YoVDO

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

Offered By: Learnit Training via YouTube

Tags

Data Analysis Courses Data Manipulation Courses Advanced Functions Courses Pivot Tables Courses Macros Courses VBA Courses Array Formulas Courses XLOOKUP Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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 Challenge
LinkedIn 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