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, INDEX, MATCH, and OFFSET functions, expedite data analysis through dynamic ranges, and create, modify, and update Pivot Tables and charts efficiently. The course covers advanced topics such as XLOOKUP, conditional formatting, charting, pivot tables, and data analytics in Excel. The teaching method includes video tutorials and practical examples. The intended audience for this course are individuals who have completed standard Excel training or are proficient in basic Excel skills.
Overview
Syllabus
Start
Excel Power User 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
Excel Power User Conclusion
Pivot Tables Introduction
Organizing Data in Tables
More Data Organization Techniques
Data Mining
Custom Sort Command and Functions
Merge Data Using XLOOKUP
Pivot Tables - Setup
Pivot Tables - Building Reports
Pivot Tables - Formats, Drilldowns, and Refreshing
Pivot Tables - Designing for Reports and Charts
Pivot Tables - Cal Fields, Items, and Grouping
Power Pivot - Turning It On
Power Pivot - Adding Data and Establishing Relationships
Power Pivot - RELATED Function and Pivot Tables
Pivot Tables Conclusion
Intro to Data Analysis Introduction
Working with Tables
Conditional Formats
Using the IF FUNCTION
Database Functions
Unique, Sort, and Filter Functions
Charts and Sparklines
Working with Pivot Tables
Intro to Data Analysis Conclusion
XLOOKUP Introduction
VLOOKUP Refresher
XLOOKUP Basics
INDEX and MATCH
XLOOKUP - Approx Match Results
XLOOKUP - Returning Multiple Values
XLOOKUP - Two Way Search
XLOOKUP Conclusion
Taught by
Learnit Training
