www.myonlinetraininghub.com
Open in
urlscan Pro
192.124.249.160
Public Scan
URL:
https://www.myonlinetraininghub.com/financial-modelling-course?awt_a=f2Zj&awt_l=ptWL&awt_m=gR26enG7HfVR.Zj
Submission: On February 14 via api from OM — Scanned from DE
Submission: On February 14 via api from OM — Scanned from DE
Form analysis
3 forms found in the DOMGET 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
* 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 * SALE 20% Off All Courses * 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 SALE 20% Off All Courses - Ends Feb 15th (8pm PDT) See Courses * Courses * Pricing Sub Menu * SALE 20% Off All Courses * 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 $298 $238Add to cart $298 $238Add to cart 12 Months Online $298 $238Add 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 $597 $477Add to cart $597 $477Add to cart 12 Months Online + Download $597 $477Add 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. 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 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