Month: April 2014

Acing the Case Study Assessment

The Case Study of the consulting interview process may seem like the most daunting part for some. But there is thankfully lots of information out there to help you get an idea of things that could be asked. At the end of the day, you have to remember that these are the kinds of scenarios you will be dealing with every day as a consultant, so the true future consultants will be eager with enthusiasm for this stage of the process.

Often the questions will address a variety of areas. These usually include Market Sizing, Business Operations/Strategy and Logic but could include some brain teasers too to test out your financial and business sense.

The first place to check out is the consulting firm websites themselves. They want you to do well and many of the firms have lots of tips and guidance, practice questions and help to get you through.

McKinsey –  Four practice case studies to work from here

Oliver Wyman – two practice examples here

Accenture – has an excellent array of videos on youtube for general information about the work they do with plenty of interviews with current consultants. However, their interview prep section is surprisingly lacking. There are five short videos on the ‘Essential Skills’ consultants need here which are worth looking at to understand the competencies Accenture are looking for in their candidates

This document from Accenture explains how to do generally do well in interviews And the Interview webpage has a short list of points to heed

LEK – has a useful youtube channel. This video on the general case interview is helpful and the interview playlist has some further worked through examples.

Bain & Company Two practice cases and videos that go through questions with three answers – see if you can work out which is strongest.

Booz & Co Very short bullet points on what they’re looking for

OC&C Consultants One short case study example here in this pdf

A helpful video from a small consulting firm here, but a good helpful walk through of the case interview

Now watch this full half hour interview on how to crack the case study so you know what to expect when you’re the one sitting there!

Next, here are the top three Case Interview Gurus and their books and websites to check out…

1) ‘Case Interview Secrets: A Former McKinsey Interviewer Reveals How to get Multiple Job Offers in Consulting’ by Victor Cheng to go with his website which gives free advice upon subscription to a free newsletter. This book has won praise from its explanation of the rationale behind the case interview process. When you know what the interviewer is thinking it can really help your understanding of how you can make your answers better.

Victor Cheng also has a recorded presentation here

2) ‘Case in Point: Complete Case Interview Preparation’ by Marc P. Cosentino is the book to go with his website The Wall Street Journal named it the MBA Bible so it is worth a read with 40 strategy cases and many other types of question too. Here you can watch a 2 hour workshop on case interview success on his website The website also offers some other useful resources including the following short pages on tips for acing the case interview a simple framework for working through the case interview and the ‘commandments’ to follow On the flip side, have you ever wondered what the Interviewers are thinking? Well this pdf is aimed at those who are actually setting the questions – but potential applicants can read this to understand what they are looking for in answers 

3) ‘Crack the Case System: Complete Case Interview Prep’ by David Ohrvall includes 150 integrated videos on the website You can see one free example practice case here:

And here are 10 more useful resources to check out and improve your case interview knowledge:

1) A HUGE document here from the business school at Emory University which goes through literally hundreds of questions. It starts with getting the consulting interview but then goes onto detailing all the aspects of an MBA ‘in a nutshell’. This includes case study scenarios (helpfully listing the firms from which they originate) and which could be useful to take a look at for practicing your case study technique. Definitely take a thorough look through this for practice questions.

2) A pdf guide from Ace the Case that goes through the entire case study process, including all the sections and worked through examples and comments on what the interviewer may ask and extend the discussion further. A definite must read!

3) An even more important document to read through! Written by the Columbia Business School it goes through the dialogue of case interviews to show how they progress and what interviewers may ask. Follow the work through examples and see if you would respond in the same way.

4) A good pdf guide from Yale on how case studies are structured and includes some clickable links for further info at the end.

5) This is a really useful tool for the case interview as if you know all the vocab they might throw at you in a question then the method of calculating it shouldn’t be so daunting. This website also offers three free sample interview questions for Business Problems, Market Sizing and Logic before you have to pay to access more material. Only $14.95 for the ebook too

6) Worried about those awkward silences in an interview? Targetjobs advises thinking aloud as a way of processing your thoughts – it’s certainly much more helpful for the interviewer than you sitting in silence!

7) A few useful tips on structuring your answer but note that the links are old and broken.

8) Not worked through examples though which is slightly less helpful. But plenty to work through to practice your technique

9) Loads of examples here but requires a $6.99 monthly subscription to read the whole articles

10) Buy 11 case studies for $49.99 from Wall Street Oasis .

Powerful Powerpoints – Top tips for making great presentations

We’ve all been stuck in seemingly never ending presentations before….but don’t let that happen to your audience when you’re up at the front! Prevent ‘death by Powerpoint’ now and take heed of the tips below…

1) Firstly, let’s start out with a nice video on how to spice it up

2)  A massive 71 little tips here on how to smarten up your presentations and make them more professional and effective.

3)  10 tips to prevent ‘death by Powerpoint’

4) Three blog posts from Consultant’s Mind about how to make your Powerpoints better. Definitely advice to follow as the blogger is indeed a management consultant.

5) A good range of topics covered by Management Consulting News here with 7 articles and 2 podcasts via interviews with consultants and their advice.

6)  An Agony Aunt response to the often asked question ‘How can I make my powerpoint amazing?’ Includes the 5 rules of Powerpoints which if followed should be a good preventative measure against boredom.

7) This is a really good blog post geared for consultants with plenty of pictures to illustrate the differences in style that changes can make

8) Interview with consultant David Tracy about how to make a good professional consulting presentation

9) Another consultant interview about driving the message you are trying to put across

10) Yes, this is a Powerpoint on how to make a good Powerpoint, focusing on the style used by consultants

11) Ten tips from Strategy Expert here and the website also includes free Powerpoint templates

12)  Some really useful tips here for if you are giving a presentation to Senior Management – the audience of your presentation will dramatically affect what you should and should not emphasise in your Powerpoint.

13) Wondering what models you should put in your Powerpoint to display your data? This series of more technical posts gives a list of useful templates used by consultants e.g. SWOT analysis, 5 Forces Framework etc. Includes McKinsey and BCG templates and tips on how to use them

14) 10 more tips on how to make your Powerpoint stand out

15) A few short tips here but aimed at consultants

Finally, check out the previous post on the amazing new presentation tool Prezi to zazz up your presentations!

Beginner’s Financial Modeling

Management Consultants can come from many walks of life and have a background of a variety of subjects. The recent History graduate about to start at McKinsey is therefore unlikely to have come across Financial Modeling. This is a skill (using Excel of course) that is vital in the consulting industry to complete the research into the companies you have been hired to help. Financial models allow you to analyse large sets of data will help you work out what is and is not working in the business. From this you can therefore spot trends and alter the variables for a more favourable outcome – and provide the perfect financial solutions for your clients.

Financial modeling in Excel involves using VBA and so is considered an advanced Excel skill. It is therefore assumed that basic Excel functions and formatting are known. But where does the ‘advanced beginner’ begin?

1) Firstly, read these 6 points about why a spreadsheet is not a financial model!

2) Now take a look at this article on how to build a financial model. It’s just an overview of the process, not a technical guide.

3) Investopedia gives a clear explanation here of the types of financial models that you can create in Excel and what they mean. There are plenty of links to follow for DCF (Discounted Cash Flow) analysis.

And now for the actual learning how to build them in Excel…

4)  Chandoo has a great 6 step guide which goes through financial modeling from start to finish. Includes loads of pdfs to download including cheat sheets and case studies. Definitely a good place to start learning how to get to grips with financial modeling and Chandoo is well known for its Excel tutorials so if anything doesn’t make sense about the terms used to talk about formatting etc. then the answer can surely be found elsewhere on the website (and often already has hyperlinks added to skip straight to those sections as they are talked about within the financial modeling article!)

5)  A great website of free resources here on all aspects of financial modeling. Includes a really helpful blog and every tutorials comes with Excel and pdf downloads.

6) This Australian site has a good range of materials here – the videos are easy to follow and the downloadable templates mean that you can follow along with them. Includes pdf guides that explain everything step by step too.

7) BusinessFinance has a good range of financial modeling tutorials here, usefully split into shorter topics such as three statement models and discounted cash flow. Aimed at investment bankers but same skills apply.

8)  edupristine’s channel offers 9 tutorials based on financial modeling in Excel. 30-40 minutes each. They are previews of their masterclasses and are good demos to check out.

9) Take a look at this template with 5 tabs showing some of the main forms of financial modeling in Excel.

10) Finally some top tips on how to save your sanity when modeling in Excel!

For paid courses, the top two recommened ones are quite pricey but worth it! Recommended by this course from Breaking into Wall Street offers 43 hours worth of videos on financial modeling and works through real life case studies such as a valuation of Wal-Mart and large mergers and acquisitions worth millions of dollars. You get a certificate for completion as well which can be added to your CV list of skills. Costs $247 and is aimed at the absolute basic Said to be a little harder but more thorough. The basic program is $199 and the premium package is $399 and there is also a $39 Excel crash course if you need to do that beforehand. Includes sample demos on the website (and on Youtube) to see if the style of learning suits you and sample downloads to print too. Also offers public programs across America. You can also sign up for a free newsletter which gives you Excel cheat sheets and finance interview questions which may transfer for consultants.

There is also that offers thousands of free videos in return for a monthly or yearly subscription. For one month it is only $15 and there is this 2 hour video going through all the financial functions in Excel which should be worth the price

And of course, there is always the old fashioned book to learn from. The top ones are:

1) Financial Modeling using Excel and VBA by Chandan Sengupta

And massive plus for this one – you can read it all online for FREE here!

2) Next Generation Excel: Modeling in Excel for Analysts and MBAs

3) Valuation: Measuring and Managing the Value of Companies by McKinsey & Company Inc. (Tim Koller, Marc Goedhart, David Wessels)

4) Mastering Financial Modelling: A practitioner’s guide to applied corporate finance by Alastair Dey

In 1 month be a better Project Manager

Project managing is the name of the game for the high level consultant. Complex projects need to be delegated to your team members, the aims of the project delineated and discussed and then the PM has to ensure that everyone is keeping up with their assigned tasks and checking that the work is correct and up to scratch as well as resolving any conflicts within the team. It is a big responsibility as the success of the project ultimately rests with you. If watching ‘The Apprentice’ has taught you anything, it’ll be that the PM’s neck is always on the line if anything goes wrong! With this in mind, keeping up with the latest project management training is a must – even if you only take one new thing away from reading an article or watching a video, it could be the thing that ensures the success of a project and a happy team.

Accenture’s Essential Skills series has an excellent video here on what project management is for the aspiring consultant

Top 10 Websites with Top Tips:

1) The Project Management Hut seeks to emphasise the difference between a good project manager and a great one in this post. The website also includes plenty of further project management related posts including budgeting, delegating and team building.

2) 20 practical tips on how to ensure your project is successful and also includes 5 tips on how to avoid disaster!

3) Tech Republic is an IT specialist so it is focused in this area but the same 10 practices apply to any project. The key thing to take away from this post is that it is the right mix of planning, monitoring and controlling that makes a good project manager – too much or too little of one will result in conflict and collapse. You can also sign up for the ’10 Things…’ newsletter at the bottom of the page for future tips.

4) Plenty of great whiteboard tutorials from the Youtube channel including ‘How to kick off your project’, ‘Good vs. Bad Project Managers’ and even ‘The Idiot’s guide to Project Management’.

5) A great Dummies help sheet here on the top qualities a good project manager needs

6) This is a great list of famous quotes that will make you a better project manager – sure to motivate both yourself and the team!

7) Workhoppers says ‘Let the plan be your compass that guides you to successful completion’ – importance of the Logical Framework Approach will come in handy here.

8) A simple list of 10 characteristics of a great project manager based on a study of the top rated 2% as rated by their peers

9) Expert coach Rosemary Hossenlopp gives a good tutorial here on what makes a good project manager in the consulting world.

10) Some consultants may never have had any form of low-level project management experience before they started. This guide takes you through the steps for those who are unfamiliar. Includes a free downloadable ebook too!

11) 5 really good tips for ‘savvy project managers’ here – more specific too than the usual ‘be organised’

12)  Written by a project manager herself, this is a great list of 10 tips to ensure your project remains on time and on budget

13) Another good range of tips here on project managing including keeping an open mind for new solutions and listening to others rather than being too dictatorial

14) 5 good tips from a director of project management. Keeping communication flowing is a key point here.

15) Download this Project Management Guidebook for free here and take a read of its useful tips.

16) Take a look at these 10 guidelines for a project manager from a recruiting website – they know what they’re looking for in candidates so definitely a good list of key skills!

17) An interesting blogpost on what makes a good project manager in business.

18) A really great free 14 chapter course on project managing – should keep you going for the next two weeks as well…!



The official certification of project management training is the Prince2 programme. Consultants won’t need this as you learn it on the job, but there are plenty of resources online that relate to those taking this course which can be useful for you.  Basic PM training for as little as $24 A full PMP training course is available for $179.99 but there are plenty of free resources on this website too $499 for the complete course but a demo is available for free and is conducted by the author of the PMP exam guidebooks. Join this website for free live webinars on various PM topics throughout the year.

21 Articles to Help Improve Your Pitch

Sales skills are so important in both freelance and company consulting in order to attract new business. For the clients you have secured, they will expect high class pitches to explain the solutions you are offering. If your pitch flops with a poor performance, you can be sure you won’t be on the recruiting list for the best projects in the future. But if you can make yourself the most persuasive and convincing public speaker with the best structure and control of a presentation, no matter who you are pitching to, you will be an indispensable member of any team that is being recruited.

So have a read of the following 20 articles and improve those all-important skills!

1) To start off, if you can pitch yourself in 60 seconds then you can probably pitch anything. Craft your perfect ‘elevator pitch’ with ManagementConsulted’s 10 do’s and don’ts

2) Following the arc of a consulting project from pitch to strategy to execution, consultant Benjamin Estes offers some good consulting specific advice

3) A really great help sheet from a consultant at Microsoft on how to develop, perform and follow up on a pitch effectively and the questions you should be asking when writing it

4) How do you give the perfect pitch? This is the most comprehensive yet concise set of sheets on how to do just that, including the Trojan Horse and Pizza analogies. In pdf format to print off easily too

5) It’s not just your words but also your body that can speak during a presentation. Forbes lists the top 5 ways to improve your body language during a pitch

6) The Harvard Business Review offers an interesting article here on how to ensure your pitch is pigeon-holed into the correct corrective box – the key is to make the client feel like a collaborator in the process rather than being dictated to

7) Building a rapport with the audience is so important in a pitch. IBM salesman Shamus Brown gives his top 5  Sales presentation tips here He has a persuasive way of writing down his pitch on his website to sell his Persuasive Skills CD (for the princely sum of $297)

8) A great top 10 list on how to give the best pitch from CNBC’s research taken after talking to investors and entrepreneurs.

9) Another list of top 10 pitching tips, though this one includes how appearance can make a difference as well

10) A short little article by the Institute of Management Consultants USA on how to make your pitch stand out against all the rest with titles that hook you – and this article title ‘Management Consulting is Like Sex’ certainly does it as a good example!

11) How do you win more clients to ensure a pipeline of business? Follow these 8 tips!CpDNy 

12) What about the client’s point of view on a pitch? Based from experience as a VP at an ad agency but still relevant for consulting, here are the top tips from the client’s perspective on what they look for in a pitch

13) Don’t think you’re selling emphasis is strong enough? Take a look at Selling Power’s sales management top 10 tips  

14) Looking for a simple template for how you can get the important part of a pitch across? The sentence starters for the top 6 tips here will be useful 

15) Are you a consultant branching into freelance work and looking for your first clients? Take a look at this entrepreneur tips page to bag the clients and generate business with your pitch

16) Although based at website SEO consultants, these detailed 17 tips from the client perspective here can be applied to any sales pitch

17) It’s not about bragging about all the success stories of your past – new clients will want to know how you can help their particular business. Take a look at Rick Conlow’s simple 5 steps to writing a good sales pitch

18) The Guardian offers some good advice on creating a good pitch here and emphasising how important all aspects of it are to the overall performance, from the brief to the goodbye

19) Based on the experience of small businesses pitching to investors but the principles remain the same in this New York Times blog post 

20) Pitching isn’t just about the presentation but also about the proposal itself and how well written it is. Follow Marketer/Advertiser Brandon Eley’s advice here on how to ensure your proposal and pitch are up to scratch

21) And finally, Wikihow actually has some good consultant-specific pitching tips to gain and nurture business


Personal branding to make you a star!

In the consulting world, personality is a big factor in the business – the way you present yourself can really transform your relationship with your clients. And if you’re a freelancing consultant starting your own business, then personal branding is even more important to get your name out there as the one person companies need to hire for their projects. First impressions are really important so make sure your personal brand is saying what you actually want it to say…!

Watch this 4 minute keynote speech by the personal branding guru William Arruda on ‘Personal Branding for Project Managers’

He also has an excellent Youtube channel with plenty more videos with specific advice

Central to initial first impressions of your personal branding is the ‘elevator pitch’. This is around a 60 second round up of yourself and your achievements that can be crafted to get all the essential information about yourself across in a short and succinct way, such as at an initial introduction at a networking event – or indeed on an elevator ride! Take a look at the following 5 websites for some tips…

1) A good article here on what is important to say with a list of books to read at the end to get more inspiration

2) Not sure what you should say? Some good questions put here to help you realise what’s important

3) Finding it difficult to squeeze all you want to say in 60 seconds without speaking too fast? Take a look at these 4 tips to help shorten the pitch.

4) Worried your pitch won’t interest anyone? Read the examples of ‘bad’ and ‘good’ responses and see how small changes in the way you say things can dramatically alter whether the listener wants to hear more.

5) A good explanation from the Harvard Business Review about what an elevator pitch is and how to make it better.

6) An excellent scenario setting of how people react when asked to ‘tell me about yourself’. The 5 step breakdown of what the pitch should include is really helpful.

There’s even an interesting article in the Harvard Business Review that your smartphone might be the key to making your elevator pitch stand out in the future… and another that a ‘dumbwaiter’ pitch is perhaps more important than the ‘elevator’ one 

Elevator pitches aside, personal branding extends to online presence and general demeanor. How do you build upon your personal brand? The following websites give some of the best tips…

1) 10 steps on how to brand yourself. Includes two worked through examples. This website also offers a service of managing what comes up when you are searched on Google.

2)  A website aimed at leadership for women, to encourage them to not be reserved in corporate environments. Includes an article on ‘To be or not to be humble’ with a very appropriate quote from C.S. Lewis that “Humility is not thinking less of yourself. It is thinking of yourself less”

3)  14 tips to ensure your personal brand rates high on Google listings!

4)  A worksheet to help you work out your personal brand

5) What makes a great consultant? Better find out to ensure you’re branding the right traits in yourself!

6) Light-hearted but with some useful ideas.

7)  More aimed at a business and how to fulfil a great atmosphere with the best people – but consulting is about that too as a project manager and their team!

8) An extensive article going through plenty of personal branding techniques – again relevant to people starting businesses but most of these apply to consultants too.

9) Another Top 10 countdown for personal branding including an interestying Tedx video with Simon Sinek explaining how great leaders inspire action.

10) Still unsure how to use LinkedIn’s full potential? These 21 tips will show you how to boost your personal brand on this up and coming site.


Strategic thinking in a month – 30 top links

Strategy is probably one of the most important things a consultant has to learn on the job. Each firm is slightly different in their approach but the overall aim is the same – have a great strategy and the project will be great.

But getting a strategic mindset requires time and practice. Get ahead of the game and start to learn some strategic thinking before that interview. Read one of these articles/watch one of these videos each day and within a month you’ll go from novice to pro!

1) Firstly, let’s start with this good animated video on how to create a strategic business plan. Focuses on three questions to ask when creating the plan. Consultants often need to give this sort of advice to help the company realise it’s vision.

2) The British Council offers this little tutorial on what strategic thinking is. As a government organisation they are used to using strategic planning all the time so useful advice to heed.

3) The Harvard Business Review gives a rundown on different ways in which to expand your strategic thinking

4)  Wondering what the key skills are to train your brain to be strategic? Well here they are!

5) A really great forum post here about how to be a good strategic thinker. Includes a table outlining the differences between a strategic and non-strategic thinker and the Wootton and Horne 3 strategic activities

6) Aspiring to be a McKinsey consultant? This article explains the 7S Framework used by McKinsey to address problems.

7) McKinsey’s own detailed article here on thinking strategically is obviously a must read. It’s mainly a run down of how strategic thinking has developed over the years but all of this should be understood to gain a better understanding of how strategic thinking is developing.

8) Are you a strategic leader rather than a lackey? 6 habits of strategic leaders. Includes a video

9) A good article including a flow chart of a strategic planning model, explaining the role that strategic thinking plays in business.

10) Written by a consultant, this excellent list shows how projects work and the fact that ‘the soft skills are the hard skills’ a lot of the time.

11) A pdf version of an extensive powerpoint presentation on being a strategic thinker. A definite good thing to read through as includes useful flow charts and bullet point questions to show you how to think like a strategist.

12)  Rich Howarth, CEO of the Strategic Thinking Institute, gives an 10 minute presentation at a conference on how to develop your strategic thinking skills. He has worked with some of the largest companies in the US so he knows his stuff…!

13)  Here is an interview with Rich Howarth too!

14) This article succinctly explains why strategic management is needed – that’s where consultants come in!

15) Five characteristics of great strategic thinkers – make sure you fit this model!

16) A quick rundown of what a successful business plan should include

17) Harvard Business Review article explaining how to develop strategic thinkers within an organisation – again advice that a consultant would probably give on a project.

18) Another Harvard Business Review short article on how to strengthen those strategic thinking muscles!

19) CEOs often have trouble implementing their strategic plans, or making them clear to their team. Here is a list of nine improvement suggestions that a consultant would typically make.

20) Seeking to demystify the art of strategic thinking by explaining how to make a causal diagram and follow the logical progression of a project.

21) A short Forbes article on how to improve strategic thinking

22) This page goes through how to conduct SWOT analysis in order to understand where a business is at and to develop a business strategy from the results.

23) A good set of steps on putting strategic thought into action – transcript along with video.

24) A pdf on strategic thinking and a useful set of pitfalls to avoid

25) A really good set of five elements of strategic thinking that are essential to think about

26) There are a selection of articles on Strategic planning on and here is one on how to implement a strategy across a business

27) An excellent article from McKinsey again on how executives can think more strategically.

28) A really useful detailed tutorial here on how to develop strategic thinking. Includes plenty of models and diagrams to visually represent the thought process

29) An interesting list here of the blog writer’s top four strategy models. It is in reference to the book ‘The Decision Book: 50 models on strategic thinking’ by M. Krogerus and R. Tschappeler

30) Finally this is a short clip from the Capture Your Flag series on Youtube – an excellent channel which gives inspirational messages via interviews with people at the top of their professions. Here, consultant Audrey Parker says that being a listener rather than a talker is a much better strategy for being a consultant.


If you’re looking for a book to supplement this list, take a look at

– Thinking Strategically, the Pocket Mentor guide from the Harvard Business School Press (2010) – the HBS is always a good source of business info and developments

– Thinking Strategically: The Competitive Edge in Business, Politics and Everyday Life by Avinash Dixit and Barry Nalebuff (1993) – voted into the Top Ten Financial Times Bestsellers list. It is more of a guide in how to beat rivals but businesses obviously have to understand these tenets to outdo their competitors

– The Boston Consulting Group on Strategy: Classic concepts and New Perspectives (2006) – BCG has been at the top of its game for 40 years and this new edition of their strategic techniques brings together new ideas, insights and lessons. It is set out in the form of articles that were published in the Harvard Business Review or for clients so can be quite dense and challenging but is meant to expand your knowledge.

– The McKinsey Mind: Understanding and Implementing the Problem-Solving Tools and Management Techniques of the World’s Top Strategic Consulting Firm by Ethan Raisel and Paul Friga (2001) – This book is part of a trilogy of books printed by McKinsey that outline the way in which consultants work within their company. With real-life examples of strategic thinking in action within a consulting company, this is a definite must read!

– Be Your Own Strategy Consultant: Demystifying Strategic Thinking by Tony Grundy and Laura Brown (2001) – recommended for MBA courses, aimed at company chiefs trying to use strategic thinking for their businesses without having to use outside management consultants…but as an aspiring consultant you can take all the tips for the advice you would give on your projects!

60 day Excel Expert

Excel is the saviour for most consultants looking for quick ways to calculate and manage data and make financial models. But the knowledge needed to perform these tasks efficiently is vast and complicated. So to simplify it for you, here is the ultimate Excel list of things to know about this programme for consultants. Short bursts over a long period of time will ensure that these become innate skills. So click on one of these links each day, watch the videos and read the articles and over the summer before you start your graduate placement, you’ll be ahead of the game!

Basic Introductions

Day 1 Learn the Excel interface – Probably the most basic introduction to the Excel interface and what different things in Excel look like and do. Simply an explanation of how the programme works and how to perform basic tasks.

Day 2 Sort a list – Needless to say, sorting lists can organise your data in more practical ways and it is very simple as Excel has the capacity built in to do this. Here are three ways to use it

Day 3 Filter unique items on a list – Sometimes you may want to filter lists according to specific criteria. Read this basic intro to filtering out data and removing duplicates in the sort

Now watch this short video on sorting and filtering to recap

Day 4 Create a Custom List – When looking to sort according to criteria that Excel can’t do automatically such as alphabetically or numerically then you will need to create a custom list. This article shows you how

Day 5 Basic SUM, AVERAGE and MAX/MIN functions – This is a quick video intro to entering data and using these simple functions using a very basic table of data.

Day 6 Customise and format data – Excelteacher offers a video tutorial here on how to generally customise Excel worksheets with colours and formats and how to protect them from interference.

Day 7 Pull data from a website – This is obviously an important skill to learn if using client’s data that is available online.

Day 8 Cell references – Understand the difference between relative, absolute and mixed cell references in this short article

Day 9 How to Print a spreadsheet in one page – Excel has a tendency to be awkward to print due to the tabular form of the interface but there are ways to ensure that it all fits onto one page and is formatted correctly.

Day 10 How do functions and formulas work? – Excel seems like a very complicated programme when you start using it as there are lots of seemingly random symbols used within formulas to calculate things. Read through Microsoft’s overview of formula construction here and understand what the symbols you will be using actually mean. Essentially, a formula is an expression which calculates the value of a cell whereas functions are predefined formulas and are already available in Excel. So you insert functions such as SUM, AVERAGE, COUNT etc to create a formula that performs calculations on certain cells (which would look for example like =SUM(A1:A2). This could be written out like =A1+A2 but the SUM function is a quicker and easier way to perform such a task in Excel). 

Managing Data

Day 11 Using the ‘Fill’ command – There are several ways to fill data or formulas into multiple cells. This article shows you four types, from dragging the Fill handle to using a Custom Fill.

Day 12 ROUND – It is often useful to ROUNDUP or ROUNDDOWN when making reports in order to make the numbers easier to handle. This video shows you how.

Day 13 CEILING – This is also relevant to rounding as it caps the number of digits displayed in the cell.

Day 14 Nesting functions – This is when two or more functions are used together in one cell to make a calculation. You can use up to 64 levels of nesting in one formula so they can get quite complicated but do follow logical pathways. Read the short explanation here with the SUM and ROUND example

Day 15 RANK – This function is used to compare numbers against each other.

Watch the short Contextures tutorial here on how to use it

And read techrepublic’s more technical post on the language input here

Day 16 VLOOKUP – This function allows you to search for information across vertical columns (that’s what the ‘v’ stands for!) Read how to use them here The basic construction is =VLOOKUP(what,where,inwhichrow,true/false)

Day 17 – HLOOKUP – Just like VLOOKUP, but the ‘H’ means ‘horizontal’ so is only used for rows. It is not used as much as VLOOKUP as usually tables are based on vertical columns, but it still a useful counterfoil to understand.

Day 18 – MATCH and INDEX – As VLOOKUP and HLOOKUP are restricted by either the vertical or horizontal axes they are searching, many argue that MATCH and INDEX are better to use. This businessinsider article explains why and Mr Excel explains how to use them too

Here is a quick summary of all the lookup functions:

Day 19 – Using VLOOKUP info from different workbooks

Day 20 – Advanced filtering techniques There are plenty of ways that data can be filtered so read through this more extensive list of different filters you can create (includes worked through video examples)


Logical Formulas

The following inputs create a formula which will carry out a different calculation based on criteria that you specify.

Day 21 – IF Statements This function is used to work out statements that will come out TRUE or FALSE

Watch the ExcelIsFun video below with 7 worked through examples

Day 22 IF THEN ELSE You can add more and more conditions into IF statements in order to affect the TRUE or FALSE outcome. See how to use the words ‘THEN’ and ‘ELSE’ here

See this short video here too

Day 23 IF AND OR  

A short explanation of how IF statements work with AND/OR 

And watch this video on compound IF statements

Day 24 Logical formulas in practice  Using a simple chart to get to grips with these functions, Excelteacher goes through these functions.


Array Formulas

An array is a group of cells that are related e.g. in adjacent columns or rows. An array formula is therefore a formula that works with a series of data values rather than just one. It returns either a single value or an array of values into a selected cell or array of cells. Read the basics in this blog post here

Day 25 SUMPRODUCT – This function calculates the SUM across an array of cells. Follow the input steps here

Day 26 SUMIF – This is used to add up the SUM across a certain number of cells that meet specified criteria. Here’s a five minute lesson on how to use this function:

A large range of examples and more complex SUM calculations including videos can be found here at Contextures

Day 27 COUNTIF – This function calculates the number of times that a value occurs within a set range of criterion. This article explains how to use it:


Text inputs

Day 28 LEFT, RIGHT and MID – These functions cut text from the left, right or middle to simplify the data.

Techrepublic goes through an example to explain how this is useful

And here’s a Danny Rocks tutorial on how to use these three functions

Day 29 CONCATENATE – This word means ‘to combine’ and is therefore used in order to combine information from different cells that involve text, cell references or blank spaces (otherwise it would be a SUM or other numerical function). It can be used for up to 255 text entries.

Watch the ExcelIsHell tutorial here

And here is a printable example sheet too

Day 30 LEN – This function tells you the character count of a piece of text inputted into a cell. It is very simple to use as LEN is just added with the cell number you want to know.

Day 31 FIND – Similar to VLOOKUP but used to search for the position of specific text within the worksheet. Watch out, it’s case sensitive!

Day 32 Date and time arithmetic – The symbols / and – need to be used when inputting dates and Excel has the capability to add dates and times together too. Follow the Excel Easy article here on how Chandoo also has some Top 10 tips too

Day 33 Formatting Textual Information

A good video here on formatting textual information so that Excel treats the data as numbers but places the correct information in front (e.g. dollar signs, AM/PM, percentages)


VBA and Macros

VBA is the ‘language’ used to create functions and formatting in Excel. So all the functions above are in this VBA ‘language’ but are inputted into each cell rather than into the code. If you use VBA then you have created a macro. This is a very large and complicated topic and goes all the way to configuring the programme. But work through the following links to get the basics on how to do more complicated sums and calculations.

Day 34 Create a Macro – basic intro Read this HowtoGeek intro into what macros are with plenty of screenshots to help you navigate.

Day 35 Macros from Easy to Intermediate Go through the short videos and accompanying text here on everything to do with Macros from easy to intermediate levels.

Day 36 How the VBA InputBox works – Follow this article that uses an example VBA code and what it shows

Day 36 Practice Macros and VBA Use Microsoft’s 30-40 minute tutorial here to check everything is understood.

Day 37 Apply conditional formatting This function allows you to apply certain formats depending on the criteria that you set e.g. any number over 5 turns the cell green. This is a useful tool for you to visually analyse large sets of data quickly

Watch this video to see it in practice

Day 38 VBA Cheat Sheet Read this Dummies cheat sheet that goes through most of the VBA language that you will come into contact with. A good reference sheet for the future too.



Excel is not built for high level statistics but can easily deal with simple statistical problems that a management consultant is likely to come across.

Day 39 Quick Descriptive Statistics This Excel function allows you to see the main statistical outcomes of a set of data at the click of a button. It automatically calculates mean, average, sum, skewness, standard deviation etc).

Day 40 Correlation and Regression Read this help sheet from page 2

Day 41 TREND – This function calculates the trend line through a given set of y and x values. Of course this is easier to see on a graph but this function enables you to complete the maths behind the graph line.

Here is a short video on using TREND with a simple linear regression

On Trend Analysis, Wikihow has quite a detailed description of various methods you may come across.

Day 42 STDEV – Short for ‘Standard Deviation’ which can be calculated from lists of data. Enter STDEV and the range of cells you want to calculate it for. Watch the simple video tutorial example here:

Day 43 VAR – Short for ‘Variance’ of a set of data. Simply explained by Microsoft including the statistical equation this function is solving

Day 44 FREQUENCY – As the name suggests, this function shows how many of a certain type of something are mentioned within a data set. Some examples given here on how it works

Day 45 – Statistics overview Follow the Microsoft training website for their 50 minute tutorial on everything about Excel statistics. Includes some practice examples too that will ensure you understand all.


Financial Modeling

Day 46 How to create financial scenarios in Excel – Financial Modeling is an important feature of Excel for consultants as it allows for the manipulation of the inputted and managed data to come to decisions regarding investments or profitability of a company.

Watch this 15 minute edutechional video on various types of scenarios that can be modeled within Excel

Chandoo offers a 6 part intro into how to start building financial models and project evaluations here

Day 47 DCF (Discounted Cash Flow)

This is a type of analysis used by consultants to value a project, company or asset over time. All the future incoming and outgoing cash flows are estimated and discounted to give Present Values (PVs). Follow this step by step blog post here on what to do to work out the DCF of a set of data

And the well known Wall Street Prep offers a video tutorial here

Plus there is a free template download available here to start building your own DCF model

Day 48 NPV (Net Present Value)

This is simply the sum of all future cash flows worked out during the DCF calculations to estimate the overall present value of a company. Your clients are sure to be wanting this to be a high number and your job may be to find solutions to get this number up!

Watch the ExcelIsHell video to see how!

Day 49 IRR (Internal Rate Return)

This is a term used in capital budgeting to work out the profitability of investments. Again, another term that is going to be very useful for consulting work. Follow this friendly voice through the IRR tutorial

Day 50 WHAT-IF analysis Allows you to try out different scenarios for formulas depending on the criteria you set. This function is therefore very important for management consultants when working out what types of mathematical solutions they can offer to the client based on the data they have researched/provided. Read the Excel Easy article on how to use it here

Day 51 Solver and Goal Seek Indeed Excel now offers tools that find optimal solutions to all kinds of decision problems! Solver can take into account constraints and variables and Goal Seek is used to find a result when you are not sure of the starting value. Find out how Solver works here  and for Goal Seek check out


Visualising Data – Reports and Charts

Day 52 How to create a graph or chart from worksheet data

As creating charts is a very visual skill, GCF Learn Free has a great slideshow like page here that goes through the different types and how to create them.

Day 53 Creating a Gantt chart This type of chart is used a lot by management consultants as it is used for project management. Tasks are shown on the vertical axis, and the project time span is represented on the horizontal axis. Each task has a corresponding bar that shows the time span required for that task. The bar can be filled in to show the percentage of the task that has been completed.

Watch this video tutorial that goes through how it works

And you can use a free Gantt template to work from here

Day 54 – Sparklines A new feature in Excel 2010 that offers graphical lines in a cell to chart the rise and fall of the values entered in the column/row

Day 55 Create a Pivot Table

They are considered an advanced Excel skill but are not very hard to create! Watch this short video with transcript below.

Now watch this excellent longer worked through example

Day 56 Power Pivot a Pivot Table This is a new function of Excel that allows larger sets of data known as ‘Power Pivot’ to be entered into Pivot Table analysis.

Watch Microsoft’s quick explanation of how to create a Pivot Table using Power Pivot data here

Day 57 Pivot Charts These enable the user to visualise Pivot Table data. Excel Easy shows how to quickly do it But for a more fancy interactive format, watch the following video

Now Check out this 6 page guide and download the practice workbook to try out your newly learnt Pivot Table skills!

Day 58 – Create a Summary Report Reports will be vital for your consulting career as ways of visualising and summarising the data that you have collected and researched. Here is the Dummies rundown of how to create one

For a quick overview of Summary reports, watch this

Day 59 – Create a Key Performance Indicator (KPI) Dashboard Report Another vital reporting technique that all consultants will be using at some point. The dashboard is designed to consolidate KPIs from numerous areas of the business research to increase the visibility of business-critical information to the end-user (the client). They are also particularly useful as they can be interactive with graphs changing according to other criteria that are clicked on.

See this 9 minute video to build a simple KPI dashboard

For other types of Dashboard report, see Chandoo’s  templates and tutorials here



Day 60 – Refresh and Consolidate! And there you are! You did it! Now you should have a pretty good understanding of most of the things you will need to know in Excel but it is important to refresh and consolidate this knowledge. Spend this final day looking back over the skills you have learnt over the last 59 days and ensure you remember them all. There will always be more to learn and your skills will improve on the job, but as a good starting point for your management consulting career this course should equip you with the necessary knowledge. For now, we dub thee an Excel Power User!


Other useful resources

Here are some more useful resources which cover more topics than were appropriate for the daily quick fire tutorials. A good FAQ list with simply explained answers including codes to enter and screen shots. A really good pdf here of all basic Excel knowledge from navigating the windows to inputting data and creating charts. The checklist for the Excel course – useful to compare your skills to what is listed here A printable statistics revision sheet from the University of Texas