Microsoft excel data analysis with pivot tables online training course

Course Outline

Being able to summarize, visualize, and tabulate your data makes PivotTables an important skill for anyone who uses Excel to store and report on data. Taught by Microsoft trainer Kathy Jones, Excel: Data Analysis with Pivot Tables will help intermediate and advanced users work more effectively with Excel PivotTables and PivotCharts.

Topics covered include:

• Preparing Data and Creating PivotTables
• Working with Local and External Data Sources
• Summarizing, Organizing, Filtering, and Formatting PivotTables
• Refresh and Change PivotTable Data
• Working with PivotCharts

Objectives. You will be able to:

• Create a pivot table from a local data source, multiple local data sources, and external sources
• Organize data within a pivot table
• Modify pivot table options

Need to train your Team? Contact Us for Discounts on Multiple Subscription Purchases.