How to use Power Pivot - Microsoft Excel Tutorial
Вставка
- Опубліковано 30 лип 2024
- 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...
the videos are very use full and recommended to see in a serial order to pick up the skills in excel.
Thanks for generously providing your practice tables.
Many thanks for your patience and covering almost everything. Bravo
My pleasure!
Sir-you’re a genus! I am going to try using this to customise the daily work assignments I get
I love the way you teach excel. I bought an online excel course and it's very descriptive with little practical presentation session at the end of the course. Mostly that make me asleep. But it's great, the way you do it with actual live presentation on the screen :)
Thanks for such a great content. Well explain !!
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.
Glad you found it helpful!
@@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
Thank you so much , you are a great teacher .
Thank you, excellent presentation
one of the best video..very simple and easy to understand... fall in love with your videos...thanks and gratitude
You’re welcome and thank you!
This was so helpful! You are a great teacher. Thanks so much for doing this.
You are so welcome!
Thank you.
I love this video
Thank you so much
This lesson really useful, thanks for sharing. 👍
Benar, ini materi yang sangat bermanfaat
Thanks for simple File
thanks for knowledge
thank you very much
tnx teacher 🥰
Very professional and useful channel. you teach much better than my college professor 🤭
hi first well done thanks a lot, i watch your videos since 2019, you helped me create my channel art thanks !
You’re welcome!
thank you very much sir
Thank you so much 💙
You're welcome 😊
you are a great teacher!! if any more power pivot videos plz send yiur link...🥰
Thank you
Thank you!
You're welcome!
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.
Thank you for your great videos. Is it possible to talk about forecasting and VBA scripting in Excel
?
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?
Very good teaching 😃
Thank you! 😃
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
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
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!
You’re welcome!
I will try to use this formula. Thank you.
Is this video enough for power pivot??
Should the Tuition table to Student table be 1 to 1? Thanks
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..
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!!!!!
I'm not able to use Power Pivot in Excel web version. :(
👍
Sorry to ask here but do you have any video on how to convert good old music CDs to mp3 format?
Hello, unfortunately I don't
Hi. Unfortunately, Power Pivot is not available on Mac =(
It is unfortunate. Such a great add-in
How to with databases
przydatny filmik. Szkoda że po angielsku.
Great tutorial. Thank you
Please can you share your LinkedIn username?
Keep up the awesome work!! You need to research 'promosm'.
Thank you very much teacher tech. But my excel doesn't have pivot. What do I do.