Intermediate Excel Course (How To)

Learn how to perform intermediate level functions in Microsoft Excel. In this course, you will learn how to use LOOKUP functions, build and modify pivot tables, use conditional formatting, find and replace data, and check for errors. Learning these tools will help you bring data to life and allow you to use Excel in a more meaningful way.

What you'll learn

• Use the LOOKUP function to look in a single row or column and find a value from the same position in a second row or column.
• Build and modify pivot tables
• Use conditional formatting
• Use find and replace
• Perform error checking

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.

Chevron 6 steps

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

Chevron 5 steps

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

Chevron 3 steps

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

Chevron 6 steps

• 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