Excel yog qhov kev siv computer siv dav. Nws xav tau rau kev suav, kev teeb duab thiab cov duab kos, suav cov haujlwm yooj yim thiab cov khoom siv nyuaj. Nws yog ib feem ntawm Microsoft Office suite
Excel
Cov chaw thiab qhov ua tau rau kev siv Excel muaj ntau yam:
- Ib daim ntawv Excel yog lub rooj npaj tau, yog li Excel feem ntau siv los tsim cov ntaub ntawv tsis muaj ntau cov kev suav uas muaj cov ntawv nthuav qhia (piv txwv, cov caij nyoog, cov nqi teev hauv khw muag khoom);
- Excel muaj cov kev cai sib txawv ntawm cov duab kos thiab cov duab uas siv cov ntaub ntawv los tsim cov ntxhuav los ntawm cov hlwb (cov duab ntawm cov qauv ntawm qhov muag ntawm lub sijhawm lossis cov duab qhia cov kev faib tawm ntawm cov khoom hauv qee ntu);
- Excel tuaj yeem siv rau hauv cov lus yooj yim hauv tsev lossis tus kheej cov kev xam (khaws cov ntaub ntawv ntawm tus kheej kev siv nyiaj - tau txais / siv nyiaj, kev kwv yees);
- Excel muaj nplua nuj kev ua haujlwm ntawm kev ua lej thiab kev ua haujlwm zoo, yog li ntawd, nws tuaj yeem muaj txiaj ntsig zoo rau cov menyuam kawm ntawv thiab cov tub ntxhais kawm thaum xam hauv cov haujlwm hauv chav kawm, chav ua haujlwm;
- Ua tsaug rau cov lus Askiv ua qhov kev kawm ua tau zoo Visual Basic (macros) hauv Excel, koj tuaj yeem npaj ib daim ntawv thov rau kev sau nyiaj ntawm lub tuam txhab me. Hauv ntau lub tuam txhab, qhov no yog qhov chaw ib puag ncig rau cov ntawv, kev suav thiab tsim cov duab kos. Tsis tas li, Excel twb muaj haujlwm npaj ua tau, thiab vim muaj peev xwm txuas cov neeg thib peb ntxiv, cov haujlwm tau nthuav dav;
- Excel tuaj yeem ua haujlwm zoo li qhov chaw khaws ntaub ntawv. Tab sis qhov haujlwm no tuaj yeem siv tau ntau dua tsuas yog txij li xyoo 2007 version xwb. nyob rau hauv xyoo 2003 version muaj kev txwv ntawm tus naj npawb ntawm cov kab ntawm ib daim ntawv ntawm 65536 (txij xyoo 2007, twb tau me ntsis dhau ib lab). Tab sis cov teeb meem yuav daws tau vim muaj kev sib cuam tshuam yooj yim ntawm Excel nrog MS Access database;
- Excel muaj qhov cuab yeej zoo rau kev tsim cov pivot uas tsis txuas ntxiv hauv ntau yam kev qhia.
Lub hom phiaj ntawm lub ntsiab:
- Cov nplooj ntawv muab cov npe ntawm daim ntawv ua haujlwm tam sim no
- Saib xaiv - hloov ntawm cov ntawv xaiv ua haujlwm xaiv
- Ribbon yog qhov sib cuam tshuam qhov twg cov lus txib thiab cov chaw teeb tsa khawm nyob. Lub pob tw tau muab faib ua cov zajlus kom muaj peev xwm ntawm tab. Piv txwv li, "Saib" tab pab kho lub ntsej muag ntawm cov ntawv ua haujlwm, "Cov Qauv" - cov cuab yeej rau kev ua cov ntawv suav, thiab lwm yam.
- Ntsuas nplai - cov npe hais lus rau nws tus kheej. Peb xaiv qhov sib piv ntawm qhov tseeb loj ntawm daim ntawv thiab nws cov lus tshaj tawm ntawm lub vijtsam.
- Cov Ntaub Ntawv Nkag Nkag Tawm sai sai - ib thaj chaw rau tso cov khoom uas siv feem ntau thiab muaj ploj ntawm cov xov
- Lub npe sau qhia txog qhov ua haujlwm ntawm lub xovtooj xaiv lossis lub npe ntawm xaiv tau
- Seem kab - tso cai rau koj kom muab daim ntawv ua kab rov tav thiab ntsug
- Cov xwm txheej bar qhia qee qhov kev suav nruab nrab, qhia txog kev suav nrog "Num Lock", "Caps Lock", "Scroll Lock"
- Lub thawv tshuaj pub mis yog siv los nkag thiab tso tawm ib qho qauv hauv cov cell nquag. Yog tias muaj tus qauv hauv cov kab no, hauv lub xovtooj ntawm nws tus kheej koj yuav pom qhov tshwm sim ntawm kev xam lossis cov lus yuam kev.
- Tus Cursor Rooj - Qhia txog lub cell uas tseem niaj hnub ua rau hloov cov ntsiab lus
- Kab lej thiab kab ntawv npe - cov teev los ntawm cov chaw nyob hauv xov tooj raug txiav txim siab. Ntawm daim duab, koj tuaj yeem pom tias ntawm tes L17 yog nquag, kab 17 ntawm nplai thiab keeb L yog qhov tseem ceeb hauv cov xim tsaus.
- Cov ntawv txheeb tau pab koj hloov ntawm txhua cov nplooj ntawv ntawm nplooj ntawv
Yuav ua li cas thiaj li kho cov ntawv xov header hauv Excel
Koj tuaj yeem txhim kho lub rooj ntawm cov ntawv qhia hauv Excel siv cov "Freeze Region" cov khoom noj npe ntawm lub pob "Saib". Txhawm rau txhim kho tag nrho cov kab lus ntawm lub rooj, peb yuav tsum xaiv tag nrho cov kab hauv qab cov kab ntawv:
- Nws yog ib qho tsim nyog yuav tsum tau nyem rau ntawm kab ntawv tus naj npawb ntawm kab ntawm nplooj ntawv sab laug ntawm daim ntawv
- Tom qab xaiv kab, koj tuaj yeem mus rau "Freeze Region" cov ntawv qhia zaub mov thiab xaiv cov khoom "Freeze Region".
- Tam sim no cov ntxhuav yuav pom tas li
Txhawm rau kom khov rau thawj kab ntawv nkaus xwb, mus rau ntawm "View menu", nyem qhov "Freeze Areas" khawm, thiab xaiv Freeze First Kem.
