Indlela yokudala ispredishithi se-Excel Kuyikhono elibalulekile kunoma ubani osebenza ngedatha. Kungakhathaliseki ukuthi uqhuba ibhizinisi, ugcina ibhajethi yomuntu siqu, noma ulandelela imikhuba yakho yokuzivocavoca, i-Excel iyithuluzi elinamandla elizokusiza uhlele futhi uhlaziye ulwazi ngempumelelo. Kulesi sihloko, sizokuqondisa ezinyathelweni ezilula nezibalulekile zokwakha ishidi le-Excel, kusukela ekuvuleni uhlelo kuye ekudaleni ispredishithi sokuqala. Noma ngabe ungumuntu osaqalayo noma ungumsebenzisi onesipiliyoni, silapha ukuze sikusize ube yingcweti kulesi sici esibalulekile sokukhiqiza kwedijithali!
- Isinyathelo ngesinyathelo ➡️ Indlela yokudala ishidi le-Excel
- Isinyathelo 1: Vula i-Microsoft Excel kukhompyutha yakho.
- Isinyathelo 2: Chofoza "Incwadi Yokusebenzela Entsha" ukuze udale idokhumenti entsha ye-Excel.
- Isinyathelo 3: Uma ibhuku lokusebenza elisha selivuliwe, uzobona isipredishithi esingenalutho.
- Isinyathelo 4: Phansi kweshidi, uzobona amathebhu ahlukene, chofoza okuthi “Ishidi 1” ukuze uqale ukusebenza kulelo shidi elithile.
- Isinyathelo 5: Manje usulungele ukuqala ukufaka idatha yakho. Ungabhala umbhalo, izinombolo namafomula kumaseli eshidi le-Excel.
- Isinyathelo 6: Ukuze ushintshe ifomethi yeseli, chofoza iseli noma amaseli ofuna ukuwafometha bese ukhetha inketho yokufometha oyithandayo kubha yamathuluzi.
- Isinyathelo 7: Uma ufuna ukufaka imigqa noma amakholomu, chofoza inombolo yomugqa noma uhlamvu lwekholomu ukuze ukhethe wonke umugqa noma ikholomu, bese uchofoza kwesokudla bese ukhetha okuthi “Faka” ukuze wengeze umugqa noma ikholomu entsha.
- Isinyathelo 8: Ukuze ulondoloze ishidi lakho le-Excel, chofoza okuthi “Fayela” bese ukhetha “Londoloza Njenge.” Khetha indawo negama lefayela, bese uchofoza okuthi "Londoloza."
Imibuzo Nezimpendulo
Indlela yokudala ispredishithi se-Excel
1. Ngiyivula kanjani i-Excel kukhompuyutha yami?
Ukuvula i-Excel kukhompyutha yakho, landela lezi zinyathelo:
- Chofoza inkinobho yokuqala ekhoneni elingezansi kwesobunxele kwesikrini.
- Thayipha okuthi “Excel” ebhokisini lokusesha bese ucindezela u-Enter.
- Chofoza isithonjana se-Excel esivela emiphumeleni yosesho.
2. Ngiqala kanjani ukwakha ishidi le-Excel?
Ukuze uqale ukwakha ishidi le-Excel, yenza lokhu okulandelayo:
- Vula i-Excel kukhompyutha yakho.
- Chofoza okuthi “Incwadi Yokusebenzela Entsha” noma “Entsha” ukuze uvule isipredishithi esisha esingenalutho.
3. Ngiyifaka kanjani imigqa namakholomu ku-Excel?
Ukufaka imigqa namakholomu ku-Excel, landela lezi zinyathelo:
- Khetha umugqa noma ikholomu ofuna ukufaka kuyo umugqa noma ikholomu entsha.
- Chofoza kwesokudla bese ukhetha "Faka" kumenyu yokudonsela phansi.
4. Ngiyishintsha kanjani ifomethi yeseli ku-Excel?
Ukushintsha ukufometha kwamaseli ku-Excel, yenza lokhu okulandelayo:
- Khetha amaseli ofuna ukuwafometha.
- Chofoza ithebhu »Ekhaya» phezulu esikrinini.
- Khetha izinketho zokufometha njengefonti, umbala wangemuva, imingcele, njll.
5. Ngizenza kanjani izibalo ku-Excel?
Ukuze wenze izibalo ku-Excel, landela lezi zinyathelo:
- Bhala amanani ofuna ukuwabala kumaseli ahambisanayo.
- Khetha iseli ofuna ukuthi umphumela uvele kulo.
- Bhala ifomula yezibalo, isibonelo, =SUM(A1:A5) ukuze ungeze amanani ukusuka ku-A1 ukuya ku-A5.
6. Ngiligcina kanjani ishidi le-Excel kukhompuyutha yami?
Ukugcina ishidi le-Excel kukhompyutha yakho, landela lezi zinyathelo:
- Chofoza inkinobho ye-Office ekhoneni eliphezulu kwesokunxele kwesikrini.
- Khetha okuthi "Londoloza njenge".
- Khetha indawo negama lefayela, bese uchofoza okuthi "Londoloza."
7. Ngiliphrinta kanjani ishidi le-Excel?
Ukuphrinta ishidi le-Excel, yenza lokhu okulandelayo:
- Chofoza inkinobho Office ekhoneni eliphezulu kwesokunxele kwesikrini.
- Khetha "Phrinta".
- Khetha izinketho zokuphrinta bese uchofoza "Phrinta."
8. Ngiwasebenzisa kanjani amafomula ku-Excel?
Ukuze usebenzise amafomula ku-Excel, landela lezi zinyathelo:
- Khetha iseli ofuna ukuthi umphumela uvele kulo.
- Thayipha uphawu olulinganayo (=) olulandelwa ifomula yezibalo, isibonelo, =SUM(A1:A5) ukuze wengeze amananikusuka ku-A1 kuya ku-A5.
9. Ngiwafaka kanjani amashadi ku-Excel?
Ukufaka amashadi ku-Excel, yenza okulandelayo:
- Khetha idatha ofuna ukuyifaka eshadini.
- Chofoza ithebhu "Faka" phezulu esikrinini.
- Khetha uhlobo lweshadi olufunayo futhi ulenze ngendlela oyifisayo ngokwezidingo zakho.
10. Ngilivikela kanjani ishidi le-Excel elinephasiwedi?
Ukuze uvikele ishidi le-Excel elinephasiwedi, landela lezi zinyathelo:
- Chofoza ithebhu "Buyekeza" phezulu esikrinini.
- Khetha okuthi “Vikela Ishidi” bese usetha iphasiwedi yokufinyelela.
- Qinisekisa iphasiwedi bese uchofoza "Kulungile."
Ngingu-Sebastián Vidal, unjiniyela wekhompyutha ozifelayo ngobuchwepheshe kanye ne-DIY. Ngaphezu kwalokho, ngingumdali we tecnobits.com, lapho ngabelana khona ngezifundo zokwenza ubuchwepheshe bufinyeleleke kakhudlwana futhi buqonde wonke umuntu.