In life as in business, we always strive to find the easiest ways of getting things done. Sometimes, however, the simplest methods involve cutting corners, obtaining short-term results but long-term headaches. One of a long line of Excel features, the PivotTable is the best way to break your information down into more manageable chunks. In […]
See the timing of trends in your Excel 2013 PivotTable data with the new timeline feature. By default the data is split into months, though manipulation allows you to break this down into weeks, quarters, years or even days if you prefer. If you make user of Slicers in your PivotTables and PivotCharts, you will […]
Poor Excel skills are costing UK businesses millions in lost revenue. According to an article in the Financial Times more than half of financial service groups have “poorly applied or no controls for managing business critical spreadsheets”. The article blamed losses in part due to “avoidable errors in MS spreadsheets”. So, what could thousands of UK […]