Access courses

Excel Basics Course

What will I learn?

Notlolla matla a Excel ka Thupelo ea Motheo ea Excel, e etselitsoeng litsebi tsa Bohlale ba Khoebo (Business Intelligence). Ithute tsebo ea bohlokoa joalo ka ho theha li-dashboard tse matla, ho rala litlaleho tse hloahloa, le ho sebelisa Excel bakeng sa litlhahiso tse nang le tšusumetso. Kena ka har'a tlhahlobo ea data ka litafole tsa pivot, mokhoa oa ho hlophisa (conditional formatting), le mekhoa ea ho akaretsa. Ntlafatsa bokhoni ba hau ba taolo ea data ka lisebelisoa tsa ho kenya (import), ho ntša (export) le ho hloekisa. Phahamisa pono ea data ka lichate, likerafo le li-sparkline. Fumana tsebo e batsi ea liforomo, mesebetsi (functions), le likarolo tse tsoetseng pele joalo ka li-macro le Tlhahlobo ea Hore ho Etsahala'ng (What-If Analysis). Fetola tsebo ea hau ea BI kajeno!

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

Tseba ho theha li-dashboard bakeng sa tlhahiso ea data e nang le tšusumetso.

Sebelisa litafole tsa pivot bakeng sa kakaretso e sebetsang ea data.

Kenyelletsa netefatso ea data bakeng sa taolo e nepahetseng ea data.

Rala litlaleho tse hloahloa ho ntlafatsa leseli la khoebo.

Iketsetse mesebetsi ka li-macro bakeng sa tlhahiso e eketsehileng.

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.