Excel Formulas Course
What will I learn?
Tswinya maatla a Excel go tlhaloganya kgwebo ka botlalo (Business Intelligence) ka Khoso ya rona e e feletseng ya Ditsela tsa go Dirisa Difomula tsa Excel. Ithute go sekaseka data ya thekiso, go itse dipalo tsa botlhokwa, mekgwa, le dipalo tse di supa katlego (KPIs). Tokafatsa togamaano ya gago ya BI ka didirisiwa le boranyane jo bo botlhokwa. Ithute mekgwa e e kwa godimo ya Excel, go balela ditafole tsa pivot, go tlhomamisa data, le go rulaganya ka mokgwa o o rileng (conditional formatting). Dira diboto tsa tshedimosetso (dashboards) tse di nang le mosola le dipale tsa pono (visual stories) ka dichate le dikerafo. Godisa bokgoni jwa gago jwa go bega ka mekgwa e e siameng ya go tlhagisa data le go kwala dipego tse di nang le mosola. Ikopanye le rona jaanong go fetola data go nna tshedimosetso e e ka dirisiwang.
Apoia's Unique Advantages
Develop skills
Enhance the development of the practical skills listed below
Itsese ditsela tsa go dirisa difomula tsa Excel: Tokafatsa go sekaseka data ka SUMIF, AVERAGEIF, le tse dingwe.
Tlhagisa data ka pono e e nang le mosola: Thama diboto tsa tshedimosetso mme o dire dichate tse di nang le mosola.
Sekaseka mekgwa ya thekiso: Lemoga dipalo tsa botlhokwa le dipalo tse di supa katlego.
Dirisa didirisiwa tsa BI: Kopanya go sekaseka data mo ditogamaanong tsa kgwebo.
Kwala dipego tse di gogelang: Tlhagisa data ka phepafalo le pale ya pono.
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.