Kugwiritsa ntchito cholinga Chofuna mu Excel

Gwiritsani ntchito Cholinga Pangani kukonza mapulani atsopano

Cholinga cha Excel Chofunafuna chikuthandizani kuti musinthe deta yomwe ikugwiritsidwa ntchito mwachindunji kuti mupeze zomwe zotsatira zidzakhala ndi kusintha. Mbali imeneyi ili yothandiza pamene mukukonzekera polojekiti yatsopano. Zotsatira zosiyana zitha kuyerekezedwa ndikupeza kuti ndi yani yomwe ikuyenerera bwino zomwe mukufuna.

Kugwiritsa ntchito Pulogalamu Yowunikira Pachifuniro cha Excel & # 39;

Chitsanzo ichi choyamba chimagwiritsa ntchito ntchito ya PMT kuwerengera malipiro a mwezi ndi ngongole. Icho chimagwiritsa ntchito Cholinga Chofuna kuchepetsa malipiro a mwezi ndi kusintha nthawi ya ngongole.

Choyamba, lowetsani deta zotsatirazi mu maselo omwe amasonyeza:

Cell - Data
D1 - Kubwezera ngongole
D2 - Malipiro
D3 - Malipiro #
D4 - Mkulu
D5 - Malipiro

E2 - 6%
E3 - 60
E4 - $ 225,000

1. Dinani pa selo E5 ndipo lembani fomu yotsatira: = pmt (e2 / 12, e3, -4) ndipo yesani ENTER mmanja pa makiyi
2. Mtengo wa $ 4,349.88 uyenera kuoneka mu selo E5. Imeneyi ndi malipiro amwezi pamwezi.

Kusinthasintha kwa Malipiro a Mwezi Kupyolera Mufuna Kufuna

1. Dinani pa tabu ya Deta pa tsamba.
2. Sankhani Chiyani-Ngati Kusanthula kutsegula mndandanda wamatsitsimutso.
3. Dinani pa Cholinga Chofuna .
4. Mu bokosi la bokosi , dinani pa Kuyika selolo .
5. Dinani pa selo E5 mu spreadsheet kuti musinthe malipiro a mwezi uliwonse pa ngongoleyi.
6. Mu bokosi la bokosi, dinani pa Kuti muyamikire mzere.
7. Lembani 3000 kuti muchepetse malipiro a mwezi uliwonse kwa $ 3000.00.
8. Mu bokosi la bokosi, dinani pa Kusintha selo .
9. Dinani pa selo E3 mu spreadsheet kuti musinthe malipiro a mwezi uliwonse mwa kusintha chiwerengero cha malipiro opangidwa.
10. Dinani OK .
11. Panthawi imeneyi, cholinga Chofunafuna chiyenera kuyamba kufunafuna yankho. Ngati akupeza imodzi, bokosi lakulingalira la cholinga lidzakuuzani kuti yothetsera vutoli.
12. Pachifukwa ichi, yankho ndikutembenuza chiwerengero cha malipiro mu selo E3 mpaka 94.25.
13. Kuti muvomereze yankho ili, dinani Chotsekerani mu Cholinga Chofunira Bukhuli, ndi Cholinga Chofuna Kusintha deta mu selo E3.
14. Kuti mupeze yankho linalake, dinani Tsanulani mu bokosi la Mafunso lofunafuna. Cholinga Funani kubwereranso mtengo mu selo E3 mpaka 60. Tsopano mwakonzeka kuthamanga Goal Search kachiwiri.