The Power Pivot Add-in in Excel 2013 for Windows

Excel 2013 (Windows)    |    Expert
  • 13 videos | 1h 5m 1s
  • Earns a Badge
Rating 4.6 of 38 users Rating 4.6 of 38 users (38)
Power Pivot allows you to create advanced PivotTables and PivotCharts in Excel 2013. Discover how to work with Power Pivot, so you can analyze data from a variety of sources.

WHAT YOU WILL LEARN

  • Activating power pivot
    Importing your database
    Creating power pivot relationships
    Formatting 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

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

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.5 of 1331 users Rating 4.5 of 1331 users (1331)
Journey Microsoft Excel
Rating 2.7 of 3 users Rating 2.7 of 3 users (3)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.4 of 330 users Rating 4.4 of 330 users (330)
Rating 4.4 of 438 users Rating 4.4 of 438 users (438)