The Power Pivot Add-in in Excel 2013 for Windows

IN THIS COURSE

• 1.  Activating Power Pivot in Excel 2013 for Windows
  6m 32s
  Power Pivot is a free add-in for Excel 2013 that allows you to create advanced PivotTables and analyze data from a variety of different sources. You can even use it to manage your own databases. FREE ACCESS
• 2.  Importing your database in Excel 2013 for Windows
  4m 30s
  If you have already created a database in Access, you can import your data tables into Excel 2013 and begin analyzing them in Power Pivot.. This is a great time saver, as it means you can not only take advantage of the data that has already been collected, but also reuse the existing relationships that have already been added to your tables. FREE ACCESS
• 3.  Creating Power Pivot relationships in Excel 2013 for Windows
  5m 39s
  If you want to use Power Pivot to combine and analyze data from multiple data sources in Excel 2013, you are going to first of all need to know how create relationships. These are used to identify how different data types relate to one another. FREE ACCESS
• 4.  Formatting your Power Pivot tables in Excel 2013 for Windows
  6m 25s
  Your Power Pivot database tables in Excel 2013 contain fields, which are organized into columns. It is important to know how to manage and format these columns. FREE ACCESS
• 5.  Applying data formats in Power Pivot tables in Excel 2013 for Windows
  4m 51s
  The different data values found in your Power Pivot tables can be formatted in a number of different ways. You can, for example, apply monetary formats and percentages, and adjust decimal points. In Excel 2013, adjusting the format can help you to ensure that your data is readable and correctly presented. FREE ACCESS
• 6.  Sorting the data in your Power Pivot table in Excel 2013 for Windows
  4m 55s
  Sorting your data in your Power Pivot view is a very good way of uncovering new patterns and analyzing your data. Like in Excel 2013, you can sort your data via the Home tab or by using the column headers. FREE ACCESS
• 7.  Filtering data in your Power Pivot table in Excel 2013 for Windows
  5m 12s
  The filter tools in Excel 2013 are a very good way of locating specific values or simplifying your tables. With Power Pivot, you can create advanced filters using text and numerical queries. FREE ACCESS
• 8.  Creating a calculated field in your Power Pivot table in Excel 2013 for Windows
  3m 12s
  A calculated field in a Power Pivot table is a column that uses existing data in the table to automatically perform a calculation and return the result. This is particularly useful if you want Excel to check the application of a tax rate to a sales purchase, for example. FREE ACCESS
• 9.  Creating custom views in your Power Pivot table in Excel 2013 for Windows
  3m 52s
  Power Pivot perspectives are used to adjust the data values that are visible in your Excel 2013 tables. They allow you to visualize data in different ways, summarize your tables, and create business scenarios. But before you can do this, you are going to need to activate the Advanced options in Power Pivot. FREE ACCESS
• 10.  Updating your Power Pivot tables in Excel 2013 for Windows
  3m 1s
  If Power Pivot uses data contained in a linked or original Excel 2013 worksheet, there are a number of different ways of ensuring that your Power Pivot tables stay up to date. You can choose to have your tables updated automatically, or you can manage the updates yourself, once you have made changes to the source. FREE ACCESS
• 11.  Creating an advanced PivotTable in Excel 2013 for Windows
  4m 47s
  The Power Pivot add-in in Excel 2013 can be used to create advanced PivotTables. Power Pivot is particularly good for analyzing data from multiple tables. All you need to do is make sure that you have correctly configured the relationships between the different fields in the tables you are going to be analyzing. FREE ACCESS
• 12.  Creating an advanced PivotChart in Excel 2013 for Windows
  5m
  The Power Pivot add-in in Excel 2013 can be used to create advanced PivotCharts. Power Pivot is particularly good for analyzing data from multiple tables, meaning you can push your analysis further. All you need to do is make sure that you have correctly configured the relationships between the different fields in the tables you are going to be analyzing. FREE ACCESS
• 13.  Creating a dashboard in Excel 2013 for Windows
  7m 5s
  You can use Power Pivot to create a dashboard in your Excel 2013 workbook. You can combine multiple data reports and graphics, and use them to keep track of your tables. Your dashboard can be used to combine different visualization styles and analyze data from different tables. FREE ACCESS