Learn Generative AI, Prompt Engineering, and LLMs for Free
The Most Addictive Python and SQL Courses
Overview
Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
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