Pivot Tables Excel: Detailed Beginners Pivot Table Tutorial

Рет қаралды 393,005

Күн бұрын

✅ Download the free course files to follow along
➡️www.simonsezit.com/pivot-tabl...
Learn all about Excel Pivot Tables in this detailed tutorial for beginners. Learn how you can summarize your datasets by creating Pivot Tables while following along using the same data that the instructor used in the course.
In this 2+ hours Excel tutorial video, we will walk you through the importance of cleaning your data to be used in Pivot Tables. You will learn how to prepare your data by removing blank rows and duplicates, clear formatting in Excel, merging and splitting columns, and converting numbers stored as text.
We teach you how to create and format Excel tables and how to create Pivot Tables from scratch or by using the Recommended Pivot Tables option. Learn different Pivot Table layout options and how to lock the report layout. We also show you how to add Pivot Table fields, ways to summarize your data, and how to group data.
We've even included downloadable course files so you can follow along in this course. This will help you put what you are learning into practice and master PivotTables in Excel.
✅www.simonsezit.com/pivot-tabl...
📝 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 - What Are Pivot Tables
0:06:33 - Cleaning Excel Data
0:09:39 - Removing Blank Rows
0:15:10 - Removing Duplicate Rows
0:17:49 - Clearing Formatting
0:22:14 - Applying Number Formatting
0:30:53 - Changing the Case
0:40:10 - Removing Spaces and Non-printing Characters
0:50:16 - Merging and Splitting Columns
1:03:18 - Converting Numbers Stored as Text
1:05:46 - Find and Replace
1:11:53 - Spell Checking
1:15:51 - Excel Tables vs. Pivot Tables
1:21:15 - Formatting Data as an Excel Table
1:30:02 - Using Recommended Pivot Tables
1:35:31 - Creating a Pivot Table from Scratch
1:42:16 - Pivot Table Ribbons and Fields
1:47:55 - Pivoting Fields
1:53:27 - Adding Multiple Dimensions
1:56:15 - Deleting Fields and Locking the Report Layout
1:59:56 - Methods of Aggregation
2:04:07 - Combining Methods of Aggregation
2:09:43 - Grouping and Ungrouping Data in Excel
2:19:28 - Applying Number Formatting
2:24:14 - Handling Cells with No Data
2:28:15 - Subtotals and Grand Totals
2:32:41 - Choosing a Report Layout
2:37:27 - Inserting Blank Rows
🌍 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 PivotTables 👉 • How to Use Pivot Table...
✅ Pivot Tables - All you can Eat playlist here 👉 • Pivot Tables - All you...
✅ Microsoft Excel Tips and Tricks 👉 • Microsoft Excel Tips a...
✅ Advanced Pivot Tables in Excel here 👉 • Advanced Pivot Tables ...
💬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 👍🏽 ;-)

Пікірлер: 148

@babatundeegbeyemi9168 6 ай бұрын

Madam, i have been following you for a long time, maybe you don't know how much you are lifting some of us in Africa out of poverty by enriching us with this kind of knowledge to improve human development. This is speeding up my career as a maintenance planner. Thank you so much

@SimonSezIT 6 ай бұрын

Hey there! I'm so glad to hear that my videos are making a difference in your life and career. Thank you for your support and keep up the great work as a maintenance planner! 🤩 🔥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

@user-dv2ru9od1r 2 ай бұрын

I can't explain how grateful I am to the Simon Sez team especially Deb Ashby. Detailed explanation and very helpful course files to follow along. My interest for learning has more than increase. Thank you for the training and may God bless you all.

@SimonSezIT 2 ай бұрын

Our pleasure! Thank you for taking the time to leave a nice comment :-)

@tracycollier7516 Жыл бұрын

OMG! This tutorial is well worth the 2 hours it takes to complete! I'm so happy I found this. Thank you Simon Sez and Instructor Deb A!

@SimonSezIT Жыл бұрын

Glad you are enjoying the training. 😀

@Potencyfunction Жыл бұрын

i AM ALREADY BORED AFTER 15 MIN I DONT KNOW HOW I CAN SEE IT TO THE END. IT IS SCIENCE TO HAVE PATCIENCE TO GET NOW WHERE YOU CANT NOT STAND

@doraszabo3591 6 ай бұрын

AGREE, absolutely would recommend this course! I love the way it begins to introduce us to the world of pivot tables, starting with CLEANING! Thank you, very professional!!!

@SimonSezIT 6 ай бұрын

Thanks for your positive feedback! Glad it was helpful. 🤩 🚀 Level up your Excel skills with free training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI

@chukwunonsojoshua 2 жыл бұрын

Finally finished the tutorial. It's well detailed and taught in an easy-to-understand language. Great job!

@claudiomx167 Жыл бұрын

top quality! thank you Deborah, you are a fantastic presenter/teacher

@mikeparks1309 2 жыл бұрын

Thank you Deb - of all the Excel KZfaq videos available on Excel Pivot Tables, yours' are the most informative and complete.

@SimonSezIT 2 жыл бұрын

Glad you like them!

@dexxxxxxxx 2 жыл бұрын

Which video I should watch after this for pivot table please suggest.

@tonytaf107 Жыл бұрын

I've watched the 2 short vids on Pivot Tables, twice. Now I'm watching this one for the second time but this time I'm following along, I'm literally flying 😎😎😎

@SUPERSLIDE123 3 ай бұрын

What a great tutorial!!! I do a lot of the stuff in the vid but having a thorough walk through and explanation is so useful!! I learned so much more than expected. Thank you!!

@wwpharmacist Жыл бұрын

No words to describe the value added to my knowledge from this amazing video, many thanks

@SimonSezIT Жыл бұрын

Glad it was helpful!

@KaylaTheLawyer 4 ай бұрын

You are such a big help to so many people in the world. Thank you.

@lacreamlacream 4 ай бұрын

Thanks alot Simon,am new to data but because of your videos when i speak or work on a data they think am a professional already thanks alot simon for helping me

@SimonSezIT 4 ай бұрын

You're welcome! Glad it was helpful. 🤩 🔥Check out our FREE 300+ hour training course playlist here 👉 kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

@mohangr3703 Жыл бұрын

This is one of the best courses and has so much value. Brilliantly done I learned so much in 2 hrs

@SimonSezIT Жыл бұрын

Glad you liked it! 🙂

@sandraleslie188 Жыл бұрын

This is by far one of the best educational videos I have viewed. Thank you so much!!!

@SimonSezIT Жыл бұрын

Wow, thank you!

@kikimae1830 Жыл бұрын

'I swear you are an amazing teacher thank you so much!! I have three interviews this week I needed this.

@SimonSezIT Жыл бұрын

Wonderful! Wishing you the best of luck with the interviews 😊 If you need additional prep for the interview, we have additional free Excel training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training 👉kzfaq.info/sun/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u

@aika7974 2 жыл бұрын

The woman explained the excel in a really amazing way. Very articulate and easy to understand! I'am able to understand what she said quickly. really talented teacher. Kudos to all of the team 🙇

@SimonSezIT 2 жыл бұрын

This is so great to hear! Thank you!

@margaretdsouza3782 2 жыл бұрын

Words cannot describe how great a Tutor you are. Very detailed and clear voice modulation. God Bless !

@dexxxxxxxx 2 жыл бұрын

Which video I should watch after this for pivot table please suggest.

@rodneyoganga6693 2 жыл бұрын

Very well articulated Deb, you always take your time to give the best.

@SimonSezIT 2 жыл бұрын

Thanks Rodney, much appreciated ☺️

@joekriss9318 2 жыл бұрын

This training is absolutely fantastic! Thank you so much. I found it extremely useful that you also taught how to clean up the data. This is an important step and knowing the techniques you taught will speed up my workflow considerably. I was doing many of these things manually and learning a better way was very helpful to me. Thank you again, much appreciated!

@Potencyfunction Жыл бұрын

iT IS CRAZY AND VERY REALISTIC IN STORING AND DELETING DATA AS IT TAKES PROFESSIONAL SKILLS TO DO IT. IT SAVE SPACE AND TIME WASTE FOR FUTURE SALES OF NOTHING CAN BE MORE COMPREHENSIVE ON STAGE THINKING..

@alisontownsend3940 6 ай бұрын

At last people who know how to deliver superb training... love it Thank you

@SimonSezIT 6 ай бұрын

You are very welcome! Glad you enjoyed it. 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

@eagillum Жыл бұрын

Awesome tutorial- I finally learned pivot tables!

@SimonSezIT Жыл бұрын

Glad you liked it! 😊 Check out our new 10 hour Excel course -> kzfaq.info/get/bejne/nLV0obF1s7O8mX0.html

@charlesmangezi9564 2 жыл бұрын

Great teaching, now a pro. Thank you Debora!!!

@SimonSezIT 2 жыл бұрын

Glad it was helpful! Thanks for watching :-)

@eirhnh.x 2 жыл бұрын

Words cannot describe what a fantastic tutor you are!! The pace of the presentation, the tone and colour of your voice, the subjects you choose to present... Pivot tables are absolutely essential to what I have to deal with right now but I had developed a paralysing fear for them. With your presentation, I now know I can deal with this and feel so, so confident. Thank you, with all my heart thank you.

@SimonSezIT 2 жыл бұрын

Wow, I am out of words, but sure glad that it was helpful.

@dexxxxxxxx 2 жыл бұрын

Which video I should watch after this for pivot table please suggest.

@CheeseCake5990 Жыл бұрын

This is the best. Thank you for being so thorough.

@SimonSezIT Жыл бұрын

You are so welcome! Additional Pivot Table training is here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u

@Nevertoomuchtea 2 жыл бұрын

YOU are absolutely amazing! The presented material is so well explained, easy to follow and informative. Thank you for putting so much effort into this presentation.

@olusolaokuboyejo7291 2 жыл бұрын

Fantastic tutorial Deb. Don't know how to express my delight. This is definite more than I was expecting. I was not expecting such clarity. Many thanks for making this easy to learn.

@SimonSezIT 2 жыл бұрын

You are so welcome!

@anwarnsu Жыл бұрын

OMG!!! I am in love with your voice Ash!!!

@rcasturi55 9 ай бұрын

This is a great tuturial. Right from first fixing the table before making Pivots. Great explanation.

@SimonSezIT 9 ай бұрын

Glad you think so!

@realvirtualdemand4222 Жыл бұрын

always great o be here and be part of the program.. They're super and basic

@SimonSezIT Жыл бұрын

Thanks for the nice comments 😊 There's additional Excel training here if you need it -> kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

@rfdave3980 Жыл бұрын

Wow a fantastic tutorial. Ms. Ashby your are a expert in Excel. I have learnt so much, blown away at every lesson. This will help me make my reports quickly. Thank You.

@ginodiabinay 23 күн бұрын

This is so helpful. Just amazing.

@SimonSezIT 23 күн бұрын

You are very welcome! Glad it was helpful. 🙂

@oyedejiopeyemi6514 2 жыл бұрын

Many thanks for this training. I have indeed learnt new techniques of formatting large data.

@SimonSezIT 2 жыл бұрын

Great to hear!

@13lila 2 жыл бұрын

This is brilliant, you have covered every detail and explained in an easy to catch up, thank you so much 🙂

@SimonSezIT 2 жыл бұрын

Glad you enjoyed it!

@cliffordtembo8205 2 жыл бұрын

The contents and presentation is excellent, thank you so much!

@SimonSezIT 2 жыл бұрын

You're very welcome, Madlen! Here's some additional training if you need it -> kzfaq.info/get/bejne/pbRoZbieyJ-xc4U.html

@user-oo2jj7ln6g 5 ай бұрын

This is a very informative video I got to learn everything from scratch. 100% recommended for beginners like myself.

@SimonSezIT 5 ай бұрын

Glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

@tatianarose888 2 жыл бұрын

Fantastic tutorial. I've learned a lot about pivot tables now I can apply it to my spreadsheets. Thank you for the tutorial.

@SimonSezIT 2 жыл бұрын

You're very welcome, Maryrose. Thanks for watching!

@dexxxxxxxx 2 жыл бұрын

Which video I should watch after this for pivot table please suggest.

@consuelojorquera864 2 жыл бұрын

@@SimonSezIT 0⅞op0009100q

@lastattempt9983 11 ай бұрын

Thank You (specially for uploading these files for us) 🙏🙏🙏

@SimonSezIT 10 ай бұрын

Our pleasure!

@ahmadpourjavadi4223 2 жыл бұрын

THANK YOU! For sharing with others valuable information! Bod Bless You!

@SimonSezIT 2 жыл бұрын

You are so welcome Ahmad Pour Javadi 😀

@kousikdey62 2 жыл бұрын

Wonderful ethical detailing.

@SimonSezIT 2 жыл бұрын

Thanks Kousik 😀

@skpkhoo 4 ай бұрын

TQ SIMON,GREAT TUTOR.

@charlesmonier7143 6 ай бұрын

Excellent!

@SimonSezIT 6 ай бұрын

Glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

@charlesmonier7143 6 ай бұрын

appreciate it!@@SimonSezIT

@keithmcguire9422 8 ай бұрын

Great Video👏😊

@SimonSezIT 8 ай бұрын

Thank you so much! 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!

@lmg4293 9 ай бұрын

This was great! I really like her teaching style~ and if I can understand this, anyone can

@SimonSezIT 9 ай бұрын

Thank you!

@louisd95714 2 жыл бұрын

Thank you for this very informative tutorial!

@SimonSezIT 2 жыл бұрын

You’re welcome Louis!😉

@fionaawat9958 3 ай бұрын

great video Big up Deborah and your team

@SimonSezIT 3 ай бұрын

Thank you so much for your kind words! I appreciate your support. 🙂 🔥Check out our FREE 400+ hour training course playlist here 👉 kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

@dannynnanna4574 7 ай бұрын

Thank you very much

@SimonSezIT 7 ай бұрын

Hey, thanks a bunch for the shoutout! We're glad you enjoyed the video. 😊 🔥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! #SimonSezIT #Excel

@mishelitz 6 ай бұрын

AMAZING TUTORIAL!

@SimonSezIT 6 ай бұрын

Glad you enjoyed it. Thanks for watching! 🙂 🚀 Level up your Excel skills with free training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI

@Djadsjt 7 ай бұрын

This is amazing...thank youu

@SimonSezIT 7 ай бұрын

You are very welcome! Thanks for watching 🙂 🔥Need training for Excel 2021/365? Check out our free 10-hour training course on KZfaq ➡️ kzfaq.info/get/bejne/nLV0obF1s7O8mX0.html 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! #SimonSezIT #Excel

@patriciadedasdores629 2 жыл бұрын

Great tips and explanations!

@SimonSezIT 2 жыл бұрын

Glad it was helpful!

@SimonSezIT Жыл бұрын

✅Download the Free Instructor Files to follow along the course here 👉www.simonsezit.com/pivot-table-beginners-instructor-files/ If the link doesn't work, please try another web browser or try clearing your browser cache. 🔥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

@merittilewa3030 Жыл бұрын

You are the best. Thank you so much.

@SimonSezIT Жыл бұрын

You are very welcome! Glad it was helpful. 🙂

@miguelalvarado1440 6 ай бұрын

Thank You Deb. Happy New Year. Cheers!

@SimonSezIT 6 ай бұрын

Cheers to 2024. I'm glad you enjoyed our training. Thanks for watching 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

@mamunmafi1930 4 ай бұрын

Thank You

@SimonSezIT 4 ай бұрын

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

@josephirvingcrisologo Жыл бұрын

Thank you..this video tutorial is very helpful. Subscribed already.

@SimonSezIT Жыл бұрын

Glad you are enjoying the training. 😀

@jagadeeshladi7381 2 жыл бұрын

Thank you very much..

@SimonSezIT 2 жыл бұрын

No worries!

@panhachhorn5037 2 жыл бұрын

Thank you so much

@SimonSezIT 2 жыл бұрын

You're most welcome, Panha!

@hamedu2965 2 жыл бұрын

Thank you.

@SimonSezIT 2 жыл бұрын

You're welcome!

@user-cq8kd7qf4b Жыл бұрын

Thanks❤

@zillionz 2 жыл бұрын

Didn't realise that formatting as an Excel table results in them automatically expanding as new data is added to the end... the amount of time I've wasted... well, at least now I know, thank you!

@SimonSezIT 2 жыл бұрын

Glad it helped!

@redx1073 Жыл бұрын

The Best 👍

@SimonSezIT Жыл бұрын

Thanks 😊 There is additional Excel training here if you need it -> kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI

@jonesdarryn1 5 ай бұрын

a faster way to select all columns is to click that little triangle in the top left above 1 and to the left of A. it selects all columns

@engrma3 2 жыл бұрын

Its pretty good. Give the file link for practice.

@chukwunonsojoshua 2 жыл бұрын

Excellent tutorial. I have a complaint though, I couldn't seem to find the file you use for the clearing formatting, duplicates removal and empty rows removal in the files you instructed us to download from the link in the description.

@daveh4208 2 жыл бұрын

Actually, I noticed one more short cut. At 47:42, after you entered the =proper(clean(trim(b4))) formula hit control+enter, then double clicked the small box in the corner of the cell to paste everything down, all the cells in the helper row are now highlighted. From there I was then able to select 'contorl+C and it copied all the data in the C column. I then moved my cursor to cell B4, and then pasted special. I didn't have to put my cursor in cell c4, hit control+shift+down arrow to highlight everything, then Control+C, then Control+up arrow to get back to the top. Does that make sense?

@user-lc7fj9yp3p 3 ай бұрын

Can i do =PROPER(CLEAN(TRIM(B4)))? Thank you!❤

@davemason2604 2 жыл бұрын

Brilliant tutorials as always but I have found a small error so the pivot tables analisys will be incorrect.....I noticed earlier in the tutorial but then realised in the spell checking section...After you got the word "Cancelled" correctly spelt on Row 11 then that row became a duplicate of Row 12....i.e. Rows 11 and 12 are exactly the same which means a Duplicate Records match needs to be run again

@olaola5939 6 ай бұрын

👏👏

@user-cq8kd7qf4b Жыл бұрын

Why you didn't use power query for data cleaning and processing?

@moesadr3342 Жыл бұрын

How we dynamically can extract the number of rows for: this month and last month, this quarter and last quarter, this year and last year from a table? Lets say there is column for thin 1, thing 2, thing 3 etc and each occur on daily basis and we want to know the number of those occurrences for the current month, quarter and year as well as the last ones? Could someone please help?

@dexxxxxxxx 2 жыл бұрын

Where can I find next video after this?

@Michael.storen 2 жыл бұрын

@2:02:14 Where did the Year and Quarter fields come from in the pivot table? They are not on the original excel sheet.

@SimonSezIT 2 жыл бұрын

Excel can automatically group dates by year, quarter, and months when you create a Pivot Table even if you don't have these fields/columns in your source table. You can simply remove them by unchecking in the Pivot Table field list.

@rezajankov5671 Жыл бұрын

Hello! I'm having trouble finding the error for rows 9 and 14 (Sub-Saharan Africa). I followed each step in the tutorial (clean, trim etc.) and double-checked it as well. However those rows don't act OK. When I move on to change the formatting in column G to Date, G9 and G14 won't change to date but stay the same (41100, 42577). Not only that, those two rows have different row width as well and overall don't look OK.

@mayasam1326 Жыл бұрын

if you click on 41100 and press enter and then backspace . it will change into date. I tried that it worked for me.

@odalesaylor 9 ай бұрын

Can't access the training files. :(

@SimonSezIT 9 ай бұрын

Hi there. Please click the link below to download the exercise files: www.simonsezit.com/pivot-table-beginners-instructor-files/ 🔥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!

@amadubah1781 2 жыл бұрын

how to download the exercise file ?

@SimonSezIT 2 жыл бұрын

Just follow the instructions here www.simonsezit.com/pivot-table-beginners-instructor-files/

@Dean-ui3wl 2 жыл бұрын

Hi, link to dataset does not work!

@SK-ox6xq 2 жыл бұрын

doesn't work for me either.

@user-cq8kd7qf4b Жыл бұрын

I cant find file

@Potencyfunction Жыл бұрын

Of course everyone knows what is an Excel table... It only take a holistic intelligence to understand all that table.

@tonytaf107 Жыл бұрын

=SUBSTITUE(B8,"Czech Republic","CZR") doesn't work for me.

@hestiaa9354 Жыл бұрын

If it still doesn’t work, check your spelling. It’s SUBSTITUTE.

@a_codetube737 2 жыл бұрын

Downloadable Excel file are not opening …

@SimonSezIT 2 жыл бұрын

Please try clearing your cache and/or try another web browser, thanks.

@a_codetube737 2 жыл бұрын

@@SimonSezIT Problem solved.. Thank you very much... I am 100% Satisfied..

@Gary-ts6dh 11 ай бұрын

47:30 - None of the times you've used the PROPER() function up to this part in the lesson did the 'of the' in "Democratic Republic of the Congo" correctly display the prepositions in the title! How do you fix that?! 1:07:48 - Or even quicker with less mouse movement is to use the 'replace' keyboard shortcut: ctl-h

@AngelaSchans 2 жыл бұрын

Pivot table training starts at 1:16:00

@SimonSezIT 2 жыл бұрын

You can also check out the timestamps in the description box to select each topic.

@zillionz 2 жыл бұрын

The first hour+ is critical to avoiding problems and pitfalls with problematic source data... the entire tutorial is a must watch for anyone that wants to develop true expertise. The trainer recognizes this so doesn't omit it from the lesson.