Excel offers over 300 functions and formulas to help you get more out of your spreadsheets. This page contains a summary of the functions that are covered by lessons on this site. It's being added to all the time, so check back often!
If you're getting started with Excel, creating formulas is one of the first things you should learn. In this lesson you'll learn how to create simple formulas and calculations in Excel.
Sometimes you'll find yourself working with dates in an Excel spreadsheet that have been pasted or imported into Excel from another datasource. When that happens, Excel can treat those dates as text - in other words, they look like dates but don't behave like dates. For example you can't sort by date properly. This lesson looks at several ways you can convert a date which Excel is treating as text into a proper date value in Excel.
The SUMPRODUCT function is perfect if you have two or more columns of data (e.g. Quantity Sold and Price Per Unit) and you want to find the total value of the columns multiplied together. Without the SUMPRODUCT function, you'll find yourself having to create a third column that contains a formula that multiplies each row together, and then using SUM to add up the values in the third column. This lesson shows you how to use SUMPRODUCT to do all that with just one formula.
COUNTBLANK allows you to count the number of empty or blank cells in a range in Excel. This lesson shows you how to use COUNTBLANK, and also shares a couple of things to watch out for when you use COUNTBLANK in an Excel formula.
The SUMIF function allows you to add up the values in a range of cells in Excel that meet a certain criteria. However, in some cases the SUMIF function isn't quite enough, and you need the SUMIFS function instead. This lesson explains how to use SUMIFS.
The SUM function in Excel allows you to add up the values in a range of cells. However, sometimes you only want to add up the cells that meet certain criteria. That's where the SUMIF function comes in handy, along with the more capable SUMIFS function.
Excel offers a couple of handy functions that you can use to calculate the smallest and largest values in a range of cells. They are simple functions that go by the names of MIN() and MAX(). This lesson shows you how to use them. It also introduces SMALL() and LARGE(), functions which duplicate what MIN and MAX do, plus more besides.
The IF() function in Excel allows you to evaluate a situation which has two possible outcomes (e.g. sales are greater than $1000) and calculate a different value for each outcome. However, sometimes you need to work with situations where there are more than two possible outcomes. That's where multiple, or nested, IF functions come in handy. In this tutorial we'll cover how to use nested IF functions to calculate sales commission for a team of sales people, given a range of different commission rates.
The IF statement is a simple function in Excel that is one of the building blocks you need when you are working with large spreadsheets. You may not know you need it yet, but once you know how to use it, you won't want to live without it.
VLOOKUP is one of the most useful functions in Excel. In fact, the world can be separated into two groups of people - those who know how wonderful VLOOKUP is, and those who haven't discovered it yet. This VLOOKUP tutorial will help you join the ranks of the enlightened.
