Microsoft Office Tutorials and References
In Depth Information
You might call the new Timeline feature a date slicer . If your data includes dates, as in
Figure 1-6, you can include a Timeline with your PivotTable or PivotChart that is used to limit
the displayed data to any date range you want—in days, months, quarters, or years. For
more information, see ”Creating a Power View report” in Chapter 24, “Using PowerPivot.”
Figure 1-6 You can click any month segment on the Timeline bar to display only that month’s
data, or drag a handle to include as many months as you want.
Here are more upgrades and enhancements you’ll find in Excel 2013:
Recommended PivotTables Similar to the Recommended Charts feature,
Recommended PivotTables analyzes the selected data and offers appropriate suggestions.
For more information, see Chapter 24.
Table slicers Slicers were introduced in 2010, but they worked only with
PivotTables. The interface has been upgraded for 2013, and you can now use slicers with
other kinds of data tables as well. For more information, see “Creating a Power View
report” in Chapter 24.
One workbook, one window, one worksheet New workbooks contain a single
sheet in 2013, not three. And previously, all open workbooks were enclosed within a
single Excel window. Now, each workbook is its own window, making it easier to work
with multiple workbooks, particularly for multiple-monitor users. For more
information, see Chapter 7, “How to work a workbook.”
Rich chart data labels Data labels in charts are more customizable in 2013. You
can create labels with text that updates automatically, you can apply rich formatting,
and you can display text inside shapes. For more information, see “Adding and
positioning data labels” in Chapter 19.