Data Analysis using Excel


No schedule at the moment

If you have three or more candidates or you would like to run this course as an in-house programme, please contact us.


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?

Follow us on:

Abu Dhabi

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


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