LIVE WEBINAR

Starting November 5, 2020

10:00 AM Mountain time



This live ten hour course is offered once a week through Zoom!

Also included is:

  • Ten Interactive Live Lessons via Zoom
  • Course Manual
  • Quick Reference Sheet
  • Recordings of Video Lessons for Future Reference
  • Homework Assignments
  • Video Recordings of Homework Exercises for you to Check your Answers
  • Access to Practice Files (Lifetime) and Recordings (Three Months from last class)

You can even access the equivalent online course and watch the whole course if you can't make any of the live sessions! Or do a combination!


In this course, we will dive into some powerful features of Excel so you can analyze your data and make it dance for you!

We will work with some intermediate functions such as:

  • VLOOKUP
  • IF
  • Pivot Tables
  • Filtering
  • Subtotaling
  • Tables
  • Many more

You won't believe the reporting you will produce after this course!

You should be comfortable creating formulas and understand absolute references. The Excel Level 1 course will do that for you if needed!

This is a 10 week live course, complete with homework assignments!

$199

Excel Beyond the Basics - Live Webinar

Course Content:

  Resources
Available in days
days after you enroll
  Lesson 1 - Review, Tips and Tricks (Nov 5, 2020)
Available in days
days after you enroll
  Lesson 2 - Excel Tables and Conditional Formatting (Nov 12, 2020)
Available in days
days after you enroll
  Lesson 3 Excel Functions: IF, COUNTIF, SUMIF (Nov 19, 2020)
Available in days
days after you enroll
  Lesson 4 - More Excel Functions: VLOOKUP, ROUND, NOW (Nov 26, 2020)
Available in days
days after you enroll
  Lesson 5 - Excel Graphs/Working with Multiple Sheets (Jan 7, 2021)
Available in days
days after you enroll
  Lesson 6 - Excel Sorting and Filtering (Jan 14, 2021)
Available in days
days after you enroll
  Lesson 7 - Excel Subtotals (Jan 21, 2021)
Available in days
days after you enroll
  Lesson 8 - Excel Pivot Tables (Jan 28, 2021)
Available in days
days after you enroll
  Lesson 9 - Named Ranges and Drop Down Lists (Feb 4, 2021)
Available in days
days after you enroll
  Lesson 10 - Review (Feb 11, 2021)
Available in days
days after you enroll
  Wrap up
Available in days
days after you enroll