Access courses

Excel Basics Course

What will I learn?

Unlock the power of Excel with our Excel Basics Course, tailored for Business Intelligence professionals in Zambia. Learn how to create proper dashboards, design business reports, and use Excel for presentations that get results. Dig deep into data analysis with pivot tables, conditional formatting, and ways to summarise your data. Improve how you manage data by learning how to import, export, and clean it up. Make your data look good with charts, graphs, and sparklines. Become good at using formulas, functions, and special features like macros and What-If Analysis. Improve your BI skills today!

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

Learn to create dashboards that present data in a clear way.

Use pivot tables to quickly summarise data.

Use data validation to make sure your data is correct.

Design business reports that provide useful insights.

Use macros to automatically do tasks and save time.

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.