« Back to Class Listing

Microsoft Excel: Data Analysis Using Pivot Tables and Subtotals


This class is taught using Microsoft Excel 2010 on our lab PCs, but the content applies to Excel 2007, 2010, 2013, and 2016 for Windows. Material learned in this course may not apply to Excel for Mac.

This half day course covers creating and downloading databases and then how to analyze data through Pivot Tables and SubTotals. Students interested in this course should be comfortable using Excel formatting, sorting, and filter features.

Data analysis is a powerful Excel feature and we will look in depth at creating and editing Pivot Tables and Pivot Charts for analysis. We will look at other database features such as Subtotals and using the Name Manager. We will use sorting and filtering to help restrict our data and use Pivot Tables for Sum, Average, and Count functions. Using Office 2007/2010 we will use the new Format as a Table feature and learn the advantages and disadvantages of using Format as a Table.

Section: MS-EXCEL-DATA (05MAY17)
Dates: May 05, 2017 - May 05, 2017 Time: 9:30 AM
Tuition: $185.00 Instructor: Greg Creech Inquire
    After this class, students will be able to:
  • Create custom PivotTables and edit existing PivotTables and PivotCharts
  • Develop Subtotals in a Table
  • Use the Format as a Table feature
  • Analyze data through PivotTables
  • Increase productivity using the Name Box and Name Manager
  • Understand and implement databases using Excel

Class Schedule

Date Times Meeting Type Location
05/05/2017 9:30 AM - 12:30 PM Classroom Executive Park

Additional Information

Final Enrollment:
Clock Hours: 3.0