Excel 2010 Creating and Using Pivot Tables (1/2 Day)
CLASS DATE(s):
Request a Class

COURSE LENGTH: 1/2 Day

COURSE COST: $175*

COURSE TIMES: 9:00am - 12:00pm

Printable version of this course
print

COURSE OVERVIEW

PivotTables may be Excel's most powerful feature, but Microsoft has estimated that only 15% of Excel users take advantage of them. That's because PivotTables have a reputation for being difficult to learn.
This course uses realistic business scenerios that any Excel user can understand, and goes far beyond merely explaining PivotTables and PivotCharts. The course presents practical "recipes" for solving a wide range of business problems.

Upon successful completion of this course, students will be able to:

  • build a PivotTable.
  • analyze data using PivotTables.
  • present PivotTable data visually.

    AUDIENCE AND PREREQUISITES

    This course is meant for people with a sound working knowledge of Microsoft Excel and general computer proficiency.

      

    *Course cost listed does not include the cost of courseware (required) or lunch (optional). Please contact us at learn@vtec.org or 207-775-0244 for additional pricing information, or if you have any questions.
    Course subject to minimum enrollment.

  • COURSE TOPICS:


    Lesson 1: Building a PivotTable
    Insert a PivotTable
    Create a PivotTable Based on External Data
    Categorize PivotTable Data
    Customize a PivotTable

    Lesson 2: Analyzing Data Using PivotTables
    Create Custom Calculations in a PivotTable
    Restructure a PivotTable

    Lesson 3: Presenting PivotTable Data Visually
    Format a PivotTable
    Present a PivotTable in a PivotChart
    Print PivotTables and PivotCharts

    Appendix A: Solvers

    Appendix B: Goal Seek

    Appendix C: Troubleshooting PivotTables