Microsoft Excel Bootcamp

Current Status
Not Enrolled
Get Started


Table of Contents

Subscribe and gain instant access to ALL our courses

This is not your grandma’s Microsoft Excel course. Our CPE qualifying online Excel course will only teach you the most important Excel formulas and functions to conquer any spreadsheet or analysis.

Course objectives

Excel is the most used, yet most underutilized, business tool. Conquering Excel can put you years ahead of your peers. We’ll start by spending quite a bit of time learning keyboard shortcuts which are key to maximizing your efficiency.

After this, you’ll learn powerful functions such as IF statements, VLOOKUPs, SUMIFSConditional Formatting and other powerful tools. We finish the course by learning how to create PivotTables. We have left out all the fluff and get right to the heart of Excel.

At completion, you’ll have the tools to master pretty much any analysis in Excel!

Some key things you’ll learn:

  • Keyboard shortcuts​
  • SUMIFS and COUNTIFS formulas
  • IF, Nested IF, and VLOOKUP formulas
  • Conditional Formatting and other data tools
  • PivotTables and PivotCharts with Slicers
  • And more!

We also recommend taking our Excel VBA Macros Bootcamp which is a fantastic complement to this course.

Additional info

Format: 3-6 minute videos, quizzes, and a final exam

CPEs: 5.0

Field of study: Computer Software & App

Prerequisites: You should have a beginner knowledge of Excel (e.g. SUM, AVERAGE, Charts, etc.)

We also recommend taking our Excel VBA Macros Bootcamp after which is a great complement to this course.

Cost: If you are an accountant, please click here to access your free course.

Subscribe for full access to all courses

Course Content

Expand All