The Power View Add-in in Excel 2013 for Windows

IN THIS COURSE

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