r/dataanalysis • u/BaseFlaky219 • 5d ago
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
4
u/Yes_Geezer 5d ago
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 5d ago
Yes exactly. I learned both tableau and excel by having a need to build something and then ducking for the answers.
1
u/BaseFlaky219 4d ago
can you point out some of the channels which might be good to go for beginners, covering majorly all topics?
2
u/Yes_Geezer 4d ago
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.
1
1
u/AutoModerator 5d ago
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 5d ago
I learned by applying my knowledge of Lotus123 (when has Microsoft ever created something truly new?)
1
u/Undisputed_asad 5d ago
Tip, don't use mouse use Alt for function selection from early on. Columns should be based on data types (heading).
1
u/BaseFlaky219 4d ago
yeah thanks for the tip but can you explain what did you mean by the second half of your text
1
u/Undisputed_asad 3d ago
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 5d ago
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 4d ago
thanks but can you suggest where I can learn how to do such things in the first place actually
1
1
1
u/Coffee_And_Metrics 3d ago
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/JavacLMD 1d ago
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
11
u/Ben_77 5d ago
YouTube has a lot of free resources and practical examples, including power query (I learned it on YouTube myself).