Victor Momoh | Microsoft Excel Enthusiast | MOS

Certified Microsoft Excel Expert | Microsoft Excel MVP ||Youtube Channel: |Watch out for Excel Tips and Tricks

[Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel]

One more shortcut to your bag of shortcuts! #Excel #ExcelTips @msexcel @david_akomolafe

[Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel]

Do you know how to format time or time difference above 24 hours in Excel? It's simple, but nuanced. Watch this video to learn more about this #TikTok #Excel https://t.co/GLM7tJE1Xd

[Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel]

Some of us still use shortcuts in Excel, everything isn't CoPilot 😁 This is an "old" (recording date) video that I had not posted on CTRL A-Z in Excel for beginners to pick up on what those shortcuts do and how they could be useful time-savers https://t.co/GOy93gDruY

[Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel]

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 https://t.co/dvIKiX0VfM

[Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel]

This is a video showing an interesting use case of TEXTSPLIT and REGEXEXTRACT for extracting data between delimiters

https://t.co/OTcNsdlCkR @Crisp_EXCEL @ObboatB

[Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel]

This is a simple tip to sort columns alphabetically (by column names) in Power query

https://t.co/RNUMb8Pp3J

[Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel]

@excelwizardd Thanks for the feedback

[Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel]

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
https://t.co/FCuQ3LWDAp

[Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel]

https://t.co/fTR7AYzBLX
#Microsoft #Microsoft365 #Excel365

[Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel]

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
https://t.co/7vU4kSZtXL

[Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel]

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
https://t.co/XAKrLOOFWP

[Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel]

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.
https://t.co/hKh19E0l0p

[Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel]

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

https://t.co/6BXC4FJbgo
@david_akomolafe @AhmedOyelowo

[Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel]

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.
https://t.co/lZnbWfdjDC

[Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel]

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
https://t.co/zpOzlvRs1C

[Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel]

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
https://t.co/xMAcJJyEgE

[Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel]

Have you ever used the REPT function in Excel? Here is an interesting use case for in-cell visuals

https://t.co/HCggVKfx7S

[Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel]

Have you ever used the REPT function in Excel? Here is an interesting use case for in-cell visuals
https://t.co/p6jwJHyPgw

[Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel]

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
https://t.co/2gWABraxSg

[Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel]

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

https://t.co/7dFN8faMOC