5 Advanced Excel Formulas You - AI Video Analysis

AI Commentary

Play the video to see AI commentary

Oh, starting with the basics to build up to the advanced stuff. That's a smart approach to get everyone on the same page. I'm curious to see what they consider 'advanced' compared to what I already use.
TEXTSPLIT, huh? I haven't seen that one before, which is always exciting. A new function could really change how I handle some data cleaning tasks. It sounds like it's designed for exactly that kind of name separation problem.
Demonstrating it with first and last names makes it immediately relatable. That's a common pain point, so if TEXTSPLIT solves it cleanly, that's a huge win for efficiency. I can already think of a few places this would be useful.

Want more insights? Sign up to see the full conversation

Sign Up Free

Video summary will appear here after you start watching

The video begins by acknowledging common Excel formula knowledge like SUM and IF [0:00], then immediately introduces five advanced functions. The first function discussed, TEXTSPLIT, is highlighted as a new addition to Excel [0:10]. This function is demonstrated with an example of separating full names into first and last names, showcasing its ability to divide text based on delimiters [0:20]. The speaker emphasizes that this function can be a significant time-saver for data organization [0:35].
Want to access full features?

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

Sign Up Free Log In

Current Section Summary

Video summary will appear here after you start watching

The video begins by acknowledging common Excel formula knowledge like SUM and IF [0:00], then immediately introduces five advanced functions. The first function discussed, TEXTSPLIT, is highlighted as a new addition to Excel [0:10]. This function is demonstrated with an example of separating full names into first and last names, showcasing its ability to divide text based on delimiters [0:20]. The speaker emphasizes that this function can be a significant time-saver for data organization [0:35].
Want to access full features?

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

Sign Up Free Log In