The Excel Community has moved off of the ION site this month and all content is now right here on icaew.com!  A few posts from early September will still direct to the older site.

Excel Tip of the Week

357 – Removing duplicates redux (public)

Get rid of duplicate values from your table – whether with the Ribbon tool or with the new UNIQUE function – and understand how each works, with our handy guide.

358 – Revisiting FREQUENCY

This unusual array function can quickly tot up how many values fall into a number of buckets – making for quick and easy histograms.

359 – Audit sampling templates: VBA

Our three-part series concludes with a look at how to do random or monetary unit sampling using VBA code.

360 – Revisiting typing special characters

Whether you’re looking for a ♥ or a 😁, you can enter special characters in Excel directly from the keyboard – we show you how.

361 – How to do data entry

We get back to basics with a look at the keyboard shortcuts, best practices, and tips you need to do data entry simply, efficiently, and securely.

Other blogs

Intro to Financial Modelling – Part 9: Clarity – Labelling & explanation

Andy Paw of Protiviti brings us the latest instalment in our examination of the lessons of the Financial Modelling Code – looking at why labelling and explanation aren’t just nice-to-haves, but essential pieces of the model-building process.

Audit sampling techniques – the Power Query alternative – part 1 and part 2

Simon Hurst brings his own spin to the recent TOTW series on audit sampling, examining how to manage random and monetary unit sampling with Power Query as a fourth option.