Key Fact:
Out of 2,500 companies-those that offered comprehensive training had 24% higher profits. -ASTD
Register for Computer Training
Excel Pivot Tables
Date: Wednesday, September 29, 2010
Course Length: 1/2 Day
Time: 8:30 AM - 12:00 PM
Price: $249.00
Seats Remaining: 4
1. Working with External Data
Making your data dynamic, using the offset function and tables.
2. Working with Tables
Creating a table, working with table size, total row and table data. Summarizing a table with a PivotTable, using the data form, table styles and style options, creating and deleting custom table styles, and converting or deleting a table.
3. Working with PivotTables
Creating a PivotTable, specifying data, changing a PivotTable's calculation, creating custom calculations, filtering and sorting, working with layouts, grouping items, exporting PivotTable to a text file, updating and formatting the table and creating a PivotChart.