Financial Modelling in Excel for Beginner to Intermediate
1 Year Access 
Beginner
3 Students -
4 hours, 47 minutes
Financial Modelling in Excel for Beginner to Intermediate
Original price was: £425.£29Current price is: £29. ex Vat
Save 93.18 % - ENDS SOON
Offer Ends In
Days
:
Hours
:
Minutes
:
Seconds
OR
Or
All courses for
£49 
Get access to 5000+ courses including this for only £49. FIND out more
Overview of Financial Modelling in Excel
Become a trained professional from the safety and comfort of your own home by taking Financial Modelling in Excel for Beginner to Intermediate . Whatever your situation and requirements, One Education can supply you with professional teaching, gained from industry experts, and brought to you for a great price with a limited-time discount.
One Education has been proud to produce an extensive range of best-selling courses, and Financial Modelling in Excel for Beginner to Intermediate is one of our best offerings. It is crafted specially to promote easy learning at any location with an online device. Each topic has been separated into digestible portions that can be memorised and understood in the minimum of time.
Teaching and training are more than just a job for the staff at One Education; we take pride in employing those who share our vision for e-learning and its importance in today’s society. To prove this, all learning materials for each course are available for at least one year after the initial purchase.
By completing Financial Modelling in Excel for Beginner to Intermediate, you will have automatically earnt an e-certificate that is industry-recognised and will be a great addition to your competencies on your CV. Whatever your reason for studying Financial Modelling in Excel for Beginner to Intermediate, make the most of this opportunity from One Education and excel in your chosen field.
Please be aware that there are no hidden fees, no sudden exam charges, and no other kind of unexpected payments. All costs will be made very clear before you even attempt to sign up.
Financial Modelling in Excel Course Design
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
- Video lessons
- Online study materials
Will I receive a certificate of completion?
Upon successful completion, you will qualify for the UK and internationally-recognised CPD accredited certification. You can choose to make your achievement formal by obtaining your PDF Certificate at the cost of £9 and Hard Copy Certificate for £15.
Why study this Financial Modelling in Excel Course?
It doesn’t matter if you are an aspiring professional or absolute beginner; this course will enhance your expertise and boost your CV with critical skills and an accredited certification attesting to your knowledge.
The Financial Modelling in Excel for Beginner to Intermediate is fully available to anyone, and no previous qualifications are needed to enrol. All One Education needs to know is that you are eager to learn and are over 16.
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 – Excel – Conditional Formatting | 00:03: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 | |||
| Resource – Financial Modelling in Excel: Beginner to Intermediate | 00:00:00 | ||
| Order Your Certificate | |||
| Order Your Certificate Now | 00:00:00 | ||
No reviews found for this course.
Related Courses
Important Links
With a team of industry professionals producing and delivering our course content, you can be sure the skills and knowledge you learn are applicable to your career aspirations, whether that’s in management, administration or beyond.
0
0
Your Cart
Your cart is emptyBrowse Courses
Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year
Claim Offer & UpgradeMembership renews after 12 months. You can cancel anytime from your account.
Other Students Also Buy
-
Get Lifetime Access To Your Course£9.99 Add to basket+Add