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

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