Microsoft PivotTable

Course

Online

£ 59 VAT inc.

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

Online

Start date

Different dates availableEnrolment now open

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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Emagister S.L. (data controller) will process your data to carry out promotional activities (via email and/or phone), publish reviews, or manage incidents. You can learn about your rights and manage your preferences in the privacy policy.

Reviews

This centre's achievements

2019

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

Syllabus:

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
Section 2: PivotTables for Data Analysis
  • 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

£ 59 VAT inc.