Dos thiab Dont's ntawm Cov Ntaub Ntawv Sau Cov Ntaub Ntawv hauv Excel

01 ntawm 08

Excel Cov Ntaub Ntawv Nkag Mus Siv

Qhov kev qhia nyeem no yog siv qee cov hauv paus hauv paus thiab DONsTs ntawm cov ntaub ntawv nkag mus rau hauv cov ntaub ntawv xws li Excel, Google Spreadsheets, thiab Open Office Calc.

Nkag mus rau cov ntaub ntawv kom yog thawj zaug yuav zam dhau cov teeb meem tom qab thiab ua kom yooj yim siv ntau tus Excel cov cuab yeej thiab nta xws li cov qauv thiab cov kab kos.

Cov Do thiab DON'Ts yog:

1. Npaj koj daim ntawv nplua nuj
2. Tsis txhob sau ntawv cim kab lossis txhua txhua thaum nkag mus rau lwm cov ntaub ntawv
3. Tsis txhob txuag nquag thiab txuag hauv ob lub chaw
4. Tsis txhob siv Cov Naj Npawb los ntawm Kem Lub Npe thiab Tsis Txhuam Nrog Chav Nyob nrog Cov Ntaub Ntawv
5. Siv Kev Tshawb Fawb Thiab Lub Npe Ua Ntej Hauv Cov Qauv
6. Tsis txhob tso cov hlwb uas muaj cov qauv xauv
7. Ua Txheeb Koj Cov Ntaub Ntawv

Npaj Ua Koj Daim Ntawv Sau Tseg

Thaum nws los mus rau cov ntaub ntawv hauv Excel, nws yog ib lub tswv yim zoo ua ib qho kev npaj ua ntej koj pib ntaus.

Paub txog cov ntawv ua haujlwm yuav siv rau, cov ntaub ntawv nws yuav muaj, thiab yuav ua li cas nrog cov ntaub ntawv ntawd yuav cuam tshuam rau qhov kawg ntawm kev ua haujlwm.

Kev npaj ua ntej hom yuav txuag lub sij hawm tom qab yog tias daim ntawv khom nqi yuav tsum tau muab coj los ua kom yooj yim dua thiab yooj yim dua ua haujlwm nrog.

Cov Ntsiab Lus Xav Txog

• Lub hom phiaj ntawm daim ntawv khom nqi yog dab tsi?
• Cov ntaub ntawv khom nqi npaum li cas?
• Cov kab lus xav tau?
• Cov ntaub ntawv khom nqi puas yuav luam tawm?

Lub Hom phiaj ntawm Spreadsheet yog dab tsi?

• Lub hom phiaj ntawm daim ntawv khom nqi yuav pab txiav txim seb qhov chaw ntawm cov ntaub ntawv, li cov ntaub ntawv tseem ceeb tshaj plaws yuav tsum pom thiab nkag yooj yim.
• Dab tsi yog qhov xav tau? Cov lus teb yuav cuam tshuam dab tsi cov qauv thiab cov hauj lwm uas yuav tsum muaj thiab lawv yuav nyob qhov twg.

Npaum Li Cas Cov Nqi Ntaub Ntawv Tawm Tsam Lawm?

Cov nqi ntawm cov ntaub ntawv khom nqi ntawm daim ntawv khom nqi yuav pib tuav thiab ntau npaum li cas ntxiv tom qab yuav cuam tshuam rau cov ntawv ua haujlwm uas siv.

• Tsis txhob kis koj cov ntaub ntawv tawm ntau dhau vim nws tuaj yeem ua cov ntaub ntawv qhia yooj yim mus nrhiav thiab kev sib piv ib daim ntawv ntau ntau los yog cov phau ntawv muaj peev xwm pib tau los cuam tshuam rau Excel qhov kev ua tau zoo.
• Rau cov ntawv ua haujlwm loj, nws yog qhov tseem ceeb kom pom cov kab lus tseem ceeb ntawm sab saud kiag, tsis txhob yuam cov neeg siv los mus rau hauv qab ntawm daim ntawv ua haujlwm kom pom cov ntaub ntawv.

Puas Yuav Tsum Tau Tshaj Tawm?

Yog tag nrho los yog ib feem ntawm cov ntaub ntawv yuav tsum tau muab tso rau hauv daim duab los yog cov kab kos, nws yuav muaj feem cuam tshuam rau kev teeb tsa ntawm cov ntaub ntawv,

• Raws li daim hom ntawv qhia, cov ntaub ntawv yuav tsum tau muab sib faib ua ke - xws li kev ua haujlwm thaj chaw hauv cov ntsiab lus rau cov khoom noj qab zib.
• Rau cov ntawv loj spreadsheets, cov kab kos tau txav mus rau lwm nplooj ntawv kom tsis txhob muaj neeg coob coob

Puas Yuav Sau Tseg Sau Npe?

Yuav muab cov ntaub ntawv li cas los cuamtshuam yog tias tag nrho lossis qee yam ntawm cov ntaub ntawv yuav muab luam tawm, nyob ntawm saib seb puas yuav tau xaiv cov duab lossis cov duab thaij thiab cov nplooj ntawv yuav tsum muaj.

• Yog siv daim ntawv pom zoo rau daim ntawv loj (8 1/2 X 11), xav seb feem ntau ntawm cov ntaub ntawv hauv cov kab hauv ob peb kab, kom tag nrho cov hau lus tshwm ntawm ib daim ntawv.
• Yog tias xav tau ntau cov ntawv ntxiv, xav txog kev sau ntawv taub hau ntawm sab saum toj ntawm nplooj ntawv kom nyeem tau cov ntaub ntawv yooj yim.
• Yog hais tias muaj ntau cov ntaub ntawv yuav tsum luam tawm, qhov tsim cov duab hauv tsev yuav khaws tag nrho cov hau lus ntawm ib nplooj ntawv. Ntxiv dua thiab, yog xav tau ntau cov ntawv txheeb, sau cov lus qhia kiag ntawm sab saum toj ntawm nplooj ntawv.
• Yog tias kab kos tau muab luam tawm, tsiv mus rau lwm daim ntawv yuav ua rau kev ua haujlwm yooj yim.

02 ntawm 08

Tsis txhob sau cov kabmob tsis txaus los yog txhua txoj hauv cov ntaub ntawv

Tawm ntawm ib qho ntawm kab sau los yog kab hauv cov ntawv xov xwm los yog cov sib txawv ntawm cov ntaub ntawv yuav ua rau nws nyuaj heev kom siv tau ntau tus Excel cov nta xws li cov kab kos, cov ntxhuav pivot, thiab tej yam hauj lwm.

Txawm tias lub hlwb tsis muaj kab uas nyob rau hauv kab los yog kem muaj cov ntaub ntawv muaj peev xwm ua rau muaj teeb meem raws li qhia hauv daim duab saum toj no.

Cov tsis muaj chaw seem yuav ua kom yooj yim rau Excel los xyuas thiab xaiv cov ntaub ntawv muaj feem xyuam rau hauv cov chav yog tias nta xws li sorting , filtering, los yog AutoSum siv.

Tsis txhob cia cov kab tawm los yog cov kab nrib, siv cov ciam teb los yog cov hau lus thiab cov ntawv siv siv pob los yog kos hauv qab thiaj li tawg tau cov ntaub ntawv thiab ua kom yooj yim nyeem.

Sau koj cov ntaub ntawv qhia tawm-paub qab hau thaum ua tau.

• Thaum tso tawm koj daim ntawv khom nqi, tso ib lub ntsiab lus piav qhia txog sab saum toj ntawm thawj kem ntawm lub rooj nrog cov ntaub ntawv hauv qab no.
• Yog tias muaj ntau tshaj ib cov ntaub ntawv cia, sau lawv ib qho tom qab ntawm txhua kab (sab laug mus rau sab xis) nrog lub npe rau txhua cov ntaub ntawv series rau saum toj.

Khaws cov ntaub ntawv tsis txheeb

Thaum cov ntaub ntawv khaws tseg ua ke tseem ceeb, tib lub sij hawm, nws yuav pab tau kom tsis txhob muaj qhov sib txawv ntawm cov ntaub ntawv cais.

Tshem tawm ntawm txhua daim kab lus los yog kab ntawm cov ntaub ntawv sib txawv los yog lwm cov ntaub ntawv ntawm daim ntawv ua haujlwm yuav rov ua kom yooj yim dua rau Excel kom pom tseeb thiab xaiv cov phom sij los yog cov lus qhia ntawm cov ntaub ntawv.

03 ntawm 08

Tsis Txhob Txwm Nquag

Qhov tseem ceeb ntawm kev txuag koj txoj haujlwm feem ntau tsis tuaj yeem tshaj tawm - lossis tau hais ntau dhau lawm.

Tau kawg, yog tias koj siv lub vas sab-cov ntawv khom nqi-xws li Google Spreadsheets los yog Excel Online - ces txuag tsis yog qhov teeb meem, vim tsis yog qhov kev zov me nyuam muaj ib qho kev xaiv txuag, tiam sis, ua haujlwm nrog nws pib txuag feature.

Rau cov kev pab cuam hauv lub computer ho, tom qab ob lossis peb qhov kev hloov - seb nws puas ntxiv cov ntaub ntawv, hloov kev hloov, los yog nkag mus ua formula - txuag tau daim ntawv ua haujlwm.

Yog tias nws zoo li ntau dhau, tseg tsawg kawg li ob zaug lossis peb feeb.

Txawm tias qhov ruaj ntseg ntawm cov computers thiab computer software tau zoo dua qub dhau ob peb xyoos dhau los, tus software tseem crashes, hwjchim failures tseem tshwm sim, thiab lwm tus neeg tau mus ncig koj lub hwjchim qaum thiab rub tawm ntawm cov phab ntsa.

Thiab thaum nws tshwm sim, qhov poob ntawm tej nqi ntawm cov ntaub ntawv - loj los me me - tsuas yog nce koj workload li koj sim reconstruct dab tsi koj twb tau ua.

Excel muaj ib qho pib txuag feature, uas feem ntau ua haujlwm zoo heev, tab sis nws yuav tsum tsis txhob cia siab rau. Tau nyob hauv tus cwj pwm ntawm kev ruaj ntseg rau koj tus kheej cov ntaub ntawv nrog kev cawm heev.

Shortcut rau Txuag

Txuag tsis tas yuav yog ib qho hauj lwm ntawm kev txav nas mus rau ntawm txoj hlua thiab txhaj rau cov icons, mus ua tus cwj pwm ntawm txuag siv cov keyboard shortcut ua ke ntawm:

Ctrl + S

Tsis tseg nyob rau hauv Ob Qhov Chaw

Ib qho ntxiv ntawm kev cawm uas tsis tuaj yeem tshaj tawm yog qhov tseem ceeb ntawm txuag koj cov ntaub ntawv hauv ob qhov chaw sib txawv.

Qhov chaw thib ob yog, qhov tseeb, qhov thaub qab, thiab nws tau hais ntau zaus, "Thaub qab yog zoo li kev pov hwm: muaj ib tus thiab koj ntshe yuav tsis xav tau nws, tsis muaj ib qho thiab koj ntshe yuav".

Qhov zoo tshaj plaws thaub qab yog ib qho uas yog nyob rau hauv ib qho chaw txawv ntawm qhov qub. Tom qab tag nrho, qhov point yog muaj ob daim qauv ntawm cov ntaub ntawv yog lawv

• yog nyob rau tib lub zog tsav uas tsis tau?
• nyob rau tib lub computer, uas tau raug nyiag?
• hauv tib lub tsev uas hlawv rau hauv av?

Web Based Backups

Ntxiv dua thiab, ua tus thaub qab tsis tas yuav yog ib qho hauj lwm ua los sis siv sij hawm.

Yog hais tias kev ruaj ntseg tsis yog qhov teeb meem - daim ntawv ua hauj lwm yog ib daim ntawv teev ntawm koj lub DVD - xa koj tus kheej ib daim ntawv siv web xa ntawv kom ib daim qauv nyob rau ntawm cov neeg rau zaub mov puas zoo txaus.

Yog hais tias kev ruaj ntseg yog qhov teeb meem, web cia tseem yog ib qho kev xaiv - albeit nrog ib lub tuam txhab uas tshwj xeeb tshaj plaws nyob rau hauv cov khoom tshaj plaws thiab them tus nqi rau kev ua li ntawd.

Nyob rau hauv cov ntaub ntawv ntawm online spreadsheets, txawm, qhov kev pab cuam tus tswv backup lawv servers - thiab qhov no suav tag nrho cov neeg siv cov ntaub ntawv. Tab sis ua kom muaj kev nyab xeeb, download tau ib daim qauv ntawm cov ntaub ntawv rau koj tus kheej lub computer.

04 ntawm 08

Tsis txhob siv Cov Naj Npawb los ntawm Kem Lub Npe thiab Tsis Txhuam Nrog Chav Nyob nrog Cov Ntaub Ntawv

Siv cov hau lus rau saum toj ntawm txhua kab thiab pib ntawm cov kab lus txheeb xyuas koj cov ntaub ntawv, raws li lawv ua haujlwm xws li kev sib faib yooj yim dua, tiam sis tsis siv cov xov tooj xws li - 2012, 2013, thiab ntxiv rau - ua rau nws.

Raws li muaj nyob rau hauv daim duab saum toj no, kem thiab kem lub npe uas yog cov zauv tsuas yog muab tso rau hauv cov lus teb. Yog tias koj cov qauv muaj xws li:

• AutoSum ,
• AutoMax ,
• AutoAverage .

uas cia li xaiv qhov ntau ntawm cov ntaub ntawv rau qhov kev ua haujlwm qhov kev sib cav .

Feem ntau, cov hauj lwm zoo li no thawj zaug rau txhua tus zauv ntawm qhov chaw lawv nyob thiab tom qab mus rau sab laug rau kab zauv, thiab txhua lub npe uas muaj cov zauv muaj nyob rau hauv cov kev xaiv.

Cov zauv siv los ua cov kab npe muaj peev xwm tseem yuam kev raws li lwm cov ntaub ntawv series yog xaiv los ua ib feem ntawm ib qho kev taw qhia ntau dua li daim ntawv lo.

Cov zauv nyob rau hauv cov ntawv lub hlwb ua cov ntawv nyeem lossis tsim cov ntawv sau ua ntej txhua tus zauv nrog rau kev tshaj tawm (') - xws li' 2012 thiab '2013. Lub cim taw qhia tsis pom hauv cell, tab sis nws hloov tus naj npawb rau cov ntaub ntawv luam tawm.

Khaws Nyob Hauv Lub Npe

Tsis txhob: sau cov txiaj, qhov kub thiab txias, los yog lwm qhov chaw hauv txhua lub xov tooj nrog cov xov tooj.

Yog tias koj ua, muaj caij nyoog zoo uas Excel lossis Google Spreadsheets yuav saib tag nrho koj cov ntaub ntawv ua cov ntawv nyeem.

Xwb, tso cov koog nyob rau hauv cov hau lus saum toj ntawm sab, uas, raws li nws tshwm sim, yuav xyuas kom meej tias cov hau lus tsawg yog cov ntawv nyeem thiab yuav tsis tsim qhov teeb meem uas tau tham saum toj no.

Cov ntawv nyeem rau sab laug, Tooj ntawm sab xis

Txoj kev ceev nrawm los qhia tias koj muaj cov ntawv nyeem lossis cov ntaub ntawv tus xov tooj yog los xyuas cov lus sib dhos ntawm cov ntaub ntawv hauv xovtooj. Los ntawm neej ntawd, cov ntaub ntawv tawm mus ua ke mus rau sab laug hauv Excel thiab Google Spreadsheets thiab cov ntaub ntawv tus lej yog mus raws li txoj cai nyob rau hauv ib lub xovtooj.

Txawm hais tias qhov kev hloov no ua rau nws hloov tau yooj yim, formatting tsis nquag thov kom txog thaum tom qab tag nrho cov ntaub ntawv thiab cov qauv tau nkag, ces qhov ua kom sib haum xeeb yuav muab rau koj thaum ntxov ntawm qhov uas muaj ib yam dab tsi nyob hauv tsab ntawv.

Feem pua ​​thiab Nyiaj Txiaj Ntsim

Txoj kev xyaum zoo tshaj plaws rau kev nkag mus rau tag nrho cov ntaub ntawv rau hauv daim ntawv ua haujlwm yog cia li sau tus lej dawb xwb thiab ces hom xov tooj ntawm tes los tso saib tus xov tooj kom raug - thiab qhov no suav cov feem pua ​​thiab cov nqi nyiaj.

Excel thiab Google Spreadsheets, txawm li cas los, txais cov cim feem pua ​​uas tau muab ntaus rau hauv xov tooj nrog rau tus naj npawb thiab ob qho tib si kuj cim tau ntau cov cim cim, xws li cov cim kos npe ($) los sis cov cim pound (£) yog tias lawv ntaus xov tooj nrog rau cov ntaub ntawv xov tooj, tiam sis lwm cov cim cim, xws li South African Rand (R), yuav raug muab txhais raws li cov ntawv.

Txhawm rau ua kom tsis txhob muaj teeb meem, ua raws li cov lus qhia zoo tshaj plaws saum toj no thiab nkag mus rau qhov nyiaj thiab ces muab tus nqi ntawm tes rau cov nyiaj es tsis yog ntaus cim hauv txiaj cim.

05 ntawm 08

Siv Kev Tshawb Fawb Thiab Lub Npe Ua Ntej Hauv Cov Qauv

Ob qhov references ntawm xov tooj thiab cov npe hu ua yuav tsum siv thiab siv rau hauv cov qauv ua kom nws sai thiab yooj yim kom daim qauv thiab los ntawm kev txuas, tag nrho cov ntawv ua haujlwm, tsis muaj teeb meem thiab mus paub txog.

• Xov tooj ntawm tes yog ib qho ua ke ntawm kem ntawv thiab kab leej hauv xov tooj ntawm tes - xws li A1, B23, thiab W987 - thiab yog siv los txheeb xyuas qhov chaw nyob ntawm daim ntawv ua haujlwm.
• Lub npe los yog lub npe hu ua zoo li lub xov tooj ntawm tes siv rau hauv uas nws yog siv los taw ib lub xovtooj ntawm tes lossis ntau yam ntawm cov kab ntawv hauv daim ntawv ua haujlwm.

Kev Siv Cov Lus Qhia Hauv Cov Qauv

Cov qauv siv hauv Excel ua cov lus teb - xws li sib ntxiv lossis sib rho.

Yog tias cov zauv muaj nyob rau hauv cov qauv - xws li:

= 5 + 3

Txhua zaus uas cov ntaub ntawv hloov-hais rau 7 thiab 6, qhov formula yuav tsum kho thiab tus lej hloov lawm ces lub mis thiaj:

= 7 + 6

Yog tias, qhov ntawd, cov ntaub ntawv muab nkag rau hauv hlwb hauv daim ntawv ua haujlwm, cov xov tooj ntawm tes - lossis ntau lub npe - tuaj yeem siv nyob rau hauv cov qauv ntawm cov zauv.

Yog tias tus naj npawb 5 raug muab nkag rau hauv cell A 1 thiab 3 rau hauv cell A2, lub mis ua:

= A1 + A2

Txhawm rau hloov cov ntaub ntawv, hloov cov ntsiab lus ntawm lub hlwb A1 thiab A2, tab sis cov mis nyob qis qis - Excel yeej hloov cov qauv tawm mis.

Cov nyiaj hauv lub sijhawm thiab kev siv zog yog nce ntxiv yog tias daim ntawv khomob muaj cov qauv ntau dua thiab yog ntau cov qauv siv cov ntaub ntawv tib yam vim cov ntaub ntawv xav tau tsuas yog hloov hauv ib qhov chaw thiab txhua cov qauv uas siv nws yuav raug kho tshiab.

Kev siv xov tooj ntawm tes los yog hu ua ntau hom ntawv tseem ua rau koj daim ntawv ua haujlwm zoo dua qub, vim nws tso cai rau koj los tiv thaiv cov qauv ntawm cov kev hloov ua yuam kev thaum tawm hauv cov ntawv xov xwm uas hloov tau yooj yim.

Qhia Tias Cov Ntaub Ntawv

Lwm cov feature ntawm Excel thiab Google Spreadsheets yog tias lawv tso cai rau koj sau cov xov tooj ntawm tes los yog cov npe ntawm cov npe rau hauv cov qauv uas siv cov ntsiab lus taw qhia - uas yuav tsum tau txhaj rau lub xov tooj ntawm tes mus rau qhov kev siv rau hauv cov mis.

Taw qhia txo cov teeb meem tshwm sim los ntawm kev ntaus hauv xov tooj tsis ncaj ncees los yog tsis ua ntau lub npe.

Siv Kev Ntaus Npe Rau Xaiv Cov Ntaub Ntawv

Muab qhov chaw ntawm cov ntaub ntawv muaj npe muaj peev xwm ua rau nws yooj yim dua los xaiv cov ntaub ntawv thaum nqa hom xaiv los yog kev ua haujlwm ua haujlwm.

Yog hais tias qhov loj ntawm cheeb tsam cov ntaub ntawv hloov, qhov ntau ntawm ib lub npe tau yooj yim raug kho siv lub Npe Tus Neeg Tswj .

06 ntawm 08

Tsis txhob tso cov kaab mob uas muaj cov kab mob tsis zoo

Tom qab siv sij hawm ntau kom tau lawv cov qauv thiab siv cov xov tooj tseeb, ntau tus neeg ua yuam kev tawm hauv cov qauv kev thiam rau qhov yuam kev los yog txhob txwm hloov.

Los ntawm kev muab cov ntaub ntawv hauv hlwb hauv daim ntawv ua haujlwm thiab tom qab ntawd referencing cov ntaub ntawv hauv cov qauv, tso cai rau lub hlwb uas muaj cov qauv uas yuav tsum tau muab xauv thiab, yog tias tsim nyog, lo lus zais tiv thaiv kom zoo rau lawv.

Nyob rau tib lub sijhawm, lub hlwb uas muaj cov ntaub ntawv tuaj yeem tau xauv xauv kom hloov tau yooj yim nkag mus rau hauv thiaj li khaws cov ntawv khom nqi mus txog hnub tim.

Kev tiv thaiv ib daim ntawv los yog cov ntawv ua haujlwm yog ob txoj haujlwm:

1. Xyuas kom tseeb tias cov hlwb tseeb yog xauv lawm
2. Thov kev tiv thaiv ntawv xaiv - thiab yog xav tau, ntxiv ib lo lus zais

07 ntawm 08

Ua Txheeb Koj Cov Ntaub Ntawv

Ua qhov koj cov ntaub ntawv tom qab koj tau ua tiav lawm.

Ua hauj lwm nrog cov ntaub ntawv me me hauv Excel lossis Google Spreadsheets tsis yog ib qho teeb meem feem ntau, tab sis raws li tus lej ntawm cov ntaub ntawv nce ua li qhov nyuaj tsis ua hauj lwm nrog nws zoo.

Cov ntaub ntawv muab faib tau yooj yim dua kom nkag siab thiab tshawb xyuas thiab qee cov zog thiab cov cuab yeej siv, xws li VLOOKUP thiab SUBTOTAL yuav tsum tau muab cov ntaub ntawv txheeb xyuas kom rov qab tau qhov tseeb.

Tsis tas li ntawd, kev faib cov ntaub ntawv nyob rau hauv ntau txoj hau kev yuav ua rau nws yooj yim dua qhov chaw ntshiab uas tsis pom tseeb thaum xub thawj.

Xaiv Cov Ntaub Ntawv Tshaj Tawm

Ua ntej cov ntaub ntawv yuav muab txheeb, Excel xav paub txog ntau ntau yam uas yuav tsum tau txheeb, thiab feem ntau, Excel zoo zoo nkauj thaum xaiv cov chaw ntawm cov ntaub ntawv hais txog - tsuav thaum nws nkag mus,

1. tsis muaj daim ntawv dawb paug los sis txhua tus sab nraud nyob hauv thaj tsam ntawm cov ntaub ntawv muaj feem xyuam;
2. thiab cov kab uas tsis muaj dab tsi thiab txhua kab tawm ntawm cov chaw muaj feem xyuam.

Excel yuav txiav txim siab txawm, txiav txim ncaj ncaj, yog hais tias thaj chaw cov ntaub ntawv muaj npe cov npe thiab cais tawm cov kab no los ntawm cov ntaub ntawv yuav tsum tau txheeb.

Txawm li cas los xij, cia Excel xaiv qhov khwv tau los ua ke yuav muaj kev pheej hmoo - tshwj xeeb yog nrog cov nqi ntawm cov ntaub ntawv uas nyuaj xyuas.

Siv cov npe los xaiv cov ntaub ntawv

Yuav kom ntseeg tau tias cov ntaub ntawv raug xaiv raug xaiv, qhia txog qhov ntau yam ua ntej pib qhov kev hloov.

Yog tias tib qho kev sib txawv ces yuav tsum rov qab ua dua, qhov zoo tshaj plaws yog mus muab nws lub npe.

Yog tias lub npe raug sau rau qhov ntau yam yuav tau muab faib, sau lub npe ntawm Lub Npe Lub Npe , lossis xaiv nws los ntawm cov ntawv sau npe thiab Excel yuav qhia qhov tseeb ntawm ntau cov ntaub ntawv hauv daim ntawv.

Cov kab zauv thiab txhua kab thiab qhov sib txawv

Cov kab zauv thiab txhua kab ntawm cov ntaub ntawv tsis tau tsiv tawm thaum faib, vim li ntawd lawv yuav tsum tau ua tsis tau ua ntej qhov khoob qhov chaw.

Piv txwv, yog hais tias kab 7 yog muab zais, thiab nws yog ib feem ntawm cov ntaub ntawv uas tau muab txheeb tseg, nws yuav nyob twj ywm raws li kab 7 es tsis tau tsiv mus rau nws qhov chaw nyob qhov tseeb ntawm qhov sib txawv.

Tib yam mus rau txhua kab lus. Xaiv qhov ntawm kab yog qhov rov qab ntawm txhua cov ntaub ntawv, tab sis yog tias Kem B yog muab zais ua ntej qhov kev sib txawv, nws yuav nyob raws li Kem B thiab tsis raug kho dua nrog rau txhua kab hauv qhov kev sib txawv sorted.

08 ntawm 08

Tag nrho cov Numbers yuav tsum yog Khw muag khoom noj

Qhov teeb meem: Xyuas kom tag nrho cov zauv muab khaws cia ua zauv. Yog tias cov qhabnias tsis zoo li koj xav tau, kem yuav muaj cov lej khaws tseg rau hauv ntawv thiab tsis yog cov lej. Piv txwv, cov zauv negative uas nqes los ntawm qee lub tshuab los sis tus naj npawb nkag nrog lub hauv paus '(apostrophe) muab khaws cia ua cov ntawv nyeem.

Thaum koj ceev nrooj cov ntaub ntawv nrog cov Zis ZA lossis ZA, tej yam yuav mus tsis yog lawm. Yog tias muaj kab dawb paug los sis tsis muaj dab tsi nyob rau hauv cov ntaub ntawv, ib feem ntawm cov ntaub ntawv yuav muab txheeb, thaum lwm cov ntaub ntawv tsis raug. Xav txog qhov mess koj yuav muaj, yog tias cov npe thiab xov tooj tsis ua ntxiv lawm, lossis yog txiav txim mus rau cov neeg tsis ncaj ncees lawm!

Qhov yooj yim tshaj plaws los xyuas kom meej tias ntau qhov tseeb ntawm cov ntaub ntawv raug xaiv ua ntej kev faib tawm yog muab nws Lub Npe.

Qhov thib ob tias yuav cuam tshuam raws nraim li Excel hom. Yog tias koj muaj ib lub xov tooj ntawm tes xaiv, Excel ncua kev xaiv los xaiv ib thaj tsam (ntau tshaj li nias Ctrl + Ua haujlwm + 8) kheev los ntawm ib lossis ntau kab dawb rau kab thiab kab. Nws mam li kuaj thawj kab hauv qhov xaiv ntau los txiav txim seb nws puas muaj cov ncauj lus qhia los yog tsis.

Qhov no yog qhov chaw sib faib nrog cov cuab yeej toolbar yuav ua tau yooj yim-koj lub taub hau (piv txwv tias koj muaj ib qho) yuav tsum tau ua raws li cov kev cai txwv tsis pub kom Excel pom nws li lub hau. Piv txwv li, yog tias muaj qee lub hlwb dawb nyob hauv lub hau kab, Excel yuav xav tias nws tsis yog lub hau. Ib yam li ntawd, yog hais tias lub hau kab tawm tau zoo ib yam li lwm cov kab hauv cov ntaub ntawv cov ntaub ntawv, ces nws yuav tsis paub txog nws. Zoo li, yog hais tias koj cov ntaub ntawv cov lus muaj cov ntawv nyeem thiab koj lub tsho muaj kab ntawv tsis muaj dab tsi tab sis cov ntawv nyeem, Excel yuav-zoo txhua lub sijhawm-tsis paub txog lub npe kab. (Tus kab zoo nkaus li ib yam li lwm cov ntaub ntawv tawm mus rau Excel.)

Tsuas yog tom qab xaiv qhov ntau thiab txiav txim seb puas muaj ib lub tsho khais yuav Excel ua qhov kev tshawb nrig txuag. Koj zoo siab npaum li cas nrog cov qhab-nees yog nyob ntawm seb Excel puas tau txais ob qhov kev xaiv ntau thiab qhov kev txiav txim siab hauv lub tshooj. Piv txwv li, yog Excel tsis xav tias koj muaj ib lub tsho, thiab koj ua, ces koj lub header yog sorted rau hauv lub cev ntawm cov ntaub ntawv; qhov no feem ntau yog qhov phem tshaj plaws.

Kom paub tseeb tias koj cov ntaub ntawv kom raug pom zoo kom raug, siv Ctrl + Ua haujlwm + 8 shortcut mus saib pom Excel zoo li cas; qhov no yog dab tsi yuav tsum sorted. Yog tias nws tsis haum koj qhov kev xav tau, ces koj yuav tsum hloov cov cim ntawm cov ntaub ntawv hauv koj lub rooj, los sis koj yuav tsum xaiv cov ntaub ntawv ntau yam ua ntej siv qhov kev xaiv khij.

Kom paub meej tias koj lub npe yog pom zoo, siv Ctrl + Shift + 8 shortcut los xaiv cov ntaub ntawv ntau, ces saib thawj kab. Yog hais tias koj lub header muaj hlwb dawb ntawm cov xaiv nyob rau thawj kab los yog thawj kab yog formatted li ob kab, los yog koj muaj ntau tshaj ib header uake xaiv, ces Excel assumes koj muaj tsis muaj header txhua. Txhawm rau kho qhov no, hloov koj lub tshav puam kom paub meej tias nws raug pom zoo los ntawm Excel.

Thaum kawg, tag nrho cov bets yuav tsis ua haujlwm yog tias koj cov ntaub ntawv qhia siv ntau cov kab taub hau. Excel muaj ib lub sijhawm nyuab rau lawv. Koj compound qhov teeb meem thaum koj xav tias nws yuav muaj cov seem ntawm qhov seem hauv qab ntawd; nws tsuas yog ua tsis tau nws cia li. Koj tuaj yeem, tabsis, tsuas yog xaiv tag nrho cov kab uas koj xav kom txheeb ua ntej ua qhov haujlwm. Hauv lwm lo lus, yuav tsum ua ib yam dab tsi uas koj xav tau Excel kom txheeb; tsis txhob cia Excel ua cov kev xav rau koj.
Cov Hnub thiab Cov Caij Nyoog Xws li Cov Ntawv

Yog tias cov ntsiab lus ntawm kev cais raws hnub tsis ua raws li kev xav tau, cov ntaub ntawv nyob hauv kem uas muaj qhov yuam kev tsi muaj hnub los yog sijhawm khaws cia ua cov ntaub ntawv tsis yog cov zauv (hnub thiab lub sijhawm yog cov ntaub ntawv tawm qauv).

Nyob rau hauv daim duab saum toj no, cov ntaub ntawv rau A. Peterson tau sau tseg rau hauv qab ntawm daim ntawv, thaum, raws li cov hnub txais - Lub Kaum Ib Hlis 5, 2014 -, cov ntaub ntawv yuav tsum tau muab tso ua ntej sau tseg rau A. Wilson, uas yog muaj hnub kawg ntawm lub Kaum Ib Hlis 5.

Yog vim li cas rau cov kev xav tau npaj txhij txog yog tias lub sij hawm qiv nyiaj rau A. Peterson tau muab khaws cia ua cov ntawv nyeem, es tsis yog tus lej
Mixed Data thiab Quick Sorts.

Thaum siv txoj kev ceev ceev ntawm cov ntaub ntawv uas muaj cov ntawv nyeem thiab cov ntaub ntawv zauv muaj sib xyaw ua ke, Excel cais cov zauv thiab cov ntaub ntawv cov ntawv cais - tso cov ntaub ntawv nrog cov ntawv sau hauv qab ntawm cov npe ntawm cov npe.

Excel tej zaum kuj muaj xws li cov lus qhia kiag hauv cov qhab nias - txhais lawv li lwm kab ntawv ntawm cov ntaub ntawv tawm tsam dua li cov npe ntawm cov lus teb.
Tsi Ceeb Toom - Tsi Dialog Box

Raws li muaj nyob rau hauv daim duab saum toj no, yog hais tias qhov Kev Ntsuas Sib Thib Siv, txawm yog xaiv rau ntawm ib kem, Excel sau lus ceeb toom koj tias nws tau ntsib cov ntaub ntawv khaws cia ua cov ntawv nyeem thiab muab rau koj xaiv rau:

Tsi txhua yam uas zoo li tus lej raws li tus lej
Muab cov zauv thiab cov zauv khaws cia ua cov ntawv cais

Yog tias koj xaiv qhov kev xaiv thawj zaug, Excel yuav sim muab cov ntaub ntawv tso tawm hauv qhov tseeb qhov chaw ntawm cov qhab nia.

Xaiv qhov kev xaiv thib ob thiab Excel yuav tso cov ntaub ntawv uas muaj cov ntaub ntawv hauv qab ntawm cov txiaj ntsim tau los - raws li nws ua nrog ceev ceev.