Saib ntawm cov lus teev qhuav ntawm cov ntxhuav, nws yog ib qho nyuaj thaum xub thawj siab kom ntes cov duab tag nrho lawv sawv cev. Tab sis, hauv Microsoft Excel, nws yog ib qho graphical visualization uas koj tuaj yeem pom cov ntaub ntawv muaj nyob hauv cov ntxhuav. Qhov no tso cai rau koj yooj yim dua thiab sai sai absorb cov lus qhia. Qhov cuab yeej no hu ua conditional formatting. Cia peb xav paub seb yuav siv cov cai hauv kev sib cai hauv Microsoft Excel li cas.
Yooj Yim Zog Cov Qauv Kev Xaiv
Yuav kom tsim tau ib qho chaw ntawm lub cheeb tsam, xaiv qhov chaw no (feem ntau sab), thiab hauv Tsev Tsev, nias rau Cov Cai Tso Cai, uas nyob rau ntawm daim qauv ntawm cov cuab yeej hom cuab yeej.
Tom qab ntawd, daim ntawv ceebtoom tawm cov lus qhia tawm. Muaj peb hom ntsiab lus:
- Histograms;
- Cov nplai;
- Cov cim.
Yuav kom tsim cov cai sib sau ua ke nyob rau hauv daim ntawv ntawm ib qho histogram, xaiv cov kem nrog cov ntaub ntawv, thiab nias rau ntawm cov khoom noj uas tsim nyog. Raws li koj tau pom, muaj ntau hom histograms nrog gradient thiab cov khoom kom tiav los xaiv. Xaiv ib qho uas, hauv koj lub tswv yim, feem ntau zoo sib xws ntawm cov style thiab ntsiab lus ntawm lub rooj.
Raws li koj tau pom, histograms tshwm sim hauv cov hlwb xaiv. Qhov ntau dua cov zauv nyob hauv lub hlwb, qhov ntev ntawm cov histogram. Tsis tas li ntawd, nyob rau hauv versions ntawm Excel 2010, 2013 thiab 2016, nws yog ib qhov ua tau kom pom cov lus pom qhov tseem ceeb hauv cov histogram. Tab sis nyob rau hauv 2007 version tsis muaj xws li tau.
Thaum uas siv cov xim nplaib tsis tiav ntawm ib qho histogram, nws tseem tau xaiv ntau hom ntawm qhov cuab yeej no. Nyob rau hauv cov ntaub ntawv no, raws li txoj cai, tus loj dua tus nqi nyob rau hauv lub cell, qhov ntau saturated xim ntawm lub scale.
Qhov feem ntau nthuav thiab txoj cuab tam ntawm cov txheej txheem kev teeb tsa no yog cim tseg. Nws muaj plaub lub ntsiab ntawm cov cim: cov lus taw qhia, qauv, cov cim thiab cov kev kwv yees. Txhua qhov xaiv tau xaiv los ntawm tus neeg siv yuav xav siv cov cim txawv thaum ntsuas qhov khoom ntawm lub xov tooj. Tag nrho cheeb tsam tau xaiv yog luam los ntawm Excel, thiab tag nrho cov nqi ntawm tes yog muab faib ua feem, raws li cov nqi teev tseg hauv lawv. Ntsuab icons yog siv rau qhov loj tshaj qhov tseem ceeb, qhov tseem ceeb xim rau qhov nruab nrab, thiab qhov tseem ceeb tshaj plaws hauv feem tsawg tshaj plaws yog cim nrog liab icons.
Thaum xaiv cov xib xub, raws li lub cim, ntxiv rau xim tsim, kos npe rau hauv cov lus qhia tseem siv tau. Yog li, lub xub, taw taw, yog siv rau qhov tseem ceeb loj, mus rau sab laug - mus rau nruab nrab, qis - me me. Thaum siv cov duab, qhov tseem ceeb tshaj plaws yog cim nyob ib ncig ntawm, daim duab peb sab yog nruab nrab, qhov rhombus me me.
Cov Kev Cai Txwv Ntawm Tes
Yog vim li cas, txoj cai yog siv, uas tag nrho cov hlwb ntawm cov khoom raug xaiv raug xaiv nrog ib qho xim lossis cim, raws li qhov tseem ceeb nyob hauv lawv. Tiam sis siv cov ntawv qhia zaub mov, uas peb tau hais los saum no, koj tuaj yeem siv lwm cov cai rau kev xaiv.
Nias rau ntawm daim ntawv qhia zaub mov "Cov cai rau xaiv hlwb". Raws li koj tau pom, nws muaj xya txoj cai:
- Ntau ntxiv;
- Tsawg;
- Sib npaug rau;
- Nruab nrab;
- Hnub tim;
- Duplicate qhov tseem ceeb
Xav txog daim ntawv thov ntawm cov kev ua no ntawm tus qauv. Xaiv qhov ntau ntawm cov hlwb, thiab nyem rau ntawm qhov khoom "Tshaj ...".
Lub qhov rais qhib hauv qhov koj yuav tsum teev cov nqi ntau dua li cas tus lej yuav tsum yog qhov tseem ceeb. Qhov no yog ua tiav rau hauv "Hom ntawv uas loj dua." Los ntawm kev ua neej, tus nqi nruab nrab ntawm qhov ntau tau txais ntawm no, tab sis koj tuaj yeem tsim lwm yam, los yog koj tuaj yeem qhia qhov chaw nyob ntawm tus xov tooj ntawm tes uas muaj tus xov tooj no. Qhov kev xaiv tom qab yog tsim rau cov rooj seem ntawm cov txheej txheem, cov ntaub ntawv uas hloov tas li, los yog lub xov tooj ntawm tes uas qhov formula tau thov. Piv txwv li, peb npaj tus nqi rau 20,000.
Hauv daim teb tom ntej, koj yuav tsum txiav txim siab seb cov qe ntshav dawb yuav ua li cas: lub teeb liab liab thiab xim liab tsaus nti (los ntawm kev ua neej); daj sau thiab tsaus daj ntawv; liab ntawv, lwm yam zoo li Tsis tas li, muaj ib hom kev cai.
Thaum koj mus rau qhov khoom no, lub qhov rais qhib uas koj tuaj yeem kho xaiv, yuav luag txhua yam li koj nyiam, los ntawm kev siv ntau hom, sau, thiab ciam xaiv.
Thaum peb tau txiav txim siab txog cov kev cai nyob rau hauv lub qhov rais qhib rau cov kev cai xaiv, nias qhov "OK" khawm.
Raws li koj tau pom, lub hlwb raug xaiv, raws li txoj cai tswjfwm.
Tib lub ntsiab cai tseem ceeb rau qhov tseem ceeb thaum ua raws li cov cai "Tsawg", "Sib Ncaim" thiab "Sib npaug." Tsuas yog nyob rau hauv rooj plaub thawj zaug, lub hlwb raug faib qis dua tus nqi ntawm koj; nyob rau hauv rooj plaub thib ob, lub caij nyoog ntawm tus lej raug teem, lub hlwb uas yuav muab faib; nyob rau hauv rooj plaub thib peb, tus zauv tshwj xeeb yog muab, thiab cov hlwb uas muaj nws yuav raug faib.
Cov ntawv teev lus "Cov ntawv nyeem" muaj cai xaiv rau hom ntawv nyeem ntawv. Hauv txoj cai kev txhim kho qhov rai, koj yuav tsum qhia ib lo lus, ib feem ntawm ib lo lus, los yog cov lus ntawm cov lus, thaum nws pom, lub hlwb coj los ua ke yuav tsum yog qhov tseem ceeb.
Lub hnub txoj cai siv tau rau cov hlwb uas muaj qhov tseem ceeb ntawm hom ntawv hnub tim. Tib lub sij hawm, hauv qhov chaw koj tuaj yeem xaiv xaiv cov hlwb raws li thaum muaj kev tshwm sim tshwm sim los yog yuav tshwm sim: hnub no, nag hmo, tag kis, lub xeem 7 hnub, thiab lwm yam.
Los ntawm kev ua ntawv thov "Txoj cai tseem ceeb", koj tuaj yeem kho xaiv cov hlwb raws li seb cov ntaub ntawv muab tso rau hauv lawv cov yeebyam ib qho ntawm cov txheej xwm: cov ntaub ntawv sib txawv lossis cov ntaub ntawv.
Cov kev cai rau xaiv cov thawj thiab lub xeem qhov tseem ceeb
Tsis tas li ntawd xwb, nyob rau hauv daim ntawv foos ntawm cov ntawv sau tawm muaj lwm yam khoom nthuav - "Cov cai rau xaiv cov thawj thiab lub xeem qhov tseem ceeb." Ntawm no koj tuaj yeem npaj qhov kev xaiv ntawm qhov loj tshaj lossis tsawg tshaj qhov tseem ceeb hauv cov kab kev qe ntshav. Hauv qhov no, koj tuaj yeem siv qhov kev xaiv, ob qho tib si nyob rau ntawm qhov tseem ceeb thiab hauv feem pua. Nws muaj cov kev xaiv hauv qab no, uas tau teev nyob rau hauv cov khoom siv hauv tshuab raj:
- Thawj 10 yam khoom;
- Thawj 10%;
- 10 yam dhau los;
- Lub xeem 10%;
- Saum toj siab nruab nrab;
- Hauv qab nruab nrab.
Tab sis, tom qab koj nias rau ntawm qhov khoom ntawd, koj tuaj yeem hloov txoj cai. Lub qhov rais qhib hauv qhov xaiv hom raug xaiv, thiab tseem, yog xav tau, koj tuaj yeem xaiv lwm ciam. Piv txwv li, yog txhaj rau qhov "Thawj 10 Yam" hauv lub qhov rais qhib, nyob rau hauv "Hom Thawj Lub Cev", hloov tus naj npawb 10 nrog 7. Yog li, tom qab txhaj rau "OK" khawm, tsis yog 10 qhov loj tshaj qhov tseem ceeb yuav tsum tau highlighted, tab sis tsuas yog 7.
Tsim cov cai
Saum toj no, peb tham txog cov cai uas twb tau teev hauv Excel lawm, thiab tus neeg siv tau xaiv ib qho ntawm lawv. Tab sis, ntxiv rau, yog xav tau, tus neeg siv yuav tsim lawv cov cai.
Yuav ua li no, nyob rau hauv qee yam ntawm daim ntawv teev cov cai hauv kev sau ntawv, nyem rau ntawm "Lwm cov cai ..." nyob hauv qab ntawm daim ntawv teev npe. "Los yog, nias rau" Tsim cov cai ... "nyob rau hauv qis dua ntawm cov ntawv qhia zaub mov loj ntawm cov cai.
Ib lub qhov rais qhib qhov twg koj xav tau xaiv ib hom ntawm 6 txoj cai:
- Hom ntawv txhua lub hlwb raws lawv qhov tseem ceeb;
- Format tsuas hlwb uas muaj;
- Hom ntawv tsuas yog thawj qhov thiab qhov kawg;
- Hom ntawv tsuas yog qhov tseem ceeb uas siab dua lossis tsawg tshaj qhov nruab nrab;
- Hom ntawv tshwj xeeb lossis cim qhov tseem ceeb;
- Siv lub mis los txiav txim siab lub hlwb.
Raws li cov hom kev cai, nyob rau sab qis ntawm lub qhov rais koj yuav tsum khi txoj kev hloov hauv kev piav qhia ntawm cov cai, teem qhov tseem ceeb, sib luag thiab lwm qhov tseem ceeb, uas peb tau hais hauv qab no. Tsuas yog nyob rau hauv cov ntaub ntawv no, teem cov kev ntseeg no yuav yoog tau. Nws tseem yog teem, los ntawm kev hloov cov font, ciam teb thiab fills, raws nraim li cas xaiv yuav saib. Tom qab tag nrho cov chaw lawm, koj yuav tau nyem rau ntawm "OK" khawm kom txuag tau qhov hloov.
Kev cai tswj kav
Nyob rau hauv Excel, koj tuaj yeem siv ob peb cov cai rau tib lub hlwb ib zaug, tab sis tsuas yog lub xeem nkag txoj cai yuav tshwm rau ntawm qhov screen. Yuav kom tswj cov kev cai ntawm ntau cov cai txog qee hom qe ntshav, koj yuav tsum xaiv qhov ntau yam, thiab nyob rau hauv cov ntawv qhia zaub mov tseem ceeb ntawm txoj cai yuav tsum mus rau cov lus tswj kev cai.
Lub qhov rais qhib qhov twg tag nrho cov kev cai uas muaj feem xyuam rau feem ntau ntawm cov hlwb raug nthuav tawm. Cov cai yog siv los saum toj mus rau hauv qab, raws li lawv tau teev tseg. Yog li, yog hais tias cov cai tswj ib leeg, ces qhov tseeb tsuas yog qhov nyuam qhuav dhau los ntawm lawv tau muab tso rau ntawm qhov screen.
Yog xav hloov cov cai hauv chaw, muaj cov nyees khawm nyob rau hauv daim ntawv ntawm cov nce taw thiab nqis. Hauv kev txiav txim rau txoj cai yuav tsum tau tso tawm kom pom ntawm qhov screen, koj yuav tsum xaiv qhov ntawd, thiab nias rau ntawm lub pob ntawm daim ntawv qhia txog tus taw taw kom txog thaum txoj cai siv cov kab nyuam qhuav kawg ntawm daim ntawv.
Muaj lwm txoj hau kev. Nws yog ib qho tsim nyog los muab tus zuam hauv kem nrog lub npe "Nres yog tias muaj tseeb" tsis raws li txoj cai peb xav tau. Yog li, kev mus los ntawm cov kev cai los ntawm sab saum toj mus rau hauv qab, qhov kev zov me nyuam yuav nres qhov ncaj hauv txoj cai, nyob ze qhov chaw cim no, thiab yuav tsis poob rau hauv qab, uas txhais tau hais tias txoj cai no yuav raug tua.
Nyob rau hauv tib lub qhov rais muaj cov nyees khawm rau kev tsim thiab hloov txoj cai xaiv. Tom qab txhaj rau cov nyees khawm no, lub qhov rais tsim thiab hloov cov cai yog qhov uas peb tau sib tham saum toj no.
Yuav kom rho tawm txoj cai, koj yuav tsum xaiv qhov ntawd, thiab nyem rau ntawm "Delete rule" khawm.
Tsis tas li ntawd, koj tuaj yeem rho tawm cov cai los ntawm cov ntawv qhia zaub mov tseem ceeb ntawm txoj cai. Ua li no, nyem rau ntawm qhov "Delete rules". Ib tug submenu opens qhov twg koj tuaj yeem xaiv ib qho ntawm cov kev xaiv deletion: xws li rho tawm cov cai ntawm xaiv ntau ntawm cov hlwb, los sis rho tawm tag nrho cov cai uas muaj nyob rau ntawm daim ntawv qhib Excel.
Raws li koj tau pom, conditional formatting yog ib qho cuab tam heev rau kev pom cov ntaub ntawv hauv ib lub rooj. Nrog nws, koj tuaj yeem hloov lub rooj kom cov ntaub ntawv ntawm nws yuav tau assimilated los ntawm tus neeg siv ntawm ib nrais muag. Tsis tas li ntawd, txoj cai yuav tsum muaj cov ntsiab lus zoo dua rau cov ntaub ntawv.
