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