Introduction to Power Pivot in excel. Understanding the excel data model relationships

This beginners power pivot tutorial looks at excel power pivot and the data model in excel. Power pivot is great as it helps speed up work in excel. Excel power pivot data model relationships are quick and easy to build. Then it is easy to insert you power pivot table, which helps you analyse multiple tables against each other. This introduction to power pivot covers one of my favourite excel tips and tricks. Excel data automation really helps you work more efficiently and power pivot is a powerful tool to speed up and automate your working in excel. Have you ever thought of using power pivot to link multiple tables? If not, watch this video and find out how! Overall, power pivot helps to speed up work in excel and for this tutorial advanced power pivot knowledge isn't needed, as it covers the basics!

0:00 Introduction
0:22 Enable the power pivot add-in
0:51 Enable the add-in via the developer tab
1:21 Building the data model (linking tables)
4:06 Load your power pivot table
5:16 Using measures to add a calculated column

Learn Excel online for free: Our Excel for beginners tutorial will teach you all you need to know to take you from zero to Excel hero!

What Microsoft Excel tips and tricks do you want to learn? Let me know for future videos! I'll continue to develop tutorials covering Excel basics for beginners and will build up a catalogue of free Microsoft Excel course materials! :-)

Or here are the links to individual videos; check them out!

[drippiemikk]

Thank you for making this! I have a test tomorrow and you helped me out tremendously! Wish I could make content like this, you had me hooked throughout the entire video! You got me jealous with the quality, therefore, I subscribed. Have a nice day, and keep putting out this great content!