Get Actionable Insight From Your Data With Excel’s Popular Power Tool!
Pivot Tables are the perfect tool to analyze large amounts of data in Excel, and in this Excel: Data Analysis with Pivot Tables course, Microsoft trainer Kathy Jones will show you how to effectively use the PivotTable tools in Excel 2013 and 2016. Are you ready to learn how to get more from Excel with the power of PivotTables?
Length: 2 hrs 27 min
This title is available in the
Total Training All-Access library.
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 in both the 2013 and 2016 versions of Excel.
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
1. Excel: Data Analysis with Pivot Tables 2:27:33
Create From Local Data Source
Create From Multiple Local Sources
Create From External Sources
Summarize Table Data
Organize Pivot Table Data
Filter Data Part 1
Filter Data Part 2
Format Pivot Table
Refresh And Change Data
Pivot Options Part 1
Pivot Options Part 2
Creating A Pivot Chart Data
Manipulate Pivot Chart Data
Formatting A Pivot Chart
Kathy Jones is a training professional with experience in all aspects of training and consulting, including classroom presentations, project management process analysis, program design and development, and individual knowledge transfer. She has a special focus on work with project management teams to improve processes, as well as the soft skills involved in managing projects and teams such as negotiation and problem resolution. She also specializes in working with technical teams such as IT groups or help desks to improve communication and customer skills.
Specialties: Project management process analysis and training; Communication, negotiation and team building skills for technical managers and specialists.