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 ...

Learn how to dynamically insert blank rows in Excel to improve data readability, organization, and clarity with advanced techniques.

Use implicit And and Or operators with Excel's Advanced Filter feature to create complex, but powerful, filtering combos.