Using the Power Pivot Add-in in Excel 2016 for Windows
Excel 2016 (Windows)
| Expert
- 14 videos | 57m 56s
- Includes Assessment
- Earns a Badge
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 33sPower 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 47sThere 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 Windows4m 19sIf 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 Windows4m 36sIf 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 Windows4m 31sYour 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 Windows3m 54sThe 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 Windows2m 50sSorting 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 Windows4m 58sThe 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 Windows2m 50sA 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 Windows4m 29sPower 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 Windows3m 25sIf 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 Windows4m 21sThe 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 Windows5m 15sThe 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 Windows6m 9sYou 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.
