Amathebula namabanga ku-Excel: umhlahlandlela ophelele wokuqonda kahle idatha yakho

Uma usebenza ne-Excel nsuku zonke, ukwazi kahle amaseli, ububanzi, namathebula Kwenza umehluko phakathi kokukhubeka nokuhamba kahle. Kulo mhlahlandlela ophelele, sizobuyekeza, ngokuthula kodwa ngokufushane, ukuthi lezi zinto zisebenza kanjani, ukuthi zihlobana kanjani, nokuthi singazisebenzisa kanjani emisebenzini yangempela, kusukela ekufomeni kuya ekwenzeni ukuhlaziywa okuthuthukisiwe.

Uzobona ukuthi yini ngempela Iseli le-ExcelLo mhlahlandlela uchaza indlela yokuhlanganisa idatha ibe amabanga (kufaka phakathi amabanga kumashidi amaningi), indlela yokuguqula lawo mabanga abe amatafula "ahlakaniphile", nokuthi yimaphi amathuluzi engeziwe atholakalayo lapho usebenza ngamathebula: izihloko, imigqa eboshwe, amakholomu abaliwe, imigqa iyonke, izinkomba ezihlelekile, ngisho nokuhlanganiswa ne-SharePoint. Konke kuchazwa ngesiSpanishi (eSpain) ngezibonelo ezicacile ukuze ukwazi ukuzijwayeza kumafayela akho.

Iyini iseli le-Excel futhi usebenza kanjani nalo?

Una Iseli ku-Excel liwukuhlangana komugqa nekholomuIseli ngalinye linekheli elihlukile elenziwe ngohlamvu lwekholomu kanye nenombolo yomugqa, njengo-A1, C7, noma u-F15. Lesi sithenjwa sisetshenziswa kumafomula, imisebenzi, kanye nokuchaza amabanga, ngakho-ke kubalulekile ukukuqonda kahle kusukela ekuqaleni.

Kuseli ngayinye ungangena izinhlobo ezahlukene zedatha: umbhalo, izinombolo, izinsuku, izikhathi, amanani afomethiwe ngohlobo lwemali, amaphesenti noma ngisho namafomula nemisebenzi ebala imiphumela evela kwamanye amaseli. Nakuba zingase zibonakale njengamabhokisi azimele, amandla aphelele e-Excel avela lapho uqala ukuhlobanisa amaseli nomunye nomunye ngokusebenzisa izinkomba.

Ikholi iseli esebenzayo Leli yiseli osebenza kulo njengamanje. Ngokuvamile lifakwe uhlaka olunomngcele ojiyile, futhi ikheli lalo liboniswa ebhokisini legama (ngakwesobunxele sebha yefomula). Konke okuthayiphayo kuzofakwa kuleli seli, ngaphandle kokuthi uhlela enye indawo (njengebhokisi legama noma ibha yefomula kolunye uhlelo lokusebenza).

Ukuze okuqukethwe kufundeke kalula, i-Excel ikuvumela ukuthi ulungise ifomethi yeseli Ungenza ngokwezifiso okudingayo: uhlobo lwenombolo, ukuqondanisa, ifonti, imingcele, umbala wokugcwalisa, noma isivikelo. Lezi zinketho azishintshi inani ngokwalo, kodwa kunalokho indlela eliboniswa futhi eliziphatha ngayo ngaphakathi kweshidi lokusebenzela.

Ukufometha kweseli: inombolo, ukuqondanisa, imingcele, ukugcwalisa, kanye nokuvikela

Ngokuchofoza kwesokudla kunoma yiliphi iseli bese ukhetha inketho Ifomethi yeseliIwindi livula ngamathebhu amaningana aqukethe cishe zonke izinketho zokwenza ngokwezifiso. Lokhu kulungiselelwa kuyisihluthulelo sokuqinisekisa ukuthi amaspredishithi acacile, achwepheshile, futhi kulula ukuwasebenzisa abanye.

Kuthebhu Inombolo Unganquma ukuthi okuqukethwe kuzophathwa kanjani: njengenombolo evamile, inombolo yedesimali, uhlobo lwemali, ukubalwa kwezimali, usuku, isikhathi, iphesenti, ingxenye, umbhalo, njll. Ukukhetha isigaba esifanele kuqinisekisa ukuthi i-Excel ihumusha idatha ngendlela efanele; isibonelo, ukuthi usuku luqashelwa kanjalo futhi luvumela ukuhlelwa kwezikhathi noma ukubala umehluko ezinsukwini.

Ithebhu Ukulungiswa Ikuvumela ukuthi ulawule indawo yokuqukethwe ngaphakathi kweseli: qondanisa kwesobunxele, phakathi, noma kwesokudla, songa umbhalo emigqeni eminingi, wehlise usayizi wefonti uze ulingane, noma ushintshe ngisho nokuma kombhalo. Iwusizo kakhulu ezihlokweni ezinde noma ezihlokweni zekholomu ebezizolahla lonke ithebula.

Kuthebhu Fuente Uhlobo lwefonti, usayizi, isitayela (esigqamile, esima-ithalikhi), ukudwebela, umbala, kanye nemiphumela eyengeziwe kuyakhethwa. Nakuba ngezinye izikhathi kunganakwa, ukukhetha okuhle kwefonti nosayizi kwenza amadokhumenti abe lula ukuwafunda, ikakhulukazi uma ephrintiwe noma abelwana ngawo namakhasimende noma ozakwabo.

Ithebhu Edongeni Isetshenziselwa ukusebenzisa imigqa ezungeze iseli noma ububanzi bonke: imingcele yangaphandle, yangaphakathi, ephindwe kabili, enezingqimba, njll. Kungumthombo obonakalayo olula kodwa onamandla wokuhlukanisa izigaba, ukumaka izingqikithi, noma ukuhlela imibiko ngaphandle kokusebenzisa amathebula ayinkimbinkimbi.

Nethebhu Kufakwe Ungasebenzisa imibala yangemuva kanye nemiphumela ye-gradient. Ukusebenzisa ukugcwalisa kancane kusiza ukugqamisa idatha ebalulekile noma ukuhlukanisa izindawo zokufaka idatha ezindaweni zokubala, ukuvimbela abanye abasebenzisi ekususeni amafomula ngephutha.

Ekugcineni, ithebhu Vikela Ikuvumela ukuthi umake amaseli njengakhiyiwe noma afihliwe. Lezi zinketho empeleni ziyavuselelwa uma uvikela ishidi, lapho unganquma khona ukuthi yini engahlelwa nengalungiselelwa. Lesi isendlalelo esiwusizo sokuphepha uma wabelana ngezincwadi zomsebenzi nabanye noma ushicilela amathempulethi.

Imisebenzi ewusizo ehlobene neseli: isibonelo nge-CELL

I-Excel ifaka imisebenzi ekuvumela ukuthi uthole ulwazi mayelana namaselingale kokuqukethwe kwayo. Omunye wabo umsebenzi we-CELL, obuyisa idatha mayelana nefomethi, indawo, noma uhlobo lolwazi olugciniwe.

Isibonelo, uma ufuna ukuhlola ukuthi iseli liqukethe inombolo ngaphambi kokwenza ukubala, ungasebenzisa ifomula efana nale (ukulungisa isihlukanisi ngokwezilungiselelo zesifunda): =UMA(ISELELI(«uhlobo»;A1)=»v»;A1*2;0)Kulesi simo, ifomula iphindaphinda inani lika-A1 ngo-2 kuphela uma liqukethe inani lezinombolo; uma iseli lingenalutho noma liqukethe umbhalo, libuyisela u-0.

Lolu hlobo lokuhlola lunikeza ungqimba olwengeziwe lokuqina kumaspredishithi akho, ugwema amaphutha lapho usebenza ngedatha evela kweminye imithombo noma engase ibe namanani angalindelekile.

Ngokuhlanganisa i-CELL neminye imisebenzi efana ne-ISNUMBER, i-ISBLANK, noma i-ISERROR ungakha ukuqinisekiswa okuthuthukisiwe ezivumelana nokuziphatha kwangempela kwabasebenzisi, ikakhulukazi kumathempulethi ezinkampani noma kumadeshibhodi azodluliselwa ngabantu abaningana.

Izindlela zokuhlela amaseli nokulungisa okuqukethwe

Kunezindlela eziningana hlela okuqukethwe kweseliFuthi kuyasiza ukuzazi ngoba ezinye zilula kakhulu uma usebenza ngamafomula ayinkimbinkimbi noma imibhalo emide. Indlela eqondile kakhulu ukuchofoza kabili kuseli bese uthayipha noma ushintshe okuqukethwe kwalo ngqo.

Enye inketho kulula qala ukubhala Uma iseli likhethiwe: noma yini oyithayiphayo izothatha indawo yokuqukethwe kwangaphambilini. Le ndlela ishesha ekubhaleni kabusha idatha, yize ingasebenzi kahle uma ufuna ukushintsha ingxenye yefomula noma umbhalo kuphela.

Ungahlela futhi kusukela ku- Ibha yefomulaItholakala ngaphezu kweshidi lokusebenzela, ibha yefomula iwusizo kakhulu lapho usebenza ngamafomula amade, njengoba inikeza isikhala esengeziwe kanye nombono okhululekile. Mane ukhethe iseli bese uchofoza kubha yefomula ukuze ushintshe okuqukethwe.

Isinqamuleli esivame ukusetshenziswa siyisihluthulelo F2Lokhu kukuvumela ukuthi ufake imodi yokuhlela kuseli esebenzayo ngaphandle kokusebenzisa igundane. Ukucindezela i-F2 kubeka ikhesa ngaphakathi kokuqukethwe okukhona, kulungele ukwenza izinguquko ezithile ngaphandle kokubhala kabusha konke.

Ukuze ulungise indlela okuqukethwe okuboniswa ngayo ngaphakathi kweseli ngayinye, unamathuluzi amaningana: umyalo Songa umbhalo kubangela ukuthi umbhalo usakazeke emigqeni eminingana ngaphakathi kweseli elifanayo; Hlanganisa amaseli Ikuvumela ukuthi uhlanganise amaseli amaningana abe linye (yize kufanele lisetshenziswe ngokucophelela ukuze kugwenywe ukuphazamisa ukuhlunga nokuhlunga); futhi ukufometha kweseli ngokwalo kunikeza inketho Nciphisa kuze kube yilapho kulungiselelwa, okunciphisa usayizi wefonti ukuze kufakwe umbhalo ebubanzini obutholakalayo.

Iyini ibanga ku-Excel futhi yiziphi izinhlobo zamabanga ezikhona?

Ku-Excel, a Ububanzi buyisethi yamaseli Kubhekwa njengeyunithi yokusebenzisa ukufometha, ukwenza izibalo, noma ukudala amashadi. Kungaba kusukela kuseli elilodwa kuya ezinkulungwaneni, kuye ngezidingo zencwadi yokusebenza, futhi kuyisisekelo semisebenzi eminingi eyenziwa kumaspredishithi.

Indlela ejwayelekile yokubhala ububanzi iwukuqala ngokubonisa iseli eliphezulu kwesokunxele, kulandelwe yikholoni, bese kuba yi- iseli eliphansi kwesokudlaIsibonelo, i-A1:C2 ihlanganisa amaseli A1, B1, C1, A2, B2, kanye ne-C2, lawo ngolimi lwemvelo esivame ukuwachaza ngokuthi "kusukela ku-A1 kuya ku-C2".

Kuyathakazelisa ukukhumbula ukuthi iseli elilodwa, ngokwalo, selivele limele ububanzi obuvumelekile Ku-Excel, uma usebenza ngamaseli, empeleni usebenza ngama-range, noma ngabe angu-1x1 kuphela ngobukhulu. Lokhu kuyabonakala uma usebenzisa ukufometha, imisebenzi, noma ukuqinisekiswa, okuhlala kulindele ububanzi njengempikiswano.

Ngokuphathelene nokuma, singakhuluma ngezintathu ezinkulu izinhlobo zebangaI-one-dimensional, two-dimensional, kanye ne-three-dimensional. Ngayinye inokusetshenziswa okukhethekile futhi iphathwa ngendlela ehlukile kancane, ikakhulukazi uma kuhileleke amaphepha amaningana.

Un ububanzi obunobukhulu obubodwa Ibhekisela kuseli elilodwa, kungaba eshidini lamanje noma kwelinye ishidi. Izibonelo ezijwayelekile zingaba yi-A1, B2, C3, noma i-Sheet2!D10. Nakuba zilula, ziyisisekelo samafomula, amagama achaziwe, kanye nezinkomba eziphakathi kwamakhasi.

Un ububanzi obunezinhlangothi ezimbili Lokhu kubhekisela eqenjini lamaseli ahambisanayo noma, ngenothi elithuthukisiwe kakhulu, ezinhlanganisweni zamabanga amaningana (isibonelo, i-A1:B3 noma i-F5:L50;N5:P50). Yifomethi yakudala yamathebula edatha, izindawo zokuphrinta, amashadi, noma imisebenzi esebenza ngama-array.

El ububanzi obunezinhlangothi ezintathu Inwebeka kumashidi amaningi. Isibonelo, i-Sheet1:Sheet3!F3 noma i-Sheet2:Sheet4!A1:B10 ikhombisa ukuthi ububanzi busuka eshidini lokuqala kuya eshidini lokugcina, kufaka phakathi wonke amashidi aphakathi nendawo. Lolu hlobo lobubanzi lusetshenziswa uma unezincwadi zomsebenzi ezinezakhiwo eziphindaphindwayo ngeshidi ngalinye (isibonelo, isifinyezo sanyanga zonke kuthebhu ngayinye) futhi ufuna hlanganisa amashidi amaningi ekubalweni okukodwa.

Ukukhetha, ukusebenzisa kanye nokuphatha amabanga

Ukuze usebenze ngokunethezeka, kubalulekile ukwazi khetha ububanzi ngokushesha. Indlela enembile kakhulu ukuchofoza iseli yokuqala, ubambe inkinobho yegundane lesobunxele, bese uhudula uye kuseli lokugcina. Uma ukhulula inkinobho, kukhethwa ibhulokhi lonke.

Enye indlela ewusizo kakhulu ukusebenzisa ikhibhodi: khetha iseli lokuqala, ubambe inkinobho Shift Bese, usebenzisa izinkinobho zemicibisholo, wandisa ukukhetha ukuze kufakwe wonke amaseli afunwayo. Le ndlela inembe kakhulu uma usebenza ngamanani amakhulu kumashidi okusebenzela amakhulu kakhulu.

Uma ufuna ukufika ngqo ephuzwini, ungabhala ngqo ireferensi yobubanzi ku- ibhokisi legama (phezulu kwesobunxele, eduze kwebha yefomula). Isibonelo, uma uthayipha i-A1:C3 bese ucindezela u-Enter, i-Excel izolikhetha ngokushesha lelo banga. Kuyindlela esheshayo yokugxumela ezindaweni ezithile zeshidi ngaphandle kokuskrola ngesandla.

Kungenzeka futhi ukukhetha amabanga okungaxhumeneUkuze wenze lokhu, qala ngokukhetha ibhulokhi yokuqala, bese ubamba inkinobho ye-Ctrl bese wengeza amanye amabanga ngegundane. Uma usuqedile, khipha i-Ctrl bese uzoba namaqembu amaningana amaseli akhethiwe ngesikhathi esisodwa, okuyinto enhle kakhulu ekusebenziseni ukufometha okukhethekile noma ukukopisha izindawo ezithile ezihlakazekile kuphela.

Empilweni yansuku zonke, izigaba zisetshenziselwa dala amafomula nemisebenzi (njenge-SUM, i-AVERAGE, noma i-VLOOKUP), kuya ku- sebenzisa amafomethi kumaqembu amaseli ngesikhathi esisodwa, dala amatafula kanye nokondla ihluzoamathebula e-pivot noma ukuqinisekiswa kwedathaEqinisweni, noma yikuphi ukusebenza okwenzayo kumaseli angaphezu kwelilodwa kuhilela ngqo ububanzi.

Kopisha, hambisa, futhi unamathisele amabanga amaseli

Uma usukhethile ububanzi, ungakwazi yikopishe noma uyihambise ngokuguquguquka okukhulu. Ukuze ukopishe, mane ukhethe ububanzi, sebenzisa i-Ctrl+C (noma inkinobho ethi Kopisha), bese unamathisela nge-Ctrl+V kuseli yendawo noma olunye ububanzi. I-Excel izokopisha kokubili idatha kanye nokufometha ngaphandle kokuthi ucacise ngenye indlela.

Uma okufunayo hambisa ububanzi Ngaphandle kokuyikopisha, ungasebenzisa umyalo othi Cut (Ctrl+X) bese unamathisela endaweni entsha. Enye indlela elula ukubeka ikhesa onqenqemeni lokukhetha bese uhudula ngegundane; uma ubamba futhi ukhiye we-Ctrl ngenkathi uhudula, kuzodala ikhophi esikhundleni sokunyakaza.

Uma unamathisela ububanzi, i-Excel inikeza eziningana izinketho ezikhethekile zokunamathisela: Namathisela konke (amanani nokufometha), amanani kuphela, ukufometha kuphela, amafomula kuphela, ukuguqula imigqa namakholomu, unamathisele njengesithombe, njll. Lezi zinketho zilawulwa kusuka kumenyu evelayo uma uchofoza umcibisholo kunkinobho ethi Namathisela noma ngemenyu yokuqukethwe.

Ukukhetha phakathi kokunamathisela amanani, amafomula, noma amafomethi kukuvumela ukuthi wakhe amathempulethi ahlanzekile, gcina izibalo ziqinile futhi ugweme amaphutha ajwayelekile lapho ushintsha amabanga, ikakhulukazi lapho usebenza ngezinkomba ezixubile ezihlobene kanye nezinkomba eziphelele.

Ngaphezu kwalokho, i-Excel isekela ukukhethwa kwe- amabanga ahlukahlukene ezindaweni ezahlukene zeqabunga elifanayo, ngisho nasemaqabungeni ahlukene, ukuze kopisha, susa, noma fometha ngasikhathi sinyeLokhu konga isikhathi esiningi ngokugcina ukuvumelana okubonakalayo nokubala kuyo yonke incwadi.

Amathebula e-Excel: ayini nokuthi kungani uwasebenzisa

Ku-Excel, a Ithebula liwuhlu lwamaseli ahlelwe ngendlela ekhethekile. Ihlanganisa idatha ehlobene futhi inezela inani elihle lamathuluzi engeziwe okuyiphatha. Nakuba empeleni kuseyibhulokhi yemigqa namakholomu, i-Excel iphatha amatafula njengezinto ezihlelekile ezinamagama azo.

Umugqa wokuqala wetafula ugcinelwe izihloko zekholomuLokhu kuchaza izinkambu zedatha (isb., Usuku, Umkhiqizo, Ubuningi, Inani). Imigqa esele iqukethe amarekhodi edatha noma imigqa. Lesi sakhiwo esicacile senza kube lula ukuhlunga, ukuhlunga, ukufingqa, nokuhlaziya ulwazi ngokushesha.

Inzuzo ebalulekile ukuthi, lapho usebenza ngamathebula, i-Excel iyanakekela phatha ngokuzenzakalelayo imininingwane eminingi: yandisa ububanzi uma ungeza imigqa emisha, wandisa ukufometha kudatha entsha, ubuyekeza amafomula ethebula, ugcine izihlungi zisebenza, futhi ulungisa amashadi ahlobene noma amathebula e-pivot.

Empeleni, amatafula enza impilo ibe lula kakhulu uma ushayela. uhlu olukhulu lolwazi (ukuthengisa, izinqolobane, amarekhodi amakhasimende, njll.) futhi ufuna ukugxila ekuhlaziyeni esikhundleni sokukhathazeka ngokuthi ngabe amabanga akho ayasilela noma amafomula akho ashiya idatha entsha.

Kuhle ukukhumbula ukuthi ibhodi, ngokwezobuchwepheshe, liyi- ububanzi bamaseli anezakhiwo ezengeziweUngaguqula ububanzi bube ithebula, usebenze nawo wonke amathuluzi alo, futhi uma ufuna ukugcina ukufometha kuphela, kungenzeka ukuguqula ithebula libuyele kububanzi obujwayelekile ngaphandle kokulahlekelwa izitayela ezisetshenzisiwe.

Izinto eziyinhloko zethebula le-Excel

Uma usuguqule ububanzi bube ithebula, kuvela eziningana izici zesici. Esokuqala yi- umugqa wekhandaokuhlanganisa izihlungi ezizenzakalelayo kukholamu ngayinye. Kusukela kulowo mugqa ungahlela idatha kusukela kwencane kakhulu kuya kwenkulu noma enkulu kakhulu kuya kwencane kakhulu, usebenzise izihlungi ngombhalo, inombolo, umbala, noma usebenzise izihlungi ezithuthukisiwe ngokushesha.

Esinye isici esijwayelekile yi- imigqa enezingqimbaUkushintshashintsha umbala kwenza idatha ifundeke kalula. Lokhu kushintshashintsha kwemibala ethambile emigqeni elinganayo nengajwayelekile kunciphisa amaphutha lapho ulandela umugqa ngokubonakalayo, ikakhulukazi ematafuleni abanzi anamakholomu amaningi.

I-Las amakholomu abaliwe Ziyisici esiyinhloko samathebula. Uma ufaka ifomula kuseli ngaphakathi kwekholomu yethebula, i-Excel inweba ngokuzenzakalelayo leyo fomula kuwo wonke amaseli asele kukholomu. Lokhu kuqinisekisa ukuthi azikho izikhala nokuthi yonke imigqa ibalwa kusetshenziswa indlela efanayo yokucabanga, ngaphandle kokuthi uhudule ngesandla isibambo sokugcwalisa.

La umugqa wesamba Lesi esinye isici esiwusizo kakhulu. Uma sisebenza, umugqa owengeziwe uvela ekugcineni kwethebula onezinhlu eziya phansi kukholomu ngayinye. Ukusuka lapho, ungakhetha imisebenzi efana ne-SUM, AVERAGE, COUNT, MAX, MIN, neminye. Ngaphakathi, i-Excel isebenzisa umsebenzi we-SUBTOTAL, ongazinaki izinhlu eziya phansi ngokuzenzakalelayo. imigqa efihliwe ngokusebenzisa izihlungi, ukuze ingqikithi ivumelane nalokho okubonayo esikrinini.

Ekhoneni elingezansi kwesokudla letafula kukhonjiswa isilawuli sosayizi okukuvumela ukuthi uhudule futhi ushintshe usayizi wethebula ngokushesha. Nakuba ukunwetshwa kwethebula kuvame ukuzenzekela uma uthayipha umugqa olandelayo, lesi silawuli sinikeza ukulawula okubonakalayo okucacile kakhulu phezu kwemingcele yento yethebula.

Indlela yokudala ithebula kusuka kububanzi

Ukuguqula uhla lwamaseli lube ithebula kuyinqubo iyashesha futhi iyahlehlaOkokuqala, khetha iseli noma ububanzi bedatha ofuna ukuyifaka; vele uzibeke ngaphakathi kwebhulokhi futhi i-Excel ivame ukubona yonke isethi uma kungekho migqa noma amakholomu angaphakathi angenalutho.

Ngemuva kwalokho kuthebhu Inicio kusuka kuribhoni, chofoza Fometha njengethebulaKuzovela izitayela eziningana ezichazwe ngaphambilini ezinezinhlanganisela zemibala, imingcele, kanye nama-band ongawasebenzisa ngokuchofoza okukodwa. Khetha isitayela esifanelana kahle nokubukeka okufunayo.

Ibhokisi lengxoxo lizovuleka lapho i-Excel iphakamisa khona uhla lwedatha ukuthi ikutholile. Yibukeze bese ulungisa uma kudingeka. Ngezansi, unebhokisi Itafula lami linezihlokoMaka leli bhokisi uma umugqa wokuqala usuvele uqukethe izihloko zekholomu. Uma ungenazo izihloko, i-Excel izokhiqiza amagama ajwayelekile (Ikholomu 1, Ikholomu 2, njll.) ongawashintsha njalo kamuva.

Uma ucindezela u-OK, ububanzi buba ithebula elisebenza ngokugcweleIsitayela, izihlungi emgqeni ophezulu, amabhendi omugqa, nazo zonke izakhiwo zethebula ziyasetshenziswa. Ukusuka lapho, ungaqamba kabusha ithebula kusuka kuthebhu yomongo evela ku-ribbon, okuwusizo kakhulu ekusebenzeni ngezinkomba ezihlelekile.

Uma uthanda, ungakha namathebula avela kwezinye izinketho zeribhoni noma ngisho nasedathani engeniswe evela kumafayela angaphandle. yolwazi noma izinsizakalo zamafu, ezilayishwa ngqo ngefomethi yethebula ukuze kube lula ukukhohlisa.

Ukusebenza kahle ngedatha yethebula: ukubhekisela kanye nokuqinisekisa

Enye yezinzuzo ezinkulu zamatafula ukusetshenziswa izinkomba ezihlelekileEsikhundleni sokubhekisela kumaseli afana ne-A1 noma i-B2, ungasebenzisa amagama ethebula namakholomu, into efana ne-SalesTable, futhi, uma usebenza ne- amazinga aqanjwe ngamagamaUzobona izinzuzo ezengeziwe. Lezi zinkomba zifundeka kalula, ziyamelana nezinguquko zesakhiwo, futhi zenza kube lula ngabanye abasebenzisi ukuqonda amafomula.

Ngaphezu kwalokho, amabhodi ahambisana kahle kakhulu ne- ukuqinisekiswa kwedathaUngakhawulela ukuthi yiziphi izinhlobo zamanani ezamukelwayo kumakholomu athile (isibonelo, izinombolo ezinhle kuphela, izinsuku ezingaphakathi kobubanzi kuphela, noma uhlu oluya phansi olunezinketho ezichazwe kusengaphambili). Lokhu kuqinisa ubuqotho bedatha futhi kunciphisa amaphutha abantu lapho kugcwalisa amaspredishithi abiwe.

Uma uhlanganisa amatafula namathuluzi afana izihlungi ezithuthukisiwe, ukuhlukaniswa kwedatha, noma amathebula e-pivotUthola isisekelo esiqinile kakhulu semibiko namadeshibhodi lapho umthombo wedatha uhlelwe kahle futhi kulula ukuwunakekela ngisho noma ivolumu ikhula.

Ukuphatha ukufometha ngaphakathi kwetafula nakho kuba lula: uma usebenzisa isitayela etafuleni, ukufometha kubuyekezwa konke ngesikhathi esisodwa. imigqa enamabhande, imibala yezihloko, namafontingendlela ehambisanayo. Lokhu kusiza ukugcina ukubukeka kobungcweti ngisho noma abantu abaningana bebambisana kufayela elifanayo.

Okokugcina, uma nganoma yisiphi isikhathi ufuna ukuyeka ukusebenzisa imisebenzi yetafula kodwa ugcine ukubukeka, ungaguqula ithebula libe ububanzi obujwayelekileI-Excel izogcina ukufometha okubonakalayo, kodwa izosusa izici ezikhethekile (izinkomba ezihlelekile, umugqa wesamba ozenzakalelayo, njll.), ibuyisele isethi kububanzi obujwayelekile.

Thumela amathebula e-Excel ku-SharePoint

Ezindaweni zezinkampani, kuvamile ukuthi amaspredishithi e-Excel asebenze njengesisekelo izinhlu ezabiwe Kumapulatifomu afana ne-SharePoint, uma unezimvume ezigunyaziwe kusayithi le-SharePoint, ungathumela ngqo ithebula le-Excel ohlwini, okuvumela abanye abasebenzisi ukuthi babuke, bahlele, futhi babuyekeze idatha kusuka kuwebhu.

Uma kuthunyelwa kwamanye amazwe, uhlobo oluthile uxhumano lwendlela eyodwa phakathi kwe-Excel nohlu lwe-SharePoint. Ungabuyekeza ithebula encwadini yakho yokusebenzela ukuze libonise izinguquko ezenziwe ohlwini, okuwusizo ekuhlanganiseni ulwazi lube yimibiko ngaphandle kokukopisha nokunamathisela idatha ngesandla.

Le ndlela ivame ukusetshenziswa uma ufuna Ukuthwebula Idatha Kwenziwa ngaphakathi (isibonelo, iminyango eminingana ifaka ulwazi ku-SharePoint) kuyilapho ukuhlaziywa, amagrafu kanye nemibiko kwenziwa ku-Excel, okusenamandla kakhulu ekubhekaneni nedatha yezinombolo.

Kumaphrojekthi amakhulu, ukuhlanganisa amathebula e-Excel nohlu lwe-SharePoint kanye nezinye izinsizakalo ezixhunyiwe kwenza kube lula ukusebenza nawo imithombo yedatha ebukhomaezibuyekezwa njengoba izinqubo zebhizinisi zishintsha, kugcinwa inguqulo eyodwa ethembekile yolwazi.

Ukwazi ukuphatha kahle Amaseli, ububanzi, namathebula ku-Excel Kukunika isisekelo esiqinile cishe sanoma yimuphi umsebenzi: kusukela kumaspredishithi alula okusetshenziswa komuntu siqu kuya kumamodeli ayinkimbinkimbi abiwa ngamaqembu. Ukuqonda ukuthi ububanzi buchazwa kanjani, ukuthi buguqulwa kanjani bube ithebula, yiziphi izinketho zokufometha kanye nokuqinisekisa ezitholakalayo, nokuthi lawa mathebula ahlangana kanjani namanye amapulatifomu kuzokuvumela ukuthi usebenze ngokushesha, wenze amaphutha ambalwa, futhi udale amafayela acacile kakhulu futhi achwepheshile.