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