This section will provide you with the necessary tools to create and use various Excel formulas and functions. For each formula, in the list below, I will try to provide a step-by-step breakdown of the formula into its components, followed by an example with screen shots, and a downloadable Excel spreadsheet with the example included.
Scroll down for an overview of the list of functions and formulas available on this website or select one from the drop-down menu above. Please note that this website was launched in November 2013 so please check back often for new content. Thanks for visiting.
Excel SUM Formulas:
The Excel SUM formula can be used to add together values in a single cell, multiple cells, ranges, or references. Click the SUM link for more information and some examples of how to use the SUM formula.
The Excel SUMIF formula can be used to adds together the cells in a range provided that a specified condition or criteria is met. Click the SUMIF link for more information and some examples of how to use the SUMIF formula.
Excel IF Formula:
Mastering the Excel IF formula is a key to success in using Microsoft Excel. The formula uses if, then, else logic to evaluate criteria and provide a result based on if the criteria is true or not. Click the IF link for more information and some examples of how to use the IF formula.
Excel Look-up Formulas:
The Excel VLOOKUP formula finds a value in the left most column of a table or range and returns the value from a specified cell to the right of the found value. Click the VLOOKUP link for more information and an example of how to use the VLOOKUP formula.
The Excel HLOOKUP formula finds a value in a column in the top most row if a table or range and returns the value in the specified row number for the same column. Click the HLOOKUP link for more information and to see an example of how to use the HLOOKUP formula.
The Excel MATCH formula returns the relative position of an item in a list that matches a specified value in a specified order. It’s much easier than it sounds; click the MATCH link for more information and to see an example of how to use the MATCH formula.
The Excel INDEX formula returns the value of an element in a table or an array selected by the row and column number indexes. To learn more, click the INDEX link for more information and to see an example of how to use the INDEX formula.
Understanding some of the simple Excel date functions will make your day-to-day use of Excel more efficient. Instead of typing a list of dates into your spreadsheet, try using one of the Excel date functions to calculate the dates in your Excel spreadsheet for you. Shown below are three examples of Excel date functions: TODAY, EDATE, and EOMONTH. To learn more, click the Excel Date Formula link above for more information and to see examples of how to use these formulas.
Visit the basic Excel statistical formulas page to learn how to use built in Excel functions to calculate the minimum, maximum, average, median, and mode of various sets of numbers.
Other Excel Functions:
Using Named Ranges in Excel can make it easier to identify groups of cells that contain related data. Whenever you want to perform a calculation on the cells defined in the named range, you can specify the name of the range instead of the cell references. Click the Named Range link for more information and an example of how to create a named range.