Microsoft Office Excel yog siv los khaws thiab txheeb xyuas cov ntaub ntawv teeb tsa thiab muaj cov txheej txheem zoo heev rau kev ua haujlwm nrog cov ntaub ntawv. Cov xwm txheej rau kev tshawb nrhiav nyob rau hauv qhov kev pab cuam no tuaj yeem kho nyob rau hauv kev nthuav dav kom tau qhov tseeb tshaj plaws, tab sis cov txheej txheem no tsis xav tau kev qhia tshwj xeeb los ntawm cov neeg siv.
Tsim nyog
Microsoft Office Excel cov ntawv teev lus tshaj tawm
Cov Lus Qhia
Kauj ruam 1
Pib Excel, thau lub rooj rau hauv nws thiab ntawm daim ntawv uas xav tau, muab cov npe nkag rau hauv ib qho ntawm tes ntawm lub rooj. Ntawm "Tsev" tab ntawm daim ntawv teev kev nthuav dav, los ntawm nyem khawm sab xis hauv "Hloov" pab pawg cov lus txib, qhib "Nrhiav thiab xaiv" daim ntawv teev cia. Hauv daim ntawv teev cov lus txib, xaiv cov kab saum toj kawg nkaus - "Nrhiav". Lub qhov rai nrog tshawb nrhiav nqis, uas yuav tshwm sim tawm ntawm lub vijtsam, kuj tseem tuaj yeem hu ua siv "cov yuam sij kub" Ctrl + F
Kauj ruam 2
Hauv kab ntawv Nrhiav, sau cov ntawv nyeem nqi uas koj xav pom nyob hauv lub rooj. Yog tias koj xav hais cov lus tshawb fawb hauv ntau yam, nyem "Xaiv" khawm.
Kauj ruam 3
Qee lub sij hawm koj yuav tsum tshawb rau tus nqi tsuas yog hauv cov hlwb uas muaj qee hom kev ua tshwj xeeb - uas muaj cov xim tshwj xeeb, muaj cov ntawv nyeem tsuas yog, tsuas yog hnub tim, tsuas yog tiv thaiv los ntawm kev hloov pauv, thiab lwm yam. Siv Daim Ntawv Teev Tseg tus qauv nco-txhawm rau taw qhia cov nta.
Kauj ruam 4
Yog tias pom qhov tseem ceeb yuav tsum raws nraim cov ntaub ntawv ntawm daim qauv nkag mus, xaiv lub khij "Match case". Txhawm rau kev tshawb nrhiav qhov tseeb, kos lub thawv "Txhua lub cell", txwv tsis pub muaj nuj nqis yuav pom nyob rau hauv cov qauv tshwj xeeb no tsuas yog kev sib koom ua ke.
Kauj ruam 5
Los ntawm lub neej ntawd, qhov chaw tshawb nrhiav tau txwv rau daim ntawv tam sim no. Yog tias koj xav tau kom nthuav nws mus rau tag nrho cov ntawv, hloov qhov muaj nuj nqi hauv "Saib rau" teb.
Kauj Ruam 6
Cov ncauj lus tshwj xeeb tuaj yeem tshawb ob qho tib si hauv ntu lossis cov qauv, thiab hauv kev sau ntawv rau cov hlwb - xaiv qhov kev xaiv yam xav tau hauv "Tshawb nrhiav cheeb tsam" daim ntawv teev.
Kauj Ruam 7
Teem lub tshawb nrhiav. Los ntawm lub neej ntawd, Excel xyuas los ntawm sab laug mus rau sab xis txhua lub hlwb hauv tib kab, tom qab ntawd txav mus rau kab tom ntej. Yog hais tias hauv qhov teb "Xauj" koj xaiv qhov nqi "los ntawm kab ntawv", tom qab ntawv tshawb yuav tshwm sim los ntawm thawj lub xov tooj ntawm kem mus txog tom kawg, tom qab ntawd cov kab txuas ntxiv yuav raug saib hauv tib qho kev txiav txim.
Kauj ruam 8
Txhawm rau tshawb rau ib tus nqi, nyem lub pob "Nrhiav Txuas Ntxiv", thiab kom pom txhua lub hlwb pom hauv xim, nyem khawm "Nrhiav Txhua Tus".
