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

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

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.

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

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

REGEXREPLACE and REGEXEXTRACT being used to extract special characters from a string. Serves as an intro to Regular Expressions.

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

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.

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.

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.

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

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) via @YouTube @ObboatB @david_akomolafe @AhmedOyelowo.

Wildcards and XMATCH.

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 via @YouTube @ObboatB @AhmedOyelowo.

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

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.

SCAN function for a Running Total is now much easier with the introduction of ETA Reduced Lambdas.@AhmedOyelowo @ObboatB @Crisp_EXCEL @david_akomolafe.

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.

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.

Sometimes, it is the very simple things, like in this case.