Does anyone have an excel test they can share (or point me to something online) that you use during the interviewing process to evaluate candidates? Not looking for an excel expert but definitely need someone who knows more than the sum function

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

My suggestion: get a free online official database (idk the country you're currently in) and ask the candidates to perform some analysis and create a functional* dashboard - say you provide them a database of internet connections:
- how it's divided by state?
- how it's divided between mobile, fixed, high-speed, low-speed, etc.
- what places have the most growth rate among the years in the database?
- and other useful stuff

* pls don't ask a "good-looking dashboard" as 1 - beauty is very subjective and 2 - you can easily train someone to get to your (or your company style); it's not a part of excel learning to be good at design

likehelpful

If you're in US, check the census Bureau for good ideas - I have a couple but they're mostly for finance

like

Gito coursera.com do two things . Take excel skills for business specialization by Macquire University . Second do a Google data analytics certificate do compare with Google sheets . Will do help you alot

like

Just come up with situational questions around how to or how the people would solve problems in excel. Don't be afraid to have them demo.

like

When interviewing interns and recent grads I've asked them to send me Excel files they referenced in their interview (when we ask about Excel). For the most part this has been solid in terms of knowing the basic skills they possess, interviewees tend to reference files containing whatever they consider the most complex skills they have. However, because it's generally a school project it doesn't speak to their ability to process fluid information or quickly deliver on said skills. The timeline of a typical school project is far longer than 'I need this by end of day' so I think I'll move towards adding a simplified Excel task and timing it in the future.

Well assuming you don’t want to crush the candidate with an expertise excel test, I would say after proving they know how to utilize a sum function, maybe throw in a little curve ball in there and see if they can utilize a SUMIF, COUNT , MAX, MIN and AVERAGE functions from the same dataset for quick insight.

Learn index match, xlookup, nested sumif, conditional formatting (more than basic), advanced filters, goal seek and you'll be an advanced user.

It is subjective, i agree but despite being an expert in VBA, i don't recommend it to other people. Better solutions (PQ) can be found on the fly. In terms of formulae, once you are familiar with the intermediate ones, the most advanced ones become simple to learn. I think an advanced user is one who isn't scared of attempting any spreadsheet and knowing the intermediate ones, anyone can make good spreadsheets quickly googling the functionality they don't know.

Try taking the Microsoft Office Specialist Certification exam. You can take either the regular or the expert version. I took the regular exam for Excel 2016 back in spring 2020, and it tests core competency. It doesn't go too far into advanced Excel functions, but rather it demonstrates if you're able to navigate Excel via the ribbon to execute a series of tasks. After taking the exam, I ended up earning the highest score in Iowa for the 2016 track. Wow! Since then, just having the certificate has proven to be enough of a qualifying boost when applying for roles. I've found this to be a more successful approach for saying I'm familiar with Excel rather than listing formulas I know; of course, there's still an advanced realm in Excel that exists. You don't have to be an all-seeing Excel wizard; if you have confidence in navigating the program and performing core functions, you are doing quite well compared to those who are reluctant to open a blank spreadsheet.

The course is actually quite garbage imho

Related Posts

Last year I got fired but then recruited by another company within a month. Can I tell people the second company recruited me?

like

Hello Fishes,
I recently gave interviews for confluent (SDE2) and I’m waiting for results. Looks like it’s positive but I’m not sure what will be the package.
YOE : ~5 years
Current designation: SDE2
Current CTC : 21 LPA ( 20 fixed + 1 variable)
Please help me with the industry standard salary ranges… As I couldn’t find any much data about the salary ranges…

like

Recently i have attended interview at legato for healthcare Domain Team lead/AM position for Bangalore location. I got an confirmation from my consultancy that i have cleared 2 technical round and HR need to finalize the offer. HR has scheduled the interview but he not joined, so I just send an email to know the further process. After that i haven't heard any update from HR. Pls confirm that HR process is late in legato? Pls confirm what CTC i can expect from HR?

YOE 10
CCTC :7.5LPA

like

I’m just curious about how successful people have been cold messaging someone on LinkedIn. Whether it’s a recruiter or a mentorship or someone who works at your dream company and you’ve tried asking them about their openings, how successful has it been for you?

like

I got below status from Accenture after clearing interview round. It's been 10 days I have submitted my documents & got confirmation mail on document submission. Is there anyone who has recieved the same status and got the offer letter? How much time does it take to release the offer letter after this status ?Accenture India Accenture

Post Photo
like

Has anyone done the Korn Ferry executive assessment? Specifically the Korn Ferry Four-Dimensions Assessment or the Raven’s Advanced Progressive Matrices / Abstract Reasoning? This is for an in-house position. Any tips for preparing, taking the tests, or participating in the interview?

likefunny

Hi ,

I recently got to the next steps for the UXR apreatanceship at Pinterest. Can anyone help me with interviews prep?


Also can I get some likes on this to unlock direct messaging .

Thanks

like

Does sopra has hire and fire policy . (My client interview is not done . They have released the offer without second round )

Hello, I got feedback within 6 hours for first 3 rounds and 4th round done with manager 2 days ago but still no update. Any suggestion ?

like

Needs some some advice please. I recently had my interview with the Accounts Manager (she makes the final decision) and she have me great feedback. She offered me the third interview with the Controller and told me I was her top candidate. There is currently two of us. The next day I was scheduled for my third interview, but then they also scheduled me for a 4th interview(same day) with the CFO of the company. I really want this opportunity and I feel like I got the job. How to I seal the deal?

like

What support profile people usually do? I have my interview scheduled for it. Is there any development work?

like

Had an interview with KPMG (manager) for an FRM Consultant position about three weeks back, she mentioned that I'd be a great addition to the team and is excited to work with me but I haven't heard back anything since. On contacting HR I got the standard "we'll let you know" response.
What do you guys think? Any hopes for me? What do you think went wrong after a solid interview if no?

like

Applying to Goldman Sachs FT New Analyst roles in Dallas. Would love a referral.

like
like

Ho Fishes,
I appeared for L1 for Architect role in D365 CRM yesterday. It was 30 mins discussion on scenario based qs. Able to answer 70%. Any chance? If yes, how many days it takes for the 2nd round call back?

I have an interview scheduled on Tuesday & I can't sleep as I'm highly anxious & I really want this job. I tried distracting myself but isn't working. Maybe I just want to talk about it.

like

I’m not sure I fully understand Amazons pay structure. I’m applying for a Sr. Customer Success manager role but the base is low. The sign on bonus may help and the go forward RSU’s…but it seems so unstable. What are the pros and cons of working with Amazon?

More Posts

Hoping to get my PHR in the next year or so. Outside of employer reimbursement, are there other opportunities for this to get funded? I know SHRM Foundation offers scholarships for the CP, but I am looking for PHR specific help. Thank you! :)

Which firm do you think creates most visually attractive decks/pages if you have seen outputs from multiple firms

like

Anyone have any insights into ICONIQ (hours, culture, comp, etc.)? Have heard mixed reviews so far - specifically that new joiners today have less runway (more of a pyramid today while the folks who joined 5-10 years ago had faster paths to MD / Partner and are sitting pretty). I’ve been hearing that comp is decent (i.e., I did see on a H1B salary database that base for a PE senior associate is $175K, but who knows what cash bonus / carry looks like). No datapoints on culture yet

like

I’m planning on sharing more content for the members to consume, what kind of things would help you out - courses, podcasts, general news, or Q&A sessions conducted by me with more industry professionals over Zoom etc. ?

like

Hi Fishes, currently I am having almost 3 yrs of exp in SAP PP and QM. Will it be good to learn SAP HCM success factors at this stage ? How is the scope for same ? (As one internal program I will be trained in HCM SF)

like
likehelpful

Male F
I always give my dates a gift after our dinner night out

likefunny

Friday Wordle 335
⬛️⬛️⬛️⬛️⬛️
⬛️🟨🟨🟨⬛️
⬛️🟩⬛️🟩🟩
⬛️🟩⬛️🟩🟩
⬛️🟩⬛️🟩🟩
🟩🟩⬛️🟩🟩
🙄

like

Anyone have experience doing a secondment and then returning back to home office? If so, staff level / country to and from / length of secondment?

like

For 14.5L CTC what will be the approx fixed salary?

like

Which Capitan would have your vote for President?

Has anyone here left a high paying job to start on their own?

like
likehelpful

How much % more corner townhouse would cost than the sandwiched one. What are pros and cons or corner house. planning to keep tenant on entry floor so leaning to buy corner. But cost is 20-25k more

like

Who does the xfinity TV spots “the future of awesome?” Like it.

like

In your opinion is keto bad for runners? Especially for those training for a full marathon? I’d like to drop the weight I gained from the past year to make running easier. TIA!

like

I have an approved i140 , if i switch job will i be require to do all the i140 processing (perm and all) again with new employer when i know that my priority date is decade away from being current.

like

Hi, I'm working at a product based company, I joined as a fresher and it has been 3 years, I have not been able to get an Offer in last 6 months of Interviewing with companies like Amazon, Cisco, Akamai, Paypal and ServiceNow, but I have got an Offer from startup for almost an 80% hike. I have put down my papers, but suddenly I'm feeling I'm making a mistake by moving into a startup, because I see people with the same experience are joining MAANG, I should've waited and tried hard?

like

Additional Posts in Excel Genius

I have a large spreadsheet with lots of dates, how can I identify classification based on the dates below? I.e. if your hire date was in between these parameters, it flags you. nested IFAND?

Post Photo
like

I did this manually but would there be a way to pivot the dates (day/month) in the rows years in columns with raw data being (date/month/year) needed a visual of same day different year

Post Photo

Hi! Disclaimer: not an excel genius…

I’m trying to use the lookup function to grab data from a worksheet within the same workbook. I want the column to reference the cost code in one worksheet, find the cost code in the other and display the billed to date associated with it. The problem is that it repeats an amount randomly. There will be multiples then a blank cell in one that I know has a cost associated with it.
Formula=LOOKUP(D3,!Sheet!$D:$D,!Sheet!$H:$H)

like

Hey guys, I have a Google spreadsheet where each cell has multiple links separated by semi-colons.

How would you get the links to show up in different rows WITHIN a cell? (Pictured is what I want to achieve).

Thank you so much🙏

Post Photo
like

How do you jump to the top cell in a column if there are blanks throughout the column? Control arrow just goes to the next blank cell.

like

Excel Geniuses- I need a macro the will convert a model with all USD to show it in British Pounds, and then back easily. Anyone have experience with this?

like

Hello Everyone,
I would like to create a schedule for all of my clients. Let’s say I have platinum, gold clients etc. What would be the best way for me to schedule a call for them based on their profile of gold or platinum? For example, I would start scheduling a call every month for my top clients, then a call every quarter for other categories… I need to track the data, and make sure employees are calling them… something that would alert my employees to call such clients. Thanks!

like

Hello again fishies...

Column D in tab 1 and tab 2 is a drop down list which has 6 items.

In tab 3 how can I return the Cells in Column a b and c (tab 1 and 2) when the value in cell d(tab 1 and 2) is one of the 6 items selected

like

Is there an absolute moron’s guide to Index Match? I have two tables of users, some exist on table A that don’t on B, and vice versa. I need to merge them based on their email as the unique identifier

like

Has anyone used VBA to create multiple what-if data tables before?

Looking to set up conditional formatting to indent a cell if another cell has a certain number of characters. Please see comments for details.

Post Photo
like

I have a large binary file (20mb) . When trying to reference another workbook in formula, excel won’t recognize the other workbook. Any fixes? I’ve been trying to reduce size

like

Does anybody have a good resource that would let me link data from QuickBooks Desktop to Excel?

like