Post # 1
Hey Excel Bees,
I’m in finance/accounting, and I REALLY want to improve on my Excel knowledge. I can barely do pivot tables and all the fancy spreadsheets I see everywhere, and that’s unacceptable in my field.
So Bees who are experts at Excel – what did you do to get there? Excel for Dummies, courses? Online sources? What do you recommend? What worked FOR YOU?
I’m willing to try anything. I have my last final of my grad course this Tuesday, so once I am done with that, I’ll have time to focus on this.
Many thanks in advance.
Post # 3
I honestly think the best way to learn it is giving yourself projects to do in Excel and figuring out how to accomplish what you want as you go along. It simulates a real-life situation and gets you to practice what you’re learning as you go.
Post # 4
I learned best by just playing around with it. Print out a copy of a fancy spreadsheet and try to duplicate it. I’ve also found that the Help button on excel can be useful just to point you in the right direction.
Post # 5
Practice!! And if you don’t know how to do someting, youtube it!!
Post # 6
Thanks, that’s actually how I learned what I know already. It’s just a matter of delving into the more advanced spreadsheets that have all those fancy macros and pivot tables that I’m clueless on. I have found many online resources to be VERY basic (how to make a column wider basic!), so I’m looking for something more advanced.
Post # 7
@MissCountryGirl727: That’s a GREAT idea (YouTube). It also helps justify YouTube at work.
Post # 8
@MrsNewDay: I learned from being forced to figure out how to do it at work!
You can probably find data sets and other exercises online to practice with. That’s probably the best way to learn. Or, come up with an end product you want to create in excel, and execute it. I google tutorials when I am having trouble with something or ask questions on the Mr Excel forum.
Excel is super easy to use if you know what it’s capable of. I think often people just don’t know what they can actually do, so they don’t know what to learn about. Figuring out what excel can do is the first step to learning how you will be able to use it.
Post # 9
I wouldn’t call myself an expert, but I know a fair amount. I’m also in accounting/finance. Honestly, I learn a lot just from clicking on buttons and seeing what they do. Or looking at other spreadsheets and trying to recreate them
Post # 10
@MrsNewDay: lol! Same as everyone else, I learned by stomping around in it. If I had free time (rare) I just played around.
Post # 11
I taught myself pivot table by just playing around in them. I would run reports and then see how I could arrange them. I do consider myself an expert in Excel and Word but maybe medium at pivot tables. Just play. You’ll be amazed at what you learn. 🙂
Post # 12
@MrsNewDay: Practice and google!!! Taken on projects where you have to accomplish certain tasks/operations in Excel. If you don’t know how to do it, then google it (seriously, it is all on the web).
I also took some classes at one point for Excel and MS Access because my work paid for it. They were really helpful in quickly learning “hidden” tricks and getting familiar for less used functions/operations. You could see if your employer would pay for part of or all of the cost of a course.
Post # 13
I took a class in excel originally and that’s what helped the most in learning SO many features. See if you can find a used excel textbook that applies to the current version.