Data Analysis using Excel


May 6 to May 7 Abu Dhabi, United Arab Emirates Register
June 24 to June 25 Dubai, United Arab Emirates Register
September 23 to September 24 Dubai, United Arab Emirates Register
November 14 to November 15 Abu Dhabi, United Arab Emirates Register


This course focuses on Excel features that are key to business reporting!, It is a course that identifies specific purposes that will help delegates to derive meaningful, actionable results from advanced statistical, and information formulas. Accomplish more, faster with an array of formulas, which perform calculations on a series of values simultaneously. Manipulate PivotTable data with greater precision using custom grouping and custom calculations.


  • Delegates will learn how to create and analyse reports
  • Keep your finger on the pulse of the business
  • Effectively track sales against targets
  • Maximise Return on Investment (ROI) by keeping track of campaigns.
  • Generate Statistical information


Below is an example of the course content. The content can be tailored to meet the exact requirements of the client.

Basic Functions
  • Smart Lookup
  • Sorting, Subtotaling and Filtering Data
  • Data Validation
  • What-If Data Analysis
  • Forecasting Sheet
  • Macros
Formulas and Functions
  • Data Consolidation
  • Conditional Formatting Worksheet Protection
  • Managing and Preparing Data
  • Using Cell References
  • Lookup, Text and Logical Functions
  • Statistical and Mathematical Functions
  • Date and Time Functions
Pivot Tables and Pivot Charts
  • Pivot Table Basics (new search field added to Excel 2016)
  • Pivot Table Options
  • Formatting a Pivot Table (new Automatic Time Grouping added to Excel 2016)
  • Calculated Items and Fields
  • Sort and Filter a Pivot Table (new Multi Select Slicer added to Excel 2016)
  • Consolidated Pivot Table
  • Pivot Charts and Sparklines


The foundation of our training is anchored in activity-based experiential learning. This methodology takes into consideration different learning and communication styles, and more importantly language and cultural differences. It is through active participation that the adoption and application of theory is expedited.

Our training team pays careful attention to planning and designing effective instructional methods essential for the transfer of knowledge. It is the creative skill of our management trainers and consultants that reveal untapped skills of the delegates through:

  • Group discussion
  • Individual and syndicate activities
  • Individual and group tasks
  • Case studies
  • Role plays
  • Audio and video evaluation
  • Action planning
  • Experiential learning games
  • Presentations

Recent Post

callback request

Your Name

Contact Number




How did you hear about us?

Abu Dhabi

P.O. Box 44705, Abu Dhabi,
United Arab Emirates
Phone: +971 2 6740340
Fax: +971 2 6743554

Tax Registration Number:
for VAT purposes, only in the UAE


P.O. Box 334058, Dubai,
United Arab Emirates
Phone: +971 4 2566414
Fax: +971 4 2566424

Tax Registration Number:
for VAT purposes, only in the UAE