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.

# Learn Microsoft Excel

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.

XLOOKUP is a new function for Excel that will replace VLOOKUP for most Excel users. In this lesson, we look at how XLOOKUP works and provide some practical examples of how to use it. In one function, XLOOKUP provides the same features that VLOOKUP and HLOOKUP offer separately, and is more powerful and easier to use. XLOOKUP also removes the need to use the INDEX/MATCH combination that allows you to work around some of VLOOKUP's shortcomings.

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.

This 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.

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.

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.

The WORKDAY.INTL() function extends the WORKDAY() function so that you can specify which days are weekend days when adding days to dates. This lesson shows you how to use it.

When printing in Excel 2010 for Windows, 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.

This lesson shows you how to group data in your pivot table by date. You can group by day, week, month, quarter or year. If your date fields include a time value, you can also group by seconds, minutes or hours. You'll also learn how to collapse and expand data groups in your pivot table so you can quickly see a summary of your data.

There are many scenarios where you may need to use the current date and time in your spreadsheets. You may simply need to display the current date in a spreadsheet report. Or, you may need to perform a calculation that uses the current date or time. This lesson shows you how to enter a formula into a cell in Excel that outputs the current date and/or time, and updates automatically as time passes.

This lesson shows you how to use Excel to calculate the number of days between two dates. It also shows you how to exclude weekends and holidays from the total.

This lesson introduces the LEN() function, which allows you to calculate the number of characters in a cell. This formula is useful on its own, or can be combined with other text functions such as RIGHT(), LEFT(), MID() and FIND().

This lesson explains how to use Autosum. Autosum is a powerful feature that can save you time if you need to add up cells or columns of data. It is often faster than creating a formula by hand, especially when you have a large amount of data to add up. In this lesson you'll learn how to use Autosum, and some of its limitations.

The SUMPRODUCT function allows you to multiply two arrays of numbers together (e.g. Quantity Sold and Price Per Unit) and add the results each individual calculation together. Without the SUMPRODUCT function, you'll find yourself having to create a third column in which you multiply the Quantity by Price for each row, and then find the sum of all the individual formulas. This lesson shows you how to use SUMPRODUCT to do all that with just one formula.

## Pages |

## Excel Formulas

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.

Click here to see the full list of Excel Formulas and Functions