Access courses

Excel Course For Data Analysis

What will I learn?

Bula maatla a Excel go sekaseka data ka thuto ya rona e e tseneletseng e e diretsweng batho ba ba itseng thata ka Business Intelligence. Ithute bokgoni jo bo tlhokegang jaaka go dira le go sekaseka ditšhupo (pivot tables), go tlhotlha le go tlhopha data, le go dirisa ditiro tse di kwa godimo jaaka VLOOKUP le HLOOKUP. Tokafatsa bokgoni jwa gago jwa go supa data ka ditšhate tse di dirilweng go ya ka fa o batlang ka teng mme o ithute go itirisa ditiro ka di-macro. Laola le go aba difaele tsa Excel ka tshireletsego fa o ntse o buisana ka botlalo ka dintlha tse o di lemogileng. Godisa bokgoni jwa gago jwa go sekaseka data 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

Ithute Ditšhupo (Pivot Tables): Sekaseka data e e rarakaneng bonolo e bile ka nepagamo.

Dira Ditšhate Tse Di Fetofetogang: Supa metsamao ya data ka ditšhate tsa Excel tse di dirilweng go ya ka fa o batlang ka teng.

Itirise Ditiro ka Di-Macro: Oketsa bokgoni ka go itirisa ditiro tse di ipoeletsang.

Sireletsa Data: Sireletsa le go laola difaele tsa Excel gore le dire mmogo.

Ntsha Dintlha Tse di Mosola: Lemoga dipaterone mme o buisane ka dintlha tse di theilweng mo data.

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.