This course is designed for those interested to learn the basics of financial modeling, design principles of financial models, and how to get answers and insights from your financial data. Read more.
I'm a book author of the 101 Excel Series paperback books. Courses I'm focused on range from SQL, Excel Formulas, Power Query, Power BI, and much more
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseAbout This Course
If you want to get better at Financial Modeling using Microsoft Excel so you get a better paying job or just get answers and insights from your data fast with Financial Models, then you are in the right place!
No matter if you are a Financial Modeling Beginner or never used excel before, you are sure to benefit from this quick course which goes through the must-know Financial Model foundations.
Master the following straight away in just 90 minutes:
- Everything about Financial Models
- Design Principles of Financial Models
- Scenario Analysis
- Proper Documentation
- Excel Core Concepts
- Revenue, Expense, Profit and Loss, Cashflow
- Financial Model Enhancements
After this class you will be able to:
- Actually smile when you start creating Financial ModelsÂ
- Get valuable data insights and answers anytime you want from your data
This course is for:
- People who are in: Accounting, Finance, Management, Auditing, Admin and Support, Sales, IT, Consulting, Banking, Marketing, Business Owners, Engineering, Project Management, Students, TeachersÂ
- People who want to change career and apply for a new job
- Beginners in Financial Modeling aiming to make sense of their data
Our Promise to You
By the end of this course, you will have learned how to create a financial model.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about building a financial model in Excel.
Course Curriculum
| Section 1 - Introduction | |||
| Course Resources | 00:00:00 | ||
| Introduction | 00:00:00 | ||
| What A Financial Model Is | 00:00:00 | ||
| Financial Model Design | 00:00:00 | ||
| Scenario Analysis | 00:00:00 | ||
| Documentation | 00:00:00 | ||
| Section 2 - Core Excel Concepts | |||
| Cell References | 00:00:00 | ||
| IF Formula | 00:00:00 | ||
| AND Formula | 00:00:00 | ||
| OR Formula | 00:00:00 | ||
| Nested Formulas | 00:00:00 | ||
| Conditional Formatting | 00:00:00 | ||
| Data Validation | 00:00:00 | ||
| Section 3 - Model | |||
| Inputs | 00:00:00 | ||
| Revenue | 00:00:00 | ||
| Expenses | 00:00:00 | ||
| Profit And Loss | 00:00:00 | ||
| Cashflow | 00:00:00 | ||
| Adding Scenarios | 00:00:00 | ||
| Charts | 00:00:00 | ||
| Conditional Formatting | 00:00:00 | ||
| Workbook Protection | 00:00:00 | ||
About This Course
If you want to get better at Financial Modeling using Microsoft Excel so you get a better paying job or just get answers and insights from your data fast with Financial Models, then you are in the right place!
No matter if you are a Financial Modeling Beginner or never used excel before, you are sure to benefit from this quick course which goes through the must-know Financial Model foundations.
Master the following straight away in just 90 minutes:
- Everything about Financial Models
- Design Principles of Financial Models
- Scenario Analysis
- Proper Documentation
- Excel Core Concepts
- Revenue, Expense, Profit and Loss, Cashflow
- Financial Model Enhancements
After this class you will be able to:
- Actually smile when you start creating Financial ModelsÂ
- Get valuable data insights and answers anytime you want from your data
This course is for:
- People who are in: Accounting, Finance, Management, Auditing, Admin and Support, Sales, IT, Consulting, Banking, Marketing, Business Owners, Engineering, Project Management, Students, TeachersÂ
- People who want to change career and apply for a new job
- Beginners in Financial Modeling aiming to make sense of their data
Our Promise to You
By the end of this course, you will have learned how to create a financial model.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about building a financial model in Excel.
Course Curriculum
| Section 1 - Introduction | |||
| Course Resources | 00:00:00 | ||
| Introduction | 00:00:00 | ||
| What A Financial Model Is | 00:00:00 | ||
| Financial Model Design | 00:00:00 | ||
| Scenario Analysis | 00:00:00 | ||
| Documentation | 00:00:00 | ||
| Section 2 - Core Excel Concepts | |||
| Cell References | 00:00:00 | ||
| IF Formula | 00:00:00 | ||
| AND Formula | 00:00:00 | ||
| OR Formula | 00:00:00 | ||
| Nested Formulas | 00:00:00 | ||
| Conditional Formatting | 00:00:00 | ||
| Data Validation | 00:00:00 | ||
| Section 3 - Model | |||
| Inputs | 00:00:00 | ||
| Revenue | 00:00:00 | ||
| Expenses | 00:00:00 | ||
| Profit And Loss | 00:00:00 | ||
| Cashflow | 00:00:00 | ||
| Adding Scenarios | 00:00:00 | ||
| Charts | 00:00:00 | ||
| Conditional Formatting | 00:00:00 | ||
| Workbook Protection | 00:00:00 | ||
Course Review
4.5
2 RatingsRelated Courses
Are you interested in higher education?
All Rights Reserved
Excellent beginners Course
This course will/would be very helpful to people new to excel and functions. Very useful to individuals familiar with excel but new to modeling.
Very good content for beginners
The course content is great. Although I have intermediate skills in Excel and accounting, I still learned a few things. The grammar and pronunciation is a bit distracting, such as “shit” instead of “sheet” or “tree” instead of “three”. But otherwise the content and visual aids are great for learning. My thanks to the presenter/author..