Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Data Analysis for Beginners: Excel & Pivot Tables
Introduction
Introduction (4:55)
Exercise: Meet Your Classmates and Instructor
Course Resources
Introduction to Data Analysis with Excel: Working with Structured Data
Text to Columns (5:55)
External Data (10:04)
Table Features (9:58)
Tables as Named Ranges (14:09)
Exercise: Working With Structured Data in Excel
Budget Project: Structured Data (9:32)
Data Analysis with Excel: Pivot Tables
Intro to Pivot Tables (13:03)
Adding Layers to Pivot Tables (14:08)
Pivot Table Formatting and Layout (10:57)
Filtering Pivot Tables (10:03)
Slicers (11:12)
Pivot Table Math (9:44)
Exercise: Pivot Tables
Budget Project: Pivot Tables (6:28)
Where To Go From Here?
Review This Byte!
Tables as Named Ranges
This lecture is available exclusively for ZTM Academy members.
If you're already a member,
you'll need to login
.
Join ZTM To Unlock All Lectures