Access courses

Advanced Excel Course

What will I learn?

Oketsa bokgoni jwa gago jwa Business Intelligence ka Kosi ya rona e e Tsweletseng Pele ya Excel, e e diretsweng batho ba ba itseng tiro ba ba batlang go itse thata ka go sekaseka data le go e bontsha ka tsela e e bonalang. Ithute mekgwa e e kwa godimo jaaka Excel Solver go bona dipholo tse di botoka, ditafole tsa pivot, le go sobokanya data. Tokafatsa bokgoni jwa gago jwa go bontsha data ka ditšhate, dikerafo, le diboto tsa tshedimosetso. Ithute mekgwa ya botlhokwa ya go phepafatsa data le ditiro tsa Excel, go akaretsa VLOOKUP le diteme tse di reng IF. Nna le bokgoni jwa go tlhaloganya ditsela tse dilo di fetogang ka teng, go tlhagisa tlhaloganyo, le go tlhama dipego tsa kgwebo tse di kgatlhang. Ikwadise jaanong go fetola data ya gago go nna botlhale jo bo ka dirisiwang.

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 Excel Solver go dira ditshwetso tse di siameng.

Tlhama ditafole tsa pivot tse di fetofetogang go bona tlhaloganyo mo dateng.

Dira diboto tsa tshedimosetso le dipontsho tse di nang le seriti.

Phepafatsa le go rulaganya data go sekaseka ka nepagamo.

Tlhamela dintlha tse di ka dirisiwang le dikgakololo.

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.