Certified Microsoft Excel Expert | Microsoft Excel MVP ||Youtube Channel: https://xitter.cf/t.co/oVeVIYMTT3 |Watch out for Excel Tips and Tricks
Nigeria
Joined January 2022
- Tweets1.7K
- Following364
- Followers4.4K
- Likes1.4K
To see more examples on Excel lists, watch the 2nd part of my introductory video on arrays and nested arrays. This one goes into TEXTSPLIT, XLOOKUP, GROUPBY, and FLATTEN functions. You don't want to miss it
youtube.com/watch?v=yItk6pVN… @david_akomolafe
Heard about lists, collapsed arrays, and nested arrays being supported in Excel? Here is my introductory video to demonstrate how these work. There is more, but let's start with this
youtu.be/ifJqFvE2BU4?si=3XDn… @msexcel
Escape Characters in Excel (Part 2)!
Ever wondered how \ and " work in Custom Number Formatting, or even what escape characters are, and how they surface in Microsoft Excel?
A few practical examples. Watch and try! youtu.be/X1TNIBdc5q4 @david_akomolafe
If you use Comma Style often in Excel, you’ve probably noticed that it adds decimal places by default, so you end up removing them every time. This video shows how to modify the Comma Style itself so that one click gives you exactly what you want.
youtube.com/shorts/0NH9hFyr0…
Windows key+ Shift+S is becoming my most used shortcut. That's the shortcut for taking screenshots (which copies automatically) and pastes wherever - chats, social media, Power point (for creating materials). Try it today
A quick new addition to Excel, still in beta but useful. The ability to rename tables on creation is a feature Excel lovers have looked forward to for years. Now it is here. Simple, but effective. Who ever thought "Table1" was a great name!
youtube.com/shorts/UI_ShiMh7…
Looking for something creative in Excel, here is one! An analog clock in Excel, created step by step. Created over 10 years ago, but I did not share it with the world! Well, now you have it 😁
@david_akomolafe
@MicrosoftLearn
@Microsoft365
@ExcelTips365
youtu.be/J0_dnXFSuXA?si=KkEu…
This is one of those non-clickbait "You have not seen this trick before" 😀
It will blow your mind how this trick works with Find and Replace for multilines in Excel #Microsoft #Excel @ExcelTips365 @AhmedOyelowo
youtube.com/shorts/JgVLIcCEO…
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
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
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/
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…
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…
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