Excel - Pivot Table 101 - Episode 846
28.4 هزار بار بازدید -
16 سال پیش
-
Microsoft Excel Tutorial - Pivot
Microsoft Excel Tutorial - Pivot Table 101.
Welcome to another episode of the MrExcel netcast! In this video, we will be diving into the world of Excel Pivot Tables and showing you how to create your first one from scratch. If you're a Facebook user, be sure to check out our group "Excel Pivot Tables Rock!" for more tips and tricks.
Pivot Tables are one of the most powerful features in Excel, allowing you to summarize large amounts of data in just a few clicks. To get started, make sure your data set has headings above each column and no blank rows or columns. Then, go to the Insert tab and click on the PivotTable icon. As long as your data is in Excel, the program will automatically detect it and create a blank Pivot Table for you.
In the past, we used to have to drag fields from the field list onto the report. But with Excel 2007, we now have two sections at the top for fields and at the bottom for drop zones. Simply drag the fields you want from the top to the appropriate drop zone at the bottom. For example, if we want to create a summary of sales by region and product, we would drag the Region field to the Row Labels and the Product field to the Column Labels. Then, choose the data you want to display, such as Revenue, Cost of Goods Sold, or Profit.
One new feature in Excel 2007 is the Auto Formats, which can be found on the Design tab. These allow you to quickly change the appearance of your Pivot Table with just a few clicks. You can also rearrange your fields by dragging them to different drop zones, making it easy to customize your report to your needs.
And that's it! With just a few clicks, you can create a beautiful and informative Pivot Table without having to write a single formula. So next time you need to summarize a large data set, remember to use Pivot Tables and make your life a little easier. Thanks for watching and be sure to check out our other netcasts for more Excel tips and tricks.
Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...
Creating your first pivot table in Microsoft Excel.
Episode 846 shows you how.
Table of Contents:
(00:00) Introduction
(00:18) Join the Excel Pivot Tables Rock! Facebook group
(00:28) Need for a tutorial on starting a Pivot Table in Excel 2007
(00:44) Overview of Pivot Tables and their power
(00:54) Preparing data for a Pivot Table
(01:04) Inserting a Pivot Table
(01:18) Pivot Table field list and drop zones
(01:28) Dragging fields to create a summary
(01:39) Building a summary of sales by Region and Product
(02:00) Automatically creating a beautiful view of the data
(02:12) Rearranging the Pivot Table
(02:38) Using Auto Formats in Excel 2007
(02:55) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial
This video answers these common search terms:
Adding fields to Pivot Tables
Creating a professional looking Pivot Table
Drag and drop fields in Pivot Tables
Excel Pivot Table design options
Excel Pivot Table features
Excel Pivot Table tutorial
How to create a Pivot Table in Excel 2007
MrExcel netcast tutorial on Pivot Tables
Rearranging Pivot Table data in Excel 2007
Starting a Pivot Table in Excel 2007
Summarizing data with Pivot Tables
Using Auto Formats in Excel 2007 Pivot Tables
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...
Welcome to another episode of the MrExcel netcast! In this video, we will be diving into the world of Excel Pivot Tables and showing you how to create your first one from scratch. If you're a Facebook user, be sure to check out our group "Excel Pivot Tables Rock!" for more tips and tricks.
Pivot Tables are one of the most powerful features in Excel, allowing you to summarize large amounts of data in just a few clicks. To get started, make sure your data set has headings above each column and no blank rows or columns. Then, go to the Insert tab and click on the PivotTable icon. As long as your data is in Excel, the program will automatically detect it and create a blank Pivot Table for you.
In the past, we used to have to drag fields from the field list onto the report. But with Excel 2007, we now have two sections at the top for fields and at the bottom for drop zones. Simply drag the fields you want from the top to the appropriate drop zone at the bottom. For example, if we want to create a summary of sales by region and product, we would drag the Region field to the Row Labels and the Product field to the Column Labels. Then, choose the data you want to display, such as Revenue, Cost of Goods Sold, or Profit.
One new feature in Excel 2007 is the Auto Formats, which can be found on the Design tab. These allow you to quickly change the appearance of your Pivot Table with just a few clicks. You can also rearrange your fields by dragging them to different drop zones, making it easy to customize your report to your needs.
And that's it! With just a few clicks, you can create a beautiful and informative Pivot Table without having to write a single formula. So next time you need to summarize a large data set, remember to use Pivot Tables and make your life a little easier. Thanks for watching and be sure to check out our other netcasts for more Excel tips and tricks.
Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...
Creating your first pivot table in Microsoft Excel.
Episode 846 shows you how.
Table of Contents:
(00:00) Introduction
(00:18) Join the Excel Pivot Tables Rock! Facebook group
(00:28) Need for a tutorial on starting a Pivot Table in Excel 2007
(00:44) Overview of Pivot Tables and their power
(00:54) Preparing data for a Pivot Table
(01:04) Inserting a Pivot Table
(01:18) Pivot Table field list and drop zones
(01:28) Dragging fields to create a summary
(01:39) Building a summary of sales by Region and Product
(02:00) Automatically creating a beautiful view of the data
(02:12) Rearranging the Pivot Table
(02:38) Using Auto Formats in Excel 2007
(02:55) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial
This video answers these common search terms:
Adding fields to Pivot Tables
Creating a professional looking Pivot Table
Drag and drop fields in Pivot Tables
Excel Pivot Table design options
Excel Pivot Table features
Excel Pivot Table tutorial
How to create a Pivot Table in Excel 2007
MrExcel netcast tutorial on Pivot Tables
Rearranging Pivot Table data in Excel 2007
Starting a Pivot Table in Excel 2007
Summarizing data with Pivot Tables
Using Auto Formats in Excel 2007 Pivot Tables
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...
16 سال پیش
در تاریخ 1387/10/19 منتشر شده
است.
28,430
بـار بازدید شده