Categories
Excel Training

Excel 2013: Use Timelines With PivotTable Data – MS Excel Training

new feature for microsoft office 2013See 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 be very comfortable with the timeline feature.

Timeline for PivotTables

  1. To add a Timeline, click in your PivotTable data area and from the Analyse ribbon select Insert Timeline from the Filter group.
  2. Select the date field required and your Timeline is now ready to be used to filter your date field chosen.
  3. You can change the specified dates by simply dragging each end of the timeline.

In the real world this could be a particularly handy tool on your performance dashboards. Once you’ve set everything up, you can then let users build their own view on the data.

Timeline for PivotTables

For more tips and features on Excel 2013 and other versions, browse MS Excel Training courses from Best STL, available London and UK wide. Speak to our a member of our team today to discuss the latest training offers along with your specific requirements. 

Categories
Project Training

MS Project 2013: View visual reports instantly in Excel or Visio

what's new in office 2013Visual 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 ReportsVisual Reports, select an Excel or Visio report for your project data, and click View.

Excel builds a local Online Analytical Processing (OLAP) cube file and shows your data in an Excel PivotChart or Visio PivotDiagram. Once in Excel or Visio, you’ll be able to get the most from your data thanks to a host of new tools including recommended charts and quick analysis techniques. Reporting has never been so easy.

If you’re feeling adventurous, why not customise your data even further with three new tools for Excel 2013.

visual reports in ms project

Find out more great advice like this with a Best STL course on Microsoft Project training, London and UK wide.