Скачать или смотреть How to Use Excel as a Consultant

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: https://www.youtube.com/managementcon...

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: https://managementconsulted.com/produ...

Related content to this video:
◈ New Excel Functions: Power Query, XLOOKUP, & Others article: https://managementconsulted.com/new-e...
◈ How Consultants Use Excel article: https://managementconsulted.com/how-c...

Learn about our accelerated case interview prep program: https://managementconsulted.com/black...

Subscribe to our channel: https://www.youtube.com/managementcon...

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

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