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


If you like this video you might like my EASIEST Dependent Dropdown list using DOUBLE XLOOKUP    • THE Easiest Multi Level Drop Down Lis...  

or this one 20 years of Excel Tips jammed into 1 hour    • The ultimate Excel tips and tricks guide  


Want to learn more about Power Query, DAX and Power BI? Check out my book:

"Power BI for the Excel Analyst"?
Australia: https://pbi.guide/book/
Amazon: https://www.amazon.com/Power-BI-Excel...


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...

Connect with me: https://wyn.bio.link/

Access Analytic Training
https://accessanalytic.com.au/training