Advanced Excel Dashboards Training

Finance, Grants, Compliance & Risk · 5 Days

Course Overview

A great dashboard answers management questions at a glance. Excel can deliver this without new software, if the data and layout are right. This course covers data preparation, Power Query, PivotTables, slicers, dynamic charts, KPI visuals and design. Participants build a complete dashboard from raw data.

Who Should Attend

  • Finance Analysts
  • Accountants
  • Data Officers
  • Managers
  • M&E Officers
  • Sales Analysts

Learning Objectives

  • Plan a dashboard
  • Prepare data with Power Query
  • Build data models
  • Use PivotTables and slicers
  • Create dynamic charts
  • Build KPI visuals
  • Apply dashboard design
  • Share and protect dashboards

Key Takeaways

Course Curriculum

1

Dashboard Planning

2

Preparing Data

3

Data Models

4

PivotTables and Slicers

5

Dynamic Charts

6

KPI Visuals

7

Design Principles

8

Delivering Dashboards

Requirements

Participants should have intermediate Excel skills.

Certification

Participants who complete the Advanced Excel Dashboards Training receive an Ecotrio Certificate of Completion, awarded by Ecotrio Impact Growth and Development Centre (EIGDC) and recognized by employers across the region as evidence of applied, job-ready competence.

Upcoming Sessions

LocationDatesMode
Cairo, Egypt 16 Nov 2026 – 20 Nov 2026 Classroom Register →
Zanzibar, Tanzania 16 Nov 2026 – 20 Nov 2026 Classroom Register →
Live Virtual 16 Nov 2026 – 20 Nov 2026 Online Register →
Accra, Ghana 16 Nov 2026 – 20 Nov 2026 Classroom Register →
Dar es Salaam, Tanzania 16 Nov 2026 – 20 Nov 2026 Classroom Register →
Pretoria, South Africa 16 Nov 2026 – 20 Nov 2026 Classroom Register →
Mombasa, Kenya 16 Nov 2026 – 20 Nov 2026 Classroom Register →
Nairobi, Kenya 23 Nov 2026 – 27 Nov 2026 Classroom Register →
Kampala, Uganda 23 Nov 2026 – 27 Nov 2026 Classroom Register →
Johannesburg, South Africa 23 Nov 2026 – 27 Nov 2026 Classroom Register →
Nairobi, Kenya 07 Dec 2026 – 11 Dec 2026 Classroom Register →
Kampala, Uganda 07 Dec 2026 – 11 Dec 2026 Classroom Register →

Ready to Register for Advanced Excel Dashboards Training?

See full pricing, exact upcoming dates across Egypt, Tanzania, Ghana, and secure your seat online in minutes.

Book This Training →