BeyondFormulas: Complete MS Excel Techniques & Modeling
Learn all crucial Microsoft Excel Techniques & How to apply them to real-world business modeling problems
Created by Brandon Trew
What you'll learn
- 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
Requirements
- 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)
Description
*** 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
Instructor
Excel Modeling Guru, and published author
- 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.
- I am a proud South African.