Home > BrittBrief > Microsoft Excel -How to Create and Use Pivot Tables - Part I
Microsoft Excel -How to Create and Use Pivot Tables - Part I 
 
10/7/2009 
ALP Recording 

Click on the image above to watch the webcast replay now.

 Class Description

Microsoft Excel Pivot tables are a tremendous tool for ad-hoc analysis and reporting of data from almost any source.

Excel's Pivot Tables enable you to slice, dice and present data from a variety of perspectives.

In this class you will learn how to:

  • Understand the general math concept behind Pivot Tables
  • Set your Excel spreadsheet database in proper format for Pivot Table creation
  • Create a basic Pivot Table
  • Manipulate multiple views of Pivot Table data

In our follow up class in November, we'll cover more advanced Pivot Table capabilities.

 Class Handout

 Other Materials of Interest
Microsoft Excel - How to use Date Math and Functions to Solve Practical Business Problems in Excel
In this month’s Microsoft Excel webcast class, you’ll learn "How to Use Date Math and Functions to Solve Practical Business Problems in Excel."
Microsoft Excel - How To Automate Spreadsheets with Conditional Expressions and Lookup Tables in Excel
The IF function is one many people shy away from, but this is one function that will truly make every Excel user's life much easier. Excel's VLookup is a handy tool that helps you compare data in two spreadsheets
Microsoft Excel - What's New & Different in Excel 2007
Whether you already have Excel 2007, or plan to upgrade, this webcast class will provide valuable tips and tricks you can use immediately.
Microsoft Excel - How to Create and Use Pivot Tables - Part II
Excel's Pivot Tables enable you to slice, dice and present data from a variety of perspectives.
Microsoft Excel -How to Create and Use Pivot Tables - Part I
Microsoft Excel Pivot tables are a tremendous tool for ad-hoc analysis and reporting of data from almost any source. Excel's Pivot Tables enable you to slice, dice and present data from a variety of perspectives.
Microsoft Excel - Sorting, Querying, and Subtotaling an Excel Database
nage data in Excel? If you aren't using the "Database" feature in Excel, you could be missing out on a tool to finally give you mastery over lists of data.
Microsoft Excel - How to Optimize your Data Management with Excel's Database Feature
Do you manage data in Excel? If you aren't using the "Database" feature in Excel, you could be missing out on a tool to finally give you mastery over lists of data. Join the inaugural class of the Excel Advanced Learning Program from Brittenford Systems, and learn the secret!
Microsoft Excel - How to Automate Procedures with Templates in Excel
Join us today as we tackle these two challenges: How to Consolidate Data Across Worksheets, and How to Dynamically Link Excel to Word
Microsoft Excel - How to Understand Errors and Audit Formulas in Excel
Here's what we will cover: Spreadsheet Error Messages and how to solve these issues when they occur Excels' Formula Auditing Feature for monitoring and debugging your math
Microsoft Excel - How to Create & Use Pivot Tables
Microsoft Excel Pivot Tables are a useful tool for ad-hoc analysis and reporting from almost any data source. Learn more today at 11:30 a.m. when you join Microsoft partner Brittenford Systems for the webcast "How to Create and Use Pivot Tables in Microsoft Excel."
Microsoft Excel - What's New & Different in Excel 2010
Excel 2010 has a totally new look, plus hundreds of new features and enhancements. Whether you already have Excel 2010, or plan to upgrade, this webcast class will provide valuable tips and tricks you can use immediately.
Microsoft Excel - Performing What-if Analysis with the Scenario Manager
In this class you'll learn about Goal Seek - a simple tool for basic what-if analysis; Scenario Manager Basics - setting up and displaying multiple scenarios for a spreadsheet; Scenario Manager Output - creating reports and charts to display scenarios; and more.
12359 Sunrise Valley Dr, Suite 130, Reston, VA 20191
©2011 Brittenford Systems, Inc.
remote system administration
remote system administration