What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

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

Date related formulas, such as networkdays(). Powerquery is also helpful dealing with repetitive queries from sheets that require formatting and calculations upstream. Knowing shortcuts is also a plus to showcase your efficiency

likehelpful

ISNUMBER(MATCH()) is one of my most commonly used functions. It finds if element in x is present in y.

helpful

I use IFNA a lot so that when something doesn’t pull it doesn’t break my model altogether. I create links in my models to take me to other places in the workbook - sort of like a table of contents. I use the filter function in combination with the unique function to pull out actively owned symbols from a journal of entries (don’t know if that is common or not). I’ve used RRI but not a lot - mostly Pivots, sums, sumifs, lookups cover most of what I do

helpful

SUMPRODUCT is super handy at the right time, it does a lot more than the basic use case

helpful

Didn't the FILTER function make that redundant? I personally don't like SUMPRODUCT because it is vulnerable to errors in any of the arrays referenced. In other words, it breaks far too easily.

like

Related Posts

Hi Folks , Currently living in india. Looking to shift to UK within a year . I am SCON in D-USI. Please guide me from scratch how to initiate the process . Do I need to apply for UK work visa first or just start applying to jobs in UK.

like

Hello fishes,
I have been offered From Persistent system with 90% hike and some joining bonus.
I am still awaiting offer from Capgemini as I have cleared interviews and completed documentation there too.
My question is should wait for Capgemini's offer? As they haven't been responsive to any of my mode of communication.
While as Persistent has been responsive and offered a good deal..let me know ur thoughts

like

Hi Guys, thanks on suggestions on previous post.
I have aced Google's RRK interview.
Next up GCA!, Any experiences/resource let them come in...
Wooo!

like

Any recommended resume writing services? Especially in insurance industry

like

What’s the best way to make your email stand out to a recruiter?

like

If asked this in an interview, how would you answer?
What is the one unique quality that makes you an effective salesperson?

like

In my notice period in TCS decided to hunt for interview in other company after one month, within 3 months i should able to get any offer letter from companies.m I doing the right thing,any openings please let me know guys.

like

I had an interview the week before Christmas and New Years. I know there is usually a holiday slump - when should I reach out about an update? It will be 3 weeks tomorrow.

like

I’ve been at my clerkship for 5 years (4 with a different judge) and one with my current judge, and I heard horrible things about him before starting, but I assumed they were exaggerated. Turns out they’re all true, and I’ve had to start therapy to deal with him and the incredibly toxic environment. I’m trying to get out ASAP b/c he also has a history of firing clerks without cause or notice, but I think I’ll only be able to give two weeks notice if i get the job I’m interviewing for. Thoughts?

like

Is anyone willing to look over my resume to let me know if I’m qualified enough to be a consultant at Deloitte? TIA

like

Hi Sharks,

Has any of you attended interview with ServiceNow company? I am shortlisted for second round, want to know what to expect in 2nd round and what to prepare.

like

Hi Energy fish, I’m currently an economic consultant working in Energy with 2.5 YOE. Would anyone in the energy industry be willing to critique my resume? It would be ideal if you had consulting experience too but I won’t be picky. It’s been hard for me to figure out how to get the nuances of the industry across without being too detailed. Please DM me!

like

Do you guys talk to chambers for the firm interview?

likehelpful

Hello,
I had my interview with
Infosys for .net full stack developer.
It went well and i am hoping for a positive response.
Want to know how much should I expect Or at what pkg should I negotiate with them.
I am thinking of proposing 13-15 LPA negotiable.
4 YOE and 7 LPA currently
.Net full stack
Infosys

like

Is anyone at Spotify willing to entertain a conversation around the culture, pay, interview process, and a potential referral? Let me know, thanks!

like

Hey ,I applied 3 weeks ago to Bank of America USA ,with a decent resume and referral. But still did not heard back.Need a human eye who is willing to check my application and help me moving to the next step? Bank of America USA. I'm based in NY.

likehelpful

In two interviews the interviewer asks me about one topic which I know theoretically and some practical. I directly said to the interviewer that I am not an expert in that, but if I get my hands on it then I can learn in one day.

After asking two questions again he came on the same topic this happens twice in two interviews. Mere ko lag raha hey Jaan bujhke questions same topic pe puchte hey, so that they don't select that candidate.

like

Interviewed for a GS-15 (same agency but different office) and totally aced the interview with excellent answers. They know I’m a top performer with senior references. However I noticed there was an internal candidate who has been there for few years and interviewed that’s a veteran. I feel my chances just sank and want to gauge thoughts.

like

More Posts

Why do guys don't ask girls on dates anymore? I know this guy likes me, he already told me friends so but hasn't acted or done anything in respect to us hanging out alone, such as get food

like

I’ve been feeling so tired lately. I used to be good about waking up at 4/4:30 to hit the gym before work and eat well, but I’m slacking. How do you all keep up with it all while working insane hours?

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

Hi! New attorney here. Licensed in January 2021.

I have a seriously hard time working all day. I went straight through, so part of it is probably just that I've never worked in an office before, but I have the hardest time getting in all my hours. Anyone else deal with that fatigue? Or figured out how to conquer it?

I wish I could just work all day but it's not coming naturally to me. I walk, I take breaks.... but it's hard

like

Open to anonymous comments around culture, salary, etc

Is Coforge giving anything on Diwali this time?Coforge

Georgia Tech Cybersecurity masters or the analytics masters? Currently in a cyber role at Deloitte. I was thinking it might be better to do the analytics master and get a CISSP. I feel like there is more value in the cissp than a MS cybersecurity

like

Are you not entertained?

Post Photo
likefunny

I’d like to get golf lessons as a gift for my husband. We live 30 mins north-west of Boston. Any suggestions on how I can find a really great golf instructor?…

like

Cannot make up my mind on carry on - I have a tumi leather carry on.. but need a new one..

like

Hey could you please let me know how is Pune ey gds office?

like

I started interviewing early Oct with a company that reached out via recruiter. The hiring manager was very straight forward with me that I was his top candidate and I was told all other interviews were very positive incl CMO. The recruiter said they'd be making an offer but it's now been three weeks. Anyone else had the process drag on like this? Meanwhile I'm taking other interviews and was offered a promotion at current company, but was very interested in this one. What would you do?

like

Does anyone know how many rounds of interview are done in PWC?

like

Hello

I've been interviewed by @Amazon on 8th July and even after multiple follow up emails, there's no update. Any suggestions?

like

Hi fish,
Planning a trip to Thailand for 1-2 weeks next February. Suggestions on where to stay (cities, parts of town, specific hotels), activities, where to fly into etc. Thank you!

like

Any recommendations on St Regis vs Ritz Carlton Istanbul?

like

Best places for a vacation the last 2 weeks of December?

like

What are the pay rises like across firms this year?

GT consulting getting pretty much a 3% rise and 3% bonus across the board.

Pretty mean considering we've had our best year ever and inflation is running at 5%!

Finance experts, help me understand what a major deflationary period will be like. ELI5

How to get experience letter in Virtusa after resignation?

Additional Posts in Excel Genius

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

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

like

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

Hey!

What are the less known skills in Excel worth learning which are also high in demand in the market?

PS: I am starting off on Fishbowl so please support with a ❤️.

like

Anyone know why a SUMPRODUCT cell would return to zero?

The error said ‘inconsistent formula’... (cont’d)

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

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

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

like

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

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

Everyone: Excel is a smart app
Excel:

Post Photo
likefunny

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

Hi all! Is there a way to easily copy over all the rows from multiple sheets into one consolidating sheet? We have 32 teams filling out transactions in their own tabs and need to consolidate all tabs transactions into one long list of transactions. Thank you!

like

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

What are your top Excel ninja tricks? Ones that few people know...

like

Would anyone be willing to teach me vlookup?

like

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

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