Qhov wikiHow no qhia koj li cas los tsim koj thawj daim ntawv nthuav tawm hauv Microsoft Excel. Daim ntawv nthuav qhia yog daim ntawv suav nrog kab thiab kab ntawm cov thawv uas tuaj yeem siv los txheeb thiab tswj cov ntaub ntawv. Txhua lub npov tau tsim los kom muaj ib daim ntawm cov ntaub ntawv (piv txwv li tus lej, ntawv, thiab/lossis cov qauv uas xa mus rau lwm lub thawv). Cov ntaub ntawv no tuaj yeem tsim kho, teeb tsa, pom nrog duab, lossis hais hauv lwm cov ntaub ntawv. Thaum koj paub cov hauv paus ntawm daim ntawv nthuav qhia, koj tuaj yeem sim koj cov txuj ci los ntawm kev tsim cov khoom lag luam hauv tsev thiab/lossis pob nyiaj hli. Mus ntsib peb lub tsev qiv ntawv ntawm wikiHow cov lus hais txog Microsoft Excel kom kawm paub ntau ntxiv txog cov haujlwm Excel nyuaj dua.
Kauj ruam
Txoj Kev 1 ntawm 3: Tsim Daim Ntawv Qhia Yooj Yim
Kauj Ruam 1. Qhib Microsoft Excel
Koj tuaj yeem pom nws hauv "Start" menu (Windows) lossis "Applications" folder (MacOS). Lub qhov rai thov qhib thiab nthuav tawm nplooj ntawv uas tso cai rau koj los tsim lossis xaiv ib daim ntawv.
Yog tias koj tsis muaj qhov them nyiaj ntawm Microsoft Office, koj tuaj yeem siv dawb online version ntawm https://www.office.com los tsim cov ntawv nthuav qhia yooj yim. Tsuas yog nkag mus rau koj tus lej Microsoft thiab nyem " Excel "Hauv kab ntawm cov cim uas twb muaj lawm.
Kauj Ruam 2. Nyem Phau Ntawv Tsis Txaus los tsim phau ntawv ua haujlwm tshiab
Phau ntawv ua haujlwm yog lub npe ntawm daim ntawv uas tsim cov ntawv nthuav tawm. Daim ntawv tsis muaj npe hu ua " Ntawv 1 "Yuav raug tsim thiab koj tuaj yeem pom nws ua ib lub tab nyob hauv qab ntawm qhov screen.
Thaum tsim cov ntawv nthuav qhia nyuaj dua, koj tuaj yeem ntxiv daim ntawv tshiab los ntawm txhaj " +"Nyob ib sab ntawm thawj daim ntawv. Siv cov tab nyob hauv qab ntawm qhov screen los hloov ntawm ib daim ntawv mus rau lwm qhov.
Kauj Ruam 3. Ua kom paub cov txheej txheem ntawm daim ntawv nthuav tawm
Thawj qhov koj pom yog daim ntawv nthuav tawm nrog ntau pua lub thawv tau teeb tsa hauv kab ntsug thiab kab rov tav. Qee qhov tseem ceeb koj yuav tsum nco ntsoov los ntawm qhov teeb tsa no yog:
- Txhua kab tau sau nrog cov lej nyob ib sab ntawm daim ntawv, thaum kab ntawv tau sau nrog cov tsiaj ntawv nyob saum toj ntawm daim ntawv.
- Txhua lub npov muaj qhov chaw nyob suav nrog ib kab ntawv, ua raws tus lej kab. Piv txwv li, qhov chaw nyob ntawm lub npov nyob hauv thawj kab ntawv (“A) thiab thawj kab (“1”) yog“A1”. Qhov chaw nyob ntawm lub npov hauv kab "B" thiab kab "3" yog "B3".
Kauj Ruam 4. Sau cov ntaub ntawv
Nyem rau ib lub thawv ib zaug thiab ntaus cov ntaub ntawv tam sim ntawd. Thaum koj ua tiav, nias lub pob Tab kom txav mus rau lub npov tom ntej hauv tib kab, lossis Nkag mus kom txav mus rau lub npov tom ntej hauv tib kab ntawv.
- Nco ntsoov tias thaum koj ntaus cov ntaub ntawv rau hauv lub thawv, cov ntaub ntawv lossis cov ntawv nkag yuav raug muab tso tawm ntawm kab ntawv nyob rau sab saum toj ntawm daim ntawv nthuav qhia. Qhov bar no hu ua formula bar (" Formula Bar ") Thiab muaj txiaj ntsig zoo rau kev nkag mus ntev cov ntaub ntawv thiab/lossis cov qauv.
- Txhawm rau kho lub thawv uas twb muaj cov ntaub ntawv, ob npaug nias rau lub npov kom pom tus cursor. Xwb, nyem lub npov ib zaug thiab hloov pauv ntawm tus lej bar.
-
Kauj Ruam 5. Txheeb xyuas Excel cov haujlwm muaj rau siv ntxiv
Ib qho ntawm Excel cov txiaj ntsig zoo tshaj plaws yog nws lub peev xwm los tshawb nrhiav cov ntaub ntawv thiab ua lej raws cov lej lej. Txhua tus lej uas koj nkag mus muaj qhov ua haujlwm Excel, uas yog, "nqis tes ua" uas koj ua. Cov qauv ib txwm pib nrog cov cim sib npaug ("="), ua raws li lub npe ua haujlwm (piv txwv li "= SUM", "= LOOKUP", lossis "= SIN"). Tom qab ntawd, koj yuav tsum nkag mus rau qhov ntsuas thiab nyob ib puag ncig lawv nrog cov zauv (“()”). Ua raws cov theem no kom paub seb hom haujlwm twg koj tuaj yeem siv hauv Excel:
- Nyem rau tab " Cov mis "Nyob rau sab saum toj ntawm qhov screen. Koj yuav pom ntau lub cim ntawm lub cuab yeej nyob rau sab saum toj ntawm lub qhov rai Excel, hauv lub pane sau tias "Function Library". Thaum koj paub qhov sib txawv ntawm txhua txoj haujlwm, koj tuaj yeem tshawb xyuas lub tsev qiv ntawv ua haujlwm nrog cov cim.
- Nyem lub icon " Ntxig Ua Haujlwm "Uas tseem qhia lub cim" fx ". Lub cim no yog thawj lub cim ntawm lub bar. Lub "Insert Function" vaj huam sib luag yuav qhib thiab koj tuaj yeem tshawb nrhiav qhov xav tau ua haujlwm lossis xauj qhov kev xaiv ua haujlwm los ntawm qeb.
- Xaiv ib qeb los ntawm "Los yog xaiv ib pawg" ntawv qhia zaub mov. Cov pawg tsis raug pom yog "Feem ntau Siv Tsis ntev los no". Piv txwv, txhawm rau saib kev ua lej, koj tuaj yeem xaiv " Lej & Trig ”.
- Nyem qhov ua haujlwm hauv "Xaiv lub luag haujlwm" vaj huam sib luag los tshuaj xyuas nws cov syntax, nrog rau kev piav qhia ntawm txoj haujlwm. Yog xav paub ntxiv txog kev ua haujlwm, nyem " Pab rau txoj haujlwm no ”.
- Nyem " Ncua tseg "Tom qab ua tiav qhov kev ua haujlwm.
- Txhawm rau kawm paub ntau ntxiv txog kev nkag mus rau cov qauv, nyeem kab lus yuav ua li cas ntaus cov qauv hauv Microsoft Excel.
Ua Spreadsheet hauv Excel Kauj Ruam 6 Kauj Ruam 6. Txuag cov ntawv tom qab koj ua tiav kho nws
Txhawm rau khaws cov ntawv, nyem rau " Cov ntaub ntawv "Nyob rau sab saud sab laug ntawm qhov screen thiab xaiv" Txuag As " Koj feem ntau tau txais kev xaiv los khaws cov ntawv rau koj lub khoos phis tawj lossis OneDrive qhov chaw khaws khoom, nyob ntawm qhov version ntawm Excel koj tab tom siv.
Thaum koj nkag siab txog cov hauv paus hauv Excel, nyeem "Cov Khoom Siv Hauv Tsev Los Ntawm Khaub Ncaws" txoj hauv kev los tsim "Cov Khoom Siv Hauv Tsev" kom paub yuav ua li cas tso cov ntaub ntawv saum toj no rau hauv kev coj ua
Txoj Kev 2 ntawm 3: Tsim Cov Khoom Siv Hauv Tsev los ntawm Kos
Ua Spreadsheet hauv Excel Kauj Ruam 1 Kauj Ruam 1. Qhib Microsoft Excel
Koj tuaj yeem pom nws hauv "Start" menu (Windows) lossis "Applications" folder (MacOS). Daim ntawv thov qhib thiab nthuav tawm nplooj ntawv uas tso cai rau koj los tsim lossis xaiv phau ntawv ua haujlwm.
Ua Spreadsheet hauv Excel Kauj Ruam 3 Kauj Ruam 2. Npe lub kem
Kauj Ruam 3. Sau cov npe khoom ntawm txhua kab
Thaum cov kab ntawv tau sau npe, koj tuaj yeem nkag tau yooj yim cov ntaub ntawv rau hauv kab. Txhua yam khoom tau txais nws tus kheej kab, thiab txhua daim ntawv xov xwm tau txais nws lub thawv.
- Piv txwv li, yog tias koj sau Apple HD saib hauv koj qhov chaw ua haujlwm, koj tuaj yeem ntaus HD Monitor hauv "A2" lub thawv (hauv "Cov Khoom") lub thawv, Chaw Ua Haujlwm hauv "B2" lub thawv (hauv kab ntawv "Qhov Chaw"), thiab Apple Xinesmas 30. -inch M9179LL hauv "B3" lub thawv (hauv "Hom/Qauv" kem).
- Hais txog lwm yam khoom hauv kab hauv qab no. Yog tias koj xav rho tawm cov npe hauv ib lub thawv, nyem lub npov ib zaug thiab nias Del.
- Txhawm rau tshem tawm tag nrho kab lossis kab, nyem rau sab xis ntawm kab ntawv lossis kab lej thiab xaiv " Rho tawm ”.
- Tej zaum koj yuav tau sau cov ntawv ntau heev uas nkag mus sau cov kab ntawv nyob ib sab ntawm nws. Kho qhov yuam kev no los ntawm kev hloov kho kem kom haum rau cov ntawv. Muab tus cursor tso rau ntawm kab ntawm kab ntawv (saum kab "1") kom txog thaum tus cursor hloov mus rau ob lub taub hau xub, tom qab ntawd ob npaug nyem rau kab.
Ua Spreadsheet hauv Excel Kauj Ruam 5 Kauj Ruam 4. Hloov kab ntawv kab taub hau rau cov ntawv teev cia
Cia peb hais tias koj teev ntau pua yam khoom hauv tsev, tab sis tsuas yog xav pom dab tsi khaws cia hauv koj qhov chaw ua haujlwm. Nyem"
Kauj ruam 1."Thaum pib ntawm kab" 1 "los xaiv tag nrho cov kab, tom qab ntawd ua raws cov theem no:
- Nyem rau tab " Cov ntaub ntawv "Nyob rau sab saud ntawm Excel qhov rai.
- Nyem " Lim "(Funnel icon) ntawm lub cuab yeej. Cov xub me me yuav tshwm nyob hauv txhua kab ntawv kab ntawv.
- Nyem rau cov ntawv qhia zaub mov nco-down " Qhov chaw "(Hauv lub thawv" B1 ") qhib lub lim ntawv qhia zaub mov.
- Txij li koj tsuas yog xav pom dab tsi hauv chaw ua haujlwm, khij lub npov nyob ib sab ntawm "Chaw Ua Haujlwm" thiab xaiv qhov seem.
- Nyem " OK " Tam sim no, koj tsuas pom cov khoom hauv chav xaiv. Koj tuaj yeem ua cov kauj ruam no ntawm txhua kab ntawv thiab hom ntaub ntawv.
- Txhawm rau tso tawm txhua yam khoom dua, nyem rau cov ntawv qhia zaub mov, zuam "Xaiv Txhua", thiab xaiv " OK "Rov qab txhua qhov nkag.
Ua Spreadsheet hauv Excel Kauj Ruam 6 Kauj Ruam 5. Nyem rau Nplooj Ntawv Layout tab txhawm rau hloov daim ntawv nthuav tawm
Tom qab nkag mus rau cov ntaub ntawv, koj tuaj yeem hloov xim, fonts, thiab kab. Nov yog qee cov lus qhia koj tuaj yeem sim:
- Xaiv lub thawv uas xav tau los ua qauv. Koj tuaj yeem xaiv kab tag nrho los ntawm txhaj rau tus lej, lossis kab ntawv los ntawm nyem rau ntawm tsab ntawv. Nias thiab tuav Ctrl (PC) lossis Cmd (Mac) los xaiv ntau dua ib kab lossis kab ib zaug.
- Nyem " Xim "Hauv" Themes "ntu ntawm lub cuab yeej los saib thiab xaiv cov ntsiab lus xim.
- Nyem cov ntawv qhia zaub mov " Fonts "Los xauj thiab xaiv tus font.
Ua Spreadsheet hauv Excel Kauj Ruam 7 Kauj Ruam 6. Khaws daim ntawv
Thaum ua tiav, koj tuaj yeem txuag daim ntawv nthuav tawm los ntawm txhaj rau cov ntawv qhia zaub mov " Cov ntaub ntawv "Nyob rau sab saud sab laug ntawm qhov screen thiab xaiv" Txuag As ”.
Txoj Kev 3 ntawm 3: Tsim Nyiaj Ib Hlis Nyiaj Txiag los ntawm Tus Qauv
Ua Spreadsheet hauv Excel Kauj Ruam 8 Kauj Ruam 1. Qhib Microsoft Excel
Koj tuaj yeem pom nws hauv "Start" menu (Windows) lossis "Applications" folder (MacOS). Daim ntawv thov qhib thiab nthuav tawm nplooj ntawv uas tso cai rau koj los tsim lossis xaiv phau ntawv ua haujlwm.
Txoj hauv kev no suav nrog siv Excel tus qauv tsim los tsim cov npe khoom siv. Muaj ntau pua tus qauv muaj rau ntau hom ntawv nthuav tawm. Txhawm rau pom cov npe ntawm txhua tus qauv Excel ua haujlwm, mus ntsib
Ua Spreadsheet hauv Excel Kauj Ruam 9 Kauj Ruam 2. Saib rau “Cov Nyiaj Tau Los Ib Hlis yooj yim”
Qhov kev xaiv no yog daim ntawv tso cai Microsoft dawb uas ua rau nws yooj yim rau koj los suav koj cov peev nyiaj txhua hli. Koj tuaj yeem tshawb nrhiav nws los ntawm kev ntaus pob yooj yim Ib Hlis Nyiaj hauv kab tshawb fawb nyob rau sab saum toj ntawm lub qhov rais Excel thiab nyem Enter (siv rau feem ntau ntawm Excel version).
Ua Spreadsheet hauv Excel Kauj Ruam 10 Kauj Ruam 3. Xaiv tus qauv "Cov Nyiaj Tau Los Ib Hlis yooj yim" thiab nyem Tsim
Ib daim ntawv nthuav tawm tshiab yuav raug tsim los ntawm cov qauv uas tau xaiv.
Tej zaum koj yuav tsum nyem " Rub tawm ”.
Ua Spreadsheet hauv Excel Kauj Ruam 11 Kauj Ruam 4. Nyem rau Tab Cov Nyiaj Tau Los Ib Hlis los ntaus cov nyiaj tau los
Koj tuaj yeem pom peb tabs (" Ntsiab lus "[txoj kev]," Cov Nyiaj Tau Los Ib Hlis "[Nyiaj tau los txhua hli], thiab" Cov Nqi Txhua Hli "[Kev siv nyiaj txhua hli]) hauv qab ntawm phau ntawv ua haujlwm. Nyem rau tab thib ob. Cia peb hais tias koj khwv tau nyiaj los ntawm ob lub tuam txhab, wikiHow thiab Acme:
- Ob npaug nias lub npov " Cov nyiaj tau los 1 "(Thawj nkag) los tso tus cursor. Tshem lub thawv thiab ntaus hauv wikiHow.
- Ob npaug nias lub npov " Cov nyiaj tau los 2 "(Nkag thib ob), tshem cov ntsiab lus, thiab ntaus hauv Acme.
- Ntaus wikiHow cov nyiaj tau los txhua hli rau hauv thawj lub npov hauv qab "Tus lej" nqe lus (lub thawv tau ua ntej nrog "2500" los ntawm lub hauv paus ntawm tus qauv). Ua tib yam rau cov nyiaj tau los txhua hli los ntawm "Acme" hauv lub npov hauv qab no.
- Yog tias koj tsis muaj lwm cov nyiaj tau los, nyem rau lwm lub npov ("Lwm Yam" thiab "$ 250"), tom qab ntawd nias lub pob Del kom tshem lawv.
- Koj kuj tseem tuaj yeem ntxiv cov peev txheej ntawm cov nyiaj tau los thiab lawv cov nyiaj hauv kab hauv qab cov kab uas twb muaj lawm.
Ua Spreadsheet hauv Excel Kauj Ruam 12 Kauj Ruam 5. Nyem rau Daim Ntawv Them Nqi Txhua Hli kom nkag mus rau cov nyiaj tau los
Cov ntawv no yog tab thib peb nyob hauv qab ntawm phau ntawv ua haujlwm. Ntawm lub tab ntawd, muaj cov nqi nkag thiab lawv cov nyiaj (twb tau sau ua ntej lawm). Txawm li cas los xij, koj tuaj yeem nyem ob npaug rau lub npov kom hloov qhov nkag mus.
- Piv txwv li, cia peb hais tias tus nqi xauj tsev ib hlis rau koj qhov chaw nyob lossis tsev nyob yog 3 lab rupiah hauv ib lub hlis. Nyem ob npaug rau qhov tam sim no "$ 800" nkag, rho tawm nws, thiab ntaus hauv 3000000.
- Hais tias koj muaj qiv nyiaj uas yuav tsum tau them rov qab. Nyem tus lej tom ntej "Cov Tub Ntxhais Kawm Qiv Nyiaj" hauv kab ntawv "Tus Nqi" ("$ 50") thiab nias tus yuam sij Del ntawm tus keyboard kom tshem nws. Ua tib yam rau lwm cov nuj nqis.
- Koj tuaj yeem tshem tawm tag nrho cov kab los ntawm txoj cai-nias kab lej thiab xaiv " Rho tawm ”.
- Txhawm rau ntxiv kab tshiab, nyem rau kab ntawv hauv qab kab ntawv txoj haujlwm tshiab uas koj xav tau, tom qab ntawv xaiv " Ntxig ”.
- Nco ntsoov tias tsis muaj tus nqi ntxiv uas koj yuav tsum tau them hauv kab "Tus Nqi" vim tias cov nqi no yuav suav nrog hauv pob nyiaj siv.
Ua Spreadsheet hauv Excel Kauj Ruam 13 Kauj Ruam 6. Nyem rau Cov Lus Qhia tab kom pom cov peev txheej txhua hli
Tom qab nkag mus rau cov ntaub ntawv, daim duab ntawm lub tab no yuav hloov kho tshiab kom pom qhov koj cov nyiaj tau los thiab cov nuj nqis txhua hli.
- Yog tias cov ntaub ntawv tsis suav nrog, nias F9 qhov tseem ceeb ntawm cov keyboard.
- Kev hloov pauv rau cov nyiaj tau los thiab cov nuj nqis txhua hli tab yuav cuam tshuam cov ntaub ntawv uas koj pom ntawm "Cov ntsiab lus" tab.
Ua Spreadsheet hauv Excel Kauj Ruam 14 Kauj Ruam 7. Txuag daim ntawv
Tom qab koj txaus siab lossis ua tiav kho cov ntaub ntawv, koj tuaj yeem txuag daim ntawv nthuav tawm los ntawm txhaj rau cov ntawv qhia zaub mov " Cov ntaub ntawv "Nyob rau sab saud sab laug ntawm qhov screen thiab xaiv" Txuag As ”.
