Learn how to use PivotTables in Excel with this step-by-step tutorial for beginners. Find out how to insert pivot tables and how to use recommended pivot tables. Learn what filter, column, row, and value mean. See how to use calculated fields to quickly analyze data in a pivot table. See how to summarize and show your values in different ways. Lastly, learn how to insert pivot charts, what defer layout update means, and how to access Excel for free online using office.com.

In this tutorial, I use Excel that comes with Office 365; however, this should also work with all previous versions of Excel, like Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007, and Excel 2003.

👋 Resources called out in this video:

Access the sample data in the spreadsheet:

📃 Watch related playlists and videos

– Excel:

🚩 Connect with me on social:

– LinkedIn:

– Twitter:

– Facebook:

🔔 Subscribe to my YouTube channel

🎬 Want to watch again? Navigate back to my YouTube channel quickly

Nguồn: https://collectif-du-chambon.org/

Xem thêm bài viết khác: link danh mục

Access the sample data in the spreadsheet here: https://1drv.ms/x/s!AmxrofZZlZ-wg_xUE4vA3D_5qdbRjA

Other Excel Videos & Tutorials: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

thank you very much, Kevin

I believe that everyone should learn this. You are amazing! Thanks you

Very helpful

Your tutorials are good but I’d recommend to slow down when you explain and zoom in to see your worksheet

Thanks so much for taking the time to explain and teach us these things, much appreciated!!!

Great lesson, thank you!

I just liked and subscribed. Keep them coming. You are a genius.

Is anyone else having difficulty with "Sum of Price"? When I do it, it becomes Count of Price and when i change it to sum I get 0's

i think he was in a hurry, could you slow down just bit….. 🙂

Hi.

Very easy to follow.

I have been avoiding pivot tables till now! For me they are the least understood part of excel!

Thank you.

Have an interview Wednesday that requires knowing about pivot tables! You actually made learning this exciting! Thank you ☺️🙌🏽

Prepping for a job interview, and this made me feel a lot more confident about my changes of getting the job. Thanks!

Awesome tutorial!

Kevin, you’re so calm and patient and explain it so thoroughly! You could be a driving instructor 👍😂👨🏫

Really helpful video's but I would prefer them if you cold talk a little slower, please!

Thank you so much for helping me for my school!!

get to the point man quit milking it

OMG What a crisp and neat presentation.

5:45 My Sum of Price/Cost just comes out as 0. anyone else get this?

Trying to visualize my expenses for personal budgeting. Apparently pie charts don't work well with long lists of categorized transactions. Thanks!