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

You have the option to purchase a subscription to this course only or to get a subscription to the Microsoft Office Bundle which includes all On Demand courses on:

Excel

Word

PowerPoint

Outlook


Subscription options

$49/month

$299/year


Click on All Courses on the top right to find this bundle!

$20/month

Excel Beyond the Basics Monthly Subscription

Learn the Powerful Bells and Whistles Excel has to Offer!

This is a subscription product billed on a monthly basis until you cancel. Cancel anytime from the account management page.
$120/year

Excel Beyond the Basics Annual Subscription

Learn the Powerful Tools Excel has to Offer!

This is a subscription product billed on a yearly basis until you cancel. Cancel anytime from the account management page.