Victor Momoh | Microsoft Excel Enthusiast | MOS

This is a video response to a challenge by ExcelBI on LinkedIn to split data and stack them all up. The REDUCE function is at the heart of this solution and many other solutions that involve iterations/loops. Watch, learn, and share youtu.be/z-L_pX1usRs?si…

This is a video showing an interesting use case of TEXTSPLIT and REGEXEXTRACT for extracting data between delimiters youtu.be/90wY2gUY_6Y?si… @Crisp_EXCEL @ObboatB

This is a simple tip to sort columns alphabetically (by column names) in Power query youtube.com/shorts/M16PdX5…

@excelwizardd Thanks for the feedback

@VicmoExcel Brilliant tip! Combining REGEX with XLOOKUP for case-sensitive lookups is genius - way cleaner than using EXACT. Thanks for sharing this! 👏 @excelwizardd

This video demonstrates a nifty way to perform a case-sensitive lookup by leveraging the REGEX option in the match mode of XLOOKUP. It helps to avoid using the exact function. You will like this one youtube.com/shorts/YU8J13P…

techcommunity.microsoft.com/blog/microsoft… #Microsoft #Microsoft365 #Excel365

Life is good when you know the right regular expression (regex) pattern to get the job done. When you need to extract digits, and you don't know how many, a "\d+" in regex handles this easily. So, check this example out and add to your bag of tricks youtube.com/shorts/YP3BEmp…

Happy New Year to you all. Since I have been sharing a tip every day this week and today is just a Thursday, I would pretend it is not a new year and share the tip all the same 😀This short demonstrates 2 quick ways to add a second series to a chart youtube.com/shorts/8Y5dJM9…

This video demonstrates how to FIND dates in Excel using the Find (CTRL+F) dialog. You will think it is easy until you try, and it does not work. youtube.com/shorts/3NbQobg…

Here is an interesting way to use the TEXT function as an IF function to format based on conditions. This is quite cool if you know how it works youtube.com/shorts/7aQvAfT… @david_akomolafe @AhmedOyelowo

Context is everything. Sometimes, a static solution is all you need; dynamic formulas may not be necessary. In this video, I demonstrate how to split a text string based on a delimiter for a static (one-time) solution. youtube.com/shorts/nJi-C4J…

Let's keep the examples simple since it is Christmas. In this video, I demonstrate how to dynamically stack multiple columns into one, ignore blank cells, and sort the data. Merry Christmas youtube.com/shorts/5fnRfy9…

This short simply demonstrates the use of multiple delimiters in the TEXTSPLIT function. It can drastically reduce how much function nesting you do if you know this trick youtube.com/shorts/KYeNH0q…

Have you ever used the REPT function in Excel? Here is an interesting use case for in-cell visuals youtube.com/shorts/CqDhvJl…

Have you ever used the REPT function in Excel? Here is an interesting use case for in-cell visuals youtube.com/shorts/CqDhvJl…

This week will be for some classic Excel tips and tricks. In this example, I show how to replace all tildes (~) with nothing. it is simple, but only for those who know youtube.com/shorts/2dQOh01…

When a blank cell is returned as Zero in a formula context, what do you do to make it appear blank? See different approaches and where they fall short. And of course, what works youtu.be/HPmV-VsDBw0?si…

Many know how to use AutoSum in Excel, but I love to remind you of things you know and add some nuances to it. You may just learn something new, so over to you youtube.com/shorts/zCN93ba… @AhmedOyelowo @tundetoday @david_akomolafe @ObboatB

It's a 2 in 1 Excel challenge. Fill out the blanks for a column and then execute a GROUPBY using that same column to produce the required results @AhmedOyelowo @tundetoday youtu.be/g7XqDbAIDdU?si…

Just a quick demonstration of using a column in GROUPBY that does not exist in the source data but is rather derived from another column youtube.com/shorts/7KNEwZJ… Watch, like, and subscribe