Excel Pivot Table

Frontier Education

Course

Online

£ 19 VAT inc.

Description

  • Type

    Course

  • Level

    Beginner

  • Methodology

    Online

  • Duration

    Flexible

In this bundle course you will have three courses

Course 1: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines

Course 2: Excel PowerQuery and PowerPivot

Course 3: Excel Pivot Table Basic

Curriculum:

Building basic maths
Managing the Field List

Changing the Calculation type with Value Field Settings

Growing your Pivot Table with Multiple Fields

Formatting the Pivot Table

Sorting and Filtering the Pivot Table

Creating a Dashboard with Slicers, Timelines and Pivot Charts

Reporting by day, month, qtr, or year within the Pivot Table

Refreshing the Pivot Data with new data

Adding your own calculations into the Pivot Table

The power of the Filter Section in the Pivot Table

PowerQuery

PowerPivot

26 videos on Excel PowerQuery and PowerPivot
28 videos on basic PivotTable

About this course

No prior knowledge or experience required

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

Reviews

Subjects

  • Excel
  • Microsoft Excel
  • Microsoft excel training
  • MS Excel
  • Excel for Accounting
  • Excel Sheet
  • Excel Formula

Teachers and trainers (1)

Frontier Education

Frontier Education

Education

Course programme

Microsoft Excel PivotTable is powerful tool to analyse, manipulate and visualise data.

Excel can feel complex-particularly PivotTable function, which is widely used in business and not easily explained.

It is a tool to automatically sort data from one table and put in another, PivotTable.

Excel PivotTable used almost all type of real life applications from entry level jobs or most senior roles.

Excel Pivot Table

£ 19 VAT inc.