Excel Pivot Tables Tutorial

[@LearnitTraining]

Exercise Files: learnitanytime.com/p/exercise-files-excel-pivot-tables-tutorial-2024

[@christianhennig4622]

Your instruction has greatly impressed me; it is clear, calm, and simple to follow. Many thanks for making this video available.

[@LearnitTraining]

We are happy you found it helpful!

[@thaovu-fd8jy]

Thank you so much Mo Jones!

[@MosGel-l2j]

This video on Excel pivot tables is excellent. It provides a comprehensive explanation with clear examples. Great work!

[@LearnitTraining]

Thank you very much!

[@yugo6946]

Thank you so much Mo Jones, I thoroughly enjoyed this. You were very detailed, and you made Pivot tables tutorial look like its A, B, C. You are indeed a great instructor! Bless up!

[@LearnitTraining]

Thank you for the kind words!

[@diaashaaban1111]

I just wanna send love and thanks to the great instructor Trish Connor ❤️

[@LearnitTraining]

You are very welcome!

[@jazminsanez7980]

Amazing, thank you ❤️

[@LearnitTraining]

You are welcome!

[@valeriemac679]

All the steps are easy to follow and remember. Thank you so much for this informative tutorial video!!

[@LearnitTraining]

You are very welcome!~

[@entertaimentoo231]

Thanks for this kind of productive course of Excel. Please make more videos about excel we really want to learn Excel from this Channel. ❤ Love from India.

[@LearnitTraining]

More Excel is on the way!

[@samueltafere5400]

I very much admire you for your presentation

[@LearnitTraining]

Thank you very much!

[@peterrandu7666]

Thanks for your hard work

[@LearnitTraining]

You are welcome!

[@devicetest-b4h]

LIKED IT

[@LearnitTraining]

👍👍

[@klyuvert]

i didn't know anything about power pivot, thanks a lot

[@LearnitTraining]

You are welcome!

[@kingsfordofori1887]

Thanks a lot for the training

[@LearnitTraining]

Our pleasure!

[@lwazimthembu855]

I believe in this channel, you guys taught me Sharepoint 🙌, I'm still learning thou

[@LearnitTraining]

Happy to hear that!

[@adamtabor6754]

Easy explained and for that very useful.👍

[@LearnitTraining]

Glad it was helpful!

[@upishararuwan1881]

Great video. Very helpful. Thank you!

[@LearnitTraining]

You are very welcome!

[@rc3794]

Thank you ❤

[@LearnitTraining]

You're welcome 😊

[@MicrosoftSolutions]

It seems you have done this work from the heart! Can you give me some tips after looking at my work too?🙏

[@LearnitTraining]

Thanks! We saw a few of your videos and our only advice is to ditch the AI voiceover and use your own voice. People love learning from people.

[@BelalNegm]

Excellent

[@LearnitTraining]

Thank yOU!

[@michelecuprak4266]

Thank you!!!!

[@LearnitTraining]

You are welcome!

[@sakottomitav]

Thank you so much!!!

[@LearnitTraining]

You're welcome!

[@benosborne413]

Great. Thanks. Pity it does not update automatically. Must refresh every time

[@LearnitTraining]

This article may help: www.howtogeek.com/789536/how-to-refresh-a-pivot-table-in-microsoft-excel/

[@jeangreen432]

This is a wonderful tutorial, thank you so much for the opportunity to learn about pivot tables! May I please ask your opinion on creating a payroll system for 10 employees using pivot tables? Do you see any cons? Thank you again for your expertise and time!

[@LearnitTraining]

You can definitely do it! This article may help: excel-dashboards.com/blogs/blog/excel-tutorial-create-payroll

[@jeangreen432]

@@LearnitTraining Thank you for your kind reply, it was a nice article!

[@yehualashetTeklemariam]

great thank you

[@LearnitTraining]

You are welcome!

[@benjiking-dj7zs]

I like the ways

[@LearnitTraining]

👍

[@masoudakbari6284]

awesome is the only thing I can say

[@LearnitTraining]

Thanks!

[@crimetimereports]

Lab Task Total sales for state: TX = $17647 Total sales for City: Salem = $21152 # of Production packages sold = 16 Insert a calculated Field Total commissions earned @5% = $7822 Commission for Cara Olson = $1227 Insert a Timeline Total sales for Q2 in 2023 = $44773

[@LearnitTraining]

👍👍👍

[@ragulmarley4900]

😊 really good nice explanation any video for power bi sir

[@LearnitTraining]

Here you go! kzbin.info/www/bejne/m2e0dWuihZKgbKc

[@xxLvlxx]

Hi, I wanted to follow the tutorial but I can't find the Excel options screen. In my ribbon I don't have the files tab next to home. Do you have any idea how to open that? Thanks 🙏

[@LearnitTraining]

This article may help: support.microsoft.com/en-us/office/office-options-the-general-tab-c51b7db7-d59e-448a-aa8a-7e9310cebae3#:~:text=To%20see%20general%20options%20for,click%20File%20%3E%20Options%20%3E%20General.

[@sonalisinghal988]

Plz made the series on SQL too..

[@LearnitTraining]

That series is coming this October!~

[@chukylo-k2h]

@@LearnitTraining October is almost here.... I can't wait Moe..... You such a wonderful teacher 🤝... Do you have a power BI series yet?

[@BelalNegm]

❤❤❤

[@LearnitTraining]

❤❤❤

[@chukylo-k2h]

Why is the Analyze Data shortcut is not popping up when I type the "quick access....." is there somewhere it can be turned on and off? 1- Total sales for state: TX =$17,647.00 2- Total sales for City: Salem =$21,152.00 3- # of Production packages sold = 42 4- Total commission earned @5% = $7,822 5- Commission for Cara Olson = $1,227 6- Total sales for Q2 IN 2023 = $2239........ comment if you arrived at the same value.... T for Thanks..😛

[@zezo977]

Total sales for Q2 in 2023 = $44,773😁