Access courses

Excel Expert Course

What will I learn?

Improve your Business Intelligence skills with our Excel Expert Course, tailored for Zambian professionals aiming to become data experts. Explore how to create dashboards that are interactive, include important business measures, and analyse data using PivotTables. Learn how to bring data into Excel, clean it up, and manage it properly. Also, discover how to use conditional formatting to show important trends and advanced lookup functions to find specific information. See how to display data visually with PivotCharts and perform thorough statistical analysis, all delivered in a clear and useful manner.

Apoia's Unique Offerings

Online courses with lifetime access
Certificate aligned with educational standards
Printable PDF summaries
24/7 online support
Select and organise the chapters you wish to study
Set your own course workload
Instant feedback on practical activities
Study at your convenience, no internet required

Develop your skills

Enhance your practical skills listed below

Design interactive dashboards to clearly show data insights.

Master importing and cleaning data for easy data management.

Create and customise PivotTables for advanced data analysis.

Use conditional formatting to highlight key data trends.

Use advanced lookup functions to find specific data easily.

Suggested summary

Workload: between 4 and 360 hours

Before starting, you can change the chapters and workload.

  • Choose which chapter to start with
  • Add or remove chapters
  • Increase or decrease the course workload

Examples of chapters you can add

You will be able to generate more chapters similar to the examples below

This is a free course aimed at personal and professional development. It is not equivalent to a technical, undergraduate, or postgraduate course, but provides practical and relevant knowledge for your professional journey.