Corporate training in the Gulf, London, Europe & Asia since 2015
+44 7462 102778[email protected]WhatsAppالعربية
Enquire now
CoursesSubjectsVenuesIn-House TrainingWhy ARUKContactالعربيةEnquire now
DI-009

Data Management, Manipulation & Analysis using Excel®

Intensive 5-day course · English, Arabic & European languages

Divisional heads, finance professionals and engineering leads study practical spreadsheet computing across this five-day MS Excel programme. Delegates learn over 50 Excel functions covering text parsing, multi-criteria counting, VLOOKUP, HLOOKUP and date arithmetic, then apply descriptive statistics, pivot tables, Solver optimisation and scenario modelling to solve operational problems.

Classroom

Public courses in our cities

  • 26–30 Oct 2026Manama£3,080 + VAT
  • 9–13 Nov 2026Barcelona£3,080 + VAT
  • 23–27 Nov 2026Dubai£4,200 + VAT
  • 14–18 Dec 2026Frankfurt£2,600 + VAT
  • 28 Dec – 1 Jan 2026Riyadh£4,200 + VAT
  • 4–8 Jan 2027Barcelona£3,080 + VAT
Show 23 more dates
  • 18–22 Jan 2027Malaga£3,080 + VAT
  • 1–5 Feb 2027Paris£3,600 + VAT
  • 15–19 Feb 2027Sarajevo£3,400 + VAT
  • 8–12 Mar 2027Frankfurt£2,600 + VAT
  • 22–26 Mar 2027Dubai£4,200 + VAT
  • 12–16 Apr 2027Barcelona£3,080 + VAT
  • 26–30 Apr 2027Riyadh£4,200 + VAT
  • 10–14 May 2027Frankfurt£2,600 + VAT
  • 24–28 May 2027Doha£4,200 + VAT
  • 7–11 Jun 2027Barcelona£3,080 + VAT
  • 21–25 Jun 2027Geneva£4,200 + VAT
  • 5–9 Jul 2027Paris£3,600 + VAT
  • 19–23 Jul 2027Abu Dhabi£4,200 + VAT
  • 9–13 Aug 2027Frankfurt£2,600 + VAT
  • 23–27 Aug 2027Cairo£2,280 + VAT
  • 13–17 Sep 2027Barcelona£3,080 + VAT
  • 27 Sep – 1 Oct 2027Jeddah£4,200 + VAT
  • 11–15 Oct 2027Frankfurt£2,600 + VAT
  • 25–29 Oct 2027Singapore£4,200 + VAT
  • 1–5 Nov 2027Barcelona£3,080 + VAT
  • 15–19 Nov 2027Muscat£3,080 + VAT
  • 6–10 Dec 2027Paris£3,600 + VAT
  • 20–24 Dec 2027Casablanca£2,280 + VAT

Group discount: 2 delegates 20% · 3 delegates 35% · 5 or more delegates 50%

Can't make these dates? We can run this course for your team on dates that suit you. Ask for custom dates · In-house options

Online (live)

With a trainer, on dates to suit your team

This course can be taught live online by a trainer, in English, Arabic or any European language, for one person or a whole team.

£1,850 + VAT

Group discount: 2 delegates 20% · 3 delegates 35% · 5 or more delegates 50%

Special requests

Tailor this course

Pick what you want changed and we’ll come back with a proposal and price.

Special request

Data Management, Manipulation & Analysis using Excel®

What would you like to change? (pick any)
or

Course overview

Modern enterprises generate massive transactional and operational records daily. While specialised analytics software exists, standard desktop spreadsheets remain the most accessible business calculation platform. MS Excel contains extensive analytical capability that frequently remains underused. The course transforms everyday spreadsheet users into capable quantitative analysts.

Structured over five instructional days, the curriculum builds systematic competence from foundational mechanics to advanced statistical calculation. Delegates explore more than 50 MS Excel functions, including text manipulation tools like FIND, LEN, LEFT and RIGHT, alongside conditional formulas such as COUNTIF, COUNTIFS and SUMIF. They configure lookup architectures, manage date series using YEAR, MONTH and YEARFRAC, and assemble interactive pivot tables.

Delegates run descriptive statistics, build histograms, analyse dependencies and execute optimisation routines using Solver. The sessions conclude with multi-cell scenario planning workflows.

Course objectives

By the end of the course, delegates will be able to:

  1. Demonstrate operational fluency across more than 50 MS Excel calculation functions
  2. Select and configure appropriate chart types for specific reporting scenarios
  3. Manipulate and cleanse textual strings and numerical datasets in MS Excel
  4. Execute statistical evaluations and variance analyses using spreadsheet tools
  5. Analyse relationships between business variables and construct predictive forecasts

Who should attend

This course suits:

  • Operational managers with line management responsibilities
  • HR professionals and workforce planning analysts
  • Engineers across the oil, gas, energy and telecommunications sectors
  • Senior finance professionals and management accountants
  • Board-level executives and corporate directors

Daily agenda

  1. Day 1

    The MS Excel Environment and Core Mechanics

    • Understanding cell referencing modes, cell formatting and formula syntax
    • Structural differences between workbooks and worksheets
    • Efficient clipboard management: copying, cutting and pasting workflows
    • Distinguishing between left-click selections and right-click contextual menus
    • Using Paste Special options for values, formats and formula operations
    • Constructing foundational business charts and plots
  2. Day 2

    Text Manipulation and Conditional Formulas

    • Parsing text strings using FIND, LEN, LEFT, RIGHT and the concatenation operator
    • Conditional counting and summation using COUNTA, COUNTIF, COUNTIFS and SUMIF
    • Basic summary metrics including Max and Average calculations
    • Filtering tabular data, multi-level sorting and conditional formatting rules
    • Plotting bivariate relationships using scatter diagrams
  3. Day 3

    Lookup Architectures, Dates and Pivot Tables

    • Retrieving tabular data with VLOOKUP and HLOOKUP functions
    • Calculating temporal intervals using date functions YEAR, MONTH, DAY and YEARFRAC
    • Selecting appropriate chart formats to present comparative business data
    • Constructing dynamic summary reports with Pivot tables
  4. Day 4

    Statistical Analysis and Distribution Modelling

    • Calculating central tendency measures: mean, mode and median in MS Excel
    • Distinguishing standard deviation and variance functions across sample and population data
    • Evaluating variable inter-dependency and correlation in MS Excel
    • Constructing frequency distributions and drawing histograms in MS Excel
    • Deploying automated statistical routines within Data Analysis toolpak functions
  5. Day 5

    Scenario Planning, Optimisation and Reporting

    • Assigning and managing named ranges in MS Excel
    • Linking dynamic cells to execute what-if and scenario analysis
    • Solving constrained mathematical problems using the Solver tool
    • Formatting advanced charts and visual summaries for executive audiences
    • Exporting and sharing MS Excel calculation outputs across other office application formats

Certificate

Every delegate who completes the course receives an ARUK Training Certificate of Attendance.

Frequently asked questions

How do I register?

Choose a date and city in the schedule and press Register, or send us an enquiry. Our team confirms your place and sends an invoice.

Are fees shown with VAT?

Fees are shown per delegate and exclude VAT, which is added to the invoice where applicable.

Can this course be delivered for our team only?

Yes. Any ARUK course can be delivered in-house at your premises, in a meeting room we book for you, or 1-to-1.

Is this course available online?

Yes. We run it live online with a trainer, on dates that suit your team, for £1,850 + VAT per delegate.

Is there a group discount?

Yes. 20% for 2 delegates, 35% for 3 delegates and 50% for 5 or more delegates on the same course.

Can the course be delivered in Arabic or another language?

Yes. Our courses can be delivered in English, Arabic or any European language, by a trainer who teaches in that language. Mention your preferred language when you register or enquire.

What certificate will I receive?

An ARUK Training Certificate of Attendance.

Related courses

Register

Data Management, Manipulation & Analysis using Excel®

Key booking terms (read before you register)
  • The full fee is paid in advance, before the course starts.
  • Cancel in writing 30 or more days before the start date (45 for in-house) for a refund. Later than that, the full fee is payable.
  • No refund for non-attendance or partial attendance.
  • Places are for the named delegate only; another person cannot attend instead.
  • Moving to another date or city is only possible if ARUK agrees in writing.
  • Travel, accommodation and visas are your responsibility. A refused visa does not change the cancellation terms.

booking terms and conditions

Get a quotation

Data Management, Manipulation & Analysis using Excel®