Ultimate Excel PivotTables Tutorial: Beginner to Advanced

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

Рет қаралды 404,349

Күн бұрын

Пікірлер: 83

@SimonSezIT Жыл бұрын

We have additional free Excel training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI and here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u and Excel Tips and Tricks Training 👉 kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc 🔥Check out our FREE 300+ hour training course playlist here 👉kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

@sallyho146 8 ай бұрын

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 5 ай бұрын

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 5 ай бұрын

Wow, thank you!

@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 Жыл бұрын

The best tutor for excel so far. Big up Ashby

@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.

@constantinosmavris Ай бұрын

Best instructor i've ever watched regarding excel, brilliant presentation and methodology !

@SimonSezIT Ай бұрын

Thanks for the kind comments 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

@a.achirou6547 Жыл бұрын

Amazing Tutorial! Thank you for the effort you put in.

@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 10 ай бұрын

Glad you enjoyed it

@lnprv Жыл бұрын

Thank you! Great tutorial!

@2Fa2Bu Ай бұрын

This is an amazing video. Thoroughly explained and well done.

@SimonSezIT Ай бұрын

Glad you found the video helpful. 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

@ARIFSAIFIFARHAN Жыл бұрын

Thanks deb, I enjoy your session and also this one. This session will add some additional tone in my skills ahead.

@jessir6818 Ай бұрын

Debbie, you are a great instructor

@SimonSezIT Ай бұрын

Thanks for the kind comments 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

@MichalKatD Жыл бұрын

Great tutorial!!

@babatundeegbeyemi9168 6 ай бұрын

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 6 ай бұрын

I'm glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaR

@nashonamele5687 Жыл бұрын

Good work Deborah, you are one the best I have met online

@SimonSezIT Жыл бұрын

Thank you! 😃

@valarmorghulis2736 Ай бұрын

Excellent explanation, thank you so much for sharing.

@SimonSezIT Ай бұрын

You are very welcome! Glad it was helpful. 🙂

@johannpauldalingay7329 Жыл бұрын

Thank you!!! 😄

@power-reconcile 2 ай бұрын

Amazing Tutorial! Thank you for sharing!

@SimonSezIT Ай бұрын

Glad you found the tutorial helpful! We have additional Microsoft Excel Tips and Tricks here ➡️ kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

@user-rq9hv6jm5l 7 ай бұрын

Awesome! Thank you so much

@SimonSezIT 7 ай бұрын

Glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZfaq Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzfaq.info ♥️ We appreciate your support!

@eibnakaesh325 4 ай бұрын

thank you so much

@tubeexpose 5 ай бұрын

Thanks a lot Ashby.. You are really Great Tutor..👍👍

@SimonSezIT 5 ай бұрын

You are most welcome

@ExcelServicios Жыл бұрын

Excelente, Video

@Kingco245 9 ай бұрын

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?

@rabeehaithamrashid942 8 ай бұрын

Great, thank you! :)

@SimonSezIT 8 ай бұрын

You are very welcome! Thanks for watching 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZfaq Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzfaq.info ♥️ We appreciate your support!

@ashutoshpoudyal2705 5 ай бұрын

Thank You so much

@SimonSezIT 5 ай бұрын

You are very welcome! Thanks for watching 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

@kabirfayez2010 7 ай бұрын

Fantastic

@SimonSezIT 7 ай бұрын

Thanks for watching. We're glad you enjoyed it 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZfaq Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzfaq.info ♥️ We appreciate your support!

@joelmanhede5670 10 ай бұрын

Excellent

@SimonSezIT 10 ай бұрын

Thank you so much 😀

@ablodiallo4020 2 ай бұрын

amazing thank you.

@SimonSezIT 2 ай бұрын

Glad you liked it! 😃 Learn more Microsoft Excel Tips and Tricks here ➡️ kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

@microsoftsarker 7 ай бұрын

Thank you.

@SimonSezIT 7 ай бұрын

Welcome!

@AJ-et3vf Жыл бұрын

Awesome video! Thank you!

@SimonSezIT Жыл бұрын

Glad you are enjoying the training. 😀

@alimansimov1929 Жыл бұрын

01:28:30(average, count of sales),, 01:34:20(calculated field(additional calculate)),, 01:40:25 (dashboard)

@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

@AlexBrosius Ай бұрын

great and long lesson

@saludares888 Жыл бұрын

Its a big help...great tutorial

@SimonSezIT Жыл бұрын

Glad you think so! 😊

@georgesaab7609 4 ай бұрын

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?

@AllenBennett-vp6gd Ай бұрын

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).

@gozieprince9530 Жыл бұрын

I'm in London, I need go teacher like Debbie

@kautilya8731 4 күн бұрын

21:36

@dragonflylifestyle-travelm3565 10 ай бұрын

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 10 ай бұрын

Hi! It's there in the free demo files download named Getting to Grips with PivotTables demo file.

@user-vy6nj7cm3w 4 ай бұрын

Hi how to delete a preceding date and retain the last date in excel for example 2006/03/08 to 2026/08/28

@user-my5ez6gz7x 11 ай бұрын

please help me with the training files.

@kishan0705 10 ай бұрын

Ma'am sales 2020 data are not found in downloaded files, btw great pivot tutorial ❤

@SimonSezIT 10 ай бұрын

It's saved under the subfolder Using the Data Model to Create PivotTables demo files

@lindsayk3599 2 ай бұрын

Cant get file get 404 file. Will go to pragmatic no issues there.

@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

@abeybrams2366 11 ай бұрын

Thank you so much for these helpful tutorials.

@SimonSezIT 11 ай бұрын

You are very welcome :-)

@tanweerabbasabbas649 11 ай бұрын

email for sample data never arrives!!. why not just directly give accesss here!. lovely video though

@SimonSezIT 10 ай бұрын

Have you checked your spam folder? We just tested it and it works fine.

@jignasajoshi27 5 ай бұрын

i am getting same problem.... i have checked my spam folder too.@@SimonSezIT

@Stache987 Жыл бұрын

If you find a pivot table exciting, you must have a nerdy or dull life

@ShivamRai-xo8fu Жыл бұрын

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 Жыл бұрын

@@ShivamRai-xo8fu I quoted her, goodbye 👋

@ShivamRai-xo8fu Жыл бұрын

she really said that? Lol. put the time stamp before going mr 28subs

@jaroslavjurisin2715 Жыл бұрын

As Matt Parker once said: "I can't believe some people don't use spreadsheets recreationaly." 😊