Excel Pivot Tables (Medina Campus)

Students will learn how to create and modify PivotTables and PivotCharts as well as how to filter and modify fields to format and group data. Then students will use advanced features such as consolidating multiple workbooks as well as creating and using page fields. Finally, you will learn how to generate PivotTables using imported data from external data sources like Access, SQL Tables, the Internet, or other database programs.

1 Intro
Simple lists
Sorting/Filtering
Advanced Filtering
Subtotals

2
Creating and Modifying PivotTables
Modifying the PivotTable View
Formatting PivotTables
Refreshing PivotTables
Creating/Using Custom PivotTable Styles

3
Filtering and Modifying Fields on PivotTables
Filtering PivotTables
Conditional Formatting PivotTables
Grouping Data in PivotTable
Using and Formatting a Slicer

4
Creating and Modifying PivotCharts
Creating a PivotChart
Formatting PivotCharts

5
Advanced Features of PivotTables
Consolidating Multiple Workbooks and Ranges
Using a Generated Page Field Creating Your Own Page Field
Using Calculated Fields and Items

6
Creating PivotTables from External Data
Importing Data from External Data Sources
Importing External Data Using the PivotTable Tool
Creating a PivotTable from an Access Object

Fee Breakdown

Category	Description	Amount
Course Fee (Basic)	Tuition	$ 59.00