Mukati
Miedzo inotiita magamba.
(Flash)
Kunyangwe chiridzwa Instant Zadza (Flash Kuzadza) yakaonekwa muExcel kubvira vhezheni ya2013, asi nekuda kwechimwe chikonzero chokwadi ichi hachina kucherechedzwa kune vakawanda vashandisi. Uye zvachose pasina. Muzviitiko zvakawanda, zvinova zviri nyore, zviri nyore uye nekukurumidza kupfuura mhinduro dzakafanana zvichienderana nemafomula kana macros. Mune ruzivo rwangu, mukudzidziswa, nyaya iyi inokonzera kugara "wow!" vateereri - zvisinei nekufambira mberi uye / kana kuneta kwevateereri.
Maitiro ekushanda kwechishandiso ichi ari nyore: kana iwe uine imwe kana anopfuura makoramu ane data rekutanga uye wotanga kuanyora padivi peumwe neumwe mumutsara unotevera, asi mune imwe yakagadziridzwa fomu yaunoda, ipapo nekukurumidza kana gare gare Excel icharatidza izvozvo. zvagadzirira kupfuurira mberi kupfuura imi.
Kuburitsa zvine musoro (pattern, pateni) yeshanduko uye mhanyisa basa iri reExcel, rinowanzo kukwana kuti uise yekutanga 1-3 inokonzeresa tsika nemaoko. Kana iyo yakatsanangurwa sarudzo ichikukodzera, wobva wadzvanya pinda - uye mamwe rondedzero ichapedzwa ipapo ipapo.
Kana iwe watopinda yekutanga 2-3 kukosha, uye kuenderera kuchiri kusati kwaoneka, saka unogona kumanikidza maitiro acho ne keyboard shortcut. Ctrl+E kana kushandisa bhatani Instant Zadza (Flash Kuzadza) Tab Data (Zuva):
Ngatitarisei mienzaniso mishoma yekuti chishandiso ichi chingashandiswa sei mukuita kuti tinzwisise kugona kwayo.
Kutora mazwi kubva pane zvinyorwa uye zvibvumirano
Kunyora fomula inobvisa, semuenzaniso, izwi rechitatu kubva pane zvinyorwa musero hazvisi diki. Gadzira chirevo nechadenga muzvikamu zvakasiyana uchishandisa Data - Zvinyorwa neColumns (Data - Chinyorwa kune Columns) Hazvina zvakare kukurumidza. Nekuzadza nekukurumidza, izvi zvinoitwa nyore uye zvakanaka. Uyezve, iwe unogona panguva imwe chete kuchinja mazwi akatorwa munzvimbo, uchiasanganisa mune chero kurongeka:
Kugovanisa zvinyorwa nerejista
Kusimbisa mazwi ekuzadza ipapo ipapo, hazvifanirwe zvachose kuve nenzvimbo. Chero imwe delimiter ichashanda zvakanaka, senge comma kana semicolon mushure mekupinza iyo CSV faira. Asi chakanyanya kutonhorera ndechekuti panogona kunge pasina kupatsanura zvachose - mavara makuru chete anokwana:
Zvakaoma zvikuru kushandisa mafomula akadaro. Kana pasina kuzadza ipapo ipapo chete macro ichabatsira.
Text gluing
Kana iwe uchigona kupatsanura, saka iwe unogona glue! Instant Kuzadza kuchakuunganidzira zviri nyore mutsara wakareba kubva kune akati wandei zvidimbu, uchiasanganisa nenzvimbo dzinodiwa, koma, mibatanidzwa kana mazwi:
Kutora mavara ega
Kazhinji, kuburitsa mavara ega ega uye substrings muExcel, mabasa anoshandiswa LEVSIMV (RUBOSHWE), RUDYI (RUDYI), PSTR (pakati) nezvimwe zvakadaro, asi kuzadza ipapo kunogadzirisa dambudziko iri nyore. Muenzaniso wekare ndiko kuumbwa kwezita rakazara:
Bvisa nhamba chete, zvinyorwa kana mazuva
Kana iwe wakamboedza kuburitsa chete yaidiwa data mhando kubva kune alphanumeric porridge, saka iwe unofanirwa kunzwisisa kuoma kweiyi basa rinoita serakapusa. Kuzadza nekukasira uye pano kunobata ne bang, asi iwe unoda mwenje penel mune fomu Ctrl+E:
Zvimwe chetezvo zvekubvisa zvinyorwa.
Mazuva haaziwo dambudziko (kunyangwe akanyorwa nenzira dzakasiyana):
Kushandura nhamba kana mafomati emazuva
Flash Kuzadza inogona kubatsira kushandura kutaridzika kwe data iripo kana kuiunza kune imwechete denominator. Semuenzaniso, kushandura zuva rakajairika "topsy-turvy" kuita Unix fomati:
Pano iyo nuance ndeyekuti usati wapinda, unofanirwa kushandura fomati yemasero anobuda kuti anyore pachine nguva kuitira kuti Excel isayedze kuziva "zvisizvo" misi yakapinda nemaoko semuenzaniso.
Saizvozvo, iwe unogona zvakare kumiririra nemazvo nhamba dzenhare nekuwedzera iyo kodhi yenyika uye matatu-manhamba opareta (guta) prefix mumabhuraki:
Usakanganwa kutanga wachinja mafomati emaseru ari muchikamu B kuita mavara - zvikasadaro Excel inobata makhuruuXNUMXbuXNUMXbkutanga nechiratidzo "+" semafomula.
Shandura mavara (nhamba) kuti ave nhasi
Kana uchidhawunirodha kubva kwakasiyana ERP neCRM masisitimu, zuva racho rinowanzo miririrwa senhamba-masere muchimiro cheYYYYMMDD. Unogona kuishandura kuita yakajairika fomu kungave nebasa DATA IDENTIFIER (DATEVALUE), kana zvakanyanya nyore - kuzadza ipapo:
Shandura nyaya
Kana iwe uine mameseji ane kesi isiriyo, saka iwe unogona kungonongedza mumutsara unotevera kuti rudzii rwaunoda kuchishandura kuva - uye kuzadza ipapo kuchakuitira basa rese:
Zvichava zvishoma zvakaoma kana iwe uchida kushandura nyaya yacho zvakasiyana kune zvikamu zvakasiyana zvemashoko. Semuenzaniso, nyora izwi rechipiri chete nekukura, uchisiya rekutanga muchimiro charo chemazuva ese. Pano, maitiro maviri akaiswa semuenzaniso haakwane uye iwe uchafanirwa kuita shanduko iyo yekuzadza ipapo ipapo ichafunga nezvayo mumhedzisiro:
Kugumira uye nuances
Pane zvinhu zvishoma zvekuchengeta mupfungwa kana uchishandisa Flash Zadza pabasa rako:
- Inoshanda chete kana isa sampuli zvakasimba padivi nepadivi - mune yakapfuura kana inotevera koramu kurudyi rwe data. Kana ukadzosa koramu imwe isina chinhu kubva kune yekutanga mavara, hapana chinozoshanda.
- Kana patani yawanikwa zvese zvakakosha mumutsara zvinoverengerwa - kuruboshwe uye kurudyi kwekoramu yekupinda. Tsika: mamwe makoramu anogona kuvhiringa algorithm kana kuunza ruzha anofanira kupatsanurwa kubva kune inoshanda data pachine nguva nemakoramu asina chinhu kana kudzimwa.
- Instant Zadza inoshanda zvikuru mumatafura akangwara.
- zvishoma kukanganisa kana typo kana kutaipa masero masero anogona kukonzera flash kuzadzwa kutadza kuburitsa pateni uye kusashanda. Chenjera.
- Pane mamiriro ezvinhu apo template inotsanangurwa zvisizvo, saka nguva dzose inoda kutarisa zvakawanikwaiyo yawakagamuchira (zvichida kusarudza).
- Maburitsiro ezwi rekupedzisira kubva muzvinyorwa musero
- Fuzzy Text Search (Pushkin = Pushkin) ine Fuzzy Lookup muExcel
- Nzira nhatu dzekunamira Chinyorwa muExcel