Excel 2021 Power User Tutorial
Offered By: Learnit Training via YouTube
Course Description
Overview
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
Related Courses
Social Network AnalysisUniversity of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX