Advanced Excel for Accountants

Get ready to take your Excel skills to a whole new level! This course builds on our Microsoft Excel Bootcamp and teaches you all the advanced functions you need to dominate any spreadsheet.

Course objectives

Becoming an Excel Wizard is guaranteed to put you ahead of your peers. In this course, we’ll spend quite a bit of time learning keyboard shortcuts to maximize your efficiency in Excel. After this, you’ll learn advanced functions such as INDEX/MATCH, MAX, MIN, and other powerful analysis tools. We finish by learning advanced PivotTable functionalities and Macros. As with all our courses, we’ve left out all the fluff and get right to the heart of Excel. At completion, you’ll have the tools to conquer any analysis, regardless of your industry or role.

Some key things you’ll learn:

  • Keyboard shortcuts​
  • Named Ranges
  • Advanced reference formulas
  • Advanced PivotTable
  • Intro to Macros
  • And more!

We also recommend taking our Excel VBA Macros Bootcamp which is a fantastic complement to this course. Or if you need a quick refresher on some of the basics, checkout our Microsoft Excel Bootcamp

Additional info

CPEs: 5.5

Field of study: Computer Software & App

Prerequisites: You should have a solid intermediate knowledge of Excel (e.g. VLOOKUP, SUMIFS, COUNTIFS, PivotTables, etc.) We also recommend taking our Excel VBA Macros Bootcamp which is a fantastic complement to this course. If you need a quick refresher on some of the basics, checkout our Microsoft Excel Bootcamp.