Microsoft Office Tutorials and References
In Depth Information
Animations As you work in Excel 2013, you’ll notice subtle animations in various
situations, including updating charts, inserting data, and copying and pasting. For
example, when you insert a row, the rows below the new row appear to scroll
downward. This was formerly referred to as visceral feedback , which is a clue to its true
value. The animations are not exactly essential, but they help illustrate the changes
incurred by your actions.
Standalone PivotCharts Now, your Pivot Charts do not need to remain tethered
to a PivotTable; you can copy and paste them as you wish, without the baggage. For
more information, see “Creating PivotCharts” in Chapter 23, “Analyzing data with
New functions There are always new functions, and this time, most of them are
meant to increase compatibility with the Open Document format.
The Excel Data Model Some of the power from the PowerPivot add-in that was
introduced in Excel 2010 has now been incorporated into Excel as the Excel Data
Model, which you can use to address multiple tables of data from within Excel. For
more information, see Chapter 24.
Power View This new feature leverages the power of the Excel Data Model, which
you can use to construct elaborate presentation-ready reports that include
graphics and data from multiple tables or external data sources. For more information, see
“Creating a Power View report” in Chapter 24.
Does your ribbon look different?
In this topic, we provide instructions based on traditional keyboard and mouse input
methods. If you’re using Excel on a touch-enabled device, you might be using a
stylus or your inger to give commands. If so, substitute a tapping action any time we
instruct you to click a user interface element. Also note that when we tell you to enter
information in Excel, you can do so by typing on a keyboard, tapping an on-screen
keyboard, or even speaking aloud, depending on your computer setup and your personal