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

Anyone familiar with the Client Partner role at Elephant? Curious how it differs from ‘traditional’ Account Management role

Hello Fishes,
Can someone please guide me regarding the interview process at
Tavisca? How many rounds are there and how to prepare for it?
Thanks. Tavisca JPMorgan Chase

like

International tax senior associate- Deloitte

I have an interview with Deloitte next week for senior associate Internacional tax in California. How much salary I should expect? I am sure this question will come up and I don't want to underbelly myself. Currently I am a senior at other Big4.

like

Opening my first CD.. thinking of Marcus.. any suggestions?

like

Hi Fish,

Anyone interested to move in Product Management domain and looking for career direction and coaching, DM me.

I am happy to help you for Mock interview preparation, Resume Building and referrals.

Building Product Manager.

likeuplifting

What't the pay scale for JPMorgan Chase for someone who has 10 years of IT experience, and is interviewing for a Product Owner position?

How much is the bonus?

Any how many rounds of interviews do they have in place?

Also, any help around what do they ask will help.

like

Anyone have any familiarity with facebook’s recruitment process? How much does a referral help?

What is normally asked for a Business Intelligence analyst role at GS?
The hike offering is quite low compared to other companies, so what are the other employee benefits?
How much is an average yearly hike one can expect?

Hey y’all ! Could anyone help me with a referral at National Grid ??? I’ve applied for the EA role. Thanks in advance!

like

What is the interview process for Medtronics for QA position .

like

Anyone know if any of the MBBs are hiring experienced hires in India?

like

Hi, after each interview, the recruiting agency will call me to get feedback and ask me if we're still good on X salary?

What's a good way to not agree on a set number on these calls until I get my offer?

like

Looking for any remote HR opportunities available. Unexpectedly lost my contracted role due to funding. Hopefully i look to be SHRM certified but i bring 5 years of HR/ER experience with Diversity ..

like

How do I measure what I'm "worth" in the market? I know YOE play a role, but I don't know how to measure based on perf or whatnot. What makes one person worth more than another for the same role?

like

I had my final round of SDE1 interview at Dehaat 3 days ago, feedback came back positive and HR also had salary discussion. However just next day I got mail saying Dehaat has temporarily frozen hiring process. Anyone working at Dehaat can tell me what is happening at Dehaat currently? Was this mail just for me or the entire hiring process is actually on freeze.

like

I’ll be promoted next year to senior but I’m in a niche role where I don’t see myself long term. Should I make a job switch now or should I wait to get promoted to senior? I currently have 1.5 years of experience.

like

Looking to help a first year attorney lateral to a firm in LA that specializes in L&E defense, or has a good practice team. Any recommendations on teams that have a hiring need?

like

EY TTT exit opportunities

like

Hi, I got selected in S&P. Hr gave me an link to apply for some position but I am not able to do login to that link

Facing issue like user name doesn't exist in tenant s&p global.

Did anyone face the same, if yes could you please help me on that.

More Posts

What is with people not knowing how to read signs? We have a huge one that says “NO CASH ALLOWED” and I still get asked almost everyday if we take cash

like

I think I want a sub

like

26/F Toronto, Indian, dangerously independent
Bored of insecure men on dating apps 🤷🏽‍♀️☺️

likefunny

Hi All

I am having 2.7 years of experience and looking for a functional testing role
Can someone please refer me in Oracle??

Tools: Siebel CRM, Jira, Bugzilla, HP- ALM
Skills : System Testing, Regression Testing, Brm testing

Please help

like

Any advice on my current Vanguard Portfolio ?

Post Photo
like

How can I enter into a MNC with digital marketing and SEO background?

like

You guys getting pizza parties?

Post Photo
funny

Thoughts on moving to Calgary for cheap housing?

like

Need one spacious and semi furnished or furnished 2 bhk flat in BEML layout, Brookfield. Please suggest if there is any information.

like

Hi all,

I have recently moved to Pune. I am looking for 2 BHKs. If anyone has any contacts or know good places (areas) to stay, can you please share with me. Thanks!

28M in NYC area. Chat with me

Some recent political cartoons...

Post Photo
likefunnysmart

How do I get better with frustration with family (even though warranted)? Therapy?

like

Hiii all. Anyone working here in a Digital Transformation Project??

like

Case load= malpractice? Small plaintiff’s firm of 25 attorneys. I was a 2 year associate hired and given 50 active files in pre litigation status. 9 mos later a partner quit and I inherited 45 more. I got up to 105 files. Now I hover at 85 active files in varying stages of pre lit. I asked managing partner for help and was told to settle more claims to lessen my load. Is this what people consider negative work culture?

like

Hi Fishes, need urgent help

Gartner offering 15 lpa + jb, UKG offering 16.5 lpa + jb, which one should I select, I am concerned more about technical growth and long term growth rather than short monetary gain. Please help to decide.

YOE: 2.1, Tech Stack: Azure, Java, Spring Boot

like

Hi everyone!

Can anyone provide a referral for a senior technical program management role at
Disney Streaming Services?

I’m currently the head of operations for a start-up and have over 6 years of experience in technical program management.

Any help is greatly appreciated. Thank you!

like

Anyone seeing big declines in FB/Insta performance? Across several clients we’re seeing CTRs or other ad engagements dip starting in July.

like

What is a good salary range for a Principal UX Designer with 15+ years of experience working in either Finance, Tech or Media industry in NYC?

like

How can I switch my project in Siemens?

It has been only 10months. As I am a .Net Core web developer they have assigned WPF project for me and I really don't have experience with the same , nor do I want to work in this technology.Siemens

like

Additional Posts in Accounting

So I'm not a top performer. Definitley not the smartest guy at big 4. But some of the questions I get from very experienced seniors are just so basic.

like

You ever get so sick of prepping for a walk through you just say fuck it and wing it? I mean really, the pressure should be on the client to talk about the process, not on us 🙀

like

Do a lot of seniors in the advisory groups work weekends? I am coming from a group that has busy seasons sometimes we don't get a day off for a few weeks before the deadline. 80-100 hour weeks for me.

like

I'll probably get shit for this. But please explain to me the purpose of letting women off the elevator first. Half of the time it's ridiculously inconvenient.

like

Any advice on keeping my marriage healthy during busy season? Seems like this time of year is hard both at work and at home.

like

Can I be a real estate agent while working at PA? Is it against firm policy?

like

Anyone done the Netsuite Solutions Consultant Academy. Got contacted by an Oracle recruiter today about it. Seems really good but would like to hear from others first.

like

At Deloitte, Is there a finders bonus for referring and bringing a client?

like

Seriously! A coworker is talking about her degree in history and she wrote her senior thesis on June Cleaver. How does she work at a B4? Of course, her Dad was the Partner's son's HS football coach.

like

My litecoin purchase has been pending for over 24 hours what gives

like

Anyone been to Bangalore? Recommendations on things to do?

like

Some of these recruiting salary offers are offensive.

like

With as miserable you all sound I am surprised there's not more suicides or workplace violence.

like

So bored with my job, but sticking it out til manager and one busy season for the title and milestone bonus, is it worth it ?

like

Just joined the inclusion council in my office. Any good ideas for a fun office event??

like

Passed the CIA. 🍾 I'm rolling deep in the letters... CPA, CFE too. What should I do next?

like

There's a ton of self help and leadership books out there to help people in their careers. If there was one that was written front the lense of a public accounting, would you read it?

likehelpful

How much does a big 4 marketing director make in the Bay Area?

like

Anyone have an idea of how long it takes for the background check to clear at KPMG? Also, do they send you an email or something to let you know it’s done?

likehelpful

I resigned yesterday evening.. today morning conversation with counselor and People Consultant went very cold... anyways piece out..

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