Advanced Pivot Tables Tutorial in Excel - 2.5 Hour Pivot Table Excel Course

  Рет қаралды 486,079

Simon Sez IT

Simon Sez IT

Күн бұрын

✅Download the accompanying Excel exercise files here:
➡️ www.simonsezit.com/adv-pivott...
The PivotTable function in Excel is one of the most impressive and powerful functions that Excel offers. With a few clicks, you can perform data analysis that would otherwise take forever. In this 2.5-hour pivot tables tutorial, we've assumed you've used a pivot table before and are looking to build on this skill.
We start with a quick pivot tables recap before moving on to combining data from multiple worksheets for a pivot table, combining and grouping data, different pivot table layouts and styles and so much more.
This pivot tables Excel 2019 course is aimed at intermediate to advanced users. Existing knowledge of pivot tables and Excel is advised.
We've even included a free downloadable transcription study aid so you can follow along in this Pivot Table Tutorial.
✅www.simonsezit.com/adv-pivott...
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
0:00:00 - Introduction to Advanced PivotTables
0:04:02 - PivotTables Recap
0:16:45 - Importing data from a text file
0:26:43 - Importing data from Access
0:35:18 - Exercise 01
0:40:03 - Cleaning Data
0:57:42 - Tabular Data
1:14:04 - Exercise 02
1:17:21 - Creating and Manipulating a PivotTable
1:29:48 - Combining Data from Multiple Worksheets
1:41:52 - Grouping and Ungrouping
1:52:52 - Report Layouts
2:03:48 - Formatting Error Values and Empty Cells
2:12:13 - Exercise 03
2:13:49 - PivotTable Styles
2:25:28 - Custom Number Formatting
2:41:54 - Exercise 04
🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ www.simonsezit.com/courses/
🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ www.simonsezit.com/ssit-first...
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 300+ hour training course playlist here ➡️
• Simon Sez IT Long Trai...
✅ Check out our free video playlist for Intro to QuickBooks 2020 👉 • QuickBooks Tutorials -...
✅QuickBooks Pro for Beginners video playlist 👉 • Learn QuickBooks Pro f...
✅ Microsoft Excel 30 Tips and Tricks here 👉 • Microsoft Excel Tips a...
✅ Access 2019 Beginner to Advanced playlist here 👉 • Microsoft Access Tutor...
🔥Check out our FREE 300+ hour training course playlist here ➡️
• Simon Sez IT Long Trai...
💬Stay in touch!
SimonSezIT.com: www.SimonSezIT.com/
LinkedIn: / simon-sez-it
FaceBook: / simonsezit
🔔 Subscribe to our channel:
kzfaq.info...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

Пікірлер: 313
@eleananatsi2768
@eleananatsi2768 Жыл бұрын
This is where it goes "no comment". In a sense of great generosity, high level profesionalism, tutorials designed in detail, all combined to offer us an expensive tutorial program for free. Thank you Simon! I'm sure your generosity will return back to you. You are a genuine giver. Thank you Deb! You are a natural talent in teaching and we are so lucky to have you. You are really special.
@SimonSezIT
@SimonSezIT Жыл бұрын
Wow! Thank you for taking the time to write nice comment 😊 There's additional Excel training here if you need it -> kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
@yohannesabraham7472
@yohannesabraham7472 2 жыл бұрын
This is the only PivotTable course that one needs to be a good analyst. Thank you so much for your generosity in delivering such a valuable course for free by such professional and knowledgable person.
@SimonSezIT
@SimonSezIT 2 жыл бұрын
Glad you enjoyed! Thanks for watching ;-)
@rajbirsandhu9424
@rajbirsandhu9424 2 жыл бұрын
As a Data Analyst intern, it has become my worst nightmare to analyze data and find out insights because sometimes, ite really hard to decide how to start and where to start. But by watching your videos, things have become so simple and interesting I would like to say. You truly are the Excel queen. Thank you so much for making our lives easier :)
@SimonSezIT
@SimonSezIT 2 жыл бұрын
Thank you for the kind words, Rajbir. Here's some additional videos on data analysis that may be of interest: -> kzfaq.info/sun/PLzj7TwUeMQ3jiDSWwQjtVvHqT09XdYFMi -> kzfaq.info/sun/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2
@RipRoarLB
@RipRoarLB 3 жыл бұрын
Excellent Course, perfectly delivered. There are a few things, I'd like to offer to the viewers of which I saw possibly easier ways to accomplish: 1) Finding blank rows. The method in the video used found rows of blanks cells within the data, but also individual cells left blank. The video showed the user simply using the control key and mouse to remove them from the collection. However, as said in the video, this could be a very large data sheet, thus making that not a functional way to remove blank rows. Because the data is in the table, the user can go to the table header which has a drop-down field, and simply unselect the all and then scroll to the bottom of the list and select "blank". If some rows show up with data in them, go to the column header of the row and choose blank for it also. But, most likely, choosing a column that is the primary field in the data, will show all the blank rows. Then the user can simply highlight the rows and delete them from the table.
@andriashausiku2339
@andriashausiku2339 2 жыл бұрын
Thanks so much!! I realized that issue.
@J-qd5wd
@J-qd5wd 6 ай бұрын
Thank you Simon for your generosity; thank you Deb, you are an excellent communicator, the best teacher in the world.
@SimonSezIT
@SimonSezIT 6 ай бұрын
Hey, thanks a bunch for watching. I appreciate you taking the time to leave a positive feedback. 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
@kennymek3776
@kennymek3776 3 жыл бұрын
I honestly can not say how much of an assistance the tutorials that Deb Ashby's gives has been in advancing my skills and knowledge on Excel. To start with, Deb Ashby is an excellent tutor with fantastic communication style and approach. The course content is elaborate, detailed and structured. 100% informatively relevant content and very up to date. Thank you for these contents
@SimonSezIT
@SimonSezIT 3 жыл бұрын
Wow, thank you!
@JA-kb2mh
@JA-kb2mh 2 жыл бұрын
You´re such a great teacher. Thank you so much for sharing this valuable content for free! It was so great that I decided to become a member at your website. Keep it up!
@EllenHurstfoxx
@EllenHurstfoxx 2 жыл бұрын
I loved this training and thank you very much for making this training available for us.
@qww760
@qww760 3 жыл бұрын
You are a wonderful instructor! Pivot Table intimated me in college, but now it all starts making sense. I interviewed a job today that requires high level of Pivot Table skills. I am trying to improve my Pivot Table skills from basic to advanced just in case I get a 2nd interview/or the job. I am sure it will be very useful for me in the future for other jobs as well.
@SimonSezIT
@SimonSezIT 3 жыл бұрын
Thank you! Delighted that you are enjoying the courses. I hope you get it!
@piobasartejr.7686
@piobasartejr.7686 3 жыл бұрын
I am enjoying watching and learning at the same time this video tutorial. It's easy to follow that will linger in my beautiful brain infinitely as long you focus, focus and most importantly focus whilst watching the tutorial. Much gratitude Simon Sez IT.
@SimonSezIT
@SimonSezIT 3 жыл бұрын
Thank you for your wonderful review, delighted that you've enjoyed the tutorial!
@denissteward9557
@denissteward9557 2 жыл бұрын
Great job done especially to support MEAL Departments in development world.
@idayichingovo3135
@idayichingovo3135 4 ай бұрын
Deb you are such an excellent communicator and tutor, i got to understand a lot of formulaes i couldn't get from other tutorials.Thank you so much and SIMON YOU ARE STAR
@SimonSezIT
@SimonSezIT 4 ай бұрын
Thank you for your kind words! I'm glad the tutorial helped you understand the formulas.🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
@sanchezdora1266
@sanchezdora1266 Жыл бұрын
Deborah, you have a great simple facility to explain excel that I even used your videos to perform my English! I thank you for your time and for sharing your knowledge!
@SimonSezIT
@SimonSezIT Жыл бұрын
You're very welcome, and thank you too!
@glorifinadelossantos6406
@glorifinadelossantos6406 Жыл бұрын
What a great relief for us beginners. Thank you very much for your greatness in teaching people!
@SimonSezIT
@SimonSezIT Жыл бұрын
Thanks for the nice comments and the visit 😊
@JacobKinsley
@JacobKinsley 3 жыл бұрын
Thanks for uploading this for free onto KZfaq! Pivot Tables have always seemed really useful but I've never understood what some of the advanced features do until now.
@SimonSezIT
@SimonSezIT 3 жыл бұрын
Glad it was helpful! thanks for watching
@grahamhilldrup1256
@grahamhilldrup1256 3 жыл бұрын
Thank you so much for putting this video online; I found it very informative.
@SimonSezIT
@SimonSezIT 3 жыл бұрын
Glad you enjoyed it!
@bird8569
@bird8569 3 жыл бұрын
Your explaining/teaching procedure is excellent. Even any beginner can understand and learn, provided he makes practice of it.
@SimonSezIT
@SimonSezIT 2 жыл бұрын
Thank you for your kind words, Delighted you’ve enjoyed the tutorial!
@OmefeVictor
@OmefeVictor 10 ай бұрын
Hi Deb, thanks for this tutorial. You're the best teacher in the world.
@SimonSezIT
@SimonSezIT 10 ай бұрын
You are very welcome! Thanks for watching 🙂
@nithyaprakash1024
@nithyaprakash1024 Жыл бұрын
This is a really helpful and valuable lecture. Cant stop myself from leaving a comment
@tonytaf107
@tonytaf107 2 жыл бұрын
I watched first the 1h video Pivot tables beginner then the 1h advanced one. After that I watched the 2h video beginner Pivot Tables and now right here watching this 2h advanced one. All 4 together is like magic, Thank you so much 🙏🏻
@SimonSezIT
@SimonSezIT 2 жыл бұрын
Thanks for kind feedback, Tony! If you need additional Excel training, we recently uploaded our 5+ hour course for Excel 2021/365 intermediate ➡️ kzfaq.info/get/bejne/pbRoZbieyJ-xc4U.html
@anoopanil9228
@anoopanil9228 2 жыл бұрын
Thanks for this great effort and for uploading this for free, Great instructor.Highly recommended!
@SimonSezIT
@SimonSezIT 2 жыл бұрын
You're very welcome!
@35jays
@35jays 3 жыл бұрын
Great tutorial and easy to follow. Thanks for sharing!
@SimonSezIT
@SimonSezIT 3 жыл бұрын
Thanks for watching!
@bradleybarker3133
@bradleybarker3133 2 жыл бұрын
Great course! Nice refresher and learned some new things along the way.
@SimonSezIT
@SimonSezIT 2 жыл бұрын
Thanks Bradley, appreciate the feedback!
@alessandroinvernizzi3249
@alessandroinvernizzi3249 3 жыл бұрын
Great course on Pivot Table, very clear explanation supported with exercises. Highly recomended, thanks.
@SimonSezIT
@SimonSezIT 3 жыл бұрын
You're very welcome Alessandro!
@usmanmarikkar9865
@usmanmarikkar9865 3 жыл бұрын
Hello Alessandro ... Have u got the exercise files downloaded for this course.. I tried downloading through the above link ..but the link isn't working
@abipeters2454
@abipeters2454 3 жыл бұрын
immeasurably helpful. thanks Simon
@SimonSezIT
@SimonSezIT 3 жыл бұрын
Happy to help
@marymymodelmaria3210
@marymymodelmaria3210 2 жыл бұрын
You guys are good teachers. I appreciate you Deb.
@SimonSezIT
@SimonSezIT 2 жыл бұрын
Our pleasure!
@wahidullahnoor2000
@wahidullahnoor2000 6 ай бұрын
I really enjoyed learning best quick pivot table training from your channel.
@SimonSezIT
@SimonSezIT 6 ай бұрын
Glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
@lloydfaulkner9920
@lloydfaulkner9920 2 жыл бұрын
very interesting course. The accent is very clear, thanks
@lolaadeoye3584
@lolaadeoye3584 2 жыл бұрын
Thank you for refreshing my Power pivot knowledge, the content is very useful.
@SimonSezIT
@SimonSezIT 2 жыл бұрын
Glad to hear that!
@tone4996
@tone4996 2 жыл бұрын
Many thanks. Great course, all in one video.
@SimonSezIT
@SimonSezIT 2 жыл бұрын
Glad you liked it!
@zoilovaldez
@zoilovaldez 2 жыл бұрын
Best Excel training course I've ever seen on the web. Congrats., I've subscribed to receive further info from your channel and stay up-to-date on this matter.
@SimonSezIT
@SimonSezIT 2 жыл бұрын
Thanks Zoilo, greatly appreciate your kind comments. We'll pass it along to Deborah.
@SaviJawa
@SaviJawa 3 жыл бұрын
Thank you very much Simon and Deborah
@SimonSezIT
@SimonSezIT 3 жыл бұрын
You’re welcome!
@hemanttewari6752
@hemanttewari6752 3 жыл бұрын
Tutorial is exceptionally well explained!!!
@SimonSezIT
@SimonSezIT 3 жыл бұрын
Glad you think so!
@apochioodo9032
@apochioodo9032 Жыл бұрын
you are such a great and excellent excel teacher
@petarpetrov5061
@petarpetrov5061 Жыл бұрын
I just recently got an opportunity to advance in my career to a new position. Turns out I must be a master of Excel which I had not ever opened once in my life! I want to sincerely thank you for your fantastic training and free training materials, which have made me gain so much confidence in dealing with Excel! Now I look at my future job requirements for Excel and I'm like- I GOT THIS EYES CLOSED !!!!! THANK YOU !!!!
@SimonSezIT
@SimonSezIT Жыл бұрын
It's always nice to hear our tips are helping. Wishing you all the best with your new position. 😊 We have lots of additional free Excel training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
@bernardgithua6029
@bernardgithua6029 Жыл бұрын
Thanks in a bunch Deb for this training. I can confirm this has improved my data analysis techniques
@SimonSezIT
@SimonSezIT Жыл бұрын
You're welcome! Wishing you all the best in 2023 :-)
@antoanD
@antoanD Жыл бұрын
Really great tutorial! Thank you!
@junalynbagani5154
@junalynbagani5154 3 жыл бұрын
Thank you 😀 The tutorial help me a lot. I enjoyed it as well.
@SimonSezIT
@SimonSezIT 3 жыл бұрын
You're welcome 😊
@oyunpurevbattumur6073
@oyunpurevbattumur6073 Жыл бұрын
Brilliant teaching! Thank you very much!👍
@SimonSezIT
@SimonSezIT Жыл бұрын
Glad you liked it, Oyunpurev Battumur🙂 You can get additional Excel training here ➡️ kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
@Q8Patriot
@Q8Patriot 3 жыл бұрын
Very informative, thanks alot
@merittilewa3030
@merittilewa3030 Жыл бұрын
You are simply the best. God bless you
@SimonSezIT
@SimonSezIT Жыл бұрын
Wow, thank you
@prabhleenmalhotra1469
@prabhleenmalhotra1469 2 жыл бұрын
A very helpful course. Thank you!
@SimonSezIT
@SimonSezIT 2 жыл бұрын
Glad it was helpful!
@amalnabil6572
@amalnabil6572 3 жыл бұрын
thank you for this great tutorial ❤️❤️❤️
@SimonSezIT
@SimonSezIT 3 жыл бұрын
You are so welcome!😊
@levkalishchuk5406
@levkalishchuk5406 Жыл бұрын
Thank you! Super helpful!
@osoriomatucurane9511
@osoriomatucurane9511 4 ай бұрын
Great Tutorial, Crystal Clear and Concise. When grouping a numerical field into categories/classes, instead of keeping intervals, It would be awesome if we could have the option to rename the groups (like low, moderate, high, etc,...), just as we did when grouping text fields. Actually this feature I feel like it should be better named as hierarch or categorization/bucketing since right from the beginning, the pivot table is already grouping by unique fields/values, apply the aggregation metric (sum, average, count, min, max,.......)! just thinking loud!
@edwinciprian5598
@edwinciprian5598 2 жыл бұрын
Is very useful. God bless what you do!
@SimonSezIT
@SimonSezIT 2 жыл бұрын
Thanks Edwin 😄
@iliesboukhatem7803
@iliesboukhatem7803 2 жыл бұрын
thank you so much for this amazing tutorial, it's very well explained and organized!
@SimonSezIT
@SimonSezIT 2 жыл бұрын
That is very kind of you, thank you!
@abdidekmuhumed4510
@abdidekmuhumed4510 3 жыл бұрын
Very very useful, thanks.
@divinelyguided_protected144
@divinelyguided_protected144 2 жыл бұрын
This is excellent. Thank you for sharing this information for free.
@SimonSezIT
@SimonSezIT 2 жыл бұрын
Glad you enjoyed it, Nikki! 😃
@listyokowisnuaji5179
@listyokowisnuaji5179 2 жыл бұрын
very good way of improving your pivot table skills.. thank you for uploading this video
@SimonSezIT
@SimonSezIT 2 жыл бұрын
Thanks and welcome
@hubertienwichers243
@hubertienwichers243 2 ай бұрын
Excellent, very helpful for my studies, Thanks so much!
@SimonSezIT
@SimonSezIT 2 ай бұрын
Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
@mekassociatescpa
@mekassociatescpa Жыл бұрын
great lectures
@yumyes6272
@yumyes6272 2 жыл бұрын
Excellent presentation
@maameagyeiwaa8580
@maameagyeiwaa8580 2 жыл бұрын
Thank you for this detailed course
@SimonSezIT
@SimonSezIT 2 жыл бұрын
You're very welcome!
@tranngoctrung4150
@tranngoctrung4150 2 жыл бұрын
Very useful lesson. Thanks so much!
@SimonSezIT
@SimonSezIT 2 жыл бұрын
Glad it was helpful!
@maxwell9566
@maxwell9566 3 жыл бұрын
Great and very helpful tutorial.
@SimonSezIT
@SimonSezIT 3 жыл бұрын
Glad you liked it
@jonathand170
@jonathand170 2 жыл бұрын
Great tutorial!
@zuhairalmutawa9941
@zuhairalmutawa9941 2 жыл бұрын
Thank you very much for this Excellent course.
@SimonSezIT
@SimonSezIT 2 жыл бұрын
Glad you liked it!
@ebrimajobe7530
@ebrimajobe7530 3 жыл бұрын
Thank for this great tutorial
@SimonSezIT
@SimonSezIT 3 жыл бұрын
Glad you liked it
@zainabsalam5206
@zainabsalam5206 3 жыл бұрын
Thank you so much for sharing this.
@SimonSezIT
@SimonSezIT 3 жыл бұрын
You are welcome!
@oscararguijojr.4979
@oscararguijojr.4979 3 жыл бұрын
12 minutes in but already subbed!! thank you so much for this video!
@SimonSezIT
@SimonSezIT 2 жыл бұрын
Wohoooo, Delighted to hear it!
@lizzingbet
@lizzingbet Жыл бұрын
So good! Thank you. I've learnt so much.
@SimonSezIT
@SimonSezIT Жыл бұрын
Glad you are enjoying the training. 😀
@srtechno3049
@srtechno3049 8 ай бұрын
Unbelievable Simon
@SimonSezIT
@SimonSezIT 8 ай бұрын
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!
@choroyerebakia2742
@choroyerebakia2742 Жыл бұрын
Brilliant presentation like never before
@SimonSezIT
@SimonSezIT Жыл бұрын
Thank you so much, Choro! If you need additional Excel training, there is plenty of it here -> kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
@davegrimes
@davegrimes 3 жыл бұрын
Thank you. Great intro!!
@SimonSezIT
@SimonSezIT 3 жыл бұрын
Thank you Dave!
@hatimhmt1502
@hatimhmt1502 3 жыл бұрын
very great
@yunfengwang1510
@yunfengwang1510 Жыл бұрын
Excellent tutorial in Excel ever!
@SimonSezIT
@SimonSezIT Жыл бұрын
Glad you think so!
@petetones3748
@petetones3748 3 жыл бұрын
good detailed overview, thanks
@SimonSezIT
@SimonSezIT 3 жыл бұрын
You’re welcome!
@kamineyiresha358
@kamineyiresha358 2 жыл бұрын
Thank you so much for this valuable tutorial
@SimonSezIT
@SimonSezIT 2 жыл бұрын
You're very welcome!
@ahmedsamir1193
@ahmedsamir1193 11 ай бұрын
Thank a lot Simon really I appreciate this high quality effort the course is amazing
@SimonSezIT
@SimonSezIT 11 ай бұрын
Our pleasure!
@prakashwadkar9899
@prakashwadkar9899 2 жыл бұрын
A Very very helpful course. Thank you
@SimonSezIT
@SimonSezIT 2 жыл бұрын
Glad it was helpful!
@selfmadetool
@selfmadetool Жыл бұрын
Thank you!
@jakobforslin6301
@jakobforslin6301 2 жыл бұрын
Awesome video, thank you so much!
@SimonSezIT
@SimonSezIT 2 жыл бұрын
Glad you liked it!
@janakadissanayake9350
@janakadissanayake9350 3 жыл бұрын
Just what I wanted Thanks 😀
@SimonSezIT
@SimonSezIT 3 жыл бұрын
You're welcome 😊 Glad you enjoyed it Janaka! Thank you for watching and commenting!
@abubakarrk.conteh325
@abubakarrk.conteh325 3 жыл бұрын
Great tutorial
@SimonSezIT
@SimonSezIT 3 жыл бұрын
Glad you think so Abu!
@PrasannaKumar-bo3vt
@PrasannaKumar-bo3vt 2 жыл бұрын
Teaching is excellent
@SimonSezIT
@SimonSezIT 2 жыл бұрын
😊 Thanks for watching!
@hatimhmt1502
@hatimhmt1502 3 жыл бұрын
thanks deb and thanks SIMON SEZ IT quite useful
@SimonSezIT
@SimonSezIT 3 жыл бұрын
Glad to hear it Hatim
@miftahfarid2141
@miftahfarid2141 2 жыл бұрын
Great content, really helpful
@SimonSezIT
@SimonSezIT 2 жыл бұрын
Delighted to hear that Miftah!
@kamalchellani7412
@kamalchellani7412 2 жыл бұрын
Excellent. Thank you
@SimonSezIT
@SimonSezIT 2 жыл бұрын
You're welcome!
@hazemali382
@hazemali382 2 жыл бұрын
More than great Tutorial Many Thanks ♥
@SimonSezIT
@SimonSezIT 2 жыл бұрын
Glad it was helpful, Hazem ♥
@jazbaatilaunda
@jazbaatilaunda Жыл бұрын
Hi Deb, first up, thanks a bunch! I can't express how much your videos have helped me learn pivot tables. Forever grateful. I downloaded the files but the sheets are totally different from what I see in the tutorials. Am I missing something? The files are under Folder 1, 2, 3 and 4 and they seem to be employee data files not sales figures.
@priscillarubio6079
@priscillarubio6079 2 жыл бұрын
love this video! thanks for sharing!
@SimonSezIT
@SimonSezIT 2 жыл бұрын
Thanks for watching! :-)
@samuelopoku-agyeman9432
@samuelopoku-agyeman9432 Жыл бұрын
The relationship was not forming well though i was going through the process step by step, same help will be needed
@ofosuappiah5209
@ofosuappiah5209 2 жыл бұрын
Thanks for this course
@SimonSezIT
@SimonSezIT 2 жыл бұрын
You are very welcome! Thanks for watching :-)
@ProsenjitBappi
@ProsenjitBappi Жыл бұрын
nice explanation, thank you.
@SimonSezIT
@SimonSezIT Жыл бұрын
Glad you liked it!
@humayonkabir6729
@humayonkabir6729 Жыл бұрын
Great job!
@SimonSezIT
@SimonSezIT Жыл бұрын
Thank you! Cheers!
@sumanpradhan3407
@sumanpradhan3407 2 жыл бұрын
Thank you very much Sir/Ma'am for such a good content..wish you all the very best for your future advancement...
@SimonSezIT
@SimonSezIT 2 жыл бұрын
You're very welcome! Thank you for watching ;-)
@fumobutu.s.s.r520
@fumobutu.s.s.r520 Жыл бұрын
Nice video!!! 🌶
@SimonSezIT
@SimonSezIT Жыл бұрын
Thank you! Cheers!
@amilamsamson1977
@amilamsamson1977 2 жыл бұрын
very Helpful Vedio, Many Thanks for making and publishing this in You tube.
@SimonSezIT
@SimonSezIT 2 жыл бұрын
You are most welcome
@CR-lz5yx
@CR-lz5yx 3 жыл бұрын
Awesome👍👍👍
@SimonSezIT
@SimonSezIT 3 жыл бұрын
Thanks for watching!
@samuelopoku-agyeman9432
@samuelopoku-agyeman9432 Жыл бұрын
Amazing class. I am Sam from Ghana
@SimonSezIT
@SimonSezIT Жыл бұрын
Thanks for watching our training, Samuel 😀
@samuelegbule8192
@samuelegbule8192 Жыл бұрын
Fantastic traning
@tommasosquarzoni8614
@tommasosquarzoni8614 3 жыл бұрын
AMAZING
@SimonSezIT
@SimonSezIT 3 жыл бұрын
Thanks for watching Tommaso!
@user-kg3xy5el6k
@user-kg3xy5el6k 10 ай бұрын
amazing!
@SimonSezIT
@SimonSezIT 10 ай бұрын
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!
@ayazuddin4396
@ayazuddin4396 2 жыл бұрын
Excellent explanation, Keep it up sis❤️
@SimonSezIT
@SimonSezIT 2 жыл бұрын
Thank you so much 🙂
@dream91011
@dream91011 3 жыл бұрын
thank you
@SimonSezIT
@SimonSezIT 3 жыл бұрын
You're welcome
@SimonSezIT
@SimonSezIT 3 жыл бұрын
Follow-along and download the accompanying Excel exercise files here ► www.simonsezit.com/adv-pivottables-course-exercise-files/ We have additional free Excel training here if you need it 👉 kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
@SimonSezIT
@SimonSezIT 3 жыл бұрын
Hi, I've just tested the email link and it's working fine, we've had a number of people successfully get their files already. I suggest checking your spam/junk folder as sometimes the files end up in there. Also, check that you entered your email address correctly, if there was a small typo it won't send!
@usmanmarikkar9865
@usmanmarikkar9865 3 жыл бұрын
Hello ... The above link for the exercise files is not working..Can u pls help me download the files..
@pritamsharmapaudel4060
@pritamsharmapaudel4060 2 жыл бұрын
@@usmanmarikkar9865 for me too its not working i've tried several times
@jamesfrisby8194
@jamesfrisby8194 2 жыл бұрын
i have tried numerous times to download the exercises and the course needs these to be worthwhile
@black90ify
@black90ify 2 жыл бұрын
I added my email several Time No e-mail received from you. Please check your e-mail process .
@ismailmohamed4426
@ismailmohamed4426 2 жыл бұрын
wonderful
@SimonSezIT
@SimonSezIT 2 жыл бұрын
Many thanks
@Thetrurth
@Thetrurth 2 жыл бұрын
Should be getting like and getting view million
@SimonSezIT
@SimonSezIT 2 жыл бұрын
Thank you Sam, I’m glad you’ve enjoyed it! 🙃
@tennispie1
@tennispie1 2 жыл бұрын
Thanks :)
@SimonSezIT
@SimonSezIT 2 жыл бұрын
No problem!
@pankaj007arbia
@pankaj007arbia 3 жыл бұрын
Nice video
@SimonSezIT
@SimonSezIT 3 жыл бұрын
Thanks Pankaj, glad you enjoyed it!
Pivot Table Tutorial - Learn PivotTables in 1 Hour - Excel Crash Course
1:02:01
Advanced Pivot Tables in Excel: 1-hour Excel Pivot Tables Tutorial
1:08:00
How Many Balloons Does It Take To Fly?
00:18
MrBeast
Рет қаралды 181 МЛН
50 Ultimate Excel Tips and Tricks for 2020
50:17
Sele Training
Рет қаралды 1,8 МЛН
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Excel Campus - Jon
Рет қаралды 120 М.
3 Essential Excel skills for the data analyst
18:02
Access Analytic
Рет қаралды 1,5 МЛН
Excel Power Query Course: Power Query Tutorial for Beginners
1:49:28
Simon Sez IT
Рет қаралды 820 М.
Excel Time-Savers - 5 Hidden Features for Busy People
14:24
Leila Gharani
Рет қаралды 366 М.
Ultimate Excel PivotTables Tutorial: Beginner to Advanced - 3.5 Hours!
3:25:48
Advanced Pivot Table Tricks ONLY Experts Know
9:39
Kenji Explains
Рет қаралды 474 М.
How to use Power Pivot in Excel | Full Tutorial
30:38
Kevin Stratvert
Рет қаралды 1,4 МЛН
Power Pivot Tutorial & Power Query in Excel - 1-Hour Class
1:02:30
Simon Sez IT
Рет қаралды 254 М.
50 things you didn't know Excel can DO 💡
30:03
Chandoo
Рет қаралды 269 М.
Kumanda İle Bilgisayarı Yönetmek #shorts
0:29
Osman Kabadayı
Рет қаралды 1,8 МЛН
Какой ноутбук взять для учёбы? #msi #rtx4090 #laptop #юмор #игровой #apple #shorts
0:18
Cheapest gaming phone? 🤭 #miniphone #smartphone #iphone #fy
0:19
Pockify™
Рет қаралды 4,4 МЛН