I-Excel Ethuthukisiwe Yokuhlaziywa Kwedatha
( 30 Amamojula )

module #1
Isingeniso se-Advanced Excel for Data Analysis
Uhlolojikelele lwezinjongo zezifundo kanye nesingeniso samakhono okuhlaziya idatha ye-Excel

module #2
Imikhuba Engcono Kakhulu Yokulungiselela Idatha
Ukuqonda izinhlobo zedatha, ukuhlanzwa kwedatha, kanye nokujwayelekile kwedatha

module #3
Ukungenisa nokuxhuma emithonjeni yedatha
Ukungenisa idatha kusuka emithonjeni eyahlukene, okuhlanganisa i-CSV, i-SQL, nama-API aku-inthanethi

module #4
Ukusebenzisa Umbuzo Wamandla Wokuguqulwa Kwedatha
Isingeniso Sombuzo Wamandla, ukuhlanganisa idatha, nokubunjwa kabusha kwedatha

module #5
Ukuhlanganiswa Kwedatha Nokwenza Amaqembu
Kusebenzisa i-SUMIFS, COUNTIFS, neminye imisebenzi yokuhlanganisa

module #6
Ukuguqulwa Kwedatha nge-INDEX-MATCH kanye ne-VLOOKUP
Imisebenzi yokubheka okuthuthukisiwe nereferensi

module #7
Isingeniso ku-PivotTables
Ukudala nokwenza ngendlela oyifisayo ama-PivotTables okuhlaziya idatha

module #8
Ukubonakala Kwedatha Ngamashadi namaGrafu
Ukudala amashadi namagrafu asebenzayo ukuze kuxhunyanwe nemininingwane yedatha

module #9
Ukusebenzisa Izilayishi Nezikhathi Zesikhathi Zokuhlaziya Okusebenzisanayo
Ukuthuthukisa ukuhlaziya kwe-PivotTable nge izisiki kanye nemigqa yesikhathi

module #10
Kusetshenziswa IF, IFERROR, kanye Nemisebenzi ye-IFBLANK
Ingqondo enemibandela ethuthukisiwe nokuphatha iphutha

module #11
Isingeniso ku-Array Formulas
Ukusebenzisa amafomula afanayo ukuze kusetshenziswe idatha ethuthukisiwe

module #12
Ukusebenzisa Imisebenzi ye-XLOOKUP kanye NESIHLUNGI
Imisebenzi emisha nethuthukisiwe yokubheka nokuhlunga

module #13
Isingeniso Sokufanisa Idatha
Ukudala amamodeli edatha ukuze kuhlaziywe okuthuthukile

module #14
Ukusebenzisa i-DAX Kumakholomu Abaliwe Nezilinganiso
Ukudala izibalo ngokwezifiso nge-DAX

module #15
Amafomula Nemisebenzi Ye-DAX Ethuthukisiwe
Ukusebenzisa i-DAX ekuhlaziyweni kwedatha okuthuthukisiwe kanye nokubona ngeso lengqondo

module #16
Isingeniso ku-Power BI
Ukuhlanganisa i-Excel ne-Power BI yokuhlaziya okuthuthukile

module #17
Ukusebenzisa Ukubikezela Imisebenzi ye-Predictive Analytics
Ukusebenzisa imisebenzi yokubikezela eyakhelwe ngaphakathi yama-Excels

module #18
Ukusebenzisa Ukufunda Ngomshini kanye ne-AI ku-Excel
Ukuhlanganisa ukufundwa komshini namathuluzi e-AI nge-Excel

module #19
Isingeniso ku-VBA kanye Nokuqoshwa KweMacro
Imisebenzi yokuzenzakalela nge-VBA nokuqoshwa okukhulu

module #20
Ukudala ama-Custom Macros kanye nama-UserForms
Ukwakha ama-macros wangokwezifiso nezixhumi ezibonakalayo zabasebenzisi

module #21
Amasu e-VBA Athuthukile Nemikhuba Enhle Kakhulu
Ukulungiselela kanye nokulungisa iphutha lekhodi ye-VBA

module #22
Ukusebenzisa i-Excel for Statistical Analysis
Ukusebenzisa imisebenzi yezibalo eyakhelwe ngaphakathi yama-Excels

module #23
Ukusebenzisa i-Monte Carlo Simulations and Scenario Analysis
Ukusebenzisa i-Excel ukulingisa okuthuthukisiwe nokuhlaziya isimo

module #24
Ukusebenzisa i-R ne-Python nge-Excel
Ukuhlanganisa i-Excel ne-R kanye ne-Python ukuze kuhlaziywe idatha ethuthukisiwe

module #25
Ukudala Amadeshibhodi Asebenzisanayo
Ukusebenzisa amathuluzi edeshibhodi ye-Excels ukuze kuhlaziywe ngokuhlanganyela

module #26
Ukusebenzisa i-Report Builder kanye ne-Power Pivot
Ukudala imibiko ethuthukisiwe ngombiko I-Builder and Power Pivot

module #27
Imikhuba Engcono Kakhulu Yedeshibhodi kanye Nomklamo Wombiko
Ukudizayina amadeshibhodi asebenzayo nemibiko yabasebenzisi bebhizinisi

module #28
Ukusebenzisa i-Excel Ukuhlaziya Idatha Enkulu
Ukusebenzisa i-Excel enamathuluzi amakhulu edatha njenge-Hadoop kanye I-Spark

module #29
Ukubonwa Kwedatha Okuthuthukisiwe nge-Excel
Ukusebenzisa i-Excel ukuze uthole ulwazi oluthuthukisiwe lwedatha nokuxoxa indaba

module #30
Ukugoqwa Kwezifundo & Isiphetho
Ukuhlela izinyathelo ezilandelayo ku-Advanced Excel yomsebenzi wokuhlaziya idatha

Ukulungele ukufunda, ukwaba, nokuncintisana?

Umsizi Wokufunda Ulimi
Ngosekelo Lwezwi

Sawubona! Usulungele ukuqala? Ake sihlole imakrofoni yakho.

XHUMANA NATHI INQUBOMGOMO YOBUMFIHLO

I-Excel Ethuthukisiwe Yokuhlaziywa Kwedatha ( 30 Amamojula )

Ukulungele ukufunda, ukwaba, nokuncintisana?

Umsizi Wokufunda UlimiNgosekelo Lwezwi

I-Excel Ethuthukisiwe Yokuhlaziywa Kwedatha
( 30 Amamojula )

Umsizi Wokufunda Ulimi
Ngosekelo Lwezwi