Qhov kev pab cuam MS Excel, txawm tias tsis yog qhov uas ua kom muaj cov ntaub ntawv tseem ceeb, muaj txoj kev dav rau cov neeg tuaj yeem npaj cov xwm txheej raws li cov ntaub ntawv twb muaj lawm. Ib qho yooj yim tshaj plaws, thaum xub thawj siab ib muag, cov hau kev ntawm kev twv ua ntej yog kev tsim kho ntawm txoj kab sib hloov.
Cov Lus Qhia
Kauj ruam 1
Txoj kev yooj yim tshaj plaws yog phiaj xwm qhov kev ua haujlwm tam sim ntawd tom qab nkag mus rau cov ntaub ntawv muaj nyob rau hauv array. Txhawm rau ua qhov no, nyob rau ntawm daim ntawv nrog cov ntaub ntawv cov ntaub ntawv, xaiv tsawg kawg yog ob lub hlwb ntawm qhov ntau rau qhov twg cov duab teeb yuav raug tsim, thiab tam sim ntawd tom qab muab tso rau hauv daim duab. Koj tuaj yeem siv cov kab kos xws li graph, scatter, histogram, npuas, khoom. Lwm hom kab kos tsis txhawb nqa lub tsev qib sib.
Kauj ruam 2
Los ntawm Daim Ntawv Qhia zaub mov, xaiv Ntxiv Kab Kab. Nyob rau hauv lub qhov rai uas qhib, ntawm "Hom" tab, xaiv cov kab uas yuav tsum muaj cov kab, uas nyob rau hauv cov lus hais kuj txhais tau tias cov txheej txheem ntawm cov ntaub ntawv kwv yees. Thaum siv txoj kev piav qhia, koj yuav tsum ua nws "los ntawm qhov muag", vim hais tias koj tsis tau ua kev laij lej laij rau kev npaj phiaj xwm cov duab.
Kauj ruam 3
Yog li tsuas yog xav txog yam twg ntawm kev ua haujlwm zoo tshaj plaws rau lub teeb ntawm cov ntaub ntawv muaj: linear, logarithmic, exponential, exponential, lossis lwm yam. Yog tias koj tsis paub tseeb txog qhov kev xaiv ntawm kwv yees hom, koj tuaj yeem kos ntau kab, thiab kom muaj kev twv ntau dua, ntawm kab "Parameters" ntawm tib lub qhov rais, khij lub thawv "muab kwv yees kwv yees tus nqi (R ^ 2) "nyob rau daim duab.
Kauj ruam 4
Piv rau R ^ 2 qhov tseem ceeb rau cov kab sib txawv, koj tuaj yeem xaiv hom teeb duab uas ua rau koj cov ntaub ntawv muaj tseeb tshaj, thiab, yog li ntawd, tsim cov kev kwv yees uas ntseeg siab tshaj plaws. Qhov ze dua R ^ 2 tus nqi yog rau ib qho, qhov tseeb dua koj tau xaiv hom kab. Ntawm no, ntawm kab lus "Cov Qauv", koj yuav tsum qhia lub sijhawm uas cov kev twv ua.
Kauj ruam 5
Txoj kev tsim txoj hauv kev no yog kwv yees tau zoo heev, yog li nws yog qhov zoo dua los ua tsawg kawg yog qhov kev ua thawj coj ua tau zoo tshaj plaws ntawm cov ntaub ntawv muaj. Qhov no yuav ua rau kev kwv yees muaj tseeb dua.
Kauj Ruam 6
Yog tias koj xav tias cov ntaub ntawv muaj qhia tau los ntawm kab sib npaug, tsuas yog xaiv nws nrog tus cursor thiab sau nws tiav rau qhov xav tau ntawm lub sijhawm, lossis tus lej ntawm lub hlwb. Hauv qhov xwm txheej no, tsis tas yuav nrhiav pom tus nqi R ^ 2, txij li koj tau ua tiav qhov kev kwv yees mus rau kev sib npaug ntawm txoj kab ncaj nraim ua ntej.
Kauj Ruam 7
Yog tias koj xav tias qhov tseem ceeb ntawm qhov sib txawv tuaj yeem qhia tau zoo tshaj plaws uas siv cov kab zauv sab nraud, tseem xaiv cov kab lus ntawm thawj thiab sau cov xov tooj uas yuav tsum muaj ntawm cov hlwb thaum tuav cia lawm nas khawm. Nrog rau daim ntawv sau tiav, koj yuav tsis muaj peev xwm kos lwm hom kab, tsuas yog ob kab taw qhia.
Kauj ruam 8
Yog li no, rau qhov pom tseeb tshaj, koj yuav tsum tau siv ib ntawm ob peb txoj kev ua haujlwm: "FORECAST", "TREND", "GROWTH", "LINEST" lossis "LGRFPRIBL". Hauv qhov no, koj yuav tsum xam tus nqi rau txhua lub sijhawm kwv yees tom ntej ua ke. Yog tias koj xav ua ntau txoj kev txheeb xyuas qhov tseeb ntawm cov ntaub ntawv, koj yuav xav tau "Tshawb Xyuas Pob" ntxiv-rau, uas tsis suav nrog tus qauv MS Office teeb tsa.
