Intermediate Excel → Introducing the Course

Expand all sectionsCollapse all sections

LOOKUP Functions
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.
5
Pivot Tables
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.
4
Conditional Formatting
Another good aid when analyzing data is conditional formatting, which adds some visualization to data cells in your spreadsheets.
2
- 3.0
  Introducing Conditional Formatting
- 3.1
  Getting Fancy with Conditional Formatting
Error Checking
Checking for errors is an important step that can save you from making common mistakes.
5

ABOUT COURSES