Using the Power Pivot Add-in

Excel 2016 (Windows)    |    Expert
  • 14 Videos | 1h 3m 26s
  • Includes Assessment
  • Earns a Badge
Likes 86 Likes 86
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

  • Playable
    1. 
    Activating Power Pivot
    2m 33s
    UP NEXT
  • Playable
    2. 
    Using the view settings in Power Pivot
    3m 47s
  • Locked
    3. 
    Importing your database
    4m 19s
  • Locked
    4. 
    Creating Power Pivot relationships
    4m 36s
  • Locked
    5. 
    Customizing your Power Pivot tables
    4m 31s
  • Locked
    6. 
    Applying data formats in Power Pivot tables
    3m 54s
  • Locked
    7. 
    Sorting the data in your Power Pivot table
    2m 50s
  • Locked
    8. 
    Filtering data in your Power Pivot table
    4m 58s
  • Locked
    9. 
    Creating a calculated field in your Power Pivot table
    2m 50s
  • Locked
    10. 
    Creating custom views in your Power Pivot table
    4m 29s
  • Locked
    11. 
    Updating your Power Pivot tables
    3m 25s
  • Locked
    12. 
    Creating an advanced PivotTable
    4m 21s
  • Locked
    13. 
    Creating an advanced PivotChart
    5m 15s
  • Locked
    14. 
    Creating a dashboard
    6m 9s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 282 Likes 282  
Likes 210 Likes 210  
Likes 229 Likes 229