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's capabilities with new problem-solving perspectives. The teaching method includes a series of tutorials covering DB Functions, XLOOKUP, VLOOKUP, INDEX, MATCH, advanced Pivot Tables, text functions, advanced conditional formats, Excel charts, introduction to macros, and macro examples. 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
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