🔥The 9th Round of Easy Loan, Earn $40 Reward is in progress❗️ ⏰ Promotion Period: January 15th - Feburary 15th, 2025 👉 Register now and check more details at gate.io/campaigns/358

Sometimes, it is the very simple things, like in this case youtube.com/shorts/9znJC1j…

Interesting that images integrate seamlessly with Pivot tables. Just a short video showing a Pivot table and Data types. Same can be achieved with GROUPBY and PIVOT tables youtube.com/shorts/8TNqemI…

When you format time differences more than 24 hours with the hh:mm foat, you don't get the correct results, so how do you fix it, watch this short for the answer Bernard Obeng Boateng Ahmed Oyelowo | Microsoft MVP | #MCT ako youtube.com/shorts/HOtrTNn…

SCAN function for a Running Total is now much easier with the introduction of ETA Reduced Lambdas youtube.com/shorts/x1xcUNX… Ahmed Oyelowo | Microsoft MVP | #MCT Bernard Obeng Boateng CrispEXCEL Training & Consulting ako

Wildcards are really cool, most people use them within formulas for pattern recognition. But did you know you could use it while filtering a column? Now you know youtube.com/shorts/HG_2sM0…

Very easy to make an argument optional when creating Excel Lambda functions. Watch this "short" to learn how youtube.com/shorts/BvzhrIX… Bernard Obeng Boateng Ahmed Oyelowo | Microsoft MVP | #MCT CrispEXCEL Training & Consulting ako

FIND NEXT works easily with the FIND dialog, but how do you do a FIND PREVIOUS? it is very easy when you know how and is one of the oldest tricks in the book Find Previous using "FIND" dialog in Excel #shorts youtube.com/shorts/41OOPJT… via YouTube Bernard Obeng Boateng Ahmed Oyelowo | Microsoft MVP | #MCT

Wildcards and XMATCH youtube.com/shorts/KHc1k07…

This "short" shows the PERCENTOF function and its use within the GROUPBY function in Excel. 58 seconds of simplicity and elegance 😁 GROUPBY with PERCENTOF Function (% sales per person) youtube.com/shorts/jB5XhHM… via YouTube Bernard Obeng Boateng ako Ahmed Oyelowo | Microsoft MVP | #MCT

If you like shortcuts, here are a few shortcut combinations in Excel using ALT and the Function keys. Nothing adventurous here . ALT+Function keys shortcuts in Excel #shorts youtube.com/shorts/AVWFsfy… via YouTube ako Ahmed Oyelowo | Microsoft MVP | #MCT Bernard Obeng Boateng

REGEX has silently strolled into Excel. This is really interesting, and to think I only posted earlier today a video that showed REGEXREPLACE from GoogleSheets and suggested that Excel may benefit from such a function....Beta Users --Fingers crossed insider.microsoft365.com/en-us/blog/new…

How easy is it to create hyperlinks to 1000 subfolders in a folder using Microsoft Excel? Manually? Definitely not. Watch this video to see how to do this efficiently youtu.be/DnXgI0KlMc8

Imagine having data of about 10000 rows and you want to quickly navigate to the Maximum value in a column. You can use a hyperlink function to create this dynamic navigation. If the maximum value changes, the navigation updates to the correct cell youtu.be/f3kfV1iaX3w?si…

Let's do some REGEX in Excel (or anywhere else for the matter). The video shows the solution to an interesting problem using REGEX and pattern recognition youtu.be/GmzGHNaNOzg Bernard Obeng Boateng Ahmed Oyelowo | Microsoft MVP | #MCT CrispEXCEL Training & Consulting @OzExcel

REGEXREPLACE and REGEXEXTRACT being used to extract special characters from a string. Serves as an intro to Regular Expressions youtu.be/_1b9FGamjMk?si…

This video shows how easy it is to extract phone numbers from a string cootaining numbers texts and so on. This is easy because all the phone numbers follow the same pattern youtu.be/7cv8IAbxvQ0

Back to posting video solutions to ExcelBI's linkedin challenges youtu.be/iuB_6pnovvo ako Bernard Obeng Boateng Austin Warryn CrispEXCEL Training & Consulting Ahmed Oyelowo | Microsoft MVP | #MCT

Typically, we sort dates chronologically. But for a change today, we are going to sort by month first and then by year within each month. This "Short" addresses just that ako Ahmed Oyelowo | Microsoft MVP | #MCT CrispEXCEL Training & Consulting youtube.com/shorts/vtg9kfu…

I will be presenting virtually at the 10th Edition of ExcelWeekend today, 9th February, by 10am ET or 3pm GMT on "Regex in Excel - Mastery through Examples". If you are looking to learn about REGEX, kindly tune in youtu.be/4p8E-djDQzQ?si… ako Ahmed Oyelowo | Microsoft MVP | #MCT

This video shows how to sort a range of numbers by having the Odd numbers come first, then, Even numbers, but ensuring that the data is sorted within each band(Odd and Even) youtu.be/eFIbQgnuqfQ ako Bernard Obeng Boateng @OzExcel