Excel PivotTables Part 1: PivotTables 101
Chris Dutton, Founder, Excel Maven
-
-
1. Class Materials and Outline
3:26 -
2. Getting to Know the IMBD Dataset
2:21 -
3. Setting Expectations
1:14 -
4. Why Pivot Tables?
4:10 -
5. Structuring Your Source Data
2:00 -
6. Inserting Your First Pivot Table
3:13 -
7. Navigating the Field List
7:43 -
8. Pivot Table Options: Analyze and Design
1:33 -
9. Selecting, Clearing, Moving & Copying Pivots
5:14 -
10. Refreshing & Updating Pivots
7:30 -
11. PRO TIP: Dealing with Growing Source Data
6:49 -
12. How Pivot Tables Actually Work
3:39 -
13. Number Formatting
2:12 -
14. PRO TIP: Automatically Formatting Empty Cells
1:41 -
15. Table Layouts & Styles
5:30 -
16. PRO TIP: Using Tabular Tables to Create New Source Data
2:20 -
17. Customizing Headers & Labels
1:16 -
18. Conditional Formatting
6:51 -
19. PRO TIP: Data Bars with Invisible Text
2:13 -
20. Sorting Options
5:01 -
21. PRO TIP: Why is my Alphabetical Sorting Wrong?
2:01 -
22. Label Filters & Manual Selections
8:15 -
23. PRO TIP: Using Label Filters with Wildcards
3:15 -
24. Value Filters
3:10 -
25. PRO Tip: Enabling Multiple Filters
2:42 -
26. Grouping Data
3:23 -
27. PRO TIP: Automatic Date Grouping
4:25 -
28. Using Slicers & Timelines to Filter Data
4:51 -
29. Breaking Out Report Filter Pages
4:13 -
30. "Summarize Values By" Options
4:45 -
31. PRO TIP: Avoiding the "Count Of" Trap
3:49 -
32. "Show Value As" Calculations
3:35 -
33. Show Values As: % of Column/Row
3:47 -
34. Show Values As: % of Parent
3:02 -
35. Show Values As: Difference From
4:42 -
36. Show Values As: Running Total
2:44 -
37. Show Values As: Rank
2:36 -
38. Show Values As: Index
8:06 -
39. Inserting Calculated Fields
6:30 -
40. Calculations in Pivots vs. Raw Data
4:32 -
41. PRO TIP: Calculating Using Counts
7:20 -
42. PRO TIP: Calculating Using Counts (part 2)
4:19 -
43. Inserting a Calculated Item (not recommended!)
6:11 -
44. The Solve Order & List Formulas Tools
4:54
-
