Take any business problem, and solve it using structured (consulting-like) problem solving tools
Analyze data in excel using all of the most useful excel tools for real world data analysis
Get around excel like a pro with an excel keyboard shortcut game
Evaluate advanced scenarios and sensitivity analyses with your model in just a few steps
Most of this training is Excel version agnostic. A few lessons require: Windows PC Excel 2007+ or Mac Excel 2011+
Requires only a very basic understanding of Excel (getting around the ribbon, formatting and basic IF statements)
*** This training teaches you: 1) All of the crucial excel techniques you should care about: including model structure, data handling, smart lookups, aggregation & basic statistics, tables, pivot tables, charts, VBA macros & custom formulas, and many more. 2) Unlike other training, I'll teach you how to combine these tools to solve real world problems, and help you stand out in any analytical environment.
*** Learn, then immediately apply your new knowledge:
Bite-sized and Step-by-step curriculum, so you can learn one skill at a time, combine it all into a single beautiful model output.
The only Excel techniques and tips you'll ever need, from over a year of research, and ten years of experience.
Learn to "manage upwards" so that you, the Modeler, don't work all night.
Hands-on case study approach, to practice what you learn on a real problem. All starter materials provided for each course so you can get started quickly.
Holistic model design focus, so that your models to scale, adapt and evolve easily.
Keyboard shortcut game, coded in Excel, so you can get around Excel lightning fast.
Who this course is for:
Students / graduates trying to get hired for analytical skills
Consultants and corporate analysts looking to develop core skills
Entrepreneurs needing to model their new businesses
Experienced professionals trying to brush up on new tools
9 sections • 67 lectures • 16h 21m total length
BEYONDFORMULAS - Download all course materials
COURSE HANDOUT - Accompanying slides for each lesson
EXCEL EFFICIENCY - Course materials
Keyboard shortcut game: Improve speed, save HOURS
What is "Modular Model Design" and why should you care?
Avoid embarrassing yourself: Reduce spreadsheet risk to preempt mistakes
[optional] ADVANCED: What to do if your model becomes really BIG or really SLOW
Define the Problem: Find true north with a problem statement & audience
Case-study: Creating the issue tree for the Widget Manufacturing Company problem
Prioritize: Find and prioritize the main business drivers
Plan: Plan every detail of each analysis to go from Issue tree → Plan of Attack
CaWiMak Case study - course materials
DATA BASICS - Course materials
Gather real data based on your Analysis & Data Plan
Deal with Bad Data - Process, transform & clean large structured datasets
Got data? Now what? Best practice for importing data into your model
Merging/joining data using a Primary Key+INDEX+MATCH (instead of VLOOKUP)
Use TABLES - Interact with your data using Excel's secret data weapon
Using String formulas to parse & manipulate text fields in your data
Use Dynamic Named Ranges to give your data & cells easy-to-remember names
DATA ANALYSIS - Course materials
PIVOT TABLES: Everything you need to know to instantly summarize your data
I've been building models and teaching excel for the better part of a decade: I learned the science and artistry of Excel problem-solving while at McKinsey and Google, and was consistently recognized for both my ability to analyze business problems as well as my ability to teach others in the firm. I covered a range of industries and functions, gaining experience in global supply chain, route-to-market, organizational design and national education system turnaround strategy.
I am an experienced technology strategist: While at Google, I continued to refine and apply my excel modeling approach within Google's Business Operations and Strategy team (Bizops). I worked on a diverse range of strategy problems including local shopping, digital offers and coupons, display ads, digital media and online privacy strategy.
I am a published author: Frustrated by the sad state of job applications and resumes experienced firsthand through various recruiting activities at McKinsey and Google, I wrote and published a book “Stand out, fit in, get hired." in order to help candidates better think through how to position themselves for roles to which they are applying.