Microsoft Excel yog qhov kev pab cuam tsim los ua haujlwm nrog ob-txheej txheem cov ntaub ntawv uas nthuav tawm nyob rau hauv daim ntawv ntawm cov qauv sau. Hauv cov hlwb ntawm cov lus no, cov ntaub ntawv tuaj yeem hais hauv ntau hom: cov lej, cov ntawv nyeem, nyiaj txiag, feem pua, thiab lwm yam, tib lub sijhawm, hloov nws los ntawm ib hom mus rau lwm qhov yooj yim xws li cov tawv plhaub.
Tsim nyog
Daim Ntawv Thov Microsoft Excel
Cov Lus Qhia
Kauj ruam 1
Muaj ntau ntau txoj kev sib txawv los hloov hnub tim rau cov ntawv luam hauv Microsoft Excel daim ntawv nthuav dav.
Qhib cov ntawv uas koj xav tau thiab nrhiav nyob rau hauv nws lub xov tooj ntawm tes uas koj cov ntaub ntawv koj xav tau txhais los ntawm ib hom mus rau lwm hom. Nyem rau nws nrog txoj cai nas khawm thiab hauv cov ntawv qhia zaub mov nco qab nrhiav cov khoom "Hom ntawv". Nyem rau nws. Nyob rau hauv lub qhov rai uas tshwm, qhib "Naj npawb" tab, qhov twg los ntawm "Daim ntawv hom" sau, xaiv cov nqi "Ntawv". Ntawm sab xis ntawm lub qhov rais uas qhib, koj yuav pom tias koj lub hnub tim yuav hloov pauv li cas tom qab ua cov kev ua. Yog tias txhua yam haum koj, nyem OK, yog tias tsis - khawm ncua tseg.
Kauj ruam 2
Qhov txheej txheem thib ob tsis muaj teeb meem ntau dua li qhov dhau los. Raws li txoj cai, nws yog siv nyob rau hauv cov ntaub ntawv thaum nws tsim nyog los hloov hnub hauv lub rooj rau nws hnub ua haujlwm ntawm lub lim tiam.
Thaum pib, koj yuav tsum xaiv cov xov tooj uas xav tau nyob rau hauv cov ntawv uas qhib, cia li nyem rau nws thiab nrhiav yam khoom "Format cells" hauv cov ntawv qhia zaub mov uas tshwm. Tom qab ntawd xaiv qhov "Number" tab thiab hauv kab "Number format" daim npe nyem rau kab "Txhua hom". Tam sim no nyob rau sab xis ntawm lub qhov rais hauv qhov "Hom" teb, nkag mus rau ib ntawm ob kab lus:
dddd (DDDD) - yog tias koj xav tau tus nqi ntawm hnub ntawm lub limtiam yuav muab tso tawm kom pom puv hauv cell;
dd (DDD) - yog tias koj xav tau hnub ntawm lub limtiam ntawd kom tshwm rau hauv daim ntawv sau npe luv.
Txhawm rau kom txuag tau qhov kev hloov pauv tau, nias lub khawm OK, txwv tsis pub - khawm ncua tseg.
Kauj ruam 3
Hloov kev suav hnub suav rau cov ntawv nyeem kuj tseem tuaj yeem ua tau siv TEXT function, uas yog sau raws li hauv qab no:
= TEXT (Xov tooj ntawm tes; "hom ntawv").
Yog li, txhawm rau hloov hnub rau hauv ib hnub ntawm lub lim tiam, txoj haujlwm saum toj no yuav ua daim ntawv:
= NTAWV NYEEM (A1, "DDD").
Kauj ruam 4
Hauv kev tshwm sim uas koj yuav tsum tau hloov pauv hom ntawv ntawm ntau lub hlwb ib zaug, koj tsis tas yuav ua haujlwm nrog txhua tus nyias. Koj yuav tsum xaiv txhua lub hlwb thiab xaiv ib txoj haujlwm saum toj no.
