Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll

Preview

Start a free Courses trial
to watch this video

Sign up for Treehouse

Wrapping Up

0:24 with Tyler Tallon

In this course we have learned how to use the VLOOKUP and HLOOKUP functions, how to build and modify pivot tables, how to use conditional formatting, and how to prevent and perform error checking. Excel is a really powerful tool and I hope you can take a few things from this course and apply them in a way that will be helpful to you.

For additional practice, please use any of the spreadsheets you downloaded for the course to practice what you learned. After you have mastered that you can explore the toolbar and try a few new tools on your own. Also, if you have not taken our Data Visualization or Spreadsheet Basic courses I highly recommend those. Thanks and good luck!

In this course, we have learned how to use the VLOOKUP and HLOOKUP functions, 0:00
how to build and modify pivot tables, how to use conditional formatting, and 0:04
how to prevent and perform error checking. 0:08
Excel is a really powerful tool. 0:11
And I hope you can take a few things from this course, and 0:14
apply them in a way that will be helpful to you. 0:16
Please check the teachers notes for 0:19
ideas on how to practice what you've just learned. 0:21

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

Sign up