3 Essential Excel skills for the data analyst

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

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

📖Did you know I’ve written a book “Power BI for the Excel Analyst”?

📍Use YouTube15 for 15% off the book

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

Access Analytic Training

Close Menu