When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Data Analysis with Microsoft Excel Power Pivot- A Beginners Manual
Unlock creativity with Skillshare! Learn acrylic painting, AI writing, graphic design, and photography.
Free
This Course Includes
skillshare
0 (0 reviews )
1 hours 21 minutes 
english
Online - Self Paced
course
SkillShare
About Data Analysis with Microsoft Excel Power Pivot- A Beginners Manual
Lesson 1 Introduction
Lesson 2 Introduction to Pivot Tables
Lesson 3 Formatting Pivot Table
Lesson 4 Filters and Slicers
Lesson 5 GETPIVOTDATA
Lesson 6 Pivot Charts
Lesson 7 Why PowerPivot?
Lesson 8 Powerpivot Addin
Lesson 9 Data Models
Lesson 10 Pivot Table with Powerpivot
Lesson 11 Calculated Fields and KPI Skillshare
What You Will Learn?
- Power Pivot is an Excel add-in which can be used to perform powerful data analysis and create sophisticated data models. It can handle large volumes of data (millions of rows) from various sources and all of this within a single Excel file. .
- Introduced by Microsoft in Excel 2010 and 2013, and is now a native feature for Excel 2016 and 365. As Microsoft explains, Power Pivot for Excel “enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables and PivotCharts, and then further analyze the data so that you can make timely business decisions without requiring IT assistance..
- The course starts with a brief Introduction to Pivot Tables and gradually moves towards Power Pivots, its use and benefits, How to activate the Powerpivot Add in , create data Models, Building Relationships and then gives you a feel of where Power Pivot fits in when using Excel for data analysis or visualization..