Ultimate Excel PivotTables Tutorial: Beginner to Advanced - 3.5 Hours!

  Рет қаралды 448,456

Simon Sez IT

Simon Sez IT

Күн бұрын

Пікірлер: 97
@SimonSezIT
@SimonSezIT Жыл бұрын
We have additional free Excel training here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI and here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u and Excel Tips and Tricks Training 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc 🔥Check out our FREE 300+ hour training course playlist here 👉kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
@sallyho146
@sallyho146 Жыл бұрын
Thank you for the video Simon. How to make unit sold in negative number in pivot table? In the value field setting, summarize value field by used ‘count’. If I put negative 1 as cancel sales, the pivot table picked up as positive 1 instead of negative 1. Therefore the total sales is increased by 2 instead of reduced by 1, i.e: became 20 instead of 18. How do I fix that?
@taneshiadunn3435
@taneshiadunn3435 9 ай бұрын
Debbie, I just wanted to let you know what an awesome instructor you are. I've taken very many online classes and tutorials, and I must say that you are by far one of the best instructors. Thank you so much!
@SimonSezIT
@SimonSezIT 9 ай бұрын
Wow, thank you!
@ecast1500
@ecast1500 Жыл бұрын
i am at the 24 minute mark and have learned more then the last 20 or so video gurus talking about pivot tables, This expert is actually reading the minds of the students. back to the presentation
@Zai488
@Zai488 Жыл бұрын
The best tutor for excel so far. Big up Ashby
@andreapurcell9038
@andreapurcell9038 21 күн бұрын
At about 48 minutes in this tutorial, so far a great learning video. There was a question on why you have the managers with the highest sales on top, or in descending order, but your bar chart has the manager with the highest sales on the bottom. I believe this is because the chart came from the data table and graphs the data starting with the first data set, manager with greatest sales and the value of sales, therefore highest sale manager is on the bottom.
@N7eptune
@N7eptune Жыл бұрын
Really I find it easy just create a table then insert a Recommended Pivot Tables and accept any suggested one then just play with it until you get what you want. Easy.
@ojeagadaniel
@ojeagadaniel 2 ай бұрын
I couldn't understand what you meant at first, but completing the course now I think I'll be using your method a lot😂😂. It was a wonderful course! I'm a DA who was taught the bare minimum in the Google data analytics programme so I'm here upgrading my skills.
@nothingnothing3211
@nothingnothing3211 2 ай бұрын
Just 36 minute around, knew quite a lot of things already but I see how we are developing and I have started learn new things about pivot. I am loving this tutorial. Thanks for free upload with very few ads. Thanks again!
@SimonSezIT
@SimonSezIT 2 ай бұрын
Glad you enjoyed it. Thanks for watching! 😃
@babatundeegbeyemi9168
@babatundeegbeyemi9168 10 ай бұрын
worldwide web madam Ashby. Transforming peoples life with microsoft empowerment. I really can't thank you enough. E seun ma (yoruba language from Nigeria)
@SimonSezIT
@SimonSezIT 10 ай бұрын
I'm glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaR
@yohannesabraham7472
@yohannesabraham7472 Жыл бұрын
What a contentfull video delivered in a detailed and clear manner by the legend Debs.. I can't believe that we are getting such a valuable full-blown course on Pivot table for FREE... Thank you so much and may God bless you guys !!
@SimonSezIT
@SimonSezIT Жыл бұрын
Glad you enjoyed it
@constantinosmavris
@constantinosmavris 5 ай бұрын
Best instructor i've ever watched regarding excel, brilliant presentation and methodology !
@SimonSezIT
@SimonSezIT 5 ай бұрын
Thanks for the kind comments 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
@rajeshr436
@rajeshr436 Ай бұрын
Absolutely brilliant. Thank you so much Deb
@SimonSezIT
@SimonSezIT Ай бұрын
You are very welcome! Thanks for watching 😃
@Ghflamenco
@Ghflamenco Ай бұрын
Where can I get the same excel sheet in order to follow her ??
@nashonamele5687
@nashonamele5687 Жыл бұрын
Good work Deborah, you are one the best I have met online
@SimonSezIT
@SimonSezIT Жыл бұрын
Thank you! 😃
@a.achirou6547
@a.achirou6547 Жыл бұрын
Amazing Tutorial! Thank you for the effort you put in.
@xlwatcher8885
@xlwatcher8885 22 күн бұрын
I'm following the video. When I created the pivot table showing manager and sales, at 17:39, by default, my pivot table came out with manager in alphabetical order. Why is yours in a different order? What order was set? All of mine were in a different order. Thank you so much for the amazing instruction; your videos are THE BEST!! Thank you in advance for answering.
@alimansimov1929
@alimansimov1929 Жыл бұрын
01:28:30(average, count of sales),, 01:34:20(calculated field(additional calculate)),, 01:40:25 (dashboard)
@2Fa2Bu
@2Fa2Bu 5 ай бұрын
This is an amazing video. Thoroughly explained and well done.
@SimonSezIT
@SimonSezIT 5 ай бұрын
Glad you found the video helpful. 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
@jessir6818
@jessir6818 5 ай бұрын
Debbie, you are a great instructor
@SimonSezIT
@SimonSezIT 5 ай бұрын
Thanks for the kind comments 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
@alokkumar-ve8bt
@alokkumar-ve8bt Ай бұрын
I owe you for sharing the valuable knowledge.
@SimonSezIT
@SimonSezIT Ай бұрын
Wow, thanks! Glad it was helpful. 🤩
@valarmorghulis2736
@valarmorghulis2736 5 ай бұрын
Excellent explanation, thank you so much for sharing.
@SimonSezIT
@SimonSezIT 5 ай бұрын
You are very welcome! Glad it was helpful. 🙂
@Kingco245
@Kingco245 Жыл бұрын
This tutorial is value-packed. Learning so much “tips and tricks.” How did you change the default fill color of the pivot field header and total row?
@ARIFSAIFIFARHAN
@ARIFSAIFIFARHAN Жыл бұрын
Thanks deb, I enjoy your session and also this one. This session will add some additional tone in my skills ahead.
@anhlenguyen404
@anhlenguyen404 Жыл бұрын
Thank you! Great lessons. I would like to you to clarify one thing: at the end of the second part (Advanced), the title should be "Sales by Country" instead of "Sales by Product"? It makes me confused a bit. Thank you
@zeen0x560
@zeen0x560 Ай бұрын
Thanks from heart for all ur amazing contant, Keep it uup !!
@SimonSezIT
@SimonSezIT Ай бұрын
Wow, thanks! Glad it was helpful. 🤩
@lnprv
@lnprv Жыл бұрын
Thank you! Great tutorial!
@power-reconcile
@power-reconcile 6 ай бұрын
Amazing Tutorial! Thank you for sharing!
@SimonSezIT
@SimonSezIT 5 ай бұрын
Glad you found the tutorial helpful! We have additional Microsoft Excel Tips and Tricks here ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
@tubeexpose
@tubeexpose 9 ай бұрын
Thanks a lot Ashby.. You are really Great Tutor..👍👍
@SimonSezIT
@SimonSezIT 9 ай бұрын
You are most welcome
@MichalKatD
@MichalKatD Жыл бұрын
Great tutorial!!
@georgesaab7609
@georgesaab7609 8 ай бұрын
Thank you for the help! I have one concern however: when combining the two "binary" files using the Power Query, it was failing to combine them giving me a DataFormat.Error.. how can this be fixed?
@louielopez-h7q
@louielopez-h7q 11 ай бұрын
Awesome! Thank you so much
@SimonSezIT
@SimonSezIT 11 ай бұрын
Glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!
@AllenBennett-vp6gd
@AllenBennett-vp6gd 5 ай бұрын
Deb, I can't make a pivot table following your instructions--it won't let me drag the Forms field anywhere (to filters, rows, columns, or values).
@eibnakaesh325
@eibnakaesh325 8 ай бұрын
thank you so much
@kabirfayez2010
@kabirfayez2010 11 ай бұрын
Fantastic
@SimonSezIT
@SimonSezIT 11 ай бұрын
Thanks for watching. We're glad you enjoyed it 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!
@dilshodaxmadov2137
@dilshodaxmadov2137 Ай бұрын
unfortunately, using the given link, I can not download the course files. Why it is not working?
@ashutoshpoudyal2705
@ashutoshpoudyal2705 9 ай бұрын
Thank You so much
@SimonSezIT
@SimonSezIT 9 ай бұрын
You are very welcome! Thanks for watching 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
@saludares888
@saludares888 Жыл бұрын
Its a big help...great tutorial
@SimonSezIT
@SimonSezIT Жыл бұрын
Glad you think so! 😊
@ablodiallo4020
@ablodiallo4020 6 ай бұрын
amazing thank you.
@SimonSezIT
@SimonSezIT 6 ай бұрын
Glad you liked it! 😃 Learn more Microsoft Excel Tips and Tricks here ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
@rabeehaithamrashid942
@rabeehaithamrashid942 Жыл бұрын
Great, thank you! :)
@SimonSezIT
@SimonSezIT Жыл бұрын
You are very welcome! Thanks for watching 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!
@AJ-et3vf
@AJ-et3vf Жыл бұрын
Awesome video! Thank you!
@SimonSezIT
@SimonSezIT Жыл бұрын
Glad you are enjoying the training. 😀
@kishan0705
@kishan0705 Жыл бұрын
Ma'am sales 2020 data are not found in downloaded files, btw great pivot tutorial ❤
@SimonSezIT
@SimonSezIT Жыл бұрын
It's saved under the subfolder Using the Data Model to Create PivotTables demo files
@dragonflylifestyle-travelm3565
@dragonflylifestyle-travelm3565 Жыл бұрын
Debbie, i did not receive the sales data worksheet showing Store Data & July Data. You use this workbook in the initial stage of the video. what do I do? Kindly assist, many thanks.
@SimonSezIT
@SimonSezIT Жыл бұрын
Hi! It's there in the free demo files download named Getting to Grips with PivotTables demo file.
@ParamjeetKaur-p3o
@ParamjeetKaur-p3o 8 ай бұрын
Hi how to delete a preceding date and retain the last date in excel for example 2006/03/08 to 2026/08/28
@microsoftsarker
@microsoftsarker 11 ай бұрын
Thank you.
@SimonSezIT
@SimonSezIT 11 ай бұрын
Welcome!
@johannpauldalingay7329
@johannpauldalingay7329 Жыл бұрын
Thank you!!! 😄
@joelmanhede5670
@joelmanhede5670 Жыл бұрын
Excellent
@SimonSezIT
@SimonSezIT Жыл бұрын
Thank you so much 😀
@tanweerabbasabbas649
@tanweerabbasabbas649 Жыл бұрын
email for sample data never arrives!!. why not just directly give accesss here!. lovely video though
@SimonSezIT
@SimonSezIT Жыл бұрын
Have you checked your spam folder? We just tested it and it works fine.
@jignasajoshi27
@jignasajoshi27 9 ай бұрын
i am getting same problem.... i have checked my spam folder too.@@SimonSezIT
@falconeye577
@falconeye577 Жыл бұрын
Well, I will sit here and learn as I want this to be something I can use but I was told it would not work for me I hope they were wrong
@ExcelServicios
@ExcelServicios Жыл бұрын
Excelente, Video
@lindsayk3599
@lindsayk3599 6 ай бұрын
Cant get file get 404 file. Will go to pragmatic no issues there.
@JamesMsele-h2y
@JamesMsele-h2y Жыл бұрын
please help me with the training files.
@gozieprince9530
@gozieprince9530 Жыл бұрын
I'm in London, I need go teacher like Debbie
@abeybrams2366
@abeybrams2366 Жыл бұрын
Thank you so much for these helpful tutorials.
@SimonSezIT
@SimonSezIT Жыл бұрын
You are very welcome :-)
@tanveerabbas3271
@tanveerabbas3271 2 ай бұрын
heyyyyy❤
@AlexBrosius
@AlexBrosius 5 ай бұрын
great and long lesson
@ginokalmeier2730
@ginokalmeier2730 5 ай бұрын
Information is great, but the Mic quality on this video is terrible
@SimonSezIT
@SimonSezIT 5 ай бұрын
Thanks for the feedback! Learn more Microsoft Excel Tips and Tricks here ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
@syedtahirbukhari8377
@syedtahirbukhari8377 4 ай бұрын
All your good vedioes are dark unable to read
@SimonSezIT
@SimonSezIT 4 ай бұрын
I appreciate your feedback! You may try our latest PivotTable tutorial: kzbin.info/www/bejne/lXvXq5qgqdiSqJo
@Stache987
@Stache987 Жыл бұрын
If you find a pivot table exciting, you must have a nerdy or dull life
@shivamrai162
@shivamrai162 Жыл бұрын
I understand what you say and respect your age but you should not be so negative minded. This video helps to reduce work life by 60percent. World has changed by the time you retired, Sir. Take Care.
@Stache987
@Stache987 Жыл бұрын
@@shivamrai162 I quoted her, goodbye 👋
@shivamrai162
@shivamrai162 Жыл бұрын
she really said that? Lol. put the time stamp before going mr 28subs
@jaroslavjurisin2715
@jaroslavjurisin2715 Жыл бұрын
As Matt Parker once said: "I can't believe some people don't use spreadsheets recreationaly." 😊
@kautilya8731
@kautilya8731 4 ай бұрын
21:36
@numeroVLAD
@numeroVLAD Жыл бұрын
Why so long and so much beating around the bush
@MK-lh3xd
@MK-lh3xd 9 ай бұрын
What? This is probably the most non-fluff, to the point video I have seen.
@MargaritaXanivtoy
@MargaritaXanivtoy 11 ай бұрын
Facebook
Pivot Tables Excel: Detailed Beginners Pivot Table Tutorial
2:39:56
Simon Sez IT
Рет қаралды 418 М.
БУ, ИСПУГАЛСЯ?? #shorts
00:22
Паша Осадчий
Рет қаралды 2,9 МЛН
Каха и лужа  #непосредственнокаха
00:15
Thank you Santa
00:13
Nadir Show
Рет қаралды 27 МЛН
An Introductory QGIS Workshop for Beginners
3:49:41
QGIS North America
Рет қаралды 569 М.
Hands-On Power BI Tutorial 📊Beginner to Pro [Full Course] ⚡
3:05:45
Pragmatic Works
Рет қаралды 2,2 МЛН
PowerPoint 365 Training for Beginners - 4-Hour Tutorial Course
3:55:02
Swift Programming Tutorial for Beginners (Full Tutorial)
3:22:45
CodeWithChris
Рет қаралды 7 МЛН
БУ, ИСПУГАЛСЯ?? #shorts
00:22
Паша Осадчий
Рет қаралды 2,9 МЛН