How to use Power Pivot in Excel | Full Tutorial
Вставка
- Опубліковано 30 тра 2024
- 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 UA-cam channel
ua-cam.com/users/kevlers?...
🎬 Want to watch again? Navigate back to my UA-cam 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 - Наука та технологія
🏫 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: ua-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
Hellooo Kevin. Please can you do a tutorial on kinemaster video editing
Could you please share the lessons sheet in the comment? Thank you so much, sir.
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.
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!
Excellent and easy to follow tutorial on Power Pivot! Thanks Kevin for sharing your knowledge to enrich us! 😊👍
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 :)
Amazing tutorial. Thanks Kevin and hope to see more about measures and added columns.
Hi Kevin, Thanks a lot for this video. I learned more from this video than from any other tutorial I've watched to date.😃👋
What a great instructor you are - you make it so comprehensive!
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.
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!
Was waiting for the tutorial! Thank You!
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!!
Hi Kevin, Thanks for sharing this video with us and especially adding the files you use in the example. That is fantastic.
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!
Lol our teacher sent us this for our Data Model Unit
@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
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!!!!
Very informative with real-life examples! Makes it easy to use Power Pivot for a person who knows Excel. Thank you!
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 :)
Awesome tutorials! It's great seeing all the amazing things possible with Excel and other software.
An amazing introductory video to get a glance and understanding of Power Pivot!
Excellent, clear, comprehensive presentation.
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.
Great, short, precise and simplified presentation. Kudos!
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.
Woooooooow!!!!!!!!Amazing teaching, i have to practice 200 times to grasp it.
Hello Kevin,
I genuinely like the helpfulness of these videos. Thanks for the content and I wish you the best on ur ventures.
-AM
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.
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
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!
Thank you Kevin, always love all of your content!
The most useful intro to Power Pivot!! Thank you!
Excellent video Kevin, 👍 it is clear and concise, a great eye opener. Looking forward to the others. Thank you.
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.
Thoroughly enjoyed the instructional video.. Thank you for sharing.
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
ONCE AGAIN EXCEL-LENT TEACHER!
The video was extremely useful and easy to understand, and the pronunciation was also excellent.
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.
Beautiful video. Very efficient!!
Very fun intro. Thanks!
What a fantastic video! Absolutely AMAZING*****
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.
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!
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.
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!
Thanks for this brilliantly clear and helpful video. You've really done a great job explaining these concepts so well.😊
Wow - superb detail of Power Pivot thanks Kevin
Another amazing tutorial.Thank you very much Kevin.
Excellent video! Thank you!
Kevin this is an amasing video. Thank you so much
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
Hi Kevin, This is a super learning for me👍
Pretty cool. There are some functions here that give me enough capabilities that I might not need to venture into Access. Thanks!
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!
Great video, Thanks Kevin
this video is increasing my confidence in the use of excel, thanks
Thank you so much kevin for delivering so much knowledge through your videos 💌
Thank u so much !
Crisp and to point.
Nice. Such a powerful feature that I never knew about.
Here is south Korea!!! you're what a great teacher!!! Thanks you so~~~~ much!!! 🌼
I'm delighted and surprised. A coworker told me that Excel could incorporate simple data models and, honestly, I didn't believe them. You showed it. Thanks!
Excellent cadence in your presentation! So many tutorials are so slow they are boring or if they are fast they don't explain all the relevant pieces. Thanks for making the video!
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
This video deserves countless likes.
Thanks a lot for the upload. Please next video do it from large database such as Hyperion or SQLs
Kevin, thanks so much. I love all your videos; they are very detailed. Always helping me when I am indeed
Thank you! Quick summary, and a lot has been explained!
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!
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!
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
Wow!!😮
What a great tutorial, every detail is explained meticulously.
Very Useful Power Pivot Videos, Superb Good to continue the same.
You are a good teacher. I have been following your videos with great understanding. Thank you
Fabulous and fun explanation of how to do things in Excel. Really appreciate your videos!
Outstanding tutorial, thank you for making it easy to understand. Looking forward to learning more from you.
You made it look so easy with your amazing tutorial and sharing those sample data to work along was so helpful. Many thanks for your wonderful explanation. God Bless🙏
Fantastic ! Very helpful to start with PowerPivot ! Thank you !
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.
Hi Kevin, I'm from Indonesia, I love your video. Your explanation is so powerful, clear, and simple to understand. Thank you
Absolutely fantastic. I usually don't click on the like button but I break that rule for this video after 2 years
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....
Aboslutely loved this video, every minute was worthy to be watched
YOU SAVED ME!!!!!!!! I WAS ABOUT TO CRY
Very good introduction into power pivot. Thanks man!
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.
Same like Powerbi , didn't know it already existed in Excel , thumbs up to you Kevin 😊👍
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.
Great video. I learned so much in just 30 minutes!! Thank you
Love it, very interesting and engaging , and very nicely explained.
You are an excellent instructor.
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)
thanks Kevin, it's very insightful
Please do more on this topic! It was very insightful!! Thanks!!
Super Duper Amazing... all the solution I need which let me stuck for a long time was there.. Big love and thanks for this vid 🥰
Thanks a lot Kevin. Awesome video
Outstanding, Kevin! I never knew this functionality existed in Excel. This will definitely come in handy at work. Thanks!
thank you for getting straight to the point my guy
It is an awesome video. Very clear and easy to follow. Love it!