MS Excel expert Bees – how did you do it?

posted 3 years ago in Career
Post # 3
296 posts
Helper bee
  • Wedding: August 2014

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
1080 posts
Bumble bee
  • Wedding: April 2014

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
3534 posts
Sugar bee
  • Wedding: September 2013

Practice!! And if you don’t know how to do someting, youtube it!! 

Post # 8
11668 posts
Sugar Beekeeper
  • Wedding: November 1999

@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
922 posts
Busy bee
  • Wedding: April 2014

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
1067 posts
Bumble bee
  • Wedding: September 2014

@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
550 posts
Busy bee

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
4041 posts
Honey bee

@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
1312 posts
Bumble bee
  • Wedding: May 2014 - NH

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.

Leave a comment

Sent weekly. You may unsubscribe at any time.

Find Amazing Vendors