In this Intermediate Microsoft Excel tutorial, I will show you how to use Power Pivot in Microsoft Excel. In this tutorial, we'll cover the basics of Power Pivot, a powerful data analysis tool built into Microsoft Excel. We'll start with an overview of Power Pivot and its benefits, then move on to practical steps for importing and organizing data. From there, we'll cover how to create relationships between tables and use advanced calculations to manipulate and analyze your data. Finally, we'll demonstrate how to create interactive PivotTables and PivotCharts that allow you to visualize your data in powerful new ways.

Whether you're a data analyst, business owner, or just looking to improve your Excel skills, Power Pivot can help you streamline your data analysis and gain deeper insights into your information. With this beginner's guide, you'll have everything you need to get started with Power Pivot and take your data analysis to the next level.

Don't forget to like and subscribe for more Excel tutorials, and let us know in the comments if there are any other topics you'd like us to cover!

Student and School practice: https://bit.ly/Student_School_Practice_Files
Tuition Fees practice: https://bit.ly/TuitionFees_Practice_File

0:00 Introduction to Power Pivot
1:43 How to install Power Pivot in Excel
2:51 Ways to bring data into Power Pivot
9:08 How to create relationships in Power Pivot (Diagram View)
14:46 How to create column calculation in Power Pivot
20:44 Different ways to add Measure in Power Pivot (more calculations)
28:02 Build a report with a Pivot Table in Power Pivot
32:20 Add a KPI (Key Performance Indicator) to your Pivot Table
34:49 Create a Pivot Chart with your data model

Intermediate Lesson 1 (Pivot Tables and Functions): https://youtu.be/PqczHnsNFdM
Intermediate Lesson 2 (Power Query): https://youtu.be/MHIV0bYryiw