|
Provided by: Lorman Education Services Discover the Secrets of Microsoft. Excel Pivot Tables |
 |
Training
Provided by Lorman Education Services
nAny Excel user who maintains database-like data invariably needs tools to manage and analyze the data beyond mere sorting and filtering. Excel's Pivot Table feature gives you a quick and powerful way to create summary cross-totals combined with an enormous flexibility to restructure your results with simple dragging of fields. Whether you need the ability to create a quick look at the data for that important meeting or need more detailed analysis for a printed report, a Pivot Table will meet your needs. It also has a great visual complementary feature - a pivot chart - that further enhances your presentation possibilities. To create good, quick summary information for analytical purposes, nothing beats a Pivot Table. This teleconference will use the 2003 version and will include GoToWebinar interactive component.
|
|
||||||||||
Discover the Secrets of Microsoft. Excel Pivot Tables
Agenda
- Prepare Your Data for Optimum Use in a Pivot Table
- Create a Pivot Table With Just a Few Quick Clicks
- Restructure Your Pivot Table in a Flash for a Better Layout or to Include More Fields
- Use the Drill-Down Feature to Instantly See the Detailed Original Data Behind Any Pivot Table Summary Value
- Create a Pivot Chart - Punctuate Your Presentation With This Complementary Feature That Adds Visual Impact and Gives You That Big Picture
- Perform Ad Hoc On-The-Fly Grouping of Pivot Table Results for Even More Analytical Possibilities
- Quickly Sort Pivot Table Data by Field Labels or Content
- Easily Move Pivot Table Fields for a More Logical Appearance
- Filter Pivot Table Data With Drop Arrows
- Collapse Lengthy Date Data Rapidly to View Summaries by Month, Quarter or Year
About The Training Provider: Lorman Education Services
Lorman Education Services - Lorman Education is dedicated to providing cost-effective training opportunities that meet the needs of our members and enhance their skills, knowledge, and competencies.
Please use Priority Code 16175 when registering.
Lorman Education Services began offering continuing education seminars in 1987.
Lorman Education is dedicated to providing cost-effective training opportunities that...
