Starting at MBB soon, can someone recommend some good excel courses or atleast list the skills I should really master to do well as a consultant?

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

Coursera is a great point to start, pending on your current knowledge, but you should be able to do:

- Pivot Tables,
- Graphs,
- Slicers,
- Conditional Formats;
- VLookUps, HLookUps, XLookUps,
- Index / Match,
- If, Ifs, iferror, concat, sum, etc formulas,

At the minimum

like

Legend! Thank you! If that’s the minimum, what are some additional functions I should learn that would really make me stand out? I know being very efficient with shortcuts is going to be key

When my wife started at Bain & Co they provided her a list of courses and materials two weeks prior to her start date to brush up on tools like Excel etc. If you haven’t gotten something yet, I’m sure you will as you get closer to your start date

like

If you're asking this now, it's already too late... may God have mercy on your soul...

funnylike

Should’ve started 4.5 years ago. Fml.

Excel is easy, you’ll pick it up quick. I work with a lot of data and use power bi a ton. I’d recommend learning that as well.

like

I would take the Maven course on Udemy. It teaches you how to import and clean data (similar to what alteryx does) and DAX formulas (which is like excel functionality but better). It also teaches you how to build the graphs and tables. I believe it is a 16 hour course, but you can watch it on 1.5x or 2x.

Miss excel

uplifting

Well if the MBB firm is McKinsey, don’t worry. We have our own excel trainings.

Kieran Luke’s udemy course is fantastic!

Related Posts

Can A non technical person from service operations become a scrum Master after completing the certification and learning about all the principles

Does anyone know how to become an independent contractor?

like

How long until you felt comfortable in ITS? Is it fair to say with all the changes it would take longer to get comfortable in ITS?

like

Did anyone lateral into big law? First year in insurance litigation defense and I’m looking to see if it’s even possible to break into big law in a year or two

like

take job with long commute or stay at b4?

like

I’m a junior full-stack developer. What job titles should I be looking at where I can use my skills?

like

Hello fellow SAP Consultants!
I am SAP HCM consultant having 4.10 years of experience. I feel that this module doesn’t have any growth. My first switch took me to 9LPA from 6LPA and now the second switch is being offered for 11.5LPA where I can see my fellow friends in SAP having more than 15LPA at the same experience on their second switch itself. Should I be worried about my skillset? Any insights would highly be appreciated. I feel stuck.

like

Salesforce Commerce Cloud - what are your thoughts and is it worth it to specialize in the platform?

Talent retention | There has been alot of people leaving Agency life for other careers which offer more work life balance or benefits or even just going solo. Your thoughts? How long do you plan to stay in this field ?

like

Is it worth it to make managing director at a Big Four firm?

like

Has anyone left big 4 or other PA firms tax transaction service groups for industry (or know of anyone)? What was the role and salary bump, how are annual bonuses/raises in industry, what is a typical work week (hours) like? I don’t think I can take this always on just to stay afloat life much longer. For context I am considered a high performer, am near the top of the salary band at my level and have a great supporting network at Deloitte. It’s just not worth it to have zero personal life.

like

Recommendations for websites or newsletters to subscribe to, to stay informed on anything finance related or deals related? Any podcasts too. Thank you

likehelpful

Desperately want to get into healthcare strategy consulting. 13 years of healthcare clinical experience including project work. MBA. But keep getting told by recruiters that I don't have enough experience to be a Consultant or Manager but that I have too much experience to enter in every level such as a Senior Associate. Just one rejection after another, even when applying with internal referrals from Director or Partner levels. What am I doing wrong?

like

A recent post graduate looking to penetrate tech sales industry. I have 18 months experience of derivatives portfolio management and 16 months experience of customer service with a knack for marketing

I would love if one can guide to work on certifications or affiliate courses or suggest me companies to venture into for an entry level tech sales opportunity .
Location : Vancouver,BC or Remote opportunities in Canada.

like

Why are we as a group not so active in helping each other ? I understand there are many members who joined with aspirations to learn DS. But existing members from DS are not active. Sad sorry

likehelpful

Hi all, Does Commonwealth Bank reimburse certification cost.

like

Are there any specific resources (books, articles, individuals, courses) for someone who wants to focus on being a Group Product Manager?

like

What other careers do you catch yourself daydreaming about? I, for one, would have loved acting as I loved theater throughout my life but alas fate had other plans. What's yours?

like

Would you leave a job at a startup who is still running on investment funds after almost 5-6 years of founding even though work environment is great?

I’ve been approached my by company that one of our large clients (who im currently project managing for) is looking for a consultant of sorts, and if they hire us, I’d be the first person asked to take on this consultant role. This isn’t something my company typically offers and would greatly change the scope of my role. Has anyone ever taken on a role like this? If so, were you able to negotiate a percentage of the consulting fee? Or was it a bump in salary during the project?

More Posts

I finally plan on quitting in two weeks. I’m so overwhelmed with emotions. I don’t even have a job lined up. I can’t wait to reclaim my life!

likeuplifting

After ~20-30 min on a call, I stop paying attention.

like

Anyone knows how to open a non-profit company?

like

“– Pick one: purple or blue.

– I can’t do this, this is way too complicated.”

funnylike

We are hiring for senior IT auditors and cyber assessors to work on SOC2s, CMMC, pen testing, vulnerability assessments, and other similar projects. Boston area, medium/large regional firm. 2-4 years exp but flexible. Open to associates that are on the cusp of promotion to senior. Relatively low travel and better WLB compared to Big4. Feel free to DM.

like

Bain & Company Bain & Company Do you have any insights into what they are expecting in the second (last) round? I saw that there are two cases and a presentation. Are they more interested in professionalism than the "analytical" skills assessed in the first round? Do you have any more insights into the presentation?

Many thanks in advance

like

Anyone have advice for talking to teachers in your school that are upset with you?
My 4th grade class didn’t show up today because the teachers are upset that student behaviors that are an issue in music are carrying over to their classroom. I understand their frustration, but nothing was communicated with me. I even thought things were going better this week.

I think I’m ready to leave public accounting. Where do I even begin? (See more in comments)

likeuplifting

Is binance down? Trying to cancel a limit order and getting a fail error?

like

Just uncovered my Binance account from 2018 with shitcoins (doge, trx, bnb) now worth $3k. What would you do? Can I transfer them for free to a platform that is easier to navigate than Binance?

like

"Can you make it feel more like blueberries taste?" ACCOUNT TO CREATIVE

likefunnyhelpful

Hi DXC..

Anyone from Molson coors project..please ping me..

How many years from SC to M post MBA for GSAPers?

like

I have two questions. I have 10 years of experience in multiple sectors and I have been trying to gain a leadership position. I am attempting my PHR this summer but what are some tips in order for me to obtain a leadership position? Also, how long does it take to obtain another position out of state? I am trying to move to Houston but I don’t want to move until I am confident I can obtain a position in the city before packing up and leaving.

like
like
like

Fishes,
Suggest me laptop for freelance and learning purposes in the range of 60k-70k..

like

How long is it sustainable to talk to someone without meeting in person due to covid? I find myself getting bored because the meeting in person is what determines whether we actually vibe.

like

We bought a property and the house next door fence post is on our property line. We’re planning on putting a fence on our vacant lot. What do we do about the fence post? Since no one owns the house? It was foreclosed on and I think a bank owns it now.

Online/chatroom Colt: Smooth-talking stud, 10/10
Real life Colt: Gamer Nerd living with his mom, 2/10

Additional Posts in Excel Genius

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

What are your top Excel ninja tricks? Ones that few people know...

like

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

like

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

Anyone know what these badges are?

Post Photo
likefunny

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

likesmart

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

like

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
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

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal