Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 44100 Hz, 2ch | Size: 4.02 GB
Genre: eLearning Video | Duration: 67 lectures (16 hour, 21 mins) | Language: English
Learn all crucial Microsoft Excel Techniques & How to apply them to real-world business modeling problems.
What you'll learn Homepage: https://www.udemy.com/course/beyondformulas-excel-modeling-for-analysts/
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
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.
Broknote |
