Overview
This course is designed for advanced Excel users looking to enhance their skills beyond typical Excel tools and processes. Participants will learn to intermix tools in Excel to accomplish time-intensive tasks, develop a deeper understanding of data mining tools like VLOOKUP, and explore advanced solutions like the INDEX, MATCH, and OFFSET functions. The course focuses on expediting data analysis through dynamic ranges and pushing Excel to its limits with new problem-solving perspectives. The teaching method includes video tutorials covering various topics such as DB functions, XLOOKUP, advanced pivot tables, Excel charts, macros, and more. The intended audience for this course are individuals who have completed Excel Beginner, Intermediate, and Advanced training, or are proficient in the skills covered in those courses.
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