Access courses

Excel Spreadsheet Course

What will I learn?

Itseng Excel sentle go dirisa mo go tsa kgwebo ka khoso ya rona e e tseneletseng, e e diretsweng batho ba ba dirang go thusa go tokafatsa bokgoni jwa bone jwa go tsamaisa data. Ithuteng go tsenya data ka bonako, itseng difomula tse di botlhokwa jaaka VLOOKUP le HLOOKUP, mme o tlhatlhobe tshekatsheko e e kwa godimo ya data ka PivotTables. Ithuteng go tlhama dichate le dikerafo tse di nang le mosola, dirisang conditional formatting, mme o tlhomamise boammaaruri jwa data ka go kwala tshedimosetso yotlhe ka kelotlhoko. Godisang kitso ya lona ya BI ka dithuto tse di mosola, tsa maemo a a kwa godimo tse di diretsweng go dirisiwa ka bonako.

Apoia's Unique Advantages

Online and lifelong course
Certificate aligned with educational standards
PDF summaries for downloads
Virtual assistant always available
Select and arrange the chapters you wish to study
Customize your course workload
Instant feedback on practical activities
Study anytime, without requiring internet access

Develop skills

Enhance the development of the practical skills listed below

Itseng go tsenya data sentle: Oketsang lebelo le boammaaruri mo go tsenyeng data mo Excel.

Go itse Excel interface: Tsamayang ka bokgabane mo ditirong tsa Excel.

Difomula tse di kwa godimo: Dirisang VLOOKUP, HLOOKUP, le logical functions.

Go supa data ka pono: Tlhamang dichate le dikerafo tse di nang le mosola go bona tshedimosetso.

Kitso ya PivotTables: Sekasekang le go sobokanya data ka bokgabane.

Suggested summary

Workload: between 4 and 360 hours

Before starting, you can modify the chapters and the workload.

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

Examples of chapters you can add

You’ll be able to generate more chapters like the examples below

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