Compose tips
Filter
Filter
Filter
Filter
Filter
Filter
Filter
Filter
Filter
Filter
Filter
Filter
Filter
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)
Upcoming Courses
Testimonials
"Corality completed the audit within the tight timeframe and was able to communicate the findings in a clear and succinct manner. Their best practice recommendations were especially useful in improving the integrity of my financial model in the long-run."
Parvin Walia, Commercial Manager
