modyuli #1 Xingheniso xa Excel ya le Henhla ya Nxopaxopo wa Data Nkatsakanyo wa swikongomelo swa khoso na xingheniso xa vuswikoti bya nxopaxopo wa datha ya Excels
modyuli #2 Maendlelo lamanene yo Lunghiselela Data Ku twisisa tinxaka ta datha, ku basisiwa ka datha, na ku tolovela datha
modyuli #3 Ku Nghenisa na ku Hlanganisa na Swihlovo swa Data Ku nghenisa datha ku suka eka swihlovo swo hambana, ku katsa na CSV, SQL, na ti-API ta inthanete
modyuli #4 Ku tirhisa Xivutiso xa Matimba ku Hundzula Data Ku nghenelela eka Xivutiso xa Matimba, ku hlanganisa datha, na ku vumba hi vuntshwa datha
modyuli #5 Ku Hlengeleta na ku Hlanganisa Data Ku tirhisa SUMIFS, COUNTIFS, na mintirho yin’wana yo hlengeleta
modyuli #6 Ku Cinca ka Data hi INDEX-MATCH na VLOOKUP Mintirho yo languta na ku kongomisa ya le henhla
modyuli #7 Xingheniso xa PivotTables Ku tumbuluxa na ku endla hi ku landza swilaveko swa PivotTables eka nxopaxopo wa datha
modyuli #8 Ku Vonakala ka Data hi Tichati na Tigirafu Ku tumbuluxa tichati na tigirafu leti tirhaka ku hlanganisa vutivi bya datha
modyuli #9 Ku tirhisa Swilayi na Minkarhi ya Nxopaxopo wa Ntirhisano Ku ndlandlamuxa nxopaxopo wa PivotTable hi swilayi na milayeni ya nkarhi
modyuli #10 Ku tirhisa Mintirho ya IF, IFERROR, na IFBLANK Loji ya xiyimo xa le henhla na ku khoma swihoxo
modyuli #11 Xingheniso xa Tifomula ta Array Ku tirhisa tifomula ta array eka ku cinca ka datha ya xiyimo xa le henhla
modyuli #12 Ku tirhisa Mintirho ya XLOOKUP na FILTER Mintirho leyintshwa na leyi antswisiweke yo languta na ku sefa
modyuli #13 Xingheniso xa Ku Endliwa ka Xikombiso xa Data Ku tumbuluxa timodeli ta datha ta nxopaxopo wa xiyimo xa le henhla
modyuli #14 Ku tirhisa DAX eka Tikholomu leti hlayiweke na Mimpimo Ku tumbuluxa swibalo swa ntolovelo na DAX
modyuli #15 Tifomula na Mintirho ya DAX ya le Henhla Ku tirhisa DAX eka nxopaxopo wa datha ya xiyimo xa le henhla na ku vona hi mahlo ya mianakanyo
modyuli #16 Xingheniso xa Power BI Ku hlanganisa Excel na Power BI eka vuxopaxopi bya xiyimo xa le henhla
modyuli #17 Ku tirhisa Vuprofeta Mintirho ya Vuxopaxopi bya Vuprofeta Ku tirhisa mintirho ya vuprofeta leyi akiweke endzeni ka Excels
modyuli #18 Ku tirhisa Dyondzo ya Muchini na AI eka Excel Ku hlanganisa dyondzo ya muchini na switirhisiwa swa AI na Excel
modyuli #19 Xingheniso xa VBA na Macro Recording Ku endla mintirho ya otomatiki hi ku rhekhoda ka VBA na macro
modyuli #20 Ku tumbuluxa ti-Macro ta Xihlawuhlawu na Tifomo ta Mutirhisi Ku aka ti-macro ta ntolovelo na swihlanganisi swa vatirhisi
modyuli #21 Tithekiniki ta VBA ta le Henhla na Maendlelo lamanene Ku antswisa na ku lulamisa swihoxo swa khodi ya VBA
modyuli #22 Ku tirhisa Excel eka Nxopaxopo wa Tinhlayo Ku tirhisa mintirho ya tinhlayo leyi akiweke endzeni ka Excels
modyuli #23 Ku tirhisa Swifaniso swa Monte Carlo na Nxopaxopo wa Xiendlakalo Ku tirhisa Excel eka ku tekelela ka xiyimo xa le henhla na nxopaxopo wa xiyimo
modyuli #24 Ku tirhisa R na Python na Excel Ku hlanganisa Excel na R na Python ku endlela nxopaxopo wa datha ya xiyimo xa le henhla
modyuli #25 Ku tumbuluxa Tidashboard ta Ntirhisano Ku tirhisa switirhisiwa swa dashboard ya Excels eka nxopaxopo wa vuhlanganisi
modyuli #26 Ku tirhisa Report Builder na Power Pivot Ku tumbuluxa swiviko swa xiyimo xa le henhla hi Xiviko Muaki na Power Pivot
modyuli #27 Maendlelo lamanene ya Dizayini ya Dashboard na Swiviko Ku dizayina tidashboard leti tirhaka na swiviko eka vatirhisi va mabindzu
modyuli #28 Ku tirhisa Excel eka Nxopaxopo wa Data Leyikulu Ku tirhisa Excel na switirhisiwa swa data leyikulu swo fana na Hadoop na Spark
modyuli #29 Ku Vonakala ka Data ya le Henhla hi Excel Ku tirhisa Excel eka ku vona ka datha ya xiyimo xa le henhla na ku vulavula hi switori
modyuli #30 Ku Pfuxeta & Mahetelelo ya Khoso Ku pulana magoza lama landzelaka eka ntirho wa Advanced Excel for Data Analysis
U lunghekele ku dyondza, ku avelana ni ku phikizana?
