facebook google plus twitter
Webucator's Free Advanced Microsoft Excel 2013 Tutorial

Lesson: Microsoft Excel 2013 New Features

Welcome to our free Advanced Microsoft Excel 2013 tutorial. This tutorial is based on Webucator's Advanced Microsoft Excel 2013 Training course.

Excel 2013 provides a number of new features to help you efficiently and effectively create and edit workbooks.

Lesson Goals

  • Use slicers to filter data.
  • Create a PivotTable timeline.
  • Create a standalone PivotChart.

Using Slicers to Filter Data

Slicers was a new feature added to Excel 2010, which allows users to filter PivotTable data. In Excel 2013, you can now use slicers to filter table data.

To filter data using slicers:

  1. Click in the table.
  2. From the TABLE TOOLS DESIGN tab, from the Tools group, select Insert Slicer. Insert Slicer Command
  3. In the Insert Slicers dialog box, check the check boxes of the desired slicers. Insert Slicers Dialog Box
  4. Click OK. OK
  5. The slicers are now displayed in the worksheet. Slicers Displayed

Filtering Data with Slicers

Duration: 05 to 10 minutes.

In this exercise, you will use slicers to filter data in Excel 2013.

  1. Open Filtering with Slicers.xlsx from your Excel2013.3/Exercises folder.
  2. Create slicers for the data for the months of January, February, and March.

Solution:

  1. Click in the table. Table
  2. From the TABLE TOOLS DESIGN tab, from the Tools group, select Insert Slicer. Insert Slicer Command
  3. In the Insert Slicers dialog box, check the Jan, Feb, and Mar check boxes and click OK. Insert Slicers Dialog Box
  4. View the slicers in your worksheet. View Slicers

Creating a PivotTable Timeline

You can now use the PivotTable Timeline feature to filter your data by time.

To create a PivotTable Timeline:

  1. Click the PivotTable.
  2. From the PIVOTTABLE TOOLS ANALYZE tab, in the Filter group, select Insert Timeline. Insert Timeline Command
  3. In the Insert Timeline dialog box, check the check box of the date fields you want in the timeline. Check Boxes
  4. The timeline is displayed. To filter by date, click the arrow next to the time section and make a selection. Filter By Date
  5. Drag the scrollbar to see the filtered data. Scrollbar
  6. To see a specific time period, click and drag the timeline handles. Timeline Handles
  7. Click the Clear Filter button to clear the timeline. Clear Timeline

Creating a Timeline

Duration: 05 to 10 minutes.

In this exercise, you will create a PivotTable timeline.

  1. Open PivotTables Timeline.xlsx from your Excel2013.3/Exercises folder.
  2. Create a PivotTable Timeline based on the PivotTable showing all periods.

Solution:

  1. Open the PivotTable and click it to select it. PivotTable
  2. From the PIVOTTABLE TOOLS ANALYZE tab, in the Filter group, select Insert Timeline. Insert Timeline Command

Creating a Standalone PivotChart

In previous versions of Excel, a PivotChart needed to be associated with a PivotTable; however, in Excel 2013 you can now create a standalone PivotChart.

To create a standalone PivotChart:

  1. Click in your data.
  2. Select the Insert tab and, in the Charts group, select Recommended Charts. Charts Group Class
  3. On the Recommended Charts tab, select a chart with the PivotChart icon and view the preview. View Preview
  4. When you find a chart you would like to select, click OK. Chart to Select
  5. The PivotChart is displayed. PivotChart Displayed

Workspaces in Excel 2013

One of the features of previous versions of Excel was the ability to create workspace. This command is no longer available in Excel 2013; however, if you have a previous workspace file (ending with the file extension .xlw), you can open it in Excel 2013.