filmov
tv
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!
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
Related content to this video:
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
Related content to this video:
0:15:54
Excel Tutorial for Beginners | How to Use Excel
0:32:49
Microsoft Excel Tutorial - Beginners Level 1
0:21:47
The Beginner's Guide to Excel - Excel Basics Tutorial
0:00:38
How to use the SUM function in Microsoft Excel
0:12:29
Excel Formulas and Functions Tutorial
0:27:49
Introduction to Microsoft Excel - Excel Basics Tutorial
0:22:11
Microsoft Excel Tutorial - Beginners Level 2
0:07:08
Microsoft Excel for dummies - learn the basics of Excel
0:00:33
=REGEXREPLACE in Excel‼️ #excel
0:52:40
Excel Formulas and Functions | Full Course
0:13:22
Excel Pivot Table EXPLAINED in 10 Minutes (Productivity tips included!)
0:09:46
What is Excel and How to use it?
0:00:56
How to use the SUMIF function in Microsoft Excel
0:10:47
Excel Formulas and Functions You NEED to KNOW!
0:02:37
Dollar Sign $ in Excel | Excel in Minutes
0:32:09
VLOOKUP in Excel | Tutorial for Beginners
0:03:42
How to Create a Table in Excel (Spreadsheet Basics)
0:03:16
How to Create Data Entry Forms in Excel - EASY
0:02:38
How to use VLOOKUP in Microsoft Excel
0:19:48
How to Pass Excel Assessment Test For Job Applications - Step by Step Tutorial with XLSX work files
0:28:42
Microsoft Excel Tutorial for beginners - Malayalam
0:01:01
How to use VLOOKUP in Excel
0:24:25
Microsoft Excel Tutorial - Beginners Level 3
0:03:57
How to Make a Totaling Column Formula in Excel : Using Microsoft Excel
Комментарии