Simon Hurst, accountancy's hardest-working Excel lecturer, recently performed his latest material at the Digita conference in Coventry. Here are some edited highlights. A handful of delegates had seen ...

Trying to track down all the circular references in a complex model is a nightmare, but one that Rinstrom solved when he discovered one of Excel’s hidden features. This tutorial sets out what he found ...

Learn how to move by one cell, move to the edge, a specific location, location that has a specific property, to the last inhabited cell on an Excel worksheet.

You can reference a list on another sheet, but it takes a bit more work. In this tutorial, I’ll show you how to populate a dropdown with data on another sheet.