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

Excel 2016 (Windows)    |    Expert
  • 14 videos | 57m 56s
  • Includes Assessment
  • Earns a Badge
Rating 4.4 of 117 users Rating 4.4 of 117 users (117)
You can create advanced PivotTables and analyze data from a variety of different sources using the Power Pivot add-in for Excel 2016. Learn how to use Power Pivot to import databases, create and modify tables, and create a dashboard.

WHAT YOU WILL LEARN

  • Activating power pivot
    Using the view settings in power pivot
    Importing your database
    Creating power pivot relationships
    Customizing your power pivot tables
    Applying data formats in power pivot tables
    Sorting the data in your power pivot table
  • Filtering data in your power pivot table
    Creating a calculated field in your power pivot table
    Creating custom views in your power pivot table
    Updating your power pivot tables
    Creating an advanced pivottable
    Creating an advanced pivotchart
    Creating a dashboard

IN THIS COURSE

  • 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
  • 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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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

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.7 of 3 users Rating 4.7 of 3 users (3)
Rating 4.5 of 1331 users Rating 4.5 of 1331 users (1331)
Rating 4.5 of 99 users Rating 4.5 of 99 users (99)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.4 of 438 users Rating 4.4 of 438 users (438)
Rating 4.5 of 2242 users Rating 4.5 of 2242 users (2242)
Rating 4.4 of 62 users Rating 4.4 of 62 users (62)