Excel Power User Tutorial - Advanced Functions, Pivot Tables, and Macros
Offered By: Learnit Training via YouTube
Course Description
Overview
Master advanced Excel techniques in this comprehensive 2.5-hour tutorial designed for power users. Dive deep into complex functions like nested IF statements, XLOOKUP, and array formulas. Learn to leverage Pivot Tables with calculated fields, slicers, and timelines for dynamic data analysis. Explore advanced conditional formatting, combo charts, and macro creation using VBA. Develop efficient problem-solving skills by combining various Excel tools to tackle time-intensive tasks. Enhance your data manipulation abilities, create sophisticated reports, and automate workflows to become a true Excel power user.
Syllabus
Start
Introduction
IF Function Basics
IF Functions with Calculations
Nesting AND with IF
Naming Ranges and COUNTIF
SUMIF and AVERAGEIF
SUMIFS
XLOOKUP
Populating Forms with XLOOKUP
Displaying Pivot Table Fields with COUNT Function
Calculated Fields
Slicers
Using the Timeline
Inserting Report Filter Pages
Flash Fill for Text Functions
Introduction to Advanced Conditional Formatting and Macros
Array Formula Basics
Looking Up Multiple Values with XLOOKUP
Array Functions
Advanced Conditional Formatting
Combo Charts
Developer Tab
Macro Basics
Relative Reference Macros
VBA Basics
Cleaning Up Macros
Conclusion
Taught by
Learnit Training
Related Courses
Excel Weekly ChallengeLinkedIn Learning Excel: Lookup Functions in Depth
LinkedIn Learning Excel: Tracking Data Easily and Efficiently
LinkedIn Learning Managing and Analyzing Data in Excel (Office 365/Excel 2019)
LinkedIn Learning Excel Power User Challenge
LinkedIn Learning