MS Excel Toronto Meetup - Exploring Excel's new text and Array Functions + LET - Victor Momoh
Learn how to AUTOMATE YOUR EXCEL REPORTS in minutes instead of hours without copy-paste or coding: https://snapreportschamp.com/course
Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists:
https://solveandexcel.ca/dynamic-depe...
_______________________________________________________________________
Session recorded live on December 7, 2022
With the new array and text functions coming to all Excel 365 users, it would be a good time to explore them. In this session, we consider some of the 14 new array and Text functions and how to creatively use them to solve our daily problems. The formulas can get very complex quickly, so we show how the LET function helps to simplify the look and feel and improve readability. Don’t be shocked if Lambdas spring out of nowhere, it is still Excel
---------------------
About the Speaker: Victor Momoh
Victor Momoh is a petroleum Engineer by practice, a Microsoft Most Valuable Professional and a certified Microsoft Excel Expert with years of experience in training in Excel and Visual Basic for Applications (VBA). Victor's passion for knowledge sharing and teaching stems from having teaching parents. He, alongside some MVPs, runs the Nigerian Excel Users group (NEU), a group on Telegram for enthusiasts of Microsoft Excel. When he is not solving Excel problems, he can be found playing the drums or listening to music
--------------
Find more about Victor's work and connect with him:
LinkedIn: linkedin.com/in/victor-momoh-mvp-mos-2186974b
Twitter: @VicmoExcel
Youtube: @ExcelMoments
Timestamps
00:00:00 - Celia Alves MS Excel Toronto news and upcoming events
00:02:53 - Celia Introduces Victor Momoh
00:04:25 - Victor introduces himself and his presentation
00:08:25 - TEXTSPLIT function – summary and examples - including converting to numbers
00:16:00 - TEXTSPLIT with: line feed character as delimiter, multiple delimiters, multiple rows and columns
00:22:05 - TEXTBEFORE TEXTAFTER summary and examples
00:29:30 - Get file name and get sheet name, SORTBY last name, Extract by case transition (lowercase to upper case)
00:43:40 - WRAPROWS WRAPCOLS summary and examples, Dates into Quarters, Single column to multiple columns, Breakout rooms (split list into random groups)
00:52:48 - TAKE DROP CHOOSECOLS summary and examples
00:58:35 – Dynamic Chart using TAKE XMATCH, TOCOL
01:06:40 – VSTACK HSTACK CHOOSECOLLS, consolidate multiple tables based on a list with LET, VSTACK with VLOOKUP
01:13:15 – IMAGE with FILTER CHOOSECOLS to Dynamically display images, SCAN LAMBDA REDUCE INDIRECT EXPAND examples
01:30:00 – Questions, Discussions & Wrap up