Core Pivot

Purchase this course to access all lessons and start learning.

Introduction to Pivot Tables
Video Time
Save Video 1. Why pivot tables? Watched 10:00
Save Video 2. What is a pivot table? Watched 2:44
Save Video 3. How to quickly create a pivot table Watched 2:56
Save Video 4. How to refresh data in a pivot table Watched 2:41
Save Video 5. How to drill down into a pivot table Watched 2:12
Save Video 6. Pivot Table Terminology Watched 2:56
Building Pivot Tables
Video Time
Save Video 7. Why you should use a table for your pivot table Watched 3:14
Save Video 8. How to add fields to a pivot table Watched 2:25
Save Video 9. How to rearrange fields in a pivot table Watched 2:27
Save Video 10. How to access field settings in a pivot table Watched 2:05
Save Video 11. How to format numbers in a pivot table Watched 2:15
Save Video 12. How to change the math used for pivot table values Watched 2:43
Save Video 13. How to control grand totals in a pivot table Watched 1:53
Save Video 14. How to control subtotals in a pivot table Watched 3:03
Save Video 15. How to rename fields in a pivot table Watched 3:08
Save Video 16. How to add a field to a pivot table more than once Watched 2:14
Save Video 17. How to use pivot table layouts Watched 3:05
Grouping Pivot Tables
Video Time
Save Video 18. How to group a pivot table manually Watched 2:51
Save Video 19. How to group a pivot table by numbers Watched 3:08
Save Video 20. How to group a pivot table by date Watched 2:35
Save Video 21. How to collapse and expand pivot table groups Watched 2:40
Sorting Pivot Tables
Video Time
Save Video 22. How to sort a pivot table alphabetically Watched 2:55
Save Video 23. How to sort a pivot table manually Watched 2:04
Save Video 24. How to sort a pivot table by value Watched 2:55
Save Video 25. How to sort a pivot table with a custom list Watched 2:24
Filtering Pivot Tables
Video Time
Save Video 26. How to filter a pivot table globally Watched 2:41
Save Video 27. How to filter a pivot table by rows or columns Watched 2:33
Save Video 28. How to filter a pivot table by date Watched 3:04
Save Video 29. How to filter a pivot table by value Watched 2:32
Save Video 30. How to filter a pivot table to show top values Watched 1:57
Save Video 31. How to filter a pivot table with multiple filters Watched 2:36
Pivot Table slicers
Video Time
Save Video 32. How to add slicers to a pivot table Watched 3:14
Save Video 33. How to use Pivot table slicer options Watched 2:59
Save Video 34. How to use pivot table slicer styles Watched 3:17
Save Video 35. How to use a slicer with multiple pivot tables Watched 2:30
Pivot Table Calculations
Video Time
Save Video 36. How to add a calculated field to a pivot table Watched 3:04
Save Video 37. How to modify a calculated field in a pivot table Watched 2:16
Save Video 38. How to add a calculated item to a pivot table Watched 3:33
Save Video 39. How to modify a calculated item in a pivot table Watched 2:56
Pivot table styles
Video Time
Save Video 40. How to apply a pivot table style Watched 2:27
Save Video 41. How to create a new pivot table style Watched 3:15
Save Video 42. How to move a pivot table style to another file Watched 1:52
Pivot Charts
Video Time
Save Video 43. How to create a pivot chart Watched 2:28
Save Video 44. How to change the pivot chart type Watched 2:10
Save Video 45. How to work with pivot chart options Watched 3:46
Save Video 46. How to filter a pivot chart Watched 2:11
Save Video 47. How to create a second pivot chart Watched 2:15
Pivot table tips
Video Time
Save Video 48. How to make a self-contained pivot table Watched 2:44
Save Video 49. How to group a pivot table by day of week Watched 3:39
Save Video 50. How to clone a pivot table Watched 3:11
Save Video 51. How to copy a pivot table without the data Watched 2:43
Save Video 52. How to group a pivot table by age range Watched 2:47
Save Video 53. How to rank with a pivot table Watched 3:09
Save Video 54. How to add unique count to a pivot table Watched 3:27
Example Pivot Tables
Video Time
Save Video 55. Pivot Table Example - IMDB Movie data Watched 2:28
Save Video 56. Pivot Table Example - Voting results Watched 1:44
Save Video 57. Pivot Table Example - Sales by sales person Watched 2:02
Save Video 58. Pivot Table Example - Instrument readings Watched 2:32
Bonus Materials
Video Time
Save Video 59. 10 pivot table problems and easy fixes Watched 11:01