Key features of the Financial Modelling in Excel: Beginner to Intermediate
Course
- Lifetime access to the course
- No hidden fees, only pay the price of the course which includes exam fees.
- Recognised qualification upon successful completion of the course
- Study from anywhere, anytime, whenever it is convenient for you.
- Affordable and engaging e-learning study materials
- Study at your own pace from tablet, PC or smartphone
- Online tutor support when you are in need.
Who is this course for?
There is no experience or previous qualifications required for enrolment on this course. It is available to all students, of all academic backgrounds.
Requirements
Our Financial Modelling in Excel: Beginner to Intermediate is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.
Career Path
After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.
Course Curriculum
| Introduction | |||
| Learn Financial Modelling in Excel | 00:03:00 | ||
| Financial Modelling In Excel For Beginners | |||
| Beginner – What is a Financial Model | 00:04:00 | ||
| Beginner – Financial Model Design | 00:08:00 | ||
| Beginner – Scenario Analysis | 00:03:00 | ||
| Beginner – Documentation | 00:05:00 | ||
| Beginner – Excel – Cell References | 00:09:00 | ||
| Beginner – Excel – IF Formula | 00:02:00 | ||
| Beginner – Excel – AND Formula | 00:03:00 | ||
| Beginner – Excel – OR Formula | 00:03:00 | ||
| Beginner – Excel – Nested Formulas | 00:03:00 | ||
| Beginner – Model – Conditional Formatting | 00:05:00 | ||
| Beginner – Excel – Data validation | 00:05:00 | ||
| Beginner – Model – Inputs | 00:09:00 | ||
| Beginner – Model – Revenue | 00:07:00 | ||
| Beginner – Model – Expenses | 00:07:00 | ||
| Beginner – Model – Profit and Loss | 00:07:00 | ||
| Beginner – Model – Cash Flow | 00:10:00 | ||
| Beginner – Model – Adding Scenarios | 00:15:00 | ||
| Beginner – Model – Charts | 00:05:00 | ||
| Beginner – Model – Conditional Formatting | 00:05:00 | ||
| Beginner – Model – Protect Workbook | 00:06:00 | ||
| Financial Modelling In Excel - Intermediate | |||
| Intermediate – Modules in the Course | 00:03:00 | ||
| Intermediate – Design Principles | 00:07:00 | ||
| Intermediate – Excel – Aggregate Functions | 00:05:00 | ||
| Intermediate – Excel – Lookup Functions | 00:14:00 | ||
| Intermediate – Excel – Forecasting | 00:06:00 | ||
| Intermediate – Excel – Mixed References and Named Ranges | 00:09:00 | ||
| Intermediate – Excel – External Links | 00:14:00 | ||
| Intermediate – Skills – Error Checks | 00:09:00 | ||
| Intermediate – Skills – Goal Seek | 00:08:00 | ||
| Intermediate – Skills – WACC | 00:08:00 | ||
| Intermediate – Skills – NPV and IRR | 00:09:00 | ||
| Intermediate – Model – Introduction | 00:03:00 | ||
| Intermediate – Model – Staff Expenses | 00:17:00 | ||
| Intermediate – Model – Staff Expenses Summary | 00:07:00 | ||
| Intermediate – Model – Revenue | 00:19:00 | ||
| Intermediate – Model – Market Analysis | 00:02:00 | ||
| Intermediate – Model – Profit and Loss | 00:07:00 | ||
| Intermediate – Model – NPV IRR | 00:07:00 | ||
| Intermediate – Model – Payback Period | 00:04:00 | ||
| Intermediate – Model – Scenario Analysis | 00:07:00 | ||
| Support Materials | |||
| Financial Modelling in Excel: Beginner to Intermediate | 00:00:00 | ||
| Certificate and Transcript | |||
| Order Your Certificates or Transcripts | 00:00:00 | ||
Course Reviews
No Reviews found for this course.
Related Courses
PowerPoint for Business
£24.99
1 STUDENTS ENROLLED
