The Power View Add-in in Excel 2013 for Windows

Excel 2013 (Windows)    |    Expert
  • 14 videos | 1h 7m 27s
  • Earns a Badge
Rating 3.7 of 3 users Rating 3.7 of 3 users (3)
Power View allows you to create reports you can use to extract, analyze, and present data contained in the different tables in your workbook. Learn how to use Power View, including creating and formatting reports and creating relationships.

WHAT YOU WILL LEARN

  • Activating power view
    Creating a new report
    Managing your report tables
    Grouping data with tiles
    Creating relationships between tables
    Formatting your power view report
    Filtering the data in your report
  • Reusing a table
    Using a matrix table to visualize your data
    Using bar & column charts to visualize your data
    Using line charts to visualize your data
    Using scatter charts to visualize your data
    Using pie charts to visualize your data
    Visualizing your data in map form

IN THIS COURSE

  • 3m 25s
    Power View is an add-in that comes free with Excel 2013. You can use it to create reports that can help you to extract, analyze and present data contained in the different tables in your workbook. To begin using Power View, you will first of all need to know how to activate it. FREE ACCESS
  • 5m 53s
    Power View can be used to create reports that analyze data taken from multiple tables or sources within your Excel 2013 workbook. You can activate the various data fields to display only the data values you need. If you want to use data taken from different tables in your workbook, however, you will need to know how to manage your Power View relationships. FREE ACCESS
  • Locked
    3.  Managing your report tables in Excel 2013 for Windows
    5m 1s
    Once you have created a Power View report in Excel 2013, you will need to know how to manage the various data elements. You can, for example, adjust the size and positioning of your views, update your data values, and even change the appearance of your tables. FREE ACCESS
  • Locked
    4.  Grouping data with tiles in Excel 2013 for Windows
    4m 47s
    Tiles are used in the Excel 2013 Power View add-in to create data value groups and filtered views. You can, for example, use a particular field, such as state or city, to group and show only the records that match a specified value. FREE ACCESS
  • Locked
    5.  Creating relationships between tables in Excel 2013 for Windows
    3m 52s
    If you want to combine values from separate data tables in your workbook, you will need to create relationships that tell Excel 2013 how to interpret the connected data. You can use these relationships to link data contained in an address book to data contained in an order database, which in turn could be linked to data in a product catalog. Once these relationships have been created, you can create reports that offer a far larger scope for analysis and pattern interpretation. FREE ACCESS
  • Locked
    6.  Formatting your Power View report in Excel 2013 for Windows
    6m 58s
    The Power View theme tools are very useful when it comes to changing the formatting and appearance of your report in Excel 2013. You can add titles and text boxes, change the report's font sets and color scheme, and even add a shaded background. FREE ACCESS
  • Locked
    7.  Filtering the data in your report in Excel 2013 for Windows
    6m 48s
    Excel 2013's Power View add-in features a number of different tools for filtering your data. You can apply multiple filters simultaneously, apply your filters to your entire report or just your selected view, and even advanced apply filter ranges to focus your attention on particular values. FREE ACCESS
  • Locked
    8.  Reusing a table in Excel 2013 for Windows
    5m 14s
    Any data view, table or graphic that you have created in a Power View report can be transported from one Power View sheet to another. This is a great way of reusing data elements that you have already created. To do this, all you need to do is use the Excel 2013 copy and paste tools. FREE ACCESS
  • Locked
    9.  Using a Matrix Table to visualize your data in Excel 2013 for Windows
    5m 59s
    In Excel 2013, you can use a Matrix Table, similar to a PivotTable, to analyze your data. Once you have created a Power View report, you can choose to visualize your data in Matrix Table form. This is particularly useful as it allows you to combine data from a variety of different sources. FREE ACCESS
  • Locked
    10.  Using bar & column charts to visualize your data in Excel 2013 for Windows
    3m 45s
    Charts are a very good way of visualizing trends and patterns in your Power View report. In Excel 2013, the simplest ones to create are bar or column charts. FREE ACCESS
  • Locked
    11.  Using line charts to visualize your data in Excel 2013 for Windows
    3m 12s
    Line charts in Excel 2013 can be used to represent values on both axes. For example, you can use them to analyze a developing data trend over time. The line charts that can be created in your Power View report are highly customizable. FREE ACCESS
  • Locked
    12.  Using scatter charts to visualize your data in Excel 2013 for Windows
    3m 5s
    A scatter chart in Excel 2013 can be used to analyze multiple data fields in a single graphic. The X and Y axes, as well as the size and color of the data points, can be used to represent a value. The scatter charts in Power View are extremely customizable. FREE ACCESS
  • Locked
    13.  Using pie charts to visualize your data in Excel 2013 for Windows
    4m 32s
    In Excel 2013, a pie chart is a good way of comparing divisions or slices of a larger whole (often in percentages). In Power View, you can customize your pie chart to include different series and slices. FREE ACCESS
  • Locked
    14.  Visualizing your data in map form in Excel 2013 for Windows
    4m 57s
    If you have added country or localization data to your Power View report in Excel 2013, you can display it using a map. This is a very good way of visualizing your data and associating abstract values with regions or countries. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Rating 4.7 of 3 users Rating 4.7 of 3 users (3)
Rating 4.5 of 475 users Rating 4.5 of 475 users (475)
Rating 4.5 of 319 users Rating 4.5 of 319 users (319)