menu logo
user search
cart 0

Data Analysis with Pivot Tables

  • Overview ImageOverview
  • Outline ImageCourse Outline
  • Scheduled ImageScheduled Dates

Course Overview

Advances in technology have made it possible to store ever increasing amounts of data. Along with this, the need to analyse that data and gain actionable insight is greater than ever. Being able to harness the power of advanced PivotTable features and create Pivot Charts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyse, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved.

Objective:

Upon successful completion of this course, you will be able to use Excel advanced PivotTable functionality to analyse your raw data.

 

You will:

  • Prepare data for PivotTable reporting and create PivotTables from various data sources
  • Analyse Data Using PivotTables
  • Work with Pivot Charts
Register Now

Course Outline

Preparing Data and Creating PivotTables

  • Prepare Data.
  • Create a PivotTable from a Local Data Source.
  • Create a PivotTable from Multiple Local Data Sources.
  • Create a PivotTable from an External Data Source.

Analysing Data Using PivotTables

  • Summarize PivotTable Data
  • Organize PivotTable Data
  • Filter PivotTable Data
  • Format a PivotTable
  • Refresh and Change PivotTable Data

Working with Pivot Charts

  • Create a PivotChart
  • Manipulate PivotChart Data
  • Format a PivotChart
Register Now

Schedule & Fees

3 For 2Offer

Get the most out of group training with our special discount! Register 3 of your participants together on the same course and only pay for 2.

Select Month

  • All
  • June
  • September
  • December

Location

  • All
  • Dubai dubai icon
  • Istanbul istanbul icon
  • London london icon
  • Finance and Accounting

London

$4,900

London

Duration: 20 CPD hours (5Days)

date: 03 - 07 Jun 2024

Register Now
  • Finance and Accounting

Istanbul

$4,900

Istanbul

Duration: 20 CPD hours (5Days)

date: 23 - 27 Sep 2024

Register Now
  • Finance and Accounting

Dubai

$4,900

Dubai

Duration: 20 CPD hours (5Days)

date: 16 - 20 Dec 2024

Register Now
  • Finance and Accounting

Data Analysis with Pivot Tables

Duration:5 Days (20 CPD hours)

date:03 - 07 Jun 2024

London

London

$4,900


Register Now
  • Member

    100000+ Members in

  • Country

    59+ Countries with

  • Chapter

    3000+ Chapters

Register Now

Why Choose London Training For Excellence?

  • icon icon

    Reliability

    We will never cancel a confirmed booking

  • icon icon

    Support

    We offer around the clock support

  • icon icon

    Tailored

    We customise our courses to suit your personal learning needs

  • icon icon

    Quality

    Our courses are delivered by highly experienced industry experts

  • icon icon

    Recognition

    All our courses are accredited by the CPD Standards Agency

Frequently Asked Questions

How can training courses be used as a company benefit?

Training is hugely beneficial to both yourself and your company. It enables you to employ new technologies, increases your productivity and enables you to be more autonomous. Have a look here at our infographic on the importance of training and development!

How often do you update your course content to ensure relevancy?

Our course content is constantly reviewed and updated to ensure we stay up to date with all the latest trends. After every course is completed we review the feedback and improve the material where necessary.

Do you keep your classroom environment and instructional methodologies current with today’s real-world workplace?

Yes, we focus our training on ‘real-world’ scenarios and our trainers are all highly experienced and skilled in their relevant fields.

Are your courses eligible for professional certification?

Yes, we offer certification with all our courses, every course is entitled to CPD (Continuous Professional Development) hours which you can put towards your professional portfolio.

Related Courses

  • Finance

Planning and Analysis of Financial...

5 Days course 20 CPD hours

Upcoming 10 - 07 Jun 2024

View Details & Register
London

location London

$4,900

  • Finance

Advanced Strategies: Financial Control and...

5 Days course 20 CPD hours

Upcoming 10 - 07 Jun 2024

View Details & Register
London

location London

$4,900

  • Finance

Corporate Financial Restructuring...

5 Days course 20 CPD hours

Upcoming 10 - 07 Jun 2024

View Details & Register
London

location London

$4,900

×
Please provide us with some details below and we will send a copy of the course outlines direct to your inbox

Data Analysis with Pivot Tables

  • United KingdomLondon
  • calendar03 - 07 Jun 2024
By submitting this form you agree to our Terms and Conditions and Privacy Policy.
x
Data Analysis with Pivot Tables

Request more information

  • United KingdomLondon
  • 03 - 07 Jun 2024
By submitting this form you agree to our Terms and Conditions and Privacy Policy.

Our Clients

foundation wind energy icon petronas icon ministry of finance icon ministry of energy icon indonesia financial services authority icon federal mortgage bank of nigeria icon epexspot icon european central bank icon saudi aramco icon icrc icon undp banner public investment fund icon technology and security ecosystem icon
call
Processing

Loading...

×
By submitting this form you agree to our Terms and Conditions and Privacy Policy.