I have an excel assessment for a job interview (senior revenue accountant). Any ideas of what skills I should brush up on or learn?

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

It’ll probably be basics stuff: general formulas, pivots, vlookup (hlookup), sumif, counts?

like

Index/match! 😄

like

Copy/Paste

funny

I’m sure it’s pretty basic

Like EY1 said. Also get familiar with cleaning up basic data for filtering/lookup/pivots

Pivots, Lookups, Sumif/s and get strong with use of AND and OR in if conditions.

Related Posts

Has anyone recently interviewed with S&P Global and got an offer?

Hi Fishes,

l interviewed for Deloitte (India not USI) in January, and accepted an offer letter with DOJ of 25th April, later HR asked me to join on 11th April for which I agreed. Now I haven't received the revised offer letter or any links other than BGV and Pre-Hire form from Deloitte and now the HR is not even picking my calls or responding to emails.

Any advice on what to do?

like

Hi, I have FE technical interview with @IBM this Friday. Can anyone please suggest how to prepare? YOE 4

like

How many rounds infosys has for laterals??

Hi Guys,

Can someone share
Salesforce developer/support interview experience.
What kinda questions were asked and some pointers on how to prepare for the interview.Salesforce

like

Can anyone share interview experience for the role of Full Stack Developer at McKinsey & Company for  Build by McKinsey?@

Yoe - 3

like

Hey all! I am currently a student in my final year of complete a Computer Science undergrad degree and am currently looking applying to remote college graduate positions in software engineering/development. Does anyone have any advice for landing a position (or a position they could help me land <3)?

Post Photo
funnylike

Please suggest case study questions that can be asked during interview..PwC AC Finance Transformation

likehelpful

Got a call from CTS via bot. They asked for interview on 23rd Sep. My present role at Infosys is Technical Test Lead. Kindly suggest what role you try for in CTS. Also present CTC is 16.22. Expected CTC should be how much?
Got a masters in supply chain mgmt which I have not used. Can I go in R and D? If yes on what role ?

like

Can anyone tell me the turn around time for an interview process with KPMG? Like how long it might take ?

Hello fishes,
I had my schedule today at
Genpact which went pretty well, After few hours of the interview I received an Email stating your next round is tomorrow it doesn't say anything about which round it is so can anyone throw some light on it so that I'll try my best
Thanks in Advance

like

What to expect in a Bank of America interview process for the role of Financial Analyst?

Kindly guide me I have an interview next week.

Thanks in advance fishes

like

Does anyone have any recommendations on how to prep for a human capital case study? I’m interviewing for SC role and have deep knowledge in the areas of Org Design, Change Management and Culture Transformation. I worry more about structuring the conversation and my answers in the most effective way

like

Is it common to negotiate software engineer salary at smaller companies? I know it’s common at FAANG, but what about for companies with around 200 engineers? I have a counter offer from my current company and on-site interviews scheduled for end of July with google and Amazon, but I’d prefer to go with the smaller local company if I can negotiate the salary (from offer letter) up another 5% or so.

like

Junior Partner, been in working litigation at defense firm for 10 years...but I'm really starting to burn out and would love to transition to an in-house position. My concern is that I have very limited experience with transactional work. Advice for applying and interviewing for in-house gigs?

like

The roadmap for Java interview preparation

Many folks are confused at various levels so to how to prepare for next Java interview, what all to study etc.

Worry not folks, here's a quick roadmap of the java tech stack

Post Photo

Hello Guys,

Currently I am working as People Partner (Human Resource) with Byju's at Kolkata office and I am actively looking to shift to Bangalore.
I tried applying almost everywhere but no luck yet.

It would be really helpful if anyone can refer me in their respective organisation for any role in the HR domain.

like

Hi All, Have been reached out by a GS recruiter for Software Dev - SRE role.Any leads/help on the process and interviews would be appreciated.

My Current CTC is 18.5 LPA. YoE 12yrs.
How much CTC can I ask during an HR interview for a BIGDATA engineer in UST global. What should be the expected CTC per current standard. Can you please let me know based on your experience in negotiating.

like

Hi everyone, interview for entry level Allstate claims position. Should I take it being 3 business days since my final interview and no offer. The interviewer said to give it a week and that she was gna give my info to hiring manager to review, but I thought she was the hiring manager since this was the 2 interview outside internal recruiter interview. i sent a thank you email the day after. But i don’t know i thought it was a good interview. Allstate

like

More Posts

Anyone loving their firm and HC practice? If so, which firm (and industry) are you in?

What is your preferred HRIS Platform and why? Here are the options:

-Workday
-Oracle
-SAP
-ADP
-Ultimate
-Ceridian
-Other (if other, please name the system)

like

$Link 👀. Drop down to $11 area or keep pushing up?

like

I am generally uncomfortable when I’m around my mother-in-law’s husband.

While he is overall a decent guy, his anger issues, yelling at his wife for the slightest issue, and insulting nature makes me uncomfortable and triggers my own anger due to his blatant disrespect for just about everyone around him.

My mother-in-law says he’s worked on things, but it’s been 10 years of this and I’m not sure I want such behavior around my wife and our kids since we’re trying to conceive soon (cont).

like

Any appellate public defenders here? I start in about a month (coming from an unrelated practice area) and I’d love to hear any tips.

Anybody in here trade options? I trade Iron Condors and have been having success with that but would love to hear what other people have been doing

like

Got a verbal offer from a big agency a week ago and HR said written offer will come by EOD but no email. They did background check last week. Followed up last week no response, what should I do?

helpful

What happens if a teacher you work with looses their home to a disaster like a fire or earthquake?

smart

I am not ok.

like

I have learned that several Housekeeping employees in the hospital have died from Coronavirus, and I'm ashamed to say, that I didn't even notice their absence

likehelpful

Hi,
Quick question: Do you think is it fine to be asked for preparing an outline for marketing plan as an assessment test so, employer decide if you will be the right fit for position ?

likesmarthelpfuluplifting

Anyone know anything about Artefact consulting? Recruiter reached out to me but I’ve never heard of this firm Artefact

like

Hi All,

Hope you all are doing well..!

Iam looking for a job change could anyone help me out with the job..

Current profile working with Othain software services private limited experience in Accounts payable holding 8yrs of experience.
Key roles invoices process, payment, calls, reconciliation, monthly report.

How are you interpreting Cuomo’s latest announcement? Is it close daily at 10pm or closed until further notice starting 10pm?

like

Can anyone help me with this??
What are the differece between the two and which one should I choose?

Post Photo
like

As an auditor, do we need to worry about whether signatures are legit? Like if clients mark their initials in pdfs using simple text box, can I accept that or am I supposed to get an email approval

likefunny

Kfc doing celeb meals now too?

likefunny

Hi Guys, I have 15 years of experience in IT..the experience is in different domains including project management.Now i am getting offer for both project management and technical roles.I am confused, should I go for PM role or technical role as an cloud architect.

like

Folks who do hiring, what do you think of adopting the following question in future interviews?

“Evidence suggests that teams that include a variety of perspectives and backgrounds will often produce more creative solutions and catch mistakes earlier. What background or experiences do you bring that will help broaden the perspective of our team?”

like
like

Additional Posts in Excel Genius

Do you have to activate excel almost every time you use it- or is it just me?

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

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

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

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

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

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

How can I update the range in one location for a tab whose data source, a second tab, is connected to SAP and the range updates on the source tab depending on quarterly activity?

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

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

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

like

I have a journal entry population as a .mdb format (over 1.1GB). From that file I want to separate out all Expense account entries based on a separate list of 273 accounts. What is the fastest way?

I’m working with a massive old template that gets updated every year (so hella outdated links) which populates a lot of exhibits we use for reports. When I paste these exhibits into ppt... (cont’d)

like

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

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

likehelpful

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

likesmart

Hi all,
I bought access to Wall Street Prep’s modeling courses to enhance my modeling skills. I find that the material is a few years old and the guy in the video explaining everything is super monotone and boring. I just don’t feel like I’m learning much.

Would anyone have any good recommendations for other modeling course providers? Should I stick with WSP? Any and all advice/responses would be helpful - Thank you in advance !

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

How do I compare two sheets to make sure they are identical?

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