Okuqukethwe
Abasebenzisi abaningi be-Excel bajwayelene nenkinga yokuthi akulula kakhulu ukubeka inani elikhulu lolwazi kumaseli, akukho lapho ungazishiyela khona inothi ngokuzayo. Eqinisweni, ukwenza lokhu ngaphandle kokwephula ukubukeka okujwayelekile kwetafula kulula kakhulu. Yilokho amanothi enzelwe.
Ukusebenza namanothi
Amanothi ayimiyalelo eyengeziwe yamaseli akhethiwe. Imvamisa zingombhalo futhi ziqukethe ukuphawula okuthile ngomunye wababhali betafula. Ngaphezu kombhalo, ungakwazi ukwengeza isithombe endaweni evelayo. Nokho, ukuze unamathisele ukuphawula noma isithombe osifunayo kuseli, udinga ukufunda ukwakha amamaki ombhalo alula, uwabuke futhi uwahlele.. Ngemva kwalokho, ungaqhubekela kuzilungiselelo ezithuthukile.
Indalo
Inqubo yokudala amanothi ilula futhi inezinyathelo ezimbalwa:
- Khetha iseli etafuleni elinegundane. Chofoza kuso kwesokudla.
- Kumenyu yokuqukethwe evelayo, khetha umsebenzi othi "Faka Inothi".
- Ngemuva kwalokho, inkambu yamahhala izovela ohlangothini lweseli ekhethiwe. Umugqa ophezulu uzosetshenziswa igama lomsebenzisi elizenzakalelayo.
Ungafaka noma yiluphi ulwazi lombhalo endaweni yamahhala. Ukuze ufihle amazwana, udinga ukuchofoza kwesokudla kuseli, ukhethe umsebenzi othi "Fihla Amazwana". Ngemva kwalokho, izotholakala ukuze ifundwe kusixhumanisi esikhonjiswe yikhoneni elibomvu.
Buyekeza
Ungakwazi ukubuka amazwana amaseli ahlukene ngokuhambisa phezulu phezu kwawo wonke ngekhesa yegundane. Ngemva kwalokho, umbhalo onenothi uyazivelela. Ukuze wenze inkundla yokuphawula inyamalale, udinga ukuhambisa ikhesa kwenye indawo.
Iseluleko sochwepheshe! Uma ithebula likhulu, futhi linamanothi amaningi aboshelwe kumaseli ahlukene, ungashintsha phakathi kwawo ngokusebenzisa ithebhu ethi “Buyekeza”. Kulokhu, izinkinobho "Okwangaphambilini" kanye "Okulandelayo" zenzelwe.
Editing
Ngokuvamile kuba nezimo lapho kudingekile ukushintsha okuqukethwe kwefasitela ukuze uthole ukuphawula okwengeziwe. Ungakwenza lokhu ngokulandela izinyathelo ezimbalwa:
- Chofoza okokuqala kuseli elinombhalo ofihliwe ngenkinobho yegundane elingakwesokudla.
- Ohlwini oluvelayo, khetha umsebenzi othi "Hlela Inothi".
- Iwindi kufanele livuleke lapho ungahlela khona umbhalo, wengeze izithombe kuwo, wandise noma wehlise inkambu yokuphawula.
Ungakwazi ukuqedela ukulungiselelwa ngokuchofoza noma yikuphi kuthebula elingaphandle kwenkundla ukuze uthole umbhalo owengeziwe.
Enye inketho yokuhlela amazwana eseli yithebhu ethi Buyekeza. Lapha udinga ukuthola isethi yamathuluzi wamanothi bese uchofoza inkinobho ethi "Hlela".
Ukwengeza isithombe
Esinye sezici ezithakazelisayo zamanothi ku-Excel ukungezwa kwezithombe ezizovela lapho uhambisa phezulu kumaseli akhethiwe. Ukuze ungeze isithombe, udinga ukwenza izenzo ezimbalwa:
- Ekuqaleni, udinga ukwengeza isiginesha eyengeziwe kuseli ekhethiwe.
- Iya kunqubo yokuhlela inothi, qondisa ikhesa yegundane komunye wemingcele yeseli. Kubalulekile ukuyiqondisa endaweni lapho kuzovela khona isithonjana esinemicibisholo emine, ehlukana ngezindlela ezahlukene.
- Udinga ukuchofoza kwesokudla kulesi sithonjana, ukhethe umsebenzi we-"Note Format" kumenyu evelayo.
- Iwindi lolwazi lokuhlela kufanele livele ngaphambi komsebenzisi. Kufanele uthole ithebhu "Imibala Nemigqa" bese ushintshela kuyo.
- Chofoza kuhlu lokudonsela phansi olubizwa ngokuthi “Umbala”, phansi kakhulu ohlwini oluvelayo, khetha umsebenzi othi “Gcwalisa Izindlela”.
- Iwindi elisha kufanele livele lapho udinga ukuya kuthebhu ethi "Umdwebo". Ngaphakathi kwale thebhu, chofoza inkinobho enegama elifanayo.
- Iwindi elithi “Faka Izithombe” lizovela, lapho udinga ukukhetha okukodwa kwezintathu: layisha isithombe ku-OneDrive, sesha isithombe usebenzisa i-Bing, layisha isithombe ekhompyutheni. Indlela elula ukulayisha usuka kukhompuyutha lapho idokhumenti ikhona.
- Uma isithombe sikhethiwe, sizoshintshela ngokuzenzakalela efasiteleni langaphambilini lapho kuzovezwa khona isithombe esikhethiwe. Lapha udinga ukumaka ibhokisi eliseduze nomsebenzi othi “Gcina ukulingana kwesithombe.”
- Ngemva kokuchofoza inkinobho ethi "KULUNGILE", iwindi lokuqala lokufometha inothi lizovuleka. Kulesi sigaba, udinga ukuhlanganisa inothi nesithombe kuseli ekhethiwe ekuqaleni. Ukuze wenze lokhu, udinga ukuya kuthebhu ethi "Ukuvikela", ungahloli ibhokisi eliseduze kokuthi "Into evikelwe".
- Okulandelayo, udinga ukuya kuthebhu ethi "Properties", maka ibhokisi eliseduze kwento yokuhambisa nokushintsha izinto kanye namaseli. Chofoza inkinobho ethi "OK".
Ukuze ukhulise isithombe, kuyadingeka ukwelula inkambu yenothi ejwayelekile ngezindlela ezihlukene.
Ukususa inothi
Ukususa isiginesha eyengeziwe kulula kunokufaka entsha noma ukuyihlela. Ukuze wenze lokhu, chofoza kwesokudla kuseli elinencazelo eyengeziwe. Kumenyu ephumayo, yenza kusebenze umyalo othi "Susa inothi".
Indlela yesibili yokukhipha ilebula eyengeziwe kuseli ekhethiwe iwumsebenzi othi “Buyekeza”. Ngaphambi kokukhetha le nketho, kufanele umake iseli ngegundane. Okokugcina, chofoza inkinobho yokususa imininingwane eyengeziwe.
Ungasayina kanjani inothi ku-Excel
Uma kudokhumenti eyodwa ye-Excel eyabiwe konke ukuhlela okwengeziwe phezu kwamaseli kubhalwa abasebenzisi abahlukene ngaphandle kwamasignesha angawodwana, kuzoba nzima kakhulu ukuthola umbhali wezinto ezifakiwe. Amazwibela wenothi ikuvumela ukuthi uhlele idatha. Ukuze ukushiye ngaphezu kokuhlela okuthile kuseli, udinga ukwenza izenzo ezimbalwa:
- Khetha enye yezinto zemenyu enkulu "Ifayela".
- Iya kokuthi "Izilungiselelo".
- Yiya kuthebhu ethi “Okuvamile”.
- Inkambu yamahhala izovela ngezansi kwekhasi, lapho kufanele ufake khona igama lomsebenzisi oshiye amazwana kuseli.
Ungalithola kanjani inothi ku-Excel
Uma idokhumenti inkulu kakhulu, kungase kube nesimo lapho udinga ukuthola ngokushesha ukuphawula okuthile. Kwenze kwenzeke. Imiyalo yokuthola incazelo edingekayo noma ilebula:
- Iya kuthebhu "Ekhaya".
- Yiya engxenyeni ethi “Thola bese ukhetha”.
- Chofoza inkinobho ethi "Izilungiselelo".
- Thola inketho yokukhetha "ububanzi bokusesha".
- Setha inani ukuze Qaphela.
- Chofoza inkinobho ethi "Thola Konke".
Ngemva kwalokho, uhlu olunamaseli ngokwepharamitha emisiwe luzovela ngaphambi komsebenzisi.
Ibonisa futhi ifihle inothi
Uma ufisa, ungakwazi ukufihla ngokuphelele amanothi ukuze angagqami lapho ufunda idokhumenti eyinhloko, noma ukhubaze umsebenzi wokufihla uma ubucushiwe ngaphambilini. Ukuze wenze lokhu, udinga ukulandela izinyathelo ezimbalwa ezilula:
- Iya kuzilungiselelo ezijwayelekile kuthebhu ethi “Ifayela”, bese uthi “Izinketho”, yiya engxenyeni ethi “Okuthuthukile”.
- Thola ingxenye ethi "Isikrini".
- Thikha ibhokisi eliseduze nomsebenzi othi “Amanothi nezinkomba”.
- Chofoza inkinobho ethi "OK". Ngemva kwalokho, amanothi afihliwe azohlala eboniswa. Ukuze uzifihle ngokuphelele, udinga ukuhlola ibhokisi eliseduze nomsebenzi othi “Awekho amanothi, azikho izinkomba”.
Iseluleko sochwepheshe! I-Excel inenketho yokubonisa amazwana angawodwana kuphela. Ukuze unike lesi sici amandla, kufanele uchofoze kwesokudla kuseli ngencazelo eyengeziwe, chofoza inkinobho ethi “Bonisa Amanothi”. Ngakho zizovezwa unomphela kuphela kumaseli akhethiwe. Ngemenyu yokuqukethwe efanayo, ungakwazi ukufihla incazelo emfushane ngokuphelele ezindaweni ezidingekayo.
Ikopishela inothi kwamanye amaseli
Uma inothi selidaliwe, ungalikopishela kwenye iseli ukuze ungaphinde uwubhale umbhalo futhi. Ukuze wenze lokhu, landela umyalo olula:
- Chofoza kwesokudla ukuze ukhethe iseli kudokhumenti okunamathiselwe kuyo incazelo emfushane noma isichibiyelo.
- Kumenyu ye-pop-up, khetha umsebenzi "Kopisha".
- Thola iseli ofuna ukuhlanganisa kulo inothi elikopishiwe, likhethe ngokuchofoza inkinobho yegundane kwesokunxele.
- Iya kuthebhu "Ekhaya", bese ukhetha "Ibhodi lokunamathisela", chofoza inkinobho "Namathisela".
- Uhlu lwemiyalo luzovela phambi komsebenzisi. Iphuzu elithakazelisayo lithi "Namathisela Okukhethekile". Ngemuva kokuchofoza kuyo, kuzovela iwindi elihlukile lezilungiselelo, lapho udinga ukuhlola ibhokisi eduze kwamanothi. Kusele ukulondoloza izinguquko ngokuchofoza "KULUNGILE".
Ungaphrinta kanjani ishidi lamanothi
Uma ungenzi izinguquko ezithile, ngokuzenzakalelayo, imibhalo ye-Excel iphrintwa ngaphandle kwamanothi. Ukuze uwangeze kokuphrintiwe, udinga ukulungiselela uhlelo:
- Yiya engxenyeni ethi “Isakhiwo Sekhasi”.
- Iya kuthebhu "Ukusethwa Kwekhasi", bese uchofoza okuthi "Printa Izihloko".
- Iwindi elinezinto ngazinye zokuphrinta lizovuleka. Ngokuphikisana negama elithi “Amanothi”, ungawengeza kokuphrintiwe noma ushiye lesi senzo sikhanseliwe.
Iseluleko sochwepheshe! Lapho wengeza amanothi ozowaphrinta, kunezindlela ezimbili ongakhetha kuzo zokuwaveza kudokhumenti ephrintiwe. Uma ukhetha "Ekugcineni kweshidi" - zizovela phansi kakhulu kwekhasi. Ungakhetha inketho ethi "Njengeshidi" - amanothi azophrintwa njengoba evela kunguqulo ye-elekthronikhi yedokhumenti.
Ukushintsha igama lomsebenzisi uma udala amanothi
Lapho usebenza ku-Excel lapho ukwabelana kuvuliwe, uma udala amanothi, awanikezwa igama lomsebenzisi owashiyayo. Ukuze uyiguqulele esiteketisoni sakho, udinga ukulandela izinyathelo ezimbalwa:
- Ekhoneni eliphezulu kwesokunxele, chofoza ithebhu "Ifayela".
- Iya engxenyeni ethi “Izilungiselelo”, “Okuvamile”.
- Khetha "Igama lomsebenzisi" kumenyu evelayo.
- Inkambu yamahhala izovuleka phambi komsebenzisi, lapho kuyadingeka khona ukubhala igama olifunayo.
Izibonelo zokusebenzisa amanothi ku-Excel
Ukuze uqonde ukuthi angasiza kanjani amazwana engeziwe eseli kusipredishithi se-Excel, kutuswa ukuthi ucabangele izibonelo ezimbalwa ezisebenzayo kokuhlangenwe nakho kwabanye abasebenzisi:
- Lapho abasebenzi benkampani eyodwa benesisekelo somsebenzi esivamile esirekhodwe kudokhumenti ye-Excel, ozakwabo abasebenza ekhasini elifanayo ngokushintshana bangashiya amazwana njengamashifu, banikeze imiyalelo, bashintshisane ngolwazi oluthile.
- Ukubekwa kwezithombe - uma ithebula liqukethe idatha mayelana nabantu abathile, izithombe zanoma yiziphi izinto, uma kuthinta isitoreji sabo, ukuthengiswa.
- Izincazelo kumafomula azokwenza kube lula ukubala okwengeziwe, izibalo.
Uma ushiya amazwana ngendlela efanele - ukuze avele ngesikhathi esifanele futhi angaphazamisi umsebenzi wabanye abasebenzisi, ungakwazi ukwandisa kakhulu ukukhiqiza komsebenzi ohlobene namatafula ku-Excel.
Izifundo zevidiyo kumanothi ku-Excel
Imiyalo engenhla izokusiza uqonde izisekelo zokudala, ukuhlela, ukubuka, ukulungiselelwa okuthuthukisiwe kwamazwana kumaseli kusipredishithi se-Excel. Kodwa-ke, uma uhlangabezana nanoma yibuphi ubunzima, ubunzima ngezenzo ezithile mayelana namanothi, kunconywa ukubuka amavidiyo okuqeqesha. Aqukethe imiyalelo yesinyathelo ngesinyathelo yokwenza imisebenzi ehlukahlukene ngamazwana weselula.
Isiphetho
Ukudala, ukuhlela nokubuka amazwana kumaseli ahlukahlukene ku-Excel akunzima njengoba kungase kubonakale ekuqaleni. Kuyoba usizo ukuba namakhono anjalo hhayi kuphela kubantu abasebenza ezinhlanganweni ezinkulu, ukulandelela okuthile usebenzisa amatafula, kodwa nabasebenzisi abangabodwa abasebenza ku-Excel ngokwabo. Akufanele sikhohlwe ukuthi emkhakheni wenothi awukwazi ukwengeza umbhalo kuphela, kodwa futhi nezithombe, okwandisa kakhulu ukusetshenziswa kwazo emsebenzini.