3 Essential Excel skills for the data analyst

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=I1XeDS-GLbg

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

#############################

New on site