Amazing Reports and Dashboards with Excel Power View

Learn to use the new Excel 2013 PowerView feature to create powerful interactive dashboards and analyze data.

Join the 1% of Excel users who know how to use the most powerful features and tools in Microsoft Excel

Excel Power View is a powerful new tool in Excel 2013 which will allow you to explore, visualize and present your data in ways you never knew possible.

Learn to use Power View to create powerful interactive graphical dashboards. Power View is an interactive data exploration, visualization and presentation experience that improves decision making and gives you strong insight in to your business.

Amazing Reports and Dashboards with Excel Power View is the second course to be released about Excel Business Intelligence. The Excel Business Intelligence suite of tools includes PivotTables, PowerPivot, Power View, PowerQuery, PowerMap and PowerBI.

Excel Business Intelligence skills and capabilities are in high demand as companies are using Excel to analyze their business data to generate new intelligence and insight. McKinsey Consulting recently released a report showing that approximately 1.5 million new management job positions are required in the United States with data analysis skills and capabilities.

This course introduces you to the Excel Power View interface, teaches you how to create tables and graphs, learn to easily filter data and ask questions of your data, perform powerful data analysis and develop interactive dashboards.

The course also includes how to create relationships between between two tables of data and how to easily create reports and visualizations from both data sources using simple drag and drop actions. The course teaches users how to easily create time based scatterplot and bubbleplot advanced visual analysis techniques.

This course is for any Excel user who develops management reporting or performs data analysis to gain new insight from data. Excel Power View is only available in specific versions of Excel 2013 so first confirm that you have the correct version of Excel.

The course includes two downloadable training datafiles and currently has 23 video lectures showing how to use Excel Power View.

Introduction to Excel PowerView
About Excel Power View
Activating Excel Power View
Download the Training Data
Correctly Structure Your Data
Introduction to the First Section
Insert a New Canvas
Create a Table
PowerView Menu Options
Using Tiles
Different Table Types
Changing the Method of Calculation
Pop Outs and Filtering Tables
Introduction to Graphs and Visualizations
Create a Column Chart
Create a Bar Chart
Create Line Charts
Creating Pie Charts
Geographical Mapping
Create a Scatterplot Chart
Understanding Changes over Time
Introduction to Data Relationships
Download the Power View World Bank Indicators spreadsheet
Creating Data Relationships
Creating Graphs with Data Relationships
Creating Scatterplots with Data Relationships
Introduction to Interactive Dashboards
Creating Interactive Dashboards
Conclusion

What's included

  • 20 Video Lessons
  • 9 Text Lessons

  • Works on all devices
  • Certificate of completion

Ian Littlejohn

Instructor