Excel PivotTables & PivotCharts

Now enrolling for December 10th-11th class.

Excel PivotTables & PivotCharts
Duration: 2.00 Day(s)
Instructor-led Classroom Learning

OVERVIEW
Many know the basics of using Excel, however, few users truly understand the powerful capabilities of the PivotTable and PivotChart features Excel offers. These tools can help turn long lists of unreadable data into dynamically generated, easy-to-read tables and charts that highlight useful and pertinent business information. Companies rely on this type of data from marketing, accounting, and finance to help make better decisions about products, sales and even human resources. Charts are interactive, allowing the users to tweak results with the click of a mouse and PivotTables allow the fusion of data from several sources into one document.

This course is designed to show users how to work with PivotTables and PivotCharts more effectively and make better sense of their data. It covers features such as: understanding PivotTable benefits and uses; creating and customizing PivotTables; using PivotTables to analyze business data; building custom calculations; linking to external data sources, including Access databases, Word tables, Web pages, XML data, and SQL Server databases; publishing PivotTables to the Web; multiple consolidation of data, for example, summarizing annual fiscal data by quarters; preparing financial reporting, budgeting, and data analysis across departments; and using VBA to create macros that automate frequently used PivotTable tasks.

PREREQUISITES
• Individuals should have a strong working knowledge of the Excel application and its functionality.
• Highly recommended that Excel Levels 1, 2, and 3 be taken prior to enrolling for this specialized course which focuses more in depth on the specific topic of PivotTables and PivotCharts.

OUTLINE
• Understanding PivotTables
• Building a PivotTable
• Manipulating Your PivotTable
• Changing the PivotTable View
• Customizing PivotTable Fields
• Setting PivotTable Options
• Performing PivotTable Calculations
• Creating Custom PivotTable Calculations
• Creating a PivotChart
• Building More Advanced PivotTables
• Learning VBA Basics for PivotTables


For more information or to enroll in this class, please contact:

New Horizons of Houston
(713) 552-1414 / http://www.nhhouston.com/