Skip to main content
IHETC Business

IHETC Executive Education

Advanced Excel

The tool everyone thinks they know, finally mastered.

Entry level
Short course
Award
Course attendance certificate
Duration
2 months
Actual work
8 h/week
Pace
Self-paced
Tuition
900 000 GNF in total

A short, dense programme to move from beginner use to analyst level: advanced formulas, pivot tables, automation and dashboards. Every session starts from a real working file.

Learning objectives

  • Handle lookup, conditional and array formulas
  • Build usable pivot tables
  • Automate repetitive tasks
  • Produce a dashboard leadership can actually read

Curriculum

40 hours · 4 credits

Year 140 hours

  1. Advanced formulas

    10 hours · 1 credits

    Lookups, nested conditions, error handling and structured references.

  2. Data analysis

    10 hours · 1 credits

    Cleaning, pivot tables, slicers and consolidating sources.

  3. Automation

    10 hours · 1 credits

    Conditional formatting, input validation and simple macros.

  4. Dashboards

    10 hours · 1 credits

    Choosing indicators, the right charts and a layout built for decisions.

Real prerequisite

What follows is assumed and will not be explained again. If most of it is foreign to you, this is not the right entry point — better to know now than at the final assessment.

Entering data, writing a sum and formatting a table. Basic formulas are not explained again.

Entry requirements

  • Open to all
  • Beginner-level spreadsheet familiarity

Career outcomes

  • Management assistant
  • Junior analyst
  • Administrative officer
  • Junior controller

Skills acquired

  • Formulas
  • Pivot tables
  • Macros
  • Dashboards

Executive Education

Other programmes in this school

Professional certification

Executive Education

Project Management Certificate

Frame, steer and deliver — a proven method, in six months.

  • Framing
  • Planning
  • Risk management
  • Scrum
6 months12 h/week
2 900 000 GNF in totalView curriculum
Professional certification

Executive Education

Applied AI for Business Certificate

Move from talking about AI to measurable gains.

  • AI use cases
  • Value analysis
  • Data governance
  • Change management
4 months12 h/week
3 200 000 GNF in totalView curriculum
Professional certification

Executive Education

Digital Transformation Certificate

Lead the digital change of a whole organisation.

  • Diagnosis
  • Roadmap
  • Governance
  • Change management
6 months12 h/week
3 600 000 GNF in totalView curriculum
Advanced Excel — IHETC