Microsoft Office Tutorials and References
In Depth Information
Validating data using a list
Presenting data by using Power view
Summarizing data visually helps transform huge collections
of individual data points into actionable information. Excel
2013 enhances your ability to visualize your data with Power
View, a data visualization tool that originated as part of
SharePoint 2010. You will need to have Microsoft Silverlight
installed on your computer to take advantage of Power View.
One of the most interesting and useful Power View
capabilities is visualizing data in coordination with Bing maps. If your
data includes geographical information, combining your data
with a Power View map sheet can generate valuable insights.
A full discussion of Power View is beyond the scope of this
book, but you can find much more information by visiting
www.office.com/excel and searching for articles by using the
search phrase power view .
Power View analyzes data that you have included in the Excel
2013 data model. Using the data in the data model, you can
summarize your data by using pie charts, maps, Key
Performance Indicators, and reports. You have a wide range of
formatting and analytical capabilities available to you, so you
can change the report style, theme, or text sizing; add and
edit background images; and view your data at higher and
lower levels of granularity by drilling up, drilling down, and
creating analytical hierarchies.
As of this writing, PowerPivot and Power View are available
only for users who have installed Office 2013 Professional
Plus, SharePoint 2013 Enterprise Edition, SharePoint Online
2013 Plan 2, and the E3 or E4 editions of Office 365. It is
possible that Microsoft will subsequently make both PowerPivot
and Power View available to all users.