Using the Power View Add-in in Excel 2016 for Windows

Excel 2016 (Windows)    |    Intermediate, expert
  • 17 videos | 1h 6m 2s
  • Includes Assessment
  • Earns a Badge
Rating 4.4 of 62 users Rating 4.4 of 62 users (62)
You can use the Power View add-in to create reports in Excel 2016. Discover the capabilities of Power View, including illustrating and organizing reports, filtering data, and adding PivotTables and charts to reports.

WHAT YOU WILL LEARN

  • Activating power view
    Creating a new report
    Managing your report tables
    Grouping data with tiles
    Creating relationships between tables
    Illustrating your power view report
    Formatting your power view report
    Organizing your power view report
    Filtering the data in your report
  • Using the advanced filter options in your power view 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

  • 4m 2s
    Power View is an add-in that comes free with Excel 2016. 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
  • 4m 31s
    Power View can be used to create reports that analyze data taken from multiple tables or sources within your Excel 2016 workbook. You can activate the various data fields to display only the data values you need. FREE ACCESS
  • Locked
    3.  Managing your report tables in Excel 2016 for Windows
    5m 46s
    Once you have created a Power View report in Excel 2016, 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 2016 for Windows
    3m 48s
    Tiles are used in the Excel 2016 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 2016 for Windows
    3m 7s
    If you want to combine values from separate data tables in your workbook, you will need to create relationships that tell Excel 2016 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.  Illustrating your Power View report in Excel 2016 for Windows
    4m 27s
    As well as creating graphics and tables in Power View for Excel 2016, you can add titles and text boxes to illustrate your reports. This is very useful if you want to add explainers, titles, or additional information to your report. FREE ACCESS
  • Locked
    7.  Formatting your Power View report in Excel 2016 for Windows
    4m 27s
    The Power View theme tools are very useful when it comes to changing the formatting and appearance of your report in Excel 2016. You can change the report's font sets and color scheme, and even add a shaded background. FREE ACCESS
  • Locked
    8.  Organizing your Power View report in Excel 2016 for Windows
    2m 58s
    The graphics and other elements (including images and text boxes) that have been inserted into your Power View report in Excel 2016 can be arranged and organized in different ways. You can adjust the settings of each element to create layers, and move your items around to improve the layout and visibility of your report. FREE ACCESS
  • Locked
    9.  Filtering the data in your report in Excel 2016 for Windows
    3m 35s
    Excel 2016'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 even specify the view that you wish to modify. FREE ACCESS
  • Locked
    10.  Using the advanced filter options in your Power View report in Excel 2016 for Windows
    4m 5s
    The Power View add-in in Excel 2016 includes advanced filter options to change how you view your data. You can specify filter arguments, ranges, and criteria to obtain precise values, and even use linked graphics to filter data quickly in a report. FREE ACCESS
  • Locked
    11.  Reusing a table in Excel 2016 for Windows
    3m 36s
    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 2016 copy and paste tools. FREE ACCESS
  • Locked
    12.  Using a Matrix Table to visualize your data in Excel 2016 for Windows
    4m 1s
    In Excel 2016, 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 a Matrix Table. This is particularly useful as it allows you to combine data from a variety of different sources. FREE ACCESS
  • Locked
    13.  Using bar & column charts to visualize your data in Excel 2016 for Windows
    2m 46s
    Charts are a very good way of visualizing trends and patterns in your Power View report. In Excel 2016, the simplest ones to create are bar or column charts. FREE ACCESS
  • Locked
    14.  Using line charts to visualize your data in Excel 2016 for Windows
    3m 59s
    Line charts in Excel 2016 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
    15.  Using scatter charts to visualize your data in Excel 2016 for Windows
    3m 12s
    A scatter chart in Excel 2016 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
    16.  Using pie charts to visualize your data in Excel 2016 for Windows
    3m 23s
    In Excel 2016, 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
    17.  Visualizing your data in map form in Excel 2016 for Windows
    4m 19s
    If you have added country or localization data to your Power View report in Excel 2016, 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.5 of 27 users Rating 4.5 of 27 users (27)
Rating 4.6 of 416 users Rating 4.6 of 416 users (416)
Rating 4.5 of 125 users Rating 4.5 of 125 users (125)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 3.5 of 57 users Rating 3.5 of 57 users (57)
Rating 4.6 of 3273 users Rating 4.6 of 3273 users (3273)
Rating 4.6 of 1179 users Rating 4.6 of 1179 users (1179)