Excel 2021 Power User Full Course
Offered By: Learnit Training via YouTube
Course Description
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
Related Courses
Excel 2010Miríadax Excel Avanzado
Miríadax Problem Solving with Excel
PwC via Coursera Excel: gestión de datos
Universitat Politècnica de València via edX Excel によるデータの分析と可視化
Microsoft via edX