Skip to content
Roaya

Pivot Table Training Kit

  • 2 days
  • 4 sessions
  • 120 min / session
  • 8 hours in total
  • Intermediate level
  • Arabic

Description

The kit provides comprehensive training content that helps trainers and teachers deliver specialised programmes in data analysis using Excel, by learning about the capabilities of Pivot Tables in organising large data and turning it into clear reports and accurate indicators.

It also supports the trainer in preparing applied activities that help develop participants' skills in creating and customising pivot tables to suit the requirements of different work environments.

The kit covers methods of using filters, calculations, grouping, and refreshing data to efficiently extract analytical reports, which enables the trainer to design practical training experiences that enhance the speed of completing work and the accuracy of data-driven decision-making.

Objectives

  • Learning about the concept of Pivot Tables and their importance in analysing large data using Excel.
  • Creating pivot tables and organising and summarising data effectively according to different analysis needs.
  • Using filters, calculations and grouping features to prepare accurate reports that support decision-making.
  • Refreshing and customising pivot tables and extracting performance indicators and analysing data efficiently and professionally.
  • Employing Excel skills in preparing practical applications that help improve the quality of reports and raise work efficiency.

Who it's for

Finance and admin staff, data analysts, and Excel users.

Training sessions

  • Introductions and programme opening
  • Training video
  • What is a pivot table?
  • How a pivot table works
  • Pivot table basics
  • How to add a pivot table
  • Training activity

Version 1 — updated 16 October 2026

We keep the content up to date; every download gets the latest version.

  • Package
    Tech & AI

    Professional Portfolio Training Kit

    A kit on building a professional e-portfolio: its definition, importance and benefits, its components and content, the requirements for designing it, the stages of preparing it, and the standards for producing it well.

    2 sessions
  • Package
    Tech & AI

    Building Websites Training Kit

    A kit on building websites for education, covering the importance and benefits of integrating technology into teaching, and the practical steps to create a Gmail account and build a website on Google Sites.

    2 sessions
  • Package
    Tech & AI

    Wizer.me Interactive Worksheets Training Kit

    A kit on creating interactive worksheets with Wizer.me: strategies and requirements for integrating technology into the curriculum, the profile of the tech-savvy student and teacher, and the practical steps for registering, building, grading and giving feedback on worksheets.

    4 sessions
  • Package
    Tech & AI

    Computer Fundamentals Training Kit

    A kit on computer fundamentals: the components of a computer, how to maintain it, the factors that cause damage and how to prevent them, and corrective maintenance.

    2 sessions
  • Package
    Tech & AI

    Designing Electronic Files Using OneNote Training Kit

    A kit on designing and managing files with Microsoft OneNote: its features and benefits, how to set up and search a file, save and sync notes across devices, tag notes, and export them as PDF.

    2 sessions
  • Package
    Tech & AI

    Augmented Reality in Education Training Kit

    A kit on using augmented reality and hologram technology in education, covering how the technology works and practical steps for creating and scanning AR content with HP Reveal.

    2 sessions
  • Package
    Tech & AI

    Keynote Software Training Kit

    A kit on using Keynote to design professional, interactive presentations, applying multimedia in education and training to produce engaging and effective visual content.

    4 sessions
  • Package
    Tech & AI

    E-Training Training Kit

    A professional kit explaining e-training concepts, designing digital training programmes, managing content, and using e-training platforms and digital learning tools to deliver an effective training experience.

    10 sessions
  • Package
    Tech & AI

    Effective Online Meetings Skills Training Kit

    A kit on managing online meetings that develops skills in planning, running and documenting virtual meetings using modern communication tools such as Zoom, Skype and GoToMeeting.

    10 sessions
  • Package
    Tech & AI

    ZipGrade Programme Training Kit

    A kit that equips trainers to teach ZipGrade and professional mobile test grading, with a presentation and activities covering installation, answer-key setup and automated marking with practical, simplified steps.

    2 sessions

Frequently asked questions

Finance and admin staff, data analysts, and Excel users.

Files coming soon