Excel 2016 from Scratch

Power View – an Excel BI tool

An Excel tutorial by Peter Kalmstrom

Excel 2016 iconThe Excel Power View is a tool for Business Intelligence analyses and reports. It resembles the pivot table and chart, but it is even more powerful.

In this exercise in the Excel 2016 from Scratch series, Peter Kalmstrom shows how reach and use Power View.

Before you can open Power View the first time, you have to:
  • Enable the Data Analysis add-ins that are necessary to use the Power View.
  • Install Silverlight if you have Windows 10. (Silverlight is installed by default for Windows 7 and 8.)
In the demo below Peter explains how to filter, analyze and visualize sales data in different views. He also shows how to create charts.
 
Excel Power View


Peter uses Excel 2016 for his demo, but Excel 2013 also has the Power View.






Follow kalmstrom.com on LinkedIn, Facebook or Twitter!


back icon next icon
Products Buy FAQ Services Tips Books Contact About Us Tools

Security and integrity

Copyright  Kalmstrom Enterprises AB  All rights reserved