BeyondFormulas: Complete MS Excel Techniques & Modeling (Udemy.com)
Learn all crucial Microsoft Excel Techniques & How to apply them to real-world business modeling problems
Created by: Brandon Trew
Last updated November 2020
What you will 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
How it compares
Against the other 355 rated Udemy courses in Excel on CourseDuck:
- Rating4.6 out of 5higher than 63% of them
- Reviews330#254 of 356 by number of reviews
- Length16.4 hourslonger than 86% of them
- Last updatedNovember 2020earlier than 72% of them
Course Description
1)All of thecrucialexceltechniques you should care about:
includingmodel structure,data handling, smart lookups,aggregation &basicstatistics,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 skillsConsultants and corporate analysts looking to develop core skillsEntrepreneurs needing to model their new businessesExperienced professionals trying to brush up on new tools
Instructor Details
- 4.6 Rating
330 Reviews
Brandon Trew
- 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.
More Excel courses
Microsoft Excel Data Analysis - Learn How The Experts Use It (2026)
5.0 (5,696 Reviews)
Provider: Udemy
Time: 3h
$39.99
Microsoft Excel: Advanced Dashboard Design (Project-Based!) (2026)
4.9 (4,868 Reviews)
Provider: Udemy
Time: 6.4h
$99.99
Master NEW Excel Functions in Office 365 & Office 2021+
4.8 (5,262 Reviews)
Provider: Udemy
Time: 7.1h
$15.99
Microsoft Excel Certification Exam Prep: MO-201 Excel Expert (2026)
4.8 (3,239 Reviews)
Provider: Udemy
Time: 8.6h
$119.99
Reviews
By niti kukreja on 6/17/2020
Fantastic course!! It is very hard to come across such an excel course on the internet. The instructor has put in lot of hard work in this course.
By Jasper Boerrigter on 4/18/2020
+ Great speed, great depth and good variety of different skills. No waiting times.
- The course is quite advanced. Repeating basic activities like "Drag to the right"; "hit tab to complete" is only needed for beginners, but that's not the public being addressed
By Allyson Torsak on 4/3/2020
Confusing. Im not sure what IM supposed to be doing
By Michael Huntington on 2/26/2020
Well thought out
By Hani Haidar on 2/2/2020
Yes
By Sahil Sharma on 1/26/2020
Unclear and hasty instructions . Instructor should take a simpler approach (use sample numbers and teach usage of formulas on them first rather than using them directly in complex data sets)
Not at all what was expected.
By Jeremy Lim on 1/20/2020
Really powerful lesson, clear and concise and easy to follow through
By Siddharth Shriram Shimpi on 1/16/2020
Instructions are very clear. I am able to follow it.
By Yves Crehore on 9/12/2019
This query comes at the end of the first really intro. Haven't seen enough yet and as all courses just passed through the "Promise Delivery" phase the instructor gives at the beginning. Have to see more still.
By Andy Mannion on 8/13/2019
Huge file and deeply irritating delivery
By Grant Wykerd on 7/24/2019
So far just what the Excel Doctor ordered... I lack structure and having learnt MECE has enlightened me while simultaneously growing my analytical skills base!!!
Still a ways to go, but loving it!!!
Ps. Better understood and accomplished if you have Some Excel knowledge...
By George Macaluso on 5/12/2019
awesome cant wait to learn more structure
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 92 / 100






