txheem
- Yuav ua li cas los tsim ib daim duab hauv Excel los ntawm lub rooj
- Yuav ua li cas ntxiv cov lus dab neeg rau ib daim ntawv qhia hauv Excel 2010 hauv tus txheej txheem
- Yuav ua li cas hloov cov lus dab neeg ntawm daim duab hauv Excel 2010
- Yuav ua li cas ua kom tiav daim duab
- Lwm txoj hauv kev los hloov daim duab lus dab neeg hauv Excel
- xaus
Hauv Microsoft Office Excel, koj tuaj yeem tsim ib daim ntawv qhia ntawm cov lus sau ua ke kom pom nws cov yam ntxwv tseem ceeb. Nws yog ib qho kev cai ntxiv cov lus dab neeg rau daim duab kos kom pom cov ntaub ntawv piav qhia ntawm nws, muab lawv lub npe. Kab lus no yuav tham txog txoj hauv kev ntxiv cov lus dab neeg rau ib daim ntawv qhia hauv Excel 2010.
Yuav ua li cas los tsim ib daim duab hauv Excel los ntawm lub rooj
Ua ntej koj yuav tsum to taub yuav ua li cas daim duab yog tsim nyob rau hauv qhov kev pab cuam nyob rau hauv nqe lus nug. Cov txheej txheem ntawm nws kev tsim kho yog conditionally muab faib ua cov theem hauv qab no:
- Nyob rau hauv lub ntsiab lus, xaiv qhov xav tau ntau yam ntawm cov hlwb, txhua kab uas koj xav kom tso saib qhov kev vam khom.
- Mus rau "Insert" tab nyob rau sab sauv ntawm cov cuab yeej ntawm cov ntawv qhia zaub mov tseem ceeb ntawm qhov program.
- Hauv "Diagrams" thaiv, nyem rau ntawm ib qho ntawm cov kev xaiv rau cov duab sawv cev ntawm cov array. Piv txwv li, koj tuaj yeem xaiv lub ncuav qab zib lossis daim ntawv qhia bar.
- Tom qab ua tiav cov kauj ruam dhau los, lub qhov rais nrog daim ntawv tsim yuav tsum tshwm nyob ib sab ntawm daim ntawv qub ntawm Excel daim ntawv. Nws yuav muaj kev cuam tshuam txog kev sib raug zoo ntawm cov txiaj ntsig tau xaiv hauv array. Yog li tus neeg siv yuav tuaj yeem pom qhov sib txawv ntawm qhov tseem ceeb, txheeb xyuas cov duab thiab kos cov lus xaus ntawm nws.
Ua tib zoo mloog! Thaum xub thawj, ib daim ntawv "dawb" yuav tsim tsis muaj cov lus dab neeg, cov ntaub ntawv sau npe, thiab cov lus dab neeg. Cov ntaub ntawv no tuaj yeem muab ntxiv rau hauv daim duab yog tias xav tau.
Yuav ua li cas ntxiv cov lus dab neeg rau ib daim ntawv qhia hauv Excel 2010 hauv tus txheej txheem
Qhov no yog txoj kev yooj yim tshaj plaws rau kev ntxiv cov lus dab neeg thiab yuav tsis siv sijhawm ntau rau tus neeg siv los siv. Lub ntsiab ntawm txoj kev yog ua cov kauj ruam hauv qab no:
- Tsim ib daim duab raws li cov qauv saum toj no.
- Nrog rau sab laug nas khawm, nyem rau ntawm tus ntoo khaub lig ntsuab icon nyob rau hauv toolbar rau sab xis ntawm daim ntawv.
- Hauv lub qhov rais ntawm cov kev xaiv muaj uas qhib, tom ntej no mus rau kab "Cov Lus Dab Neeg", kos lub thawv kom qhib lub luag haujlwm.
- Txheeb xyuas daim duab. Cov ntawv sau ntawm cov ntsiab lus los ntawm thawj lub rooj array yuav tsum muab ntxiv rau nws.
- Yog tias tsim nyog, koj tuaj yeem hloov qhov chaw ntawm daim duab. Txhawm rau ua qhov no, nyem rau ntawm sab laug ntawm cov lus dab neeg thiab xaiv lwm qhov kev xaiv rau nws qhov chaw. Piv txwv li, sab laug, hauv qab, saum, sab xis, lossis sab laug.
Yuav ua li cas hloov cov lus dab neeg ntawm daim duab hauv Excel 2010
Cov kab lus dab neeg tuaj yeem hloov pauv yog tias xav tau los ntawm kev teeb tsa qhov tsim nyog font thiab loj. Koj tuaj yeem ua qhov no los ntawm kev ua raws li cov lus qhia hauv qab no:
- Tsim ib daim ntawv qhia thiab ntxiv cov lus dab neeg rau nws raws li algorithm tau tham saum toj no.
- Hloov qhov luaj li cas, font ntawm cov ntawv nyeem nyob rau hauv thawj lub rooj array, nyob rau hauv lub hlwb uas lub graph nws tus kheej yog tsim. Thaum formatting cov ntawv hauv kab lus, cov ntawv hauv kab lus dab neeg yuav hloov pauv.
- Tshawb xyuas qhov tshwm sim.
Tseem ceeb! Hauv Microsoft Office Excel 2010, nws muaj teeb meem los tsim cov lus dab neeg ntawm daim ntawv nws tus kheej. Nws yog qhov yooj yim dua los siv txoj kev txiav txim siab los ntawm kev hloov cov ntaub ntawv ntawm lub rooj array uas cov duab tau tsim.
Yuav ua li cas ua kom tiav daim duab
Ntxiv nrog rau cov lus dab neeg, muaj qee cov ntaub ntawv ntxiv uas tuaj yeem cuam tshuam hauv zaj dab neeg. Piv txwv li, nws lub npe. Txhawm rau sau npe cov khoom tsim, koj yuav tsum ua raws li hauv qab no:
- Tsim ib daim duab raws li daim ntawv qub thiab txav mus rau "Layout" tab nyob rau sab saum toj ntawm cov ntawv qhia zaub mov tseem ceeb ntawm qhov program.
- Daim Ntawv Qhia Cov cuab yeej pane qhib, nrog ntau txoj kev xaiv muaj rau kev kho. Hauv qhov xwm txheej no, tus neeg siv yuav tsum tau nyem rau ntawm "Tswj Npe" khawm.
- Nyob rau hauv cov npe drop-down cov kev xaiv, xaiv hom kev tso npe tso npe. Nws tuaj yeem muab tso rau hauv qhov chaw nrog kev sib tshooj, lossis saum toj ntawm daim ntawv.
- Tom qab ua qhov kev hloov pauv yav dhau los, daim duab kos duab yuav pom cov ntawv sau "Tswj Npe". Tus neeg siv yuav muaj peev xwm hloov nws los ntawm kev ntaus ntawv manually lwm yam kev sib txuas ntawm cov lus los ntawm lub computer keyboard uas phim lub ntsiab lus ntawm thawj lub rooj array.
- Nws tseem ceeb heev uas yuav tau sau cov axes ntawm daim ntawv. Lawv tau kos npe tib yam. Hauv kev thaiv kev ua haujlwm nrog cov kab kos, tus neeg siv yuav tsum tau nyem rau ntawm "Axis Npe" khawm. Hauv daim ntawv teev npe, xaiv ib qho ntawm cov axes: ntsug lossis kab rov tav. Tom ntej no, ua qhov kev hloov tsim nyog rau qhov kev xaiv xaiv.
Cov ntaub ntawv ntxiv! Raws li cov txheej txheem tau tham saum toj no, koj tuaj yeem hloov kho daim ntawv qhia hauv ib qho version ntawm MS Excel. Txawm li cas los xij, nyob ntawm lub xyoo cov software raug tso tawm, cov kauj ruam rau kev teeb tsa cov kab kos yuav txawv me ntsis.
Lwm txoj hauv kev los hloov daim duab lus dab neeg hauv Excel
Koj tuaj yeem hloov kho cov ntawv ntawm cov ntawv sau rau ntawm daim ntawv siv cov cuab yeej tsim rau hauv qhov program. Txhawm rau ua qhov no, koj yuav tsum ua raws li ob peb kauj ruam yooj yim raws li algorithm:
- Nrog txoj cai nas khawm, nyem rau ntawm lo lus xav tau ntawm cov lus dab neeg hauv daim duab tsim.
- Nyob rau hauv cov ntsiab lus teb hom qhov rais, nyem rau ntawm "Filters" kab. Qhov no yuav qhib lub qhov rais Custom Filters.
- Nyem qhov Xaiv Cov Ntaub Ntawv khawm nyob hauv qab ntawm lub qhov rais.
- Hauv cov ntawv qhia zaub mov "Xaiv Cov Ntaub Ntawv" tshiab, koj yuav tsum nyem rau ntawm "Hloov" khawm hauv "Cov Lus Dab Neeg" thaiv.
- Nyob rau hauv lub qhov rais tom ntej no, nyob rau hauv lub "Law npe" teb, sau ib tug txawv lub npe rau lub yav tas los xaiv thiab nyem rau ntawm "OK".
- Tshawb xyuas qhov tshwm sim.
xaus
Yog li, kev tsim kho cov lus dab neeg hauv Microsoft Office Excel 2010 tau muab faib ua ntau theem, txhua qhov yuav tsum tau kawm kom ntxaws. Tsis tas li, yog tias xav tau, cov ntaub ntawv ntawm daim ntawv tuaj yeem hloov kho sai. Cov cai yooj yim rau kev ua haujlwm nrog cov kab kos hauv Excel tau piav qhia saum toj no.