{ "media_type": "text", "post_content": "An asset management firm is asking “what my favorite excel function is” for an internship. Any ideas? And why?", "post_id": "6005258e1297d7002415d54e", "reply_count": 12, "vote_count": 1, "bowl_id": "5988685d311f0a001042963a", "bowl_name": "MBA Applicants" }

An asset management firm is asking “what my favorite excel function is” for an internship. Any ideas? And why?

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

“=today() because i rarely have a clue what day it is”

like

vLookup

likefunny

Goddammit HR. Did they really run out of questions to ask candidates?

like

Tell them you don’t trust the SUM formula and manually use “+” to add things up. They’ll respect your work ethic and attention to detail.

funnylike

Lmao

#REF!

likefunny

Pivot table! Helps you quickly and easily make sense/recognize patterns in large datasets

likesmart

Relatively speaking haha

like

If formula. You can plug everything into if

like

Vlookup and if you really want to get cute hit them with an INDEX(MATCH()) they’ll hire you right then and there.

like

I love this! Hahaha

Related Posts

like

How many people are suddenly managing an intern they didn't even ask for?

likefunny

Thoughts of an intern showing up with a goyard bag?

like

Little sister is starting her internship soon. Will be making some decent money. What financial advise can I share with her? Should she open an IRA account or any other account? Will have about $20k-$25k in student loans when she graduates college. Very minimal savings so far

uplifting

Anybody in PwC recruiting? Do you know how one can apply for internship in PwC?

What made your internship special and why did you want to join your firm? Think, fun things or small touches that went a long way, too.

likehelpful

Just finishing my first week in as an audit intern and genuinely I have no idea what I'm doing or even a general idea of the audit process. The senior associate left the engagement last week so it's just me and an associate, and they don't have time to give me instruction. Am I stupid or did the e-learns not prepare me for any of this? The training told me I'd be auditing cash but I haven't even touched a bank reconciliation.

likehelpful

Our intern comes in 5 days a week and a lot of the time I have nothing for her to do. Any good long term projects she can do during down time?

like

SwagUp Finance director - $175-190 5-7yrs exp Billing Manager - $100-120 3-5yrs exp Senior Accountant - $80-95 2yrs +CPA lol Accounting Intern - $15-20/hr PT All remote. HQ in NYC

likehelpful

I'm going to be in a tax group in the summer (intern) and was wondering how a specialist tax group would fare in this economy? It's under the tax umbrella but has consulting elements (m&a tax)

like

Recently, I have applied an internship at EY, but I didn’t received the assessment test. Does anyone know why?Thank you!EY

like

Am I making a mistake? Thinking about signing with Strategy& and giving up my 2nd year bschool reimbursement ($80k) from my internship.

like

Is taking an internship at a very good/very big agency worth It? Any horror stories of not getting a job and screwing yourself after an internship concludes?

Have you ever had a crush on the intern? Women is a manager and intern is a guy?

like

Any NYC CD’s who have time to grab a coffee and take a look at our book? We are a junior team from the Netherlands. We just finished our internship at Grey and are on exchange at the SVA.

like

That moment when your intern thinks they're above ordering dinner for the team - know your place.

like

An intern who sits near me keeps loudly burping....... really wanna tell her to stop. Do I do it?

likefunny

Anyone here leave Deloitte/PWC/KPMG, go to B-school - intern at better consulting firm like McKinsey Bcg, and get school paid for by them? Sounds like a smart move to me

like

What is the best way to apply for internship at big4? Go to a recruiter on campus or apply on their website. Seeking internship.

like

I need to know if I’ve pigeon-holed myself. I have an undergrad in music business, and got a lot of good experience then. Worked in live events for 4 years before returning to law school, intending to practice in entertainment law (specifically music). Got a summer internship at a boutique entertainment firm, but no offer due to the small market. Moved to a larger market, but I’m not in one of the “hotspots”. I’m in-house currently, and have moved up quickly. (Cont.)

like

Additional Posts

My company is looking for Sr. Product Designers with 3+ Years of experience. Anyone who wants to apply as a Product Designer (1+ Years of Experience) is also welcome to apply. Scaler Academy is one of India's top ed-tech company and has been growing exponentially since the past few years. I have been working here myself for almost an year now and I love the company ethics, the design team is full of talented people. Anyone interested in applying may please reach out to me on LinkedIn/Instagram.

like

The more pedestrian your intellect, the better fit you are at D Heard of a colleague with an FRM charter being laid off today. Overall excellent person. And you won't believe who they promote year after year.. the character, curiosity and quality of the lifers Don't join this firm if you for a love of learning and to be inspired. Join if you are a middling who wants a good brand to hack ahead in life and rise above your station

likefunnysmart

Wharton EMBA worth it? Late career starter so limited white collar experience but interesting background/past life. Also have kids to support so can’t do a full time program. Want the MBA for career boost ($), as an entry to faang/MBB and to have more security for future opportunities. Worth it? Does the EMBA have the same faang/MBB recruitment access and weight as full time?

like

How are people "networking" now that we are wfh? I mean, you are barely even aware if people still work in the same company. Previously, you at least saw them every now and then at the office but now... They could have fired half the company and I wouldn't know

likehelpfulfunny

Has anyone taken disability leave, and then used it to look for jobs? How does this work legally?

like

Best office chair for 200 or less? (On a budget)

like

I am so happy to not be grinding out 1065s, K1s, or 1120- RICs anymore . This role I’m talking to cpa firms about outsourcing work, tax software companies, mapping data, educating client representatives about tax issues, I’m making 30% more , less hours. Someone change my mind here with work being outsourced to India and automated - is the accounting profession about to change ? Especially public accounting ? I hated getting back some review points on returns .

like
like

What is the salary range of a 3rd year senior at Deloitte tech consulting like? I think you guys are paid much better!

How good at Excel so I have to be if I’m considering MBB? (Any resources to get food quickly) ?

like

Am looking to start a relationship w/ an airline. Which one has the best rewards program. I'm open to United lol

I switched jobs and I’m stuck doing boring, tactical briefs that don’t require real strategic thinking. I love qual research and connecting the dots with things happening in culture. Anyone have any leads on strategist/senior strategist jobs in NY that I can escape to before I become a hack?

like

When based in a city like NYC with multiple hubs, how do you think about the airline to chase loyalty on?

like

I interviewed for a job I really, really, really, really want today… Send me some good vibes please! 😬

likeupliftingsmart

Any info on when travel from Europe to US will be open again? Have flight end of July and not sure if I should cancel

like

Is there a reliable/accessible salary research resource out there? Trying to figure out associate salaries at local big law firms (specifically in Kansas City: Polsinelli, Bryan Cave, Shook Harry Bacon, Lathrop GPM, Dentons, Stinson).

like

Slalom manager pay ? With and without MBA? Are the long term pay scales just bad compare to big 4? I don't get why more people don't switch

like
like

What do you think of ServiceNow HRSD? Am about to be offered a role as business analyst in SNOW. Need to get system administrator certification.

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