Skip to content
Sidéral Technologies

Excel & productivity

Excel for Human Resources

Build reliable HR spreadsheets: headcount, absenteeism, payroll and social reporting.

HR teams produce a lot of Excel reporting, often from mixed HRIS exports. This training covers concrete HR cases: headcount, movements, absenteeism, social indicators — not generic Excel.

  • Intermediate
  • 2 days / 14 hours
  • In person
  • Remote
  • In-company

Audience: HR · Payroll · Social control

Request a sessionTrain my teamGet notified
Level
Intermediate
Duration
2 days / 14 hours
Format
In person · Remote · In-company
Modalities
Strong interaction and workshops. · A program dedicated to one organization.
Audience
HR · Payroll · Social control
Language
French or English
Prerequisites
Excel practice.

Why this training?

HR teams produce a lot of Excel reporting, often from mixed HRIS exports. This training covers concrete HR cases: headcount, movements, absenteeism, social indicators — not generic Excel.

  • Raw HRIS exports
  • Unstable indicators
  • Personal files that cannot be shared
  • Structured HR tables
  • Repeatable indicators
  • Less re-keying

Learning objectives

  • Structure usable headcount tracking.
  • Build absenteeism and movement indicators.
  • Prepare recurring HR reporting.
  • Reduce duplicate entry.

Skills developed

After the training, you will be able to:

  • Organize an HR file
  • Calculate simple indicators
  • Produce a monthly report

Audience

HR managers, HR officers, social-control analysts, HR managers and professionals producing social reports.

Prerequisites

  • Excel practice.

Curriculum

Practice at the core of the path

  • Headcount and movement tracking
  • Absenteeism table
  • Monthly reporting from a payroll / HRIS export

Teaching method

HR capstone case, exercises on typical files, demonstration then guided rebuild of the tables.

  • Business files
  • HR cases
  • Exercises

Tools used

  • Excel
  • Power Query

Format

  • In person

    2 days / 14 hours

    Strong interaction and workshops.

    On site or in a classroom, including Abidjan when in-person is selected.

  • Remote

    2 days / 14 hours

  • In-company

    2 days / 14 hours

    A program dedicated to one organization.

Assessment

  • Practical case

Deliverables

  • HR templates
  • Materials

Attestation

Certificate of attendance

Sessions

No public session is currently scheduled.

Get notified of a future sessionRequest an in-company session

FAQ

Continue your progression

  • Excel & productivityIntermediate

    Advanced Excel & automation

    Structure, clean and automate Excel files for reliable reporting.

    3 days / 21 hours · In person · Remote · In-company

    Controllers

    • Import and clean data
    • Transform with Power Query
    • Build a simple model
    View training
  • Data & BIIntermediate

    Power BI — from data to dashboard

    Go from a data extract to a readable, actionable Power BI dashboard.

    3 days / 21 hours · In person · Remote · In-company

    Analysts

    • Import data
    • Transform
    • Build a model
    View training

This training is part of the path

Want to train several team members?

Run this training in my companyAdapt this training to my organization