Uzenza njani iiMenu zokuLahla zeExcel
I-Excel sisixhobo esinamandla sokulungelelanisa kunye hlalutya idatha, kodwa amandla ayo okudala imenyu eyehlayo. Ezi menyu zinokuba yi- indlela esebenzayo kunye nendlela entle yokufaka idatha kwispredishithi, kwaye inokunceda ukuphepha iimpazamo kunye nokwenza lula imisebenzi ephindaphindwayo. Kweli nqaku, siza kuphonononga iindlela ezahlukeneyo zoku dala Ezi menyu zokuhla kwi-Excel, ukusuka kwezona zisisiseko ukuya kwezona ziphambili. Ukongeza, siya kubonelela iingcebiso namaqhinga ukuthatha inzuzo epheleleyo yalo msebenzi.
Yenza imenyu eyehlayo kwi-Excel
Yindlela egqwesileyo yokuphucula umbutho kunye nokufikeleleka kwedatha kwi-spreadsheets zakho. Iimenyu ezihlayo zivumela abasebenzisi ukuba bakhethe ngokukhawuleza ukhetho kuluhlu oluchazwe kwangaphambili, oluluncedo ngakumbi kwiimeko apho uluhlu lweenketho lunqunyelwe. Ngethamsanqa, i-Excel ibonelela ngomsebenzi wemveli ukudala ezi drop-down menu ngendlela elula nesebenzayo.
Ngokuba , ungaqala ngokuchaza uluhlu lweenketho ofuna ukuzifaka. Yi le ingayenza kwelinye ishiti le-Excel okanye kwiphepha elifanayo ofuna ukongeza kulo imenyu yokuthoba. Nje ukuba ulwenzile uluhlu, khetha iseli ofuna ukuvela kuyo imenyu ehlayo. Okulandelayo, yiya kwi "Data" isithuba ibar yesixhobo Excel kwaye ucofe ku "Ukuqinisekiswa kweDatha". Kwifestile ye-pop-up evelayo, khetha ithebhu »Useto kwaye ukhethe u-“Luhlu” kukhetho luka-“Vumela”. Emva koko, khetha i uluhlu lweeseli equlathe iinketho zoluhlu lwakho ngokusebenzisa isixhobo sokukhetha okanye ngokungenisa uluhlu ngesandla.
Nje ukuba uluqwalasele uludwe lweenketho, lulungele ukusetyenziswa njengemenyu ehlayo kwiseli ekhethiweyo. Xa umsebenzisi ecofa kwiseli, utolo oluncinci luya kuvela ecaleni kwayo. Ngokunqakraza kolu tolo, imenyu iya kuboniswa nazo zonke iinketho ezikhoyo. Umsebenzisi uya kuba nako ukukhetha ukhetho ngokucofa kuyo kwaye iseli iya kuzaliswa ngokuzenzekelayo ngokhetho olukhethiweyo. Kubalulekile ukuqaphela ukuba imenyu eyehlayo ikuvumela kuphela ukuba ukhethe ukhetho olunye ngexesha. Ukuba ufuna ukuvumela ukhetho lweenketho ezininzi, ungasebenzisa iimpawu eziphambili, ezinjengendawo ethi "Ukwehla Okuninzi".
Yenza iimenyu ukuhla kwi-excel sisixhobo esinamandla esinokuyikhawulezisa imisebenzi yakho kwaye siphucule ukusebenziseka kwe-spreadsheets zakho. yenza ifomu Ukusebenzisana okanye ukwenza lula ungeniso lwedatha, iimenyu zokuhla ziyindlela esebenzayo nesebenzayo Khumbula ukuba unokwenza ngokusesikweni iimenyu zokwehlayo usebenzisa iifomathi ezinemiqathango kunye neefomyula, ukulungelelanisa uluhlu lokhetho kwiimeko ezahlukeneyo. Zama lo msebenzi kwi-Excel kwaye ulinge ngezinto ezininzi ezinokwenzeka ezinikezelayo.
Khetha ngokuchanekileyo data kuluhlu
Yenza imenyu eyehlayo kwi-Excel Yindlela esebenzayo nelungelelanisiweyo yokuqokelela idatha ngokuchanekileyo. Nangona kunjalo, ukuze le nto isebenze ngokwenene, ibalulekile khetha idatha ngokuchanekileyo eya kuboniswa kuluhlu lokuhla. Ngale ndlela, kuqinisekisiwe ukuba abasebenzisi banokhetho olusebenzayo lokukhetha, ukunqanda iimpazamo kunye nokudideka.
Okokuqala, ibalulekile chaza injongo kuluhlu oluhlayo. Loluphi uhlobo lolwazi ekufuneka luqokelelwe? Ziziphi iindlela onokukhetha kuzo? Umzekelo, ukuba ujonge ukufumana idatha malunga namasebe enkampani, ukhetho lunokubandakanya "Ukuthengisa", "Izabasebenzi", "Imali" njalo njalo. Isisiseko Chonga amaxabiso asebenzayo ezihambelana nolwazi olufunekayo.
Okwesibini, ibalulekile Yakha uluhlu ngokuhambelanayo. Kunconywa ukusebenzisa ikholomu okanye umqolo kwiphepha le-Excel ukugcina idatha eya kuboniswa kwimenyu yokuhla. Oku kwenza kube lula ukulawula kunye nokuhlaziya kwimeko iinguqu okanye ukudityaniswa kwamaxabiso amatsha. Ukongezelela, kucetyiswa ukuba usebenzise ifomathi "yoluhlu" kwi-Excel ukwenzela ukuba idatha i-auto-scale ngokuzenzekelayo njengoko izinto zongezwa okanye zisusiwe. Oku kuqinisekisa ukungaguquguquki kunye nokusebenza ngokufanelekileyo kwemenyu eyehlayo.
Okokugqibela, ibalulekile qinisekisa kwaye uqinisekise idatha phambi kokuphumeza imenyu eyehlayo. Oku kubandakanya ukuphonononga ngononophelo uluhlu ukuqinisekisa ukuba onke amaxabiso achanekile kwaye ayahambelana. Ukongeza, ungasebenzisa "uqinisekiso lwedatha" umsebenzi kwi-Excel ukuqinisekisa ukuba kuphela iinketho ezisebenzayo ezinokuthi zikhethwe ngaphakathi kwemenyu eyehlayo. idatha eqokelelweyo.
Linyathelo elibalulekileyo ukwenza iimenyu ezisebenzayo zokuhla kwi-Excel. Ukulandela ezi ngcebiso kuqinisekisa ukuba abasebenzisi baneendlela ezifanelekileyo nezichanekileyo zokukhetha kuzo, ukuphucula umgangatho kunye nokuthembeka kolwazi oluqokelelweyo.
Sebenzisa isingqinisiso sedatha kwi-Excel
El umqinisekisi wedatha kwi-Excel sisixhobo esiluncedo kakhulu esikuvumela ukuba umisele imiqathango kwiiseli zespreadsheet. Ngalo uphawu, unokuqinisekisa ukuba idatha efakwe kwiseli ihlangabezana neemeko ezithile okanye iinqobo ezikhankanyiweyo. Oku kuluncedo ngakumbi xa ufuna ulawulo kunye nomda amaxabiso anokufakwa kwiseli enikiweyo.
Ngokuba sebenzisa idatha umqinisekisi Kwi-Excel, kufuneka ulandele ezi amanyathelo alula:
1. Khetha iseli okanye uluhlu lweeseli apho ufuna ukufaka khona isingqinisiso sedatha.
2. Cofa i-"Data" thebhu kwi-toolbar ye-Excel.
3. Kwiqela elithi "Izixhobo zeDatha", khetha "Ukuqinisekiswa kweDatha."
Nje ukuba ufikelele kwi umqinisekisi wedatha, ungaseta iintlobo ezahlukeneyo zezithintelo. Ngokomzekelo, unako qinisekisa uluhlu lwamanani ethile, ivumela kuphela amaxabiso ngaphakathi loo luhlu. Nawe unako yenza uluhlu oluya ezantsi ngeenketho ezichazwe kwangaphambili ongakhetha kuzo. Oku kuluncedo kakhulu xa ufuna ukuqinisekisa ukuba kuphela amaxabiso athile angeniswa kwiseli, njengemeko yomtshato okanye udidi lwemveliso.
Ngamafutshane, i- umqinisekisi wedatha kwi-Excel Sisixhobo esibalulekileyo sokuqinisekisa ukuchaneka kunye nokuhambelana kwedatha kwi-spreadsheet. Ngeli nqaku, unakho ukuseta izithintelo kunye neemeko kwiiseli, ezikuvumela ukuba ulawule kwaye unciphise amaxabiso anokuthi angenwe. Zama ngeendlela ezahlukeneyo kwaye usebenzise ukuqinisekiswa kwedatha ukwandisa iinkqubo zakho zokusebenza kunye nokuphucula umgangatho yedatha yakho kwi-Excel.. Ngoqheliselo oluncinci, uya kuba yincutshe ekusebenziseni esi sixhobo sixabisekileyo.
Cwangcisa iseli apho imenyu eyehlayo iya kuboniswa
Kwi-Excel, kubalulekile ukulandela la manyathelo:
1. Khetha iseli efanelekileyo: Okokuqala, kufuneka sichonge iseli apho sifuna ukuba kuvele imenyu eyehlayo. Le seli iya kuba yeyona ivumela umsebenzisi ukuba akhethe iinketho ezahlukeneyo zemenyu. Isenokuba nayiphi na iseli kwi spreadsheet.
2. Yiya kwi "Data" tab: Nje ukuba sikhethe iseli efanelekileyo, kufuneka siye kwi "Data" isithuba kwibar yesixhobo se-Excel. Apha siya kufumana zonke iinketho ezinxulumene nolawulo lwedatha kwi-spreadsheet.
3. Sebenzisa "uQinisekiso lweDatha" umsebenzi: Kwithebhu ethi "Idatha", siya kufumana umsebenzi othi "Ukuqinisekiswa kweDatha". Ngokunqakraza kulo msebenzi, ibhokisi yencoko yababini izakuvula apho sinokuchaza khona iinketho zemenu ehlayo. Kwithebhu ethi "Useto", siya kukhetha "Uluhlu" kwibala elithi "Vumela". Okulandelayo, siya kukhankanya iinketho zemenyu kwi-Origin field, eyahlulwe ngama-commas okanye ireferensi uluhlu lweeseli. Okokugqibela, siya kuqinisekisa utshintsho ngokucofa u-"Kulungile".
Ngala manyathelo alula, singakwazi kwi-spreadsheet yethu ye-Excel. Oku kuya kusivumela ukuba siphucule ukusebenziseka kunye nokusebenzisana komsebenzisi kunye nedatha, ukubonelela ngeendlela ezichazwe kwangaphambili zokukhetha.
Lungiselela inkangeleko yemenyu eyehlayo
1. Lungiselela imibala kunye neefonti: Indlela elula kwaye esebenzayo yoku Kwi-Excel kukutshintsha imibala kunye neefonti ezisetyenzisiweyo. Ungakwenza oku ngokukhetha i-drop-down menu kwaye emva koko ufikelele kwi-"Format" isithuba kwibar yesixhobo. Ukusuka apho, ungakhetha umbala ongasemva owufunayo kwimenyu eyehlayo kwaye utshintshe ifonti, ubungakanani, kunye nesimbo sezicatshulwa ezivela kuyo. Oku kuya kukuvumela ukuba ulungelelanise inkangeleko yemenyu eyehlayo kwi-aesthetics yespreadsheet sakho.
2. Yongeza ii-icon ezenziwe ngokwezifiso: Enye indlela yokwenza kukudibanisa ii icon zesiko kukhetho ngalunye. Ukwenza oku, ungasebenzisa umsebenzi we-Excel "UMyili weNto". Fikelela kuyo ukusuka "Faka" ithebhu kwi kwibar yesixhobo kwaye ukhethe i icon oyikhethayo. Emva koko, beka ii-ayikhoni kwiiseli ezihambelana nokhetho ngalunye lwemenyu eyehlayo.
3. Guqula ubungakanani kunye nendawo: Ukuba ufuna iqondo elikhulu lokwenza ngokwezifiso, ungatshintsha ubungakanani kunye nendawo yemenyu eyehlayo kwispreadsheet sakho. Ukwenza oku, khetha ngokulula imenyu eyehlayo kwaye uyitsalele kwindawo oyifunayo. Ungaphinda uhlengahlengise ubungakanani bemenyu eyehlayo ngokutsala imiphetho ukuyenza ibenkulu okanye ibencinci. Khumbula ukuba xa utshintsha ubungakanani okanye indawo yemenyu eyehlayo, kufuneka uqiniseke ukuba ayifihli ukubonakala kwezinye iinkcukacha ezibalulekileyo kwi-spreadsheet sakho.
Ngolu hlengahlengiso lulula, uya kukwazi ukwenza kwi-Excel kwaye uyenze ilungelelanise ngokugqibeleleyo neemfuno zakho kunye nezinto ozikhethayo. Linga ngemibala eyahlukeneyo, iifonti, kunye nee-icon ukuze ufezekise uyilo olufanelena nespreadsheet sakho kunye nokuboniswa kwedatha yakho. Musa ukoyika ukuphonononga kwaye ufumane zonke iinketho onokuthi u-Excel afumaneke kuzo. Yonwabela ukwenza imenyu eyehlayo!
Yongeza imiyalelo okanye imiyalezo yemposiso
Ukuya kwi-Excel yakho yemenyu eyehlayo, ungasebenzisa umsebenzi Ukuqinisekiswa kwedatha o Ukuqinisekiswa kwedatha. Eli nqaku likuvumela ukuba ulawule uhlobo lwedatha abasebenzisi abanokungena kwiseli kwaye babanike imiyalezo yempazamo okanye imiyalelo yokulungisa nayiphi na idatha engalunganga. Ngenqaku loQinisekiso lweDatha, unokuseta imithetho ethile ukunciphisa iinketho ezikhoyo kwimenyu eyehlayo kwaye uqinisekise ukuba abasebenzisi bakhetha ukhetho olusebenzayo.
Ukongeza imiyalezo yempazamo, khetha ngokulula iseli apho ufuna ukongeza ukwehla kwaye uye kwithebhu Idatha o Idatha kwi-toolbar ye-Excel. Emva koko cofa kwi ukhetho Ukuqinisekiswa kwedatha o Ukuqinisekiswa kwedatha kwaye ifestile iya kuvula. Kule festile, khetha isithuba Isilumkiso seMpazamo o Isaziso sempazamo. Apha ungangenisa umyalezo wemposiso yesiko oya kuvela xa abasebenzisi befaka idatha engalunganga kwimenyu yokwehla. Unokubonelela ngemiyalelo ecacileyo kunye necacileyo ukunceda abasebenzisi ukulungisa naziphi na iimpazamo kwaye ukhethe ukhetho olufanelekileyo.
Ukongeza ekongezeni imiyalezo yempazamo, unokongeza imiyalelo Ukukhokela abasebenzisi xa ukhetha inketho kwimenyu eyehlayo. Kwakwifestile yoQinisekiso lweDatha enye, kwithebhu Umyalezo Ofakwayo o Ungeniso lomyalezo, ungangenisa umyalezo womyalelo oza kuvela xa abasebenzisi bekhetha iseli ngemenyu ehlayo. Le miyalelo inokuba luncedo ekuchazeni injongo yemenyu ehlayo, ibonise iinketho ezikhoyo, okanye inike naluphi na olunye ulwazi olufanelekileyo ekufuneka abasebenzisi belwazi ngaphambi kokwenza ukhetho lwabo.
Hlaziya ngokuzenzekela uluhlu lwedatha
Ukwenziwa kwe iimenyu ezihlayo kwi-Excel Yindlela esebenzayo yokucwangcisa kunye nokubona amanani amakhulu edatha kwifomathi elawulekayo ngakumbi, enye yeengxaki eziqhelekileyo xa usebenza ngoluhlu lokuhla kukugcina ulwazi lusexesheni. Ngethamsanqa, i-Excel inika indlela elula nesebenzayo yoku ukuhlaziya idatha ngokuzenzekelayo kuluhlu oluhlayo.
Ngokuba ukuhlaziya idatha ngokuzenzekelayo Uluhlu oluhlayo kwi-Excel, kufuneka uqale uqinisekise ukuba idatha yakho ihlelwe kwitafile. Emva koko, ungasebenzisa umsebenzi iitafile zepivot ukudibanisa idatha ekwitheyibhile kuluhlu lokuhla.
Enye indlela ukuhlaziya idatha ngokuzenzekelayo yoluhlu oluhlayo kwi-Excel ngokusebenzisa i-Power Query add-in Ngombuzo waMandla, unokukhupha idatha kwimithombo eyahlukeneyo, efana nedathabhesi kunye neefayile zangaphandle, kwaye uyongeze kwincwadi yakho ye-Excel. Emva koko unokudibanisa uluhlu oluhlayo kwidatha ethunyelwa ngaphandle kwaye uqwalasele idatha ukuhlaziya ngokuzenzekelayo xa utshintsho lwenziwa kumthombo wokuqala.
Ngokufutshane, i-Excel inika iindlela ezahlukeneyo zokukhetha ukuhlaziya idatha ngokuzenzekelayo kuluhlu olwehlayo. Nokuba kungeetafile zepivot okanye iplugin yoMbuzo waMandla, ezi mpawu zikuvumela ukuba ugcine uluhlu lwakho lokuhla lusexesheni ngokufanelekileyo. Ngezi zixhobo onazo, uya kukwazi ukusebenza ngedatha esexesheni kwaye wenze izigqibo ezinolwazi ngakumbi kuhlalutyo lwakho kwi-Excel.
Sebenzisa imenyu eyehlayo kwiifomyula kunye nemisebenzi
—
Imenyu yokuhla sisixhobo esinamandla kwi-Excel evumela abasebenzisi ukuba benze uluhlu oluhlayo kwiiseli zespredishithi. Olu phawu luluncedo ngakumbi xa usebenza ngeefomula kunye nemisebenzi, njengoko yenza ukufakwa kwedatha kube lula kwaye kunciphise iimpazamo. Ngokuba Kuqala kufuneka wenze uluhlu oluhlayo ngamaxabiso ofuna ukuwasebenzisa. Ungakwenza oku ngokukhetha iiseli apho ufuna uluhlu oluhlayo luvele, kwaye emva koko uye kwi "Data" ithebhu kwiribhoni kwaye ukhethe "Ukuqinisekiswa kweDatha." Okulandelayo, khetha "Uluhlu" ukhetho kwifestile yencoko yababini kwaye uchaze amaxabiso ofuna ukuwabonisa kuluhlu, olwahlulwe ziikoma.
Nje ukuba udale uluhlu lwakho lokuhla, unako yisebenzise kwiifomula kunye nemisebenzi yakho. Endaweni yokuba uchwetheze amaxabiso okanye iireferensi kwiiseli ofuna ukuzisebenzisa, unokuzikhetha ngokulula kuluhlu oluhlayo. Umzekelo, ukuba unoluhlu oluhlayo olunamagama abantu osebenza nabo kwaye ufuna ukubala isixa-mali sentengiso nganye kubo, kufuneka ukhethe igama lomntu ngamnye kuluhlu oluhlayo njengenxalenye. yefomula. Ngale ndlela, uya kuphepha ukubhala iimpazamo kwaye ugcine ixesha lokufaka idatha.
Ukongeza ekwenzeni kube lula ukufaka idatha, ukusebenzisa imenyu yokuhla kwiifomyula kunye nemisebenzi ikwabonelela ngokuguquguquka okukhulu kunye nokulula kokusetyenziswa kwespredishithi sakho. Ungahlaziya ngokulula amaxabiso kuluhlu lokuhlayo xa kukho imfuneko, ngaphandle kokutshintsha ngesandla zonke iiseli ezisetyenziswa kuzo. Unokongeza amaxabiso amatsha kuluhlu okanye ucime asele ekhona ngokukhawuleza nangokulula. Oku kukuvumela ukuba ulungelelanise iifomula zakho kunye nemisebenzi Ngokweemfuno zakho zokutshintsha kwaye wenze uhlengahlengiso ngokulula ngaphandle kobunzima. Ngamafutshane, imenyu eyehlayo sisixhobo esibalulekileyo kwabo bafuna ukwandisa umsebenzi wabo kwi-Excel kwaye bafumane iziphumo ezichanekileyo nezisebenzayo.
Ziphephe iimpazamo eziqhelekileyo xa usenza imenyu eyehlayo kwi-Excel
Yenza i imenyu ukuhla kwi-excel Kungaba ngumsebenzi olula, kodwa kubalulekile ukuphepha iimpazamo eziqhelekileyo ezinokwenza inkqubo ibe nzima ngakumbi kunokuba kuyimfuneko. Nanga amanye amacebiso okunqanda ezi mpazamo kwaye uqiniseke ukuba iimenyu zokwehlayo zisebenza ngokuchanekileyo.
Enye yezona mpazamo zixhaphakileyo xa usenza imenyu eyehlayo kwi-Excel ayichazi kakuhle uluhlu lweenketho. Kubalulekile ukuqinisekisa ukuba uluhlu lweenketho lubekwe kwikholamu ethile okanye uluhlu kwispredishithi sakho. Ngale ndlela, uya kuba nakho ukubhekisa olu luhlu xa usenza imenyu eyehlayo.
Enye impazamo eqhelekileyo ayiluchazi kakuhle uluhlu lwedatha xa usenza imenyu eyehlayo. Qinisekisa ukuba uluhlu lwedatha lubandakanya zonke iinketho zoluhlu ofuna ukuzibonisa kwimenyu. Kwakhona, qinisekisa ukuba ukhethe u- "Uluhlu" ukhetho kwibhokisi yoluhlu lwemenu eyehlayo.
NdinguSebastián Vidal, injineli yekhompyuter ethanda itekhnoloji kunye ne-DIY. Ngaphaya koko, ndingumdali we tecnobits.com, apho ndabelana ngee-tutorials ukwenza itekhnoloji ifikeleleke kwaye iqondeke kumntu wonke.