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.

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.

If you have a range of cells, of which some contain values and some are blank, and you want to select just the blank cells, there is a quick way to select those blank cells that doesn't involve manually clicking on every one.

1 comment

This Pivot Table lesson shows you how to use the Pivot Table Field Layout to quickly change the layout of your pivot table. This allows you to try different pivot table layouts so you can be sure your data is being grouped, aggegated and displayed in the most useful way possible. It also allow you to generate multiple reports from the same underlying data without having to create multiple pivot tables.

2 comments

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