Wait until they see INDEX...

Post Photo
likefunny
Posting as :
works at
You are currently posting as works at

An SVP still knowing how to use excel? Blasphemy

like

Been a while since I modeled!

Indeed. For starters, wait until they see INDEX MATCH and nested IF statements.

like

Wait until they see Power Query and Power Pivot

like

Related Posts

like

Hello, after doing some research I believe I’m being underpaid. About 4 months ago HR did a market analysis for my role. They bumped my salary for about $2k. I’m a mid-level Executive assistant with 6 years of experience and currently supporting 5 executives at a fortune 50 company. One C level and 4 Vice Presidents. I’m currently making $61,000 with bonus included. Based on my research I should at least be making $71,400. I have a check in with my boss tomorrow and I am asking for a raise.

like

Hii all ....
Can anyone give me some info regarding project allocation in tiger analytics?
It has been 3 months since I joined...still not allocated to any project.....
I am little worried about the recession news coming......

like

Does JPMC provide child care reambursement ?
JPMorgan Chase

like

I hope everyone's day was full of food and loved ones...thankful for this bowl and the great city of Pittsburgh...cheers!

like

Any insight on when hiring for FAAS west will start again?

like

Anyone else hate case studies. I understand what they are trying to assess, but I don’t feel they are the best measurement of ones ability to problem solve. I don’t have a solution though, so I’m really just complaining.

like

Anyone here who made the exit from Big 4/MBB consulting to a VC? If so, I’d love to hear about how the experience is so far. (Not to mention the WLB and comp!) I’m considering a career change but have no one in my network I can go to for insights. Thx! 🙏🏾

like

Anyone in transactions advisory at Deloitte, KPMG, PWC or Valuation at Duff & Phelps? Would like to understand the culture there. EY is not working for me.

like

Just had someone reach out asking me to run for a seat on the school board.

What have you heard or what do you think about such opportunities, particularly when the day job eats up so much time?

likeuplifting

Loving the Olympics finally going on. In my eyes, the top sporting event. I say Olympics, World Cup, then the Super Bowl.

like
like

I've been following Coforge LinkedIn page, and I have decent offer from them. In one call HR said we will be moving towards 5 days work from Office, to which I said I don't mind. Now that aside, their LinkedIn posts everyone at VP SVP levels are joining.. seems like they are growing very fast, as hiring at such high Positions happens only that time.

Question is - whenever I compare Coforge with any other people say avoid Coforge.. Why????

like

Thinking of switching over to a non-creative role but not sure how my soul will react. Anyone here done it? What was the outcome?

like

How’s the pay and WLB at the corporate finance/IB subsidiaries of the big 4 compared to traditional MM IBs?

like

Any insight into life as a patent agent with stern Kessler? Are there directors to avoid in the chemistry area?

like

I have an MSN with a focus in informatics. Recently got my board certification. 3.5 years experience as a nurse. 8 years total in healthcare. Becoming very frustrated with my organization and the slowness of our analysts in getting anything resolved. Feeling like I’m at a dead end and thinking about switching routes entirely. Just wanting others to share salary and location and maybe give me a little hope that you have a better team where you’re at that actually get things accomplished.

like

Has anyone had experience trying to bring their parent to Canada permanently? I’m looking to move from Asia - just lost a parent, so need to find a way to stay with my other parent. how does the process work? TIA!

like

Additional Posts in Excel Genius

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

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

If you have never created a macro, any tips on where to start? Any good Udemy courses or YouTube videos?

like

I have 6 months left until I start my first consulting job, I want to use (and improve) my Excel skills via volunteering, where should I look to find such opportunities? (UK)

like

Any book recommendations on excel modeling for real world business applications?

like

What are some of the unique use cases you have leveraged excel for?

like

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

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

How can I update the range in one location for a tab whose data source, a second tab, is connected to SAP and the range updates on the source tab depending on quarterly activity?

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

likehelpful

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

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

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

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

like

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

Alt W H

For your enemies lol

likefunny

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

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