This is my opinion on the 3 key Excel skills a data analyst requires.
Understanding the use of Power Query, Tables and Pivot Tables/Power Pivot is the starting point on your learning journey.
Once you get comfortable with these concepts you will easily migrate to Power BI
If you like this video you might like my EASIEST Dependent Dropdown list using DOUBLE XLOOKUP https://youtu.be/lxd4Pc_gMIA?si=HYgTezCiKgBmOMgv&list=PLlHDyf8d156Xnoph4CbOiMrqQKiJZ8mhn
or this one 20 years of Excel Tips jammed into 1 hour https://youtu.be/i6iOW43NCY0?si=PbVjKafvvtRTRl95&list=PLlHDyf8d156Xnoph4CbOiMrqQKiJZ8mhn
Want to learn more about Power Query, DAX and Power BI? Check out my book:
"Power BI for the Excel Analyst"?
Australia: https://pbi.guide/book/
Amazon: https://www.amazon.com/Power-BI-Excel-Analyst-essential/dp/161547076X
00:00 Intro
00:41 Tables
05:15 Power Query
12:05 Pivot Tables
13:50 Power Pivot and the Data Model
Here's the file if you want to practice
https://aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/EveO1tKC_N5FkufC2Wd84A0BS0YVd-lQf-UgQkOdJ8b0Pw?e=yK91Qg
Connect with me: https://wyn.bio.link/
Access Analytic Training
https://accessanalytic.com.au/training