
Victor Momoh | Microsoft Excel Enthusiast | MOS
@vicmoexcel
Certified Microsoft Excel Expert | Former Microsoft Excel MVP ||Youtube Channel: youtube.com/c/ExcelMoments |Watch out for Excel Tips and Tricks
ID: 1482788954248261638
16-01-2022 18:56:59
1,1K Tweet
4,4K Followers
376 Following







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


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


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…



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

