Certified Microsoft Excel Expert | Microsoft Excel MVP ||Youtube Channel: youtube.com/c/ExcelMoments |Watch out for Excel Tips and Tricks
Joined January 2022
- Tweets 1,678
- Following 366
- Followers 4,440
- Likes 1,421
238 Photos and videos
This is a classic trick in excel for having dynamic chart titles where the title changes based on some other cell, dropdown or condition. Quick and easy
youtube.com/shorts/SDtMbWPA-… @msexcel @ExcelTips365 #Excel
60
You can do the regular view>freeze panes or freeze top row for your excel sheet, but there's another cheeky way to do it which is not too obvious. This video shows you how youtube.com/shorts/aLVIjgt6v…. Subscribe to the channel for more tips and tricks
1
71
1
81
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 vt.tiktok.com/ZSQBV4mJP/
1
61
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 youtu.be/wlNRZ6pljgQ?si=br3X…
4
8
419
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=tubm…
3
164
This is a video showing an interesting use case of TEXTSPLIT and REGEXEXTRACT for extracting data between delimiters
youtu.be/90wY2gUY_6Y?si=bqNZ… @Crisp_EXCEL @ObboatB
2
4
812
This is a simple tip to sort columns alphabetically (by column names) in Power query
youtube.com/shorts/M16PdX5RV…
2
194
1
103
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/YP3BEmpwU…
2
2
139
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/8Y5dJM9ZN…
1
115
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/3NbQobgqG…
115
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/YU8J13PZj…
2
147
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/7aQvAfTq8…
@david_akomolafe @AhmedOyelowo
93
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-C4JIS…
2
118
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/5fnRfy9m1…
104
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/KYeNH0qFs…
93
Have you ever used the REPT function in Excel? Here is an interesting use case for in-cell visuals
youtube.com/shorts/CqDhvJlWN…
2
3
293
Have you ever used the REPT function in Excel? Here is an interesting use case for in-cell visuals
youtube.com/shorts/CqDhvJlWN…
1
128
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/2dQOh01f2…
1
119