Advanced Microsoft Excel

5.5 CPEComputer Software & Applications

Take your Excel skills to the next level with advanced techniques and powerful tools. Learn Index Match, advanced PivotTables, and basic macros to supercharge your productivity.

VIDEO COURSE

This course is free

Create a free account to enroll and earn CPE. No credit card required.

Create free account Already enrolled? Sign in to continue

About this course

This Advanced Microsoft Excel course is designed to help you master the most powerful tools and techniques Excel has to offer. Building on the foundations of our Excel Bootcamp, this course dives into advanced formulas, dynamic functions, and complex tools like Index Match, advanced PivotTables, and macros.

With hands-on exercises and practical examples, you’ll learn how to create efficient, professional spreadsheets that streamline your work and provide actionable insights.

What you’ll learn

Upon completion of this course, you will be able to:

How to use Index Match, the most powerful Excel formula, for dynamic data lookups.
Advanced PivotTable functions for deep data analysis.
Basics of macros to automate repetitive tasks and improve efficiency.
Essential advanced formulas, including MIN, MAX, and conditional logic.
Formatting and design techniques for clear, professional spreadsheets.
Error-proofing your spreadsheets with dynamic and scalable design principles.

Course content

7 lessons · 46 steps · 3h 12m of video

01LESSON 1Formatting & Keyboard Shortcuts10 items

02LESSON 2Working with Ranges5 items

03LESSON 3INDEX/MATCH7 items

04LESSON 4Other Advanced Formulas9 items

05LESSON 5Advanced PivotTables & PivotCharts5 items

06LESSON 6Intro to Macros & Protecting your Data8 items

07LESSON 7Conclusion1 item

Locked

Final assessment

Course access is required to take this assessment.

29 questions70% to passUnlimited attempts

On course completion: 5.5 CPE and a certificate

Course details

CPE: 5.5
Field of study: Computer Software & Applications
Course level: Not specified
Delivery method: QAS™ Self Study
Prerequisites: You should have a solid intermediate knowledge of Excel (e.g. VLOOKUP, SUMIFS, COUNTIFS, PivotTables, etc.) <strong>We also recommend taking our <a href="https://wisdify.com/bootcamps/excel-vba-macros-course/">Excel VBA Macros Bootcamp</a> which is a fantastic complement to this course. If you need a quick refresher on some of the basics, checkout our <a href="https://wisdify.com/bootcamps/online-microsoft-excel-course/">Microsoft Excel Bootcamp.</a></strong>
Advance preparation: Not specified
Course content: 7 lessons · 46 steps
Assessment: Final assessment · 29 questions · pass 70%
Completion deadline: 365 days from enrollment
Last updated: February 2018
Registration: A free Wisdify account and course enrollment are required.