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.




Learn more



---------------------------------------------------------------------------------------








Always the latest news in the kalmstrom.com blog



Follow kalmstrom.com on LinkedIn Facebook, Google+  or Twitter!


back icon next icon