你可能會喜歡
It's a 2 in 1 Excel challenge. Fill out the blanks for a column and then execute a GROUPBY using that same column to produce the required results @AhmedOyelowo @tundetoday youtu.be/g7XqDbAIDdU?si…
youtube.com
YouTube
Fill Blanks and summarize data in Excel
Just a quick demonstration of using a column in GROUPBY that does not exist in the source data but is rather derived from another column youtube.com/shorts/7KNEwZJ… Watch, like, and subscribe
youtube.com
YouTube
GROUPBY Year from Date column #shorts
When you do CTRL+SHIFT+DOWN in a column that has blank cells, you need to press multiple times to get to the actual last row. This video shows a nice way to get to the last used cell with a TRIMRANGE-NameBox trick @ako @tundetoday @AhmedOyelowo youtube.com/shorts/kN7bzKL…
youtube.com
YouTube
Smart Excel Selection: The TRIMRANGE Method
When writing a formula and doing say a CTRL+SHIFT+DOWN to select down till row 100000, most users then start scrolling back to get back to the location of the formula(the active cell). A simple shortcut can get you back. Do you know? Watch this short youtube.com/shorts/hYvVv7N…
youtube.com
YouTube
Excel Tip: Return to active cell - within formula #shorts
GROUPBY in PQ is very powerful for aggregation. Unfortunately, if you have 50 columns to aggregate, you would need to add them one after the other. This video shows a smooth(if I do say so myself) workaround to achieving the same thing, by tweaking M youtu.be/PyxD9DJp4_k?si…
youtube.com
YouTube
PowerQuery: Smart aggregation of multiple columns - GROUPBY
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
youtube.com
YouTube
HOW to sort odd and even numbers in excel
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
youtube.com
YouTube
Regex in Excel - Mastery through Examples
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…
youtube.com
YouTube
Sort data first by Month and then Year #shorts
Back to posting video solutions to ExcelBI's linkedin challenges youtu.be/iuB_6pnovvo @david_akomolafe @ObboatB @AustinWarryn @Crisp_EXCEL @AhmedOyelowo
youtube.com
YouTube
Excel Challenge - Top N filter in excel using GROUPBY
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
youtube.com
YouTube
Regex to extract phone number from string #Excel
REGEXREPLACE and REGEXEXTRACT being used to extract special characters from a string. Serves as an intro to Regular Expressions youtu.be/_1b9FGamjMk?si…
youtube.com
YouTube
REGEX to extract special characters
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
youtube.com
YouTube
REGEX in Excel - find names starting with certain character
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…
youtube.com
YouTube
Dynamic navigation using hyperlinks - quickly "jump" to Max/Min in...
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
youtube.com
YouTube
Hyperlink in excel to all subfolders in a folder+PowerQuery+VBA
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…
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
youtube.com
YouTube
ALT+Function keys shortcuts in Excel #shorts
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
youtube.com
YouTube
GROUPBY with PERCENTOF Function (% sales per person) #ahorts
Wildcards and XMATCH youtube.com/shorts/KHc1k07…
youtube.com
YouTube
Wildcard Match - what column contains an "@" #shorts
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
youtube.com
YouTube
Find Previous using "FIND" dialog in Excel #shorts
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
youtube.com
YouTube
Optional Arguments in Excel Lambda #shorts
United States 趨勢
- 1. Giannis 49.6K posts
- 2. Tosin 48.9K posts
- 3. Spotify 1.38M posts
- 4. Leeds 76K posts
- 5. Bucks 32.5K posts
- 6. Maresca 40.5K posts
- 7. Wirtz 27.3K posts
- 8. #WhyIChime 1,837 posts
- 9. DANNY PHANTOM 4,846 posts
- 10. Milwaukee 15.7K posts
- 11. Sunderland 37.8K posts
- 12. Delap 13.8K posts
- 13. Merino 35.1K posts
- 14. Chiesa 7,178 posts
- 15. #LEECHE 19.5K posts
- 16. Joao Pedro 6,596 posts
- 17. Badiashile 5,864 posts
- 18. Mike Lindell 9,547 posts
- 19. Chris Paul 51K posts
- 20. Jack Smith 33.8K posts
你可能會喜歡
-
Tina Okonkwo #DataFestAfrica2025
@Rita_tyna -
David Abu _ || DataFestAfrica2025
@DavidAbu_ -
Data Community Africa
@DataFestAfrica -
Ibilolia A
@saltypip -
Alex Freberg
@Alex_TheAnalyst -
MavenAnalytics
@MavenBI -
Malcom Okonkwo
@malcom_okonkwo -
Jessica Ayodele
@jessica_xls -
Faith Omonigho Oseghale with the money✨🌍 #DFA25
@OseghaleFaithO1 -
The SQL Tribe
@thesql_tribe -
✨Rachel Irabor is learning AI
@Richie4love -
Alexa Ighodaro
@Alexa_Ighodaro -
BaBaT
@ABofficial_NG -
Chinonso Okonkwo
@Nonso_Analytics -
DataBender
@Yinkaoke
Something went wrong.
Something went wrong.