Excel Data Analysis With Pivot Tables & Pivot Charts
This MS Excel Pivot Table tool is most important for many executives, administrative assistants, Managers, marketers, supervisors, Finance professionals, Accounting professionals and anyone needs to learn.
Duration: 1 Day
Hours: 3 Hours
Training Level: All Level
About Microsoft Excel Pivot Tables Course Online:
In three hours you will learn the simplicity of Pivot Tables along with the power that they hold. You will see first-hand what all the fuss is about what PivotTables are and why everyone needs them. If you are using Excel and want to harness the power of the tools available to you in this program this class is for you. Learn, with ease, how to set up, calculate, summarize, and analyze your data. This is one tool many executives, Managers, supervisors, administrative assistants, marketers, or anyone and everyone using Excel needs to learn.
Microsoft Excel Pivot Tables Course Objective:
- Create a Pivot Table to analyze worksheet data.
- Arrange fields in a Pivot Table.
- Group and Ungroup Data in a Pivot Table.
- Filter data in a Pivot Table.
- Create PivotCharts.
- How to use PivotTables in Interactive Dashboards.
- Tips and Tricks for Beginning to Advanced Users of PivotTables.
Who is the Microsoft Excel Pivot Tables Course Target Audience?
- Anybody with basic knowledge of Microsoft Excel
What Basic Knowledge is required to learn the Microsoft Excel Pivot Tables Course?
- Have some working knowledge of Microsoft Excel
Curriculum
Total Duration: 3 Hours
Session
- Table of Contents
- Create PivotTables
- Organize Data Using the Field List
- Group and Ungroup Data
- Summarize and show values
- Use Slicers
- Sort and Filter Data
- Quickly Format PivotTables
- Change Data/Refresh Data
- Create Pivot Charts
- Interactive Excel Dashboards with slicers and Pivot Tables.
- PivotTables vs. PowerPivot
- Bonus: Pivot Tables Tips & Tricks!