3 Essential Excel skills for the data analyst

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

In this Video

00:00 Intro

00:41 Tables

05:15 Power Query

12:05 Pivot Tables

13:50 Power Pivot and the Data

Resources

https://pbi.guide/resources/