Microsoft PivotTable
Course
Online
Description
-
Type
Course
-
Level
Intermediate
-
Methodology
Online
-
Class hours
6h
-
Duration
Flexible
-
Start date
Different dates available
-
Online campus
Yes
-
Delivery of study materials
Yes
-
Support service
Yes
-
Virtual classes
Yes
Learn to harness the power of Excel’s PivotTable™ with this course. We will take you step-by-step from the basics through to dominating your data.
Excel can feel daunting – in particular, the infamous PivotTable™ function, which is widely spoken about and little understood. In the simplest terms, it allows you to automatically sort data from one table and present it in another, the pivot table.
But pivot tables can be far more sophisticated than that, and thanks to their flexibility and analytical clout are widely considered Excel’s most powerful tool.
Facilities
Location
Start date
Start date
About this course
The primary uses of pivot tables
How to identify the best and worst data sets
To filter, sort and group PivotTable™ data to maximise its usefulness
How to present your data clearly using PivotCharts and Conditional Formatting
CPD UK
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 6 years
Subjects
- Excel
- MS Excel
- PivotTable
- 2013 PC
- Presentation
- Clarity and Impact
- Calculations
- Adding Value
- Flexible Reporting
- Reporting
- Power
- Data analysis
- PivotTables
Course programme
Section 1: PivotTable 2013 PC
- Unit 1.1 - Introduction and Basics
- Unit 1.2 - Filter and Group to Compare and Contrast
- Unit 1.3 - Presentation - Clarity and Impact
- Unit 1.4 - Calculations - Adding Value to Values
- Unit 1.5 - Your Data Your Way - Flexible Reporting
- Unit 1.6 - Power to the User - Interactivity
- Unit 2.1 - Dominate Your Data
- Unit 2.2 - PowerPivot and Big Data
- Unit 2.3 - Make Your Data Work Harder
- Unit 2.4 - From Data to Decisions
- Unit 2.5 - Present Data Analysis with Impact
- Unit 2.6 - Give me more Power
Microsoft PivotTable
