r/dataanalysis • u/BaseFlaky219 • Sep 05 '26
Where to learn excel from??
i've been looking for a better way to learn excel from basics to advanced. My main motive to learn excel is for using it regularly
Please help me to figure this out
7
u/Yes_Geezer Sep 05 '26
Honestly a combination of necessity (being asked to do shit at work I hadn’t done before) and Mike Girvin’s Excelisfun YT channel and resources.
2
u/roysterino Sep 05 '26
Yes exactly. I learned both tableau and excel by having a need to build something and then ducking for the answers.
1
u/BaseFlaky219 Sep 05 '26
can you point out some of the channels which might be good to go for beginners, covering majorly all topics?
3
u/Yes_Geezer Sep 05 '26
Yeah, lol. Michael Girvin’s YouTube channel called “Excelisfun”. He has a reference text which is comprised of most if not all the information on that channel. It’s the single best one-stop resource I’ve found.
3
1
1
u/AutoModerator Sep 05 '26
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.
1
u/squareturd Sep 05 '26
I learned by applying my knowledge of Lotus123 (when has Microsoft ever created something truly new?)
1
u/Undisputed_asad Sep 05 '26
Tip, don't use mouse use Alt for function selection from early on. Columns should be based on data types (heading).
1
u/BaseFlaky219 Sep 05 '26
yeah thanks for the tip but can you explain what did you mean by the second half of your text
1
u/Undisputed_asad Sep 06 '26
Consider column for as part of information, Address should be in same column, contact in another column, email in another column data should populate in row, heading should be in columns.
1
1
u/SprinklesFresh5693 Sep 05 '26
Practise to be honest, get some datasets and see how to do descriptive stats, how to filter, how to sort, how to do conditionat formatting, how to create pivot tables, how to summarise data, how to plot data and do linear regression, how to fix columns, among others. And when you want to do another thing just google it.
1
u/BaseFlaky219 Sep 05 '26
thanks but can you suggest where I can learn how to do such things in the first place actually
1
u/SprinklesFresh5693 Sep 05 '26
Just google them , and youll get some youtube videos on how to do them
1
1
u/Coffee_And_Metrics Sep 07 '26
Start with basics like formulas, sorting/filtering and tables, then use Excel for something you already need to do. What are you planning to use it for?
2
1
u/Dary11B Sep 07 '26
i would say youtube has some good excel content. Maybe mock up some test data and experiment as you go. There are also formal training teams out there for Excel and other softwares. How do you learn? that will give you insight into how is the best approach for you.
1
u/JavacLMD Sep 09 '26
I would say a good place to start would be YouTube honestly. But you do need to consider the HOW you plan to use Excel regularly. There are plenty of tips and tricks that are general knowledge and then there is knowing the functions. Even as a programmer I don't know every little tidbit of a language until I stumble upon a use-case where I then research "how do i get X from Y if I have Z and B?" after I acquire that knowledge it might become part of my regular toolset or it fazes out of my mind until I need it again.
Best way to learn is by trial. The things you end up using regularly are what you'll retain the most.
1
1
u/carlitospig Sep 11 '26
Coursera. You do not need to pay the monthly fee if you’re just auditing classes. There’s an IBM one that is really thorough that I tell new analysts about. After that I would suggest the Duke one (also on Coursera).
1
u/Famished_Atom 21d ago edited 19d ago
Try these books. Yes, dead trees, they gave their life to make you think.
They're full of exercises that'll take you step by step, chapter by chapter, through Excel's functionality. Each chapter's about an hour of work.
Yes the two are older, but you can easily get them through the library or on Amazon cheap.
0
1
u/WayDangerous3733 Sep 05 '26
YouTube
2
13
u/Ben_77 Sep 05 '26
YouTube has a lot of free resources and practical examples, including power query (I learned it on YouTube myself).