In his second tutorial of this two-part series, David Carter shows how to use AutoFilter and pivot tables to analyse data extracted from the Exchequer ...

If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C. The Creator property is designed to be used in Microsoft ...

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