Join David Rivers for an in-depth discussion in this video Filtering records using a Timeline, part of Office 2013 New Features.
If you like to use pivot tables to analyze data, you're going to like this next new feature …that allows you to filter via a timeline.…It's called the Timeline Filter.…We're going to use this file named, No Obstacle Sport - July 2012 Sales Report,…which as you can see from the very first Data sheet here is a list of sales for each of the days in July.…So, we have multiple sales on the first of July.…You can see the SKUs for the items, their prices, and if we scroll all the way…down to the bottom of this sheet, we're going to see a grand Total Revenue for the month of July 2012.…
This is a perfect opportunity for a pivot table that will help us to analyze that data …and make it a little bit easier to understand.…Let's go to the Pivot Tab where a pivot table has already been created based on two fields.…As you can see we have the Date field and we have the Sum of the Price field next to it.…So, instead of individual sales, we see the total sales for the first of July, the second, and so on.…And as we scroll down, there's our Grand Total.…
- Exploring the new user interface
- Using the bookmark feature
- Inserting online video in Word documents
- Editing PDFs in Word
- Filtering records using the timeline in Excel
- Exploring new slide transitions in PowerPoint
- Creating web apps for SharePoint or Office 365 with Access
- Inserting online pictures with Publisher
- Embedding files in a OneNote notebook
- Connecting to social networks with Outlook
Skill Level Intermediate
1. Suite-Wide Enhancements
Using the Weather bar1m 42s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.