Learn modern Excel with Excel BI challenges
This is a short introduction to one of my favorite free resources for learning modern Excel, the daily challenges shared by Excel BI (Vijay Verma) on LinkedIn (and equally, the responses provided to them by the community).
You can follow Vijay here to see the challenges as they come out:
/ excelbi
The list of all the old challenges is available here:
https://1drv.ms/x/s!Akd5y6ruJhvhvjsDK...
And the file with my solution and the few others I pulled in during the video is here:
https://docs.google.com/spreadsheets/...
(Note it's saved in Google Drive so will open in Sheets by default, but you'll need to open it in Excel for the good bits to work...)
Sections
00:00 Introduction
02:19 Problem and basic approach
04:25 Dynamic array approach
10:02 Other people's approaches