• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Microsoft Excel Tips and Tricks - Computergaga

  • Home
  • Excel Online Courses
  • Excel Functions List
  • Free Downloads
  • Blog
  • Tutorials
  • About
Home / Archives for PivotTables

Using Timeline Slicers in Excel 2013

Timeline Slicers are a new addition to Excel 2013. They are a new filter tool that is available exclusively to the date fields in your PivotTables. They are visually appealing and easy to use.

To use a Timeline with your PivotTable;

[Read more…] about Using Timeline Slicers in Excel 2013

Show PivotTable Report Filter on Different Sheets

The report filter is fantastic for analysing Excel PivotTable data. It allows you to filter the PivotTable using any field from your data source.

An awesome feature called Show Report Filter Pages will display each report filter result on a different sheet of your workbook. This works great when there are only a few filter criteria.

This feature always goes down well in training sessions. It allows you to quickly and easily create multiple reports on different sheets of a workbook, based on the criteria you want to use.

[Read more…] about Show PivotTable Report Filter on Different Sheets
  • « Go to Previous Page
  • Page 1
  • Page 2
  • Page 3

Primary Sidebar

Recent Posts

  • Excel SWITCH Function – Nested IF Function Alternative
  • Sum Formulas Only in Excel
  • How to Calculate Age in Excel
  • Custom Sort in Excel
  • Case Sensitive Lookup with XLOOKUP in Excel
Advanced Excel Success book

Footer

Contact

[email protected]

LinkedIn Twitter YouTube

Useful Links

  • Home
  • Excel Online Courses
  • Tutorials
  • Sitemap
  • Privacy Policy
  • Jobs by Jooble

Course Topics

  • Blog
  • Charts
  • Courses
  • Dashboards
  • Downloads
  • Excel Tips
  • Formulas
  • Mail Merge
  • Office
  • PivotTables
  • Power BI
  • Power Pivot
  • Power Query
  • VBA

Join Our Mailing List

© Copyright 2009 Computergaga · All Rights Reserved ·