SEF-3001BD2 Excel 2016: Data Analysis with PivotTables

The Pivot Tables tool is one of the most powerful yet intimidating features in Excel. Pivot tables allow you to quickly summarize and analyze large amounts of data in lists and tables--independent of the original data layout in your spreadsheet--by dragging and dropping columns to different rows, columns, or summary positions. In this class students will not only be able to summarize data to analyze, but also organize the data in a way that can be meaningfully presented to others. Students will learn how to Prepare Data and Create PivotTables, Analyze Data Using PivotTables, and Work with PivotCharts.