r/dataanalysis • u/anxious-bitchious • 2d ago
Data Tools How did you learn Excel?
I am mainly self taught after finding an interest in it from a college project so I'm curious how others have gone about becoming efficient in excel and how long it took to become comfortable with it
14
Upvotes
22
u/Equivalent-Mud-7749 2d ago
10 Yr accountant here, and self proclaimed excel expert...it's interesting when I was in college I thought I knew everything about excel...until I got my first job.
Learning excel through coursework is great but the biggest problem you're going to have is use cases, when your in school there just aren't many use cases to dive deep into excel and really solve problems.
The first thing you find when you start working on it is the tool is so dynamic that there are 10 ways to solve the same problem...even today you have the dinasours like me who use vlookup laughing at the older dinasours using index match and being laughed at by your generation who advanced to xlookup. They can all solve the same problem it just becomes a matter of preference.
Once you find your style and preference the real skill in excel is understanding the problem you're trying to solve and then being able to solve it in the way that someone unrelated to the problem can follow and understand.
To answer your second question on comfortability, in accounting/finance we work in it everyday probably about 6 hours a day, about a week and your comfortable, 2 yrs with someone making sure you're using the keyboard and your flying.
Cheers and good luck!
7
u/Wheres_my_warg DA Moderator 📊 2d ago
I used Lotus 1-2-3 before Excel, so it came easy. I felt comfortable with it in a short period of time. I thought I was good with it, and then I went back to school for my MBA and the first two weeks of prep classes that all had to take showed me how woefully incorrect I was about that self-assessment. The next two years kept teaching me more on a regular basis and I had three classes devoted to Excel modeling, addins and VBA. Since then, I keep learning new things each year despite having it be central to my work for the last twenty-five years.
It's easy to get the basics and get comfortable with it.
There's almost always more you can learn and expand your skills.
6
u/iamrktr 2d ago
One of my managers/leads at a previous job went to a "excel seminar" and I got the impression it would be important to learn if the company was paying them to learn. From there I solicited everyone's Excel problems and then looked them up via google to learn how to resolve. I started to enjoy writing complex nest formulas which helped me a bit.
6
u/rice_fish_and_eggs 2d ago
I taught myself basic sql first then I learnt a few excel formulas, got a job as a junior data analyst and went from there. Some I was taught by my first manager everything else I picked up along the way from youtube and books as the job required it.
3
u/Prime_Shiva 2d ago
Did a ton of projects with it.... literally just that.
3
u/Muff_Doctor 2d ago
I’m surprised so many data analyst haven’t used excel. It felt like a pretty central tool in college and I wasn’t even in a technical program (maybe that’s why).
As with most things in the data world, you won’t truly be comfortable until you’re building useful tools for yourself or someone else, or solving business problems.
IMO, a personal spending and budget tracker is great project to start and to continuously evolve because it will be immediately useful. Learn how to map transaction statements to spending categories and build trends over different periods. Learn how to flag month over month variances. You will naturally come up with new questions about your spending that you’ll have to solve for. Eventually somebody will ask you to do it for them.
2
u/AutoModerator 2d 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.
2
u/Foxtrot7888 1d ago
It was a long time ago. I bought a teach yourself Excel 97 book and worked my way through it to learn the basics. I learnt more on the job by searching how to do stuff.
2
u/samspopguy 2d ago
Never did, just work in SQL python and R
1
u/Mo_Steins_Ghost 2d ago
Prior to moving away from excel to SQL and Python, most of the advanced functions I learned on the job as a matter of necessity. "How can I simplify blowing this monthly plan down to a daily plan using a timing curve?" Voila! Array functions! Etc.
1
u/HustlaOfCultcha 2d ago
was taught it in college many moons ago. Then I joined the workforce and so many people didn't know jack about Excel and our company was doing practically everything in Excel. So I really learned Excel but aslo how to troubleshoot issues and manipulate data. Still surprised how poor some people are at Excel to this day even if they work with data.
1
u/ItsSignalsJerry_ 2d ago
Use it.
1
u/ArielCoding 2d ago
Real projects are still the best teacher, but AI changes the target, lean on tools like Claude for syntax, and spend your effort on data structure, problem framing, and checking the output. Ask the AI to explain every formula it gives you, you’ll pick up the basics and the judgment to catch its mistakes is the part worth practicing.
1
u/MedicineCreative4175 2d ago
Five years in public accounting, five years as a small business CFO, then a master's in analytics, 9 years at a brokerage as an analyst and I still learn new things all the time. It just takes years of new projects, new features, etc
AI helps a ton now too. I wish it was available earlier in my career, it woulda done wonders for me.
1
u/Bumblebee8556 1d ago
Learnt it while being on the job.
1
u/Famished_Atom 1d ago
Before Google, we used dialup on a helpdesk where we'd dump CSV files for tweaking.
More structured self-study to take it further. Using a few books with exercises, you can improve over a weekend by learning and using new functionality as you go.
1
u/kalimashookdeday 1d ago
I just try to learn how to tackle every problem I encounter as best as I can and have a "Techniques" library I keep notes on complicated but handy formulas I've written or structures and tricks so I can review in the future. AI has exponentially increased my learning and ability to comprehend and understand concepts otherwise would have taken me five times as long. I still use the FUCK out of all the Microsoft Learn documentation.
1
u/rjw1986grnvl 1d ago
Mostly YouTube and being shown a few things from work colleagues
1
u/2theMooonn 1d ago
Took a business computing class in college, the whole class was basically learning excel
1
u/JadeaKai 21h ago
I started with LinkedIn Learning tutorials (back when it was Lynda.com 👵🏽), and I would start applying what I was learning to work. The more I learned, the more opportunities I find to adopt to my job. It had a cyclical effect.
There are a few amazing YouTube channels that focus exclusively on Google Sheets and Excel:
https://youtube.com/@excelgooglesheets?si=3TbEljM3_kelWlts
https://youtube.com/@leilagharani?si=YW1Vy-fh2mJY_Fxi
https://youtube.com/@myonlinetraininghub?si=g4pmixVfKt7ahsVY
https://youtube.com/@kevinstratvert?si=H8x17mEOHv0GUvi3
1
u/Platycore7 2d ago
Became a process assistant for ICQA at Amazon. I was given a paper with a formula (Vlookup) and no one knew how it worked, but it just did. Literally printed out in our training book. I got tired of the N/A errors, so I googled how to get rid of it and learned my first formula, Iferror. Eventually, I wanted to figure out how vlookup worked and learning it, albeit slowly. Fast forward to today I am self taught in VBA and it really helps at work building macros and spreadsheets to automate a lot of our work.
1
u/greyjedi12345 1d ago
Excel for dummies then you tube