Access courses

Excel Formulas Course

What will I learn?

Notlolla matla a Excel bakeng sa Bohlale ba Khoebo ka Khoso ea rona e felletseng ea Lipalo tsa Excel. Ithute ka tlhahlobo ea data ea thekiso, u ithute lintlha, mekhoa le li-KPI. Ntlafatsa leano la hau la BI ka lisebelisoa le mahlale a bohlokoa. Ithute mekhoa e tsoetseng pele ea Excel, ho kenyeletsoa litafole tsa pivot, netefatso ea data le ho fomata ka maemo. Theha li-dashboard tse nang le tšusumetso le lipale tse bonoang ka lichate le lichate. Holisa litsebo tsa hau tsa tlaleho ka mekhoa e metle bakeng sa nehelano ea data le ho ngola litlaleho ka katleho. Kena hona joale ho fetola data hore e be lintlha tse ka sebelisoang.

Apoia's Unique Features

Accessible online course with lifetime access
Certificate aligned with educational standards
Printable PDF summaries
Online support available at all times
Select and arrange the chapters you wish to study
Customize your course workload
Instant feedback on practical activities
Learn at your own pace, no internet required

Develop skills

Enhance your practical skills as listed below

Ithute lipalo tsa Excel: Ntlafatsa tlhahlobo ea data ka SUMIF, AVERAGEIF, le tse ling.

Bona data ka katleho: Rala li-dashboard 'me u thehe lichate tse nang le tšusumetso.

Hlahloba mekhoa ea thekiso: Hlahloba litekanyo tsa bohlokoa le li-performance indicators.

Sebelisa lisebelisoa tsa BI: Kopanya tlhahlobo ea data maano a khoebo.

Etsa litlaleho tse qobellang: Hlahisa data ka ho hlaka le pale ea pono.

Suggested summary

Workload: between 4 and 360 hours

Before starting, you can adjust the chapters and workload.

  • Choose your starting chapter
  • Add or remove chapters
  • Alter the total course workload

Examples of chapters you can include

You'll be able to generate additional chapters similar to 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 provides practical and relevant knowledge for your career.