8 new features in Microsoft - AI Video Analysis

AI Commentary

Play the video to see AI commentary

Oh, finally! Automatic refresh for pivot tables is a game-changer, it's been such a pain manually updating those. This is going to save so much time for anyone working with dynamic data.
Wow, that was instant! Adding 'Microsoft' as a new client and seeing it pop up in the pivot table immediately is incredible. This feature alone makes updating much less of a chore.
Good to know about older workbooks; enabling auto-refresh manually makes sense. And seeing data disappear when deleted and reappear when undone really highlights how seamlessly it works now. This is huge.

Want more insights? Sign up to see the full conversation

Sign Up Free

Video summary will appear here after you start watching

The latest Excel updates introduce significant improvements, starting with the highly anticipated auto-refresh functionality for pivot tables [0:00]. This feature, previously a major user request, automatically updates pivot table data when the source data changes, eliminating the need for manual refreshing. For instance, adding a new client like "Microsoft" in the sales data instantly appears in the pivot table without any intervention [0:30]. This auto-refresh is enabled by default for new workbooks but can be activated for older ones through the PivotTable Analyze tab [1:00]. This enhancement is poised to be a substantial timesaver for users managing dynamic datasets.
Want to access full features?

Sign up or log in to watch the full video with AI-powered analysis

Current Section Summary

Video summary will appear here after you start watching

The latest Excel updates introduce significant improvements, starting with the highly anticipated auto-refresh functionality for pivot tables [0:00]. This feature, previously a major user request, automatically updates pivot table data when the source data changes, eliminating the need for manual refreshing. For instance, adding a new client like "Microsoft" in the sales data instantly appears in the pivot table without any intervention [0:30]. This auto-refresh is enabled by default for new workbooks but can be activated for older ones through the PivotTable Analyze tab [1:00]. This enhancement is poised to be a substantial timesaver for users managing dynamic datasets.
Want to access full features?

Sign up or log in to watch the full video with AI-powered analysis