BeyondFormulas: Complete MS Excel Techniques & Modeling (Udemy.com)

Learn all crucial Microsoft Excel Techniques & How to apply them to real-world business modeling problems

( 75 Reviews )

Created by: Brandon Trew

Produced in 2021

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

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 90 / 100

Course Description

*** This training teaches you:
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

Time: 8.5h

Instructor Details

Brandon Trew

4.5 Rating
75 Reviews

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.

Excel Skills for Business: Essentials (2017)
5.0 (432 Reviews)

- Provider: Coursera
- Time: 4h

Free

Excel Skills for Business: Intermediate I
4.9 (463 Reviews)

- Provider: Coursera
- Time: 22h

Free

Excel Dynamic Arrays - Beginner to Expert (Microsoft 365)

Excel Dynamic Arrays - Beginner to Expert (Microsoft 365) (2021)
4.9 (216 Reviews)

- Provider: Udemy
- Time: 7h

$11.99

Visually Stunning Microsoft Excel Dynamic Dashboard Course

Visually Stunning Microsoft Excel Dynamic Dashboard Course (2021)
4.9 (193 Reviews)

- Provider: Udemy
- Time: 7h

$11.99

Excel with Top Microsoft Excel Hacks (2016)
4.9 (95 Reviews)

- Provider: Udemy
- Time: 2h

$11.99

Microsoft Excel Complete Excel Guide (Excel 2007 2021)

Microsoft Excel Complete Excel Guide (Excel 2007 2021) (2021)
4.9 (62 Reviews)

- Provider: Udemy
- Time: 21h

$11.99

All excel courses

Reviews

4.5

75 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

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