8 Awesome New Excel Formulas - AI Video Analysis

AI Commentary

Play the video to see AI commentary

Ooh, eight new Excel features! I'm always looking for ways to speed things up, so this is already sounding promising. Starting with `VSTACK` to combine tables is a great first move; that's a common task I run into.
Ah, so `VSTACK` is essentially a super-powered copy-paste for entire tables, but cleaner. Seeing it combine the San Francisco and LA inventory lists makes it really clear how much time this could save on data aggregation. This is going to be useful.
Now they're introducing `HSTACK` as the horizontal version of `VSTACK`. That makes total sense – stacking data vertically and then horizontally covers so many data consolidation scenarios. I can already picture using this for different datasets.

Want more insights? Sign up to see the full conversation

Sign Up Free

Video summary will appear here after you start watching

The video introduces eight new Excel features, starting with the `VSTACK` formula [0:00-0:25]. This function is designed to consolidate data from multiple tables into a single, unified table. An example demonstrates how `VSTACK` can be used to combine inventory lists from two different locations, San Francisco and Los Angeles, into a comprehensive total inventory view, simplifying data aggregation.
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 video introduces eight new Excel features, starting with the `VSTACK` formula [0:00-0:25]. This function is designed to consolidate data from multiple tables into a single, unified table. An example demonstrates how `VSTACK` can be used to combine inventory lists from two different locations, San Francisco and Los Angeles, into a comprehensive total inventory view, simplifying data aggregation.
Want to access full features?

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