txheem
Kev sim ua rau peb tus phab ej.
(Flash)
Txawm yog instrument Instant Sau (Flash Sau) tau tshwm sim hauv Excel txij li xyoo 2013, tab sis rau qee qhov laj thawj qhov tseeb tau mus tsis pom rau ntau tus neeg siv. Thiab kiag li nyob rau hauv vain. Feem ntau, nws hloov tawm kom yooj yim dua, yooj yim dua thiab nrawm dua li cov kev daws teeb meem zoo sib xws raws li cov qauv lossis macros. Hauv kuv qhov kev paub, hauv kev cob qhia, lub ncauj lus no ua rau muaj qhov "wow!" cov neeg mloog - tsis hais txog kev nce qib thiab / lossis qaug zog ntawm cov neeg mloog.
Lub tshuab ua haujlwm ntawm cov cuab yeej no yog qhov yooj yim: yog tias koj muaj ib lossis ntau kab nrog cov ntaub ntawv thawj zaug thiab koj pib ntaus lawv ib sab ntawm ib sab hauv kab tom ntej, tab sis hauv qee daim ntawv hloov kho koj xav tau, tom qab ntawd sai lossis tom qab Excel yuav qhia tias. nws yog npaj txhij mus ntxiv tshaj koj:
Txhawm rau nthuav tawm cov laj thawj (tus qauv, qauv) ntawm kev hloov pauv thiab khiav qhov haujlwm Excel no, feem ntau yog txaus los nkag rau thawj 1-3 qhov txiaj ntsig tau los ntawm tes. Yog hais tias qhov kev xaiv uas tsim nyog rau koj, ces cia li nias Sau - thiab lwm daim ntawv teev npe yuav ua tiav tam sim ntawd.
Yog tias koj twb tau nkag mus rau thawj 2-3 qhov tseem ceeb, thiab kev txuas ntxiv tseem tsis tshwm sim, ces koj tuaj yeem yuam cov txheej txheem nrog keyboard shortcut. Ctrl+E los yog siv khawm Instant Sau (Flash Sau) tab Cov ntaub ntawv (Hnub):
Cia peb saib ob peb yam piv txwv ntawm yuav ua li cas cov cuab yeej no siv tau rau hauv kev xyaum kom nkag siab txog nws lub peev xwm.
Extracting cov lus los ntawm cov ntawv nyeem thiab permutations
Sau cov qauv uas muab rho tawm, piv txwv li, lo lus thib peb los ntawm cov ntawv hauv ib lub xovtooj yog tsis muaj qhov me me. Parse ib kab lus los ntawm qhov chaw mus rau hauv kab sib txawv siv Cov ntaub ntawv - Cov ntawv nyeem los ntawm kab (Cov ntaub ntawv - Cov ntawv nyeem rau kab) Nws kuj tsis ceev. Nrog instant sau, qhov no ua tau yooj yim thiab zoo nkauj. Tsis tas li ntawd, koj tuaj yeem hloov pauv cov lus muab rho tawm hauv qhov chaw, sib txuas lawv hauv txhua qhov kev txiav txim:
Faib cov ntawv los ntawm kev sau npe
Txhawm rau qhia cov lus rau kev sau tam sim, nws tsis tas yuav tsum muaj qhov chaw. Lwm tus delimiter yuav ua hauj lwm zoo, xws li ib tug comma los yog semicolon tom qab importing cov ntaub ntawv CSV. Tab sis dab tsi yog qhov txias heev yog tias tej zaum yuav tsis muaj qhov sib cais ntawm txhua qhov - tsuas yog cov ntawv loj txaus:
Nws yog qhov nyuaj heev los siv cov qauv no. Yog tias tsis muaj qhov ntim tam sim, ces tsuas yog macro yuav pab tau.
Text gluing
Yog tias koj tuaj yeem faib tau, koj tuaj yeem ua kua nplaum! Instant Fill yuav yooj yim sib sau ua ke ib kab lus ntev rau koj los ntawm ntau qhov tawg, cuam tshuam nrog cov chaw tsim nyog, commas, cov koom haum lossis cov lus:
Extracting tus kheej cim
Feem ntau, txhawm rau rub tawm tus kheej cov cim thiab cov hlua hauv Excel, cov haujlwm tau siv LEVSIMV (QAUG), TXOJ CAI (RIGHT), PSTR (mid) thiab cov zoo li, tab sis instant filling daws qhov teeb meem no yooj yim. Ib qho piv txwv classic yog tsim lub npe tag nrho:
Tshem tawm cov lej, ntawv lossis hnub
Yog tias koj tau sim rub tawm tsuas yog cov ntaub ntawv xav tau los ntawm alphanumeric porridge, ces koj yuav tsum nkag siab qhov nyuaj ntawm txoj haujlwm no zoo li yooj yim. Instant filling thiab no copes nrog ib tug bang, tab sis koj xav tau ib lub teeb pendel nyob rau hauv daim ntawv Ctrl+E:
Ib yam mus rau extract cov ntawv.
Hnub tsis yog ib qho teeb meem (txawm tias lawv tau sau ua ntau hom):
Hloov tus lej lossis hnub tawm tswv yim
Flash Fill tuaj yeem pab hloov cov duab ntawm cov ntaub ntawv uas twb muaj lawm lossis coj mus rau tib tus lej. Piv txwv li, hloov hnub tsis tu ncua "topsy-turvy" rau Unix hom:
Ntawm no yog qhov nuance yog tias ua ntej nkag mus, koj yuav tsum hloov cov hom ntawv ntawm lub hlwb mus rau cov ntawv nyeem ua ntej kom Excel tsis sim kom paub txog cov hnub "tsis raug" nkag mus rau hauv tus qauv.
Ib yam li ntawd, koj tuaj yeem ua tus sawv cev rau tus xov tooj kom raug los ntawm kev ntxiv lub teb chaws chaws thiab tus neeg teb xov tooj peb tus lej (lub nroog) ua ntej hauv cov kab lus:
Tsis txhob hnov qab ua ntej hloov cov qauv ntawm cov hlwb hauv kab B rau cov ntawv nyeem - txwv tsis pub Excel yuav kho cov txiaj ntsig uXNUMXbuXNUMXb pib nrog "+" kos npe ua qauv.
Hloov cov ntawv (tus lej) rau hnub tim
Thaum rub tawm los ntawm ntau yam ERP thiab CRM systems, hnub feem ntau yog sawv cev ua tus lej 8 tus lej hauv YYYYMMDD hom. Koj tuaj yeem hloov nws mus rau ib daim ntawv ib txwm los ntawm kev ua haujlwm DATA IDENTIFIER (DATEVALUE), los yog yooj yim dua - instant filling:
Hloov rooj plaub
Yog tias koj tau txais cov ntawv nyeem nrog cov ntaub ntawv tsis raug, koj tuaj yeem hais qhia hauv kab tom ntej yam koj xav hloov nws mus rau - thiab kev sau tam sim yuav ua txhua yam haujlwm rau koj:
Nws yuav nyuaj me ntsis yog tias koj yuav tsum tau hloov cov ntaub ntawv sib txawv rau qhov sib txawv ntawm cov ntawv nyeem. Piv txwv li, siv lo lus thib ob nkaus xwb, tawm hauv thawj zaug hauv nws daim ntawv qub. Ntawm no, ob qhov tseem ceeb nkag mus rau hauv tus qauv yuav tsis txaus thiab koj yuav tsum tau hloov pauv uas instant filling yuav tam sim ntawd coj mus rau hauv tus account hauv cov txiaj ntsig:
Kev txwv thiab nuances
Muaj ob peb yam uas yuav tsum nco ntsoov thaum siv Flash Fill hauv koj txoj haujlwm:
- Nws tsuas ua haujlwm yog tias nkag mus kuaj nruj me ntsis ntawm ib sab - hauv kab ntawv dhau los lossis tom ntej mus rau sab xis ntawm cov ntaub ntawv. Yog tias koj thim rov qab ib kem khoob ntawm cov ntawv qub, ces tsis muaj dab tsi yuav ua haujlwm.
- Thaum pom tus qauv tag nrho cov nqi nyob rau hauv ib tug kab yog coj mus rau hauv tus account - rau sab laug thiab sab xis ntawm kab ntawv nkag. Kev coj ncaj ncees: cov kab ntxiv uas tuaj yeem cuam tshuam cov algorithm lossis qhia lub suab nrov yuav tsum tau muab cais tawm ntawm cov ntaub ntawv ua haujlwm ua ntej los ntawm cov kab khoob lossis tshem tawm.
- Instant Sau ua haujlwm zoo hauv cov rooj ntse.
- me ntsis yuam kev los yog typo thaum ntaus cov qauv cell tuaj yeem ua rau flash sau tsis qhia tus qauv thiab tsis ua haujlwm. Ceev faj.
- Muaj cov xwm txheej uas tus qauv tau txhais tsis raug, yog li ntawd ib txwm yuav tsum tau kuaj xyuas kev tshawb pomuas koj tau txais (tsawg kawg xaiv).
- Yuav ua li cas rho tawm lo lus kawg los ntawm cov ntawv nyeem hauv lub xov tooj ntawm tes
- Fuzzy Text Search (Pushkin = Pushkin) nrog Fuzzy Lookup hauv Excel
- Peb txoj hauv kev los Paste Text hauv Excel