Learn AI, Data Science & Business — Earn Certificates That Get You Hired
Learn Backend Development Part-Time, Online
Overview
Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This advanced Excel course teaches users to combine functions and features for faster data analysis, including XLOOKUP, INDEX/MATCH array formulas, advanced PivotTables, conditional formatting, charts, and introductory VBA macros. It assumes proficiency with foundational Excel skills.
Syllabus
Start
Introduction
DB Functions, XLOOKUP, VLOOKUP, INDEX, MATCH
Excel XLOOKUP Two-Way Search
Text Functions
Advanced Pivot Tables
INDEX MATCH Array Function
Advanced Conditional Formats
Excel Charts
Introduction to Macros
Macro Examples
Conclusion
Taught by
Learnit Training