
This hands-on course introduces one of Excel’s most powerful tools for summarizing and analyzing data – PivotTables. Students will learn how to evaluate data, create and rearrange PivotTables, sort and filter information, refresh data, and drill down to view details. The course also covers formatting a PivotTable, inserting slicers, and turning the data into a PivotChart.
Prerequisites:
• Basic computer skills (keyboard, mouse, file management)
• Experience working with Excel worksheets
• Familiarity with entering data and using simple Excel features (such as selecting cells and creating basic formulas)
IMPORTANT NOTE: This is NOT a beginner class.