{ "media_type": "text", "post_content": "Interviewing for Senior Financial Analyst position. There is an “excel test”. What should I brush up/make sure I’m familiar with?", "post_id": "5b157265761c94001830e927", "reply_count": 7, "vote_count": 1, "bowl_id": "564a5cdb94887803001dd07c", "bowl_name": "Accounting" }

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

Can anyone help with PwCs interview process for SAP Manager positions? PwC

like

Honest question: when you see a job listing like so, is your reaction... A. Good for them insisting on BIPOC; this industry needs more diversity & hiring the same middle aged white folks doesn't cut it anymore. or B. YES, every agency/brand should champion diversity but is it fair, right or even "legal" to overtly dissuade white people from applying? Can't they just "hire the best candidate" regardless of race/gender/etc? I get B but I'm team A because the 2nd ? in B hasn't exactly..worked.

Post Photo
like

Do you always clean shave for an interview? Have one with EY later today for SC2 and I think the stubble (clean neck) helps me hide my baby face a bit so I’m leaning towards not clean shaving.

like

Where are the best resources to learn about PE, the day-to-day role, and relevant opportunities?

like

What is the culture like at Facebook? Thinking of exiting into a product owner role or just general pmo type of role. Good company to work for?

like

Has anybody messed up the math during a FAANG interview and still gotten an offer?

likefunny

Is this accurate: Final interviews are mostly about the personality and culture fit test more than technical skills test?

like

Interviewing tomorrow for my dream job. Wish me luck🍀

likeupliftinghelpful

Cancelled a phone interview 5 hours before the time it was supposed to start by emailing the scheduler and recruiter, thanking them for their Time & asking to remove me as a candidate. Did I nail the

like

Hi Fishes, I am currently working with TCS as PL/SQL Developer. I have 5 years and 6months of experience. And my CTC is 6.47LPA (Including 54k variable pay) . I have cleared technical round interview at Infosys. Waiting for HR discussion. I am expecting 13LPA (including 10% variable pay). Will they offer job with this package? Or this expectations is too high? Thanks in advance

like

Are people still applying after only 2 years in consulting? Seems common for MBB but I wonder how you built solid recommendations / experience in so little time post-undergrad.

like

4YOE @Amazon & trying to lateral to a similar role @FAANG. Have my undergrad GPA (3.8/4) on resume from top 15 school but colleague says to take it off (looks silly). If it’s a good school & high GPA, why ever take it off your resume? Even if 10 YOE...can’t hurt?

like

I applied for a senior accounting role and received a take home assignment. What do company’s expect to see from a take home assignment documentation and technically?

like

Hi All, What kind of questions I can expect in KPMG interview for Angular Developer position having 2.9 YOE. Any suggestions ? Thanks in advance

like

Please suggest me some recruitment case studies to prepare for an Interview.

like

Hi Fishes , I need a referral in EY . Please comment if someone can refer me . Thank you in advance.

like

What’s the most dramatic jump in salary you’ve managed? At what position did you go from feeling underpaid to over/appropriately paid?

like

Have any Legal recruiters helped place a junior (1-2 yr.) Staff/Diligence Attorney mainly focused on PE transactions/M&A at a V20 firm into a traditional partnership-track junior (1-3 yr) Associate position at a peer firm’s similar practice group? Any suggestions to approaching these lateral opportunities?

like

I just started a new job a couple of months ago and it’s not a great fit. The health of the business wasn’t what they had led me to believe during interviews. I’m looking for new opps but how...

Additional Posts

Sent an email to my network looking for a few points of research to round out a simple deck and am now being hounded by a team trying to sell their services to my client who doesn't need it. #sharks

like

Can anyone help with PwCs interview process for SAP Manager positions? PwC

like

Honest question: when you see a job listing like so, is your reaction... A. Good for them insisting on BIPOC; this industry needs more diversity & hiring the same middle aged white folks doesn't cut it anymore. or B. YES, every agency/brand should champion diversity but is it fair, right or even "legal" to overtly dissuade white people from applying? Can't they just "hire the best candidate" regardless of race/gender/etc? I get B but I'm team A because the 2nd ? in B hasn't exactly..worked.

Post Photo
like

Do any of you experience increase of body temp throughout the day due to anxiety? I feel like I wake up okay but as the day progresses and there's more stress and anxiety, I get hot and it's like I'm boiling inside. I checked my temp and it's normal. Could this be any other medical issue and not just stress?

like

What is the average amount of salary junior designers at Google make?

like

Alaska airlines MVP Gold 75K status in here. I Booked an intl ticket using miles+$200. The flight is operated by AA. Can I cancel with full refund?

like

Do you always clean shave for an interview? Have one with EY later today for SC2 and I think the stubble (clean neck) helps me hide my baby face a bit so I’m leaning towards not clean shaving.

like

Been doing a lot more 401k biz and want to eventually do that alone. Want to complement the 401k with group DI/group life. Is it possible with smaller companies? What about group life? Any experience?

like

McKinsey Analytics: how much M&A work do you guys do? are there people devoted to M&A or are teams organized differently? currently work in B4 analytics and looking at MBB firms.

like

Asking people who went from big 4 to mbb, is it much more “difficult”? If so? How much more?

like

All this stuff with Kapernick and taking a knee and all that has got me wondering if we could participate in "corporate disobedience" to protest our agencies' lack of diversity.

like

Where are the best resources to learn about PE, the day-to-day role, and relevant opportunities?

like

When I mentor students as they submit to award shows

Post Photo
likefunny

At what age did you save your first billion? P.s. I’ve spent two months at a big 4 how do I get to McKinsey?

likefunny

Comp communications are coming up. If I am unhappy with my raise or VC can I push back? Have you done that successfully without feeling like it gave you a bad reputation? My raises and bonuses have been good in the past and maybe I was naive but I’ve never thought to ask for more.

like

Any ideas on how much raise I can expect on promotion to Manager? Currently make 122K as senior.

like

Will Big 4 let you stay as SM if you don’t want to make partner but are still hitting SM targets? Once you take the promotion BS and partner-promotion-chasing out of the equation SM is quite fun!

like

I am looking to switch careers. I have been in my current career for nearly 20 years. I need a change. I have masters degree in instructional technology, health care administration, and English. I am working on trying to work my current skills into today's job market. That is more difficult than I anticipated. I guess I'm wondering if there really is anything out there to switch to? I feel lucky to have a job, but it is getting very depressing and difficult to get up for work.

like

What is the culture like at Facebook? Thinking of exiting into a product owner role or just general pmo type of role. Good company to work for?

like

I want to start taking the hijab - going back to work after a break and am client facing. Should I inform my partner beforehand? Anyone who has done that before?

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