menu

logo

user search
cart 0

Credit Control and FinanceData Analysis with Pivot Tables


  • Back
  • United Arab EmiratesDubai
  • 25 - 29 Dec 2023
  • 20 CPD hours
  • $4,900.00
  • Overview
  • Course Outline
  • Scheduled 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

2+1Offer

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
  • September
  • December

Location

  • All
  • Dubai
  • Istanbul
  • London
  • Finance

5 Days 20 CPD hours

Register Now
London

London

$4,500.00

  • Finance

5 Days 20 CPD hours

Register Now
Istanbul

Istanbul

$4,900.00

  • Finance

5 Days 20 CPD hours

Register Now
Dubai

Dubai

$4,900.00

Speak to our friendly training advisor today

Employees of professional or formally regulated bodies are generally expected to have CPD accredited training. This type of accreditation ensures that the training is knowledgeable, informed and constantly updated. It ensures our standards as a company are kept high and consistent.

  • 100000+ Members in..
  • 59+ Countries With..
  • 3000+ Chapters ..
Register Now

Why Choose London Training

  • 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

Modern Methods: Financial Accounts and...

5 Days course 20 CPD hours

Upcoming 25 - 29 Dec 2023

View Details & Register
Dubai

Dubai

$4,900.00

  • Finance

Financial Management for Project Development

5 Days course 20 CPD hours

Upcoming 18 - 29 Dec 2023

View Details & Register
Dubai

Dubai

$4,900.00

  • Finance

Cost Management

5 Days course 20 CPD hours

Upcoming 18 - 29 Dec 2023

View Details & Register
Dubai

Dubai

$4,900.00

×
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 Arab EmiratesDubai
  • 25 - 29 Dec 2023
By submitting this form you agree to our Terms and Conditions and Privacy Policy.
x
Data Analysis with Pivot Tables

Request more information

  • United Arab EmiratesDubai
  • 25 - 29 Dec 2023
By submitting this form you agree to our Terms and Conditions and Privacy Policy.

Our Clients

call
Processing

Loading...