Category: Excel

The limitation of the VLOOKUP function is that it can’t look at its left. This will appear at the left-most column of a table and return information from the right. The solution to fix the V LOOKUP not working issue is not to use VLOOKUP at all. You can use the combination of INDEX and […]

Order of operations. When evaluating a formula, Excel follows a standard math protocol called “order of operations” . In general, Excel’s order of operation follows the acronym PEMDAS ( Parentheses, Exponents, Multiplication, Division, Addition, Subtraction ) but with some customization to handle the formula syntax in a spreadsheet. One answer is, In general, Excel’s order […]

How to Add a Series of Dates in Excel Add the first date in some cell. Select that cell, right-click on the fill handle, drag it down or across several cells, and then release. In the context menu, click Series. In the Series dialog box, choose the appropriate Date unit and enter the Step value. […]

In Excel menu go to the “Help” menu and then click on “About Microsoft Excel”. (If you do not see this option in the menu you are probably using Excel 2007 or 2010 .) When you click on “About Microsoft Excel” you will see some information on your Excel version with at the top the […]

Being a Windows program, Microsoft Excel is not natively supported on Chromebooks. However, you will be pleased to know that it is possible to use Microsoft Excel on Chromebook. Although, Chromebooks come preloaded with free software for working on spreadsheets (Google Sheets), many users still prefer using Microsoft Excel. 1 Go to Google Play Store […]

Excel icon exclamation mark Excel and many other programs use icons to visualize the file extension. If you see an icon with an exclamation mark on it, you may wonder whether the file contains an error or it’s corrupted, but you don’t have to worry, it just means that this is a macro-enabled Excel file. […]

On the Excel menu, click Preferences. Under Authoring, click General .. Clear the Use R1C1 reference style check box. The column headings now show A, B, and C, instead of 1, 2, 3, and so on. The most common answer is; muliplan was very popular on CP/M systems, but on MS-DOS systems it lost fame […]

Enter a formula that contains a built-in function. Select an empty cell. Type an equal sign = and then type a function. For example, =SUM for getting the total sales. Type an opening parenthesis (.. Select the range of cells, and then type a closing parenthesis).. Press Enter to get the result. So, how to […]

Surprisingly, excel has provided with the HYPERLINK formula, where we can easily give reference to a cell to send an automatic email to the recipient (s) in Excel. The destination location may be within the existing workbook or outside the workbook. But, Excel offers the option to send emails directly from Excel itself. Suppose, you […]

You can easily check Excel version you are using by looking at the menu or the top ribbon. Open any Microsoft Excel file and look at the top left corner of the file. Depending on how the File button looks, you can easily identify the version of Excel. Another frequently asked question is “How to […]