Why Choose this Training Course?

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.

What are the Goals?

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
Who is this Training Course 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
Course Outline
Day One: An Introduction to the MS Excel Environment
  • Cell referencing, cell formatting and entering formula
  • Workbooks versus Worksheets
  • Copy and pasting
  • Left click versus right click
  • Paste Special
  • Introductory charts
Day Two: Using MS Excel Functions for Fundamental Data Analysis
  • Use of text function, FIND(), LEN(), LEFT(), RIGHT() and &
  • Use of count functions, COUNTA(), COUNTIF(), COUNTIFS() and SUMIF()
  • Basic statistical functions, Max and Average
  • Filtering, sorting and use of conditional formatting
  • Scatter diagrams
Day Three: Intermediate MS Excel Functions
  • Use of VLOOKUP() and HLOOKUP()
  • Date functions, YEAR(), MONTH(), DAY(), YEARFRAC()
  • Selecting appropriate charts
  • Introduction to Pivot tables
Day Four: Carrying out Statistical Analysis using MS Excel
  • Using MS Excel to calculate mean, mode and median
  • The difference between the various standard deviation and variance function in MS Excel
  • Using MS Excel to examine inter-dependency
  • Drawing histograms in MS Excel
  • Introduction to Data Analysis functions
Day Five: What if and Scenario Analysis Using MS Excel
  • Naming cells in MS Excel
  • Linking cells together to undertake scenario analysis
  • Introduction to solver
  • Advanced charting
  • Sharing MS Excel output with other office formats
The Certificate
  • COPEX Certificate of Attendance will be provided to delegates who attend and complete the course
Data Management, Manipulation & Analysis using Excel®
  • Duration:5 days
  • Format:Classroom
  • Language: English
  • Certificate:Yes
London
29 Apr-03 May 2024
Fee: $5,950
Enroll Now
Al Ain
24-28 Jun 2024
Fee: $5,950
Enroll Now
Dubai
09-13 Sep 2024
Fee: $5,950
Enroll Now
Al Ain
07-11 Oct 2024
Fee: $5,950
Enroll Now
Dubai
02-06 Dec 2024
Fee: $5,950
Enroll Now
Are you Looking for a Specific Course in your Preferred Location?
View courses