Excel 2016: Pivot Tables

This training course for Microsoft Excel 2016 focuses on Pivot Tables, a powerful tool for summarizing, analyzing, and presenting large amounts of data quickly and effectively. After reviewing the benefits and uses of Pivot Tables, you’ll learn how to select an appropriate data source and create a Pivot Table using the quick analysis tool. Next you’ll explore the many options available for formatting the appearance and layout of your Pivot Table. You’ll also learn how to print your Pivot Table, display grand totals, and create calculated fields to provide additional analysis. This course also shows you how to create Pivot Charts, Sparklines, and slicers to enable you to visually analyze your data. This 1-hour course, part of our Microsoft Excel 2016 training series, features engaging audio and step-by-step instructions to help you more effectively and easily analyze your data.

Learning objectives:

• Analyze your data by creating and customizing a Pivot Table
• Summarize your data by displaying a grand total
• Graph your data by creating a Pivot Chart
• Utilize spark lines to visually represent your data in a single cell