Excel Advanced Pivot Tables

Frontier Education

Course

Online

£ 19 VAT inc.

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Level

    Beginner

  • Methodology

    Online

  • Duration

    Flexible

Subject excellence combined with the most modern online learning experience tailored to your career within the Excel Advanced Pivot Tables field.Through these Excel Advanced Pivot Tables ,you will gain a world-class knowledge and understanding with a focus on the advanced pivot tables ,using online learning materials .

Course 1: Excel Data Analysis

Excel Data Analysis: Merge, whatif analysis: what you need to know
Excel Data Analysis: Sumif, countif, averageif,: tailoring your approach to maximise impact
Excel Data Analysis: Mastering autosum relative absolute
Course 2: Excel Advanced Pivot Tables : Microsoft Excel-Pivot Tables, Pivot Charts, Slicers, and Timelines

Excel Pivot: Building basic maths
Excel Pivot: Managing the Field List
Excel Pivot:Changing the Calculation type with Value Field Settings
Excel Pivot:Growing your Pivot Table with Multiple Fields
Excel Pivot: Formatting the Pivot Table
Excel Pivot:Sorting and Filtering the Pivot Table

About this course

No prior knowledge or experience required

Questions and answers

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
  • MS Excel
  • Data analysis
  • How to use Excel
  • Microsoft Excel
  • Excel Sheet

Teachers and trainers (1)

Frontier Education

Frontier Education

Education

Course programme

This Excel Advanced Pivot Tables course addresses the knowledge, skills and application required to successfully apply excel advanced pivot tables skill in the relevant sector and take your career to the next level.

Excel is used almost everywhere in the world from office work to personal use.

In this course you will explore the merge, whatif analysis, sumif, countif, averageif, autosum relative absolute,pivot table with multiple fields,sorting and filtering the pivot table,dashboard with slicers, timelines and pivot charts and much more.You will learn how to meet challenges through efficient use of practises and technology.

This Excel Advanced Pivot Tables course addresses the knowledge, skills and application required to successfully apply excel advanced pivot tables skill in the relevant sector and take your career to the next level.

Excel is used almost everywhere in the world from office work to personal use.

In this course you will explore the merge, whatif analysis, sumif, countif, averageif, autosum relative absolute,pivot table with multiple fields,sorting and filtering the pivot table,dashboard with slicers, timelines and pivot charts and much more.You will learn how to meet challenges through efficient use of practises and technology.

Course 1: Excel Advanced Pivot Tables : Excel Data Analysis

Course 2: Excel Advanced Pivot Tables : Microsoft Excel-Pivot Tables, Pivot Charts, Slicers, and Timelines

Course 3: Excel Advanced Pivot Tables : Excel PowerQuery and PowerPivot

See related categories

Excel Advanced Pivot Tables

£ 19 VAT inc.

The best Excel courses

See all

See all