Yuav Ua Li Cas Siv Excel (nrog Duab)

Qhov wikiHow qhia koj teeb tsa thiab siv Microsoft Excel ntawm koj lub Windows lossis Mac computer.

Cov kauj ruam

Ntu 1 ntawm 5: Npaj Siv Excel

Kauj Ruam 1. Nruab Microsoft Office yog tias koj tsis muaj nws

Microsoft Excel tsis muaj raws li qhov kev pab cuam ib leeg, tab sis nws tau suav nrog hauv Microsoft Office pob lossis xaj khoom.

Kauj Ruam 2. Qhib daim ntawv Excel uas twb muaj lawm

Yog tias koj xav qhib daim ntawv Excel uas twb muaj lawm txhua lub sijhawm, tsuas yog ob npaug nyem rau ntawm daim ntawv nug. Qhov no yuav nqa cov ntawv hauv lub qhov rai Excel.

Hla cov kauj ruam no yog tias koj xav qhib daim ntawv tshiab hauv Excel

Kauj Ruam 3. Qhib Excel

Nyem lossis ob npaug nyem rau Excel lub cim app, uas zoo ib yam li dawb "X" ntawm qhov tsaus ntuj-ntsuab keeb kwm yav dhau.

Kauj Ruam 4. Xaiv tus qauv yog tias tsim nyog

Yog tias koj xav siv Excel tus qauv (piv txwv li, tus phiaj xwm phiaj xwm peev nyiaj txiag), nqes mus txog thaum koj pom tus qauv koj xav siv thiab tom qab ntawd nyem nws ib zaug los qhib nws lub qhov rais.

Yog tias koj tsuas yog xav qhib daim ntawv tshiab Excel dawb paug, nyem rau Blank kev xaiv nyob rau sab saud sab laug ntawm nplooj ntawv thiab tom qab ntawd hla cov kauj ruam tom ntej.

Kauj Ruam 5. Nyem Tsim

Nws yog sab xis ntawm tus qauv lub npe.

Kauj Ruam 6. Tos kom phau ntawv Excel qhib

Qhov no yuav siv ob peb feeb. Thaum koj pom Excel tus qauv lossis nplooj ntawv dawb, koj tuaj yeem txuas nrog nkag mus rau koj daim ntawv cov ntaub ntawv.

Ntu 2 ntawm 5: Nkag Mus Rau Cov Ntaub Ntawv

Kauj Ruam 1. Paub koj tus kheej nrog cov kab ntawv Excel ribbon

Hauv ntsuab "ribbon" nyob rau sab saud ntawm lub qhov rai Excel, koj yuav pom kab ntawv tab. Txhua ntawm cov tab no tuaj yeem siv nkag mus rau cov cuab yeej Excel sib txawv; cov tseem ceeb koj yuav tsum paub suav nrog cov hauv qab no:

Tsev - Muaj cov kev xaiv rau kev hloov pauv cov ntawv, hloov xim tom qab ntawm tes, thiab ntxiv rau.
Ntxig - Muaj cov kev xaiv rau cov ntxhuav, kab kos, kab, thiab kab zauv.
Nplooj Ntawv Layout - Muaj cov kev xaiv rau nplooj ntawv nplooj ntawv, kev taw qhia, thiab cov ntsiab lus.
Cov mis - Muaj ntau yam kev xaiv ua mis ntxiv rau cov ntawv qhia ua haujlwm.

Kauj Ruam 2. Xav txog kev siv cov kab saum toj kawg nkaus ntawm cov cell rau lub taub hau

Thaum ntxiv cov ntaub ntawv rau hauv daim ntawv teev npe dawb, koj tuaj yeem siv sab saum toj ntawm tes hauv txhua kab ntawv (piv txwv li, A1, B1, C1, thiab lwm yam) raws li koj kab lus kab lus. Qhov no muaj txiaj ntsig thaum tsim cov duab kab lossis cov ntxhuav uas xav tau cov ntawv lo.

Kauj Ruam 3. Xaiv lub cell

Nyem rau ntawm tes uas koj xav nkag mus rau cov ntaub ntawv.

Piv txwv li, yog tias koj tab tom siv daim phiaj npaj phiaj xwm phiaj xwm, koj tuaj yeem nyem thawj lub xov tooj ntawm tes khoob los xaiv nws

Kauj Ruam 4. Sau cov ntawv

Ntaus txhua yam koj xav ntxiv rau ntawm tes.

Kauj Ruam 5. Nias ↵ Enter

Ua li ntawd ntxiv nws rau ntawm tes thiab txav koj qhov kev xaiv mus rau lub cell tom ntej.

Kauj Ruam 6. Kho koj cov ntaub ntawv

Txhawm rau rov qab thiab kho cov ntaub ntawv tom qab, nyem lub xov tooj uas koj xav kho, tom qab ntawv hloov qhov koj xav tau hloov pauv hauv kab ntawv saum toj kab saum toj kawg nkaus ntawm tes.

Kauj Ruam 7. Hom ntawv yog tsim nyog

Yog tias koj xav hloov txoj hauv kev uas cov ntawv xov tooj ntawm tes tau muab tso ua ke (piv txwv li, yog tias koj xav hloov nws los ntawm kev hloov pauv nyiaj mus rau kev hloov hnub tim), nyem rau Tsev tab, nyem rau ntawm lub npov uas nyob rau sab saud ntawm ntu "Tus lej", thiab nyem rau hom kev teeb tsa uas koj xav siv.

Koj kuj tseem tuaj yeem siv cov txheej txheem raws txheej txheem kom ua rau koj lub cell hloov pauv raws qhov xwm txheej hauv daim ntawv nthuav qhia (piv txwv li, yog tias tus lej tus nqi qis dua qee tus lej, lub xov tooj yuav tig liab)

Ntu 3 ntawm 5: Siv Cov Qauv

Kauj Ruam 1. Xaiv lub cell rau koj cov mis

Nyem rau ntawm tes uas koj xav tsim cov mis.

Kauj Ruam 2. Ua haujlwm yooj yim

Koj tuaj yeem ntxiv, rho tawm, faib tawm, thiab ua kom muaj nuj nqis ntawm tes nrog cov qauv hauv qab no:

Ntxiv - Hom = SUM (cell+cell) (piv txwv li,
= SUM (A3+B3) ) ntxiv ob lub cell qhov tseem ceeb ua ke, lossis hom {{kbd | = SUM (cell, cell, cell) (piv txwv li,
= SUM (A2, B2, C2) ) ntxiv cov kab ntawm cov nqi ntawm tes ua ke.
Rho tawm - Hom = SUM (cell -cell) (piv txwv li,
= SUM (A3-B3) ) kom rho tawm ib tus lej ntawm lwm lub cell tus nqi.
Faib - Hom = SUM (cell/cell) (piv txwv li,
= SUM (A6/C5) ) los faib ib lub cell tus nqi los ntawm lwm lub cell tus nqi.
Sib npaug - Hom = SUM (cell*cell) (piv txwv li,
= SUM (A2*A7) ) txhawm rau muab ob qho txiaj ntsig ntawm tes ua ke.

Kauj Ruam 3. Ntxiv tag nrho kab ntawm cov lej

Yog tias koj xav ntxiv txhua tus lej hauv kab ntawv tag nrho (lossis hauv ib seem ntawm kab ntawv), hom = SUM (cell: cell) (piv txwv li,


= SUM (A1: A12)

) rau hauv xovtooj ntawm tes koj xav siv los tso saib qhov tshwm sim.

Kauj Ruam 4. Xaiv lub xovtooj ntawm tes rau cov mis zoo

Txhawm rau siv cov mis ntau dua, koj yuav siv Insert Function tool. Pib los ntawm txhaj lub xovtooj ntawm tes uas koj xav qhia koj cov mis.

Kauj Ruam 5. Nyem Cov Qauv

Nws yog ib lub tab nyob rau sab saum toj ntawm Excel qhov rai.

Kauj Ruam 6. Nyem Insert Function

Qhov kev xaiv no yog nyob rau sab laug sab laug ntawm Cov mis toolbar. Ua li no qhib lub qhov rai.

Kauj Ruam 7. Xaiv txoj haujlwm

Nyem rau hauv lub qhov rai qhov haujlwm koj xav siv, tom qab ntawd nyem OK.

Piv txwv li, txhawm rau xaiv cov mis rau nrhiav qhov tangent ntawm lub kaum ntse ntse, koj yuav nqes mus thiab nyem rau ntawm TAN kev xaiv

Kauj Ruam 8. Sau daim ntawv ua haujlwm

Thaum hais kom sai, ntaus tus lej (lossis xaiv lub cell) uas koj xav siv cov qauv.

Piv txwv li, yog tias koj xaiv lub TAN muaj nuj nqi, koj yuav ntaus tus lej uas koj xav pom qhov tangent.
Nyob ntawm koj qhov kev xaiv uas tau xaiv, koj yuav tsum tau nyem los ntawm ob peb ntawm kev tshuaj ntsuam ntawm qhov screen.

Kauj Ruam 9. Nias ↵ Enter

Ua li ntawd siv koj lub luag haujlwm thiab qhia nws hauv koj lub xov tooj uas koj xaiv.

Ntu 4 ntawm 5: Tsim Kab Lus

Kauj Ruam 1. Teeb cov kab ntawv cov ntaub ntawv

Yog tias koj tab tom tsim kab kab lossis kab duab kab, piv txwv li, koj yuav xav siv ib kab ntawm cov cell rau kab rov tav thiab ib kab ntawm cov cell rau txoj kab ntsug.

Feem ntau hais lus, sab laug yog siv rau kab rov tav thiab kab tam sim rau sab xis ntawm nws sawv cev rau txoj kab ntsug

Kauj ruam 2. Xaiv cov ntaub ntawv

Nyem thiab luag koj tus nas los ntawm sab laug-sab laug ntawm cov ntaub ntawv nqis mus rau hauv qab-txoj cai ntawm tes ntawm cov ntaub ntawv.

Kauj Ruam 3. Nyem Ntxig

Nws yog ib lub tab nyob rau sab saum toj ntawm Excel qhov rai.

Kauj Ruam 4. Nyem Daim Ntawv Pom Zoo

Koj yuav pom qhov kev xaiv no hauv ntu "Charts" ntawm Ntxig toolbar. Ib lub qhov rai nrog cov qauv sib txawv ntawm daim duab yuav tshwm.

Kauj Ruam 5. Xaiv daim qauv duab

Nyem rau kab ntawv qauv koj xav siv.

Kauj Ruam 6. Nyem OK

Nws nyob hauv qab ntawm lub qhov rais. Ua li ntawd tsim koj daim ntawv.

Kauj Ruam 7. Kho koj daim duab lub npe

Nyem ob npaug rau lub npe nyob rau sab saum toj ntawm kab ntawv, tom qab ntawd rho tawm thiab hloov daim duab lub npe tam sim no nrog koj tus kheej lub npe.

Kauj Ruam 8. Hloov koj daim ntawv teev npe axis

Yog tias koj xav ntxiv cov npe axis rau kab ntawv, koj tuaj yeem ua li ntawd los ntawm "Chart Elements" cov ntawv qhia uas tau nkag los ntawm nyem rau ntsuab ＋ mus rau sab xis ntawm daim ntawv xaiv.

Ntu 5 ntawm 5: Txuag Excel Txoj Haujlwm

Kauj Ruam 1. Nyem Cov Ntaub Ntawv

Nws nyob rau sab saud sab laug ntawm lub qhov rais Excel (Windows) lossis lub vijtsam (Mac). Cov ntawv qhia zaub mov yuav tshwm.

Kauj Ruam 2. Nyem Txuag Li

Nov yog nyob rau sab laug ntawm nplooj ntawv yog tias koj siv Windows.

Ntawm Mac, koj yuav nyem qhov no hauv Cov ntaub ntawv nco-down ntawv qhia zaub mov.

Kauj Ruam 3. Nyem ob npaug rau PC no

Nws nyob nruab nrab ntawm nplooj ntawv.

Ntawm Mac, nyem Hauv kuv Mac es tsis txhob

Kauj Ruam 4. Sau lub npe rau koj qhov project

Ntaus txhua yam koj xav sau koj daim ntawv nthuav tawm rau hauv "Cov ntaub ntawv npe" (Windows) lossis "Npe" (Mac) lub npov ntawv hauv Txuag Raws li qhov rai.

Kauj Ruam 5. Xaiv cov ntawv khaws tseg

Nyem rau daim nplaub tshev uas koj xav khaws koj daim ntawv nthuav tawm.

Ntawm Mac, koj yuav tsum xub nyem lub pob "Qhov twg" nco lub thawv ua ntej koj tuaj yeem xaiv cov ntawv

Kauj Ruam 6. Nyem Txuag

Nws nyob hauv qab ntawm lub qhov rais. Ua li ntawd txuag koj daim ntawv nthuav tawm hauv cov ntawv xaiv hauv qab lub npe tshwj xeeb.

Kauj Ruam 7. Txuag kev kho yav tom ntej nrog "Txuag" cov keyboard luv

Yog tias koj tab tom kho daim ntawv Excel yav tom ntej, nias Ctrl+S (Windows) lossis ⌘ Command+S (Mac) yuav txuag koj cov kev hloov pauv rau hauv daim ntawv yam tsis tau nqa lub Save As window.