Liam Bastick
Member Since: 14th May 2018
Likes: 0
Thanks: 0
Recognised by Microsoft as one of 104 Most Valuable Professionals (MVPs) in Excel worldwide by Microsoft, Liam has over 30 years’ experience in financial model development/auditing, valuations, M&A, strategy, training and consultancy. He has headed Ernst & Young’s modelling team in Melbourne and was an Assistant Director in their strategic valuations team in London. He was also a senior member of the UK Post Office’s M&A and strategy teams and has worked for / assisted various other Australian modelling companies including BPM, Corality, Navigator Project Finance, PKF and SumProduct.
He has worked in the UK, Australia, Belgium, Denmark, France, Germany, Hong Kong, Indonesia, Malaysia, New Zealand, United States, Switzerland and Vietnam, with many internationally recognised clients, constructing and reviewing strategic, operational and valuation models for many high profile IPOs, LBOs and strategic assignments. 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.
Director SumProduct
6th May 2020
New Excel functions: XLOOKUP and XMATCH
I have explained previously why INDEX MATCH was a more powerful LOOKUP combination than VLOOKUP , which to this day remains one of the...
Excel
18th Mar 2020
Common spreadsheet data issues and how to solve them
Convert numbers stored as text to numbers Sometimes when you import data from text files or external databases, numbers (including dates)...
Excel
5th Mar 2020
Working with text in Excel
There are certain functions in Excel that will allow you to select only part of a text string. For example, you may have a collection of (...
Excel
13th Feb 2020
How to detect errors in your spreadsheets
Given most of us use Excel to work with numbers, many analysts do not realise the importance of checking their work. For spreadsheets to be...
Excel
30th Jan 2020
The importance of cleaning up data
Many analysts use Excel to summarise cleaned-up data and convert it into information, with structured (sorted and/or ordered) referencing,...
Excel
12th Dec 2019
Dynamic Arrays: 15 months later
If the responses to my LinkedIn account are anything to go by, half the world has been waiting for this. The long-awaited roll-out of...
Excel
12th Nov 2019
New views for Power Query
This has popped up “on the quiet” from Microsoft so we aren’t sure yet what versions of Excel this is in, or when it will be propagated to...
Excel
5th Nov 2019
Dynamic Arrays vs legacy array formulae
Prior to this new functionality, if you wanted to work with ranges, you used to have to build array formulae, where references would refer...
Excel
16th Oct 2019
Death of data tables and PivotTables?
If the “final” versions of Dynamic Arrays highlighted here do not change drastically once they become generally available, there will be...
Excel
2nd Oct 2019
Dynamic Arrays and #SPILL! errors
In the previous article in this series, we looked at the basics of the new Dynamic Arrays . Before I carry on there is a question I do need...
Excel