The accountant’s toolkit in Excel

Although accountants may have their own efficient processes, understanding certain rarely used Excel features could save lots of time. For example converting mm-dd dates to dd-mm, highlighting an item in one list but not another, identifying which formulas have been overwritten, automatically colour coding for errors/duplicates/formulas/outliers, reducing bloated file sizes, populating a single table from a single formula or query and more.

Join David Benaim, a long standing MGI collaborator who is considered to be in the top 100 or so Excel people worldwide, as he shows you a multitude of some tools that will speed up your day to day tasks across audit, tax and other accounting disciplines.