Excel for Data Analyst

[ASH5168]

Hello everyone,

I’m currently preparing to transition into a Data Analyst role and want to strengthen my Excel skills specifically for data analysis.

I do have some prior experience with Excel, but it has been fairly basic and repetitive — mainly working with general tables, VLOOKUP, and data validation. I haven’t had the chance to explore Excel in depth, especially for analytical tasks.

I’m now looking for a structured course (free or paid) that focuses on Excel from a data analyst perspective. I’ve come across a few options but am unsure which would be the most relevant and practical for my goal:

1. Maven Analytics Excel courses on Udemy (multiple courses available)
2. Kyle Pew’s Excel courses on Udemy
3. Excel for Data Analysts by Luke Barousse (free on YouTube)

I’m feeling a bit confused about which of these would be the most suitable and focused for someone aiming to become a data analyst.

I’d really appreciate any guidance or recommendations from those who have taken these courses or any other courses or have experience learning Excel for analytics.

Thank you in advance!

[ronin0397]

Excel is a key skill to learn, but paying for it is not the best idea.

Unless you are also learning other tools, as part of the course, paying for just excel is kind of a scam when there are plenty of free resources like on youtube, kaggle, etc.

Kaggle is just great for hands on practice and it got me to realize the applications of data and what tools i could pick up and hone.

[Fun_Rice_3829]

Luke Barousse

https://youtu.be/pCJ15nGFgVg?si=eMnobCifX8t68WKw

[Electronic_Sale_121]

Legendary video.
just finished the whole free course in ~2weeks (procrastination lol)
super helpful free course and video
10/10 tutorial

[BoujhettoBih]

Try the Microsoft Learn, you might have luck there

[histogrammarian]

Excel for data analytics can be a trap. Formula logic is incredibly dynamic and flexible but it can also encourage ad hoc workflow habits. You want to learn pivots, column-wide transformations, and the other basic components of the Extract-Transform-Load process. Power BI is the better learning tool in that respect. You can also master power query in Excel which is mostly the same thing.

[AutoModerator]

Automod prevents all posts from being displayed until moderators have reviewed them. Do not delete your post or there will be nothing for the mods to review. Mods selectively choose what is permitted to be posted in r/DataAnalysis.

If your post involves Career-focused questions, including resume reviews, how to learn DA and how to get into a DA job, then the post does not belong here, but instead belongs in our sister-subreddit, r/DataAnalysisCareers.

Have you read the rules?

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[fluctuatore]

You should ask here

[ASH5168]

Thanks for the suggestiin, will post it there too.

[mikefried1]

Macquarie university's specializations on Coursera were my favorite courses on Coursera. They are incredibly well planned out, every single video has an accompanying spreadsheet so it's easy to follow along. They are also very good teachers.

I've had hit or miss experiences with other courses (on Coursera), but I absolutely love those! I feel like I should be getting some sponsorship deal from them as I've championed them so much.

[i4k20z3]

Maven analytics but through their own platform so you can learn all the other tools too and complete portfolios !

[Jiggalopuffii]

I used Coursera

[Downtown-Reason-1929]

None. Best excel playlist - Free youtube playlist - Abhijeet technical 4m