It’s time to level-up your Excel skills! This course is the next step from our Microsoft Excel Bootcamp. You will learn all the advanced functions you need to become a real Excel ninja!
Excel Ninja is a level that can open career doors, make you more productive, and generally make your life easier. This course is guaranteed to put you ahead of your co-workers and friends. In this Advanced Excel Course, we’ll spend time taking your keyboard shortcuts to the next level to make you super productive (get rid of that mouse!). After that, you’ll learn advanced functions that are needed for real analysis in excel…. things like: INDEX/MATCH, MAX, MIN, and some other real powerful tools for analysis.
To wrap up we will get into advanced PivotTable functionality and get you started with Macros. As with all our courses, we focus on REAL WORLD skills that can help you in your job today. When you finish this course, you will have the tools needed for any analysis!
Some key things you’ll learn:
- Keyboard shortcuts
- Named Ranges
- Advanced Keyboard shortcuts for real productivity
- How to work with Named Ranges
- Advanced reference formulas
- Next level PivotTable skills
- How to get started with Macros
- And much 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
Format: 3-6 minute videos, quizzes, and a final exam
Category: Financial Tools & Software
Prerequisites: You should have a good working knowledge of Excel (e.g. how to do VLOOKUP, SUMIFS, COUNTIFS, PivotTables) If you need a quick refresher on some of the basics, checkout our Microsoft Excel Bootcamp.