Intermediate Excel Course (How To)

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.

• Introducing the Course

  1:04

• Introducing Lookup Functions

  1:37

• Using VLOOKUP to Search in a Column

  6:30

• Using HLOOKUP to Search in a Row

  1:01

• LOOKUP Tips and Common Errors

  1:19

• LOOKUP Functions Quiz

  5 questions

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.

• Introducing Pivot Tables

  2:01

• Building a Pivot Table

  2:42

• Finishing the Pivot Table

  2:43

• Other Pivot Table Tips and Tricks

  2:52

• Pivot Table Quiz

  5 questions

Conditional Formatting

Another good aid when analyzing data is conditional formatting, which adds some visualization to data cells in your spreadsheets.

• Introducing Conditional Formatting

  4:30

• Getting Fancy with Conditional Formatting

  4:33

• Conditional Formatting Quiz

  4 questions

Error Checking

Checking for errors is an important step that can save you from making common mistakes.

• Why Error Checking Is Important

  3:04

• Common Errors

  3:30

• Prevent Errors Using Data Validation

  3:52

• How To Check For Errors

  6:57

• Wrapping Up

  0:24

• Error Checking Quiz

  5 questions