3 Essential Excel skills for the data analyst

3 Essential Excel skills for the data analyst

HomeAccess Analytic3 Essential Excel skills for the data analyst
3 Essential Excel skills for the data analyst
ChannelPublish DateThumbnail & View CountDownload Video
Channel AvatarPublish Date not found Thumbnail
0 Views
Here's my take on the three most important Excel skills a data analyst needs.
Understanding how to use Power Query, Tables and PivotTables/Power Pivot is the starting point of your learning journey.

Once you get comfortable with these concepts, you can easily migrate to Power BI

Want to know 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-Analyst-essential/dp/161547076X

00:00 Introduction
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?eyK91Qg

Contact me: https://wyn.bio.link/

Access to analytical training
https://accessanalytic.com.au/training

Please take the opportunity to connect and share this video with your friends and family if you find it helpful.

If you enjoyed watching 3 Essential Excel skills for the data analyst.
Don't Forget to Say Thank You comment below... ^_^