3 Essential Excel skills for the data analyst
Excel
Nov 23, 2022 12:59 PM

3 Essential Excel skills for the data analyst

by HubSite 365 about Wyn Hopkins [MVP]

Microsoft MVP | Author | Speaker | Power BI & Excel Developer & Instructor | Power Query & XLOOKUP | Purpose: Making life easier for people & improving the quality of information for decision makers

Pro UserExcelLearning Selection

This is my opinion on the 3 key Excel skills a data analyst requires.

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/

More about Excel

We value your privacy

This website stores data such as cookies to enable important website functions as well as marketing, personalization and analysis. You can change your settings at any time or accept the default settings. privacy policy.