Students will learn how to use Pivot Tables to summarize and analyze large amounts of data. They will learn about the available tools that are available to assist with this task.
Microsoft Excel 2013 – Data Analysis with Pivot Tables
Categories: Guaranteed To Run™, Microsoft
Duration: 1 Day
Share it:
Upon successful completion of this course, students will be able to understand, create, and format Pivot Tables.
Preparing Data and Creating PivotTables
- Prepare Data
- Create a PivotTable from a Local Data Source
- Create a PivotTable from Multiple Local Data Sources
- Create a PivotTable from an External Data Source
Analyzing Data Using PivotTables
- Summarize PivotTable Data
- Organize PivotTable Data
- Filter PivotTable Data
- Format a PivotTable
- Refresh and Change PivotTable Data
Working with PivotCharts
- Create a PivotChart
- Manipulate PivotChart Data
- Format a PivotChart
- Guaranteed to Run™. This ensures you will attend the instructor led class or live online class you want as scheduled without any disruptive cancellations*. You book the training you need, get back to focusing on your job and are sure your training requirements will be met saving time, money and ensuring peace of mind.
- This schedule icon the schedule indicates that this date/time will be conducted as Instructor Led Training (ILT) or a Virtual Instructor Led Training (VILT) depending on the indicated class availablity.