I have an excel test coming up for a financial analyst interview at a tech company. The role’s daily responsibilities don’t involve building LBO nor DCF models, etc. More focused on FP&A forecasting. What should I brush up on in addition to pivot tables, and v/hlookup? Ty

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

Index match

like

Use sumifs and countifs even when you have a single variable so whenever you have several you are used to the syntax

like

Agreed with this. Additionally, sometimes your analysis changes. Having to move the parameters around becomes burdensome

Not in finance but sumif, countif is always useful

like

Xlookup, index match, sumifs, aggregate, table nomenclature, and charts. If you really want to impress learn spill arrays and lambda functions.

like

Not all Excel users have Lambda yet. Would add Correl and Forecast to that list for an FPA role.

like

Agreed with the above functions mentioned. Sumifs will be your best friend in what sounds like cash flow forecasting models. Brush up on using DPO/DSO to forecast operating disbursements/receipts. If you really wanna knock it out of the park, read up on how you’d forecast differently when paying vendors via check vs wire (checks take time to clear and cash doesn’t leave bank until vendor decides to cash it)

Related Posts

Any job opening in Bosch Credit Suisse for risk management, Vapt, threat modelling, aws, security architect
Pls let me know.

like

Hello folks I’m working at Amazon currently as an Quality Auditor non tech in retail vendor department. I’m looking for a change. Can someone tell me if flipkart is hiring for any suitable job ? I’m also pursuing German language course.

like

Hearing in a bunch of places on cycle starting to kick off. My firm getting ready at any sec to begin interviewing. For any interested candidates, would be prepped and ready to go at any time! Best of luck to all!

likesmart

I am considering an offer for an AE role (UK-LDN) where the base is £42k & OTE is £70k. The Regional GM has verbally promised to move it up to £50k base if I perform well during the probationary period, but I can’t have it in writing on the contract. I’ve tried to counter offer but they said I’m currently maxing the salary band (L4). This role is exciting as I’d be the first UK employee, doing the full sales cycle & more but I had the same base and ote as an SDR. Is it too low? Do I take it?

Openings at VMware interested please DM

Post Photo
like

Beginner video editing advice wanted - I’m working on a personal side gig project. As part of that, I’m recording short interviews with people currently using a camera and/or iPhone .. (cont)

I am a Business Analyst. I have 10 years of working experience in India. In May 2022 I will complete MSc Business Analytics from Maynooth university.
In the past I have lead a team of analyst performing multiple activities like sales analytics, web analytics on Google analytics, I have also worked as a scrum master in certain projects
I have worked with tools like tableau, power BI and now alteryx any suggestions for the job role I should look forward to?

like

What would you do?

Industry accountant with 5 YoE, can move into senior position with $100k base, or lateral move into big 4 as associate in assurance AWM.

Interested in capital markets, PE, investment...Senior role is unreleated to these industries while PA role could potentially open doors? Just would hate not getting that salary bump after I can finally start seeing some real money after 5 years.....

Also potential advisory role in regional firm but nothing concrete...

like

Hi all, I’m negotiating my offer for a senior SE role. I see online that average TC is around 170k TC (70/30 structure). Is it reasonable to negotiate higher? Or is the pay structure pretty rigid per level? Also, any chance you think I could negotiate for RSUs? I am in Atlanta if that helps.

likehelpful

We interviewed a great candidate, extended a verbal offer and she accepted. We sent the written offer a few days ago but she hasn’t opened it or accepted (it’s expiring tomorrow). Have you ever had to follow up? How did you handle it? My company is small with no HR, so I have to handle the hiring myself.

Hi Fishers,
Need your inputs please. I have applied for operations senior analyst in
CBA.It says Support ITSM operations. what is job role more about business operations or fraud, sanction compliance related. Please help. Any information will become a knowledge for me.

like

I have been interviewing at Tavisca for a month long, thanks to there recruiter, already tole my expectation upfront, Now after all the tech rounds, HR round happened and told again my expectation INR X lpa Hr was like ok, will go ahead, now after someday, he says that we dont have budget and cannot go further. Then I told them I already hold an offer and will share which is INR X+ lpa, After trying for few more days finally they told that they can offer INR (X-10) lpa, Looked like a joke to me

like
like

Does interviewer nowadays still write early feedback prior to sharing the full feedback with recruiters?

like

Hi Guys can anyone refer me for the position of data and analytics analyst Job Identification NO :210362477..THANKS IN ADVANCE!

like

Dear all,

Are there any openings for senior design engineer in Daimler truck , currently working in new product development domain . If there are any openings for the role mentioned, kindly refer me.
Thank you 😊

Hello All - looking for links, resources , samples on interview prep/practice for sales , account management, partner management, practice management at FAANG companies like amazon, google, microsoft

like

Hi guys, I am a systems engg in TCS with 3 years exp. Technologies known: C, C++, Java, COBOL, Oracle DB, SQL, Unix/Linux, Shell scripting.
I had applied for Infosys in the company portal long back, but haven't got any replies yet. I am looking for the Developer/ Production support roles.
And I am in my notice period, lwd is 27th sept.
Also, have an offer from L&T with doj 29th Sept.
If any one can help me out with a interview referral, it would be great.
Thank you

So l just started a new job (I work in
higher Ed) but I would like another
stream of income. I am interested in
adjunct faculty but I find it so hard to
get into and I think it's because of
experience teaching. Can anyone be if
help with landing an online adjunct
position for teaching college
readiness or success? I think to start
my teaching journey that type of
course would be best.

More Posts

What is the avg yearly hike in deloitte india risk advisory?

like

I gave interview (Manager round) last Friday at Deloitte India. Haven't heart back tried calling hr but no luck. When can I expect result or feedback, is this a dead end for me? Deloitte @deloitteindia.

like

IQVIA - 33.5 lacs Fixed, 1.5 lacs Joining Bonus, 4.8 lacs Variable
CGI - 34 Lacs Fixed, 1.12 Lacs worth Stock options, 2Lacs Joining Bonus(will be deployed to work for Shell Client)
Siemens Healthineers - Awaiting offer, not willing to match above offers, maximum they can offer 33L as fixed and 2 Lacs Joining Bonus.

which one to choose?

YOE - 13 Years Skill Set: Agile, Scrum

Like

1Comment
Share

like

I’m struggling to find a full time job right now. I have 16 months of internship experience at a Big4, a 4 month internship at a well known bank and a 12 month internship at a boutique consulting firm.

My gpa is subpar (3.2/4.0) but I have strong extracurriculars and have been working full time while taking full time classes.

Any advice on what I can do to land a solid fu time offer?

like

What should someone expect in a data visualization code test? They told me to bring your own tool and we will provide a csv. Should this be very complicated? I know the basics for tableau but not a super user. It is for a senior manager of data science.

like

Nyc based. Is it at all possible to make at least 200 base in corp dev or strategy at a tech company? Super burned out but don’t want to take a paycut in base. I realize I’ll never make all in comp the same in tech but if I can match base I’d be content.

like

Hi,

I want to transfer my previous PF account to the current one. I have signed the Form 13 as well.

Can anyone tell me whom to give the hard copy and also submit the soft copy?

like

Lately, I've been hearing a lot from my peers about how sales isn't a real profession.
I work at a tech startup and it mostly comprises developers. They can't stop emphasizing their importance in the food chain and I can't figure if I'm too humble or they're too arrogant.
This yapping comes from people I've known since college. I have successfully blocked all such negativity but wanted to know if anyone here has faced such scenarios.
P.S: I've already accepted an offer above my expectations

like

Now that Facebook is Meta, I thought I’d just pitch MANGA as the new FAANG…

like

I have around 4.6 years of experience in frontend web app development with ReactJs. My current salary is 15LPA fixed. I am in the final interview round of Infosys. How much shall I ask from Infosys? I am thinking of asking 22 LPA fixed. Is it fine?

like

Hi Guys,

I have an OL from LTI with a CTC-20 Lpa..As my mother had brain surgery, i need to be with her. i have asked HR to provide WFH. Does LTI support in these kinds of cases?? I have also asked HR to set up a call with the Project Manager.

Comments pls ..

like

What’s a fair price to charge, direct to client, for writing individual pages of a web site?

like

Not sure if anyone of you can help me out. I am looking for 2 native HANA developers for a contract role for a client in Chicago. 5-7 years of experience. If anyone is interested - please dm me

like

Hi any advice for someone who has 1 1/2 year experience in industry and wanting to switch from market access to medical affairs. I'm open to any job opportunities in small or midsize pharma or guidance I have a vaccines and neuroscience background

like

Been seeing this guy for 1 year now. I just became an American citizen so have been getting more into politics. I lean left but the guy I’m seeing leans more conservative. He treats me so well and we get along great. Yes we disagree about topics but have respectful conversations and have both become more open minded. He doesn’t think it’s an issue. I feel like the media and the judgement of dating someone on the right is getting to me & making me have negative sabotaging thoughts. Any advice?

funnylike
like

Posting here bc this bowl skews toward consultants. I'm considering a strategy consulting-like role. I have assumptions, but want to validate realities. Any tips on books, blogs, podcasts etc?

like

I'm so freaking excited!!! Just heard from my recruiter and I'm being offered a Google cloud L5 TAM role. Thanks for all the help and advice from you all. 🎉🎉🎉

likeuplifting

Is it common to have the hiring manager interview “pre on site”? I cleared the initial recruiter call. What can I expect from this? RRK? It is for a non technical role

like

EPOR a solid first option trading choice?

like

Additional Posts in Excel Genius

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

why is index match superior to vlookup?

likefunny

How long did it take you to become good at excel? Like fast?

like

If you have never created a macro, any tips on where to start? Any good Udemy courses or YouTube videos?

like

Presenting data in 2 tables that refer to the same pivot table as source. However, one requires a filter on the pivot table and when filter undone, values change back to original. How to tackle this?

like

What are some of the unique use cases you have leveraged excel for?

like

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

Any book recommendations on excel modeling for real world business applications?

like

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

Building an invoicing template for a construction comp but won’t be industry specific. I’ll be charging 5 hours at US$80/hr. Anyone want a copy of it for US$40 worth of crypto?

Context:
I spent 2 days last week and tmr fumbling over invoicing activity with the owner using a poorly designed invoicing spreadsheet. Last minute changes to already approved templates impacting >30 invoices is ridiculous. There will be a control sheet, an invoice generating sheet and a summary sheet. Q’s or comments?

like

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

like

Just got a dell and getting annoyed learning new shortcuts on excel (had HP prior) - how do I automatically get to cell A1? Used to be CTRL-HOME on HP and Lenovo

Post Photo
like

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

What’s your Excel horror story (worst crash, worst mistake, worst there-was-a-way-to-do-this-quicker moment)? Extra points for self-shaming

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