Ntxiv ib daim ntawv tshiab rau koj cov ntaub ntawv Excel
Yog tias koj yog tus neeg siv Excel, Muaj feem yuav yog tias qee lub sijhawm koj yuav tsum tau ntxiv ib daim ntawv tshiab rau koj cov ntaub ntawv. Txawm hais tias koj tab tom ua haujlwm ntawm qhov project loj thiab yuav tsum npaj koj cov ntaub ntawv ntawm cov nplooj ntawv sib txawv, lossis tsuas yog vim koj xav kom muaj ib daim ntawv ntxiv los ua qee qhov kev suav ntxiv.
Hmoov zoo, ntxiv ib daim ntawv tshiab rau koj cov ntaub ntawv Excel Nws yog ib qho txheej txheem yooj yim thiab ceev. Hauv tsab xov xwm no, peb yuav piav qhia txog yuav ua li cas thiaj ua tiav qhov no, tsis hais tus version ntawm Excel koj siv.
Ua ntej peb pib, koj yuav tsum qhib koj cov ntaub ntawv Excel. Thaum koj tau qhib nws, tsuas yog ua raws cov kauj ruam uas peb yuav hais hauv qab no thiab hauv ib lub vib nas this koj yuav muaj ib daim ntawv tshiab muaj los ua haujlwm nrog.
Kauj Ruam 1: Mus rau hauv qab sab laug ntawm koj lub vijtsam Excel, qhov twg koj yuav pom koj daim ntawv tam sim no. Nyob ntawd koj yuav pom cov tabs, txhua tus sawv cev rau ib daim ntawv sib txawv.
Kauj Ruam 2: Right-click nrog tus nas txog ib nrab ntawm cov tabs no thiab cov ntawv qhia zaub mov poob yuav qhib nrog ntau txoj kev xaiv. Hauv cov ntawv qhia zaub mov no, xaiv qhov "Insert".
Kauj Ruam 3: Thaum koj xaiv Insert, submenu yuav tshwm sim nrog ntau txoj kev xaiv yuav ua li cas ntxiv ib daim ntawv tshiab rau koj cov ntaub ntawv Excel. Yog koj xav ntxiv ib daim ntawv khoob, Tsuas xaiv qhov "Worksheets" xaiv thiab ib daim ntawv tshiab yuav raug tsim tawm.
Kauj Ruam 4: Yog tias koj xav tau, thov hu rau peb lub Hoobkas ntxiv ib daim ntawv luam ntawm ib daim ntawv uas twb muaj lawm Hauv koj cov ntaub ntawv, koj tuaj yeem xaiv xaiv qhov "Existing Worksheets" kev xaiv. Ua li ntawd yuav qhib lub qhov rais pop-up qhov twg koj tuaj yeem xaiv daim ntawv koj xav kom duplicate thiab ntxiv ua ib daim ntawv tshiab rau koj cov ntaub ntawv.
Nrog rau cov kauj ruam yooj yim no, koj tuaj yeem ntxiv ib daim ntawv tshiab rau koj cov ntaub ntawv Excel thiab txuas ntxiv ua haujlwm hauv txoj hauv kev zoo dua thiab muaj txiaj ntsig. Tshawb nrhiav cov kev xaiv sib txawv uas Excel muab thiab tshawb pom yuav ua li cas kom tau txais txiaj ntsig zoo tshaj plaws thiab ntau yam cuab yeej no.
1. Kho cov qauv ntaub ntawv Excel ntxiv rau daim ntawv tshiab
Teeb tsa cov qauv ntaub ntawv Excel ntxiv rau daim ntawv tshiab
Cuando necesitas ntxiv ib daim ntawv tshiab rau koj cov ntaub ntawv Excel, nws yog ib qho tseem ceeb kom ntseeg tau tias cov ntaub ntawv qauv raug teeb tsa kom tsim nyog. Qhov no yuav tso cai rau koj los npaj thiab tswj koj cov ntaub ntawv of zoo. Ntawm no peb yuav qhia koj cov kauj ruam tsim nyog los teeb tsa cov qauv ntaub ntawv thiab ntxiv ib daim ntawv tshiab:
Kauj Ruam 1:
Qhib koj cov ntaub ntawv Excel thiab mus rau "Cov Ntaub Ntawv" tab nyob rau sab laug sab laug los ntawm qhov screen. Nyem »Save As» kom txuag tau ib daim ntawv theej ntawm cov ntaub ntawv yog tias koj xav khaws cov ntawv qub.
Kauj Ruam 2:
Thaum koj tau khaws ib daim qauv ntawm cov ntaub ntawv, mus rau "Insert" tab hauv lub cuab yeej Excel. Nyem "Sheet" khawm to ntxiv ib daim ntawv tshiab ntawm qhov chaw tam sim no. Koj tseem tuaj yeem nyem rau ntawm daim ntawv uas twb muaj lawm thiab xaiv "Ntxig" ntxiv ib daim ntawv tshiab ua ntej lossis tom qab cov ntawv xaiv.
Kauj Ruam 3:
Thaum koj tau ntxiv ib daim ntawv tshiab, koj tuaj yeem hloov nws lub npe kom yooj yim txheeb xyuas nws. Tsuas yog nyem rau ntawm daim ntawv tshiab tab thiab xaiv "Rename." Sau lub npe piav qhia thiab nias Enter kom txuag tau qhov hloov pauv.
Tam sim no koj tau teeb tsa Excel cov ntaub ntawv kom raug thiab ntxiv ib daim ntawv tshiab, koj npaj txhij pib sau nws nrog koj cov ntaub ntawv. Nco ntsoov khaws koj cov ntaub ntawv tsis tu ncua kom tsis txhob poob cov ntaub ntawv. Tsis txhob hnov qab tshawb txog cov yam ntxwv sib txawv uas Excel tau muab rau koj thiab tau txais txiaj ntsig zoo tshaj plaws ntawm cov cuab yeej tshaj tawm no!
2. Siv qhov "Insert sheet" xaiv los ntxiv ib daim ntawv tshiab rau koj cov ntaub ntawv
Ntxiv ib daim ntawv tshiab rau koj cov ntaub ntawv Excel
Yog tias koj tab tom ua haujlwm nrog Excel thiab xav tau ntxiv ib daim ntawv tshiab rau koj cov ntaub ntawv kom npaj koj cov ntaub ntawv zoo dua, koj tuaj yeem siv the »Insert Sheet» kev xaiv. Cov txheej txheem no Nws yooj yim heev thiab yuav tso cai rau koj kom muaj chaw ua haujlwm tshiab hauv koj cov ntaub ntawv uas twb muaj lawm. Tom ntej no, peb yuav piav qhia yuav ua li cas kauj ruam yog kauj ruam.
Rau ntxig ib daim ntawv tshiab hauv Excel, koj yuav tsum xub qhib cov ntaub ntawv uas koj xav ntxiv nws. Thaum qhib, mus rau hauv qab ntawm qhov screen, nyob ntawd koj yuav pom cov tabs uas sawv cev rau cov nplooj ntawv uas twb muaj lawm hauv koj cov ntaub ntawv. Txoj cai-nias txhua tab thiab koj yuav pom cov ntawv qhia zaub mov poob. Xaiv qhov kev xaiv Insert Sheet thiab ib daim ntawv tshiab yuav cia li tsim ib sab ntawm daim ntawv koj nyob.
Rau rename daim ntawv tshiabTsuas yog ob npaug nyem rau lub npe qub (xws li "Sheet1" lossis "Sheet1") thiab ntaus lub npe koj xav tau. Ua li no, koj tuaj yeem txheeb xyuas txhua daim ntawv hauv koj cov ntaub ntawv Excel. Nco ntsoov tias koj tuaj yeem rov ua cov txheej txheem no ntau zaus raws li koj xav tau ntxiv tag nrho cov nplooj ntawv ntxiv uas koj xav tau. Tsis muaj kev txwv rau pes tsawg nplooj ntawv koj tuaj yeem muaj hauv Excel cov ntaub ntawv, yog li ua haujlwm ywj pheej thiab teeb tsa koj cov ntaub ntawv hauv txhua txoj kev uas haum rau koj zoo tshaj plaws!
3. Rename daim ntawv tshiab rau lub koom haum zoo dua thiab siv tau yooj yim
Rename daim ntawv tshiab Nws yog ib txoj haujlwm yooj yim thiab muaj txiaj ntsig zoo los tuav lub koom haum zoo dua hauv koj cov ntaub ntawv Excel. Thaum ntxiv ib daim ntawv tshiab, los ntawm default, nws yuav muab lub npe nrov xws li "Sheet1," tab sis nws raug nquahu kom koj muab nws lub npe piav qhia ntau dua uas qhia txog cov ntsiab lus lossis kev ua haujlwm ntawm daim ntawv. Rau hloov npe daim ntawv, tsuas yog nyem rau ntawm nws tab hauv qab ntawm lub qhov rais thiab xaiv "Rename" kev xaiv los ntawm cov ntawv qhia zaub mov nco. Tom qab ntawd, nkag mus rau lub npe sheet tshiab thiab nias "Enter" lossis nyem rau sab nraum lub tab kom paub meej tias cov kev hloov pauv.
Esta práctica de rename daim ntawv yuav tso cai rau koj ib yooj yim siv Thaum koj xav tau nkag mus rau yav tom ntej. Los ntawm kev siv cov npe piav qhia, koj yuav tuaj yeem txheeb xyuas cov ntaub ntawv hauv txhua daim ntawv muaj thiab nrhiav nws yam tsis tas yuav tshuaj xyuas ib qho los ntawm ib qho. Piv txwv li, yog tias koj tab tom ua haujlwm ntawm cov ntaub ntawv muag khoom, koj tuaj yeem muab cov npe xws li "Lub Hlis Muag," "Cov Neeg Siv Khoom," "Cov Khoom," thiab lwm yam. Yog li, koj yuav muaj peev xwm taug qab tau zoo ntawm cov nplooj ntawv sib txawv thiab pom qhov koj xav tau hauv ib lub vib nas this.
Lwm qhov kev xaiv muaj txiaj ntsig yog npaj koj cov ntawv hauv pawg lossis pawg. Piv txwv li, koj tuaj yeem siv cov lus sau ua ntej lossis cov lus tom qab rau pawg cov nplooj ntawv ua ke. Txoj kev no, txhua daim ntawv muag khoom tuaj yeem pib nrog "VEN_", cov neeg siv khoom nrog "CLI_", cov nplooj ntawv khoom nrog "PROD_", thiab lwm yam. Tsis tas li ntawd, koj tuaj yeem siv tab xim kom sib txawv ntawm ntau pawg, muab cov xim tshwj xeeb rau txhua pawg. Qhov no zoo ntawm organización visual Nws yuav tso cai rau koj kom muaj lub ntsiab lus meej ntawm cov qauv ntawm koj cov ntaub ntawv thiab yuav ua kom yooj yim navigation thiab siv nyob rau hauv nws.
4. Txav lossis luam cov ntaub ntawv uas twb muaj lawm rau hauv daim ntawv Excel tshiab
Txhawm rau ntxiv ib daim ntawv tshiab rau koj cov ntaub ntawv Excel, tsuas yog ua raws cov kauj ruam no:
1. Xaiv daim ntawv qhov chaw: Xaiv daim ntawv Excel uas muaj cov ntaub ntawv koj xav txav lossis luam.
2. Xaiv cov ntaub ntawv: Siv koj tus nas thiab nyem rau ntawm lub xovtooj ntawm tes uas muaj cov ntaub ntawv koj xav txav lossis luam yog tias koj xav xaiv ntau lub hlwb, tuav Ctrl tus yuam sij thaum nyem rau ntawm lub hlwb ntxiv.
3. Luam lossis txav cov ntaub ntawv: Thaum koj tau xaiv cov ntaub ntawv, right-click thiab xaiv qhov "Copy" kev xaiv yog tias koj xav kom duplicate cov ntaub ntawv nyob rau hauv daim ntawv tshiab, los yog xaiv qhov "Cut" kev xaiv yog hais tias koj xav txav cov ntaub ntawv mus rau daim ntawv tshiab.
Thaum koj ua tiav cov kauj ruam no, koj yuav ua tau muab cov ntaub ntawv tso rau hauv daim ntawv tshiab. Txhawm rau ua qhov no, tsuas yog nyem rau ntawm qhov chaw ntawm tes ntawm daim ntawv tshiab thiab xaiv qhov "Paste" kev xaiv. saib cov ntaub ntawv tsiv mus rau daim ntawv tshiab. Lawv yuav raug muab tshem tawm ntawm daim ntawv qhov chaw thiab muab tso rau hauv daim ntawv tshiab. Nws yog qhov yooj yim kom ntxiv ib daim ntawv tshiab thiab txav los yog luam cov ntaub ntawv hauv Excel!
5. Tsim cov qauv thiab kho cov ntawv tshiab raws li koj xav tau
Ib qho tseem ceeb tshaj plaws thiab siv tau zoo ntawm Excel yog lub peev xwm los tsim thiab kho cov ntawv nthuav dav rau koj cov kev xav tau tshwj xeeb. Ntxiv ib daim ntawv tshiab rau koj cov ntaub ntawv Excel yog txheej txheem ceev thiab yooj yim uas tuaj yeem txhim kho koj lub peev xwm los npaj thiab tswj cov ntaub ntawv. Ua raws li cov kauj ruam no los teeb tsa cov qauv thiab kho cov ntawv tshiab rau koj nyiam.
Teem hom ntawv: Thaum koj tau ntxiv ib daim ntawv tshiab rau koj cov ntaub ntawv Excel, koj tuaj yeem pib teeb tsa cov qauv tsim nyog rau koj cov ntaub ntawv. Koj tuaj yeem xaiv cov font tshwj xeeb thiab qhov loj me rau cov ntawv nyeem, kho cov ciam teb thiab cov xim ntawm cov hlwb, nrog rau siv cov qauv lej rau cov txiaj ntsig xws li npib lossis feem pua. Nco ntsoov tias Excel muaj ntau hom kev xaiv xaiv, yog li nws tseem ceeb heev rau kev tshawb nrhiav thiab sim nrhiav cov qauv uas haum rau koj cov kev xav tau.
Customize daim ntawv tshiab: Thaum koj tau tsim cov qauv yooj yim, koj tuaj yeem hloov kho qhov tshiab ntxiv Daim ntawv qhia Excel Raws li koj cov kev xav tau tshwj xeeb Koj tuaj yeem ntxiv kev cai headers thiab footers, nrog rau ntxig cov duab lossis cov duab los txhim kho qhov pom kev nthuav qhia ntawm koj cov ntaub ntawv. Koj tuaj yeem kho qhov dav ntawm cov kab thiab qhov siab ntawm cov kab kom ua kom zoo dua qhov chaw muaj nyob ntawm daim ntawv. Nco ntsoov tias tus kheej ntawm daim ntawv yuav txawv nyob ntawm lub hom phiaj thiab cov ntsiab lus ntawm koj cov ntaub ntawv, yog li xav hloov nws raws li koj xav tau.
Utilizar plantillas: Yog tias koj luv luv rau lub sijhawm lossis xav kom zam dhau qhov kev hloov kho ntawm phau ntawv, Excel muaj ntau yam ntawm cov qauv ua ntej uas tuaj yeem pab koj pib sai. Koj tuaj yeem nrhiav templates rau pob nyiaj siv, sijhawm teem sijhawm, khoom muag, thiab ntau ntxiv. Cov qauv tuaj nrog cov qauv tsim ua ntej thiab cov qauv uas tso cai rau koj txuag sijhawm thiab siv zog hauv kev tsim koj daim ntawv nthuav qhia. Tsuas xaiv tus qauv uas haum rau koj cov kev xav tau, kho nws raws li koj nyiam, thiab pib ua haujlwm ntawm koj qhov project Excel kom zoo.
6. Txuag thiab tiv thaiv daim ntawv tshiab kom tsis txhob muaj cov ntaub ntawv poob lossis kev hloov pauv tsis raug
Txuag daim ntawv tshiab
Thaum koj tau ntxiv ib daim ntawv tshiab rau koj cov ntaub ntawv Excel, nws tseem ceeb heev guardarla kom paub meej tsis muaj cov ntaub ntawv ploj lossis kev hloov pauv tsis raug. Ib txoj hauv kev yog siv cov keyboard shortcut Ctrl + S lossis nias lub pob "Txuag" ntawm lub toolbar. Koj tuaj yeem mus rau "Cov Ntaub Ntawv" ntawv qhia zaub mov thiab xaiv "Txuag" lossis "Txuag Raws li" txhawm rau khaws cov ntawv tshiab nrog lub npe tshwj xeeb.
Tiv thaiv daim ntawv tshiab
Txhawm rau zam kev hloov pauv tsis raug rau daim ntawv tshiab, koj tuaj yeem protegerla. Qhov no yog tshwj xeeb tshaj yog muaj txiaj ntsig yog tias koj muaj cov ntaub ntawv rhiab lossis cov qauv tsim ntawm daim ntawv. Txhawm rau tiv thaiv daim ntawv, mus rau "Tshawb xyuas" ntawv qhia zaub mov thiab xaiv "Tshem daim ntawv". Ces koj ua tau teeb tus password los tiv thaiv daim ntawv thiab qhia meej tias yuav ua li cas tso cai rau nws, xws li kho cov hlwb lossis ntxig kab thiab kab.
Ua cov ntawv luam theej tawm
Ntxiv rau kev txuag thiab tiv thaiv daim ntawv tshiab, nws yog ib qho kev coj ua zoo ua cov ntawv luam theej tawm tsis tu ncua kom paub meej kev ruaj ntseg ntawm koj cov ntaub ntawv. Koj tuaj yeem ua qhov no los ntawm kev txuag ib daim qauv ntawm Excel cov ntaub ntawv ntawm ib qho khoom siv sab nraud, xws li hard drive lossis ib qho USB tsav. Koj tseem tuaj yeem siv cov kev pabcuam huab los ua cov ntaub ntawv thaub qab txiav txim. Thaum ua cov thaub qab, nco ntsoov sau npe cov ntaub ntawv kom muaj nuj nqis thiab tswj kom muaj kev sib koom ua ke kom cov ntaub ntawv rov qab yooj yim dua yog tias tsim nyog. Nws yog pom zoo kom ua cov thaub qab tsis tu ncua, tshwj xeeb tshaj yog ua ntej hloov pauv loj rau Excel cov ntaub ntawv.
7. Muab daim ntawv tshiab nrog lwm tus neeg koom tes hauv Excel kom muaj kev sib koom tes zoo
Hauv Excel, nws yog ua tau ntxiv ib daim ntawv tshiab rau koj cov ntaub ntawv uas twb muaj lawm los txhim kho thiab tswj koj cov ntaub ntawv zoo. Thaum koj tau tsim daim ntawv tshiab, nws tseem ceeb heev rau qhia rau lwm tus neeg koom tes los txhawb kev sib koom tes thiab xyuas kom txhua tus neeg tau txais cov ntaub ntawv tshiab. Ua raws li cov kauj ruam no los qhia daim ntawv tshiab hauv Excel:
1. Qhib koj cov ntaub ntawv Excel thiab mus rau hauv qab ntawm lub qhov rais, qhov twg cov ntawv sib txawv tabs nyob. Txoj cai-nias rau ntawm ib qho ntawm cov tab uas twb muaj lawm thiab xaiv qhov "Ntxig" kev xaiv los ntawm cov ntawv qhia zaub mov nco-down Ib qho tshiab, dawb tab yuav tshwm nyob ib sab ntawm lub tab tam sim no.
2. Hloov npe daim ntawv tshiab los ntawm txoj cai-nias ntawm qhov khoob tab thiab xaiv qhov "Rename" xaiv muab nws lub npe piav qhia yooj yim txheeb xyuas nws cov ntsiab lus.
3. Thaum koj tau tsim thiab hloov npe rau daim ntawv tshiab, nws yog lub sijhawm rau qhia rau lwm tus neeg koom tes. Nyem qhov "Cov ntaub ntawv" tab ntawm Excel toolbar thiab xaiv "Qhia" kev xaiv los ntawm cov ntawv qhia zaub mov. Lub qhov rais pop-up yuav tshwm sim qhov twg koj tuaj yeem nkag mus rau email chaw nyob ntawm cov neeg koom tes uas koj xav qhia daim ntawv nrog. Koj tuaj yeem ntxiv ntau qhov chaw nyob sib cais los ntawm commas.
Nco ntsoov tias qhia rau daim ntawv tshiab hauv Excel yog qhov tseem ceeb rau kev sib koom tes zoo. Thaum koj tau faib cov ntawv nrog koj cov neeg koom tes, lawv tuaj yeem nkag mus rau nws thiab hloov pauv. nyob rau lub sijhawm tiag tiag. Qhov no tso cai rau kev ua haujlwm zoo dua thiab kev sib koom tes ntawm kev ua haujlwm, txij li txhua tus neeg yuav tuaj yeem ua haujlwm ntawm tib daim ntawv ib txhij. Tsis tas li ntawd, txhua qhov kev hloov pauv los ntawm cov neeg koom tes yuav tau txais kev cawmdim hauv Excel cov ntaub ntawv, kom tsis txhob poob cov ntaub ntawv tseem ceeb.
8. Ntxiv cov kev sib txuas thiab cov ntaub ntawv xa mus rau daim ntawv tshiab kom yooj yim navigation thiab nkag tau sai
Ntxiv nrog rau kev ntxiv ib daim ntawv tshiab rau koj cov ntaub ntawv Excel, koj tuaj yeem txhim kho kev taw qhia thiab kev nkag tau nrawm los ntawm kev suav nrog cov txuas thiab cov ntaub ntawv siv. Cov ntsiab lus no yuav ua rau nws yooj yim dua los nrhiav thiab hloov pauv ntawm qhov sib txawv ntawm koj cov ntaub ntawv, tso cai rau koj nrhiav cov ntaub ntawv koj xav tau ntau dua. Tom ntej no, peb yuav qhia koj yuav ua li cas ua cov txheej txheem no hauv txoj kev yooj yim thiab siv tau.
Txhawm rau ntxiv qhov txuas lossis siv rau daim ntawv tshiab, ua ntej koj yuav tsum xaiv lub ntawv lossis source ntawm tes uas koj xav tsim qhov txuas. Tom ntej no, mus rau lub tshuab raj bar thiab nyem "Ntxig". Los ntawm qhov ntawd, xaiv qhov "Hyperlink" kev xaiv. Lub qhov rais pop-up yuav qhib uas koj tuaj yeem xaiv seb koj puas xav txuas mus rau qhov chaw uas twb muaj lawm hauv cov ntaub ntawv lossis mus rau nplooj ntawv sab nraud. Yog tias koj xaiv txuas mus rau daim ntawv tshiab, xaiv "Qhov chaw hauv daim ntawv no" thiab xaiv the sheet uas koj xav txuas. Thaum kawg, nyem "OK" thiab qhov txuas yuav raug tsim, coj koj ncaj qha mus rau daim ntawv tshiab thaum koj nyem rau ntawm nws.
Ntxiv nrog rau kev sib txuas, koj tuaj yeem txhim kho navigation los ntawm kev suav nrog cov ntaub ntawv. Ib txoj hauv kev muaj txiaj ntsig los ua qhov no yog los ntawm kev tsim ib lub rooj ntawm cov ntsiab lus. Txhawm rau ua qhov no, xaiv ib lub xovtooj lossis ntau lub xovtooj hauv daim ntawv tshiab thiab mus rau lub tshuab raj bar. Nyem rau ntawm "Insert" thiab xaiv "Table of contents" kev xaiv Ib lub rooj ntawm cov ntsiab lus yuav raug txiav tawm nrog kev sib txuas ncaj qha mus rau qhov sib txawv ntawm koj cov ntaub ntawv. Koj tuaj yeem kho qhov layout thiab style ntawm lub rooj ntawm cov ntsiab lus raws li koj nyiam qhov cuab yeej no tshwj xeeb tshaj yog muaj txiaj ntsig rau cov ntaub ntawv ntev lossis cov ntaub ntawv nrog ntau daim ntawv, vim nws muab cov ntsiab lus thiab tso cai rau kev nkag mus rau txhua ntu.
Hauv luv luv, ntxiv cov kev sib txuas thiab cov ntawv xa mus rau daim ntawv Excel tshiab tuaj yeem ua rau kev taw qhia thiab kev nkag tau sai hauv koj cov ntaub ntawv yooj yim heev. Los ntawm kev suav nrog cov kev sib txuas, koj tuaj yeem dhia ncaj qha los ntawm ib feem ntawm daim ntawv mus rau lwm qhov nrog ib zaug nias. Ib yam li ntawd, los ntawm kev tsim ib lub rooj ntawm cov ntsiab lus, koj tuaj yeem muaj cov ntsiab lus thiab nkag mus sai rau txhua ntu uas cuam tshuam. Cov cuab yeej no yuav tso cai rau koj txuag sijhawm thiab siv zog thaum tshawb nrhiav cov ntaub ntawv hauv koj cov ntaub ntawv Excel.
9. Siv cov qauv thiab kev ua haujlwm hauv daim ntawv tshiab los ua kev suav thiab txheeb xyuas cov ntaub ntawv
Hauv Excel, ib qho tseem ceeb tshaj plaws thiab muaj txiaj ntsig zoo yog muaj peev xwm ntxiv cov ntawv tshiab rau koj cov ntaub ntawv. cov Qhov no tso cai rau koj los npaj thiab txheeb xyuas cov ntaub ntawv zoo dua thiab ua tau zoo.. Txhawm rau ntxiv ib daim ntawv tshiab, tsuas yog ua raws cov kauj ruam yooj yim no. Hauv tab hauv qab ntawm koj cov ntaub ntawv Excel, right-click cov ntawv uas twb muaj lawm thiab xaiv "Insert Sheet."
Thaum koj tau ntxiv ib daim ntawv tshiab rau koj cov ntaub ntawv Excel, koj tuaj yeem pib siv cov qauv thiab kev ua haujlwm los ua kev suav thiab kev txheeb xyuas cov ntaub ntawv. Cov qauv hauv Excel tso cai rau koj los ua cov haujlwm lej yooj yim, xws li ntxiv, rho tawm, sib faib, thiab faib koj tuaj yeem siv ntau yam haujlwm, xws li SUM, AVERAGE, MAX, MIN, thiab ntau ntxiv, ua haujlwm ntau dua. cov kev suav siab heev.
Ntxiv nrog rau cov qauv thiab cov haujlwm yooj yim, Excel tseem muaj ntau yam tshwj xeeb ua haujlwm los ua cov ntaub ntawv txheeb xyuas ntau dua. Koj tuaj yeem siv lookup thiab siv cov haujlwm, xws li VLOOKUP thiab HLOOKUP, txhawm rau nrhiav cov txiaj ntsig tshwj xeeb hauv koj cov ntaub ntawv. Koj tuaj yeem siv cov haujlwm txheeb cais, xws li STDEV, MEAN, thiab CORREL, los xam cov kev ntsuas ntawm lub hauv paus nyiam thiab kev sib raug zoo ntawm cov ntaub ntawv teev. Cov yam ntxwv no thiab ntau lwm tus yog tsim los pab koj txiav txim siab paub thiab tau txais cov ntaub ntawv tseem ceeb los ntawm koj cov ntaub ntawv hauv excel.
10. Ua ib ntus hloov kho thiab hloov kho rau daim ntawv tshiab kom nws muaj feem cuam tshuam thiab raug
Thaum koj siv koj cov ntaub ntawv Excel, koj yuav tsum tau ntxiv ib daim ntawv tshiab los npaj thiab nthuav tawm cov ntaub ntawv ntxiv. Hmoov zoo, cov txheej txheem no tau nrawm thiab yooj yim thaum koj tau tsim koj daim ntawv tshiab, nws yog ib qho tseem ceeb uas yuav tsum tau hloov kho thiab hloov kho tshiab kom nws cuam tshuam thiab raug. Tom ntej no, peb yuav qhia koj yuav ua li cas.
Tsim ib daim ntawv tshiab: Txhawm rau ntxiv ib daim ntawv tshiab rau koj cov ntaub ntawv Excel, tsuas yog nyem rau ntawm daim ntawv uas twb muaj lawm tab thiab xaiv Insert. Tom ntej no, xaiv "Pib" los tsim ib daim ntawv tshiab. Koj tseem tuaj yeem siv cov keyboard shortcut "Shift + F11" kom nrawm nrawm rau daim ntawv tshiab.
Structure daim ntawv tshiab: Thaum koj tau tsim daim ntawv tshiab, nws yog ib qho tseem ceeb rau kev teeb tsa kom zoo Koj tuaj yeem ua qhov no los ntawm kev muab nws lub npe piav qhia thiab formatting cov headers thiab hlwb kom nyeem tau. Tsis tas li ntawd, xav txog kev siv cov ntxhuav los npaj cov ntaub ntawv zoo dua.
Khaws daim ntawv kom raug thiab raug: Txhawm rau kom ntseeg tau tias daim ntawv tshiab tseem muaj feem cuam tshuam thiab raug, nws yog ib qho tseem ceeb uas yuav tsum tau hloov kho thiab hloov kho tsis tu ncua. Qhov no suav nrog kev tshuaj xyuas thiab kho cov ntaub ntawv nkag mus, hloov kho cov qauv lossis cov haujlwm, thiab ntxiv cov ntaub ntawv tshiab thaum tsim nyog. Koj tseem tuaj yeem siv cov kev cai formatting kom pom tseeb qee cov ntaub ntawv lossis siv cov cuab yeej tshuaj ntsuam kom tau txais cov ntaub ntawv ntxaws ntxiv.
Los ntawm kev ua raws li cov kauj ruam no, koj tuaj yeem ntxiv ib daim ntawv tshiab rau koj cov ntaub ntawv Excel thiab ua kom nws muaj feem cuam tshuam thiab raug raws sijhawm Nco ntsoov tias kev hloov kho thiab hloov tshiab ua kom muaj txiaj ntsig ntawm cov ntaub ntawv nthuav tawm thiab txhim kho kev ua haujlwm ntawm koj txoj haujlwm. Tshawb nrhiav Excel cov yam ntxwv kom tau txais txiaj ntsig zoo tshaj ntawm koj cov nplooj ntawv thiab cov ntaub ntawv!
Kuv yog Sebastián Vidal, tus kws kho tshuab computer mob siab rau kev siv tshuab thiab DIY. Tsis tas li ntawd, kuv yog tus tsim tecnobits.com, qhov twg kuv qhia cov lus qhia ua kom siv thev naus laus zis ntau dua thiab nkag siab rau txhua tus.