How to Create Excel Pivot Tables & Pivot Charts - Beginner's Guide

Quickly analyze large amounts of data with a Pivot Table! Welcome to our comprehensive beginner's guide on how to create Microsoft Excel Pivot Tables and Pivot Charts! Whether you're new to Excel or looking to enhance your skills, this tutorial is packed with essential tips and tricks to master these powerful tools.

0:00 Introduction: Kickstart your journey to Excel proficiency.
0:27 Inserting a Pivot Table: Step-by-step guide on setting up your first pivot table.
3:00 Selecting Fields: How to choose the right fields for impactful data analysis.
5:26 Adjusting Rows and Columns: Customizing pivot tables for better data visualization.
6:26 Sorting in Pivot Tables: Techniques for efficient data organization.
7:50 Filtering Pivot Tables: Learn to focus on the data that matters most.
9:03 Creating Individual Worksheets: Organize data with separate worksheets for each item.
10:57 Pivot Table Tips and Tricks: Elevate your skills with advanced strategies.
13:12 Conditional Formatting: Make your data stand out with conditional formatting techniques.
14:33 Adding a Pivot Chart: Integrating visual elements for enhanced data interpretation.
16:29 Customizing Pivot Charts: Tailor your charts for maximum impact.

Join us as we delve into the essentials of creating and customizing pivot tables and charts in Microsoft Excel. You'll learn how to sort, filter, and format your data for more insightful analysis. Don't miss our exclusive tips and tricks to elevate your Excel skills. Perfect for beginners eager to become proficient in data analysis and visualization with Excel.

[dominiqued.]

What an excellent teaching and demonstration!!

[AnshikaSharma-ovxs]

i love how it uses The Office's reference, so cute. Good work Jim Halpert !!!

[PawanAdhikari-kdqk]

I love that you are using The Office's Names

[rtlxjiq]

This was very helpful and a great refresher. I had not created pivot tables for a long time. After watching this I feel like I have been missing out. Thank you!

[JesiwiththeTea]

I love that you are using The Office 🙂

[mackensonreginaldmichel]

Thanks for your videos. I have a question: can I have all the features of Excel online with the paid version, without having to install it, just with my account?

[marcw.]

Nicely done ! - Is there any reason the formatting changes when refreshing data in Pivot Tables ? really hard to fix - annoying. I notice that has been the case even in Query refreshing when there is new data. Formatting just doesnt hold - been doing that for many years.

[TECHMAN]

How do you print a multi page excel sheet or document 3:55AM

[Mandy]

I would like to know how to calculate the difference between 2 data sets. Example- I used multiple patient samples and tested for a specific analyte using 2 different methods. I want to have it show the difference between the 2 methods for each patient.

[julius]

I used sheets and Excel for years and I ended up creating extremely complex but easy to use sheets without ever touching pivot tables. Now I tried using them to see what's the deal with them, and I couldn't even figure out how to my sales data in descending order. I feel so dumb, but is there really any use to this if you are an advanced user? I imagine pivot tables could be more useful for someone who would rather avoid creating everything from the ground up.

[princealbertz]

Do you mind giving us exercise files to follow along?

[joycewong]

Hi Teacher, at 9:15, while you press 'Total' and get the column of 'Sum of total', i cannot get the 'Sum of total', any idea which part when wrong?

[jflartner]

what is a pivot table and why would I use one?

[alberthovhannisyan]

Interesting fact all employers are working in Dunder Mifflin

[markg]

Why is Dwight paying $20 for each pen?! Dwight would know better than this.