Completed
2. 00:07 We have waited for 31 years for the PivotTable to automatically refresh when source data changes
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
PivotTables Instantly Update When Source Data Change - Just Like Formulas - Excel Magic Trick 1900
Automatically move to the next video in the Classroom when playback concludes
- 1 1. 00:00 Introduction.
- 2 2. 00:07 We have waited for 31 years for the PivotTable to automatically refresh when source data changes
- 3 3. 00:35 PivotTables Can Instantly Update Notes
- 4 4. 01:08 Example of a PivotTable that automatically updates when you change the numbers in the source data table.
- 5 5. 03:08 Example of changing record attributes product name and the PivotTable updates without a manual refresh.
- 6 6. 03:41 Example of adding new records to an Excel Table, and the PivotTable updates instantly, without a manual refresh!
- 7 7. 05:59 Group dates to create a month report, and see that the PivotTable still instantly updates
- 8 8. 06:55 Group numbers to create a frequency distribution, and when the grouping categories changes, the PivotTable still updates instantly without a manual refresh.
- 9 9. 08:05 Set the Excel Options Universal PivotTable Settings so that all PivotTables on your computer will refresh automatically.
- 10 10. 09:58 Examples of Many formulas reports that the PivotTable cannot do.
- 11 11. 10:13 Median Report GROUPBY Function
- 12 12. 10:22 Text Join Report GROUPBY Function
- 13 13. 10:33 Directly formula Inputs
- 14 14. 10:55 XLOOKUP formula input
- 15 15. 11:10 Helper Column to get formula input into the PivotTable Cache, so you can use the Auto Refresh PivotTable option
- 16 16. 11:32 How Grouping is limited in a PivotTable, but accommodating with formulas formulas win.
- 17 17. 12:10 Data for a Regression X-Y Scatter Chart can NOT come from a PivotTable. But formulas can do it. GROUPBY Function
- 18 18. 12:30 Geometric Mean Summary Report
- 19 19. 12:48 Net Present Value and Internal Rate of Return NPV, IRR and the XNPV and XIRR functions
- 20 20. 13:08 Summary
- 21 21. 13:15 Closing
