About this Course

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

Teacher

• Tyler Tallon

  Tyler is the Finance Director at Treehouse who wields his spreadsheet super powers to help Treehouse staff and students excel at teaching and learning. He loves sports, traveling, and hanging out with family and friends.

Download videos

You need to sign up for Treehouse in order to download course videos.