Financial Modelling in Excel for Beginner to Intermediate

Financial Modelling in Excel: Beginner to Intermediate

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
sidemoneyBack

COPYRIGHT © 2022 One Education

Home Search Cart
0
    0
    Your Cart
    Your cart is emptyBrowse Courses

    Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year

    Claim Offer & Upgrade

    Membership renews after 12 months. You can cancel anytime from your account.

    Other Students Also Buy
      Apply Coupon