Microsoft Excel PivotTables 2010
Overview
TCCIT Solutions provides high quality, affordably priced, training classes in Microsoft Excel 2010. With experienced instructors and a convenient midtown NYC location, we offer Microsoft Excel 2010 courses for the corporate community. TCCIT Solutions offers group classes and private tutoring to beginner and more advanced corporate clients in Microsoft Excel 2010. We offer onsite training or classes at our facility on 34th Street and Madison in New York City.
Course Objective:
You will create and analyze PivotTable data.
Target Student:
This course is meant for people with a sound working knowledge of Microsoft Excel and general computer proficiency.
Upon successful completion of this course, students will be able to:
- build a PivotTable
- analyze data using PivotTables
- present PivotTable data visually
Prerequisites:
Students are recommended to take the following courses or possess equivalent knowledge:
Next Classes:
Related Classes:
Course Content
Lesson 1: Building a PivotTable
- Topic 1A: Insert a PivotTable
- Topic 1B: Create a PivotTable Based on External Data
- Topic 1C: Categorize PivotTable Data
- Topic 1D: Customize a PivotTable
Lesson 2: Analyzing Data Using PivotTables
- Topic 2A: Create Custom Calculations in a PivotTable
- Topic 2B: Restructure a PivotTable
Lesson 3: Presenting PivotTable Data Visually
- Topic 3A: Format a PivotTable
- Topic 3B: Present a PivotTable in a PivotChart
- Topic 3C: Print PivotTables and PivotCharts
Appendix A: Solvers
Appendix B: Goal Seek
Appendix C: Troubleshooting PivotTables
For more information about Corporate Training, please either call us at your convenience at 212-684-5151 or email us at info@TCCITSolutions.com.
You can always view our Complete Course List and our Complete Schedule.