Intermediate Excel → Building a Pivot Table

Expand all sectionsCollapse all sections

LOOKUP Functions
5 Items
In this stage, you'll learn about lookup functions in Microsoft Excel. We'll specifically take a look at the VLOOKUP function and learn why and when to use this function and also show you how to use it.
Pivot Tables
4 Items
In this stage, you'll learn about pivot tables and when and how to use them. We'll see how pivot tables can be a great asset and an efficient way to analyze large sets of data.
Conditional Formatting
2 Items
Another good aid when analyzing data is conditional formatting, which adds some visualization to data cells in your spreadsheets.
- 3.0
  Introducing Conditional Formatting
- 3.1
  Getting Fancy with Conditional Formatting
Error Checking
5 Items
Checking for errors is an important step that can save you from making common mistakes.

ABOUT COURSES