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

475,479
0
Published 2020-09-09
✅Download the accompanying Excel exercise files here:
➡️ www.simonsezit.com/adv-pivottables-course-exercise…

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-pivottables-course-exercise…

📝 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-month-free

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 300+ hour training course playlist here ➡️
   • Simon Sez IT Long Training Courses  

✅ Check out our free video playlist for Intro to QuickBooks 2020 👉   • QuickBooks Tutorials - Crash Course i...  

✅QuickBooks Pro for Beginners video playlist 👉    • Learn QuickBooks Pro for Beginners  

✅ Microsoft Excel 30 Tips and Tricks here 👉    • Microsoft Excel Tips and Tricks  

✅ Access 2019 Beginner to Advanced playlist here 👉    • Microsoft Access Tutorial - MS Access...  

🔥Check out our FREE 300+ hour training course playlist here ➡️
   • Simon Sez IT Long Training Courses  

💬Stay in touch!
SimonSezIT.com: www.SimonSezIT.com/
LinkedIn: www.linkedin.com/company/simon-sez-it/
FaceBook: www.facebook.com/SimonSezIT

🔔 Subscribe to our channel:
youtube.com/simonsezittraining?sub_confirmation=1

If you enjoyed the video, please give a thum

All Comments (21)
  • @JA-kb2mh
    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!
  • 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.
  • I loved this training and thank you very much for making this training available for us.
  • 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.
  • 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.
  • @JacobKinsley
    Thanks for uploading this for free onto YouTube! Pivot Tables have always seemed really useful but I've never understood what some of the advanced features do until now.
  • What a great relief for us beginners. Thank you very much for your greatness in teaching people!
  • 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!
  • @bird8569
    Your explaining/teaching procedure is excellent. Even any beginner can understand and learn, provided he makes practice of it.
  • @J-qd5wd
    Thank you Simon for your generosity; thank you Deb, you are an excellent communicator, the best teacher in the world.
  • Thank you so much for putting this video online; I found it very informative.
  • 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 :)
  • @anoopanil9228
    Thanks for this great effort and for uploading this for free, Great instructor.Highly recommended!
  • Great course! Nice refresher and learned some new things along the way.
  • 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!
  • Great course on Pivot Table, very clear explanation supported with exercises. Highly recomended, thanks.