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

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!

Course Content:

  Resources
Available in days
days after you enroll
  Lesson 1 - Review, Tips and Tricks
Available in days
days after you enroll
  Lesson 2 - Excel Tables and Conditional Formatting
Available in days
days after you enroll
  Lesson 3 Excel Functions: IF, COUNTIF, SUMIF
Available in days
days after you enroll
  Lesson 4 - More Excel Functions: VLOOKUP, ROUND, NOW
Available in days
days after you enroll
  Lesson 5 - Excel Graphs and Working with Multiple Sheets
Available in days
days after you enroll
  Lesson 6 - Excel Sorting and Filtering
Available in days
days after you enroll
  Lesson 7 - Excel Subtotals
Available in days
days after you enroll
  Lesson 8 - Excel Pivot Tables
Available in days
days after you enroll
  Lesson 9 - Named Ranges and Data Validation (Drop Down Lists)
Available in days
days after you enroll
  Lesson 10 - Review
Available in days
days after you enroll
  Wrap up
Available in days
days after you enroll

This course is closed for enrollment.