HDTutorial
EN
How to Use Excel as a Consultant

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Use Excel as a Consultant

13,213 views October 23, 2020 10:09

Watch on YouTube
ChannelManagement Consulted

Description from the creator

Do consultants need to know how to use Excel? The answer is 110% yes! Knowing how to effectively use Excel is crucial to your on-the-job success in management consulting. In this video, Jenny Rae Le Roux (former Bain consultant) walks you through understanding how consultants use Excel. In addition, she runs though many of the common Excel formulas and concepts that consultants need to know, along with examples of why they matter. You'll be on your way to becoming an Excel whiz in no time!

Subscribe to our channel: youtube.com/managementconsulted?sub_confirmatio…

Questions we’ll answer in this video:
◈ “How do consultants use Excel?"
◈ "What are the main features in Excel?"
◈ “How do Bain consultants use Excel?"
◈ Do management consultants have to be good at Excel?"

Highlight Timestamps:
01:07- The main features and functions of Excel
01:17- Pivot tables
01:52- V-lookups, H-lookups, and indexes
02:33- Arrays
02:50- Macros
03:28- Shortcuts for formatting
03:47- Conditional formatting
04:09- IF statements
04:29- Min/max functions
04:38- SUMPRODUCT & SUMIF
04:57- Truncating
05:24- Example of how consultants use Excel
07:42- Final rules for using Excel

See MC's Excel for Consulting course: managementconsulted.com/product/excel-for-consu…

Related content to this video:
◈ New Excel Functions: Power Query, XLOOKUP, & Others article: managementconsulted.com/new-excel-functions/
◈ How Consultants Use Excel article: managementconsulted.com/how-consultants-use-exc…

Learn about our accelerated case interview prep program: managementconsulted.com/black-belt-supreme/

Subscribe to our channel: youtube.com/managementconsulted?sub_confirmatio…

Great practical YouTube content from www.managementconsulted.com:
Case Interview Playlist: bit.ly/CaseInterviewPlaylist
Consulting Fit Interviews: bit.ly/FitInterviewsPlaylist
Consulting Resumes: bit.ly/ConsultingResumesPlaylist
Networking for Consulting: bit.ly/NetworkingForConsultingPlaylist

Great intro YouTube content from www.managementconsulted.com:
Consulting 101- All your basic consulting questions answered: bit.ly/Consulting101Playlist
Consulting Firms 101 Playlist: bit.ly/ConsultingFirmsPlaylist
Is Consulting Right For You Playlist: bit.ly/IsConsultingRightForYou

About this tutorial

Management Consulted published this 10:09 video tutorial on October 23, 2020. It has been watched 13,213 times on YouTube.

Category
Education
Duration
10:09
Published
October 23, 2020
Views
13,213
Likes
288

Tags

Share

Further reading

  • Excel & PowerPoint Combo - Management Consulted managementconsulted.com

    Use Excel and PowerPoint like a Consultant. Do you know how to use Excel and PowerPoint like a consultant? Learn from the mistakes our team made when starting out in consulting, and fast-track your way to top performer…

  • How Consultants Use Excel | Excel Skills | The Consulting Experts managementconsulted.com

    Consulting Excel Examples. There are innumerable uses for Excel in consulting. We have been working as consultants for ~15 years, and Excel remains the primary analytical tool consultants use to analyze data. Recently,…

  • Essential Excel for Business Analysts and Consultants | Udemy udemy.com

    If done properly, this course will transform you in 1 day into pretty good business analyst that knows how to use Excel in the smart way. It is based on my 12 years of experience as a consultant in top consulting compan…

This tutorial in other languages