How to use Power Pivot - Microsoft Excel Tutorial

Рет қаралды 57,411

Күн бұрын

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: bit.ly/Student_School_Practic...
Tuition Fees practice: 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): • Intermediate Microsoft...
Intermediate Lesson 2 (Power Query): • How to use Power Query...

Пікірлер: 56

@StopWhining491 Жыл бұрын

Thanks for generously providing your practice tables.

@Frederick7419 9 ай бұрын

Many thanks for your patience and covering almost everything. Bravo

@TeachersTech 9 ай бұрын

My pleasure!

@jawaharlalkaramchetti5675 5 ай бұрын

the videos are very use full and recommended to see in a serial order to pick up the skills in excel.

@wolfcub1870 Ай бұрын

Sir-you’re a genus! I am going to try using this to customise the daily work assignments I get

@shivtiwary5103 8 ай бұрын

Thanks for such a great content. Well explain !!

@ibugurudyah Жыл бұрын

I just found this content and it's very good for the subject matter, I'm a high school teacher of office skills competency. Thank you for the lessons given.

@TeachersTech Жыл бұрын

Glad you found it helpful!

@ibugurudyah Жыл бұрын

@@TeachersTech I am Indonesian, I use subtitles to understand the use of language in this video, but even so I can understand what is meant in the video

@required. 5 ай бұрын

Thank you so much , you are a great teacher .

@Excelvenky Жыл бұрын

one of the best video..very simple and easy to understand... fall in love with your videos...thanks and gratitude

@TeachersTech Жыл бұрын

You’re welcome and thank you!

@bettyvendig6179 7 ай бұрын

This was so helpful! You are a great teacher. Thanks so much for doing this.

@TeachersTech 7 ай бұрын

You are so welcome!

@tahirhanif9669 8 ай бұрын

Thank you, excellent presentation

@HamdanYouTuber Жыл бұрын

This lesson really useful, thanks for sharing. 👍

@ibugurudyah Жыл бұрын

Benar, ini materi yang sangat bermanfaat

@jingyu3891 Жыл бұрын

I love this video

@YTGamerboyPG3D Жыл бұрын

hi first well done thanks a lot, i watch your videos since 2019, you helped me create my channel art thanks !

@TeachersTech Жыл бұрын

You’re welcome!

@ramin31tube Жыл бұрын

Very professional and useful channel. you teach much better than my college professor 🤭

@ademuyiwamopelade4179 Жыл бұрын

Thank you so much

@hammadhago Жыл бұрын

Thank you so much 💙

@TeachersTech Жыл бұрын

You're welcome 😊

@roberth.9558 Жыл бұрын

Thank you.

@sumardjo 25 күн бұрын

Thanks for simple File thanks for knowledge thank you very much

@Mahendarreddy-wrkyt 24 күн бұрын

thank you very much sir

@tanweerabbasabbas649 9 ай бұрын

you are a great teacher!! if any more power pivot videos plz send yiur link...🥰

@Excellearn_ir Жыл бұрын

tnx teacher 🥰

@trstreet61 2 ай бұрын

Thank you!

@TeachersTech 2 ай бұрын

You're welcome!

@asana.mardanloo3024 5 ай бұрын

Thank you for your great videos. Is it possible to talk about forecasting and VBA scripting in Excel ?

@surendrababu9184 3 ай бұрын

Very good teaching 😃

@TeachersTech 3 ай бұрын

Thank you! 😃

@maribelcarlos5302 2 ай бұрын

I find your tutorials very helpful and I was able to re-create it on my own. My concern now is using the files from my OneDrive. I works well on my laptop. But when I login to another device, it is looking for the Onedrive files saved in my laptop. What should I do then. Thanks in advance

@rw3486 5 ай бұрын

Thanks. This is useful. Can you provide an example that uses Power Query to get and clean multiple files, some of which have more than 1 million rows, then use PowerPivot to create the model (linking the files or tables), then create a Pivot chart. I think you can create a "connection only" for the large file(s), should you do that in Power Query or Power Pivot? Maybe you have to do it in power query? But Power Pivot seems to advertise that as a feature. Could you do it without Power Query? Or does "cleaning" the data require Power Query.

@AyushiRai-oo1wh Жыл бұрын

Very insightful. Thank you for creating this tutorial. A doubt. I used formula =RELATED(Tution[Total Amount]) - 'Student Info'[Payment Received] to calculate Amount Owing in Student Info table. On calculation, if 'Student Info'[Payment Received] > Tution[Total Amount], valuse should be a negative integer. Why it shows as a positive integer?

@fliptop157 Жыл бұрын

My take away is on the Table Relationships. Separate related tables can have the same Primary Key (as "Student ID"), as long as it's unique to the respective Table (as in your "Grades" Table). Even though "Student ID" is the primary key in your Student ID Table. I used to think each Table required it's own unique key but I see now it only requires a unique key. -Thanks!

@TeachersTech Жыл бұрын

You’re welcome!

@ibugurudyah Жыл бұрын

I will try to use this formula. Thank you.

@vishalnadekar694 10 ай бұрын

Is this video enough for power pivot??

@sqlservertutorialin3minute485 3 ай бұрын

Should the Tuition table to Student table be 1 to 1? Thanks

@josepheboba8821 2 ай бұрын

👍

@PizzzzzzaPie1018 Жыл бұрын

Hey Jamie - I will have to start watching all your videos to help myself learn. In the meantime, I was left this horrendous spreadsheet by a former co-worker that I have come to figure out fairly well. However, this spreadsheet looks up values based on current year and another year related to the client. For the life of me, I cannot get it to work since she left it was before 2020 and how she has it calculating is based on 1900 years. (I am probably not making sense). I am an absolute novice at Excel and I was wondering if I could somehow get your personal help? Is that something you do? I have tried everything to make these calculations work and I figured it out on some but not on this one particular one. I would be SO VERY GRATEFUL!!!!!

@nmekadaniel8804 Жыл бұрын

I have be trying to import your practice data so I can play with it but I can’t,on my system I use to select import from other source then I will select web.shouldn’t I be selecting web? am cut up please anyone should help out I will appreciate

@fluffyhoneytina 9 ай бұрын

I have always had problems creating relationships and it never works for me..I end up using get data and merging. I wish I could use power pivot but I am dumb..