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

IN THIS COURSE

• 1.  Activating Power View in Excel 2016 for Windows
  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
• 2.  Creating a new report in Excel 2016 for Windows
  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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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