Indlela Yokukhulisa Idatha ku-Excel

Indlela Yokukhuphula ku-Excel: Ukwenza Imisebenzi Yamandla Kahle

I-Excel iyithuluzi elinamandla elinikeza inhlobonhlobo yemisebenzi namakhono okuphatha nokuhlaziya idatha. Phakathi kwale misebenzi kukhona imisebenzi yamandla, evumela inombolo ukuthi iphakanyiswe emandleni athile. Ukwenza kahle le misebenzi kubalulekile ukuze wenze izibalo ezithuthuke kakhulu nokuhlaziya ku-Excel, noma ngabe kusesimweni sobuchwepheshe noma somuntu siqu. Kulesi sihloko, sizohlola ngokuningiliziwe ukuthi ungakhuphula kanjani ku-Excel nokuthi ungazisebenzisa kanjani ngokugcwele lezi zici zamandla ukuze uyise amakhono akho espredishithi ezingeni elilandelayo.

1. Ukuqonda imisebenzi yamandla ku-Excel

Ngaphambi kokuthi singene emhlabeni wamandla ku-Excel, kubalulekile ukuqonda ukuthi iyini ngempela le misebenzi yamandla nokuthi isetshenziswa kanjani. Ngamafuphi, umsebenzi wamandla usivumela ukuthi siphakamise inombolo emandleni athile. Isibonelo, uma sifuna ukuphakamisa inombolo yesi-2 emandleni angu-3, ​​sisebenzisa umsebenzi we-"MANDLA(2, 3)" ku-Excel, ozosinika u-8 njengomphumela "AMAMANDLA (isisekelo, i-exponent)".

2. Izibonelo ezisebenzayo zokukhulisa izinombolo ku-Excel

Manje njengoba sesinokuqonda okuyisisekelo kwemisebenzi yamandla ku-Excel, ake sibheke izibonelo ezithile ezisebenzayo ukuze sibonise ukuthi zisetshenziswa kanjani ezimweni zomhlaba wangempela. Cabanga ukuthi usebenza kuphrojekthi yobunjiniyela futhi udinga ukubala indawo yomjikelezo onikezwe irediyasi. Uma unerediyasi egcinwe kuseli, ungasebenzisa umsebenzi wamandla ukuze usikwele futhi uthole indawo. Isibonelo, uma irediyasi ingu-5, ungasebenzisa ifomula =PI() * AMANDLA(A2, 2) lapho i-A2 iyiseli lapho kugcinwa khona inani lerediyasi.

3. Amathiphu namaqhinga ukusebenzisa ngokugcwele izici zamandla

Ngaphezu kwezibonelo eziyisisekelo, kunamathiphu namasu amaningana angakusiza ukuthi usebenzise ngokugcwele izici zamandla ku-Excel. Isibonelo, uma udinga ukuphakamisa izinombolo eziningi emandleni afanayo, ungasebenzisa izinkomba zamaseli esikhundleni sokuthayipha inombolo ngayinye ngayodwa. Ngale ndlela, uma udinga ukufaka isikwele izinombolo ezi-5 ezahlukene, ungasebenzisa ifomula = AMANDLA(A2:A6, 2) esikhundleni sokubhala = AMANDLA(A2, 2), = AMANDLA(A3, 2), njll. Le nqubo izokusiza ukuthi wonge isikhathi futhi ugweme amaphutha angenzeka.

Kafushane, ukwenza kahle imisebenzi yamandla ku-Excel kubalulekile ekwenzeni izibalo eziyinkimbinkimbi nokuhlaziya. Ukuqonda i-syntax eyisisekelo nezibonelo ezingokoqobo, kanye nokusebenzisa amathiphu namasu awusizo, kuzokuvumela ukuthi uthathe amakhono akho espredishithi uwabeke ezingeni elilandelayo. Ngalolu lwazi, uzokwazi ukwenza izibalo ezinembe kakhudlwana nezisebenza kahle, futhi usebenzise amandla aphelele e-Excel emisebenzini yakho yansuku zonke.

1. Isingeniso semisebenzi ye-Excel

Imisebenzi ye-Excel ingamathuluzi anamandla akuvumela ukuthi wenze izibalo nokuhlaziya idatha ngempumelelo. Ngale misebenzi, kungenzeka ukwenza imisebenzi yezibalo, izibalo kanye nenengqondo kusipredishithi, okwenza umsebenzi ube lula futhi wonge isikhathi kubasebenzisi. <>
Eminye yemisebenzi esetshenziswa kakhulu ku-Excel ihlanganisa:
- Imisebenzi yezibalo: njenge-SUM, I-AVERAGE, MAXIMUM kanye ne-MINIMUM, evumela ukubalwa okuyisisekelo ukuthi kwenziwe kusipredishithi.
- Imisebenzi yezibalo: efana ne-DEVEST, i-VAR ne-CONFIIDENCE, esiza ukuhlaziya nokufingqa idatha ngokusekelwe ekusabalaliseni kwayo.
- Imisebenzi enengqondo: njengokuthi IF, KANYE kanye noma NOMA, evumela ukuhlola okunengqondo nokuhlola ukuthi kwenziwe kusipredishithi.

Ngokungeziwe kule misebenzi eyisisekelo, i-Excel iphinde inikeze imisebenzi eminingi ekhethekile yemisebenzi ecaciswe kakhudlwana, njengokuthola impande eyisikwele yenombolo, ukubala inzalo ehlanganisiwe, noma ukuthola ukuthi idethi iba ngosuku lwebhizinisi. Lezi zici ezikhethekile zingaba usizo kakhulu ezimbonini nasemisebenzini eyahlukene. <>
Ukuze usebenzise umsebenzi ku-Excel, uvele uthayiphe igama lawo kuseli bese unikeza izimpikiswano ezidingekayo kubakaki. Isibonelo, uma ufuna ukwengeza uchungechunge lwezinombolo, ungathayipha "=SUM(A1:A10)" kuseli. Uma usucindezela u-Enter, i-Excel izobala isamba sezinombolo kulolo bubanzi bese iveza umphumela kuseli.

Njengoba ujwayelana kakhulu nezici ze-Excel, uzothola amathuba angapheli okuthola okuningi kuleli thuluzi elinamandla. Noma ngabe udinga ukwenza ukuhlaziya kwezezimali, udale imibiko yangokwezifiso, noma wenze ngokuzenzakalelayo imisebenzi ephindaphindwayo, i-Excel ikunikeza izici ozidingayo ukuze ukwenze ngendlela efanele. indlela ephumelelayo. Hlola izici ze-Excel futhi uthole konke ongakufeza kumaspredishithi akho!

2. Asetshenziswa kanjani amafomula nezinkomba ku-Excel ngendlela efanele

Ukuze usikwele inombolo ku-Excel, ungasebenzisa ifomula elula kakhulu: =inombolo^inombolo. Isibonelo, uma sifuna ukufaka isikwele inombolo yesi-5, simane sibhale =5^2. Kubalulekile ukukhumbula ukuthi uphawu lokuphakama iphimbo le-circumflex (^). Ngale ndlela, singakwazi ukwenza izibalo ngokushesha futhi ngokunembile ngaphandle kwesidingo sokusebenzisa imisebenzi eyenziwa ngesandla.

Ngokungeziwe ku-squaring, kuyenzeka futhi ukusebenzisa amanye amafomula nezinkomba ku-Excel kahle. Omunye wabo UKWENGEZA, okusivumela ukuthi sengeze ukukhethwa kwezinombolo ngokuzenzakalelayo. Isibonelo, uma sinohlu lwezinombolo futhi sifuna ukuthola isamba sazo, simane sikhethe izinombolo esifuna ukuzengeza futhi sizibhale. =SUM(ububanzi). I-Excel izobala ngokuzenzakalelayo isamba sezinombolo ezikhethiwe.

Enye ifomula ewusizo ithi ISILINGANISO, okusivumela ukuthi sithole isilinganiso sezinombolo ezikhethiwe. Ukusebenzisa le fomula, sikhetha izinombolo esifuna ukuzilinganisela futhi sizibhale =ISILINGANISO (ububanzi). I-Excel izobala isilinganiso sezinombolo ezikhethiwe futhi isibonise umphumela ngokuzenzakalelayo. Ngale fomula, singonga isikhathi nomzamo lapho senza izibalo zezibalo ku-Excel.

Kafushane, i-Excel isinika amathuluzi amaningi okusebenzisa amafomula nezinkomba kahle. Kusukela ku-squaring kuya ekungezeni nasekulinganiseni izinombolo, singasebenzisa le misebenzi ukuze senze izibalo zethu zibe lula futhi sithole imiphumela enembile. Ngolwazi oluyisisekelo lwalawa mafomula nezinkomba, singakwazi ukuthuthukisa ukuzizwisa kwethu kwe-Excel futhi sithuthukise ukukhiqiza emisebenzini yethu yansuku zonke.

3. Amasu okuhlela nokufometha idatha ku-Excel

Ku-Excel, ukuhlelwa kwedatha nokufometha kuyizici ezibalulekile zokuthola okuningi kuleli thuluzi elinamandla. Nawa amanye amasu azokusiza ukuthi uthuthukise amakhono akho e-Excel futhi uthuthukise ukuphathwa kwedatha yakho:

1. Sebenzisa amathebula e-pivot: Amathebula e-Pivot ayindlela enhle yokuhlela nokufingqa amanani amakhulu edatha ngefomethi ecacile neqondakala kalula. Ungakha amathebula aguqukayo ukuhlaziya idatha imibiko yokuthengisa, imibiko yezezimali, izinhlu zokusungula nokunye okuningi. Sebenzisa isici sethebula le-pivot le-Excel ukuze uqoqe futhi ufingqe idatha, uhlunge ulwazi olufanele, futhi ukhiqize imibiko yobungcweti.

2. Sebenzisa ukufometha okunemibandela: Ukufometha okunemibandela iyithuluzi elinamandla elikuvumela ukuthi ugqamise ngokuzenzakalela idatha ehlangabezana nemibandela ethile. Ungasebenzisa ukufometha okunemibandela ukuze ubone amanani ayimpinda, ugqamise amaseli aqukethe amanani aphakeme kakhulu noma aphansi, noma ukuhlaba umkhosi idatha ehlangabezana nemibandela ethile. Lesi sici sizokusiza ukuthi ubone ngokushesha amaphethini namathrendi kudatha yakho futhi wenze izinqumo ezisekelwe olwazini olubukeka kahle.

3. Hlunga bese uhlunga idatha yakho: Ikhono lokuhlunga nokuhlunga idatha ku-excel Kubalulekile ekuhleleni nasekuhlaziyeni amaqoqo amakhulu olwazi. Ungakwazi ukuhlunga idatha yakho ngendlela ekhuphukayo noma eyehlayo, ngokusekelwe kumanani kukholamu eyodwa noma kumakholomu amaningi. Ukwengeza, ungakwazi ukuhlunga idatha yakho ukuze ubonise kuphela amanani ahlangabezana nemibandela ethile. Lezi zici zizokuvumela ukuthi uthole ngokushesha ulwazi oludingayo futhi uluhlaziye ngokuphumelelayo.

Ukusebenzisa lawa maqhinga kuzokuvumela ukuthi uthuthukise ukuphathwa kwedatha yakho ku-Excel futhi uthuthukise amakhono akho ekusebenziseni leli thuluzi. Khumbula ukuthi ukuzijwayeza njalo nokuhlola yonke imisebenzi ye-Excel kuzokusiza ube umpetha wokuhlaziya idatha nokukhohlisa. Qala ukusebenzisa la masu namuhla futhi usebenzise ngokugcwele amakhono e-Excel!

4. Amathiphu okwenza lula imisebenzi ephindaphindwayo ku-Excel usebenzisa amamakhro

Esicini sokugcina okufanele sicatshangelwe lapho sikhulisa amakhono ethu ku-Excel, kukhona Amathiphu okwenza lula imisebenzi ephindaphindwayo usebenzisa amakhrosi. Amamakhro awuchungechunge lwemiyalo nezenzo ezirekhodwe ngokulandelana okuthile okungadlalwa ngokuzenzakalela. Lokhu kusivumela ukuthi sizenzele izinqubo zenjwayelo futhi songe isikhathi esibalulekile. Nawa amanye amathiphu abalulekile wokusebenzisa amandla amamakhro ku-Excel.

Ithiphu yokuqala ithi Thola futhi uhlaziye imisebenzi ephindaphindwayo esikwenza kaningi ku-Excel. Kungaba yinoma yini kusukela ekufometheni amaseli athile kuye ekukhiqizeni imibiko eyinkimbinkimbi. Uma le misebenzi isihlonziwe, kufanele cabanga ngokulandelana kwemiyalelo edingekayo ukuze uyifeze. Kubalulekile ukunaka yonke imininingwane, njengezinqamuleli zekhibhodi ezisetshenzisiwe noma ukuchofoza kwegundane okudingekayo. Lokhu kuqonda kubalulekile ekwakheni i-macro ephumelelayo.

Isinyathelo esilandelayo yilesi rekhoda imakhro ku-Excel. Ukuze wenze lokhu, siya kuthebhu ethi "Unjiniyela" kumenyu ephezulu bese ukhetha "Rekhoda i-macro". Okulandelayo, sikhetha igama le-macro futhi sinikeze isinqamuleli sekhibhodi, uma sifisa. Ngenkathi senza izenzo ezidingekayo ukuze siqedele umsebenzi ophindaphindayo, i-macro izobe iqopha isinyathelo sethu ngasinye. Uma umsebenzi usuqediwe, simane siyeke ukuqopha i-macro. Manje singakwazi sebenzisa i-macro ngokumane ucindezele isinqamuleli sekhibhodi noma usebenzise inketho ehambisanayo kuthebhu ethi "Unjiniyela".

5. Khulisa ukukhiqiza ku-Excel ngezinqamuleli zekhibhodi eziwusizo

Ukusebenzisa izinqamuleli zekhibhodi ku-Excel yi-a indlela ephumelelayo de khulisa umkhiqizo futhi uthuthukise ukuhamba komsebenzi. Ukwazi kanye nokwenza kahle ezinye izinqamuleli eziwusizo kakhulu kungenza umehluko ngesivinini nokunemba kwemisebenzi yakho yansuku zonke. Nalu uhlu lwezinqamuleli zekhibhodi ezizokusiza uphakamise amakhono akho e-Excel.

1. I-Quick Scroll: Sebenzisa okhiye bemicibisholo ukuze uzulazule ngokushesha phakathi kwamaseli, imigqa noma amakholomu ngaphandle kokuthi usebenzise igundane.

2. Ukukhetha okusheshayo: Inhlanganisela yokhiye u-Shift + Umcibisholo ikuvumela ukuthi ukhethe ngokushesha ububanzi noma ibhulokhi yamaseli. Uma ucindezela ukhiye ka-Ctrl kanye no-Shift, ungakhetha amaseli angahlangani.

3. Kopisha bese unamathisela: Sebenzisa okhiye u-Ctrl + C ukuze ukopishe no-Ctrl + V ukuze unamathisele. Le nhlanganisela yokhiye iwusizo kakhulu lapho usebenza nenani elikhulu ledatha edinga ukuphindwa kabili noma idluliselwe ezindaweni ezihlukene.

Ngalawa mathuluzi onawo, uzobona ukuthi ukusebenza kahle kwakho nempumelelo yakho ku-Excel ukwanda kakhulu. Ungawabukeli phansi amandla ezinqamuleli zekhibhodi, njengoba zingakongela isikhathi futhi zinciphise amaphutha lapho ufaka noma ukhohlisa idatha. Zijwayeze futhi uzame ngalezi zinqamuleli futhi ube umpetha we-Excel! Khumbula ukuthi ukuzijwayeza njalo kuyisihluthulelo sokwazi noma yiliphi ikhono.

6. Ukwenziwa kanjani ukuhlaziya idatha ngempumelelo usebenzisa amathebula e-pivot ku-Excel

Amathebula e-Pivot ku-Excel iyithuluzi elinamandla lokuhlaziya inani elikhulu ledatha ngokushesha nangempumelelo. Ngokukwazi kwabo ukufingqa nokuhlela idatha ngamasekhondi, amathebula e-pivot abe yinketho edumile yokwenza ukuhlaziya idatha okusebenzayo.. Ukuze usebenzise amathebula e-pivot ku-Excel, kufanele uqale uqinisekise ukuthi unedatha ehlelwe kuthebula noma uhla lwamaseli. Bese, khetha idatha bese uye kuthebhu "Faka". ibha yamathuluzi. Chofoza “Ithebula Le-Pivot” bese ukhetha lapho ofuna kuvele khona ithebula le-pivot.

Uma usudale ithebula le-pivot ku-Excel, ungaqala ukwenza ukuhlaziya idatha okusebenzayo. Isici esibalulekile samathebula e-pivot yikhono lokuhlanganisa ngokushesha futhi kalula nokuhlunga idatha.. Ungakwazi ukwengeza izinkambu kuthebula le-pivot ukuze uhlaziye izici ezihlukene zedatha, njengezibalo, izilinganiso, ubuncane, nobukhulu. Futhi, ungakwazi ukuhlunga kalula idatha ukuze ubonise ulwazi oluthandayo kuphela. Isibonelo, uma uhlaziya idatha yokuthengisa, ungahlunga ngokwesifunda noma ngesikhathi esithile.

Esinye isici esiwusizo samathebula e-pivot yikhono loku dala amashadi ashukumisayo asekelwe kudatha yethebula. Lokhu kukuvumela ukuthi ubone ngokushesha nangokucacile amathrendi namaphethini kudatha. Ungakha izinhlobo ezahlukahlukene zamashadi, njengamashadi ekholomu, amashadi emigqa, noma amashadi amabha, futhi uwenze ngendlela oyifisayo ngokwezidingo zakho. Inhlanganisela yamathebula e-pivot namashadi e-pivot ku-Excel ikuvumela ukuthi wenze ukuhlaziywa kwedatha okuphelele futhi okuphumelelayo, okungaba usizo olukhulu ekwenzeni izinqumo zebhizinisi noma ukwethula imibiko.

7. Ukwenza ngendlela oyifisayo Amashadi kanye Nokubukwa Kwedatha ku-Excel

:

Uma kukhulunywa ngokuthi thuthukisa amakhono akho e-Excel, kubalulekile ukwazi amathuluzi okwenza ngokwezifiso igrafu namathuluzi okubona idatha anikezwa yile software. Lezi zici zingashintsha idatha yakho eyisicefe ibe izethulo ezibukwayo ezikhangayo nezifundisayo.

A ngempumelelo Ukwenza ngendlela oyifisayo amashadi akho ku-Excel usebenzisa ithebhu ethi "Design" kubha yamathuluzi. Lapha, uzothola izinketho zokushintsha uhlobo lweshadi, ulungise izimbazo, uguqule imibala, futhi wengeze izici ezengeziwe ezifana nezihloko namalebula. Ku hlela lezi zici ngendlela oyifisayo, uzokwazi ukugqamisa ulwazi olufanele kakhulu futhi wenze igrafu yakho ibe lula ukuyitolika. Ukwengeza, ungasebenzisa izinto ezifana namathebula e-pivot noma amafomula e-Excel ukuze ukhiqize ngokuzenzakalelayo amashadi abuyekeziwe ngokusekelwe kudatha entsha efakiwe.

Enye indlela yokwenza thuthukisa amakhono akho e-Excel ngokubona idatha ngeso lengqondo ngamathebula asebenzayo namagrafu. Esikhundleni sokumane ubonise izinombolo kusipredishithi, ungaziguqulela emashadi amabha, amashadi omugqa, amashadi ophaya, nanoma yiluphi olunye uhlobo lweshadi olufanele izidingo zakho. Lokhu kuzokwenza kube lula ukuhlonza amathrendi, ukuqhathanisa, namaphethini kudatha yakho. Ukwengeza, ungasebenzisa izici ezifana nethuluzi elithi "Sparkline" ukuze udale amagrafu amancane ngaphakathi kweseli, okukuvumela ukuthi ubone ngeso lengqondo idatha ebalulekile ngokuhlangene nangempumelelo.

Khumbula ukuthi Ngeke nje ikusize ukuthi unikeze ulwazi ngendlela ekhangayo, kodwa futhi igqamisa amaphethini abalulekile namathrendi kudatha yakho. Sebenzisa izinhlobonhlobo zezinketho zokwenza ngokwezifiso ezinikezwa yi-Excel ukuze udale izethulo ezibonakalayo ezithuthukisa idatha yakho futhi zivumele ukuqonda okungcono kolwazi. Hlola amathuluzi nezinketho ezitholakalayo, bese uthatha amakhono akho e-Excel uwabeke ezingeni elisha!

8. Ukwenziwa ngcono kwamafomula ayinkimbinkimbi nezibalo ku-Excel

Ku-Excel, kuvamile ukuhlangana namafomula ayinkimbinkimbi nezibalo ezidinga ukuthuthukiswa ukuze uthole imiphumela esheshayo nenembile. Ngenhlanhla, kukhona amasu ahlukahlukene esingawasebenzisa ukuze sithuthukise ukusebenza kwamaspredishithi ethu. Enye yazo inketho yokwengeza inombolo ku-Excel. Ukuze sifinyelele lokhu, singasebenzisa umsebenzi WAMANDLA noma sisebenzise u-opharetha wokuphindaphinda. Isibonelo, uma sifuna ukufaka isikwele inombolo u-5, singasebenzisa ifomula = AMANDLA(5,2) noma simane sithayiphe u-5*5 kuseli.

Ukwengeza ku-squaring, kungenzeka ukwenza ezinye izibalo eziyinkimbinkimbi ku-Excel ngokuphumelelayo. Indlela ewusizo ukusetshenziswa kwamathebula okubhekisela kuwo. Lawa mathebula asivumela ukuthi sihlele idatha namafomula ngendlela ehlelekile, ayenze kube lula ukuyifunda nokuyiqonda. Ukwengeza, ngokusebenzisa amathebula ereferensi, singasebenzisa amafomula azenzakalelayo e-Excel. Isibonelo, uma sidinga ukwenza uchungechunge lwezibalo zamavelu okufakwayo ahlukene, singafaka amanani kukholamu eyodwa yethebula futhi sisebenzise ifomula eyodwa kwenye ikholomu ukuze senze izibalo ngokuzenzakalelayo ivelu ngayinye.

Ekugcineni, Ukusebenzisa imisebenzi enemibandela ingasisiza ukuthi silungiselele amafomula ayinkimbinkimbi nezibalo ku-Excel. Le misebenzi isivumela ukuthi simise izimo ezinengqondo futhi senze izenzo ezihlukene kuye ngomphumela wokuhlola. Isibonelo, singasebenzisa umsebenzi we-IF ukwenza isibalo esisuselwe ekutheni umbandela othile uyafinyelelwa yini noma cha. Lokhu kusivumela ukuba sehlise inani lamafomula nezibalo ezingadingekile, sithuthukise ukusebenza kwamaspredishithi ethu. Ukwengeza, ngokusebenzisa imisebenzi enemibandela, singakwazi ukwenza izinqumo ngokuzenzakalelayo kumafomula ethu, siwenze avumelane nezimo futhi avumelane nezimo ezihlukahlukene.

9. Amathiphu okuxazulula amaphutha avamile ku-Excel

Emhlabeni wezibalo namaspredishithi, i-Excel iyithuluzi elibalulekile. Nokho, njenganoma yiluphi olunye uhlelo, ingase futhi yethule amaphutha angenza kube nzima ukusebenza kahle. Nawa amanye amathiphu okuxazulula amaphutha avame kakhulu ku-Excel.

1. Iphutha lefomula: Elinye lamaphutha ajwayelekile ku-Excel ukwenza iphutha lapho ubhala ifomula. Ukuze ugweme le nkinga, kubalulekile ukubuyekeza ngokucophelela i-syntax yefomula ngaphambi kokuyiqalisa. Ungasebenzisa inketho yokugqamisa ifomula ukuze uhlole ukuvumelana kwefomula futhi uqinisekise ukuthi bonke opharetha nezithenjwa zipelwe ngendlela efanele.

2. Ukungahambisani kwefomethi: Ngokuvamile, amaphutha ku-Excel ayenzeka ngenxa yamafomethi angahambelani phakathi kwamaseli. Isibonelo, uma uzama ukwenza umsebenzi wezibalo phakathi kweseli yombhalo neseli yenombolo, cishe uzobona iphutha. Ukuze ugweme lokhu, kubalulekile ukuqinisekisa ukuthi amaseli ahilelekile afomethwe ngendlela efanele ngaphambi kokwenza noma yimiphi imisebenzi.

3. Izithenjwa ezingalungile: Elinye iphutha elivamile ku-Excel ukusebenzisa izinkomba ezingalungile. Lokhu kwenzeka uma ubhekisela kuseli noma ububanzi bamaseli angekho noma angapeliwe kahle. Ukuze ulungise le nkinga, kubalulekile ukubuyekeza amafomula futhi uqiniseke ukuthi zonke izithenjwa zibhalwe ngendlela efanele futhi zikhomba amaseli afunwayo. Ukwengeza, ungasebenzisa umsebenzi othi "Sesha" ukuze uthole ngokushesha futhi ulungise noma yiziphi izithenjwa ezingalungile.

Khumbula, I-Excel iyithuluzi elinamandla elingakusiza kakhulu ukubala idatha yakho nemisebenzi yokuhlaziya. Nokho, kubalulekile ukuqaphela amaphutha avamile futhi wazi indlela yokuwalungisa. Ngalezi zeluleko, uzokwazi ukuphakamisa amakhono akho e-Excel futhi uthole okuningi kuwo imisebenzi yayo.

10. Intuthuko ekubikeni nasekukhiqizeni imibiko ku-Excel

.

Ku-Excel, ukubika nokukhiqiza imibiko kuyimisebenzi ebalulekile kunoma ubani osebenza ngedatha futhi odinga ukuhlaziya nokubona ulwazi ngeso lengqondo. ngempumelelo. Ngenhlanhla, iMicrosoft yethule intuthuko yakamuva ku-Excel ethuthukisa kakhulu lezi zici.

Okukodwa kwe ukuthuthukiswa okuphawuleka kakhulu ku-Excel yikhono loku dala amathebula e-pivot kalula. Manje, ngokuchofoza okumbalwa nje, ungakwazi ukuguqula ngokushesha ububanzi bedatha ube ithebula le-pivot elinamandla elikuvumela ukuthi uhlunge kalula, ufinyeze, futhi uhlaziye idatha. Ukwengeza, izinketho ezintsha zengeziwe ukuze wenze ngendlela oyifisayo ukwakheka nokufometha kwamathebula e-pivot, okukuvumela ukuthi udale imibiko ekhangayo neyochwepheshe.

Okunye isici esiyinhloko ekubikeni nasekukhiqizeni imibiko ku-Excel yikhono loku dala ihluzo ngesikhathi sangempela. Manje ungabuka idatha yakho ibe amashadi asebenzisanayo abuyekezwa ngokuzenzakalelayo njengoba idatha eyisisekelo ishintsha. Lokhu kubaluleke kakhulu ekuqapheni nasekuthuleni idatha yesikhathi sangempela, efana nokusebenza kokuthengisa noma ukulandelela iphrojekthi. Ukwengeza, izinketho ezintsha zengeziwe ukwenza amashadi ngendlela oyifisayo, njengemibala, izitayela, namalebula, okukuvumela ukuthi udale ukubonwa okunomthelela nakakhulu.

Ngokungeziwe ekuthuthukisweni kwamathebula e-pivot namashadi, i-Excel yengeze okusha imisebenzi yobuhlakani bokwenziwa ukukhiqiza umbiko. Manje, ungasebenzisa isici esithi "Imibono" ukuze uthole iziphakamiso ezizenzakalelayo zokuthi wethula kanjani futhi ubone ngeso lengqondo idatha yakho ngempumelelo. Le mininingwane ikhiqizwa injini ye-Excel ye-AI ngokusekelwe kumaphethini namathrendi kudatha yakho. Lokhu kukusiza ukuthi wonge isikhathi lapho ukhiqiza imibiko futhi kuqinisekisa ukuthi isethulo sakho sinomthelela futhi sicacela izethameli zakho.

Ngamafuphi, i Ziyamangalisa ngempela. Ngekhono lokudala kalula amathebula e-pivot, amashadi esikhathi sangempela, kanye nezici zobuhlakani bokwenziwa, i-Excel isibe yithuluzi elinamandla nakakhulu lokuhlaziya nokwethula idatha. Lokhu kuthuthukiswa akugcini nje konga isikhathi, kodwa futhi kukuvumela ukuthi udale imibiko ekhangayo neyochwepheshe. Uma ufuna ukuphakamisa amakhono akho e-Excel, ungangabazi ukusebenzisa lezi zici ezintsha futhi uthathe imibiko yakho uye kwelinye izinga.