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