I'm interviewing for a Financial Analyst role. Does anyone know what are common Excel formulas I should know?

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

Tbh I don't think NK it's about the formula. It'll be about the knowledge. Possibly behavioural questions and how you problem solve. If you've had an FA role there is month end reporting and there are aways isssuesss. Just my 2 cents though

like

Pivot tables, vlookups etc

like

Thank you!

Index match and goal seek. Cagr and NPV

Thank you!

The 3 abv are on every excel test - there are a bunch of online courses that just cover the must haves that you could bang out in 2 weekends if you get into it

Hahaha all good, thank you! :)

Related Posts

What all companies have openings for Informatica Developer for 7.5 YOE...
if anyone has any referrals pls post
Currently serving notice period....

Hello In Accenture india we have a huge opening for .net full stack developer, ASP Net MVC, ASP Net developers exp 2.5 to 6 years. Please dm me for referrals.

like

I'm currently in a process for senior associate at a Big4. The process began on July, yet between the first and second interview it took like 3-4 weeks. And between the 2nd and 3rd like 7 weeks. I sent an email to HR during those weeks asking for an update and didn't have an answer. Then it a 3rd one was scheduled three times (the manager didn't connect to the first 2) and next week I have the last interview with 1 partner. Is the timing normal? Or were they looking for other candidates or what?

S&P Global Dear Fishes,
Can someone please help me out by referring my profile for the below mentioned job ID?
I would highly appreciate your support.
Job ID: R21515
Role: Operations Analyst

Thanks in advance!
S&P Global

like
like

Anyone willing to do a resume review? Getting a lot of rejections (before interviews) and wondering if it has to do with my resume.

like

Hi Accenture people,
I have interview in Accenture today for Program/Project Management practitioner.
Any tips about Accenture interview process ??
It will be highly appreciated.

like

I have the option to leave Biglaw for in-house position at Fortune 100 for 320k TC with 10 YOE in HCOLC. This is my first in-house role and so I wanted others' thoughts on TC range for my level.

like

I have an interview with Korn Ferry for an associate principal role and am curious about others’ experiences have been with work-life balance here. Also, I have an idea of what I should be compensated in this type of role, but any insights on how they pay compared to others would be helpful. Are you traveling during the pandemic or have client interactions been virtual? Lastly, if you are a consultant here, are you on billable hours? My current consulting role is not - so this would be new.

like

Hi Fish,

My LWD in TCS is on next week. Can anyone please help me what are the formalities I have to do and clearance I have to apply for.
If someone has gone through the process recently, a step by step guide would be really appreciated.

like

I currently have 12 years of experience.
I am looking out for Tech lead / Engineering manager role in Pune.
Tech stack is Java, Microservices, spring boot
How much should I expect?

like

Need referral in siemens. I have job id as well

like

I am actively looking to transition into a tech company. I’ve worked in campus recruitment for 2 years at a construction company. I am open to any advice.

I’d prefer a remote position. I am willing to take on training or classes to become a better recruiter.

like

Currently an associate at a V30 and negotiating a partnership position at another V30. What is the correct way to maximize the pay in the negotiation as a lateral partner? I’m afraid of settling at a lower price than what they can do at the top end of the range! Do I anchor by asking for an outrageous figure or let them offer a salary figure first?

like

Any suggestions on path to crack interviews with 11 YOE ? Tech stack .net angular

like

I have an offer with a start date in November. It’s 2+ months away, but should I consistently reach out to the recruiter? I don’t know what to say though, since I have a start date, but want to keep them me on their radar.

like

Any recommendations for recruiters who are active in the region?

like

More Posts

Anyone interested in purchasing a SXSW Film badge at the early bird special cost of $895?

likefunny

I read a contract from San Diego that had some very interesting language for Special Educators. Thinking about sending it to the Union to see.

I recently got a job offer through a company that offered me the high end of what I was asking (75k) but since it is the high end of what I asked for, do I have room to negotiate? Do I have a leg to stand on if I even try negotiating at the point? I have til Friday to fully accept. I’ve never negotiated my salary but want to be sure I’m being paid fairly for this site merchandiser role! TIA

like

Just got an offer from PwC for 47.5K for SA role in Manchester. Feels kinda low considering everyone just got a 7%+ pay raise. Can anyone comment if this is in line or not? I was told this would put me above the SA band

like

Has anyone recently onboarded to Accenture and how was the experience. Wat is expected on ur reporting day n when do u get ur laptop delivered.?

likeuplifting
like
like

Looking at a Facebook people strategy role and wondering if I’d have a higher chance at getting a first round interview if I was referred by a FB recruiter in a different department? I have another friend who is a FB benefits manager but he says 9/10 referrals of his don’t get one. Thoughts?

like
like

Have people checked out Aion by Matthew Spoke and Nuco? Looks like the next biggest thing since Ethereum to me. Curious of others' thoughts

Is anyone aware of any healthcare / healthcare consulting companies based in the Bristol area (UK)? Thanks

Has anyone ever sued Big 4 for unfair firing?

Is anyone willing to refer to EY or PwC? Thank you!

like

Debating leaving and going to a different Big 4, thoughts?

like

Thoughts on Jumia stock?

like

If I’m just looking to slim down is the best thing to do at the gym run?

like

What’s a typical salary for a creative director in Miami (10+ years in advertising, but new to CD role)?

Any other copywriters write on their phone when the computer seems too daunting?

like

I put in a lot of effort to show my client properties that fit their requirements, but they ended up working with a different agent just because they wandered across an open house. I'm so frustrated right now. Has anyone else experienced this?

like

Stop asking if we can unionize after being asked to work over the weekend.

likefunny

Additional Posts in Financial Advisors

Looking to transfer into a client associate role (unregistered at the moment, but willing to obtain). Currently have ~1.5 YOE in valuation (financial statement analysis, modeling, etc.) I get that those skills could be unrelated to a CSA role, but I think there could be some similarities. Does anyone happen to have a referral or can anyone give DM me some insight into what a CSA role would look like? I appreciate it.

like

I had no idea how well people could do for themselves as an advisor. Are many of you millionaires? If so, when did you reach that milestone?

like

What the heck does your day look like? I mean really do you do anything anymore other than take client calls and screw around online?

like

The son of a friend is an advisor and is giving up. He has approached me about taking over his book, evidently only about $1.5M.What would be a fair amount to pay for this?

like

How much did you spend on client lunches/dinners last year? I’m at $3,600.

like

Signs someone is not cut out for this industry?

like

Booyahh, landed hedge fund number 2 for IPOs.

like

Just lost out on two potential clients because they said they were concerned about how many clients I have. Currently have approx 250 households ( Ed Jones speak for mailing groups). I never thought that was a lot but now I am reevaluating. Curious as to how many relationships you all manage.

like

I already am a CFP, now thinking about getting the RICP. Who has it? What's the study time required?

like

Dumb question: can I set up a solo 401(k) through my RIA? Or does that type of account always go through a B/D? Cont.

like

It's March, and I have done a lot of seminars in Jan and Feb. I've gotten a few clients but would like to increase AUM drastically! Any books, sites or advice on what I can do for marketing?

like

What is your go to watch in the office?

like

Is it better to put a “tl;dr” before or after the main bit? I know it makes more sense to have it before but I can also see it being slightly funny at the end of an email. Help

What is your close ratio with walk ins/call ins?

like
like

I spent abt $25 a client last year for gourmet chocolates and don't think I would do that again, think 4 out of 30 families even told me they received them. Anybody have gifts that were home runs?

like

Wells Fargo merger news. What’s it mean?

likehelpful

What are the best words of encouragement you've received when feeling discouraged about this job?

like

Anyone looking for a succession plan or looking to sell their book? CFP with a decade experience in Wealth Management.

like

I think I’m addicted to diet soda. I don’t drink coffee or alcohol but probably 60 ounces a day give or take. I drink it for every reason (or excuse) you can think of. Continue...

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