Interviewing for Senior Financial Analyst position. There is an “excel test”. What should I brush up/make sure I’m familiar with?

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

@TM1 why not ask a simple question so that I can be prepared for an interview instead of missing out on a job because there was a tip I could have easily googled and made myself familiar with beforehand

like

Check out how to make a football field chart. Thats what they asked me to do

like

If you aren’t already, I would say at the very least understand pivots, vlookups, hlookups, and sumif formulas

like

The question should be “if I am worried about an excel test should I be applying for a Senior Financial Analyst position or enrolling in an excel class?"

funny

Thanks SC1. Familiar with all of those. However, this would have more of a modeling portion and wasn’t sure if there were any other things I should be aware of.

like

I can give you a thorough excel class for $500. Refundable if you aren’t happy. Let me know and I can share my info (should take 4 hours to teach - in person or webex)

I would review some of the basics. Took an excel exam a few years back. I got some of the very easy questions wrong. Like Copy, Paste, Autosum due to heavily using the short cuts - ctrl c / v, alt+=.

Related Posts

💸 What should I be asking for if I move to London, UK for an ACD position? Recruiters are giving me a very wide salary range. (Got international awards and 8+yrs exp)

Got a first round interview with AlphaSight out in San Francisco. Any tips or advice?

helpful

Actually, I gave Interview for BackEnd Developer @ Itilite. I was selected in the interview process (2 Tech DSA Based + HR) and got a mail stating that our interview panel is really impressed with your domain related expertise in order to proceed with offer negotiation please submit your documents. Now after 2-3 days of document submission, they came up by saying they cant move forward with my candidature.

I am still amazed how can they do this after asking my documents.

like

Hi All

Can anyone please guide me to # Axtria about WLB, Yearly Appraisal, Culture, and Career Growth? I'm giving an interview for a senior account manager.

like

Hi,

Anyone from
EY, I need a referral. EY

like

Long time agency person, considering joining an in house crisis team at a global company. Wouldn’t be my first time doing crisis work but would be my first time doing exclusively crisis. Can any full-time crisis people give me the good, bad and the ugly of what this would make my life look like? What questions do I need to ask during hiring process to catch red flags? I already work long hours and do constant issues management but this role would pay way more and is in an industry I like.

like

Recently been invited for an interview with Bearing Point. Interested to know what type of work they do in the UK? Also what is the typical working arrangement, working mostly on-site, in the office or remote?

like
like

Hello, I have an interview scheduled for the position of Product Manager for Mumbai location. Could anyone please help me with details like culture/benefits and pay at ICICI?

How many offers did you receive? out of how many interviews you had? Need some hope.

like

Anyone willing to give me a referral at Microsoft?
I have the job id

like

Who hires junior strategists? Where should I start looking? I’m loving my planning internship right now, but I want to apply elsewhere in case I don’t get an offer, but I’m not seeing anything open.

like

Could anybody throw light on variable % in oracle gsc for consulting technical manager position? Is it a part of ctc? How much of this we can expect on an average for an year?

like

So, in the past few months I’m being contacted by recruiters, mostly email me or call me directly on my office phone or email. Is this normal and is it good or bad in the field?

like

How do I find headhunters that specialize particularly on junior strategists? Thanks for any help

like

Hi All,

One of my friend got interviewed in Deloitte and she was asked to rethink her salary ask in the HR round. She reduced it to 1L less than initial ask. Now the status is in benchmarking approval. What does that mean ? Will they release the offer letter ?

like

Received an email about doing a HireVue with Deloitte for an M&A internship position. Any advice or tips on how to prepare/questions that will be asked? Any help is appreciated!

like

I prepared a presentation for an interview with a sales leader, it went well and I was offered a final interview with regional manager. The sales leader I interviewed with gave me a bunch of feedback, but said to find out information about tech stack, which I for some reason, didn’t consider. I come to find out that deep, hidden within the website of the hypothetical client, they use the service already. Do I roll into the final interview and play dumb or do i present and then come clean?

like

More Posts

I think the Matrix is broken, I just had a déjà vu.

funnylike

Best way to find a roommate? Looking to move mid sept-early October and don’t know anyone else moving.

like

How is the Deloitte India Corporate Financial Advisory team? In terms of work and culture. Please help guys

Are any members of this group producers at an independent agency?

like

May I know why are we not allowed to eat in shuttle? I was stopped by security guard cz I was eating ... I was hungry,packed up my food,running out of coding work . .. Strange !!

like

Is TCS IBegin portal having some issues ? I'm unable to login

like
uplifting

Hi,I am looking for a referral in Virtusa. Please let me know if you help me with referral, I will share the relevant details with you.

like

Can sumone provide a reference for a person having 12+ years legal experience in multiple fields including litigation/consulting/advisory etc, in & around Delhi NCR?

like

Interviewer is being recruited for high level remote position, but when joining a panel interview, the candidate does not cut on the camera. Big red flag as scamming for jobs since remote culture grew is becoming a big trend

What are your favorite management books?

like

have a call with a capgemini recruiter tomorrow. what should I be prepared to talk about?

Consultant from Australia just landed in Houston. Staying downtown but wow is the city centre dead on weekends. Are there any nice stretches of avenue or outdoors where people congregate on weekends?

What is this grade and level in JLR india - data science role
GRADE:
D - TM5

What is a normal comp package for Google level 6 Cloud partner services?

like

Hi all, I’m not sure if this is the correct bowl to post in but could anyone that works at Truist Financial Corporation look up the salary range for their Intelligent Automation Product Owner - Agile role?

like

Anyone work at Hulu that would feel comfortable referring me? Lmk! Thanks :)

like

Additional Posts in Accounting

My SM thought my staff should get 3 instead of 4. I rewrote the review, argued with SM and got 4 approved. Staff may not know what I did, but I feel proud of myself, just wanna be fair.

like

Highest number of billable hours you have seen in a year?

like

Any advice on breaking out of accounting roles? I am in restructuring which I thought would be more interesting strategy work but it’s been just compliance, legal, little modeling. Corporate roles don’t seem to have any interest in the experience either.

like

Has Deloitte tax heard anything about layoffs yet? Just saw the news about audit

like

Met this really cute guy at national training, exchanged phone number, but he's heading back to home office tomorrow. Advice?

like
like

Thoughts/advice please. I’m thinking about leaving public less than a year in. The initial plan was to stay at least till I hit the year mark so I can get my work experience for CPA and then leave but I just don’t like the work and want to explore my options/other service lines. Is it a dumb move to leave post spring busy season? I’m not expecting some crazy raise or anything, just another experience. Also if I leave, how do I go about getting my work exp sign off from my ex-firm?

like

Can someone walk me through a provision

like

Is it possible to transfer offices more than once within the same company and LoS?

like

Are other big4 firms getting mid year raises right now?

likefunny

Anyone have the Jabra headphones? Are they worth it to purchase with the firm discount or wait until we get them for free?

like

How bad do you have to be to get fired after your first busy season. Asking for a friend

like

I’m in tax and failed REG for the second time... it was by a few points, but still. I’m not really sure what’s going on. Super bummed out but taking it again soon Hopefully third time’s a charm 🙏🏼

like

Does it burn a bridge if you interview at a place, receive an offer but then decline?

like

Two in one special:
1. What gets you most excited on a weekly basis?
2. One aspect of today's society you wish you could change?

like

They tell us not to eat time but then say if we go over the minimum hours that work will have to be reallocated...why don’t the higher ups understand that there is no one to reallocate the work to...

like

My utilization is 90% but all of my clients are small jobs. Does that look worse than someone who works on the larger, higher revenue generating jobs with all else equal (utilization/performance)?

like

Just finished my first year in audit. Recruiter reached out to me for a role with a 30% bump in salary. Total comp included it gets closer to 45%. I actually enjoyed my first year and especially being done with busy season now feeling pretty good. Not at all actively looking to leave, but just looking for advice on if I would be crazy for not pursuing an opportunity for so much more money at least a little further. Really what I care about is my long term career more than anything

like

we've got a new hire who wears dress clothes to the office on saturdays. fuckin weirdo

likefunny

Who else loves blowing the budget

likefunnyuplifting

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