Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
16 Hour(s) 21 Minute(s)
Language
English
Taught by
Brandon Trew
Rating
Course Overview
Learn all crucial Microsoft Excel Techniques & How to apply them to real-world business modeling problems
*** 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.
Course Content
- 1 section(s)
- 67 lecture(s)
- Section 1 INTRO: Learn to solve problems in excel, instead of just formula syntax
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
Skills covered in this course
Reviews
-
RRafael Torcende Aro
I am not yet done with the course, but all I can say is this: this is a super course! The course doesn't just teach you Excel. But rather, practical skills that you can apply in the business world. I was reading the book "Bulletproof Problem Solving", but I was looking for a course that would show me how to apply the idea of the book in business settings. Thankfully, I found this course. I hope the author will update this course. Also, I hope he will create another course.
-
OOmkar More
Not use, definitely need instructions on what to do, Can't assume what can be dome
-
PPale
I hope so, it looks like something that will be helpful for my work. Still, long way to go.
-
KKeith Penman
Excellent course! I have been using excel for a long time, and have taken several excel courses. This course is really helpful in providing best practices for excel. Thanks so much Brandon!
