Microsoft Excel Bootcamp

This is not a “cookie cutter” university Microsoft Excel course. Our  online Excel training will teach you the most critical formulas and functions in Microsoft Excel to give you the skills to take on any spreadsheet or analysis.


Course Objectives

Microsoft Excel is a cornerstone of finance and accounting.  FP&A and Accounting employees use excel for many hours a day, yet most people are completely underutilizing this great tool.  If you master you can save a lot of time and frustration, as well as differentiate yourself from your peers.  In this course we will spend a lot of time learning keyboard shortcuts which are key to maximizing your efficiency.

After we get through keyboard shortcuts, we will move on to powerful functions like IF statements, VLOOKUPs, SUMIFSConditional Formatting and some other powerful formulas and tricks. We finish the course by learning how to create PivotTables. We have left out all the unimportant details and get right to the heart of Microsoft Excel.  This will be the best Excel course you have taken!

Some key things you’ll learn:

  • How to stop relying on the mouse and master keyboard shortcuts​
  • How to do IF, Nested IF, and VLOOKUP formulas
  • Apply Conditional Formatting and other data tools
  • PivotTables and PivotCharts with Slicers
  • And more more!

Additional Info

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

Estimated Time: 4 hours

Field of study: Financial Tools & Software

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

Enroll in Microsoft Excel Bootcamp now

Course Content

Expand All