If you use Excel, but don't know how to use Pivot Tables, you're missing out...wasting time trying to do things that a Pivot Table can do for you automatically. Core Pivot is a step-by-step Excel video course that will teach you everything you need to know to use this very powerful tool. With a small investment, Pivot Tables will pay you back again and again.
|1. Why pivot tables?||10:00|
|2. What is a pivot table?||2:44|
|3. How to quickly create a pivot table||2:56|
|4. How to refresh data in a pivot table||2:41|
|5. How to drill down into a pivot table||2:12|
|6. Pivot Table Terminology||2:56|
|7. Why you should use a table for your pivot table||3:14|
|8. How to add fields to a pivot table||2:25|
|9. How to rearrange fields in a pivot table||2:27|
|10. How to access field settings in a pivot table||2:05|
|11. How to format numbers in a pivot table||2:15|
|12. How to change the math used for pivot table values||2:43|
|13. How to control grand totals in a pivot table||1:53|
|14. How to control subtotals in a pivot table||3:03|
|15. How to rename fields in a pivot table||3:08|
|16. How to add a field to a pivot table more than once||2:14|
|17. How to use pivot table layouts||3:05|
|18. How to group a pivot table manually||2:51|
|19. How to group a pivot table by numbers||3:08|
|20. How to group a pivot table by date||2:35|
|21. How to collapse and expand pivot table groups||2:40|
|22. How to sort a pivot table alphabetically||2:55|
|23. How to sort a pivot table manually||2:04|
|24. How to sort a pivot table by value||2:55|
|25. How to sort a pivot table with a custom list||2:24|
|26. How to filter a pivot table globally||2:41|
|27. How to filter a pivot table by rows or columns||2:33|
|28. How to filter a pivot table by date||3:04|
|29. How to filter a pivot table by value||2:32|
|30. How to filter a pivot table to show top values||1:57|
|31. How to filter a pivot table with multiple filters||2:36|
|32. How to add slicers to a pivot table||3:14|
|33. How to use Pivot table slicer options||2:59|
|34. How to use pivot table slicer styles||3:17|
|35. How to use a slicer with multiple pivot tables||2:30|
|36. How to add a calculated field to a pivot table||3:04|
|37. How to modify a calculated field in a pivot table||2:16|
|38. How to add a calculated item to a pivot table||3:33|
|39. How to modify a calculated item in a pivot table||2:56|
|40. How to apply a pivot table style||2:27|
|41. How to create a new pivot table style||3:15|
|42. How to move a pivot table style to another file||1:52|
|43. How to create a pivot chart||2:28|
|44. How to change the pivot chart type||2:10|
|45. How to work with pivot chart options||3:46|
|46. How to filter a pivot chart||2:11|
|47. How to create a second pivot chart||2:15|
|48. How to make a self-contained pivot table||2:44|
|49. How to group a pivot table by day of week||3:39|
|50. How to clone a pivot table||3:11|
|51. How to copy a pivot table without the data||2:43|
|52. How to group a pivot table by age range||2:47|
|53. How to rank with a pivot table||3:09|
|54. How to add unique count to a pivot table||3:27|
|55. Pivot Table Example - IMDB Movie data||2:28|
|56. Pivot Table Example - Voting results||1:44|
|57. Pivot Table Example - Sales by sales person||2:02|
|58. Pivot Table Example - Instrument readings||2:32|
|59. 10 pivot table problems and easy fixes||11:01|
Many Excel experts believe that pivot tables are the single most powerful tool in Excel. According to Bill Jelen (a.k.a. Mr. Excel): "No other tool in Excel gives you the flexibility and analytical power of a pivot table".
The short answer: No other tool in Excel gives you the flexibility and analytical power of a pivot table.
Without any formulas at all, Pivot Tables let you quickly analyze data that contains hundreds, thousands, or even hundreds of thousands of rows.
Yes. There are some small differences in the Mac and Win interface with respect to formulas, but in general this is one area in Excel where there is very good overlap between the Mac and Windows versions. The videos were recorded in Excel 2010 on Windows 7. All videos highlight shortcuts for both Windows and Mac.
Of course! If you aren't happy with the course, just let us know within 30 days and we'll give you a full refund. We're always interested in your feedback (so we can make the course better), but this a no-quibble guarantee. We want you to be completely happy.
When you purchase the course, an account will be created for you automatically on the Exceljet website. You'll receive an email immediately with a link to login, and when you do log in, you'll have full access to all videos and practice worksheets for the course(s) you purchased.
We think people learn quickly and effectively with a no-nonsense approach that is quick, clean, and to the point.
In other words: less is more. Excel brings plenty of complexity to the table already :)
If you're not completely satisfied, let us know within 30 days for a full refund. We want you to be 100% satisfied.