Look Who it Was Random video

Excel - Pivot Tables in Excel: Step-by-Step Tutorial to Create Your First Pivot Table - Episode 706

1,064 views · Published 18 February 2009 · 2:37 · Indexed 29 October 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Create your first pivot table in Excel 2007. Episode 706 shows you how.

Welcome back to the MrExcel netcast! I'm Bill Jelen, and today we're diving into the world of Pivot tables, Excel's most powerful feature. Learn how to transform massive datasets—whether it's 500, 5,000, or 500,000 rows—into a concise one-page summary with just a few clicks.

🚀 In this episode:

Discover the efficiency of Pivot tables in Excel.
Follow the easy steps to create a Pivot table from your data.
Understand the Pivot table field list and its drop zones.
Learn how to arrange data using column labels, row labels, and sum value sections.
Build a quick summary report showcasing Model, Region, and Revenue in just five clicks and a drag.
🎯 This week, we'll unravel more advanced features and functionalities of Pivot tables. Stay tuned for in-depth insights that will supercharge your data analysis skills.

👉 Subscribe to MrExcel for regular netcasts and tutorials, unlocking the full potential of Microsoft Excel. Don't miss out on upcoming episodes that will empower you to master Pivot tables and elevate your spreadsheet game.

📌 If you found this introductory episode helpful, give it a thumbs up, share it with your colleagues, and hit that subscribe button for more Excel brilliance. Your journey to becoming an Excel pro starts here!

🔗 Check back next time for another netcast from MrExcel, where we continue our exploration of Excel's powerful features.

Table of Contents:
(00:00) Introduction to Pivot Tables
(00:20) How to access Pivot Table command in Excel 2007
(00:43) Understanding the Pivot Table field list
(00:58) Using drop zones in the field list
(01:14) Adding fields to create a report
(01:42) Creating a one page summary with just a few clicks
(02:08) More advanced features of Pivot Tables
(02:18) 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:
Advanced Pivot table features
Column labels
Data analysis
Data summarization
Excel 2007
Model and Region
Pivot tables
Report filter
Revenue calculation
Row labels
Sum values
Summary report

Join the MrExcel Message Board discussion about this video at  https://www.mrexcel.com/board/threads/1152200/

More from this channel