08 6210 8500
Formula Auditing Toolbar Tracking the formula inputs By Neale Blackwood If you need to analyse formula and track the links to and from a cell use the Formula Auditing Toolbar. In Excel 2003 you can view the toolbar by Right clicking the toolbar and selecting Formula Auditing. In Excel 2007 it appears in the [...]
Spreadsheet blunders cost businesses billions By Jeff Robson A recent report released by UK-based financial modelling company F1F9, has once again highlighted the multi-billion – in this case, pound – costs to business of spreadsheet errors. Kenny Whitelaw-Jones, F1F9 Managing Director, said that his company’s estimates suggested 88 per cent of spreadsheets contained errors, and [...]
Financial Modelling Risk is Inevitable Managed well, it can create business value, but the alternative can be costly. By Jeff Robson Effective modelling to quantify and manage business risk is vital across all industry sectors. Models can be Economic: examining strategic planning and project evaluation. Such models are typically long term (5-30 years), contain [...]
How to tell if your Financial Models are at Risk By Jeff Robson Worldwide, legions of spreadsheets support corporate infrastructure. Every day, directors, managers and professionals in all disciplines use those spreadsheets to make business-critical decisions with far-reaching consequences. But, many studies over the past 10 years have shown that 80 to 90 [...]
Excel Formula Auditing Tips for improving data quality through Excel Formula Auditing By Jeff Robson Excel formula auditing is important! If you regularly create or review spreadsheets, you'll know just how many errors there can be! Experts estimate that on average, about 80% of complex spreadsheets contain some kind of material error. So if you're [...]
Reach out to the Access Analytic team Monday to Friday on (08) 6210 8500 or submit your contact information and we will be in touch.
Get Ahead of the Game – Book Your Training Now!
Wyn has been awarded MVP status by Microsoft every year since 2017 and is the author of the book “Power BI for the Excel Analyst”. He is known worldwide for sharing his knowledge via the Access Analytic YouTube channel with over 5 million views and 90,000+ subscribers.
He gained his Chartered Accountant qualification at PwC in 2000 and has extensive Business Analyst experience with HBOS and Barclays in the UK plus multinational clients in Perth.
Wyn is skilled in Excel and Power BI development, Power Query automation, management reporting and is an experienced Excel and Power Bl trainer.
Pay my invoice
