12 lub tswv yim yooj yim kom ua tiav sai hauv Excel

2024 Tus sau: Malcolm Clapton | [email protected]. Kawg hloov kho: 2024-01-13 01:43

Yuav ua li cas ntxiv cov ntaub ntawv sai sai, tsim lub rooj ntse, lossis txuag cov ntaub ntawv tsis tau khaws cia.

1. Ceev nrooj ntxiv cov ntaub ntawv tshiab rau hauv daim ntawv

Yog tias cov ntaub ntawv tshiab tshwm rau ntawm daim ntawv rau daim duab kos duab, uas yuav tsum tau ntxiv, ces koj tuaj yeem xaiv ntau yam nrog cov ntaub ntawv tshiab, luam nws (Ctrl + C) thiab tom qab ntawd muab nws ncaj qha rau hauv daim duab (Ctrl + V).

2. Flash Sau

Piv txwv tias koj muaj ib daim ntawv teev npe tag nrho (Ivanov Ivan Ivanovich), uas koj yuav tsum tau tig mus rau hauv cov npe luv (Ivanov I. I.). Txhawm rau ua qhov no, koj tsuas yog yuav tsum pib sau cov ntawv xav tau hauv kab uas nyob ib sab ntawm tes. Ntawm kab thib ob lossis thib peb, Excel yuav sim kwv yees peb cov kev ua thiab ua tiav cov txheej txheem ntxiv. Txhua yam koj yuav tsum tau ua yog nias tus yuam sij Enter kom paub meej, thiab tag nrho cov npe yuav raug hloov dua siab tshiab tam sim ntawd. Ib yam li ntawd, koj tuaj yeem rho cov npe los ntawm email, nplaum lub npe los ntawm cov khoom tawg, thiab lwm yam.

3. Luam tawm yam tsis muaj kev cuam tshuam

Koj feem ntau yuav paub txog cov cim ua kom tiav autocomplete. Qhov no yog ib tug nyias dub ntoo khaub lig nyob rau hauv sab xis ces kaum ntawm lub xov tooj ntawm tes, rub uas koj muaj peev xwm luam cov ntsiab lus ntawm ib tug xov tooj ntawm tes los yog ib tug formula rau ntau lub hlwb ib zaug. Txawm li cas los xij, muaj ib qho tsis txaus ntseeg: qhov kev luam no feem ntau ua txhaum tus qauv ntawm lub rooj, vim tsis yog cov qauv luam tawm xwb, tab sis kuj yog cov qauv ntawm tes. Qhov no tuaj yeem zam tau. Tam sim ntawd tom qab rub tus ntoo khaub lig dub, nyem rau ntawm lub cim ntse - lub cim tshwj xeeb uas tshwm nyob rau sab xis sab xis ntawm thaj chaw theej.

Yog tias koj xaiv qhov kev xaiv Sau Tsis muaj Formatting, Excel yuav luam koj cov qauv yam tsis muaj formatting thiab yuav tsis lwj qhov layout.

4. Tso cov ntaub ntawv los ntawm Excel daim ntawv nthuav qhia ntawm daim ntawv qhia

Hauv Excel, koj tuaj yeem tso saib koj cov geodata sai sai ntawm daim ntawv qhia kev sib tham, xws li kev muag khoom hauv nroog. Txhawm rau ua qhov no, mus rau Chaw Ua Haujlwm Khw ntawm Insert tab thiab nruab Bing Maps plugin los ntawm qhov ntawd. Qhov no tuaj yeem ua tiav los ntawm lub vev xaib los ntawm nyem lub pob tau txais tam sim no.

Tom qab ntxiv ib qho module, koj tuaj yeem xaiv nws los ntawm My Apps drop-down list ntawm Insert tab thiab muab tso rau hauv koj daim ntawv ua haujlwm. Nws tseem yog xaiv koj lub hlwb nrog cov ntaub ntawv thiab nyem rau ntawm lub pob Qhia qhov chaw hauv daim ntawv qhia module kom pom peb cov ntaub ntawv ntawm nws. Yog tias xav tau, hauv qhov chaw plugin, koj tuaj yeem xaiv hom kab ntawv thiab xim los tso saib.

5. Ceev dhia mus rau daim ntawv xav tau

Yog tias tus naj npawb ntawm cov ntawv ua haujlwm hauv cov ntaub ntawv tau tshaj 10, ces nws nyuaj rau kev taw qhia lawv. Right-click ib qho ntawm cov ntawv tabs scroll nyees khawm nyob rau sab laug ces kaum ntawm lub vijtsam. Lub rooj ntawm cov ntsiab lus yuav tshwm sim, thiab koj tuaj yeem dhia mus rau ib daim ntawv xav tau tam sim ntawd.

6. Hloov kab rau kab thiab rov ua dua

Yog hais tias koj puas tau yuav tsum tau txav hlwb los ntawm kab mus rau kab los ntawm tes, ces koj yuav txaus siab rau cov nram qab no ua kom yuam kev:

1. Qhia qhov ntau.
2. Luam nws (Ctrl + C) lossis, los ntawm txhaj rau ntawm txoj cai nas khawm, xaiv "Copy" (Copy).
3. Txoj cai-nias ntawm lub xovtooj uas koj xav muab cov ntaub ntawv thiab xaiv ib qho ntawm Cov Kev Xaiv Tshwj Xeeb los ntawm cov ntawv qhia zaub mov - Transpose icon. Cov ntawv qub ntawm Excel tsis muaj lub cim no, tab sis koj tuaj yeem kho qhov teeb meem los ntawm kev siv Paste Tshwj Xeeb (Ctrl + Alt + V) thiab xaiv qhov kev xaiv Transpose.

7. Teev-down daim ntawv teev nyob rau hauv ib lub xovtooj ntawm tes

Yog hais tias nyob rau hauv ib lub xovtooj ntawm tes nws yuav tsum tau nkag mus rau cov ntsiab lus nruj me ntsis los ntawm cov kev tso cai (piv txwv li, tsuas yog "yog" thiab "tsis yog" lossis tsuas yog los ntawm cov npe ntawm cov tuam txhab lag luam thiab lwm yam), ces qhov no tuaj yeem yooj yim teeb tsa siv. daim ntawv teev cia.

1. Xaiv ib lub xovtooj (lossis ntau lub cell) uas yuav tsum muaj qhov txwv.
2. Nyem qhov "Validation" khawm ntawm "Cov ntaub ntawv" tab (Cov ntaub ntawv → Validation).
3. Hauv daim ntawv teev npe "Type" (Tswj) xaiv qhov kev xaiv "Tsev" (Sau npe).
4. Hauv qhov "Tsev" teb, qhia qhov ntau yam uas muaj cov kev siv sib txawv ntawm cov ntsiab lus, uas yuav tom qab tso tawm thaum ntaus ntawv.

8. Ntse rooj

Yog tias koj xaiv ntau yam nrog cov ntaub ntawv thiab nyob rau ntawm "Tsev" tab nyem "Format as a table" (Home → Format as Table), ces peb cov npe yuav raug hloov mus rau hauv lub rooj ntse uas tuaj yeem ua tau ntau yam tseem ceeb:

1. Tsis siv neeg ncab thaum kab tshiab lossis kab ntxiv rau nws.
2. Cov qauv uas nkag mus yuav raug muab theej rau tag nrho kem.
3. Lub header ntawm lub rooj zoo li no tau raug kho thaum scrolling, thiab nws suav nrog cov khawm lim rau lim thiab txheeb xyuas.
4. Nyob rau hauv tab "Design" nyob rau hauv xws li ib lub rooj, koj muaj peev xwm ntxiv ib tug kab ntawm tag nrho cov uas tsis siv neeg xam.

9. Cov nplaim taws

Sparklines yog cov kab kos me me uas tau kos rau hauv cov hlwb uas pom qhov kev hloov pauv ntawm peb cov ntaub ntawv. Txhawm rau tsim lawv, nyem rau kab lossis kab hauv kab hauv pawg Sparklines ntawm Insert tab. Nyob rau hauv lub qhov rais uas qhib, qhia qhov ntau yam nrog cov thawj cov ntaub ntawv tus lej thiab cov hlwb uas koj xav kom pom cov sparklines.

Tom qab nyem rau ntawm lub pob "OK", Microsoft Excel yuav tsim lawv hauv cov hlwb uas tau teev tseg. Nyob rau ntawm "Tsim" tab uas tshwm sim, koj tuaj yeem hloov kho lawv cov xim, hom, ua kom pom qhov tsawg kawg nkaus thiab qhov siab tshaj plaws, thiab lwm yam.

10. Rov qab cov ntaub ntawv tsis tau khaws tseg

Xav txog: koj kaw tsab ntawv ceeb toom uas koj fiddled nrog ib nrab hnub kawg, thiab nyob rau hauv lub dialog box uas tshwm "Txuag hloov mus ua ntaub ntawv thov?" mam li nco dheev rau qee qhov laj thawj koj nias "Tsis yog". Lub chaw ua haujlwm tshaj tawm koj lub siab quaj qw, tab sis nws lig dhau lawm: ob peb teev dhau los ntawm kev ua haujlwm tau poob dej.

Qhov tseeb, muaj lub caij nyoog los kho qhov xwm txheej. Yog tias koj muaj Excel 2010, tom qab ntawd nyem rau ntawm "Cov Ntaub Ntawv" → "Tsis ntev los no" (Cov Ntaub Ntawv → Tsis ntev los no) thiab nrhiav lub pob "Rov qab Unsaved Workbooks" nyob rau sab xis sab xis ntawm lub vijtsam.

Hauv Excel 2013, txoj kev sib txawv me ntsis: Cov ntaub ntawv → Paub meej → Tswj Version → Cov Ntaub Ntawv - Cov Khoom Siv - Rov qab Unsaved Workbooks.

Hauv cov ntawv tom ntej ntawm Excel, qhib Cov Ntaub Ntawv → Cov Ntaub Ntawv → Kev Tswj Xyuas Haujlwm.

Ib daim nplaub tshev tshwj xeeb los ntawm lub plab zom mov ntawm Microsoft Office yuav qhib, qhov twg cov ntawv luam ib ntus ntawm txhua tus tsim lossis hloov kho, tab sis cov phau ntawv tsis tau khaws cia hauv qhov xwm txheej zoo li no.

11. Kev sib piv ntawm ob qhov sib txawv rau qhov sib txawv thiab qhov sib txawv

Qee zaum thaum ua haujlwm hauv Excel, koj yuav tsum sib piv ob daim ntawv teev npe thiab nrhiav cov khoom uas zoo ib yam lossis txawv ntawm lawv. Nov yog qhov ceev tshaj plaws, feem ntau intuitive txoj kev ua nws:

1. Xaiv ob kab sib piv (tuav tus yuam sij Ctrl).
2. Xaiv Tsev tab → Conditional Formatting → Highlight Cell Rules → Duplicate values.
3. Xaiv qhov kev xaiv tshwj xeeb los ntawm cov npe dropdown.

12. Kev xaiv (hloov kho) ntawm kev suav cov txiaj ntsig rau qhov yuav tsum tau muaj

Koj puas tau tweaked cov tswv yim qhov tseem ceeb hauv koj qhov kev suav Excel kom tau txais cov zis koj xav tau? Nyob rau lub sijhawm zoo li no koj xav tias zoo li ib tus neeg tua phom loj: tsuas yog ob peb lub kaum os iterations ntawm "undershoot - overflights" - thiab ntawm no nws yog, qhov ntev-awaited hit!

Microsoft Excel tuaj yeem ua qhov no rau koj, nrawm dua thiab raug. Txhawm rau ua qhov no, nyem lub pob "Dab tsi Yog" ntawm "Cov ntaub ntawv" tab thiab xaiv "Parameter xaiv" hais kom ua (Ntxig → Yuav ua li cas Yog Kev Tshawb Fawb → Lub Hom Phiaj Nrhiav). Nyob rau hauv lub qhov rais uas tshwm, qhia cov xov tooj ntawm tes uas koj xav xaiv tus nqi xav tau, qhov xav tau tshwm sim thiab cov tswv yim ntawm tes uas yuav tsum tau hloov. Tom qab nyem rau ntawm "OK" Excel yuav ua tiav mus txog 100 "shot" txhawm rau txhawm rau pom qhov xav tau tag nrho nrog qhov tseeb ntawm 0,001.