🏫 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: ruclips.net/p/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
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.
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
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.
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!
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!
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
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.
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
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!
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.
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!
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!
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
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.
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....
I think this might be a bit of an undersell, but this was absolutely LIFE CAHNGING! I am picturing all of the sheets that I have built without knowing this, and how I plan to fix them all.
You are a great teacher, i did not know how to create a macro, because i did not know how to find it, i was watching a video and they kept saying to create a macro but when look at top couldn't gind it, until you explained it. Thank you .
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!
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! 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.
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!
Bro, your explanation is too good and easy to understand, this makes me confident about Power Pivot if some one asks me to do some exercise in office Thank you so much for your video, this really helpful...
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!!!!
first time i have seen full video related to data analyst in English and enjoy it. Due to different accent I fount difficult to understand easily and I skip that but the way you explain I loved it.
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🙏
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.
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 :)
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.
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!
Your previous lectures Sir Kevin are mind boggling a bombardment of information Man it helped Im beginning to be interested in computers because there's analysis, I'm a healthcare worker/artist/ romantic. Thanks
Awesome vid, Kev! I've become a Power Pivot champion thanks to this walkthrough. Could never ever think such an advanced feature would be packed and ready to use inside Microsoft Excel!! Just 30 minutes of training got me hit the road running with Power Pivot.🏃♂ Thank you!
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!
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.
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.
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.
Thank you so much for these videos. I have been taking online courses about the world of data and these videos have helped me a lot especially now that I could coding from Python, R, SQL, and other programming languages. Being relatively new to data, I want to start my career as a data analyst and eventually work my way up just like everyone else. Again, thank you for teaching these videos that we can use to practice our skills. You are the best!!!!!!!
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!
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!!
🏫 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: ruclips.net/p/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
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.
Where would we be without people like Kevin. So grateful☺
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
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.
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!
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
Woooooooow!!!!!!!!Amazing teaching, i have to practice 200 times to grasp it.
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
The video was extremely useful and easy to understand, and the pronunciation was also excellent.
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.
Hi Kevin, I'm from Indonesia, I love your video. Your explanation is so powerful, clear, and simple to understand. Thank you
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
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
this video is increasing my confidence in the use of excel, thanks
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!
This video deserves countless likes.
Thanks a lot for the upload. Please next video do it from large database such as Hyperion or SQLs
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😀
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!
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!
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
Absolutely fantastic. I usually don't click on the like button but I break that rule for this video after 2 years
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.
Excel to the next level. Very explanatory step by step tutorial Kevin, thank for sharing!
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.
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....
Here is south Korea!!! you're what a great teacher!!! Thanks you so~~~~ much!!! 🌼
I think this might be a bit of an undersell, but this was absolutely LIFE CAHNGING! I am picturing all of the sheets that I have built without knowing this, and how I plan to fix them all.
You are a great teacher, i did not know how to create a macro, because i did not know how to find it, i was watching a video and they kept saying to create a macro but when look at top couldn't gind it, until you explained it. Thank you .
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!
Really Now I can confidently say that i know what is Power Pivot. Greate Tutorial with example, Thank you
Pretty cool. There are some functions here that give me enough capabilities that I might not need to venture into Access. Thanks!
Sir Keven you are the leader, I learned from you a lot thank you so much.🧠👍👍👍👍
ONCE AGAIN EXCEL-LENT TEACHER!
An amazing introductory video to get a glance and understanding of Power Pivot!
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! 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.
Thank you very much for your tutorial; it has greatly improved my understanding of how to combine data sheets in Microsoft Power Pivot
You are awesome person who explain the concept of power pivot in this particular video in great detail. Cheers from India
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!
Beautiful to the point precise explanation. I already feel confident about power pivots after watching this video. Thank you. 😀😀😀😀😀.
Bro, your explanation is too good and easy to understand, this makes me confident about Power Pivot if some one asks me to do some exercise in office
Thank you so much for your video, this really helpful...
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, clear, comprehensive presentation.
first time i have seen full video related to data analyst in English and enjoy it. Due to different accent I fount difficult to understand easily and I skip that but the way you explain I loved it.
You are a good teacher. I have been following your videos with great understanding. Thank you
Wow!!😮
What a great tutorial, every detail is explained meticulously.
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🙏
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 is great Kevin, thank for the tutorial
Great, short, precise and simplified presentation. Kudos!
You method of teaching is superb,learning is fun with you.Thanks for sharing your great content
Just love your teaching Kevin. Its so simple to follow along. Many thanks
Same like Powerbi , didn't know it already existed in Excel , thumbs up to you Kevin 😊👍
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 :)
Great video. I learned so much in just 30 minutes!! Thank you
Your intrustion helps me a lot. Thank you so much for the detailed video.
Awesome video tutorial and very clear, easy to follow step-by step. I've watched other videos but I fully understood it after watching this tutorial.
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.
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!
The most useful intro to Power Pivot!! Thank you!
This tutorial will persuade me to appreciate Excel more.
Very informative with real-life examples! Makes it easy to use Power Pivot for a person who knows Excel. Thank you!
Thank you for your sharing.i managed to follow through the whole tutorial step by step.Many thanks for your teaching.TQ...
thank you for getting straight to the point my guy
Your previous lectures Sir Kevin are mind boggling a bombardment of information Man it helped Im beginning to be interested in computers because there's analysis, I'm a healthcare worker/artist/ romantic. Thanks
Awesome vid, Kev! I've become a Power Pivot champion thanks to this walkthrough. Could never ever think such an advanced feature would be packed and ready to use inside Microsoft Excel!! Just 30 minutes of training got me hit the road running with Power Pivot.🏃♂ Thank you!
Aboslutely loved this video, every minute was worthy to be watched
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!
Kevin you smile makes my day !! ......Good Teacher you are..... 😄😄
😁
Great video. 30 mins video I learned power Pivot.
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.
Thank you so much kevin for delivering so much knowledge through your videos 💌
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.
Please discuss more advanced power pivot options. You are incredible ❣️. Lots of love and thanks to you
Please do more on this topic! It was very insightful!! Thanks!!
Explained very well and easy to follow. Thank you!
You are an excellent instructor.
YOU SAVED ME!!!!!!!! I WAS ABOUT TO CRY
Excellent introduction to Power query. It gives nice peek to the power of power query.
Awesome! Thanks alot for this tutorial. It is so comprehensive and simple to understand.
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.
The sample files would be of great help for practice. Thanks a lot Kevin
Thank you so much for these videos. I have been taking online courses about the world of data and these videos have helped me a lot especially now that I could coding from Python, R, SQL, and other programming languages. Being relatively new to data, I want to start my career as a data analyst and eventually work my way up just like everyone else. Again, thank you for teaching these videos that we can use to practice our skills. You are the best!!!!!!!
Hi Aliconteh,
I hope you landed a data analyst job.
Outstanding tutorial, thank you for making it easy to understand. Looking forward to learning more from you.
Short and simple thank you for creating this video.
Thank you one more time! You are one of the best at explanations!
Hi Kevin, I enjoy your lesson of Power Pivot Table, thank you.👍👍👍
Kevin, you are amazing and your presentation is superb!
Thank you very much, I was able to learn all I needed with this one video. You are definitely the best!
Thanks Kevin for this great video. Now I am able to teach PowerPoint in my next excel course.
Kevin, thanks so much. I love all your videos; they are very detailed. Always helping me when I am indeed
Thank you for making this so much easier to understand.
Kevin, thank you so much for sharing your knowledge ! Love your channel. Greetings from France !! 😁🤙🏾🤙🏾
The presentation was very good and information and simple. Thank you.
Nice. Such a powerful feature that I never knew about.
This is an amazing video. You always make grade A videos. Thumbs up!
Thanks, this was so helpful for me! I hadn't worked with PP in awhile and just needed a quick, straightforward refresher. Perfect. :)
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!
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!!