If you want to learn Excel, this lesson covers ten important things that we think you need to know if you are going to use Excel effectively. Even if you've been using Excel for a while, check this lesson out to make sure you have the basics covered.
If you want to learn Microsoft Excel, you're in the right place. There is a lot to learn about Microsoft Excel, and not everything is in the manual. We've got a range of free online lessons on how to get the best out of Excel, starting from the basics right up to advanced subjects. We'll help you to do your job better - with the right Excel skills you could even get a raise or a better job! If you don't see what you want to learn, why not get in touch and suggest a lesson we should write.
Excel's Pivot Table feature is an incredibly powerful tool that makes it easy to tabulate and summarise data in your spreadsheets, particularly if your data changes a lot. This lesson will show you how to create a simple pivot table in Excel to summarize a set of daily sales data for a team of several sales people.
There are a variety of ways to add up the numbers found in two or more cells in Excel. This lesson shows you how to use the SUM function to add up cells, rows and columns of cells in Excel.
How to use the XLOOKUP functionThis lesson shows you how to write formulas using INDEX and MATCH to let you perform lookups that VLOOKUP can't, and which run much faster on large lookup tables than VLOOKUP. This lesson explains how INDEX and MATCH work on their own, and then shows you how to write an INDEX MATCH formula that can look left as well as right, and performs much faster than VLOOKUP on large tables.
VLOOKUP allows you to look for a specified value in a column of data inside a table, and then fetch a value from another column in the same row. An example might be where you need to find the sales for a specific salesperson from within a monthly sales report. In this lesson you'll learn how to use VLOOKUP in your spreadsheets by walking you through several simple examples. The lesson will also highlight some shortcomings of VLOOKUP, plus a solution to those shortcomings.
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's VLOOKUP function is excellent when you want to find a value in a table based on a lookup value. But if your table includes your lookup value multiple times, you'll find that VLOOKUP can't do it. This lesson shows you how to use the INDEX function (plus some other functions) to find all matching values in a list, and return a value from another column in the same row. It also looks at how to do this when you want to return all values which are a partial match (i.e. a wildcard search) to the values in your lookup table.
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.
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.
When printing in Excel, it is sometimes useful to print a set of rows (e.g. column headings) on each page in the print out. There is nothing worse than having a printout that runs to multiple pages, with the column headings only printed on the first page. This lesson shows you how to get header rows printing at the top of every page in Microsoft Excel 2011 for Mac. You will also learn how to print header columns on the left of every page in your printout.
This lesson shows you a formula to convert a month name into its corresponding number (i.e. Jan = 1, Feb =2, etc).
Entering the same formula or value into multiple cells can be time consuming and boring. Most people, if they want to enter the same formula into a row or column of data, will enter the formula in the first cell, then copy and paste it into the rest of the cells where they need the formula. This lesson shows you an even faster way to do it.
Autofilter is one of the most powerful features of Excel if you need to work with data in tabulated (table) format. It lets you treat a range of cells as a table and then filter out certain rows based on different criteria. It is very powerful if you need to "mine" data in a list and find out specific information about the data in that list. This tutorial covers how to set up a data table in Excel to use with Autofilter, and also shows you how to enable Autofilter and use it for basic filtering. This lesson is applicable for all versions of Excel (including Excel for Mac) although the visual presentation of the options may change from version to version.
This lesson shows you now to extract text from a cell in Excel. This is useful when you have a cell containing combining numbers and text, such as a part number, or several text values separated by commas. It introduces the RIGHT() and LEFT() functions, which are essential text manipulation functions in Excel.
Excel offers a number of ways to find rows that contain duplicate values. However, most of them focus on finding rows where the value in just one column is repeated. In this lesson, we look at how to use the COUNTIFS function to find rows where values in moree than one column is repeated. We then use the COUNTIFS function in combination with Excel's Conditional Formatting feature to highlight duplicate and even triplicate rows.
Do you need help with an Excel formula or function? We have lessons on a range of different Excel functions, and the list is growing all the time.