Access courses

Excel Formulas Course

What will I learn?

Unlock the full potential of Excel for Business Intelligence with our in-depth Excel Formulas Course, tailored for Zambia. Get stuck in to analysing sales data, mastering key measurements, trends, and performance indicators. Improve your Business Intelligence approach with essential tools and ways of doing things. Learn advanced Excel skills, including pivot tables, data validation, and conditional formatting. Build powerful dashboards and tell visual stories with charts and graphs. Improve your report writing skills with best practice for presenting data and writing effective reports. Jona now and turn data into insights you can use.

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

Master Excel formulas: Improve data analysis using SUMIF, AVERAGEIF, and other formulas.

See data clearly: Design dashboards and create charts that tell a story.

Analyse sales trends: Find the important numbers and performance indicators.

Use BI tools properly: Put data analysis into your business plans.

Write reports that make sense: Show data clearly and tell a good story with visuals.

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.