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
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
Buy my book “Power BI for the Excel Analyst”
Connect with me: https://wyn.bio.link/
Access Analytic Training
