20 namacebo kuwe guru Excel

Njalo ngubani osebenzela-computer, phendula ngoyebo, uma bambuze ukuthi uyayazi nendlela yokubavikela usebenze nge-Excel. Nokho, uma ubeka umbuzo ngenye indlela futhi uzame ukuthola kahle ukuthi iningi kuzobangela ukudideka. Kodwa kungaba khona bakwazi ukubhekana? Eqinisweni, lolu hlelo lugcine omningi izimfihlo, lapho nje bamshaya indiva. Kodwa uma wazi ngazo, masinyane baba intandokazi yakho kakhulu. Ngakho, kulesi sihloko uzofunda namaqhinga mayelana amabili ezahlukene "Eksele" ukuthi bonke abantu kufanele bazi.

Khetha zonke nge okukodwa nje

Esikhathini ekhoneni elingenhla esinxeleni emkhakheni kukhona inkinobho okuyinto akekho ngokuvamile akwenzi ucindezela. Futhi ewusizo kakhulu, njengoba kuvumela kokuchofoza okukodwa ukhethe wonke amaseli yedokhumenti yamanje.

Kuvulwa amafayela amaningi

Idatha ukucutshungulwa - lena isici esiyinhloko lolu hlelo, kodwa yini okufanele uyenze uma une eziningi amafayela, ngalinye elikwazi udinga ukusebenzisa? Ngempela-ke kuyadingeka ukuvula ngamunye wabo wodwa eceleni? Eqinisweni, kukhona omunye iqhinga lokuthi kuzokuvumela lapho zibhekene nomsebenzi ngokushesha. Khetha wonke amafayela owadingayo bese ucindezela Faka - bona zonke evulekile ngaphandle ingxabano phakathi kwazo.

Skrola amafayela

Uma usebenza nge inqwaba amadokhumenti, kakhulu bangacasulana isidingo ngesandla ukushintsha phakathi kwabo. Ungenza ukuphila kwakho kube lula ngokusebenzisa inhlanganiselazihlonzi Ctrl Tab, okuyinto ngokuzenzakalelayo sekuqalile ukuba kuthebhu elandelayo.

imenyu izinto

Abantu abaningi bakholelwa ukuthi "Londoloza" "Phambili" futhi "Emuva" - la izinketho kuphela etholakala uhlelo kusuka kwimenyu abaphezulu. Kodwa ungase futhi wengeze ukuba iyiphi inombolo nemisebenzi ngokusebenzisa izilungiselelo ekhethekile block - khumbula nje ukuthi amalebuli ukuboniswa ezimbili kuphela - lonke kuzofihlwa.

Umugqa idayagonali kuseli

Ngezinye izikhathi udinga ukusetha iseli emgqeni idayagonali ukwabelana ngolwazi, izinguquko kuwo. Kodwa ungakwenza kanjani na? Zonke bayakwazi ukuchaza imingcele kumaseli, kodwa uma uchofoza "Imingcele Okuningi", uzothola umugqa idayagonali hhayi kuphela, kodwa futhi nezinye lezimanga.

Ukungeza imigqa noma amakholomu

Wonke umuntu uyazi ukuthi ukuze ungeze irowu noma ikholomu amaseli. Kodwa ukwengeza izingcezu ezimbalwa eceleni - kungcono a nightmare real. Ngakho-ke, uzowathola kangcono ukhethe inombolo oyifunayo amaseli kumelwe ilingane inombolo oyifunayo imigqa noma amakholomu, bese obukwenza ejwayelekile.

Ukudlulisa idatha ye-Fast

Kuthiwani uma udinga ngokushesha ukuhambisa ikholomu eyodwa idatha? Ukuze wenze lokhu, hambisa isikhombisi emaphethelweni ikholomu, kuze kuthatha ngesimo umcibisholo engu- emise, bese ususa okuqukethwe ikholomu ngokukhululekile.

Ukususwa lamaseli angenalutho

Phakathi nalokho kubingelelana, ngokuvamile kakhulu kukhona inqwaba sezitokisi ezingenalutho, okonakalisa ukubukeka idokhumenti. Ungasusa ngayinye ngayinye - noma sebenzisa indlela esheshayo. Ukuze wenze lokhu, uzodinga ukuhlunga ungakhethi into "Konke" bese ukhetha "Akunalutho" - khona manjalo ukhetha wonke amaseli angenalutho idokhumenti ungasusa ngokuchofoza okukodwa.

usesho olungalungile

Wonke umuntu uyazi ukuthi ukusebenzisa search esheshayo, kodwa bambalwa abantu bazi iqiniso lokuthi awukwazi ukucinga ukufana ngqo, futhi imiphumela eyodwa noma ngaphezulu izinhlamvu. Ukucinga uhlamvu olulodwa, udinga kubha yokusesha ukufaka uphawu lombuzo, futhi uma ufuna ukucinga ngokufaka izinhlamvu eziningana - Sebenzisa lwenkanyezi.

Dala i-value ehlukile

Abantu abaningi basebenzisa umshini, kodwa cishe awalokothi esigabeni eziphambili. Kodwa naso, ungacacisa value ehlukile yeseli esithile, uma uludinga umsebenzi noma nezinye izinjongo.

Isenzo sokunqophisa Imininingwane

Akuwona wonke umuntu uyazi ukuthi ungasetha imikhawulo kulokho Imininingwane okuyokwenziwa iseli. Ngokwesibonelo, uma udala uhlu lwabantu ababemenyelwe umcimbi, futhi ubudala babo kungaba isukela kwengu-18 kuya ku-60 ubudala (kuphela tinombolo letiphelele), khona-ke zombili lezi ongakhetha ungakhetha kusuka kumenyu "Idatha" bese ezinye amagugu nje angeke amukelwe .

Ukuzulazula okusheshayo

Ukuze kwemikhumbi okusheshayo ngokusebenzisa ikhasi dokhumenti, ungasebenzisa ikhi Ctrl ne- imicibisholo. Uma usebenzisa le nhlanganisela, uzoba ukufinyelela yokugcina ulwazi amaseli.

ukuguqulwa

Ngezinye izikhathi kuyadingeka ukuze ujike kukholamu ilandelana, noma okuphambene nalokho. Eqinisweni, kungenzeka kakhulu ukumane. Ukuze wenze lokhu, kudingeka ukukopisha ulwazi olufunayo, bese unamathisele kusuka kwimenyu ngokukhetha "Ukuguqula" - nenombolo yakho azokopishwa ikholomu.

Indlela ukufihla ulwazi?

Ngo "Eksele" unekhono ukufihla ulwazi, kodwa kungenziwa ngezindlela ezahlukene. Ungachofoza iseli bese ukhetha "Fihla", kodwa ngeke neze kube nomphumela omuhle kakhulu. ke Kuyancomeka ukusebenzisa cell ukufometha kufomethi Uhlobo ;;; - ikuvumela uthole ukwaziswa okunokwethenjelwa kakhulu kufihlakele emehlweni prying.

Ukuhlanganisa idatha kusuka amaseli

Uma une amaseli amaningi, futhi udinga ukuhlanganisa ulwazi olulondolozwe nabo zibe munye, ngeke kabusha ngempela bonke ngokuphelele. Mane usethe umsebenzi lapho amaseli phakathi amagama adingekayo faka "ampersand" isithonjana - umphumela kuseli ekhethiwe, uthola yonke idatha kusuka esedlule.

Shintsha ezincane ibe usonhlamvukazi

Uma udinga umbhalo kwesinye isitokisi bazifake wenze ebhaliwe ngokugcwele ngosonhlamvukazi, ungenawo ukuba Thayipha ke ngokuphelele capslock isebenze. Udinga nje ukusebenzisa umsebenzi NGENHLA kubakaki abonisa onjani cell okudingekayo ukuguqula.

Idatha eziqala 0

Kwezinye izimo, kungase kudingeke ukufaka idatha kuseli oqala 0. Ngeshwa, ngokuzenzakalelayo uhlelo kususa ngokuzenzakalelayo kuka-zero, kusale kuphela i value inamba. Ungashintsha ifomethi cell, kodwa kuyinqubo eside ukuthi kulula esikhundleni elula isithonjana quote elilodwa. Uma alibhece phambi value yakho, bese zero izohlala endaweni.

Ukulungiswa ngokuzenzekelayo

Abantu abaningi basebenzisa engadingeki njengoba kuhlosiwe, ukuthi akesabi ukuphrinta amaphutha, ngoba bayazi ukuthi isofthiwe yabo uyolungisa. Kodwa bambalwa abantu ezifika engqondweni ukuthi ungakwazi ukusebenzisa lesi sici ku-lula umsebenzi walo. Uma une amazwi yansukuzonke eside, amagama, bese ungawafaka ohlwini amazwi for Ukulungiswa ngokuzenzekelayo futhi bachitha lokubhala abo yesibili - futhi lolu hlelo ngokwalo iyobenza ku ifomu efanele, zibuze kanye esikhundleni zamakhulu.

Olunye ulwazi

Uma ukhetha iseli ekhoneni lesidla eliphansi kukhona ulwazi mayelana nalo. Nokho, kukude ephelele, kodwa ungathola ukufinyelela ngokuphelele yonke idatha. Ukuze wenze lokhu, kudingeka hambisa imawusi phezu ulwazi bese uchofoze inkinobho yegundane kwesokudla - ke kuvula ifasitela, elizoquketha yonke idatha ukuthi kule seli ethile.

ekuqambeni kabusha Amakhasi

Eyodwa yezindlela elula, okuyinto ngasizathu simbe cishe akekho isebenzisa. Isikhathi esining impela, kufanele ukuqamba kabusha emakhasini e idokhumenti, futhi ngenxa yalokho, uchofoza igama, chofoza ngakwesokudla, bese ukhetha "Qamba kabusha", bese ukushintsha igama. Kodwa inqubo kungenziwa kakhulu lula ngokusebenzisa ikhasi isimiso esifanayo njengoba ngonqamulelo namafayela ku-Windows. Chofoza kabili igama ikhasi kukunika ithuba osheshayo ukuhlela maseko, bashintshe.