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
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
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
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
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
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
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
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
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
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
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
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
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
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