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.