Excel: Introduction to PowerPivot
What you'll learn
- 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
Requirements
- A copy of Microsoft Excel is recommended.
Description
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.
Who this course is for:
- Microsoft Excel users looking to get more out of their Excel experience.
Course content
- Preview05:57
- Preview10:54
- 11:43Creating a Power Pivot Report
- 08:19Creating Calculations in Power Pivot
- 05:41Creating Key Performance Indicators
- 06:33Creating a Date Table
- 11:20Working with Dates and Time
Instructor
![Chip Reaves](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.4 Instructor Rating
- 19,463 Reviews
- 92,365 Students
- 90 Courses
Bigger Brains Founder and President Chip Reaves is a serial entrepreneur who has started five successful companies. An Atlanta native, Chip began fixing computers for small businesses in the 1980's while studying Computer Science at Georgia Tech. After 10 years building a successful IT Service Practice in Atlanta, Chip founded the Computer Troubleshooters franchise system alongside Wilson & Suzanne McOrist, which became the world's largest computer service franchise and received multiple awards from Entrepreneur Magazine, Franchise Business Review, and AllBusiness.
Chip has been interviewed on TV and other major media on topics related to small business technology and entrepreneurship, including ABC News, BusinessWeek TV, the Wall Street Journal, and the New York Times, and is a member of Jim Blasingame's "Brain Trust" on SmallBusinessAdvocate. In 2010 Chip was listed among the Top 150 most influential people in small business IT by SMB PC magazine.
Chip lives with his wife Maren and step-daughter Meg in Anderson, South Carolina where they also co-own a Computer Troubleshooters franchise location. In his spare time Chip is very active with his church and local charities, and consults with two aid organizations serving Rwanda and the Democratic Republic of Congo in Africa.