Kev ntsuas qis yuav tuaj yeem pab tau rau kev txheeb xyuas cov ntaub ntawv ntau thiab ua kev kwv yees thiab kev kwv yees. Txhawm rau khiav kev txheeb xyuas qhov hloov pauv hauv Microsoft Excel, ua raws cov lus qhia no.
Cov kauj ruam
Txoj Kev 1 ntawm 2: Ua Kom Ntsuas Kev Ntsuas Ntsuas Ntsuas Tau Zoo Ntawm Koj li Excel
Kauj Ruam 1. Yog tias koj li Excel daim ntawv qhia kab lus (Tsev, Ntxig, Nplooj Ntawv Layout, Cov Qauv …)
- Nyem rau ntawm Office Office khawm nyob rau sab saum toj sab laug ntawm nplooj ntawv thiab mus rau Excel Options.
- Nyem rau Add-Ins ntawm sab laug ntawm nplooj ntawv.
-
Nrhiav Analysis tool pack. Yog tias nws nyob ntawm koj daim ntawv teev npe ua haujlwm ntxiv-ntxiv, koj tau teeb tsa.
Yog tias nws nyob hauv koj daim ntawv teev npe tsis ua haujlwm ntxiv, saib rau hauv qab ntawm lub qhov rais rau cov npe uas nyob ib sab ntawm Tswj, xyuas kom tseeb tias Excel Add-Ins raug xaiv, thiab ntaus Go. Hauv lub qhov rai tom ntej uas tshwm tuaj, nco ntsoov Txheeb xyuas cov cuab yeej tshuaj xyuas pob thiab ntaus OK kom qhib. Cia nws nruab yog tsim nyog
Kauj Ruam 2. Yog tias koj li Excel version qhia txog cov cuab yeej siv ib txwm muaj (Cov Ntaub Ntawv, Kho Kom Zoo Nkauj, Saib, Ntxig …)
- Mus rau Cov Cuab Yeej> Ntxiv-Ins.
-
Nrhiav Analysis tool pack. (Yog tias koj tsis pom nws, nrhiav nws siv Kev Tshawb Nrhiav.)
Yog tias nws nyob hauv Add-Ins Available box, xyuas kom tseeb Cov cuab yeej tshuaj xyuas pob tau tshuaj xyuas thiab ntaus OK kom qhib tau. Cia nws nruab yog tsim nyog
Kauj Ruam 3. Excel rau Mac 2011 thiab siab dua tsis suav nrog cov cuab yeej tsom xam
Koj tsis tuaj yeem ua nws yam tsis muaj qhov sib txawv ntawm software. Qhov no yog los ntawm kev tsim txij li Microsoft tsis nyiam Apple.
Txoj Kev 2 ntawm 2: Khiav Kev Tshawb Fawb Kev Ntsuam Xyuas
Kauj Ruam 1. Sau cov ntaub ntawv rau hauv daim ntawv uas koj tab tom ntsuas
Koj yuav tsum muaj tsawg kawg yog ob kab ntawm cov lej uas yuav sawv cev rau koj cov tswv yim Y ntau thiab koj cov tswv yim X Ntau. Cov tswv yim Y sawv cev rau qhov sib txawv sib txawv thaum cov tswv yim X yog koj qhov kev hloov pauv ywj pheej.
Kauj Ruam 2. Qhib Regression Analysis tool
- Yog tias koj qhov Excel version qhia txog kab, mus rau Cov Ntaub Ntawv, nrhiav ntu Kev Txheeb Xyuas, ntaus Cov Kev Txheeb Xyuas Cov Ntaub Ntawv, thiab xaiv Qhov Tseeb los ntawm cov npe cuab yeej.
- Yog tias koj qhov Excel version qhia txog tsoos toolbar, mus rau Cov Cuab Yeej> Txheeb Xyuas Cov Ntaub Ntawv thiab xaiv Rov Qab los ntawm cov npe cuab yeej.
Kauj Ruam 3. Txheeb xyuas koj cov tswv yim Y Range
Hauv Regression Analysis box, nyem rau hauv Input Y Range lub thawv. Tom qab ntawd, nyem thiab rub koj tus cursor hauv Input Y Range teb los xaiv txhua tus lej koj xav tshuaj xyuas. Koj yuav pom cov qauv uas tau nkag mus rau hauv Chaw Y Range Range.
Kauj Ruam 4. Rov ua dua cov kauj ruam dhau los rau Kev Tshawb Fawb X Range
Kauj Ruam 5. Hloov kho koj li chaw yog xav tau
Xaiv seb puas yuav tso tawm cov ntawv, cov khoom seem, cov av seem, thiab lwm yam los ntawm kev khij lub npov xav tau.
Kauj Ruam 6. Xaiv qhov chaw tso zis yuav tshwm
Koj tuaj yeem xaiv qhov tshwj xeeb tso tawm ntau lossis xa cov ntaub ntawv mus rau phau ntawv ua haujlwm tshiab lossis ntawv ua haujlwm.
Kauj Ruam 7. Nyem OK
Cov ntsiab lus ntawm koj qhov kev tso tawm rov qab yuav tshwm sim qhov twg tau teev tseg.
Qauv Ntsuas Kev Ntsuas
Qauv Ntsuas Kev Ntsuas
Txhawb wikiHow thiab qhib tag nrho cov qauv.
Qauv Ntsuas Kev Ntsuas Rau Lub Tsev Loj
Txhawb wikiHow thiab qhib tag nrho cov qauv.
Qauv Ntsuas Kev Ntsuas Ntshav Siab
Txhawb wikiHow thiab qhib tag nrho cov qauv.