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

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/PowerBIExcel...


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...

Connect with me: https://wyn.bio.link/

Access Analytic Training
https://accessanalytic.com.au/training