Excel GETPIVOTDATA Function

getpivotdata function

October 20, 2014

Excel GETPIVOTDATA Function

In its simplest form the Excel GETPIVOTDATA function enables you to extract values from a PivotTable report, but if you’re

Read More
Chart Makeover

October 13, 2014

Excel Chart Makeover

Getting the formatting in your chart right can make the difference between clear, concise information and just a pretty picture.

Read More
Interactive Excel Formulas

October 6, 2014

Interactive Excel Formulas

Dynamic formulas are the cornerstone of interactive reports like dashboards. They enable our report recipients to interact with the data,

Read More
Excel Chart Templates

April 22, 2014

Excel Chart Templates

If you find yourself repeatedly spending a few minutes customising your chart colours, formatting the title, legend, axis labels etc.

Read More
Curse You Excel Cursor

January 30, 2014

Curse You Excel Cursor

The Scenario You need to change the range referenced by your chart/conditional formatting/named range so you merrily open the Edit

Read More