Amanothi ku-Excel - ukuthi usenza kanjani, ubuke, uhlele, ususe futhi wengeze isithombe

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:

  1. Khetha iseli etafuleni elinegundane. Chofoza kuso kwesokudla.
  2. Kumenyu yokuqukethwe evelayo, khetha umsebenzi othi "Faka Inothi".
Amanothi ku-Excel - indlela yokudala, ukubuka, ukuhlela, ukususa nokwengeza isithombe
Ukudala inothi ngokuchofoza kwesokudla kunoma iyiphi iseli
  1. 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.

Amanothi ku-Excel - indlela yokudala, ukubuka, ukuhlela, ukususa nokwengeza isithombe
Buka ulwazi oluvela kunothi ngokuhambisa phezulu ngegundane

Editing

Ngokuvamile kuba nezimo lapho kudingekile ukushintsha okuqukethwe kwefasitela ukuze uthole ukuphawula okwengeziwe. Ungakwenza lokhu ngokulandela izinyathelo ezimbalwa:

  1. Chofoza okokuqala kuseli elinombhalo ofihliwe ngenkinobho yegundane elingakwesokudla.
  2. Ohlwini oluvelayo, khetha umsebenzi othi "Hlela Inothi".
  3. 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.

Amanothi ku-Excel - indlela yokudala, ukubuka, ukuhlela, ukususa nokwengeza isithombe
Ukuhlela inothi usebenzisa indlela evamile

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:

  1. Ekuqaleni, udinga ukwengeza isiginesha eyengeziwe kuseli ekhethiwe.
  2. Iya kunqubo yokuhlela inothi, qondisa ikhesa yegundane komunye wemingcele yeseli. Kubalulekile ukuyiqondisa endaweni lapho kuzovela khona isithonjana esinemicibisholo emine, ehlukana ngezindlela ezahlukene.
  3. Udinga ukuchofoza kwesokudla kulesi sithonjana, ukhethe umsebenzi we-"Note Format" kumenyu evelayo.
  4. Iwindi lolwazi lokuhlela kufanele livele ngaphambi komsebenzisi. Kufanele uthole ithebhu "Imibala Nemigqa" bese ushintshela kuyo.
  5. Chofoza kuhlu lokudonsela phansi olubizwa ngokuthi “Umbala”, phansi kakhulu ohlwini oluvelayo, khetha umsebenzi othi “Gcwalisa Izindlela”.
  6. Iwindi elisha kufanele livele lapho udinga ukuya kuthebhu ethi "Umdwebo". Ngaphakathi kwale thebhu, chofoza inkinobho enegama elifanayo.
  7. 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.
Amanothi ku-Excel - indlela yokudala, ukubuka, ukuhlela, ukususa nokwengeza isithombe
Izinketho zendlela yokulayisha isithombe
  1. Uma isithombe sikhethiwe, sizoshintshela ngokuzenzakalela efasiteleni langaphambilini lapho kuzovezwa khona isithombe esikhethiwe. Lapha udinga ukumaka ibhokisi eliseduze nomsebenzi othi “Gcina ukulingana kwesithombe.”
  2. 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".
  3. 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".

Amanothi ku-Excel - indlela yokudala, ukubuka, ukuhlela, ukususa nokwengeza isithombe
Indlela elula yokususa inothi ngokuchofoza kwesokudla

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:

  1. Khetha enye yezinto zemenyu enkulu "Ifayela".
  2. Iya kokuthi "Izilungiselelo".
  3. Yiya kuthebhu ethi “Okuvamile”.
Amanothi ku-Excel - indlela yokudala, ukubuka, ukuhlela, ukususa nokwengeza isithombe
Ukushintsha igama lomsebenzisi oshiye amazwana ngezilungiselelo ezijwayelekile
  1. 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:

  1. Iya kuthebhu "Ekhaya".
  2. Yiya engxenyeni ethi “Thola bese ukhetha”.
  3. Chofoza inkinobho ethi "Izilungiselelo".
  4. Thola inketho yokukhetha "ububanzi bokusesha".
  5. Setha inani ukuze Qaphela.
  6. 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:

  1. Iya kuzilungiselelo ezijwayelekile kuthebhu ethi “Ifayela”, bese uthi “Izinketho”, yiya engxenyeni ethi “Okuthuthukile”.
  2. Thola ingxenye ethi "Isikrini".
  3. Thikha ibhokisi eliseduze nomsebenzi othi “Amanothi nezinkomba”.
  4. Chofoza inkinobho ethi "OK". Ngemva kwalokho, amanothi afihliwe azohlala eboniswa. Ukuze uzifihle ngokuphelele, udinga ukuhlola ibhokisi eliseduze nomsebenzi othi “Awekho amanothi, azikho izinkomba”.
Amanothi ku-Excel - indlela yokudala, ukubuka, ukuhlela, ukususa nokwengeza isithombe
Izindlela ezimbili zokubonisa nokufihla umbhalo noma izithombe kumanothi

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:

  1. Chofoza kwesokudla ukuze ukhethe iseli kudokhumenti okunamathiselwe kuyo incazelo emfushane noma isichibiyelo.
  2. Kumenyu ye-pop-up, khetha umsebenzi "Kopisha".
  3. Thola iseli ofuna ukuhlanganisa kulo inothi elikopishiwe, likhethe ngokuchofoza inkinobho yegundane kwesokunxele.
  4. Iya kuthebhu "Ekhaya", bese ukhetha "Ibhodi lokunamathisela", chofoza inkinobho "Namathisela".
  5. 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:

  1. Yiya engxenyeni ethi “Isakhiwo Sekhasi”.
  2. Iya kuthebhu "Ukusethwa Kwekhasi", bese uchofoza okuthi "Printa Izihloko".
Amanothi ku-Excel - indlela yokudala, ukubuka, ukuhlela, ukususa nokwengeza isithombe
Iwindi elinazo zonke izilungiselelo zekhasi ezingashintshwa, kuhlanganise nokuphrinta
  1. 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:

  1. Ekhoneni eliphezulu kwesokunxele, chofoza ithebhu "Ifayela".
  2. Iya engxenyeni ethi “Izilungiselelo”, “Okuvamile”.
  3. Khetha "Igama lomsebenzisi" kumenyu evelayo.
  4. 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:

  1. Lapho abasebenzi benkampani eyodwa benesisekelo somsebenzi esivamile esirekhodwe kudokhumenti ye-Excel, ozakwabo abasebenza ekhasini elifanayo ngokushintshana bangashiya amazwana njengamashifu, banikeze imiyalelo, bashintshisane ngolwazi oluthile.
  2. Ukubekwa kwezithombe - uma ithebula liqukethe idatha mayelana nabantu abathile, izithombe zanoma yiziphi izinto, uma kuthinta isitoreji sabo, ukuthengiswa.
Amanothi ku-Excel - indlela yokudala, ukubuka, ukuhlela, ukususa nokwengeza isithombe
Isithombe somkhiqizo esifihliwe kunothi endaweni ethile etafuleni
  1. 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.

shiya impendulo