Qhov kev pabcuam Microsoft Excel muaj lub sijhawm tsis yog los ua haujlwm nrog cov ntaub ntawv hais txog lej, tabsis tseem muaj cov khoom siv los tsim cov duab kos raws li cov qauv nkag. Nyob rau tib lub sijhawm, lawv txoj kev saib pom tuaj yeem sib txawv. Cia peb pom yuav ua li cas kos ntau hom kab kos uas siv Microsoft Excel.
Daim ntawv rooj
Kev tsim ntawm ntau hom duab kos yog xyaum tsis txawv. Tsuas yog nyob rau ntawm qee qib koj yuav tsum xaiv cov hom kev tsim kho kom pom tseeb.
Ua ntej koj pib tsim ib qho qauv duab, koj yuav tsum tsim lub rooj nrog cov ntaub ntawv ntawm lub hauv paus uas nws yuav tsim. Tom qab ntawd, mus rau "Nkag" tab, thiab xaiv thaj chaw ntawm lub rooj no, uas yuav raug hais tawm hauv daim duab.
Ntawm txoj hlua xov hauv "Ntxig" tab, xaiv ib ntawm 6 yam ntawm cov qauv duab:
- Histogram;
- Teem Sijhawm;
- Vajvoog;
- Kav Xwm;
- Nrog thaj chaw;
- Taw tes.
Ntxiv rau, los ntawm txhaj rau "Lwm yam" khawm, koj tuaj yeem xaiv tsawg dua ntawm hom duab kos duab: Tshuag, nto, ntiv nplhaib, npuas, nplaim paj.
Tom qab ntawd, los ntawm txhaj rau ib yam ntawm cov kab kos cov ntawv, nws raug npaj los xaiv cov kev xaiv tshwj xeeb. Piv txwv, rau histogram, lossis daim duab kab kos, cov ntsiab lus hauv qab no yuav yog xws li subspecies: dog dig histogram, volumetric, cylindrical, conical, pyramidal.
Tom qab xaiv cov subspecies tshwj xeeb, ib daim duab tso tawm lawm. Piv txwv li, ib txwm daim ntawv tshuaj histogram yuav zoo li uas tau qhia hauv daim duab hauv qab no.
Daim duab kab teeb duab yuav zoo li no.
Daim duab thaj chaw yuav zoo li no.
Ua haujlwm nrog cov duab kos
Tom qab daim qauv tsim, hauv cov tshiab tab "Ua Haujlwm Nrog Cov Cim" cov cuab yeej ntxiv rau kev kho thiab hloov nws ua kom tiav. Koj tuaj yeem hloov kho hom ntawv hom, nws cov qauv, thiab ntau lwm yam tsis.
Cov "Ua Haujlwm Nrog Daim Ntawv Cim" muaj peb lub sub-ntxiv: "Tsim", "Tsim" thiab "Format".
Txhawm rau npe rau daim duab, mus rau "Layout" tab, thiab xaiv ib qho kev xaiv rau qhov chaw ntawm lub npe: hauv nruab nrab lossis theem saum daim duab.
Tom qab qhov no tiav lawm, cov kab lus npe "Daim Ntawv Npe" tshwm sim. Hloov nws rau cov ntawv sau uas haum rau lub ntsiab lus ntawm cov lus no.
Lub npe axis ntawm daim duab kos npe tau kos npe raws tib txoj hauv kev, tab sis rau qhov no koj yuav tsum nias lub khawm "Axis Names".
Feem pua Qhia Tawm
Txhawm rau txhawm rau qhia qhov feem pua ntawm ntau qhov ntsuas, nws yog qhov zoo tshaj plaws los tsim cov duab qhia lub ncuav.
Hauv txoj kev ib yam li peb tau ua saum toj no, peb tsim lub rooj, thiab tom qab ntawd xaiv cov ntu yam ntawm nws. Tom ntej no, mus rau "Ntxig" tab, xaiv daim duab ncuav qab zib rau ntawm daim xov, thiab tom qab ntawd, hauv cov npe uas tshwm sim, nyem rau txhua yam ntawm daim duab qhia cov ncuav qab zib.
Ntxiv mus, cov phiaj xwm ywj siab coj peb mus rau ib qho ntawm cov tabs rau kev ua haujlwm nrog kab kos - "Tus Qauv Tsim". Ntawm cov kab ntawv qhia hauv cov xov, xaiv ib qho uas muaj cim feem pua.
Daim duab qhia cov ncuav ntawv qhia feem pua ua ntaub ntawv npaj.
Pareto daim duab hluav taws xob
Raws li txoj kev xav ntawm Wilfredo Pareto, 20% kev nqis tes ua tau zoo coj 80% ntawm tag nrho cov txiaj ntsig. Raws li, qhov seem ntxiv 80% ntawm tag nrho cov teeb tsa ntawm kev nqis tes ua tsis tau zoo, nqa tsuas yog 20% ntawm qhov tshwm sim. Kev tsim kho ntawm daim duab Pareto yog tsuas yog tsim los laij cov txiaj ntsig zoo tshaj plaws uas ua rau lub siab tshaj plaws. Peb yuav ua qhov no siv Microsoft Excel.
Nws yog qhov yooj yim tshaj plaws los tsim daim duab Pareto daim duab hauv ib daim ntawv ntawm histogram, uas peb tau hais txog saum toj no.
Piv txwv kev tsim kho. Lub rooj muab cov npe khoom lag luam. Hauv ib kem, kev yuav tus nqi ntawm tag nrho cov ntim ntawm ib qho tshwj xeeb ntawm cov khoom lag luam ntawm cov lag luam wholesale tau nkag mus, thiab hauv qhov ob, tau txais txiaj ntsig los ntawm nws muag. Peb yuav tsum txiav txim siab seb cov khoom lag luam twg muab "rov qab zoo tshaj" ntawm kev muag khoom.
Ua ntej tshaj plaws, peb tab tom tsim ib qho histogram zoo tib yam. Txav mus rau "Ntxig" tab, xaiv tag nrho cov kab ntawm lub rooj muaj nuj nqis, nias lub pob "Histogram", thiab xaiv hom yam xav tau ntawm histogram.
Raws li koj tuaj yeem pom, ua los ntawm cov haujlwm no, ib daim duab tau tsim nrog ob hom kab ntawv: xiav thiab liab.
Tam sim no, peb yuav tsum hloov cov kab liab mus teeb teeb. Txhawm rau ua qhov no, xaiv cov kab ntawv no nrog tus cursor, thiab hauv "Tsim" tab, nyem rau ntawm "Hloov daim duab hom" khawm.
Daim duab hom hloov qhov rai qhib. Mus rau hauv ntu "Daim Ntawv", thiab xaiv cov duab kos uas haum rau peb lub hom phiaj.
Yog li, daim duab Pareto raug txhim tsa. Tam sim no, koj tuaj yeem hloov nws cov kev ua haujlwm (lub npe ntawm cov duab kab thiab axes, cov qauv, thiab lwm yam), ib yam li nws tau piav qhia siv cov piv txwv ntawm daim duab kab kos.
Raws li koj tuaj yeem pom, Microsoft Excel muab ntau yam khoom siv los tsim thiab kho ntau hom duab kos duab. Feem ntau, kev ua haujlwm nrog cov cuab yeej no tau ua kom yooj yim los ntawm cov neeg tsim kho kom cov neeg siv nrog ntau qib kev kawm thiaj tuaj yeem kho lawv.
