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

IN THIS COURSE

• 1.  Activating Power Pivot in Excel 2016 for Windows
  2m 33s
  Power Pivot is a free add-in for Excel 2016 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.  Using the view settings in Power Pivot in Excel 2016 for Windows
  3m 47s
  There are two main view modes when using the Power Pivot add-in in Excel 2016: grid (similar to the standard datasheet view) and diagram, for visualizing the relationships between your sheets. It is also possible to adjust the zoom level when using the view, to focus on individual elements in your document. FREE ACCESS
• 3.  Importing your database in Excel 2016 for Windows
  4m 19s
  If you have already created a database in Access, you can import your data tables into Excel 2016 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
• 4.  Creating Power Pivot relationships in Excel 2016 for Windows
  4m 36s
  If you want to use Power Pivot to combine and analyze data from multiple data sources in Excel 2016, 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
• 5.  Customizing your Power Pivot tables in Excel 2016 for Windows
  4m 31s
  Your Power Pivot database tables in Excel 2016 contain fields, which are organized into columns, rows, and values. It is important to know how to manage and format these columns. FREE ACCESS
• 6.  Applying data formats in Power Pivot tables in Excel 2016 for Windows
  3m 54s
  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 2016, adjusting the format can help you to ensure that your data is readable and correctly presented. FREE ACCESS
• 7.  Sorting the data in your Power Pivot table in Excel 2016 for Windows
  2m 50s
  Sorting your data in your Power Pivot view is a very good way of uncovering new patterns and analyzing your data. Like in Excel 2016, you can sort your data via the Home tab or by using the column headers. FREE ACCESS
• 8.  Filtering data in your Power Pivot table in Excel 2016 for Windows
  4m 58s
  The filter tools in Excel 2016 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
• 9.  Creating a calculated field in your Power Pivot table in Excel 2016 for Windows
  2m 50s
  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
• 10.  Creating custom views in your Power Pivot table in Excel 2016 for Windows
  4m 29s
  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
• 11.  Updating your Power Pivot tables in Excel 2016 for Windows
  3m 25s
  If Power Pivot uses data contained in a linked or original Excel 2016 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
• 12.  Creating an advanced PivotTable in Excel 2016 for Windows
  4m 21s
  The Power Pivot add-in in Excel 2016 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
• 13.  Creating an advanced PivotChart in Excel 2016 for Windows
  5m 15s
  The Power Pivot add-in in Excel 2016 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
• 14.  Creating a dashboard in Excel 2016 for Windows
  6m 9s
  You can use Power Pivot to create a dashboard in your Excel 2016 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