Ama-Dos no-Dont wokufaka idatha ku-Excel

by I-Ted French

01 ngo-08

I-Excel Data Entry Overview

I-DO ne-DON'Ts ye-Data Entry. © Ted French

Le tutorial ihlanganisa ezinye ze-DOs kanye ne-DON'Ts eziyisisekelo zokufaka idatha kumahlelo wespredishithi njenge-Excel, i-Google Spreadsheets, ne-Open Office Calc.

Ukufaka idatha kahle okokuqala kungagwema izinkinga kamuva futhi kwenze kube lula ukusebenzisa amathuluzi amaningi kanye nezici ezifana namafomula namashadi.

I-DOs kanye ne-DON'Ts yilezi:

Hlela ipredishithi lakho
Ungayishiyi Imigqa Engacacile noma Amakholomu Uma Ufaka Imininingwane Ehlobene
Gcina Ngokuvamile futhi Ugcine Ezindaweni Ezibili
Ungasebenzisi Amanani njengezihloko zekholomu futhi ungafaki izinyunithi nedatha
Sebenzisa Amakhophi Ezingcingo Namabala Abizwa Ngamafomula
Ungashiyi Amaseli aqukethe Amafomu Avuliwe
Hlunga Ukwaziswa Kwakho

Hlela Ispredishithi Yakho

Uma kuziwa ekungeneni idatha ku-Excel, kuwumqondo omuhle ukwenza okuncane kokuhlela ngaphambi kokuba uqale ukuthayipha.

Ukwazi ukuthi ishidi lomsebenzi lizosetshenziselwa, idatha ezoyiqukatha, nokuthi yini ezokwenziwa ngaleyo datha ingathinta kakhulu isakhiwo sokugcina sephepha lokusebenzela.

Ukuhlela ngaphambi kokuthayipha kungasindisa isikhathi kamuva uma ispredishithi sidinga ukuhlelwa kabusha ukuze senze kahle futhi sisebenze kangcono.

Okucatshangelwe Ukucabangela

Iyini injongo yespredishithi?
I-spreadsheet ingabamba idatha engakanani?
Ingabe amashadi adingekayo?
Ingabe ispredishithi izophrinta?

Iyini Inhloso YeSpredishithi?

Inhloso yespredishithi izosiza ekunqumeni indawo yedatha, njengoba ulwazi olubaluleke kakhulu ludinga ukubonakala nokufinyeleleka kalula.
Yiziphi izibalo ezidingekayo? Ukubala kuthinta ukuthi yimaphi amafomu nemisebenzi edingekayo nokuthi bazophi.

IsiSpredishithi Sizobamba Kangakanani Idatha?

Idatha yedatha ispredishithi izobamba kuqala nokuthi kungakanani okuyokwengezwa kamuva kuzothinta inani lamashidi okusebenza asetshenzisiwe.

Ungasakazeli idatha yakho kakhulu ngoba ingenza ulwazi oluthile lukhuni ukuthola nokuthi izibalo zithinta amashidi amaningi noma izincwadi zokusebenza zingase zithinte ukusebenza kwe-Excel.
Emafishini amakhulu omsebenzi , ngezinye izikhathi kuyasiza ukubonisa izamba zekholomu ezibalulekile ngaphezu kwezihloko zekholomu, kunokuba ucindezele abasebenzisi ukuba baphelele phansi kwephepha lokusebenzela ukuze babone ulwazi.

Ingabe Kudingeka Amashadi?

Uma konke noma ingxenye yedatha kufanele iboniswe eshadini noma emashadi, kungathinta ukuhlela ulwazi,

Kuye ngohlobo lweshadi, idatha ingase idingeke ihlelwe ngokuhlukile - njengokusebenzisa indawo yesifinyeto se-pie charts.
Ngezipredishithi ezinkulu, amashadi angathuthelwa emakhasini ahlukene ukuze anciphise ukuqhuma

Ingabe Ispredishithi Sizoprintwa?

Ukuthi idatha ihlelwe kanjani ingathinteka uma yonke imininingwane noma enye yedatha izophrinta, kuye ngokuthi ngabe i-portrait noma indawo ye-landscape ikhethiwe futhi inani lamashidi liyadingeka.

Uma umbono wesithombe sokubuka iphepha elijwayelekile (8 1/2 X 11) kufanele lisetshenziswe, cabanga ukubeka iningi lemininingwane emigqeni ngaphansi kwamakholomu ambalwa, ukuze zonke izihloko zibonwe ephepheni elilodwa.
Uma kudingeka amashidi amaningi, cabanga ngezihloko zekholomu yokunyathelisa phezulu kwekhasi ngalinye ukwenza ukufunda idatha kube lula.
Uma amakholomu amaningi edatha adinga ukunyatheliswa, ukuhlelwa kwezwe kungagcina zonke izihloko ekhasini elilodwa. Futhi, uma kudingeka amashidi amaningi, phrinta izihloko zekholomu phezulu kwekhasi ngalinye.
Uma amashadi kufanele ashicilelwe, ukuwahambisa kwelinye ishidi kungenza umsebenzi ube lula.

02 ngo-08

Ungayishiyi Imigqa Engenalutho noma Amakholomu kuDatha Ehlobene

Ungayishiyi Imigqa Engacacile noma Amakholomu. © Ted French

Ukushiya imigqa noma amakholomu angenalutho kumatafula wedatha noma eminye imikhakha yedatha kungenza kube nzima kakhulu ukusebenzisa izici eziningi ze-Excel njengama-charts, amatafula we-pivot, nemisebenzi ethile.

Ngisho namangqamuzana angenalutho emgqeni noma ikholomu equkethe idatha angabangela izinkinga njengoba kuboniswa esithombeni ngenhla.

Ukungabikho kwezikhala ezingenalutho kuzokwenza kube lula ku-Excel ukuthola nokukhetha yonke idatha ehlobene ebangeni uma izici ezifana nokuhlunga , ukuhlunga, noma i- AutoSum zisetshenzisiwe.

Esikhundleni sokushiya imigqa noma amakholomu angenalutho, sebenzisa imingcele noma ukufometha kwefomethi namalebula usebenzisa isibindi noma ucindezela ukuze uhlukanise idatha futhi wenze kube lula ukufunda.

Faka idatha yakho yekholomu-ohlakaniphile uma kungenzeka.

Lapho ubeka isipredishithi sakho, faka isihloko esichazayo phezulu kwekholomu yokuqala yetafula nedatha ngezansi.
Uma kunezinchungechunge ezingaphezu kweyodwa yedatha, zifake ohlwini olulodwa ngemuva kwamanye amakholomu (kwesobunxele kuya kwesokudla) isihloko sesichungechunge ngasinye sedatha phezulu.

Gcina Idatha Engavumelani Ehlukile

Ngenkathi ukugcina idatha ehlobene ndawonye kubalulekile, ngesikhathi esifanayo, kungaba usizo ukugcina uhlu oluhlukile lwedatha oluhlukene.

Ukushiya amakholomu angenalutho noma imigqa emkhatsini wedatha ehlukile yedatha noma enye idatha ekhasini lokusebenzela lizophinde lenze kube lula ku-Excel ukubona ngokufanele futhi ukhethe amabanga ahlobene noma amatafula wedatha.

03 ngo-08

Gcina Ngokuvamile

Londoloza Idatha Yakho Ngokuvamile. © Ted French

Ukubaluleka kokulondoloza umsebenzi wakho kaningi akukwazi ukunqwabelana - noma kuboniswe kaningi.

Yiqiniso, uma usebenzisa ispredishithi esekelwe kuwebhu - njenge-Google Spreadsheets noma i-Excel Online - bese ulondoloza akuyona inkinga, ngoba akukho hlelo olunezinketho zokulondoloza kodwa, esikhundleni salokho, sebenzisa isici sokulondoloza auto.

Mayelana nezinhlelo zekhompiyutha kodwa, emva kokushintsha okungu-2 noma ezintathu-kungakhathaliseki ukuthi kwengeza idatha, ukwenza ushintsho lokufometha, noma ukufaka ifomula - londoloza iphepha lokusebenzela.

Uma lokho kubonakala kuningi, gcina okungenani njalo imizuzu emibili noma emithathu.

Ngisho noma ukuzinza kwamakhompiyutha kanye nesofthiwe yekhompiyutha sekuthuthukile kakhulu eminyakeni embalwa edlule, isofthiwe isaphazamisa, ukuhluleka kwamandla okwenzekayo, futhi abanye abantu ngezinye izikhathi bahamba ngentambo yakho yamandla bese bayidonsela ngaphandle kwodonga.

Futhi uma kwenzeka, ukulahlekelwa kwanoma yiliphi inani lemininingwane - enkulu noma encane - kwandisa kuphela umthwalo wakho womsebenzi njengoba uzama ukuvuselela lokho okwenzile kakade.

I-Excel inesici sokulondoloza ngokuzenzakalela , esivame ukusebenza kahle, kodwa akufanele sithembele. Thola umkhuba wokulondoloza idatha yakho siqu ngokusindisa okujwayelekile.

Isinqamuleli ekugcineni

Ukulondoloza akudingeki kube ngumsebenzi onzima wokuhambisa igundane ku-ribbon bese uchofoza izithonjana, ungene emkhakheni wokugcina usebenzisa inhlanganisela yokunciphisa ikhibhodi ye:

I-Ctrl + S

Gcina ezindaweni ezimbili

Esinye isici sokulondolozwa esingenakuqedwa kakhulu ukubaluleka kokulondoloza idatha yakho ezindaweni ezimbili ezihlukene.

Indawo yesibili yiqiniso, isiphequluli, futhi sekushiwo kaningi, "Izipele zifana nomshuwalense: unalo futhi cishe ngeke uyidinge, awunayo futhi cishe uzobe".

Ukusekela okungcono kunazo zonke okunye okubonakalayo endaweni yangempela kusuka ekuqaleni. Ngempela, yini iphuzu lokuba namakhophi amabili efayela uma

zikhona ku-hard drive efanayo ehlulekayo?
kukhompyutha efanayo, lokho okubiwe?
esakhiweni esifanayo esishisa phansi?

Izipele ezisekelwe kuwebhu

Futhi, ukwenza isipele akudingeki kube umsebenzi onomdlandla noma ochitha isikhathi.

Uma ukuvikeleka akuyona inkinga - ishidi lokusebenzela liluhlu lwe-DVD yakho - thumela i-imeyili ikhophi usebenzisa i-web mail ukuze ikhophi ihlale kuseva cishe iyanele.

Uma ukuphepha kuyinkinga, isitoreji sewebhu sisengakhetha - nakuba inkampani ekhethekile kulokho uhlobo futhi ikhokhisa imali yokwenza kanjalo.

Uma kwenzeka amaspredishithi e-intanethi, cishe, abanikazi bezinhlelo balondoloza amaseva wabo - futhi lokhu kuhlanganisa yonke idatha yomsebenzisi. Kodwa ukuze uphephe, landa ikhophi yefayela kukhompyutha yakho.

04 ngo-08

Ungasebenzisi Amanani njengezihloko zekholomu futhi ungafaki izinyunithi nedatha

Ungasebenzisi Izinombolo zekholomu noma izihloko zemijaho. © Ted French

Sebenzisa ama-headings phezulu kwekholomu futhi ekuqaleni kwemigqa ukukhomba idatha yakho, njengoba benza imisebenzi efana nokwenza okulula kakhulu, kodwa ungasebenzisi izinombolo ezifana no-2012, 2013, njalonjalo-ukukwenza.

Njengoba kuboniswe esithombeni esingenhla, izingqikithi zekholomu kanye ne-row eziyizinamba nje zingase zifakwe ngokungabonakali ekubalweni. Uma amafomula akho aqukethe imisebenzi efana nalokhu:

ukuthi ngokuzenzakalelayo ukhethe uhla lwemininingwane yempikiswano yomsebenzi.

Ngokuvamile, imisebenzi enjalo iqala ukubheka amakholomu ezinombolo ngenhla lapho ikhona khona bese ngakwesokunxele ngenombolo yezinombolo, futhi noma yiziphi izihloko eziyizinombolo nje ezizofakwa ebangeni elikhethiwe.

Izinombolo ezisetshenziswe njengezingqimba zomugqa zingaphinde zenze iphutha njengenye uchungechunge lwedatha uma zikhethiwe njengengxenye ebangeni leshadi kunokuba zibe amalebuli ezinkomba.

Fometha izinombolo kumaseli okuqondisa njengombhalo noma ukudala amalebuli wombhalo ngokulandelana kwenombolo ngayinye nge-apostrophe (') - njenge' 2012 no '2013. I-apostrophe ayibonisi esitokisini, kodwa ishintsha inombolo ukuthumela idatha.

Gcina izinyunithi ezihlokweni

Ungafaki: faka imali, izinga lokushisa, ibanga noma amanye amayunithi esitokisini ngasinye ngenombolo yocingo.

Uma wenza, kunethuba elihle lokuthi i-Excel noma i-Google Spreadsheets izobuka yonke idatha yakho njengombhalo.

Esikhundleni salokho, faka izingxenye ezihlokweni ezingaphezulu kwekholomu, okuzokwenza ukuthi, njengoba kwenzeka, kuzoqinisekisa ukuthi lezo zihloko okungenani ziyi-text futhi ngeke zidale inkinga okukhulunywe ngenhla.

Umbhalo kuya kwesobunxele, izinombolo ngakwesokudla

Indlela esheshayo yokutshela ukuthi unombhalo noma idatha yocingo ukuhlola ukulungiswa kwedatha esitokisini. Ngokuzenzakalelayo, idatha yombhalo ihambelana ngakwesobunxele ku-Excel kanye ne-Google Spreadsheets nedatha yenombolo ihambelana ngakwesokudla kuseli.

Nakuba lokhu kulungiswa okuzenzakalelayo kungashintshwa kalula, ukufometha akusetshenziswanga ngokujwayelekile kuze kube yilapho zonke idatha kanye namafomula zifakiwe, ngakho ukulungiswa okuzenzakalelayo kungakunika imininingwane ngaphambi kokuthi kukhona okuthile okufakiwe ekhasini lokusebenzela.

Amaphesenti Namaphesenti Emali

Umkhuba omuhle wokungena yonke idatha kufasitelana lokufaka isicelo ukufaka inombolo nje ethafeni bese ufometha iseli ukubonisa inombolo ngokufanele - futhi lokhu kuhlanganisa amaphesenti kanye nemali yemali.

I-Excel ne-Google Spreadsheets, noma kunjalo, yamukela izimpawu zamaphesenti ezifakwe esitokisini kanye nenombolo bobabili futhi bayaqaphela izimpawu zemali ezivamile, njengesibonakaliso se-dollar ($) noma uphawu lwepound yaseBrithani (£) uma zifakwe efenjini iseli kanye nedatha yenombolo, kodwa ezinye izimpawu zemali, njengeRandi laseNingizimu Afrika (R), cishe zizohunyushwa njengombhalo.

Ukuze ugweme izinkinga ezingase zibe khona, landela umkhuba ongcono okukhulunywe ngenhla bese ufaka inani bese ufometha iseli ngemali kunokuthayipha uphawu lwemali.

05 ka-08

Sebenzisa Amakhophi Ezingcingo Namabala Abizwa Ngamafomula

Ukusebenzisa imigqa ebizwa ngamagama kanye nezinkomba zezigcawu emafomu. © Ted French

Zombili izingcaphuno zamaseli kanye nemigqa ebizwa ngokuthi ingaba futhi kumele zisetshenziswe emafomulini ukwenza kube lula futhi kube lula ukugcina amafomula kanye nokwandiswa, lonke iphepha lokusebenzela, amaphutha okungafani futhi kusesikhathini.

Izinkomba zeselula ziyinhlanganisela yombhalo wekholomu nenombolo yomugqa weseli - njenge-A1, B23, ne-W987 - futhi isetshenziselwa ukukhomba indawo yedatha kushidi lokusebenzela.
Ibanga elibizwe noma igama elichazwe lifana nereferensi yeseli lapho lisetshenziselwa ukukhomba iseli noma uhla lwamaseli kufomethe lokusebenzela.

Ukubonisa Idatha kumafomula

Amafomu asetshenziswa ku-Excel ukwenza izibalo - njengokufaka noma ukususa.

Uma izinombolo zangempela zifakiwe emafomulini - njenge:

= 5 + 3

Njalo lapho idatha iguquka- isho ku-7 no-6, ifomula idinga ukuhlelwa futhi izinombolo zishintshiwe ukuze ifomula iba:

= 7 + 6

Uma, esikhundleni salokho, idatha ingene kumaseli ekhasini lokusebenzela, izingcaphuno zamaseli - noma amagama ebanga - zingasetshenziswa kwifomula kunezinombolo.

Uma inombolo engu-5 efakwe esitokisini A 1 no-3 ibe yiseli A2, ifomula iba:

= A1 + A2

Ukuze ubuyekeze idatha, shintsha okuqukethwe kwamaseli A1 no-A2, kodwa ifomula ihlala efanayo - i-Excel ivuselela ngokuzenzakalelayo imiphumela yefomula.

Ukugcinwa kwesikhathi kanye nomzamo kwanda uma iphepha lokusebenzela liqukethe amafomula amaningi anzima futhi uma amafomula amaningi ekhomba idatha efanayo kusukela idatha idinga ukuguqulwa endaweni eyodwa kuphela futhi wonke amafomula awakhumayo azobuyekezwa.

Ukusebenzisa amareferensi weselula noma amabanga akhethiweko nakho kwenza iphepha lakho lokusebenzela livikeleke, ngoba likuvumela ukuba uvikele amafomula kusuka kushintsho lwengozi ngenkathi ushiya amaseli wedatha ashintsha ukufinyeleleka.

Ukukhomba kuDatha

Esinye isici se-Excel nama-Google Spreadsheets ukuthi akuvumela ukuthi ufake amareferensi weselula noma amagama ebanga ngamafomula usebenzisa ukukhomba - okufaka ukuchofoza esitokisini ukufaka ireferensi kwifomula.

Ukuphawula kunciphisa amathuba okuba amaphutha abangelwa ukuthayipha ekubhekiseni okungalungile kwamaseli noma ukungaphumeleli igama lebanga.

Sebenzisa Amathrekhi Aqanjwe Ukukhetha Idatha

Ukunikeza indawo ehambisana nedatha igama lingenza kube lula ukukhetha idatha uma wenza izinhlobo noma imisebenzi yokuhlunga.

Uma ubukhulu bezinguquko zendawo yedatha, ububanzi begama lungenziwa kalula ngokusebenzisa iMenenja Yegama .

06 ka-08

Ungashiyi Amaseli Aqukethe Amafomula Avikelekile

Ngemuva kokuchitha isikhathi esiningi ukuthola imibono yabo iqondise futhi isebenzise izikhombisi eziqondile zamangqamuzana, abantu abaningi benza iphutha lokushiya lawo mafomula abhekene nezinguquko ezenzakale noma ezihlose.

Ngokubeka idatha emasethini kwiphepha lokusebenzela bese ucacisa leyo datha ngamafomula, ivumela amaseli aqukethe amafomula ukuba avaliwe futhi, uma kunesidingo, iphasiwedi ivikelwe ukuwagcina ephephile.

Ngesikhathi esifanayo, amaseli aqukethe idatha angashiywa avuliwe ukuze izinguquko zingene kalula ukuze kugcinwe ispredishithi.

Ukuvikela ishidi lokusebenzela noma ibhuku lezinqubo kuyinkqubo ezinyathelo ezimbili:

Qiniseka ukuthi amaseli afanele avaliwe
Faka isicelo sephepha lokuvikela - futhi uma uthanda, engeza iphasiwedi

07 ngo-08

Hlunga Ukwaziswa Kwakho

Hlunga idatha yakho ngemuva kokuqeda ukuyifaka.

Ukusebenza ngemali encane yemininingwane engafanelekile ku-Excel noma i-Google Spreadsheets akuyona inkinga, kodwa njengoba inani leminye imininingwane landa ngakho kunzima ukusebenzisana nayo ngokuphumelelayo.

Idatha ehleliwe kulula ukuyiqonda nokuhlaziywa futhi eminye imisebenzi namathuluzi, afana ne- VLOOKUP ne- SUBTOTAL adinga idatha ehlelwe ukuze abuyisele imiphumela efanele.

Futhi, ukuhlunga idatha yakho ngezindlela ezahlukene kungenza kube lula ukubona izitayela ezingabonakali ekuqaleni.

Ukukhetha idatha okufanele ihlungwe

Ngaphambi kokuba idatha ihlelwe, i-Excel idinga ukwazi ukuthi yikuphi uhla oluzohlungwa, futhi ngokuvamile, i-Excel inhle kakhulu ekukhetheni izindawo ezihlobeneyo - uma nje ingenisiwe,

akukho imigqa noma amakholomu angagcini asele ngaphakathi kwendawo ehlobene;
futhi imigqa namakholomu angenalutho ashiywe phakathi kwezindawo zedatha ehlobene.

I-Excel izokwazi ngisho nokunquma, ngokunembile, uma indawo yedatha inamagama ensimu futhi ingabandakanyi lo mgca kusuka kumarekhodi azohlungwa.

Noma kunjalo, ukuvumela i-Excel ukukhetha ububanzi obuzohlungwa kungaba yingozi - ikakhulukazi ngemali enkulu yedatha enzima ukuyihlola.

Ukusebenzisa Amagama Ukukhetha Idatha

Ukuqinisekisa ukuthi idatha echongiwe ikhethiwe, qokomisa ububanzi ngaphambi kokuqala uhlobo.

Uma ibanga elifanayo lizohlelwa ngokuphindaphindiwe, indlela engcono kakhulu ukuyibeka iName.

Uma igama lichazwa ububanzi obuzohlungwa, thayipha igama ebhokisini legama , noma ukhethe ohlwini oluhlehlisiwe oluhambisana nalo kanye ne-Excel luzogqamisa ngokuzenzakalelayo uhla olufanele lwemininingwane ekhasini lokusebenzela.

Imigqa Efihlekile kanye Namakholomu Nokuhlelwa

Imigqa efihliwe namakholomu wedatha awahanjiswa ngesikhathi sokuhlunga, ngakho-ke kudingeka adalulwe ngaphambi kokuba uhlobo lube khona.

Isibonelo, uma irowu 7 lifihlekile, futhi liyingxenye yolwazi oluhlehlisiwe, luzohlala njengolayini 7 kunokuba luhanjiswe endaweni yalo efanele ngenxa yoluhlobo.

Okufanayo kuya kumakholomu wedatha. Ukuhlunga ngemigqa kuhilela ukuvuselela amakholomu wedatha, kodwa uma ikholomu B ifihliwe ngaphambi kohlobo, izohlala njengekholomu B futhi ingabuyiselwanga namanye amakholomu ebangeni elihlelwe.

08 ngo-08

Wonke Amanani Kufanele Abe Izitolo njengezinombolo

Issue: Hlola ukuthi zonke izinombolo zigcinwe njengezinombolo. Uma imiphumela ayikho okwakulindele, ikholomu ingase ibe nezinombolo ezigcinwe njengombhalo hhayi njengezinombolo. Isibonelo, izinombolo ezimbi ezifakiwe ezivela kwezinye izinhlelo zokucubungula noma inombolo efakwe nge-'prophephe 'ehamba phambili igcinwa njengombhalo.

Uma uhlela ngokushesha idatha nge inkinobho AZ noma ZA, izinto zingahamba kabi kakhulu. Uma kukhona umugqa ongacacile noma amakholomu angenalutho ngaphakathi kwedatha, ingxenye yedatha ingahle ihlelwe, kanti enye idatha inganakwa. Ake ucabange ukuthi uzoba nobani, uma amagama nenombolo yocingo engavumelani, noma uma ama-oda ahamba kumakhasimende angalungile!

Indlela elula yokuqinisekisa ukuthi uhla olufanele lwedatha lukhethiwe ngaphambi kokuhlunga ukulunika igama.

Ukucabanga kokubili kuthinta ukuthi yiziphi izinhlobo ze-Excel. Uma unesisodwa esisodwa esikhethiwe, i-Excel ifinyelela ukhetho ukukhetha ibanga (kufana nokucindezela i-Ctrl + Shift + 8) ehlotshiswe ngekholomu eyodwa noma ngaphezulu engenalutho. I-ke ihlola umugqa wokuqala ebangeni elikhethiwe ukucacisa ukuthi iqukethe ulwazi lwekhanda noma cha.

Yilapho ukuhlunga ngamathuluzi webha yamathuluzi kungabakhohlisa-ikhanda lakho (ekuboneni unalo) kumele lihlangabezane neziqondiso ezinzima kakhulu ukuze i-Excel ibone njengesihloko. Isibonelo, uma kunamaseli angenalutho emgqeni wekhanda, i-Excel ingacabanga ukuthi akuyona inhloko. Ngokufanayo, uma umugqa wekhanda ufomathiwe ofanayo neminye imigqa ebangeni ledatha, kungenzeka ukuthi awuwuboni. Futhi, uma ithebula lakho lemininingwane linamathekisthi ngokuphelele futhi umugqa wakho wekhanda awuqukethe lutho ngaphandle kombhalo, i-Excel izoba cishe cishe sonke isikhathi-ukuhluleka ukuqaphela umugqa wenhloko. (Umugqa ubukeka njengenye enye umugqa wedatha ku-Excel.)

Ngemuva kokuba ukhethe uhla bese uthola ukuthi kukhona yini umugqa wezinhloko kuzokwenza u-Excel enze ukuhlunga kwangempela. Yeka ukuthi ujabule kangakanani nemiphumela kuncike ekutheni i-Excel ithole kokubili ukukhetha kwebanga kanye nokuzimisela komugqa wekhanda ngakwesokudla. Isibonelo, uma i-Excel ingacabangi ukuthi unomugqa wekhanda, futhi wenza kanjalo, ikhanda lakho lihlelwa emzimbeni wedatha; lokhu ngokuvamile kuyinto embi.

Ukuze uqinisekise ukuthi ibanga lakho lwedatha liyabonakala kahle, sebenzisa isinqamuleli se-Ctrl + Shift + 8 ukuze ubone ukuthi i-Excel ikhetha ini; yilokho okuzohlungwa. Uma ingavumelani nokulindela kwakho, khona-ke udinga ukuguqula umlingisi wedatha etafuleni lakho, noma udinga ukukhetha ibanga ledatha ngaphambi kokusebenzisa ibhokisi lebhokisi lengxoxo.

Ukuze uqiniseke ukuthi isihloko sakho sibonakala kahle, sebenzisa isinqamuleli se-Ctrl + Shift + 8 ukuze ukhethe ibanga ledatha, bese ubheka umugqa wokuqala. Uma ikhanda lakho lingenalutho lamaseli phakathi kwalabo abakhethiwe emgqeni wokuqala noma umugqa wokuqala ufomatiwe njengelinye irowu yesibili, noma unamakheli angaphezu kweyodwa ekhanda, bese i-Excel inquma ukuthi awunawo umugqa wekhanda nhlobo. Ukuze ulungise lokhu, yenza ushintsho kumugqa wakho wenhlokweni ukuze uqiniseke ukuthi uyaqashelwa kahle yi-Excel.

Okokugcina, wonke amabhethri angahle aphelelwe uma ithebula lakho lemininingwane lisebenzisa izihloko zamarowu amaningi. I-Excel inenkathi enzima ukuyiqaphela. Uhlanganisa inkinga uma ulindele ukuthi ifaka imigqa engacacile kuleso sihloko; akukwazi nje ukukwenza ngokuzenzakalelayo. Nokho, ungakhetha nje yonke imigqa ofuna ukuyihlela ngaphambi kokwenza uhlobo. Ngamanye amazwi, yiba yilokho okufunayo i-Excel; ungavumeli i-Excel yenza ukucabanga kwakho.
Izinsuku Nezikhathi Ezigcinwe Njengombhalo

Uma imiphumela yokuhlunga ngedethi ingaphenduki njengoba kulindelwe, idatha ekholomu equkethe ukhiye wokuhlunga ingase iqukathe izinsuku noma izikhathi ezigciniwe njengedatha yombhalo kunokuba njengezinombolo (izinsuku kanye nezikhathi nje nje idatha yedatha efomethiwe).

Emfanekisweni ngenhla, irekhodi lika-A. Peterson laphela phansi ohlwini, lapho, ngokususelwa ngosuku lokuboleka - uNgovemba 5, 2014 -, irekhodi kufanele libekwe ngaphezu kwerekhodi lika-A. Wilson, unomhla wokuboleka kaNovemba 5.

Isizathu semiphumela engalindelekile yukuthi usuku lokuboleka luka-A. Peterson lugcinwe njengombhalo, kunokuba kube inombolo
Data Mixed and Izinhlobo Quick.

Uma usebenzisa indlela yokwenza okusheshayo yamarekhodi equkethe umbhalo kanye nenombolo yocingo ehlanganisiwe ndawonye, i-Excel ihambisa inombolo nenamba yombhalo ngokwahlukana - ukubeka amarekhodi ngedatha yombhalo ngezansi ohlwini oluhleliwe.

I-Excel ingase iphinde ihlanganise izihloko zekholomu ngemiphumela enhle - ukuzihumusha njengenye enye umugqa wedatha yombhalo kunokuba njengamagama endle yedatha yedatha.
Hlunga izixwayiso - Hlunga ibhokisi lokuxoxa

Njengoba kuboniswe esithombeni ngenhla, uma ibhokisi lebhokisi lengxoxo lisetshenzisiwe, ngisho nangezinhlobonhlobo kukholomu eyodwa, i-Excel ibonisa umyalezo okuxwayisa ukuthi uhlangabezane nedatha egciniwe njengombhalo futhi ikunika ukhetho ku:

Hlunga noma yini ebukeka njengenombolo njengenombolo
Hlunga izinombolo nezinombolo ezigcinwe njengombhalo ngokwahlukana

Uma ukhetha ukhetho lokuqala, i-Excel izama ukubeka idatha yombhalo endaweni efanele yemiphumela enhle.

Khetha ukhetho lwesibili futhi i-Excel izobeka amarekhodi aqukethe idatha yombhalo phansi kwemiphumela ehle - njengoba nje yenza ngezinhlobo ezisheshayo.