Microsoft Excel - Advanced Course

Our Advanced course builds on the skills you've already mastered in our Beginner and Intermediate courses. You’ll start with conditional functions like IFS, COUNTIFS, and SUMIFS, then move on to working with Date and Time values and advanced lookup formulas like INDEX, MATCH, and XLOOKUP. From there, you’ll be introduced to Dynamic Arrays, learn how to audit formulas, protect your work, and finish with an introduction to automation using macros. This course equips you to tackle almost any advanced task and prepares you for a smooth transition into our Power Query, Power Pivot, and Power BI courses on your way to becoming a Microsoft Excel power user.