Kusetshenziswa amatafula ahlakaniphile kuMicrosoft Excel

Cishe wonke umsebenzisi we-Excel uhlangabezane nesimo lapho uma ungeza umugqa omusha noma ikholomu kuhlaka lwethebula, kuzofanela uphinde ubuyise amafomula bese ufomatha le nto esitayeleni esivamile. Izinkinga ezikhonjisiwe zingeke zibe khona uma, esikhundleni senketho evamile, kusetshenziswa ithebula okuthiwa yi-smart. Lokhu "kuzodonsela" ngokuzenzakalelayo kuzo zonke izinto umsebenzisi anazo emingceleni yakhe. Ngemuva kwalokho, i-Excel iqala ukubabona njengengxenye yobubanzi bethebula. Lolu akulona uhlu oluphelele lokuthi itafula eliwusizo lisebenzelani. Ake sibheke ukuthi ingayakha kanjani nokuthi yimaphi amathuba eliwanikezayo.

Isicelo sethebula le-Smart

Itafula "ehlakaniphile" liyindlela ekhethekile yokufometha, ngemuva kokuyisebenzisa ebangeni elithile ledatha, uhlu lwamaseli luthola izakhiwo ezithile. Okokuqala, ngemuva kwalokhu, uhlelo luqala ukungalubheki njengobubanzi beseli, kodwa njengento ebalulekile. Lesi sici sivele kulolu hlelo luqala ngohlobo lwe-Excel 2007. Uma uqopha kunoma yisiphi iseli emgqeni noma ikholomu etholakala ngqo emingceleni, khona-ke lo mzila noma ikholomu lifakwa ngokuzenzakalelayo kuloluhlu lwethebula.

Ukusetshenziswa kwalobu buchwepheshe kuvumela ukungaphindi benze amafomula ngemuva kokungeza imigqa uma idatha evela kuyo idonswa kolunye uhla ngumsebenzi othile, ngokwesibonelo I-VPR. Ngaphezu kwalokho, phakathi kwezinzuzo, kufanelekile ukugqamisa cap ngaphezulu kweshidi, kanye nokuba khona kwezinkinobho zokuhlunga kwezihloko.

Kodwa, ngeshwa, lobu buchwepheshe bunokulinganiselwa okuthile. Isibonelo, kuyathandeka ukusebenzisa inyunyana yamaseli. Lokhu kuyiqiniso ikakhulukazi ngezigqoko. Okwakhe, ukuhlanganisa izinto ngokuvamile akwamukeleki. Ngaphezu kwalokho, noma ungafuni ukuthi inani elithile elitholakala emingceleni yohlu lwethebula lifakwe kulo (ngokwesibonelo, inothi), lisazobhekwa yi-Excel njengengxenye yalo. Ngakho-ke, wonke amalebula angeziwe kufanele abekwe okungenani kuluhlu olulodwa olungenalutho kusuka ekuhlelweni kwetafula. Futhi, amafomula afanayo ngeke asebenze kuwo futhi incwadi ngeke ikwazi ukuyisebenzisela ukwaba. Onke amagama ekholamu kumele ahluke, okungukuthi, angaphindwa.

Ukwakha itafula elihlakaniphile

Kepha ngaphambi kokuthi uqhubeke nokuchaza amakhono wethebula elihlakaniphile, ake sibheke ukuthi lingakhiwa kanjani.

1. Khetha ibanga lamaseli noma yisiphi isici sezinhlaka esifuna ukufaka ukufometha kwetafula kuzo. Iqiniso ngukuthi noma ukhetha into eyodwa yamalungu afanayo, uhlelo luzothatha zonke izinto eziseduze ngesikhathi senqubo yokufometha. Ngakho-ke, akukho mehluko omkhulu kokuthi ukhetha lonke uhla lokuqondiwe noma ingxenye yalo kuphela.

   Ngemuva kwalokho, iya kuthebhu "Ikhaya"uma njengamanje ukwithebhu ehlukile ye-Excel. Ngokuchofoza inkinobho "Fometha njengetafula", ebekwe etheyiphu kwibhulokhi yamathuluzi Izitayela. Ngemuva kwalokho, uhlu luvula ngokukhetha kwezitayela ezahlukahlukene zokuklanywa kwamatafula wethebula. Kepha isitayela esikhethiwe ngeke sithinte ukusebenza nganoma iyiphi indlela, ngakho-ke sichofoza kukho okukhethwa kukho okuthanda ukubonakala okuningi.

   

   Kukhona enye inketho yokufomatha. Ngendlela efanayo, khetha konke noma ingxenye yebanga esizoliguqula kuhlaka lwethebula. Okulandelayo, iya kuthebhu Faka nakulubambo kubhokisi lamathuluzi "Amathebula" chofoza isithonjana esikhulu "Ithebula". Kulesi simo kuphela, ukukhetha isitayela akunikezwanga, futhi kuzofakwa ngokuzenzakalelayo.

   

   Kepha inketho esheshayo ukusebenzisa ama-hotkeys ngemuva kokukhetha iseli noma uhlu I-Ctrl + T.

2. Ngokunye okukhethwa kukho okungenhla, kuvulwa iwindi elincane. Inekheli lobubanzi obuzoguqulwa. Esikhathini esiningi samacala, uhlelo luquma ibanga kahle, kungakhathalekile ukuthi ulikhethile lonke noma iseli elilodwa kuphela. Kepha noma kunjalo, uma kwenzeka, udinga ukubheka ikheli le-array ensimini futhi, uma lingahambelani izixhumanisi ozidingayo, bese ulishintsha.

   Futhi, qiniseka ukuthi kukhona uphawu lokuhlola eduze kwepharamitha Ithebula Lokuqondisa, ngoba ezimweni eziningi izihloko zedatha yoqobo sezivele zikhona. Ngemuva kokuthi uqinisekise ukuthi wonke amapharamitha afakwe kahle, chofoza inkinobho "Kulungile".



3. Ngemuva kwalesi senzo, uhla lwedatha luzoguqulwa luse etafuleni elihlakaniphile. Lokhu kuzovezwa ngokutholwa kwezinye izakhiwo ezingeziwe kusuka kulolu luhlu, kanye nasekushintsheni kombukiso waso obonakalayo, ngokwesitayela esikhethwe ngaphambilini. Sizokhuluma ngezimpawu eziphambili ezinikezela ngalezi zakhiwo ngokuqhubekayo.

Isifundo: Ungayenza kanjani itafula e-Excel

Igama

Ngemuva kokuthi itafula "ehlakaniphile" lenziwe, izonikezwa igama ngokuzenzakalela. Ngokuzenzakalelayo, leli yigama lohlobo. "Ithebula1", "Ithebula2" njll.

1. Ukuze ubone ukuthi yiliphi igama lethimba lethu lamathebula, khetha noma iziphi izinto zalo bese uqhubekela kwithebhu "Umqambi" ithebhu block "Ukusebenza ngamatafula". Kubambo obusiseqenjini lamathuluzi "Izindawo" insimu izotholakala "Igama lethebula". Iqukethe igama layo nje. Kithi, lokhu "Ithebula3".



2. Uma kufiswa, igama lingashintshwa ngokumane liphazamise igama kusuka kukhibhodi endle engenhla.

Manje, lapho sisebenza ngamafomula, ukuze sikhombise umsebenzi othize ukuthi kuyadingeka ukucubungula lonke uhla lwethebula, esikhundleni sokuxhumanisa okujwayelekile, kuzokwanela ukufaka igama laso njengekheli. Ngaphezu kwalokho, akukhona ukuthi kufanelekile kuphela, kodwa futhi kusebenza. Uma usebenzisa ikheli elijwayelekile ngesimo sokuxhumanisa, lapho-ke ungeza umugqa ongezansi kohlu lwethebula, noma ngabe ngemuva kokuthi ulufakiwe kwisakhiwo salo, umsebenzi ngeke uwuthathe lomugqa ukuze ucubungulwe futhi nokuphikisana kuzodingeka kuphinde kuphazanyiswe. Uma ucacisa, njengengxabano emsebenzini, ikheli elisesimweni segama lethebula lethebula, khona-ke yonke imigqa engezwe kuyo ngokuzayo izocubungulwa ngokuzenzakalelayo ngomsebenzi.

Beka ibanga

Manje ake sigxile ekuthini imigqa emisha nezinsika zengezwa kanjani kuhlu lwethebula.

1. Khetha noma isiphi iseli emugqeni wokuqala ngezansi kohlu lwethebula. Senza ukungena ngokuncintisana kuyo.



2. Bese ucindezela ukhiye Ngena kwikhibhodi. Njengoba ubona, ngemuva kwalesi senzo, wonke umugqa lapho irekhodi elisanda kufakwa khona lifakwe ngokuzenzakalela kuhlaka lwethebula.

Ngaphezu kwalokho, ukufometha okufanayo kwafakwa kuyo ngokuzenzakalelayo njengalo lonke uhla lwethebula, futhi wonke amafomula akukholamu ahambisanayo nawo aqiniswa.

Ukungezwa okufanayo kuzokwenzeka uma siqopha kwikholamu etholakala emingceleni yohlu lwethebula. Uzofakwa nasekwakheni kwalo. Ngaphezu kwalokho, igama lizonikezwa lona ngokuzenzakalelayo. Ngokuzenzakalelayo, igama lizoba Ikholomu1Ikholomu elandelayo engeziwe ithi Ikholomu2 njll. Kepha uma ufisa, ungahlala uzibize kabusha ngendlela ejwayelekile.

Enye into ewusizo yetafula elihlakaniphile ukuthi noma ngabe ungakanani okufakiwe, noma ngabe wehlela ezansi, amagama ekholomu ayohlala ephambi kwamehlo akho. Ngokuphikisana nokulungiswa okujwayelekile kwama-cap, kuleli cala, amagama ezinsika lapho wehlela phansi azobekwa khona kanye lapho kukhona khona iphaneli yokuhlanganisa etholakalayo.

Isifundo: Ungawengeza kanjani umugqa omusha ku-Excel

Amafomula we-AutoFill

Sibonile phambilini ukuthi lapho kufakwa umugqa omusha esitokisini sakhe kulelo kholomu leqoqo lamatafula esevele enefomula, le formula ikopishwa ngokuzenzakalelayo. Kepha imodi yedatha esiyifundayo inekhono ngokwengeziwe. Kwanele ukugcwalisa iseli elilodwa lekholomu engenalutho ngefomula ukuze ikopishwe ngokuzenzakalela kuzo zonke ezinye izinto zale kholamu.

1. Khetha iseli lokuqala lekholamu elingenalutho. Sifaka noma yiliphi ifomula lapho. Lokhu sikwenza ngendlela ejwayelekile: setha uphawu esitokisini "=", ngemuva kwalokho sichofoza kulawo maseli, phakathi esizokwenza umsebenzi wokubala. Phakathi kwamakheli amaseli kusuka kukhibhodi sibeka uphawu lwesenzo sezibalo ("+", "-", "*", "/" njll.). Njengoba ukwazi ukubona, noma ikheli lamaseli aliboniswa njengasesimweni esejwayelekile. Esikhundleni sokuxhumanisa okukhonjiswe kumapaneli aqonde phezulu naphezulu ngendlela yezinombolo nezinhlamvu zesiLatini, kulokhu, amagama ezinsika ngolimi afakwe kulo aboniswa njengamakheli. Isithonjana "@" kusho ukuthi iseli likulayini efanayo nefomula. Ngenxa yalokho, esikhundleni sefomula esimweni esejwayelekile

   = C2 * D2

   sithola isisetshenziswa setafula eli-smart:

   = [@ Ubungako] * [@ Intengo]



2. Manje, ukubonisa umphumela eshidini, cindezela inkinobho Ngena. Kepha, njengoba sibona, inani lokubalwa aliboniswa kuphela esitokisini sokuqala, kodwa futhi kuzo zonke izinto zekholomu. Okusho ukuthi, ifomula yayikopishwa ngokuzenzakalelayo kwamanye amaseli, futhi ngenxa yalokhu angizange ngisho ngisebenzise umaki wokugcwalisa noma amanye amathuluzi wokuphrinta ajwayelekile.

Leli phethini alisebenzi kuphela kumafomula ajwayelekile, kepha lisebenza nasemisebenzini.

Ngaphezu kwalokho, kufanele kuqashelwe ukuthi uma umsebenzisi engena ekhelini lezinto ezivela kwamanye amakholomu esitokisini selitshe ngefomula, azokhonjiswa ngemodi ejwayelekile, njenganoma yiluphi olunye uhla.

Umugqa wamanani

Enye into enhle imodi echaziwe yokusebenza ku-Excel okunikezayo ukukhipha kwamanani wekholomu kulayini ohlukile. Ukuze wenze lokhu, awudingi ukufaka ngesandla umugqa ngokukhethekile bese ushayela amafomula we-DRM kuwo, ngoba ithuluzi lamatafula "ahlakaniphile" selivele linokulungiselela kwalo kwe-argorithms okudingekayo.

1. Ukuze usebenzise i-DRM, khetha noma iyiphi itafula. Ngemuva kwalokho, iya kuthebhu "Umqambi" amaqembu wethebhu "Ukusebenza ngamatafula". Ebhokisini lamathuluzi "Izinketho zesitayela sethebula" hlola ibhokisi eliseduze nenani "Ulayini we-totals".

   

   Esikhundleni sezenzo ezingenhla, ungasebenzisa futhi inhlanganisela ye-hotkey ukwenza kusebenze umugqa wesamba. I-Ctrl + Shift + T.

2. Ngemuva kwalokho, kuzovela umugqa ongezansi ezansi kohlu lwethebula, oluzobizwa - "Isifingqo". Njengoba ukwazi ukubona, inani lekholamu lokugcina selivele libalwe ngokuzenzakalelayo kusetshenziswa umsebenzi owakhelwe-ngaphakathi IZINHLOBO.



3. Kepha singakwazi ukubala inani eliphelele lamanye amakholomu, bese sisebenzisa izinhlobo ezihlukile ngokuphelele zamanani. Qhafaza kwesobunxele noma isiphi iseli emugqeni "Isifingqo". Njengoba ukwazi ukubona, isithonjana esinxantathu sivela ngakwesokunene sale nto. Sichofoza kukho. Ngaphambi kwethu kukhona uhlu lwezinketho ezahlukene zokufingqa:
   • Isilinganiso;
   • Ubungako;
   • Ubukhulu
   • Ubuncane;
   • Inani
   • Ukuphambuka ngokweqile;
   • Ukwehluka okuhlukile.

   Sikhetha indlela yokukhipha imiphumela esicabanga ukuthi idingekile.



4. Uma thina, ngokwesibonelo, sikhetha inketho "Inani lezinombolo", khona-ke emugqeni wamanani, kuzoboniswa isibalo samaseli kukholamu agcwele izinombolo. Leli nani lizokhonjiswa umsebenzi ofanayo. IZINHLOBO.



5. Uma ungenalo ulwazi olwanele lwezici ezijwayelekile ezinikezwe uhlu lokufingqa amathuluzi achazwe ngenhla, bese uqhafaza "Ezinye izinto ..." phansi kwayo impela.



6. Lokhu kuqala iwindi. Umsebenzi Wizards, lapho umsebenzisi angakwazi ukukhetha noma yimuphi umsebenzi we-Excel awubona uwusizo. Umphumela wokusebenza kwawo uzofakwa kuseli elihambisanayo lomugqa "Isifingqo".

Ukuhlunga nokuhlunga

Etafuleni elithi "smart", ngokuzenzakalela, lapho kudalwa, amathuluzi awusizo axhuma ngokuzenzakalela ahlinzeka ngemininingwane yokuhlela nokuhlunga.

1. Njengoba ubona, enhlokweni eduze kwamagama ekholamu esitokisini ngasinye kunama-pictogramu asohlobo lokunxantathu. Kungenxa yabo ukuthi sithola ukufinyelela emsebenzini wokuhlunga. Chofoza isithonjana esiseduze negama lekholamu esizolisebenzisa ngokukhohlisa. Ngemuva kwalokho, uhlu lwezenzo ezingenzeka luyavula.



2. Uma ikholomu iqukethe amanani wokubhaliwe, ungafaka isicelo sokuhlela ngokwe-alfabhethi noma ngokuhleleka okubuyela emuva. Ukuze wenze lokhu, khetha into ngokufanele "Hlunga kusuka ku-A kuye ku-Z" noma "Hlunga kusuka ku-Z kuya ku-A".

   

   Ngemuva kwalokho, imigqa izohlelwa ngokulandelana okukhethiwe.

   

   Uma uzama ukuhlunga amanani kukholamu equkethe idatha ngefomethi yosuku, khona-ke uzonikezwa ukukhetha kwezindlela ezimbili zokuhlunga "Hlunga kusuka kokudala kuye okusha" futhi "Hlunga kusuka kokusha kuya kokudala".

   

   Ngefomethi yenombolo, izinketho ezimbili zizonikezwa: "Hlunga kusuka kobuncane kuya kobukhulu" futhi "Hlunga kusuka kwesilinganiso esiphezulu kuya kwesincane".



3. Ukuze usebenzise isihlungi, ngendlela efanayo sibiza amamenyu wokuhlunga nokuhlunga ngokuchofoza isithonjana esikukholamu okuhlobene nedatha ozosebenzisa kuyo ukusebenza. Ngemuva kwaloko, susa ukumaka amanani kusuka kuhlu oluhlwaya amanani awo. Ngemuva kokwenza izinyathelo ezingenhla ungakhohlwa uchofoze inkinobho "Kulungile" phansi kwemenyu ezivelelayo.



4. Ngemuva kwalokho, yimigqa kuphela ezosala ibonakala, eduze nalapho ushiye imikhaza kuzilungiselelo zokuhlunga. Ezinye zizofihlwa. Ngokuvamile, amanani entambo "Isifingqo" kuzoshintsha futhi. Imininingwane yemigqa ehlungiwe ngeke ibhekwe lapho kufingqwa futhi kufingqwa eminye imiphumela.

   

   Lokhu kubaluleke kakhulu kunikezwe ukuthi uma usebenzisa umsebenzi wokujwayelekile we-DRM (ISUM), hhayi opharetha IZINHLOBO, ngisho namanani afihliwe azobamba iqhaza ekubalweni.

Isifundo: Hlunga futhi uhlunge idatha ku-Excel

Guqula itafula libe libanga elijwayelekile

Vele, kuyaqabukela, kepha kwesinye isikhathi kusadingeka ukuba siguqulwe itafula eliyi-smart kuluhlu lwedatha. Isibonelo, lokhu kungenzeka uma udinga ukusebenzisa ifomula yamalungu afanayo noma obunye ubuchwepheshe obungaxhaswa yi-Excel mode yokusebenza esibufundayo.

1. Khetha noma iyiphi into yohlu lwethebula. Kubambo, iya kuthebhu "Umqambi". Chofoza isithonjana Guqula ukuze Kubangeetholakala kwibhulokhi yamathuluzi "Insizakalo".



2. Ngemuva kwalesi senzo, kuzovela ibhokisi lezingxoxo ukukubuza ukuthi ingabe sifuna ngempela ukuguqula ifomethi yetafula ibe uhlu lwedatha ejwayelekile? Uma umsebenzisi ezethemba ngezenzo zawo, bese uchofoza inkinobho Yebo.



3. Ngemuva kwalokho, uhlu lwethebula elilodwa luzoguqulwa lube yibanga elijwayelekile, lapho izakhiwo nemithetho ejwayelekile ye-Excel izosebenza.

Njengoba ukwazi ukubona, itafula elihlakaniphile lisebenza kakhulu kunokujwayelekile. Ngosizo lwayo, ungasheshisa futhi wenze lula isixazululo semisebenzi eminingi yokuqokwa kwedatha. Izinzuzo zokusetshenziswa kwayo zifaka ukwanda kwebanga okuzenzakalelayo lapho kungezwa imigqa namakholamu, i-autofilter, amaseli okuzenzakalelayo anamafomula, umugqa wethotho neminye imisebenzi ewusizo.