Okuqukethwe
Ukuhlola kusenza amaqhawe.
(Flash)
Nakuba insimbi Ukugcwaliswa Okusheshayo (Flash Gcwalisa) ivele ku-Excel kusukela kunguqulo ka-2013, kodwa ngesizathu esithile leli qiniso alizange libonwe kubasebenzisi abaningi. Futhi ngokuphelele ize. Ezimweni eziningi, kuvela ukuthi kulula, kulula futhi kuyashesha kunezixazululo ezifanayo ezisekelwe kumafomula noma ama-macros. Ngokuhlangenwe nakho kwami, ekuqeqesheni, lesi sihloko sibangela "wow!" izethameli - ngaphandle kokuthuthuka kanye / noma ukukhathala kwabalaleli.
Indlela yokusebenza yaleli thuluzi ilula: uma unekholomu eyodwa noma ngaphezulu enedatha yokuqala futhi uqala ukuyibhala eduze komunye nomunye kukholamu elandelayo, kodwa ngendlela ethile eguquliwe oyidingayo, ngokushesha noma kamuva i-Excel izobonisa lokho. isilungele ukuqhubeka ngaphezu kwakho:
Ukwembula ingqondo (iphethini, iphethini) yokuguqulwa futhi usebenzise lo msebenzi we-Excel, ngokuvamile kwanele ukufaka amanani okuqala angu-1-3 ngesandla. Uma inketho ehlongozwayo ikufanele, vele uchofoze Faka - futhi lonke uhlu luzoqedwa khona manjalo.
Uma usuwafakile amanani okuqala angu-2-3, futhi ukuqhubeka kungakaveli, ungakwazi ukuphoqa inqubo ngesinqamuleli sekhibhodi. Ctrl+E noma inkinobho yokusebenzisa Ukugcwaliswa Okusheshayo (Flash Gcwalisa) ithebhu Idatha (Usuku):
Ake sibheke izibonelo ezimbalwa zokuthi leli thuluzi lingasetshenziswa kanjani ekusebenzeni ukuqonda amakhono alo.
Ukukhipha amagama embhalweni nezimvume
Ukubhala ifomula ekhipha, isibonelo, igama lesithathu embhalweni oseseli akuyona into encane. Hlunga umusho ngesikhala kumakholomu ahlukene usebenzisa Idatha - Umbhalo ngamakholomu (Idatha — Umbhalo Kumakholomu) Ayisheshi futhi. Ngokugcwaliswa okusheshayo, lokhu kwenziwa kalula futhi kahle. Ngaphezu kwalokho, ungashintsha kanyekanye amagama akhishiwe ezindaweni, uwahlanganise nganoma iyiphi indlela:
Ukwehlukanisa umbhalo ngerejista
Ukugqamisa amagama ukuze agcwaliswe ngokushesha, akudingekile neze ukuba nesikhala. Noma iyiphi enye i-delimiter izosebenza kahle, njengokhefana noma isemicolon ngemva kokungenisa ifayela le-CSV. Kodwa okuhle kakhulu ukuthi kungase kungabi khona nhlobo isihlukanisi - osonhlamvukazi kuphela banele:
Kunzima kakhulu ukusebenzisa amafomula anjalo. Uma ngaphandle kokugcwalisa ngokushesha, i-macro kuphela izosiza.
Ukunamathisela umbhalo
Uma ungakwazi ukuhlukanisa, ungakwazi ukunamathisela! I-Instant Fill izokuhlanganisela kalula umushwana omude ezingxenyeni ezimbalwa, iwahlanganise nezikhala ezidingekayo, okhefana, izinyunyana noma amagama:
Ikhipha izinhlamvu ngazinye
Imvamisa, ukukhipha izinhlamvu ngazinye namayunithi ezinhlamvu angaphansi ku-Excel, kusetshenziswa imisebenzi I-LEVSIMV (KUSELE), KUPHELA (KWESOKUDLA), PSTR (phakathi) nokunye okunjalo, kodwa ukugcwalisa ngokushesha kuyixazulula le nkinga kalula. Isibonelo sakudala ukwakheka kwegama eligcwele:
Khipha izinombolo kuphela, umbhalo noma amadethi
Uma uke wazama ukukhipha kuphela uhlobo lwedatha olufunayo ephalishini le-alphanumeric, kufanele uqonde ubunkimbinkimbi balo msebenzi obonakala ulula. Ukugcwalisa okusheshayo futhi lapha kubhekana ne-bang, kodwa udinga i-pendel elula efomini Ctrl+E:
Okufanayo kuya ekukhipheni umbhalo.
Izinsuku nazo aziyona inkinga (ngisho noma zibhalwe ngamafomethi ahlukene):
Iguqula inombolo noma amafomethi edethi
I-Flash Fill ingasiza ekuguquleni ukubukeka kwedatha ekhona noma ilethe ku-denominator efanayo. Isibonelo, ukuguqula idethi evamile ethi "topsy-turvy" ibe ifomethi ye-Unix:
Lapha i-nuance iwukuthi ngaphambi kokungena, udinga ukushintsha ifomethi yamaseli avelayo ukuze uthumele umbhalo kusengaphambili ukuze i-Excel ingazami ukubona izinsuku "ezingalungile" ezifakwe ngesandla njengesampula.
Ngokufanayo, ungakwazi futhi ukumela izinombolo zocingo ngendlela efanele ngokwengeza ikhodi yezwe kanye nesiqalo sika-opharetha esinamadijithi amathathu (idolobha) kubakaki:
Ungakhohlwa ukuqala ngokushintsha ifomethi yamaseli akukholomu B abe umbhalo - ngaphandle kwalokho i-Excel izophatha amanani uXNUMXbuXNUMXbiqala ngophawu "+" njengamafomula.
Guqula umbhalo (izinombolo) ube yimanje
Uma ulanda kusuka kumasistimu ahlukahlukene e-ERP nawe-CRM, idethi ivamise ukumelelwa njengenombolo enezinhlamvu ezingu-8 kufomethi ye-YYYYMMDD. Ungayiguqula ibe yifomu evamile noma ngomsebenzi ISIKHOMBISI SEDATHA (DATEVALUE), noma kulula kakhulu - ukugcwalisa ngokushesha:
Shintsha icala
Uma unombhalo onekesi elingalungile, ungakwazi ukusho kalula kukholamu elandelayo ukuthi hlobo luni ofuna ukuwuguqulela kulo - futhi ukugcwalisa ngokushesha kuzokwenzela wonke umsebenzi:
Kuzoba nzima kakhulu uma udinga ukushintsha icala ngokuhlukile ezingxenyeni ezihlukene zombhalo. Isibonelo, bhala ngosonhlamvukazi igama lesibili kuphela, ushiye elokuqala esimweni salo esivamile. Lapha, amanani amabili afakwe njengesampula ngeke anele futhi kuzodingeka wenze izinguquko ukuthi ukugcwaliswa okusheshayo kuzocatshangelwa ngokushesha emiphumeleni:
Imikhawulo nama-nuances
Kunezinto ezimbalwa okufanele uzikhumbule lapho usebenzisa i-Flash Fill emsebenzini wakho:
- Isebenza kuphela uma faka amasampula ngokuqinile eceleni – kukholamu edlule noma elandelayo kwesokudla sedatha. Uma uhlehlisa ikholomu eyodwa engenalutho embhalweni wokuqala, akukho okuzosebenza.
- Lapho kutholakala iphethini wonke amanani emugqeni ayacatshangelwa — kwesokunxele nakwesokudla sekholomu yokufaka. Ukuziphatha: amakholomu engeziwe angase adide i-algorithm noma ethule umsindo kufanele ahlukaniswe nedatha yokusebenza kusengaphambili ngamakholomu angenalutho noma asuswe.
- Ukugcwaliswa Okusheshayo isebenza kahle kumathebula ahlakaniphile.
- kancane iphutha noma iphutha uma uthayipha amaseli esampula kungabangela ukugcwaliswa kwefuleshi ukuthi kuhluleke ukuveza iphethini futhi kungasebenzi. Qaphela.
- Kunezimo lapho isifanekiso sichazwa ngokungalungile, ngakho njalo kudingeka uhlole okutholweowatholile (okungenani ngokukhetha).
- Indlela yokukhipha igama lokugcina embhalweni kuseli
- Ukusesha Okungaqondakali Kombhalo (Pushkin = Pushkin) Ngokubheka Okungaqondakali ku-Excel
- Izindlela Ezintathu Zokunamathisela Umbhalo ku-Excel