Chav Haujlwm Microsoft Office muaj txoj haujlwm tshwj xeeb rau kev tsim cov ntaub ntawv thiab ua haujlwm nrog lawv - Kev nkag mus. Txawm li cas los xij, ntau tus neeg siv nyiam siv daim ntawv thov dua rau cov laj thawj no - Excel. Nws yuav tsum raug sau tseg tias qhov kev pab no muaj txhua yam cuab yeej rau kev tsim cov ntaub ntawv tiav (DB). Thov peb cov neeg no yuav ua tau li cas?
Kev tsim cov txheej txheem
Excel chaw khaws ntaub ntawv yog txheej tsim cov ntaub ntawv faib tawm thoob cov kem thiab kab ntawm ib daim ntawv.
Raws li cov lus siv tshwj xeeb, cov kab sib txuas tau muaj npe "Cov ntaub ntawv"Cov. Txhua nqe nkag muaj cov ntaub ntawv hais txog ib qho khoom siv.
Cov ntawv txhua yog hu ua "teb"Cov. Ib daim teb twg nws muaj ib qho kev txwv cais rau txhua cov ntaub ntawv.
Ntawd yog, lub moj khaum ntawm txhua qhov database hauv Excel yog lub rooj ib txwm muaj.
Kev tsim rooj
Yog li, ua ntej txhua yam, peb yuav tsum tsim lub rooj.
- Peb nkag mus rau hauv cov kab hauv ntej ntawm cov teb (kab ntawv) ntawm lub chaw khaws ntaub ntawv.
- Sau lub npe ntawm cov ntaub ntawv (cov kab) ntawm cov ntawv khaws tseg.
- Peb npaj mus sau cov ntaub ntawv.
- Tom qab cov ntaub ntawv sau lawm, peb tsim cov ntaub ntawv hauv nws ntawm peb qhov kev txiav txim siab (font, ciam teb, sau, xaiv, cov ntawv qhia chaw nyob ze rau lub cell, thiab lwm yam).
Qhov no ua tiav qhov tsim ntawm lub hauv paus ntsiab lus.
Tshooj: Yuav ua li cas ua ib lub rooj hauv Excel
Kev muab cov Ntaub Ntawv Ntaus Npe
Txhawm rau Excel kom pom lub rooj tsis yog raws li ntau ntawm cov hlwb, tab sis, raws li qhov chaw khaws ntaub ntawv, nws yuav tsum tau muab tus cwj pwm tsim nyog.
- Mus rau hauv lub tab "Cov ntaub ntawv".
- Xaiv tag nrho cov ntau yam ntawm lub rooj. Txoj nyem. Hauv cov ntawv qhia zaub mov, nyem rau ntawm lub pob "Muab ib lub npe ...".
- Hauv daim duab teeb "Npe" qhia lub npe uas peb xav tau lub npe rau database. Qhov yuav tsum tau ua ntej yog tias lub npe yuav tsum pib nrog ib tsab ntawv, thiab yuav tsum tsis muaj chaw. Hauv daim duab teeb "Khwv" koj tuaj yeem hloov qhov chaw nyob ntawm cov rooj noj mov, tab sis yog tias koj xaiv nws kom raug, ces koj tsis tas yuav hloov dab tsi ntawm no. Koj tuaj yeem xaiv cov ntsiab lus sau rau hauv ib daim teb cais, tab sis kab lus no yog nyob ntawm yeem. Tom qab txhua qhov hloov pauv tau, nyem rau ntawm lub pob "OK".
- Nyem rau feem khawm Txuag nyob rau sab qaum kev ntawm lub qhov rai lossis ntaus cov cim ntawv luv luv Ctrl + S, txhawm rau txhawm rau khaws cov ntaub ntawv ntawm lub hard drive lossis tshem tawm uas txuas nrog lub PC.
Peb tuaj yeem hais tias tom qab ntawd peb twb muaj ib qho chaw khaws ntaub ntawv pov tseg. Koj tuaj yeem ua haujlwm nrog nws hauv lub xeev raws li tau qhia tam sim no, tab sis ntau lub sijhawm yuav txo qis. Hauv qab no peb yuav tham txog yuav ua li cas thiaj ua tau lub hauv paus ntsiab lus siv tau ntau dua.
Txheeb thiab lim
Ua haujlwm nrog cov chaw khaws ntaub ntawv, ua ntej ntawm txhua yam, muab qhov peev xwm ntawm kev teeb tsa, xaiv thiab xaiv cov ntaub ntawv khaws tseg. Txuas cov haujlwm no rau peb cov ntaub ntawv.
- Peb xaiv cov ntaub ntawv ntawm daim teb uas peb tau npaj. Nyem rau "Xaiv" khawm nyob ntawm lub pob xov ntawm daim tab "Cov ntaub ntawv" hauv lub thawv Txheeb thiab Lim.
Kev xaiv tau tuaj yeem nqa ntawm yuav luag txhua qhov kev ntsuas:
- cov niam ntawv npe;
- Hnub Tim
- tooj thiab lwm yam.
- Hauv lub qhov rai tom ntej uas zoo nkaus li, cov lus nug yuav yog seb tsuas yog siv thaj chaw xaiv rau qhov txheeb los yog nws cia li nthuav nws. Xaiv qhov tsis siv neeg nthuav dav thiab nyem rau ntawm lub pob "Cawv ...".
- Sorting nqis qhov rai qhib. Hauv dab teb Tsi yog qhia lub npe ntawm daim teb uas nws yuav ua tiav.
- Hauv dab teb "Ruam" qhia raws nraim li cas nws yuav ua. Rau DB nws yog qhov zoo tshaj plaws xaiv qhov tsis muaj nuj nqis "Qhov tseem ceeb".
- Hauv dab teb "Order" qhia hauv qhov kev txiav txim uas qhov sorting yuav tau nqa tawm. Txhawm rau cov ntaub ntawv sib txawv, sib txawv tus nqi tau tso tawm hauv lub qhov rai no. Piv txwv li, rau cov ntawv luam cov ntaub ntawv - qhov no yuav yog tus nqi "Los Ntawm A Rau Z" lossis "Los Ntawm Z Rau Ib", thiab rau suav - "Nce" lossis "Nqis".
- Nws yog ib qho tseem ceeb kom paub tseeb tias nyob ib ncig ntawm tus nqi "Kuv cov ntaub ntawv muaj kab sau" muaj ib lub cim ntaus cim. Yog tias nws tsis yog, tom qab ntawd koj yuav tsum tso nws.
Tom qab nkag mus rau txhua qhov tsis tsim nyog, nyem rau ntawm lub pob "OK".
Tom qab ntawd, cov ntaub ntawv nyob hauv lub chaw khaws ntaub ntawv yuav txheeb raws li cov kev teeb tsa tshwj xeeb. Hauv qhov no, peb txheeb los ntawm cov npe ntawm cov neeg ua haujlwm ntawm cov tub ua haujlwm.
- Ib qho ntawm cov khoom siv yooj yim tshaj plaws thaum ua haujlwm hauv ib qho Excel database yog autofilter. Peb xaiv tag nrho cov ntau ntawm cov ntaub ntawv hauv cov ntawv qhia thaiv Txheeb thiab Lim nyem rau ntawm lub pob "Lim".
- Raws li koj tuaj yeem pom, tom qab ntawd nyob rau hauv cov hlwb nrog lub teb cov npe pictograms tshwm sim nyob rau hauv daim ntawv ntawm daim duab peb sab. Peb nyem rau ntawm lub cim ntawm kem uas nws tus nqi peb yuav lim. Hauv qhov rai uas qhib, tsis kos tus nqi uas peb xav zais cov ntaub ntawv nrog. Tom qab xaiv tiav, nyem rau ntawm lub pob "OK".
Raws li koj tuaj yeem pom, tom qab ntawd, cov kab muaj cov nqi ntawm qhov uas peb tau khij qhov tsis raug muab zais ntawm lub rooj.
- Txhawm rau xa rov qab tag nrho cov ntaub ntawv mus rau lub vijtsam, peb nyem rau ntawm lub cim ntawm kem uas tau lim, thiab nyob rau hauv lub qhov rai uas qhib, khij lub thawv rov qab txhua yam khoom. Nyem ntawd tag khawm "OK".
- Txhawm rau kom tshem tawm qhov lim tawm, nyem rau ntawm lub pob "Lim" ntawm daim kab xev
Tshooj: Teeb thiab lim cov ntaub ntawv hauv Excel
Tshawb Fawb
Yog tias muaj cov ntaub ntawv loj, nws yooj yim los tshawb xyuas nws siv cov cuab yeej tshwj xeeb.
- Ua li no, mus rau ntawm lub tab "Tsev" thiab ntawm hlua xov tooj cua nyob rau hauv lub thawv "Editing" nyem rau ntawm lub pob Nrhiav thiab Highlight.
- Ib lub qhov rais qhib qhov twg koj xav tau los teev tus nqi xav tau. Tom qab ntawv, nyem rau ntawm lub pob "Nrhiav tom ntej" lossis Nrhiav Txhua.
- Hauv thawj kis, thawj lub xov tooj ntawm tes uas muaj ib qho nqi teev tshwj xeeb ua kom nquag plias.
Hauv rooj plaub thib ob, tag nrho cov npe ntawm cov hlwb uas muaj tus nqi no yog qhib.
Tshooj: Yuav ua li cas thiaj tshawb hauv Excel
Khov chaw
Thaum tsim cov chaw khaws ntaub ntawv, nws yooj yim los kho cov hlwb nrog cov npe ntawm cov ntawv sau thiab daim teb. Thaum ua haujlwm nrog cov ntaub ntawv loj - qhov no tsuas yog qhov tsim nyog. Txwv tsis pub, koj tas li yuav tsum tau siv sijhawm nyob hauv daim ntawv los saib seb kab twg lossis kab ntawv sib haum mus rau qee tus nqi.
- Xaiv lub cell, thaj chaw nyob rau sab saum toj thiab sab laug ntawm qhov uas koj xav kho. Nws yuav nyob rau tam sim ntawd hauv qab lub taub hau thiab rau sab xis ntawm cov npe ntawm kev nkag.
- Nyob hauv kab "Saib" nyem rau ntawm lub pob "Xauv cheeb tsam"nyob rau hauv pawg pab pawg "Qhov rai"Cov. Hauv daim ntawv teev cia-xaiv, xaiv tus nqi "Xauv cheeb tsam".
Tam sim no cov npe ntawm cov teb thiab cov ntaub ntawv yuav ib txwm ua ntej koj ob lub qhov muag, tsis muaj teeb meem deb npaum li cas koj rub cov ntaub ntawv cov ntaub ntawv.
Tshooj: Yuav ua li cas tus pin thaj tsam hauv Excel
Daim ntawv teev npe cia
Rau qee thaj teb ntawm lub rooj, nws yuav zoo rau npaj cov ntawv teev npe kom cov neeg siv khoom, ntxiv cov ntaub ntawv tshiab, tuaj yeem hais qhia qee yam tshwj xeeb. Qhov no muaj feem xyuam, piv txwv, rau ib qho teb "Paul"Cov. Qhov tseeb, tsuas muaj ob txoj kev xaiv xwb: txiv neej thiab poj niam.
- Tsim ib daim ntawv teev npe ntxiv. Nws yuav yooj yim tshaj plaws los muab nws tso rau lwm daim ntawv. Hauv nws peb qhia cov npe ntawm cov nuj nqis uas yuav tshwm sim hauv daim ntawv teev cia.
- Xaiv cov npe no thiab nyem rau ntawm nws nrog khawm khawm. Hauv cov ntawv qhia zaub mov uas tshwm, xaiv "Muab ib lub npe ...".
- Lub qhov rais twb paub rau peb qhib. Nyob hauv cov teb, peb muab lub npe rau peb ntau, raws li cov xwm txheej tau hais los saud.
- Peb xa rov qab daim ntawv nrog cov ntawv txheeb. Xaiv qhov ntau yam uas cov ntawv teev npe poob qis yuav siv. Mus rau hauv lub tab "Cov ntaub ntawv"Cov. Nyem rau feem khawm Cov Ntaub Ntawv Kev Tshawb Xyuasnyob rau txoj hlua xov hauv lub thawv "Ua haujlwm nrog cov ntaub ntawv".
- Lub qhov rai kev kuaj xyuas kom pom qhov tseem ceeb qhib. Hauv dab teb "Cov ntaub ntawv hom" muab tus tes hloov qhov ua haujlwm SauCov. Hauv dab teb "Los Ntawm" teeb daim paib "=" thiab tam sim ntawd tom qab nws, tsis muaj chaw seem, sau lub npe sau cia, uas peb tau muab nws nce siab me ntsis. Tom qab ntawv, nyem rau ntawm lub pob "OK".
Tam sim no, thaum koj sim nkag mus rau cov ntaub ntawv hauv qhov ntau uas qhov kev txwv ntawd tau teeb tsa, ib daim ntawv teev tshwm uas koj tuaj yeem xaiv ntawm cov teeb tsa pom meej meej.
Yog koj sim sau cov cim lam nyob hauv cov hlwb no, cov lus qhia yuam kev yuav tshwm sim. Koj yuav tsum tau rov qab mus thiab ua qhov kev nkag yog.
Tshooj: Yuav ua li cas thiaj li ua kom poob npe hauv Excel
Tau kawg, Excel tau qis dua nyob rau hauv nws lub peev xwm tshwj xeeb cov kev pab cuam rau kev tsim cov ntaub ntawv. Txawm li cas los xij, nws muaj cov cuab yeej uas feem ntau yuav txaus siab qhov kev xav tau ntawm cov neeg siv uas xav tsim lub database. Muab qhov tseeb tias Excel nta, hauv kev sib piv nrog cov ntawv thov tshwj xeeb, paub rau cov neeg siv zoo tib yam zoo dua, hauv qhov no, kev txhim kho ntawm Microsoft muaj txawm tias muaj qee qhov zoo.
