Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
1 Hour(s) 55 Minute(s)
Language
English
Taught by
Lucas Lin
Rating
Course Overview
A no-nonsense crash course on Excel for consulting analysis, taught by an ex-BCG consultant and ex-Amazon PM
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)
Course Content
- 7 section(s)
- 40 lecture(s)
- Section 1 Introduction
- Section 2 How to navigate quickly in Excel
- Section 3 How to clean data in preparation for analysis
- Section 4 How to analyze data
- Section 5 Practice Assignment
- Section 6 How to format your output
- Section 7 Best practices for structuring your workbook
What You’ll Learn
- Navigate quickly around Excel (without using a mouse)
- Clean data in preparation for data analysis
- Use dynamic formulas to conduct detailed data analysis
- Use beautiful and best-in-class formatting
- Structure your workbook to be clear and auditable
Skills covered in this course
Reviews
-
YYuna Ko
Thank you sir for this course. It will help me be more professional in my career.
-
KKatjia M
I like the way the instructor explains the differences between the more complex formulas like sumifs, averageifs, pivots, and index matching - I was always confused about when / how to use what before but this helped clarify
-
MMike Gover
Great course - it covered all the key formulas I expected and more, and gave me shortcuts that I found too hard to follow in the past. Lucas does a good job of repetition and reviewing / incorporating past lessons in the later sessions in the course.
-
PPayole Vele
Exceeded my expectations in terms of depth and comprehensiveness
