Completed
13. 10:33 Directly formula Inputs
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
