Data Academy Course

Advanced Excel

About this course

This video-guided workshop is the third in a series of Excel workshops offered by Data Academy. In this course, the instructor guides attendees through the course material by showing high-quality training videos from  This course provides Data Academy’s most advanced level of Excel training.

We encourage experienced Excel users to register for this fast-paced course.

What you’ll learn in this course

This course will cover the following topics. If you would like to review the material outside of class, see the More Resources section for hyperlinks to the videos we will be using.

  • IF formulas
  • Nested formulas
  • MATCH function
  • INDEX and MATCH functions
  • OFFSET function
  • Conditional Formatting with a Pick List
  • INDIRECT function
  • Checking formulas for errors

More resources