www.myonlinetraininghub.com Open in urlscan Pro
192.124.249.160  Public Scan

Form analysis
3 forms found in the DOM

GET https://www.myonlinetraininghub.com/

<form class="search-form" method="get" action="https://www.myonlinetraininghub.com/" role="search"><label class="search-form-label screen-reader-text" for="searchform-1">Search site</label><input class="search-form-input" type="search" name="s"
    id="searchform-1" placeholder="Search..." required=""><button class="search-form-submit button-secondary" type="submit" value="Search"><span class="screen-reader-text">Submit search</span><svg xmlns="http://www.w3.org/2000/svg"
      viewBox="0 0 512 512" class="search-form-submit-icon" width="24" height="24"><!-- Font Awesome Pro 5.15.3 by @fontawesome - https://fontawesome.com License - https://fontawesome.com/license (Commercial License) -->
      <path
        d="M508.5 468.9L387.1 347.5c-2.3-2.3-5.3-3.5-8.5-3.5h-13.2c31.5-36.5 50.6-84 50.6-136C416 93.1 322.9 0 208 0S0 93.1 0 208s93.1 208 208 208c52 0 99.5-19.1 136-50.6v13.2c0 3.2 1.3 6.2 3.5 8.5l121.4 121.4c4.7 4.7 12.3 4.7 17 0l22.6-22.6c4.7-4.7 4.7-12.3 0-17zM208 368c-88.4 0-160-71.6-160-160S119.6 48 208 48s160 71.6 160 160-71.6 160-160 160z">
      </path>
    </svg></button>
  <meta content="https://www.myonlinetraininghub.com/?s={s}">
</form>

POST

<form method="post" class="currency_switch_form">
  <select class="aelia_cs_currencies" name="aelia_cs_currency" aria-label="Choose Currency">
    <option value="USD" selected="selected">United States (US) dollar</option>
    <option value="AUD">Australian dollar</option>
    <option value="GBP">Pound sterling</option>
  </select>
  <noscript><button type="submit" class="button change_currency">Change Currency</button></noscript>
</form>

POST #

<form action="#" method="post" novalidate="novalidate" autocomplete="new-password">
  <div class="tve_lead_generated_inputs_container tve_clearfix tve_empty_dropzone">
    <div class="tve_lg_input_container tve_lg_input" data-css="tve-u-11644b189fa4afe">
      <input type="email" data-field="email" data-required="1" data-validation="email" name="email" placeholder="Type Your Email Here" data-placeholder="Type Your Email Here" class="">
    </div>
    <div class="tve_lg_input_container tve_submit_container tve_lg_submit" data-css="tve-u-12644b189fa4aff">
      <button type="submit" class="" style=""><span class=""><strong>Download My eBook</strong></span></button>
    </div>
  </div>
  <input id="_submit_option" type="hidden" name="_submit_option" value="redirect"><input id="_back_url" type="hidden" name="_back_url" value="https://www.myonlinetraininghub.com/exit-thank-you"><input id="_autofill" type="hidden" name="_autofill"
    value=""><input id="_sendParams" type="hidden" name="_sendParams" value=""><input id="_api_custom_fields" type="hidden" name="_api_custom_fields"
    value="YToxMDp7aTowO2E6Mjp7czoyOiJpZCI7czo0OiJuYW1lIjtzOjExOiJwbGFjZWhvbGRlciI7czo0OiJOYW1lIjt9aToxO2E6Mjp7czoyOiJpZCI7czo1OiJwaG9uZSI7czoxMToicGxhY2Vob2xkZXIiO3M6NToiUGhvbmUiO31pOjI7YToyOntzOjI6ImlkIjtzOjEyOiJtYXBwaW5nX3RleHQiO3M6MTE6InBsYWNlaG9sZGVyIjtzOjQ6IlRleHQiO31pOjM7YToyOntzOjI6ImlkIjtzOjExOiJtYXBwaW5nX3VybCI7czoxMToicGxhY2Vob2xkZXIiO3M6MzoiVVJMIjt9aTo0O2E6Mjp7czoyOiJpZCI7czoxMzoibWFwcGluZ19yYWRpbyI7czoxMToicGxhY2Vob2xkZXIiO3M6NToiUmFkaW8iO31pOjU7YToyOntzOjI6ImlkIjtzOjE0OiJtYXBwaW5nX3NlbGVjdCI7czoxMToicGxhY2Vob2xkZXIiO3M6ODoiRHJvcGRvd24iO31pOjY7YToyOntzOjI6ImlkIjtzOjE2OiJtYXBwaW5nX2NoZWNrYm94IjtzOjExOiJwbGFjZWhvbGRlciI7czo4OiJDaGVja2JveCI7fWk6NzthOjI6e3M6MjoiaWQiO3M6MTY6Im1hcHBpbmdfdGV4dGFyZWEiO3M6MTE6InBsYWNlaG9sZGVyIjtzOjg6IlRleHRhcmVhIjt9aTo4O2E6Mjp7czoyOiJpZCI7czoxMjoibWFwcGluZ19maWxlIjtzOjExOiJwbGFjZWhvbGRlciI7czoxMToiRmlsZSB1cGxvYWQiO31pOjk7YToyOntzOjI6ImlkIjtzOjE0OiJtYXBwaW5nX2hpZGRlbiI7czoxMToicGxhY2Vob2xkZXIiO3M6NjoiSGlkZGVuIjt9fQ=="><input
    type="hidden" id="tve_mapping" name="tve_mapping" value="YTowOnt9"><input type="hidden" id="tve_labels" name="tve_labels" value="YToxOntzOjU6ImVtYWlsIjtzOjIwOiJUeXBlIFlvdXIgRW1haWwgSGVyZSI7fQ==">
</form>

Text Content

My Online Training Hub
Data and Cookie Consent
In order to provide a more personal user experience, we and our 219 partners use
technology such as cookies to store and/or access device information.
By clicking “Accept” you consent to these technologies which will allow us and
our partners
to process non-sensitive data such as IP address, unique ID, and browsing data
for the purposes of serving personalized ads and content, ad and content
measurement, audience insights, and to develop and improve products.
Your choices on this site will be applied only for this site. You can change
your settings at any time, including withdrawing your consent, by going to the
Privacy Policy
page of this site.
Manage Settings
Accept

Update Privacy Settings
 * Skip to main content
 * Skip to header right navigation
 * Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

Menu
 * Courses
 * Pricing
   * Free Courses
   * Power BI Course
   * Excel Power Query Course
   * Power Pivot and DAX Course
   * Excel Dashboard Course
   * Excel PivotTable Course – Quick Start
   * Advanced Excel Formulas Course
   * Excel Expert Advanced Excel Training
   * Excel Tables Course
   * Excel, Word, Outlook
   * Financial Modelling Course
   * Excel PivotTable Course
   * Excel for Customer Service Professionals
   * Excel for Operations Management Course
   * Excel for Decision Making Under Uncertainty Course
   * Excel for Finance Course
   * Excel Analysis ToolPak Course
   * Multi-User Pricing
 * Resources
   * Free Downloads
   * Excel Functions Explained
   * Excel Formulas
   * Excel Add-ins
   * IF Function
     * Excel IF Statement Explained
     * Excel IF AND OR Functions
     * IF Formula Builder
   * Time & Dates in Excel
     * Excel Date & Time
     * Calculating Time in Excel
     * Excel Time Calculation Tricks
     * Excel Date and Time Formatting
   * Excel Keyboard Shortcuts
   * Excel Custom Number Format Guide
   * Pivot Tables Guide
   * VLOOKUP Guide
   * ALT Codes
   * Excel VBA & Macros
   * Excel User Forms
   * VBA String Functions
 * Members
   * Login
   * Password Reset
 * Blog
 * Excel Webinars
 * Excel Forum
   * Register as Forum Member
 * 
 * Search
   Search siteSubmit search
 * Login

 * Courses
 * Pricing Sub Menu
   * Free Courses
   * Power BI Course
   * Excel Power Query Course
   * Power Pivot and DAX Course
   * Excel Dashboard Course
   * Excel PivotTable Course – Quick Start
   * Advanced Excel Formulas Course
   * Excel Expert Advanced Excel Training
   * Excel Tables Course
   * Excel, Word, Outlook
   * Financial Modelling Course
   * Excel PivotTable Course
   * Excel for Customer Service Professionals
   * Excel for Operations Management Course
   * Excel for Decision Making Under Uncertainty Course
   * Excel for Finance Course
   * Excel Analysis ToolPak Course
   * Multi-User Pricing
 * Resources Sub Menu
   * Free Downloads
   * Excel Functions Explained
   * Excel Formulas
   * Excel Add-ins
   * IF Function Sub Menu
     * Excel IF Statement Explained
     * Excel IF AND OR Functions
     * IF Formula Builder
   * Time & Dates in Excel Sub Menu
     * Excel Date & Time
     * Calculating Time in Excel
     * Excel Time Calculation Tricks
     * Excel Date and Time Formatting
   * Excel Keyboard Shortcuts
   * Excel Custom Number Format Guide
   * Pivot Tables Guide
   * VLOOKUP Guide
   * ALT Codes
   * Excel VBA & Macros
   * Excel User Forms
   * VBA String Functions
 * Members Sub Menu
   * Login
   * Password Reset
 * Blog
 * Excel Webinars
 * Excel Forum Sub Menu
   * Register as Forum Member
 * 
 * Login


FINANCIAL MODELLING COURSE

You are here: Home / Financial Modelling Course

This course tackles the age-old issue of financial modelling head on and breaks
down the seemingly complicated process into small segments that are easily
digestible.

Furthermore, it offers you the ability to learn at your own pace, jumping in and
out as and when you like!



QUICK STATS:

 * 465 interactive slides
 * 6+ hours of video lessons
 * 25 questions
 * 1 financial model broken down into 28 easy steps
 * 30+ hands-on Excel workbook walkthrough files.


SAMPLE MODULE



Your browser does not support the video tag.





WHO IS THIS COURSE FOR?

Anyone who needs to understand the three primary financial statements: namely,
the Income Statement, Balance Sheet and Cash Flow Statement. These should be
understood thoroughly by everyone involved in the business decision making
process.

Only through understanding the core concepts can you avoid the common mistakes
that people make when working with these three statements.

Our Financial Modelling online course allows you to learn the core concepts of
the three financial statements, at your own pace!

This course also offers flexibility in learning methods, presenting key
knowledge points in interactive slides, for the hands-on learner, or presenting
the same knowledge points in videos for the visual learner.



WHO IS THE INSTRUCTOR?




DR. LIAM BASTICK FCA FCMA CGMA MVP

Liam has 30+ years’ experience in the development of financial models, auditing,
valuations, M&A, strategy, training and consultancy.

His experience covers many different sectors including banking, energy, media,
mining, oil and gas, private equity, transport and utilities.

Liam headed Ernst & Young’s modelling team in Melbourne as well as being
Assistant Director in London for their strategic valuations team.

He was a senior member of the UK Post Office’s M&A and strategy teams, and
worked for / assisted various Australian companies including BPM, Corality,
Navigator Project Finance, PKF and SumProduct.

He has worked with many internationally recognized clients throughout Europe,
Asia, Australia and New Zealand, constructing and reviewing strategic,
operational and valuation models for many high profile IPOs, LBOs and strategic
assignments.

Liam regularly contributes to the Institute of Chartered Accountants in
Australia (ICAA), Certified Practising Accountants Australia (CPAA), the
Chartered Institute of Management Accountants (CIMA), Finance 3.0 and various
LinkedIn specialist groups. He is also an experienced facilitator for ICAA.

Liam is a Fellow of the Institute of Chartered Accountants (ICAEW), a Fellow of
the Institute of Chartered Management Accountants (CIMA) and is a professional
mathematician.





COURSE DESCRIPTION

This course is jam-packed full of interactive slides that break down the
modelling process, walking you through a step-by-step guide to to create your
own financial model.

The 6+ hours of videos will also guide you through the entire modelling process,
highlighting key practices along the way.

Our developers have crafted the questions to test key knowledge points for you
to pick up on, to ensure you walk away with the most important points.

Finally, you get to keep the 30+ Excel walkthrough files for future reference.



INTERACTIVE CASE STUDY

Starting with a blank Excel workbook at the beginning of the course, you will
work through the course and develop a small, straightforward model that enables
our methods to be demonstrated readily and practiced comprehensively.

Break down the complicated financial modelling process into bite sized,
digestible chunks to be consumed at your own pace!

At the end of this course, users will have built a complete set of financial
statements and will be able to repeat this process when building their own
models.





KEY BENEFITS

 * Understanding the differences between the three primary financial statements
 * Develop a straightforward approach that can be employed again for future
   financial modelling projects
 * Balance the dreaded balance sheet in seconds
 * Learn to avoid common mistakes
 * Learn at your own pace, anytime, anywhere!


PROGRAMME OUTLINE

 * Layout Tips
 * Time Series Analysis
 * Error Checks
 * Financial Model Template Example
 * Financial Statement Theory
 * Control Accounts
    * Initial Structure of the Financial Model
    * Linking the Financial Statements
    * Example Model Build
    * Initial Structure
    * Adding Sheets
    * Creating the Financial Statement Worksheets
    * Revenue
    * Inventory
    * Costs of Goods Sold (COGS)
    * Operating Expenditure (OPEX)
    * Capital Expenditure (CAPEX)
    * Debt
    * Taxation
    * Equity

 * Single Entry Accounting
 * Opening Balance Sheet
 * Indirect Cash Flow
 * Wrap-up


REQUIREMENTS:

 * Working internet connection
 * Computer or handheld device
 * Either Excel 2010, 2013, 2016, 2019, or Office 365
 * We do not recommend the use of the Edge browser


BUY ANY COMBINATION OF 2 OR MORE COURSES AND GET 20% OFF ALL OF THEM

 * Online Only : 12 months online access to the course(s)
 * Online + Download : 12 months online access to the course(s) + download the
   course videos to keep
 * GST : Prices are shown exclusive of GST for Australian customers.



These Prices Already Have The 20% Discount Applied



CHOOSE YOUR COURSE


Choose Currency
United States (US) dollar Australian dollar Pound sterling Change Currency



These Prices Already Have The 20% Discount Applied



FINANCIAL MODELLING ONLINE



$298Add to cart

$298Add to cart

12 Months Online

$298Add to cart

--------------------------------------------------------------------------------

Online Only Access To Course

--------------------------------------------------------------------------------

One Payment for 12 Months Access

--------------------------------------------------------------------------------

Unlimited 24/7 access

--------------------------------------------------------------------------------

Pause, rewind, replay

--------------------------------------------------------------------------------

Download Workbooks and Practice Data

--------------------------------------------------------------------------------

*30 Day Money Back Guarantee

 


FINANCIAL MODELLING DOWNLOAD



$597Add to cart

$597Add to cart

12 Months Online + Download

$597Add to cart

--------------------------------------------------------------------------------

Online Access + Download & Keep Course Videos*

--------------------------------------------------------------------------------

One Payment for 12 Months Access

--------------------------------------------------------------------------------

Unlimited 24/7 access

--------------------------------------------------------------------------------

Pause, rewind, replay

--------------------------------------------------------------------------------

Download Workbooks and Practice Data

--------------------------------------------------------------------------------

*30 Day Money Back Guarantee

 









*NOTES

 * Videos will be available for download after the 30 day Money Back Guarantee
   period ends. You can watch the videos online in the meantime.
 * Membership and access to the training materials is for one person only.
   Logons are not to be used by multiple people.
 * Downloaded videos are to be used only by the registered member, they are not
   to be transferred/shared amongst other people.
 * You can request a refund provided that no more than 30% of the course videos
   have been watched.

Added to Cart

BLOG CATEGORIES

 * AI in Excel
 * Excel
 * Excel Charts
 * Excel Dashboard
 * Excel Formulas
 * Excel Office Scripts
 * Excel PivotTables
 * Excel Shortcuts
 * Excel VBA
 * General Tips
 * Online Training
 * Outlook
 * Power Apps
 * Power Automate
 * Power BI
 * Power Pivot
 * Power Query

Sign up to our newsletter and join over 400,000
others who learn Excel and Power BI with us.

 

COMPANY

 * About My Online Training Hub
 * Disclosure Statement
 * Frequently Asked Questions
 * Guarantee
 * Privacy Policy
 * Terms & Conditions
 * Testimonials
 * Become an Affiliate
 * Sponsor Our Newsletter


SUPPORT

 * Contact
 * Forum
 * Helpdesk – For Technical Issues

Copyright © 2024 · My Online Training Hub · All Rights Reserved. Microsoft and
the Microsoft Office logo are trademarks or registered trademarks of Microsoft
Corporation in the United States and/or other countries. Product names, logos,
brands, and other trademarks featured or referred to within this website are the
property of their respective trademark holders.




Download A Free Copy of 100 Excel Tips & Tricks

Download My eBook

We respect your privacy. We won’t spam you.

x
151 Shares
Share
Tweet
Pin
Share
Share
Print
Share
Email
Share