Cov wikiHow no qhia koj li cas los tsim daim ntawv xa nyiaj nrog Windows lossis Mac version ntawm Microsoft Excel. Koj tuaj yeem tsim cov ntawv xa nyiaj tuaj ntawm tus kheej, lossis siv cov qauv sau nqi.
Kauj ruam
Txoj Kev 1 ntawm 3: Siv Cov Qauv ntawm Windows
Kauj Ruam 1. Nyem ob npaug rau lub cim ntsuab nrog lub "X" dawb los qhib Microsoft Excel lub vijtsam hauv tsev
Kauj Ruam 2. Tshawb nrhiav cov ntawv teev nyiaj txiag los ntawm kev nkag mus rau lo lus tseem ceeb daim ntawv xa nyiaj hauv kab ntawv tshawb fawb nyob rau saum toj ntawm nplooj ntawv
Tom qab ntawd, nyem Enter.
Txhawm rau tshawb nrhiav tus qauv, koj lub khoos phis tawj yuav tsum txuas nrog internet
Kauj Ruam 3. Xaiv tus qauv koj xav siv
Tus qauv yuav qhib rau lub qhov rai tshiab.
Kauj Ruam 4. Nyem rau khawm Tsim ntawm sab xis ntawm tus qauv saib ua ntej kom qhib cov qauv hauv Microsoft Excel
Kauj Ruam 5. Kho cov qauv raws li xav tau
Piv txwv li, hloov cov ntawv "Tuam Txhab" nyob rau sab saum toj ntawm tus qauv nrog koj lub tuam txhab npe.
Txhawm rau kho cov ntawv hauv tus qauv, ob npaug nyem rau ntawm cov ntawv koj xav kho, tom qab ntawd rho tawm lossis rov sau dua cov ntawv
Kauj Ruam 6. Sau daim nqi
Nkag mus rau cov ntaub ntawv thov los ntawm tus qauv kom ntseeg tau tias tus qauv qhia pom tus nqi raug nqi raug.
- Piv txwv li, qee tus qauv them nqi xav kom koj nkag mus rau tus nqi teev lossis tus nqi tiaj tus.
- Cov qauv them nqi feem ntau muaj cov qauv rau xam tus nqi teev thiab pes tsawg teev ua haujlwm. Cov txiaj ntsig ntawm cov kev suav no yuav tshwm nyob rau hauv kab "Tag Nrho Kawg".
Kauj Ruam 7. Khaws daim ntawv xa nyiaj los ntawm txhaj Cov Ntaub Ntawv nyob rau hauv kaum sab xis ntawm nplooj ntawv
Tom qab ntawd, nyem Txuag As, thiab xaiv qhov chaw khaws cov ntawv. Sau lub npe cov ntaub ntawv, tom qab ntawd nyem Txuag. Tam sim no, koj cov ntaub ntawv them nqi raug khaws tseg thiab npaj xa.
Txoj Kev 2 ntawm 3: Siv Cov Qauv ntawm Mac
Kauj Ruam 1. Ob-nias lub cim ntsuab nrog lub "X" dawb los qhib Microsoft Excel lub vijtsam hauv tsev
Kauj Ruam 2. Nyem Cov Ntawv Qhia zaub mov nyob rau sab saum toj sab laug ntawm nplooj ntawv kom qhib cov ntawv qhia zaub mov
Kauj Ruam 3. Los ntawm cov ntawv qhia zaub mov uas tshwm, nyem Tshiab los ntawm Tus Qauv
Lub qhov rai tshiab nrog cov qauv xaiv yuav tshwm.
Kauj Ruam 4. Tshawb nrhiav cov ntawv teev nyiaj txiag los ntawm kev nkag mus rau lo lus tseem ceeb daim ntawv xa nyiaj hauv kab ntawv tshawb fawb nyob rau saum toj ntawm nplooj ntawv
Tom qab ntawd, nyem Enter.
Txhawm rau tshawb nrhiav tus qauv, koj lub khoos phis tawj yuav tsum txuas nrog internet
Kauj Ruam 5. Xaiv tus qauv koj xav siv
Tus qauv yuav qhib rau lub qhov rai tshiab.
Kauj Ruam 6. Nyem rau khawm Tsim ntawm sab xis ntawm tus qauv saib ua ntej kom qhib cov qauv hauv Microsoft Excel
Kauj Ruam 7. Kho cov qauv raws li xav tau
Piv txwv li, hloov cov ntawv "Tuam Txhab" nyob rau sab saum toj ntawm tus qauv nrog koj lub tuam txhab npe.
Txhawm rau kho cov ntawv hauv tus qauv, ob npaug nyem rau ntawm cov ntawv koj xav kho, tom qab ntawd rho tawm lossis rov sau dua cov ntawv
Kauj Ruam 8. Sau daim nqi
Nkag mus rau cov ntaub ntawv thov los ntawm tus qauv kom ntseeg tau tias tus qauv qhia pom tus nqi raug nqi raug.
- Piv txwv li, qee tus qauv them nqi xav kom koj nkag mus rau tus nqi teev lossis tus nqi tiaj tus.
- Cov qauv them nqi feem ntau muaj cov qauv rau xam tus nqi teev thiab pes tsawg teev ua haujlwm. Cov txiaj ntsig ntawm cov kev suav no yuav tshwm nyob rau hauv kab "Tag Nrho Kawg".
Kauj Ruam 9. Txuag daim nqi los ntawm txhaj rau ntawm File menu
Tom qab ntawd, nyem Txuag As, thiab xaiv qhov chaw khaws cov ntawv. Sau lub npe cov ntaub ntawv, tom qab ntawd nyem Txuag. Tam sim no, koj cov ntaub ntawv them nqi raug khaws tseg thiab npaj xa.
Txoj Kev 3 ntawm 3: Kev Them Nqi Tus Kheej
Kauj Ruam 1. Ob-nias lub cim ntsuab nrog lub "X" dawb los qhib Microsoft Excel lub vijtsam hauv tsev
Kauj Ruam 2. Nyem qhov Blank Workbook xaiv nyob rau sab saud sab laug ntawm Excel pib nplooj ntawv los tsim cov ntawv tshiab
Yog tias koj siv Mac, hla cov kauj ruam no yog Excel tam sim qhia cov ntawv tshiab
Kauj Ruam 3. Ua lub taub hau ntawm daim nqi
Koj daim ntawv them nqi yuav tsum muaj cov ntaub ntawv hauv qab no:
- Lub tuam txhab npe - Lub npe ntawm lub tuam txhab uas tau tshaj tawm daim nqi.
- Ntaub ntawv - Kev piav qhia dav dav (piv txwv li "Bill") lossis hom nqi. Piv txwv li, yog tias koj xav muab kev pabcuam tshwj xeeb, tsis txhob them nyiaj rau kev ua haujlwm, sau "Tus Nqi Muab".
- Hnub tim - Hnub sau daim ntawv sau nqi.
- Zauv Tus lej them nqi. Koj tuaj yeem siv cov lej thoob ntiaj teb rau txhua tus neeg siv khoom, lossis tus lej tus kheej rau txhua tus neeg siv khoom. Yog tias siv tus lej tshwj xeeb rau txhua tus neeg siv khoom, koj tuaj yeem suav nrog ib feem lossis tag nrho cov neeg siv khoom lub npe ntawm tus lej them nqi, piv txwv li "JupeFriedChicken-01".
Kauj Ruam 4. Nkag mus rau qhov chaw nyob ntawm tus neeg xa thiab tus neeg txais nyiaj nyob rau saum daim nqi
Muab koj lub tuam txhab cov ntaub ntawv tshaj tus neeg siv cov ntaub ntawv.
- Suav nrog koj lub npe, npe tuam txhab, tus xov tooj, thiab email chaw nyob ntawm daim nqi.
- Kuj suav nrog lub npe ntawm tus neeg siv khoom lub tuam txhab, lub npe ntawm tus neeg tau txais tus nqi, thiab tus neeg siv khoom chaw nyob. Yog xav tau, koj tuaj yeem suav nrog tus neeg siv tus lej xov tooj thiab email chaw nyob.
Kauj Ruam 5. Sau cov ntaub ntawv nqi
Koj tuaj yeem tsim kab ntawv uas muaj cov lus piav qhia luv luv ntawm cov kev pabcuam lossis khoom, cov kev pabcuam/cov khoom muaj nuj nqis, tus nqi/nqe nqe, thiab tag nrho nqe nqe rau kev pabcuam/khoom.
Kauj Ruam 6. Tso tag nrho cov nqi hauv qab tus nqi/tus lej
Koj tuaj yeem suav tag nrho cov nuj nqis nrog Excel's SUM ua haujlwm.
- Piv txwv li, yog tias koj tso $ 200 hauv xov tooj B3 thiab IDR 300,000 hauv kab ntawv B4, sau cov mis = SUM (B3, B4) hauv cell B5 kom pom $ 500 hauv cell B5.
- Yog tias koj them tus nqi pabcuam ib teev (piv txwv li IDR 100,000) ntawm tus xovtooj B3 thiab pes tsawg teev ua haujlwm ntawm tes B4, sau cov mis = SUM (B3*B4) hauv cell B5.
Kauj Ruam 7. Suav nrog hnub kawg rau saum lossis hauv qab ntawm cov ntaub ntawv them nyiaj
Feem ntau, koj tuaj yeem ua daim ntawv xa nyiaj xa tuaj thaum xa daim ntawv xa tuaj, 14 hnub tom qab xa daim nqi xa nyiaj, 30 hnub tom qab xa daim nqi, lossis 60 hnub tom qab xa daim nqi.
Koj tseem tuaj yeem suav nrog daim ntawv ceeb toom hauv qab ntawm daim nqi. Hauv daim ntawv no, koj tuaj yeem suav nrog txoj hauv kev them nyiaj, cov ntaub ntawv dav dav, lossis ua tsaug rau cov neeg siv khoom
Kauj Ruam 8. Txuag daim nqi
Yog tias tsim nyog, siv lub npe sib txawv los ntawm lwm daim ntawv xa nyiaj rau tus neeg siv khoom. Kom txuag tau ib daim nqi:
- Qhov rai - Nyem Cov ntaub ntawv nyob rau sab xis ntawm nplooj ntawv. Tom qab ntawd, nyem Txuag As, thiab xaiv qhov chaw khaws cov ntawv. Sau lub npe cov ntaub ntawv, tom qab ntawd nyem Txuag.
- Mac - Nyem ntawv qhia zaub mov Cov ntaub ntawv. Tom qab ntawd, nyem Txuag As, thiab xaiv qhov chaw khaws cov ntawv. Sau lub npe cov ntaub ntawv, tom qab ntawd nyem Txuag.
