Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel

Certified Microsoft Excel Expert | Microsoft Excel MVP ||Youtube Channel: https://t.co/oVeVIYMTT3 |Watch out for Excel Tips and Tricks Nigeria Joined January 2022

Tweets

2K
Followers

4K
Following

369
Likes

1K

Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel

6 months ago

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 @david_akomolafe @ObboatB @OzExcel

0 2 4 543 1

Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel

7 months ago

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… @david_akomolafe @AhmedOyelowo

0 1 3 645 2

Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel

8 months ago

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 @david_akomolafe @AhmedOyelowo @Crisp_EXCEL youtube.com/shorts/vtg9kfu…

0 0 0 377 0

Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel

8 months ago

Back to posting video solutions to ExcelBI's linkedin challenges youtu.be/iuB_6pnovvo @david_akomolafe @ObboatB @AustinWarryn @Crisp_EXCEL @AhmedOyelowo

0 1 2 747 0

Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel

a year ago

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

0 0 2 460 0

Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel

a year ago

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

0 1 1 465 0

Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel

a year ago

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 @ObboatB @AhmedOyelowo @Crisp_EXCEL @OzExcel

0 0 3 370 1

Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel

a year ago

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…

0 0 3 332 1

Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel

a year ago

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

1 2 7 423 5

Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel

a year ago

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…

0 0 3 387 0

Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel

a year ago

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 @david_akomolafe @AhmedOyelowo @ObboatB

2 2 13 652 0

Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel

a year ago

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 @ObboatB @david_akomolafe @AhmedOyelowo

1 2 8 405 0

Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel

a year ago

Wildcards and XMATCH youtube.com/shorts/KHc1k07…

0 1 5 366 2

Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel

a year ago

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 @ObboatB @AhmedOyelowo

1 1 4 370 2

Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel

a year ago

Very easy to make an argument optional when creating Excel Lambda functions. Watch this "short" to learn how youtube.com/shorts/BvzhrIX… @ObboatB @AhmedOyelowo @Crisp_EXCEL @david_akomolafe

1 2 3 464 1

Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel

a year ago

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…

0 2 2 355 0

Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel

a year ago

SCAN function for a Running Total is now much easier with the introduction of ETA Reduced Lambdas youtube.com/shorts/x1xcUNX… @AhmedOyelowo @ObboatB @Crisp_EXCEL @david_akomolafe

0 4 5 771 0

Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel

a year ago

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 @ObboatB @AhmedOyelowo @david_akomolafe youtube.com/shorts/HOtrTNn…

1 1 3 346 0

Victor Momoh | Microsoft Excel Enthusiast | MOS @VicmoExcel

a year ago

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…