Mastering: Microsoft Excel PivotTables

Training Provided by INT Information Systems, Inc. One of Excel's most powerful features is also one of its most neglected. Many people have never even heard of PivotTables and those who have have often seen only the most basic features of the tool. This class devotes an entire day to exploring all of the most useful and powerful aspects of Excel's PivotTables. The class is taught as a hands-on "laboratory" lead by an experienced instructor. During class, students use a workstation to work with actual files and real-world examples. In addition to the classroom instruction and hands-on exercises, each participant recieves a booklet and class CD, detailing the topics and methods presented during the class, for their review after class.

Mastering: Microsoft Excel PivotTables

Excel data tends to be arranged into lists that run hundreds or thousands of rows. Within this forest of unorganized information, there are details to be analyzed, trends to be spotted and data points to be summarized. How do you spot that information?

PivotTables summarize, analyze and report on large lists of data by rearranging the data set into an easy-to-manage overview or summary. Easily built and fluid in their construction, they can be crucial in helping you better understand your data.

The process of creating a basic PivotTable is quite simple but this class covers aspects of PivotTables that are rarely documented in other Excel books or courses. This includes the creation of custom grouping systems (grouping a series of dates by month and year, for example) and frequently-overlooked options that provide powerful methods of reviewing data. Optional sections, covered at the class' request, include sections on working with data in an Access database and the use of the tricky "multiple consolidation ranges" option. As a full day class, there is ample opportunity to review every significant tool offered by PivotTables, as well as answer student questions. The class objectives include:

• Review the basic construction and manipulation of PivotTables: building, rearranging and formatting PivotTables, drilling down to specific information, updating and expanding PivotTables.
• Cover intermediate PivotTable features: arranging data into logical groups, setting up a PivotTable to print similar to an Access report, filtering in PivotTables.
• Discuss advanced PivotTable features: the Data field options, creating calculated fields and calculated items.
• Use PivotTables to analyze complex data: use Access data in a PivotTable, create a PivotTable based on multiple tables.

Visit the class' web page to review the class table of contents and sample pages from the presentation.

About The Training Provider: INT Information Systems, Inc.

More Training from INT Information Systems, Inc.

• Advanced Microsoft Excel
• Advanced Microsoft Word
• Building Better Brochures, Banners And Training Materials
• Integrating Microsoft Office
• Intermediate Microsoft Access
• Intermediate Microsoft Excel
• Intermediate Microsoft PowerPoint
• Intermediate Microsoft Word
• Introduction to Microsoft Access
• Introduction to Microsoft Excel
• Introduction to Microsoft PowerPoint
• Introduction to Microsoft Word
• Mastering: Microsoft Excel Charts