How to use Power Pivot in Excel | Full Tutorial
Ғылым және технология
In this step-by-step tutorial, learn how to use Power Pivot in Microsoft Excel. Power Pivot is a data modeling technology that lets you create data models, establish relationships, and create calculations. With Power Pivot you can work with large data sets, build extensive relationships, and create complex (or simple) calculations, all in a high-performance environment, and all within the familiar experience of Excel.
👋 Additional resources:
- Sample files to follow along: 1drv.ms/u/s!AmxrofZZlZ-whK1Sw...
- In-depth Pivot Table tutorial: • Pivot Table Excel Tuto...
- Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
⌚ Timestamps
0:00 Introduction
1:23 Enable Power Pivot add-in
3:05 Sample files overview
4:06 Create data model
8:55 Define relationships
12:13 Calculations
16:02 Measures
21:24 Insert PivotTable from data model
24:49 Key Performance Indicators (KPIs)
27:06 Insert PivotChart
28:16 Slicers
29:34 Wrap up
📃 Watch related playlists and videos
- Playlist with all my videos on Excel: • ❎ How to use Excel
🚩 Connect with me on social:
- LinkedIn: / kevinstratvert
- Discord: / discord
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
- TikTok: / kevinstratvert
- Instagram: / kevinstratvert
🔔 Subscribe to my KZread channel
kzread.info?...
🎬 Want to watch again? Navigate back to my KZread channel quickly
www.kevinstratvert.com
🛍 Support me with your Amazon purchases: amzn.to/3kCP2yz
⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.
#stratvert
Пікірлер: 727
🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: kzread.info/head/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
@nkuidjoufabien4555
3 жыл бұрын
Hellooo Kevin. Please can you do a tutorial on kinemaster video editing
@naytun4276
2 жыл бұрын
Could you please share the lessons sheet in the comment? Thank you so much, sir.
@jhotiozon1010
2 жыл бұрын
Hi Kevin! I'm from Philippines and I would like to thank you because I'm learning a lot from you. My new work requires me to learn more of Google Workspace and Microsoft Apps and Im using your videos as one of my reference. I wanna learn more of Excel Formulas and maybe PowerPoint for reporting & presentation purposes.
Add a couple more tables and you can work out how much tax you'll be paying on your $2.7M profits! 😉 Great video. Loved how you took it all the way from data to report. So much work goes on behind the scenes e.g. creating that data. Your efforts are appreciated, Kevin. Brilliant.
@ubaidhanif5886
6 ай бұрын
Too Funny😀
This was a super helpful presentation! Thank you so much for breaking this down so clearly and simply! I can already see how I'll be using this going forward!
Excel to the next level. Very explanatory step by step tutorial Kevin, thank for sharing!
Thank you Kevin. I never heard of Power Pivot before but now explained it practically and in a clear understanding. Waiting for the future videos like this. Hats off Kevin :)
Excellent and easy to follow tutorial on Power Pivot! Thanks Kevin for sharing your knowledge to enrich us! 😊👍
Your videos pacing and explanations are so crisp. (Concise and clear) Honestly these deserve even more views as how excellent the setup is. So direct to the point and easy to follow. Very very helpful. My thanks again!
Great video as always. My feedback to enrich the experience would be to provide 2 sample data sets with written instruction steps on their own regarding the second data set. This way, when we're following along, we do the first data set by visually following your steps. Next, we practically apply our newly learn't knowledge in a semi-supervised (stand alone instruction steps) format, allowing us to build muscle memory without going from the shallow end (supervised) right into the deep end (unsupervised). Thank you Kev :)
Amazing tutorial. Thanks Kevin and hope to see more about measures and added columns.
Simply WOW!! I have been using pivot tables and there is a way to link various pivot tables....but PowerPivot is something extraordinary, thanks for sharing this tool with so much of ease. Keep up the good work you have been doing!!
30 minutes of cookie talk is making me hungry. It's also making me want Kevin Cookie Company merch. This tutorial is really helpful. It seems much more intuitive than Access to me, as I've been using Excel for 20+ years, but I'm mainly self-taught. I can see where Power Pivot will be very useful to me with QuickBooks reports that NEVER connect all the elements I need to see in one report. by importing those reports into Excel and then connecting the tables, this should save me a LOT of the manual data entry I've always had to do. I really appreciate this video!!! Thanks Kevin! And think about that KCC merch!
ONCE AGAIN EXCEL-LENT TEACHER!
Hi Kevin, Thanks a lot for this video. I learned more from this video than from any other tutorial I've watched to date.😃👋
Thanks--very helpful and very well organized, and perfect for someone like me who is strong at Excel and regular pivot tables but found the whole UI for Power Pivot very opaque. I tried listening to three other folk's tutorials and did not get the hang of Power Pivot until coming across your great 30 minute tutorial here! Great job.
I rarely commented on social media, but I would like to show my appreciation. I really like that you have provided sample files so we can follow them. Thank you for sharing your knowledge.
Hi Kevin, Thanks for sharing this video with us and especially adding the files you use in the example. That is fantastic.
Very good content. Thanks for breaking down complex BI into individual steps. If you're taking requests, I'd very much like 1-2 min programmatic background for each of the concepts (ex: why relational, what flow order we need to follow if editing in XML, what's linking your relationships and how to tweak them)
Was waiting for the tutorial! Thank You!
What a great instructor you are - you make it so comprehensive!
Awesome tutorials! It's great seeing all the amazing things possible with Excel and other software.
Thanks could be useful. I’m used to performing all the data relationships & queries in Access, then pulling results into Excel for analysis. I’ve also learned BI, which does everything for you but has its own drawbacks. So this is something else I’ll have to pick up. Excellent presentation, very clear & understandable!
An amazing introductory video to get a glance and understanding of Power Pivot!
Amazing video. Never heard of this but now I now. This is a great tutorial. Thanx for uploading. 4:04 I love that part where you said "It takes a lot of love to make these delicious cookies.
Just love your teaching Kevin. Its so simple to follow along. Many thanks
You're a better teacher than some of my professors! You make learning easy and fun! I love watching your videos and thank you for sharing the data sample sets!
@prestonfernandes2071
Жыл бұрын
Lol our teacher sent us this for our Data Model Unit
@ramonmeza4209
Жыл бұрын
@Jay M oh wow I never thought of that! Lol getting my masters in data science fam and wanted to give a compliment. Please escort that negativity out
Kevin - that was one unbelievably awesome video. thank you. forever grateful for your help
Very informative with real-life examples! Makes it easy to use Power Pivot for a person who knows Excel. Thank you!
Pretty cool. There are some functions here that give me enough capabilities that I might not need to venture into Access. Thanks!
Thank you Kevin, always love all of your content!
Hello Kevin, I genuinely like the helpfulness of these videos. Thanks for the content and I wish you the best on ur ventures. -AM
Thanks so much for making these type of videos. They are so well structured and detailed that it is impossible to get lost! I am so happy that I found you!!!!
Excellent video Kevin, 👍 it is clear and concise, a great eye opener. Looking forward to the others. Thank you.
Great tutorial...Thanks a bunch, Kevin!
Absolutely awesome video! Quick and gets to the point and the benefits. Seriously this is upping my Excel game tremendously. Thank you! Subscribed.
Thoroughly enjoyed the instructional video.. Thank you for sharing.
I've been trying to get around to learning and actually using Power Pivot, and this is great tutorial for the basics. The only issue I have with examples like this is that it's good for theory, but not for practical use. In the real world, each order would have to be frozen in time, in effect. The costs in the product table might apply to a few orders when the invoices were created, but costs and selling prices change all the time. Same with customer address info. Each order when it's complete would have to have all the information saved in static tables with costs, selling prices, and customer data as permanent info attached to that table, since you could never rely again on the product table as a source of accurate info for that particular invoice. Still, this is good for learning how table relationships work and how data models are created.
Absolutely fantastic. I usually don't click on the like button but I break that rule for this video after 2 years
Awesome video! I just watched a different beginner tutorial on PowerPivot and despite covering similar material, it wasn't nearly as clear and concise as this video. Thank you for all of your great content!
this video is increasing my confidence in the use of excel, thanks
The most useful intro to Power Pivot!! Thank you!
Thank u so much ! Crisp and to point.
Another excellent walk through, thank you Kevin.! I’m a complete novice but with your guidance I’m creating some excellent data models and dashboards. Thanks again!👍
Kevin, you are good. What I like the best is the pace you describe things and the way you speak each word. Not like peep vloggers that speak fast and too much. Thanks and Keep it UP
This is indeed a great presentation with powerfully packed knowledge. I really found this quite helpful in developing my skills in data analysis using MS Excel.
Wow! I am amazed by your work and teaching skills. I have learned so much from watching your videos and following along. I am currently trying to figure out how to automate cash reconciliation at my work and watching your videos gets me closer and closer every day. Thank you Kevin, and good job Kevin's Cookies!
Very, very good. Now that I have seen one of your Excel training videos and loved it, I will not only be referring back to it, but plan to seek out any additional videos you have on YT. Thank you. Yes, I clicked subscribe and like.
This video deserves countless likes. Thanks a lot for the upload. Please next video do it from large database such as Hyperion or SQLs
Great, short, precise and simplified presentation. Kudos!
For some1 that has tried this for the first term, creating docs on the fly to follow along with you , learn and enjoy that was pretty much perfect ... i like the fact that you didnt waste anytime and everything was exactly what was needed from start to finish
Excellent video! Thank you so much! The time stamps are great for when I need to go back and rewatch a video to resolve a specific problem.
Excellent training material. Power pivot is totally new for me. Even then, I need no more video/training material to practice power pivot after watching this video. Thanks a lot.
Another amazing tutorial.Thank you very much Kevin.
Excellent. Thanks for a detailed explanation. I did do the same steps on parallel screens and thoroughly understood. Will put in use in my work ASAP.
Thanks for this brilliantly clear and helpful video. You've really done a great job explaining these concepts so well.😊
Thank you! Quick summary, and a lot has been explained!
The video was extremely useful and easy to understand, and the pronunciation was also excellent.
I cannot thank you more for this helpful tutroial. What is amazing with your way of teaching is that you start from scratch. It is impossible not to understand
This is a game changer. SO EXCITED to learn this. Bam. Does exactly what I need saving a TON of time - my datasets have 8+ million records. Thank you so much!
Woooooooow!!!!!!!!Amazing teaching, i have to practice 200 times to grasp it.
Didn't want to spend time to go through my professors two hour long video to find what I was looking for. Huge thank you for this video, it helped a lot and I only had to spend couple of minutes to get the information I needed!
Wow! I don't know if you saw my comment on the access video where I was basically pining about wanting relationships like access in excel, but you basically solved all of my wants with this video. I will use this a lot.
Today learned power pivot. It helped me a lot to visualize my data and connecting them through different worksheet. Thanks a lot buddy. You are truly amazing.
Wow - superb detail of Power Pivot thanks Kevin
thank you for the lecture. i did not know about Prpivot until NOW. i like it because you take us right to the point, not hit around the bush. definitely will have to see your other lecture relating to this subject
I can't really thank you enough for this video! I'm a huge "Power Excel" fan and to this day I would still rather work my data in Power Pivot than in Power BI. It would need a revamp from Microsoft, but I guess this would get in the way of selling Power BI as the only viable BI solution out there 😉 This is one beautiful beginner tutorial, you're a great communicator!
Kevin, thanks so much. I love all your videos; they are very detailed. Always helping me when I am indeed
Fantastic ! Very helpful to start with PowerPivot ! Thank you !
Amazing! I always import data from Excel to Access to do such things. You made my life easier. Thank you ☺️
Hey Kevin, you rock! Thank you so much for everything!
EXCELLENT WORKS, KEVIN, THANKS SO MUCH FOR YOUR SHARING!
Excellent Guide! Thank you Kevin.
Kevin this is an amasing video. Thank you so much
Beautiful video. Very efficient!!
Amazing training video. Very compact, useful, and easy to understand. Thank you
Thank you so much kevin for delivering so much knowledge through your videos 💌
Fabulous and fun explanation of how to do things in Excel. Really appreciate your videos!
THANK YOU!!!! Great explanation! It helped me a lot. You make it look so easy.
Great Stuff and easy to comprehend. Tons of respect and gratitude, Kevin
Thank you Kevin for your simple tutorial on power pivot and make it so easy for a beginner like me for first time I ever make comment on youtube. you deserve big cookies....
you are my excel guru everytime i want to learn something i always look up to you kevin thanks for making such great and easy to understand videos
A tremendous video. Thank you very much, Kevin!
Very fun intro. Thanks!
Super clear!! Thank you Kevin!! 🔥
Outstanding tutorial, thank you for making it easy to understand. Looking forward to learning more from you.
Really great video. You explained it so well as always. I've learned a lot from your channel. Thanks for sharing
It is an awesome video. Very clear and easy to follow. Love it!
Nice. Such a powerful feature that I never knew about.
Loved your video Kevin, terrific, thanks for sharing.
Thanks, this was so helpful for me! I hadn't worked with PP in awhile and just needed a quick, straightforward refresher. Perfect. :)
Very good introduction into power pivot. Thanks man!
Thank you a lot! It is really enjoy learn pivot and query with you and your example files doing the same thing that you're doing!
I’m your newest fan. Your instruction and approach to teaching is awesome. Instead of watching movies during Covid, I’m hooked to your instructional videos. They are so informative and I’ve learned lots of tricks to enhance my productivity. I need to take 12-step program to ween myself away from tour addictive videos 😀. You are the best and thank you for sharing. Your greatest fan
Outstanding, Kevin! I never knew this functionality existed in Excel. This will definitely come in handy at work. Thanks!
Awesome information delivered about the PIVOT TABLE.
Excellent, clear, comprehensive presentation.
Thank you Kevin. This is super helpful. Much appreciate
Awesome! Thanks alot for this tutorial. It is so comprehensive and simple to understand.
Same like Powerbi , didn't know it already existed in Excel , thumbs up to you Kevin 😊👍
Thank you, thank you , thank you! This was very helpful!
Hi Kevin, I'm from Indonesia, I love your video. Your explanation is so powerful, clear, and simple to understand. Thank you