20 namacebo ube guru Excel

Wonke umntu osebenza kwiziko ikhompyutha, phendula kwi affirmative, ukuba uyamcela ukuba uyazi ukuba asebenze njani kwi Excel. Nakuba kunjalo, ukuba ufake umbuzo enye indlela uze uzame ukufumana indlela kakuhle, uninzi oko kuya kubangela ukudideka. Kodwa apho ukwazi ukujongana? Enyanisweni, le nkqubo igcina isixa esikhulu weemfihlelo, leyo nje nina musani unikele ingqalelo. Kodwa ukuba wazi ngazo, ngoko nangoko babe oyithandayo kakhulu. Ngoko ke, kweli nqaku uza kufunda amaqhinga ezahlukeneyo malunga namashumi amabini "Eksele" ukuba wonke umntu kufuneka azi.

Khetha konke ngokucofa nje omnye

Kwikona ephezulu ekhohlo asendle kukho iqhosha apho kungekho mntu ngokuqhelekileyo alinyanzele ntoni. Kwaye iluncedo kakhulu, njengoko ivumela okukodwa-khetha zonke iiseli yoxwebhu lwangoku.

Ivula iifayile ezininzi

lweenkcukacha - oku yeyona nkalo iphambili yale program, kodwa ukuba benze ntoni xa unayo ezininzi iifayile, ngasinye apho ufuna ukusebenzisa? Nyhani ke kuyimfuneko ukuba ukuvula ngamnye ngokwahlukeneyo? Enyanisweni, kukho elinye iqhinga eya kukuvumela ukuba ukumelana msebenzi ngokukhawuleza. Khetha zonke iifayili ozidingayo kwaye cinezela i Ngena - bonke evulekileyo kunye akukho ngquzulwano phakathi kwabo.

Skrola ngokusebenzisa iifayile

Xa usebenza inani elikhulu lwamaxwebhu, kakhulu ezisenokumdina imfuneko ukuswitsha ngesandla phakathi kwabo. Uyakwazi ukwenza ubomi bakho lula ngokusebenzisa udibaniso lwesitshixo Ctrl Tab +, leyo sokuyivula ngokuzenzekelayo ukuba kwi tab elandelayo.

izinto menu

Abantu abaninzi bakholelwa ukuba "Save", "Phambili" yaye "Back" - ezi kuphela iinketho ezikhoyo kule nkqubo ukususela kwi menu phezulu. Kodwa kwakhona ukudibanisa ukuba naliphi na inani imisebenzi ngokusebenzisa izicwangciso block ezikhethekileyo - khumbula ukuba iilebhile ziboniswa ezimbini kuphela - abanye izakufihlwa.

Umgca oxwesileyo kwiseli

Ngamanye amaxesha ufuna ukucwangcisa i iseli umgca oxwesileyo ukwabelana ngolwazi, ufakelo lwezilungiso kuwo. Kodwa njani ukwenza loo nto? Bonke uyakwazi ukuchaza imida iiseli, kodwa xa unqakraza "Borders More", uya kufumana umgca oxwesileyo nje kuphela, kodwa ezinye izimanga.

Ukongeza Imiqolo ngaphezulu okanye imiqolo

Wonke umntu uyazi ukuba ukongeza indlela umqolo okanye eziqala iiseli. Kodwa ngeza iziqwenga ezimbalwa ngokwahlukileyo - oko zajika lokwenene. Ngoko ke, ndingathanda kungcono khetha olifunayo inani leeseli eziya ne olifunayo inani lemiqolo okanye imiqolo, uze uphinde ukusebenza eqhelekileyo.

transfer data Fast

Kuthekani ukuba ufuna ngokukhawuleza ukuhamba umhlathi data? Ukuze wenze oku, hambisa isalathisi elunxwemeni umhlathi, ide kuthatha uhlobo utolo cross-emile, ngoko yisa iziqulatho kwikholam ngokukhululekileyo.

Ukususwa zingabinanto iiseli

Kule nkqubo, ngokufuthi kukho inani elikhulu zingabinanto iiseli, ezonakalisa imbonakalo xwebhu. Uyakwazi ukucima nganye nganye - okanye usebenzise indlela ekhawulezayo. Ukuze wenze oku, kuya kufuneka ukuhluza ungakhethi item "Sonke" kunye ukhethe "Empty" - nto ngephanyazo kukhetha konke iiseli elingabhalwanga uxwebhu ukuba uyakwazi ukususa ngokucofa kanye.

search alunalo

Wonke umntu uyazi ukuba usebenzise indlela ukukhangela okukhawulezayo, kodwa bambalwa abantu baqonde ukuba awukwazi ukukhangela kwimidlalo ngqo, kwaye iziphumo iileta omnye okanye ngaphezulu. Ukukhangela unobumba omnye, kufuneka kwi bar yokukhangela ukuba ufake uphawu lombuzo, yaye ukuba ufuna ukuphendla ngokufaka iincwadi eziliqela - Sebenzisa i asterisk.

Yenza inani eyodwa

Abantu abaninzi basebenzisa okucoca, kodwa phantse kuyo zange khangela kwicandelo phambili. Kodwa ke, uyakwazi ukukhankanya ixabiso elilodwa iseli ethile, ukuba ufuna ngenxa yomsebenzi okanye ezinye iinjongo.

sebhithi ulwazi

Asinguye wonke umntu uyazi ukuba ungacwangcisa imida kwi yintoni inkcazelo iya wangena iseli. Umzekelo, ukuba uyila uluhlu wamema abantu ukuba lo mcimbi, kunye nobudala babo ekungabonini ukusuka kwiminyaka eli-18 ukuya kuma-60 (kuphela amanani apheleleyo) ubudala, ngoko zombini ezi ongakhetha ungakhetha kwi menu "Data" uze nezinye amaxabiso nje aziyi kwamkelwa .

navigation Quick

Kuba navigation quick ikhasi uxwebhu lo, ungasebenzisa i Ctrl isitshixo kunye iintolo. Ukuba usebenzisa olu dibaniso, uya kufika iiseli ulwazi sedatha.

inguqu

Maxa wambi kuyimfuneko ukuba ikholam emgceni, okanye ngolunye uhlobo. Eneneni, oko kunokwenziwa kakhulu nje. Ukuze wenze oku, kufuneka ukukhuphela ulwazi olufunayo, uze ubeno kuyicola kwi menu ngokukhetha "Convert" - kunye nenombolo yakho iya zikhutshelwa kwi ikholam.

Indlela ukufihla ulwazi?

In "Eksele" kufuneka ukukwazi ukuzimela ulwazi, kodwa kungenziwa ngeendlela ezahlukeneyo. Unga nqakraza kwi iseli ze ukhethe "Fihla", kodwa awuyi kuthetha isiphumo engcono. Ngako oko ke kucetyiswa ukuba usebenzise iseli ifomathi ukuya Uhlobo format ;;; - ikuvumela ukufumana ulwazi inokuthenjwa emehlweni prying efihliweyo.

Ukudibanisa data evela kwiiseli

Ukuba une iiseli ezininzi, kwaye kufuneka ukudibanisa ulwazi olugcinwe kwenye, akuyi awo ngokuyimfuneko yonke ngokupheleleyo. ubeke nje umsebenzi apho iiseli phakathi amagama efunekayo faka "ampersand" icon - isiphumo kwi ariya ekhethiweyo, ufumana yonke data evela engaphambili.

Tshintsha asezantsi abasebenzisi kwamagama aphezulu

Ukuba ufuna okubhaliweyo ukusuka kwiseli enye ukwenza ebhaliweyo ngokupheleleyo ngoonobumba abakhulu, akunyanzelekanga ukuba nokubhala ngayo ngokupheleleyo CapsLock yasebenza. Kufuneka nje ukusebenzisa umsebenzi UPPER kwindawo yegama zibonisa ukuba uhlobo yeseli kufuneka ukuba kuguqulwe.

Data eqala nge 0

Kwezinye iimeko, kusenokufuneka ukuba bangene nkcukacha zibe seli eqala 0. Ngelishwa, ngokungagqibekanga, inkqubo ususa ngokuzenzekelayo zero, eshiya ixabiso elipheleleyo kuphela. Ungatshintsha ifomathi iseli, kodwa yinkqubo ende kulula ukufaka elula icon quote elinye. Ukuba uyibeke phambi ixabiso yakho, ngoko zero iya kuhlala ndawo.

autocorrection

Abantu abaninzi basebenzisa umlungisi njengoko senzelwe, oko akoyiki ukushicilela iimpazamo, kuba bayazi ukuba software labo liya kulungisa. Kodwa bambalwa kakhulu abantu ukuba ukukhumbula ukuba usebenzise olu phawu ukuze lula umsebenzi wayo. Ukuba une amagama elide qho, amagama, ngoko unga ukubongeza kuluhlu lamagama autocorrection baze bachithe nokubhala lwabo lwesibini - kwaye inkqubo ngokwalo kubo iya kukhokelela kungena ifomu efanelekileyo, uyazibuza kanye endaweni amakhulu.

ulwazi olungaphezulu

Ukuba ukhetha iseli kwikona esezantsi ekunene kukho inkcazelo ngayo. Noko ke, ukuba kude ngokupheleleyo, kodwa unako ukufumana ukufikelela ngokupheleleyo yonke idatha. Ukuze wenze oku, kufuneka hambisa imouse yakho phezu ulwazi kwaye nqakraza kwi ekunene iqhosha le mouse - kuvula i window, eya kuqulatha yonke idatha kule seli ethile.

oyindawo amaphepha

Enye indlela elula, nto leyo ngenxa yesizathu esithile phantse mntu usebenzisa. rhoqo, kufuneka kwakhona amaphepha kuxwebhu, kwaye nangenxa yokuba nqakraza kwi gama, nqakraza-ekunene, uze ukhethe "igama", ngoko ukutshintsha igama. Kodwa inkqubo kube lula kakhulu ngokusebenzisa iphepha kumgaqo kunye ezimfutshane kunye iifayile Windows. nqakraza kabini ngokucacileyo kwi igama page kukunika ithuba yethutyana ukuhlela utshintshe ngaphandle kokulibazisa.