The Corality Training Academy
Financial Modelling Training
Financial Modelling Training
Financial Modelling Training
Financial Modelling Training
Financial Modelling Training
Financial Modelling Training
Financial Modelling Training
Financial Modelling Training
Financial Modelling Training
Financial Modelling Training
Financial Modelling Training
Financial Modelling Training
Financial Modelling Training
all posts
-
Conferences
- Terrapinn Corporate Finance World, Sydney – Project finance modelling
- Excellence in oil and gas – Sydney 2009
- Corality’s Liam Bastick discusses presenting at the CPA Management Conference and CPA Congress around Australia
- Summer Drinks in Sydney - You're Invited!
- CPA Australia Congress, Dr. Liam Bastick
- Modelling Risk, Return and Ranking
- Cash Flow Management For Critical Decision Making
- Key Driver Analysis Modelling
- Forecasting Techniques and Financial Modelling
- The ICAA Accounting Conference 2011
- The Newcastle Convention 2011
- National Infrastructure Awards 2011 - The Oscars of Infrastructure
- EuSpRIG: Corality presents SMART financial modelling in London, Greenwich
- Corality presents seminar on Business Analytics and Decision Analysis for the Institute of Chartered Accountants
- CPA Sydney Congress
- Financial modelling for gold projects and flying sharks at The Gold Symposium
- Strong speaker line up at The Gold Symposium, Sydney
- Corality continues its seminars on best practice standards in financial modelling for CPA Australia
- The CFO Crystal Ball: Powerful Financial Modelling for Strategic Planning
-
Corporate News
- Corality is a BRW 2011 Fast Starter
- SMART, Navigator’s best practise modelling methodology is here!
- Corality Gallery Opening - 16th of June, Sydney
- Corality hosts seminar at the London Business School
- Corality Gallery Opening
- Corality clients nominated in the Ernst & Young ‘Entrepreneur of the Year’
- Strategic merger - Corality and Navigator form the Corality Financial Group
- Excel workshops and live model builds with Corality at the CPA Expo
- Mines and Money Conference and Exhibition
- Peter Weatherston: Head of Consulting, financial modelling expert and whisky connoisseur
- Corality Financial Group - the start of a new era
- Banks approve US$138 million for the Wetar copper project
- Corality wins high profile Desertec equity model build job
- Rickard Warnelid – Top 40 business leader under 40
- Corality writes article series about financial modelling for CIMA
- Solar flair – Corality in the press
- Corality sponsors Macquarie University with award for academic excellence
- Investing in iron ore projects – Corality in the press
- Corality’s new MD, Rickard Warnelid
- Corality celebrates rapid growth nomination - BRW 2012 Fast Starter
- Corality attends The Resources and Energy Symposium, Broken Hill
- Corality is building its global presence with an office in Perth
-
Excel
- Corality check-lists in Excel using Webdings
- Are you using the Share Workbook functionality in Excel?
- What level of input Data Validation is needed in Excel?
- Excel lovers celebrate like crazy - Day 40,000 is here!
- ‘Zoom to selection’ with VBA to improve presentation of Excel financial models
- “Input cell reference is not valid” – how to create a Data Table in ANY sheet
- Scenario analysis for freaks - 13 silly options
- Excel and VBA password security
- VBA and Conditional Formatting in Excel
- OFFSET function and tracing formulae
- Financial model review – try this at home!
- IF-fetishism and named-range-bonanza
- Excel forecasting methods and how to assess forecast accuracy
- Full article now published: Reducing Risk in Excel Modelling
- CPA - Excel Secrets and Shortcuts
- Excel 2007 vs. 2010 – What's new
- Spreadsheet skills: hiding formulae
- Worst practice financial modelling
- Spreadsheet skills: Being Sensitive with data tables
- Excel shortcuts – get your Excel shortcuts cheat sheet
- Make Excel history and win a free financial modelling course!
- Corality Excel challenge - Congratulations Daniel Ferry!
- Spreadsheet Errors – Research by Professor Panko
- Sumwise – will it start a spreadsheet revolution?
- Should we use SUMPRODUCT?
- Desktop sharing – Using Skype to get Excel help from your friends
- So what can you do with an Excel spreadsheet
- Your guide to Excel Mapping Software
- Edward Tufte: Information Design and Data Visualisation
- Best practice financial modelling - Dilbert you should try it!
- Three simple ways to improve communication in your financial model
-
Financial model audit
- What is ‘Usual Practice’ for Calculating Project NPV?
- The time zone advantage in financial model audit iterations
- Do you love clients? Join the team.
- Sorry, but your financial model looks like Berlin (before 1989)!
- Can new spreadsheet infrastructure assist financial model audits in real-time?
- 4 Free alternatives to a financial model audit
- What is an ‘iteration’ in a financial model audit?
- Controlling costs in the financial model audit process
- Top 10 tips to reduce errors in excel modelling
- Seasons Greetings
-
Financial modelling industry
- Stand-alone financial modelling can destroy your company
- Charles Darwin, genetics and financial modelling
- www.fimodo.com – New financial modelling website
- 14 steps to improved marketing in your financial model
- You have an ugly baby!
- ‘Financial Modelling Expertise’ – Digit Advisory in Sydney
- “I built the worst financial model in the world!”
- Financial model audit analyst - What is the ideal background?
- What is the ideal background of a financial model audit analyst?
- Recruiting two financial modelling analysts in Sydney
- Does the world need pro bono financial modelling?
- My top 3 ‘Cityboy’ moments
- Career booster for senior financial model auditor
- Leighton and CBA win Queensland school PPP Project
- Australia’s fantastic internet infrastructure project
- Operis Analysis Kit (OAK 4.00) – time to upgrade?
- Rock Financial Modelling – Emma McPherson goes independent
- New Member of the Corality Team
- We’re recruiting!
- New Royal Adelaide Hospital PPP Project
- London – New financial model audit specialist in town!
- LinkedIn Group – Financial Modelling in Excel
- Pitfalls of utilising Cloud computing for spreadsheet modelling
- Debt Service Cover Ratio (DSCR) sculpting in Project Finance Modelling - the easy way!
- Regulatory change makes financial planning sector ripe for M&A
-
Training
- Debt-sculpting using VBA and Goal Seek
- Public training courses for financial model auditors?
- Financial modelling training on a shoestring
- Corality Financial Group hosts seminar at the Frankfurt School of Finance & Management
- Business Case Modelling Sydney - 6 & 7 December 2011
- Financial Modelling for Mining Projects training
- Corality training - lunchtime training sessions for PKF Australia
tags
all tutorials
-
Excel - Advanced
- Calculate NPV without Excel formulae
- LOOKUP instead of VLOOKUP and HLOOKUP
- Custom formats in Excel
- Data Validation in Excel
- Goal Seek function in Excel
- Range names in Excel
- Excel Data Tables in any sheet
- An iterative approach to calculating the Internal Rate of Return (IRR)
- How to use SUMPRODUCT
- Custom number formats - Formatting decimals
- Cashflow Available for Debt Service (CFADS)
- Benefits of using Excel shortcuts: get your shortcut sheet
- Cash Sweep Analysis in Project Finance
- Circular Interest – Interest on average balances
- Project Life Cover Ratio
-
Excel - Basic
- Array formulas in Excel
- ICAA Conference: Get Corality’s presentation and excel files
- Excel 2007 Styles Shortcut Tool
- Using trend lines to analyse patterns in historical data
- Excel offset function increases modelling risk
- Custom number formats - Formatting text
- Debt Sculpting to Target DSCR without VBA
- Calculate IRR in Excel
- Debt Service Reserve Account
- Organisational benefits of implementing best practice financial modelling
- Visual Basic for Applications (VBA)
The Corality Training Academy
The Corality Training Academy is your one-stop-shop for financial modelling, project finance and general Excel training. We offer public and in-house training courses for finance professionals globally.
Corality believes in an interactive approach to training. Our training courses are structured around updated case studies and practical workshops – all designed to facilitate learning and make the courses interesting and dynamic. Our course presenters are experts who are currently active professional, not just trainers.
Our public training courses are offered in more than 12 cities across Europe, the United States, Canada, Africa, Australia and Asia and we are continuously adding new locations.
Our tailored in-house training caters specifically to your needs. It helps you build your team’s capabilities and ensure their ongoing development and success. Corality’s extensive library of training materials and case studies ensure we can tailor our courses according to your individual requirements. Our suite of public courses is always growing and the content can be tailored based on the specialty and experience of the course participants.
Best practice modelling methodology - SMART
Our modelling courses are based on our extensively tested best practice modelling methodology, SMART. SMART is a set of best practice guidelines, internationally applauded for effective and professional financial modelling. It emphasises transparency, flexibility and presentation and introduces rules that underpin how Excel can be used to achieve this. The SMART approach to modelling decreases model risk and increases the confidence of all users – it helps people build better models.
Corality’s training courses are designed to demystify financial modelling and course participants are shown how to build their own models, on their own laptop, in a 100% hands-on environment. Attending a Corality course means you get to peek inside to see how we build a model commercially. Our modelling courses are relevant to finance professionals in top tier banks and corporations worldwide who are required to build or analyse financial models or are responsible for their development.
Our general Excel courses are an excellent foundation for anyone who wants to learn more about Excel in order to minimise the errors in their model or spreadsheets. We show you how to find your own errors before someone else finds them and how to present and analyse the outputs.
Our project finance and sector-specific courses leverage off the extensive experience of our professional team. Our suite of project finance courses has plenty to offer regardless of whether you are starting out in project finance, don’t actually work in the industry but want to know more, or even if you are a very experienced financial modeller or transaction professional.
Our courses and their case studies, along with the extensive experience of our delivery team, will provide you with an outstanding solution to your financial analysis and project finance training needs.
Why attend a Corality course?
- Gain the tools to increase confidence in your financial projections and other key metrics for your business
- Learn how to build financial models from scratch – we show you all the secrets and what mistakes to avoid
- Improve your financial modelling techniques and build robust, flexible and transparent financial models using the SMART best practice modelling methodology
- Gain insights from our team of experts who are all currently active professionals, not just trainers
- Enjoy highly personalised coaching from our expert trainers – public training groups are strictly limited to ensure maximised learning through individual attention
- Bring your own problems or discussion points – our courses are 100% hands-on
- Continue learning with website tutorials, e-books and ongoing trainer interaction




