Free webinar: Modern Excel Functions
Since 2019, Microsoft has been rolling out an incredible set of new, powerful, and dynamic functions that solve so many of the old problems people have had! In this webinar, we go on a whirlwind tour of some of the most useful ones.
Included in the webinar are:
- XLOOKUP
- UNIQUE
- FILTER
- VSTACK
- TOCOL
- TOROW
- WRAPCOLS
- WRAPROWS
- TAKE
- DROP
- TEXTSPLIT
- TEXTBEFORE
- TEXTAFTER
- LET
- LAMBDA
You can download the finished workbook here:
Related everyday office posts
Building a Color-Coded Calendar Grid in Excel
People are always badmouthing Excel and working in various new and powerful data visualization tools. In this video, we duplicate...
Going Text to ROWS with Power Query
Text to Columns is a common tool in Excel (although the Text to Columns feature in Power Query, called Split...
Related recources
A Beginner’s Guide to Power Query
Power Query is Excel's new ETL tool - whether you’re talking about Excel or Power BI, when you extract, transform, and load the data into a report, you’re doing it with Power Query.