Need Support? Tel: +971 4 361 6397
Home » Courses » Management & Leadership » Data Management, Manipulation & Analysis using Excel®

Data Management,
Manipulation
& Analysis
using Excel®

09 - 13 Jun 2019 Dubai, UAE $4,950 Register
01 - 05 Sep 2019 Dubai, UAE $4,950 Register
01 - 05 Dec 2019 Dubai, UAE $4,950 Register

Training Course Overview

Never before has data been so readily and freely available. From our daily commute, to our morning coffee, to our daily purchases to our business activities and personal achievements data is generated. The availability of such rich data set afford fabulous opportunities to solve problems and lead to improvements in all aspects of our lives, especially in commercial activities. Such problem solving traditionally involved sophisticated quantitative skills. However, on every desktop computer through the world lies an underutilised tool, that tool is Excel. In this COPEX training course you will learn to how to use Excel to query data, test hypothesis and solve sophisticated problems. By the end of the training course you will be conversant with 50+ Excel functions, a huge variety of charts and analysis tools.

Training Course Objectives

By attending this COPEX training course, you should achieve these goals:

  • Be familiar with 50+ Excel functions
  • Recognise the right chart for the right task
  • How to manipulate both textual and numerical data
  • Be able to analyse data using appropriate tools
  • Analyse relationships amongst variables and generate forecasts

Designed For

This COPEX training course is suitable for middle and senior managers who have responsibility for divisional or organizational success, as well as consultants and professionals who support them. For example:

  • Anyone with Line Manager Responsibility
  • HR Professionals
  • Oil and Gas, Energy and Telecom Team Engineers
  • Senior Finance Professionals
  • Board Level Executives and Non-Executives

Training Course Outline

Amongst a wide range of valuable topics, the following will be prioritised:

  • The Excel environment – How to become an advanced user
  • Analysing textual data using Excel functions
  • Analysing numerical data using Excel functions
  • Appropriate uses of pivot tables
  • Selecting the most appropriate function to suit the task
  • Selecting the right chart for the right task
  • Statistical analysis using the Data Analysis tool
  • Financial Analysis using Excel functions
  • Solver, goal seek and scenario analysis
  • Generating forecasts of important variables

The Certificate

  • COPEX Certificate of Attendance will be provided to delegates who attend and complete the course



Data Management,
Manipulation
& Analysis
using Excel®


Upcoming Dates

09 - 13 Jun 2019 in Dubai - UAE, $4,950

01 - 05 Sep 2019 in Dubai - UAE, $4,950

01 - 05 Dec 2019 in Dubai - UAE, $4,950


Training Course Overview

Never before has data been so readily and freely available. From our daily commute, to our morning coffee, to our daily purchases to our business activities and personal achievements data is generated. The availability of such rich data set afford fabulous opportunities to solve problems and lead to improvements in all aspects of our lives, especially in commercial activities. Such problem solving traditionally involved sophisticated quantitative skills. However, on every desktop computer through the world lies an underutilised tool, that tool is Excel. In this COPEX training course you will learn to how to use Excel to query data, test hypothesis and solve sophisticated problems. By the end of the training course you will be conversant with 50+ Excel functions, a huge variety of charts and analysis tools.

Training Course Objectives

By attending this COPEX training course, you should achieve these goals:

  • Be familiar with 50+ Excel functions
  • Recognise the right chart for the right task
  • How to manipulate both textual and numerical data
  • Be able to analyse data using appropriate tools
  • Analyse relationships amongst variables and generate forecasts

Designed For

This COPEX training course is suitable for middle and senior managers who have responsibility for divisional or organizational success, as well as consultants and professionals who support them. For example:

  • Anyone with Line Manager Responsibility
  • HR Professionals
  • Oil and Gas, Energy and Telecom Team Engineers
  • Senior Finance Professionals
  • Board Level Executives and Non-Executives

Training Course Outline

Amongst a wide range of valuable topics, the following will be prioritised:

  • The Excel environment – How to become an advanced user
  • Analysing textual data using Excel functions
  • Analysing numerical data using Excel functions
  • Appropriate uses of pivot tables
  • Selecting the most appropriate function to suit the task
  • Selecting the right chart for the right task
  • Statistical analysis using the Data Analysis tool
  • Financial Analysis using Excel functions
  • Solver, goal seek and scenario analysis
  • Generating forecasts of important variables

The Course Content


The Certificate

  • COPEX Certificate of Attendance will be provided to delegates who attend and complete the course


© 2018. Material published by Copex shown here is copyrighted. All rights reserved. Any unauthorized copying, distribution, use, dissemination, downloading, storing (in any medium), transmission, reproduction or reliance in whole or any part of this course outline is prohibited and will constitute an infringement of copyright.

Send to Colleague

© 2018. Material published by Copex shown here is copyrighted.

All rights reserved. Any unauthorized copying, distribution, use, dissemination, downloading, storing (in any medium), transmission, reproduction or reliance in whole or any part of this course outline is prohibited and will constitute an infringement of copyright.





Sending your message. Please wait...

Send Successfully

There was a problem sending your message. Please try again.

Please complete all the fields in the form before sending.

Print Page

© 2018. Material published by Copex shown here is copyrighted.

All rights reserved. Any unauthorized copying, distribution, use, dissemination, downloading, storing (in any medium), transmission, reproduction or reliance in whole or any part of this course outline is prohibited and will constitute an infringement of copyright.








Sending your message. Please wait...

Close

There was a problem sending your message. Please try again.

Please complete all the fields in the form before sending.

Download PDF

© 2018. Material published by Copex shown here is copyrighted.

All rights reserved. Any unauthorized copying, distribution, use, dissemination, downloading, storing (in any medium), transmission, reproduction or reliance in whole or any part of this course outline is prohibited and will constitute an infringement of copyright.







Sending your message. Please wait...

Close

There was a problem sending your message. Please try again.

Please complete all the fields in the form before sending.

Give Us a Call Now to Get Started +971 4 361 6397