Free Excel Bootcamp for Accountants

This is not your grandma’s Microsoft Excel course. Our free CPE 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 spend quite a bit of time learning keyboard shortcuts which are key to maximizing your efficiency. After this, you’ll learn universally key functions such as IF statements, VLOOKUPs, SUMIFS, Conditional 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

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 which is a great complement to this course.