Tutorial: Structure of a Pivot Table | YouAccel

Course Content
Course Summary
Course Files
Module 1: Introduction
Introduction - 04:42
Building Blocks - 06:45
Toolbar - 17:35
Module 2: Worksheet Operations, Cells, Ranges and Tables
Worksheet Operations - 08:18
Cells & Ranges - 06:57
Tables - 06:14
Module 3: Formats & Conditional Formatting
Formats - 15:42
Conditional Formatting Part 1 - 15:08
Conditional Formatting Part 2 - 16:25
Module 4: Formulas/Functions
Formulas - 15:19
Logical Functions - 10:25
Text Functions - 16:29
Date & Time Functions - 04:24
Lookup Functions - 09:06
Math Functions - 07:08
Statistics Functions - 11:52
Module 5: Data Protection & Validation
Data Protection - 13:37
Validation - 11:40
Module 6: Charts
Introduction to Charts - 20:26
Line Charts - 08:02
Pie - 06:52
Doughnut, Bubble, Stock Charts - 11:10
Sparkline Charts - 09:25
Module 7: Pivots
Structure of a Pivot Table - 09:47
Pivot Table Calculations - 23:23
Pivot Table Options - 09:39
Module 8: Data Analysis 1
What-if Analysis - 17:54
Solver - 10:45
Module 9: Data Analysis 2
Descriptive Statistics, Ranks - 19:14
Statistical Tests and Regression - 15:59
Module 10: VBA
Basic Building Blocks Part 1 - 11:19
Basic Building Blocks Part 2 - 13:04
Basic Building Blocks Part 3 - 08:28
Conditional and Looping Constructs - 10:39
Custom Functions - 04:54
Error Handling - 14:55
Introduction to Form Controls - 10:29
Introduction to Workbook & Worksheet Events - 19:04
Creating a Userform Part 1 - 24:56
Creating a Userform Part 2 - 04:30
Module 11: Additional Resources
Locking cells for Functions - 03:22
SUM, SUMIF, SUMIFS - 04:48
Importing Data in Excel - 02:08
Custom Sort in Excel - 02:09
Conditional Formatting to highlight duplicate values - 03:17

Sign In Sign Up

Microsoft Excel - Beginner to Advanced

Enroll

Structure of a Pivot Table

2024 © YouAccel

Home
About
Privacy
Terms
Contact

Home
Inbox