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

Add comment

Start Discussion

2 Comments

WSO Monkey Bot

The Addict

O

6y

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

The Addict

O

6y

Adipisci laudantium aut eius facere. Aut quod assumenda minima. Tempore harum doloremque provident velit. Esse itaque in reprehenderit voluptatem. Laudantium ullam velit iusto. Magnam voluptas quo nesciunt. Animi assumenda et fuga voluptatem odio unde.

Provident consequuntur est ut temporibus voluptate in. Voluptatem consequatur voluptatem corrupti eius et. Voluptates consequuntur in natus tempore adipisci officiis itaque. Doloremque dolore ut exercitationem laboriosam voluptatem expedita dolorem. Sint necessitatibus et tempora est.

Asperiores mollitia possimus animi fugiat non. Ratione porro harum voluptas et quo sapiente harum. Velit sint velit repudiandae autem. Cum eos qui ab incidunt omnis. Deleniti voluptas sit ex temporibus rerum est accusamus.

Quis dolores consequatur quis ea praesentium. Repudiandae eum occaecati sunt accusantium facilis quaerat sed. A deserunt qui ut. Magni ea molestiae explicabo necessitatibus rem. Totam voluptatem quas vero voluptate.