Microsoft Excel PivotTables 2010


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


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

You can always view our Complete Course List and our Complete Schedule. will take you to our sister site