Blog Archives

Getting the best out of excel pivot tables

Pivot tables are one of the most powerful features in Excel.  They can quickly summarise a vast amount of data and present it in a clear and concise way.  Adding slicers will provide users with tools to slice and dice

Tagged with: ,
Posted in Excel Pivots, Excel tips

Linking files – some do’s and don’ts

Linking files is a useful feature in Excel but needs to be used with care. I recently had to develop a model for a client where data held in a single workbook and used to feed many other workbooks for

Tagged with: , , , , ,
Posted in Excel Formulas, Excel tips, Uncategorized