** Isicelo esingaxhunyiwe ku-inthanethi ngokuphelele **
** Qedela i-Excel Tutorial nge **
1. Imisebenzi yolwazi
2. Imisebenzi yosuku nesikhathi
3. Imisebenzi yobunjiniyela
4. Imisebenzi yezezimali
5. Imininingwane yolwazi
6. Imisebenzi enengqondo
7. Ukubheka nokubheka imisebenzi
8. Izibalo kanye nemisebenzi ye-trigonometry
9. Imisebenzi yezibalo
10. Imisebenzi yombhalo
11. Imisebenzi yeWebhu
12. Cube imisebenzi
** Ingqikithi yezifundo ezingama-72 Zokufunda ziveza igxathu negxathu, kwabaqalayo.
** Kunemisebenzi eminingi ehlukile ye-Excel kanye nokususwayo, okufana nosuku nesikhathi.
Ubunjiniyela, ezezimali, ulwazi, umsebenzi weLogical, Ukubheka kanye nesethenjwa, iMathematics, Statistical, isebenza ngombhalo neminye imisebenzi.
** Kulabo kini abalwisana namafomula e-Excel nobunzima obuningi, sethula lolu hlelo lokusebenza luphelele ifomula. Lolu hlelo lokusebenza lufanelekile Wabasaqalayo, oluthuthukile, kanye nezikole namabhizinisi.
** Nazi ezinye izici ezikule lokusebenza ezizokusiza ufunde ms excel:
Ngiyethemba ukuthi lokhu kungakusiza ufunde ukuvelela.
Funda amafomula we-Excel agcwele: Kulula ukulandela okokufundisa ukuthi ungayisebenzisa kanjani i-Excel, amathiphu namasu.
** Funda amafomula we-Excel agcwele amafomula afana ne -CEILING, ROUNDUP, ROUNDDOWN, PRODUCT, SUM, SUMIF, SUMIFS, KHETHA, TRANSPOSE, VLOOKUP, HLOOKUP, FUTHI, NOMA, HHAYI, IF IF, IFERROR, DATEIF, COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS, CONCATENATE, KWESOKUNXELE, MID, KWESOKUDLA, Phezulu, PHANSI, PROPER. namanye amafomula ahlukahlukene atholakalayo.
** Funda i-Excel Formulas Full isici sokulanda sinikezwa ukulanda ifayili le-xls lilusizo kakhulu kuma-ejensi kahulumeni, izikole, amanyuvesi, amabhange, imifelandawonye, ukubakhona, ukufakwa kwezicelo, ukubalwa kwebhalansi, ishadi lokugeleza, ukuhlangana kweposi, kanye nezincwadi ezizenzakalelayo nge-xls.
** Qaphela: Lesi akusona isicelo seMicrosoft Lesi yisifundo nje seMicrosoft Excel
Kubuyekezwe ngo-
Jul 10, 2024