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

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

"Power BI for the Excel Analyst"?

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

Access Analytic Training

[AccessAnalytic]

📖📍Use discount code YouTube15 for 15% off my book "Power BI for the Excel Analyst"? I wrote it for those who love Excel and want to learn Power BI, there's even a whole chapter dedicated to Power Pivot in Excel.
📍Use YouTube15 for 15% off the book

[StopWhining]

Calm, controlled presentation with no cursors flying around the screen. He also tells you "why."

[SilvestreECamposano]

When I am confused about the basic of Power Query, I usually go back to this lecture. Thank you Sir, for simplifying the very complicated topics.

[misskaykay]

After years of using Excel, how am I only learning about Power Query now 😭😭😭😭😭!!! Cleaning data takes up most of my time! This video was brilliant. Thank you 🙏🏾

[XianOrtiz]

i am getting major "she's a beauty" irwin vibes from this. love it.

[deangawler]

Learnt more about advanced Excel use in 18minutes than I have in the previous year - brilliant!

[arnaudmanir]

Came here for Excel, stayed for the heavy British accent 😅

[verbeeck]

The possibility to unpivot other columns is adressing a major obstacle for pivot table application. I was looking for a solution through traditional excel formulae but was completely unaware of this possibility. Thank you so much!

[abdulwahabfakunle]

Great content. You not only have the knowledge of the right skills required for Data Analytics using Excel but you are also an excellent teacher. I'm a fan.

[brandonp]

This has transformed my life as a data analyst. Saves so much of time

[JamesGettingFit]

Power query is the one! I’m not an analyst but helping pull different information in quickly has been a game changer

[tomalcolm]

Your voice is music to my ears. Every other Excel tutorial I've come across is like nails on a chalkboard. Subscribed!

[CeliaAlvesSolveExcel]

I agree with you about these essential skills, Wyn.
About Trim, I would suggest applying that step before merging the columns because it seems that in Power Query Trim does not remove multiple spaces in the middle of the string as TRIM does in Excel.

[deepakgautam]

I am an Analyst I love Excel nowadays along with Tableau, Power BI, Sql or any other tools. Its amazing to learn and enhance skill everyday. I am passionate to learn excel advanced features along with Power BI ☺️☺️. Thank you for explaining in detail in this video.

[gjones]

Love the video! I've used PQ for a few years now and am amazed at how few people realize that it's there. I'm putting together some recommended PQ training for analysts at my company and will definitely include this video! FYI I love your pronunciation of POWA QWEWY :)

[iankr]

Great video, Wyn. I'm slowly building my experience with Power Query. As you say, a lot of people haven't heard of it. In my organisation so many people rely on fiddly manual processes to gather and report on data, which is so prone to error.

[Machende]

Love your teaching mythology, clear and very easy to follow. I'll be reviewing a lot more of your lessons moving forward!

[ds]

Wow! Power Query! Mind blown! Brushing up on my rusty-ish excel skills for my job interview. I've added several of your videos to my watch list! Thank you for providing such engaging content!

[TheJoshtheboss]

I love how you explain. Very concise, yet detailed. Excellent!!

[Theausomecaleb]

Control space.
Control space
🤯
I've been highlighting and scrolling my entire life, ooof glad I found this video lol.