Microsoft Excel ua rau nws muaj peev xwm tsim tau ntau hom duab piav qhia thiab cov duab kos nyob rau hauv cov ntawv tabular cov ntaub ntawv rau kev pom ntawm cov ntaub ntawv. Piv txwv li, koj tuaj yeem tsim daim phiaj kab ntawv uas yuav ua rau pom kev ua haujlwm ntawm txhua lub chaw haujlwm lossis cov neeg ua haujlwm. Siv daim duab teeb, koj tuaj yeem ua tiav qhov kev tos ntawm ib qho taw qhia ntawm lwm qhov.
Tsim nyog
Excel
Cov Lus Qhia
Kauj ruam 1
Pib Microsoft Excel. Qhib cov ntaub ntawv nrog lub rooj uas koj xav ua keeb kwm. Xaiv qhov ntau ntawm cov nuj nqis uas koj xav tau nyob rau hauv daim chart thiab nyem rau ntawm "Chart Wizard" khawm ntawm toolbar.
Kauj ruam 2
Xaiv cov khoom "Histograms" hauv kab ntawv txheem hauv qhov rai uas tshwm sim ua haujlwm thiab kos tus qauv duab koj xav tau ntawm sab xis ntawm lub qhov rai. Nyem rau tom ntej no. Hauv lub qhov rai thib ob ntawm tus neeg txawj ntse, tshawb xyuas qhov tseeb ntawm cov ntau yam tau xaiv, raws li daim duab uas teeb tsa hauv Excel. Yog tias tsim nyog, hloov nws los ntawm nias lub pob hauv thaj "Range". Nyem Cov Series Series ntxiv cov series ntawm cov nqi, piv txwv li los ntawm lwm qhov chaw ntawm lub rooj.
Kauj ruam 3
Xaiv txhua kab thiab muab nws lub npe. Txhawm rau ua qhov no, hauv "Npe" teb, nyem rau ntawm lub pob thiab xaiv cov phiajcim yuav ua haujlwm raws li lub npe rau tus qauv. Nkag mus rau cov ntawv sau rau X-axis. Yog tias koj xav tau ntxiv los ntawm lub rooj, nyem rau ntawm pob ntawv uas tsim nyog thiab xaiv cov ntaub ntawv xav tau ntau los ntawm lub rooj. Daim ntawv ceeb toom yuav ua li cas saib ua ntej daim duab hloov pauv ntawm lub qhov rais. Nyem "Tom ntej".
Kauj ruam 4
Teeb qhov yuav tsum muaj ntawm cov histogram. Hauv kab "Npe", nkag mus rau hauv cov npe ntawm daim duab nws tus kheej, axis daim ntawv lo. Txav mus rau "Dab Neeg" tab, xaiv nws qhov chaw nyob txheeb ze rau ntawm keeb kwm: hauv qab, sab xis, sab laug. Yog tias tsim nyog, teeb tsa cov ntaub ntawv ntawm cov ntawv sau hauv daim ntawv tsim nyog. Nyem "Tom ntej".
Kauj ruam 5
Xaiv qhov twg tsim ua kab ke bar yuav tsum tau muab tso rau hauv cov kauj ruam tom ntej ntawm lub wizard. Koj tuaj yeem tso nws rau ntawm daim ntawv uas twb muaj lawm, i.e. nyob rau ntawm qhov rooj tib yam. Tso nws rau lwm daim ntawv yog tias tsim nyog. Nyem Rau Finish khawm. Yog tias tsim nyog, koj tuaj yeem hloov cov kev txwv lossis hom qauv ntawm daim duab, kom ua qhov no, nyem ntawm nws thiab xaiv yam khoom uas xav tau. Kev tsim kho ntawm histogram tiav.
