The Excel crash course for consulting analysis
- Description
- Curriculum
- FAQ
- Reviews
Do you want to become known as the ‘Superstar Analyst‘ on your team? Want to deliver rapid analysis and insights, but unsure where to start with the various formulas? Still slowly clicking around in messy Excel workbooks?
Excel mastery is an upfront investment that will save you thousands of hours throughout your career. This was one of the best personal investments I ever made which was further honed as a BCG consultant and Amazon PM. I would like to pass on my key learnings.
Consultants, Business Analysts, Data Analysts, and Business Intelligence Engineers pride themselves on rapidly delivering beautiful, dynamic, and structured analysis. If you work in this field, mastering Excel is essential.
After this crash course, you will know exactly how to do that. We will walk through examples of all the important formulas a superstar analyst needs to know, and the little-known shortcuts to do it faster than anyone else.
By the end of this course, you will:
-
Master all the important formulas in Excel that matter, without getting overwhelmed by less important details
-
Know the best-practices used in consulting and tech business analysis
-
Understand when and how to use each formula – you will shine in delivering workbooks that are beautiful and insightful, not just correct
-
Note: This course does not include VBA, Statistical Analysis, or data links to other programs (e.g., Python, SQL)
-
8Insert filters, multiple sortVideo lesson
-
9Create tablesVideo lesson
-
10Find and replace dataVideo lesson
-
11IFERROR for calculationsVideo lesson
-
12IFS for creating buckets in a new columnVideo lesson
-
13LEFT RIGHT LEN SEARCH for manipulating textVideo lesson
-
14LEFT RIGHT LEN SEARCH for manipulating text (advanced)Video lesson
-
15Cleaning datesVideo lesson
-
16Using Excel's Smart Autofill featureVideo lesson
-
26Format numbers quickly, set decimal pointsVideo lesson
-
27Using detailed formatting options in Ctr + 1Video lesson
-
28Conditional formattingVideo lesson
-
29Align text, font colorVideo lesson
-
30Adding cell bordersVideo lesson
-
31Cell highlightsVideo lesson
-
32Use Paste Special to copy formats from another cellVideo lesson
-
33Clear formatting from cellsVideo lesson
-
34Insert and delete comments from cellsVideo lesson
-
35Set row width and column height, Use autofitVideo lesson
-
36Show and hide gridlinesVideo lesson
-
37Color the tabs in your workbookVideo lesson
External Links May Contain Affiliate Links read more