Elevate Your Excel Modelling Skills

Boost Your Speed, Accuracy and Clarity to Become an Exceptional Analyst
What you'll learn
How to structure an excel financial model the right way
How to develop accuracy
We will go through specific techniques which will enable you to increase your speed
How to infuse 'clarity'
Requirements
Computer and Microsoft Excel
Description
In Part 1 - I will teach you how to structure an excel financial model the right way, so that it forms a good foundation which will enable you to provide insights with speed and accuracy. When you set up your model the right way, it will be user friendly and easy to understand, eliminating future confusion. it will be easy to update and easily expandable to cope with changing user requirements. It will also prevent the need to 'rework' or 'redo' your model repeatedly and avoid wasting time and effort in the future.In Part 2 - I will teach you how to develop accuracy, so that your excel financial model is trustworthy and does not give you any unpleasant surprise. This will in turn transformed you into a more trusted analyst in the eyes of your customer.In Part 3 - we will go through specific techniques which will enable you to increase your speed, so that you can develop your excel financial model quickly. So that you can be faster and more efficient at work.In Part 4 - I will show you how to infuse 'clarity', so that you can develop excel model for analysis, reporting or forecasting which are easy to understand and user friendly.After completing this course, you, your reports and financial models will immediately begin to stand out from the rest of the pack.
Overview
Section 1: The fastest way to bocome an Exeptional Analytst
Lecture 1 Meet your instructor
Lecture 2 The difference between a medicore and exceptional analyst
Lecture 3 Why all Excel models aren't the same
Lecture 4 Who this course is designed for
Lecture 5 The #1 secret to creating an exceptional Excel model
Lecture 6 The four ingredients to elevate your Excel Modelling skills
Section 2: The importance of structure
Lecture 7 Why structure matters in Excel modelling
Lecture 8 The concept of zoning
Lecture 9 The beauty of dragging
Lecture 10 Avoiding multiple headings
Lecture 11 The value of cloning
Lecture 12 Chapter summary
Section 3: The importance of accuracy
Lecture 13 Why accuracy matters in Excel modelling
Lecture 14 Creating error checks
Lecture 15 Avoiding skinny sums
Lecture 16 Removing magic numbers
Lecture 17 Best practice for linking
Lecture 18 Best practice for sense checking
Lecture 19 Chapter summary
Section 4: The importance of speed
Lecture 20 Why speed matters in Excel modelling
Lecture 21 Speed Booster 1: Knowing Excel inside out
Lecture 22 Tweaking CPU settings
Lecture 23 Utilizing manual calculation settings
Lecture 24 Turning off Editing Directly in Cells
Lecture 25 Expanding your knowledge of Excel formulas / functions
Lecture 26 Excel Function: Sum and its family
Lecture 27 Excel Function: Sum Ifs and its family
Lecture 28 Excel Function: Why Xlookup is better than Vlookup
Lecture 29 Excel Function: Left and its family
Lecture 30 Excel Function: Upper and its family
Lecture 31 Excel Function: Expand your knowledge with Help
Lecture 32 Excel Function: Discovering Sort
Lecture 33 Excel Function: Discovering Stock Price
Lecture 34 Excel Function: Discovering Unique
Lecture 35 Excel Function: Discovering Filter
Lecture 36 Enhancing your knowledge of Excel Features
Lecture 37 Excel Features: Exploring Filter
Lecture 38 Excel Features: Introducing Conditional Formatting
Lecture 39 Excel Features: Using Data Table
Lecture 40 Excel Features: Pivot Table
Lecture 41 Excel Features: Pivot Chart
Lecture 42 Bonus Video: Building an Interactive Dashboard
Lecture 43 Boosting your knowledge of shortcuts
Lecture 44 Getting to know your function keys
Lecture 45 The art of copying and pasting
Lecture 46 Bonus Video: The most efficient way to copy charts
Lecture 47 Speed Booster 2: Removing formulas
Lecture 48 Speed Booster 3: Adopting MPV
Lecture 49 Chapter summary
Section 5: The importance of clarity
Lecture 50 Why clarity matters in Excel modelling
Lecture 51 Pillar 1: How to build your model to ensure clarity
Lecture 52 A reminder of the importance of structure
Lecture 53 Why you should use short and simple formulas
Lecture 54 Pillar 2: How to present your model clearly
Lecture 55 Following the flow of the brain
Lecture 56 Rounding your numbers
Lecture 57 Hiding what's irrelevent
Lecture 58 Choosing colours
Lecture 59 Using lines wisely
Lecture 60 Creating one-page summaries
Lecture 61 Pillar 3: How to save your model to avoid confusion
Lecture 62 Developing good filing habits
Lecture 63 Developing good naming habits
Lecture 64 Chapter summary
Section 6: Conclusion
Lecture 65 Summary of key concepts
Aspiring Analysts who are sick of being mediocre,Aspiring Analysts who want to become exceptional analysts,Aspiring Analysts who want to improve their Excel Modelling skills.
Screenshots