Create account

Early registration is open

Beginner · English

Data Analysis with Excel

You leave with an organised Excel file that turns training data into a summary and results you can interpret.

Supervised by ⁨Sultan Al-Mutairi⁩Presented by Maha, Ali and Khlood, ZERAX’s virtual trainers

270390

per learner

You save 120 SAR (30%)

  • The early-registration price is for whoever registers now. Nothing to pay today; we write the day the training opens.

About the training

The training takes you from an unorganised spreadsheet to a simple analytical report. You apply cleaning steps, functions and PivotTables, then show what the numbers mean and what cannot be concluded from them.

What you will learn

After this training, you will be able to:

  1. 1

    Clean data that has duplicates, missing values and inconsistent dates.

  2. 2

    Use conditional and aggregate functions to analyse specific questions.

  3. 3

    Build a PivotTable and a chart suited to comparison.

  4. 4

    Check the report's totals and explain three findings grounded in the data.

The programme

Five units of two hours each. Suggested pace: five meetings or learning sessions of two hours each, over one to two weeks, as the learner's schedule allows.

Level
Beginner
Language
English
Suggested pace
10 training hours including activities and assessment
  1. 1

    Preparing the data

    • Table structure and data types30 minutes
    • Sorting, filtering and removing duplicates30 minutes
    • Application and comprehension check: cleaning a training registration file1 hour

    2 hours

  2. 2

    Basic functions

    • Relative and absolute references and aggregate functions30 minutes
    • IF, SUMIF, COUNTIF and handling errors30 minutes
    • Application and comprehension check: calculating a summary by a given category1 hour

    2 hours

  3. 3

    Analysis with PivotTables

    • Building PivotTables and grouping data30 minutes
    • Changing levels of analysis and checking totals30 minutes
    • Application and comprehension check: analysing participation by college and period1 hour

    2 hours

  4. 4

    Presenting the results

    • Choosing the right chart and formatting the report30 minutes
    • Interpreting results and avoiding misleading comparisons30 minutes
    • Application and comprehension check: preparing a summary with three findings1 hour

    2 hours

  5. 5

    The applied project

    • Building a report from a raw file30 minutes
    • Testing formulas and reviewing report quality30 minutes
    • Application and comprehension check: submitting the analysis file and recommendations1 hour

    2 hours

What sets this training apart

  • (01)ZERAX Academy

    10 hours

    Of training, activities and assessment

    Suggested self-paced content on ZERAX, with virtual trainer support and feedback on activities

  • (02)ZERAX Academy

    5 units

    Each unit lasts two hours

    Short activities tied to situations at university and at the start of work

  • (03)ZERAX Academy

    Project

    Project submitted against a checklist

    A defined project that can be added to the learner's portfolio after review

The project and what you leave with

An Excel file with cleaned data, functions, a PivotTable, a chart and three documented findings.

Suggested completion method: finishing the lessons and activities and submitting the project against a checklist covering the accuracy, completeness and clarity of its presentation. ZERAX approves the assessment policy and the issuing of the completion certificate before launch.

Who this training is for

Basic knowledge of cells and rows, and a computer with Excel. Basic, widely compatible functions are used, allowing for differences in interface language.

  • Students of management, finance, engineering and other disciplines that work with spreadsheets.
  • Those heading into a training placement that requires reports and indicator tracking.

Who it is not for

  • Anyone who needs advanced financial models or VBA programming.

Before you start

Do I need to be advanced in Excel?

No, knowing how to enter data and move between cells is enough; the training starts from the analytical basics.

How much time do I need?

The training totals ten hours, including the lessons, the application work and the project; they can be spread over five sessions of two hours each.

Can it be offered to a university group?

A proposed offer can be prepared for the group; delivery, support and cost arrangements are agreed with ZERAX.

Register now and start at the early-registration price when the training opens

Register now and hold the early-registration price. Nothing to pay today; we write the day the training opens.

270 390
You save 120 SAR (30%)

ZERAX

Short trainings written by people who do the work, ending in a certificate in your name.

© 2026 ZERAX