Excel 2013 new feature: Timeline Slicer

What’s New in Excel 2013?  Timeline Slicers !

Timeline Slicers are a feature new to Excel 2013.
If your PivotTable contains dates, a Timeline Slicer affords you and your reviewers an easy method to filter and scale of the dates displayed..

(For detailed instructions on creating PivotTables review the 5 minute video tutorial  PivotTables and Slicers )

Inserting the Timeline Slicer

  1. Click here to open the file PivotTable Advanced Functions.xls file.
  2. Review the Sales sheet. This is the source of our PivotTable data.
  3. Click the Summary Sheet. A PivotTable has already been inserted, with the dates of Weekly Sales displayed in Rows, and a Slicer for the Category field applied.
  4. Select one of the cells containing data (e.g. A4).
  5. On the Ribbon, on the PIVOTTABLE TOOLS: ANALYZE tab, in the Filters group, click Insert Timeline. The Insert Timelines dialog appears.
  6. Check Weekly Sales and click OK. The Weekly Sales Timeline Slicer appears.
askq_timeslicers2
Weekly Sales Timeline Slicer

Working with Timeline Slicers

  • CLICK or CLICK+ DRAG on the timescale to filter timeline.
  • To change the scale, click the Level drop-down, at right, and select Years, Quarters, Months, or Days.
  • To quickly format, select a style from  the Timeline Styles on the TIMELINE TOOLS: OPTIONS  tab of the Ribbon.

Cheers!
hɔuᴉnb

Comments and questions are always welcome!

Advertisements

Author: quincy harley jr

Quincy is a technophile, coach and Learning Development expert. He has an extensive legal IT background and is practiced in MS Office application support and product development. As a project leader he has been integral in numerous new application rollouts. Whatever spare time he has, is spent with reading, archery and watching his young sons grow.

2 thoughts on “Excel 2013 new feature: Timeline Slicer”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s