Excel yog daim ntawv thov ua haujlwm uas yog ib feem ntawm Microsoft Office program. Siv Microsoft Excel, koj tuaj yeem xam cov nyiaj them txhua hli rau txhua hom qiv nyiaj lossis credit card. Qhov no tso cai rau koj kom raug dua hauv koj li kev siv nyiaj txiag los faib nyiaj txaus rau kev them nyiaj txhua hli. Txoj hauv kev zoo tshaj los xam cov nyiaj them txhua hli hauv Excel yog siv "cov haujlwm" tshwj xeeb.
Kauj ruam
Kauj Ruam 1. Qhib Microsoft Excel thiab phau ntawv ua haujlwm tshiab
Kauj Ruam 2. Txuag phau ntawv ua haujlwm nrog lub npe tsim nyog thiab piav qhia
Qhov no yuav pab koj nrhiav haujlwm thaum tom qab koj xav tau xa mus lossis hloov pauv koj cov ntaub ntawv
Kauj Ruam 3. Tsim daim ntawv lo hauv xov tooj ntawm tes A1 txo qis rau A4 rau qhov sib txawv thiab qhov tshwm sim ntawm koj li kev suav txhua hli
- Ntaus "Tshuav" hauv cell A1, "Tus paj laum" hauv cell A2 thiab "Period" hauv cell A3.
- Ntaus "Kev Them Ib Hlis" rau hauv cell A4.
Kauj Ruam 4. Nkag mus rau qhov sib txawv rau cov nyiaj qiv lossis credit card tus lej hauv cov cell los ntawm B1 mus rau B3 los tsim koj li lej Excel
- Qhov seem tshuav yuav tsum tau nkag mus rau hauv cell B1.
- Cov paj laum txhua xyoo, faib los ntawm tus naj npawb ntawm cov sijhawm nyob hauv ib xyoos, yuav nkag mus rau hauv cell B2. Koj tuaj yeem siv tus lej Excel ntawm no, xws li "=.06/12" los sawv cev rau 6 feem pua cov paj laum txhua xyoo uas tau them txhua lub hlis.
- Tus naj npawb ntawm lub sijhawm rau koj cov nyiaj qiv yuav raug nkag mus rau hauv cell B3. Yog tias koj tab tom suav cov nyiaj them txhua hli rau daim npav rho nyiaj, sau tus lej raws li qhov sib txawv hauv lub hlis nruab nrab ntawm hnub no thiab hnub uas koj teem rau kev them rov qab.
- Piv txwv, yog tias koj xav them koj daim npav rho nyiaj 3 xyoos txij tam sim no, sau tus lej "36." Peb xyoos sib npaug nrog 12 lub hlis hauv ib xyoos sib npaug 36.
Kauj Ruam 5. Xaiv cell B4 los ntawm txhaj rau nws
Kauj Ruam 6. Nyem qhov khawm ua haujlwm luv luv nyob rau sab laug ntawm kab ntawv mis
Daim ntawv lo rau nws yog "fx."
Kauj Ruam 7. Saib rau Excel tus lej "PMT" yog tias nws tsis pom nyob hauv cov npe
Kauj Ruam 8. Nyem rau xaiv "PMT" ua haujlwm, tom qab ntawd nyem rau "OK" khawm
Kauj Ruam 9. Ua kom siv tus xov tooj ntawm tes uas koj nkag mus rau cov ncauj lus kom ntxaws rau txhua qhov haujlwm hauv qhov "Function Arguments" window
- Nyem rau hauv "Tus Nqi" qhov rai qhov rai, tom qab ntawd nyem cell B2. Qhov "Tus Nqi" teb tam sim no yuav rub cov ntaub ntawv los ntawm lub xovtooj ntawd.
- Rov ua dua rau qhov "Nper" teb los ntawm kev nyem rau hauv daim teb no, tom qab ntawv nyem rau ntawm cell B3 kom tus lej tuaj yeem kos tau.
- Rov ua dua rau qhov "PV" teb los ntawm kev nyem sab hauv, tom qab ntawd nyem rau ntawm tes B1. Qhov no yuav yuam cov nyiaj qiv lossis daim npav rho nyiaj yuav tsum tau thim rau txoj haujlwm.
Kauj Ruam 10. Tawm ntawm "FV" thiab "Type" fields blank hauv "Function Arguments" window
Kauj Ruam 11. Ua kom tiav cov txheej txheem los ntawm nias lub pob "OK"
Kev suav them txhua hli yuav raug nthuav tawm hauv xov tooj B4, nyob ib sab ntawm daim ntawv "Them Ib Hlis"
