Excel Skills Test for Consulting Help

Hi,

I have a skills test for a consulting position coming up soon relating to restructuring and claims. I am solid on my excel knowledge and what it may consist of in regards to the model that I saw in another post. But I want to freshen up on it as it won't be on DCFs, etc. and will relate more to condensing large amounts of data i.e. claims from a specific company and cleaning/analyzing it. If you have any advice towards these types of models or any practice tests that'd be great as a refresher. If that doesn't make sense let me know so I can clear that up. Thanks in advance.

-postgrad2017

Excel Functions to Learn:

Pivot Tables
Vlookups, Hlookups, Index/Match
Arrays
Macros - are an added plus but unnecessary
Short cuts for formatting
Text to columns
Conditional formatting
If Statements
Min Max Functions
Sum Product / Sum If
Truncate
Proper, Lower, Upper 
Goalseek
Datatables
Advanced Chart Techniques
Circular error trouble shooting

2 Comments

WSO Monkey Bot

O

8y

Hi postgrad2017, check out these resources:

Excel Test in an Interview explained answers. Excel Test for Interview Prep excel test ... of the stuff they would test. To begin preparing for an excel test interview, JobTestPrep has ... everything you need to know for Excel Testing Interviews, incl
Most Important Excel Skills for Consulting year to everybody:D 15% Off wall st. prep Financial Modeling Training Click Here Excel Skills Needed ... for Analyst Position Becoming sharp with excel is critical in both consulting and banking positions. ... excel for basic statistics and a bit of data analysis. I would really appreciate some insight into what ...
Real Estate Private Equity Excel Test Help interview models that they had to build for their company or practice models to prep for these types of ... I have an interview next week with a real estate private equity firm for an analyst position in ... their acquisitions department. The HR guy said the exam would be a basic excel model (take no longer ...
Excel test.. any advice? I have an excel test next week for an Analyst role. This is more of a consultant type firm for an ... entry level role. They mentioned it is just a short excel test to test skills and some basic RE ... principle type stuff. Any idea what I can expect? Prior interview they asked me to tell me about NPV so ...
Top 5 Financial Modelling Skills and Excel skills needed for Corporate Development/strategy position in a media company. Form my research, they all require financial modeling and advanced excel skills ... 5 topics I would need/they would ask in an interview for a position at a company...not a equity research ... . I have a month to teach these to myself. I was wondering if you can help me out and tell me the top ...
Finalta London- Excel test+interview insights to both complete and send the file back to us via email." Excel excel help assessment test ... Hey guys, I got an Excel + writing test with Finalta coming up in 2 days, what to expect? ... What're the question types: for example, do I need to do the ppt based on the Excel (e.g. find a problem ...
PwC Virtual Office Audit Support Data Analyst Second Interview (2nd Excel Test Help!) The recruiter brought me in to interview for an Audit Support Data Analyst position (they are hiring ... ten). I passed the first round, including excel/audit/gl tests, but I'm told there will be an excel ... data analysis test at my second round. I have no real auditing/data analysis experience and my excels ...
More suggestions...

If we're lucky, the following users may have something to say: Chris-Pasquale @adking1357" alpinespringwater

You're welcome.

Reply

Quote

Report

Other

I'm an AI bot trained on the most helpful WSO content across 17+ years.

WSO Monkey Bot

O

8y

Iure accusantium cum porro reiciendis eum suscipit perferendis sequi. Ipsum ullam delectus esse excepturi aut facilis. Rerum natus repellat laborum omnis. Ea et quibusdam maiores.

+43	Lying about GPA	23	2d
+23	Notorious Backchanneling Recruiters & Employers	7	3d
+15	This job just ain’t for me. What now?	5	2d
+12	Nearly two weeks after HR phone screen without any hear back, should I keep waiting?	3	1d
+12	Non target guidance	1	3d
+10	Nontraditional Background Trying to Break Into Finance — What Am I Missing?	2	2d
+9	Couldn't find a good place to practice quant interview questions, so I built one	1	5d
+9	I need career advice	1	2d
+9	OffCycle; Internship Tracker	3	1d
+9	Where I though I'd Be by Now	4	19h

1	redever	99.2
2	kanon	99.0
3	BankonBanking	99.0
4	Secyh62	99.0
5	CompBanker	98.9
6	GameTheory	98.9
7	dosk17	98.9
8	Betsy Massar	98.9
9	DrApeman	98.9
10	numi	98.8

Elite Career Bootcamp. Top Job Offer Guaranteed.

Elite Career Bootcamp. Top Job Offer Guaranteed.

Excel Skills Test for Consulting Help

Elite Career Bootcamp. Top Job Offer Guaranteed.

Elite Career Bootcamp. Top Job Offer Guaranteed.

Excel Skills Test for Consulting Help

See All Comments - 100% Free

Trending Content - Job Search Advice Forum