4.5
2
157
Overview Financial modeling for beginners course will help you to learn core excel concepts, scenario analysis, conditional formatting, and more. Are you tired of feeling …
Overview
Financial modeling for beginners course will help you to learn core excel concepts, scenario analysis, conditional formatting, and more. Are you tired of feeling left out in finance meetings because you don’t know how to create a financial model? Well, have no fear because our ‘Financial Modeling for Beginners in Excel’ e-course is here! This course is designed for those with little to no experience in financial modeling and will teach you the fundamental concepts and techniques to build a model from scratch. We’ve broken it down into several lectures, covering everything from cell references to forecasting revenue and expenses, and even valuing a company using discounted cash flow analysis. Don’t worry, we won’t just be throwing information at you and expecting you to remember it all. We’ve included hands-on exercises and real-world examples so you can apply what you’ve learned in a fun and interactive way. By the end of this course, you’ll have the skills and knowledge to create a basic financial model in Excel and make informed business decisions. The best part? You can complete the course at your own pace, from the comfort of your own home. So whether you’re a finance or business professional, or just a student looking to make a career in finance, this course is for you!What you’ll learn?
- Learn different types of formulas and data validation in financial modeling
- Forecast revenue and expenses and create a projected income statement
- Understand how to use discounted cash flow analysis to value a company
- Add scenarios, conditional formatting and learn how to protect your workbook
- Use charts and graphs in Excel to present financial models in a clear and visually appealing way.
Who Should Take The Financial Modeling for Beginners in Excel Course?
- Beginners with little to no experience on the subject
- Those looking to start a career in finance, business, or accounting
- Anyone interested in working with financial models or improving their
- Excel skills
- Entrepreneurs, small business owners, or anyone looking to make informed decisions
- Anyone interested in learning the subject and wants to make a career in finance
Requirements
Please note that the course is conducted online and requires a stable internet connection to access the course material and participate in hands-on exercises. Although the course is designed for beginners, a basic understanding of Excel is recommended. The course is meant for those who are interested in learning financial modeling, and it will be beneficial for those who want to make a career in finance.Course Currilcum
-
- Modules in the Course 00:02:00
- What is a Financial Model 00:04:00
- Financial Model Design 00:07:00
- Scenario Analysis 00:02:00
- Documentation 00:05:00
-
- Core Excel Concepts – Cell References 00:08:00
- Core Excel Concepts – IF Formula 00:02:00
- Core Excel Concepts – AND Formula 00:03:00
- Core Excel Concepts – OR Formula 00:02:00
- Core Excel Concepts – Nested Formulas 00:03:00
- Core Excel Concepts – Conditional Formatting 00:03:00
- Core Excel Concepts – Data validation 00:05:00
- Model – Inputs 00:08:00
- Model – Revenue 00:07:00
- Model – Expenses 00:07:00
- Model – Profit and Loss 00:07:00
- Model – Cashflow 00:10:00
- Model – Adding Scenarios 00:14:00
- Model – Charts 00:05:00
- Model – Conditional Formatting 00:04:00
- Model – Protect Workbook 00:06:00