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 […]
Visual reports are another fantastic way to share figures with stakeholders in way that’s digestible and easy to break down. In Project 2013, you can view specific project data in a visual report in Excel or Visio, if you have those programs installed. How to: Select Reports, Visual Reports, select an Excel or Visio report for your project […]
Whether you’ve decided to use a suggested chart to represent your data or already knew which one works best from the outset, a new toolbar in Excel 2013 allow you to customise your visualisation quicker. Selecting the chart will automatically reveal two tool ribbons: Design & Format, both specifically designed to help you manipulate your […]
For users with the Office Professional Plus package, the Inquire add-in comes pre-installed on Excel 2013. Helping you to analyse, audit and review workbooks, this great new feature also has the potential to highlight errors and security concerns. We recently discussed, how to take back control of your spreadsheets by reducing “fat finger mistakes” and […]