Excel Power User Tutorial - Advanced Functions, Pivot Tables, and Macros

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

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