Discounts for 3+ Users
Do you need more information about group pricing for our training courses?
ANY SIZE/ANY INDUSTRY (Businesses, Non-Profits, Academic Institutions)
Excel: Intro to Power Pivot
Organizing A Lot of Data? This is The Power Tool You Need
Teacher : Barbara Evers Learner : Kayla Chase
Learn How To Transform Excel Into Your Big Data Power Tool
Power Pivot is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily.
In this course we’ll show you everything you need to know in order to install and start using Power Pivot in Excel. We strongly recommend you take our “Mastering Excel” courses before you proceed with Power Pivot, unless you are already comfortable with advanced Excel topics including basic PivotTables.
Objectives – You will be able to:
- Enable the Power Pivot add-in and navigate its interface
- Manage Data Relationships
- Create a Power Pivot Report
- Create calculations in Power Pivot
- Create a Key Performance Indicator
- Work with dates and time in Power Pivot
Quickly Search For And Find The Skills You Want To Master– Then Just Point, Click, And Learn
Over 60 minutes of high quality HD content in the “Uniquely Engaging” TM Bigger Brains Teacher/Learner style!
What You'll Learn
01: Enable and Navigate Power Pivot (5:57)
02: Managing Data Relationships (10:54)
03: Creating a Power Pivot Report (11:43)
04: Creating Calculations in Power Pivot (8:19)
05: Creating Key Performance Indicators (5:41)
06: Creating a Date Table (6:33)
07: Working with Dates and Time (11:20)
This course is included in the Bigger-Brains online subscription for individuals or organizations, or can be purchased in SCORM format for use in your own LMS (Learning Management System)
Also available from these partners:
Lessons : 7
Seat Time : 60 Minutes
Versions Available : Standard HD SCORM, MP4, reseller HTML, Vimeo embed
Produced by : Bigger Brains
Sample Course Video