Learn Python with Generative AI - Self Paced Online
Build the Finance Skills That Lead to Promotions — Not Just Certificates
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
Master advanced Excel 2021 techniques in this comprehensive power user tutorial. Dive deep into data mining tools like VLOOKUP, XLOOKUP, INDEX, and MATCH functions. Explore dynamic ranges, advanced pivot tables, and conditional formatting to expedite data analysis. Learn to create sophisticated charts and harness the power of macros for automation. Designed for experienced Excel users, this tutorial will elevate your skills, enabling you to solve complex problems more efficiently and push the boundaries of Excel's capabilities.
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