{ "media_type": "text", "post_content": "Only know basic excel but I am going to spend a few months learning everything up to VBA (preferably without a mouse). Any general advice I should know before I commit a bunch of time to this?", "post_id": "5eef9141833cd2002f43c9ad", "reply_count": 9, "vote_count": 2, "bowl_id": "552d1d24dc1c586b09d2d051", "bowl_name": "Consulting", "feed_type": "crowd" }

Only know basic excel but I am going to spend a few months learning everything up to VBA (preferably without a mouse). Any general advice I should know before I commit a bunch of time to this?

likehelpful
Posting as :
works at
You are currently posting as works at

Some basic VBA can be pretty easy to learn and only take a week or so to really get down I think. Look up some of the more important things to do in VBA (like opening and saving a workbook, looping through a range, changing formatting) and try to build it into a macro. Also, start recording macros and looking at the code to get a better idea of what it’s doing. Using Excel without a mouse is mostly just an exercise in muscle memory than anything else.

likesmart

I see, I plan on doing VBA afterwords but would you suggest doing a little VBA contemporaneously so that I connect the two a little more? I actually know so little about VBA I didn't think to consider it

Learn by projects, not tutorials. Happy learning!

like

Instead of VBA learn Python or R. Much more flexible and much more powerful. A couple of months and you will have a lot of knowledge. I picked Python 5 years ago and I don’t regret it at all.

like

Being able to remove grid lines without the mouse makes you an excel guru

funny

It’s more impactful if you have something you need to do. Learning without application won’t make it stick so I’d suggest you look for opportunities to utilize excel to complete the tasks or to improve something you’re already doing.

like

Think about it in terms of weeks, not month. Agreed with what others have said here: absolute best way to learn is during a real project where you have some skin in the game. May be a bit nerve-wracking and you won't be as efficient at the beginning, but it'll stick for sure longer term.

like

Definitely learn the keyboard shortcuts. Hit ALT and then see what the shortcuts are. Well worthwhile over the years. One off the top of my head - shift and space to highlight a row then ALT E D to delete it. Takes 2 seconds.

Example deliverables from investment banks: tinyurl.com/talkpts

Additional Posts

How many first year analysts here started as interns? What did you guys do to get those jobs?

like

test post from test

like

No company displaying!

like

Hhjjndjjffjjddjdh dndbbdndjjdjdndnnf dndbdhjxjdjd djdjhdjdjdjhdjndndndjdjdjdjjcncndjdjnd dhdjhdjdjdjhddhhd ghhhhhhh ghbbbbb fghhhhhhbh cvhhhhhhbhbb ghhbb. Hjnxnxndbd vsbdbddbbxbdbbd dbdhdhdjjxndnbdhdh

like

Testing for sound!

Post for push testing

like

Post without company

like

Just moved to the city any job postings in the lab arena?

like

Post for comments

like

14:36 gmt 😀

Post with company

like

Consulting colleagues who send long winded emails, with Manager cc'd, to clients and even internally for even seemingly small details are...

like

It scares me how good I've gotten at pretending I know what I'm talking about.

like

Heading to Vietnam for 2 weeks around xmas/nye. Flying in and out of Ho Chi Minh. Any tips? Favorite places? Things to watch out for?

like

To EY folks who are crying on FB about low PBB this year, either accept it and give the firm one more year or move to another firm. Complaining on FB will further prevent good talent from joining EY.

like

What is the salary range for consultants two years out of college?

For those of you that have an MBA, was it worth the effort and money? I'm considering going to Georgetown full-time and would really appreciate any insight from folks on the other side.

like

Favorite Excel shortcuts? Putting together a list for first year consultants on my team so they can learn the ways of the keystrokes and throw✌🏽to the mouse

like

Making 120k right now at a great firm, working 40 hours from wherever I want. Have an offer for 150k, unsure about work life balance. Would have to go in the office every day. Would you take it?

likehelpful

Just got a gift from a co worker. Guess I'll make that my holiday bonus by a degree of separation. Thanks Accenture.

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
Download Fishbowl to see what others are saying
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the Fishbowl app

Get realtime notifications and see
what's happening in your industry
from the palm of your hand.

For account settings, visit Fishbowl on Desktop Browser or

General

Legal