Inchant tebulo ku Excel

Anonim

Tebulo lopindika mu Microsoft Excel

Nthawi zambiri, muyenera kuwerengera zotsatira zomaliza za kuphatikiza kosiyanasiyana kwa deta. Chifukwa chake, wogwiritsa ntchitoyo adzatha kuwunika njira zonse zomwe angathe kuchita, sankhani zomwezo, zomwe zimachitika chifukwa chogwirizana, ndipo, pomaliza, sankhani njira yabwino kwambiri. Kupambana, pali chida chapadera chochitira ntchitoyi - "tebulo la data" ("Phala" la "Phati"). Tiyeni tiwone momwe mungagwiritsire ntchito kuti muchite zomwe zili pamwambapa.

Gome lodzaza ndi deta mu Microsoft Excel

Kuphatikiza apo, zitha kudziwika kuti kuchuluka kwa malipiro pamwezi pa 12,5% pachaka chomwe chapezeka chifukwa chogwiritsira ntchito patebulo yolowa m'malo mwake chidwi chomwe tidalandira pogwiritsa ntchito ntchito yomwe talandira. Izi zimatsimikiziranso kulondola kwa kuwerengera.

Kutsatirana ndi matebulo omwe ali ndi kuwerengetsa kwambiri mu Microsoft Excel

Tikamafufuza masabulo awa, kuti tiwone kuti, monga tikuwona, pokhapokha tikungowerenga 9 9.5% pachaka chomwe chimakhala chovomerezeka pamwezi (ochepera ruble 29,000).

Kuvomerezeka kwa mwezi uliwonse ku Microsoft Excel

Phunziro: Kuwerengera kwannuity kulipirira

Njira 2: Kugwiritsa ntchito chida chokhala ndi mitundu iwiri

Zachidziwikire, kupeza mabanki pakadali pano, omwe amapereka ngongole pansi pa 9.5% pachaka, ndizovuta, ngati zili choncho kwenikweni. Chifukwa chake, tiwone zosankha zomwe zingakhalepo mu gawo lovomerezeka pamwezi pamitundu ina ya mitundu ina: kukula kwa thupi la ngongole ndi nthawi ya ngongole. Nthawi yomweyo, chiwongola dzanja chidzasiyidwa osasinthika (12.5%). Pothetsa ntchitoyi, tithandiza chida cha "deta ya deta ya data" pogwiritsa ntchito mitundu iwiri.

  1. Kudalirika kwatsopano. Tsopano m'mayiko a mizamu idzawonetsedwa nthawi ya ngongole (kuyambira 2 mpaka 6 zaka mu sabata limodzi), komanso m'mizere ya ngongole ya ngongole (kuchokera ku 85000 rubles za ma ruble 10,000). Pankhaniyi, chikhalidwe choyenera ndichakuti khungu, lomwe njira yowerengera imapezeka (malinga ndi nkhani yathu) idapezeka m'malire a mayina a mizere ndi mizata. Popanda kuchita izi, chida sichingagwire ntchito mukamagwiritsa ntchito mitundu iwiri.
  2. Tebulo logwirira ntchito kuti mupange mitundu iwiri ndi mitundu iwiri ku Microsoft Excel

  3. Kenako tinagawa mitundu yonse ya tebulo, kuphatikizapo dzina la mizati, mizere ndi maselo okhala ndi mawonekedwe a PLD. Pitani ku "deta" tabu. Monga mu nthawi yapita, dinani pa "kusanthula" Bwanji "", mu "kugwira ntchito ndi data" chida. M'ndandanda womwe umatsegulira, sankhani "tebulo la data ...".
  4. Yambitsani Gome la Zida Zapamwamba pa Microsoft Excel

  5. Khonera la "data ya data" limayamba. Pankhaniyi, tidzafunikira minda yonse. Mu "Zoyenera zamitundu yokhudzana ndi mzati" m'munda, sonyezani mgwirizano wa khungu lomwe lili ndi ngongole yobwereketsa. Mu "mfundo zogwirizira kudzera pa" munda, fotokozerani adilesi ya khungu la magwero okhala ndi mtengo wa ngongole ya ngongole. Pambuyo pa deta yonse yaikidwa. Clay pa batani la "Ok".
  6. Chida cha Khodi ya Final Pack ku Microsoft Excel

  7. Pulogalamuyi imagwira ntchitoyo ndikudzaza mawonekedwe a detar. Panjira ya mizere ndi mzati, mutha kuwona zomwe zingakhale zolipira pamwezi, pogwiritsa ntchito mtengo wolingana pa peresenti ya pachaka ndi nthawi yomwe mwakhala ndi ngongole.
  8. Gome la data limadzaza microsoft Excel

  9. Monga mukuwonera, mfundo zambiri. Kuti muthane ndi ntchito zina, pakhoza kukhala zochulukirapo. Chifukwa chake, kuti mupereke zotsatira zowoneka bwino komanso nthawi yomweyo kudziwa zomwe sizikukwaniritsa zomwe zafotokozedwazo, mutha kugwiritsa ntchito zida zowoneka. M'malo mwathu, zidzakhala zanzeru. Timatsindika zonse za patebulo, kupatula mitu ya mizere ndi mizata.
  10. Kusankha tebulo ku Microsoft Excel

  11. Timasunthira ku "kunyumba" ndi dongo pa chithunzi cha "mawonekedwe azomwe amalemba. Imapezeka mu "masitayilo" zida zotchinga pa riboni. Pa menyu yosiya, sankhani chinthucho "malamulo ogawika ma cell". Mumndandanda wowonjezera wa dinani paudindo "wochepera ...".
  12. Kusintha Kuti Muzikonzekera Zoyimira mu Microsoft Excel

  13. Kutsatira izi, kukonza mapangidwe zenera kumatseguka. M'munda wamanzere, timatchula ndalama zochepa kuposa momwe maselo adzasonyezera. Pamene mukukumbukira, timatikhutiritsa pomwe ndalama zomwe ndalama za mwezi uliwonse zidzasakwana ruble 29,000. Lowetsani nambala iyi. Mu gawo loyenera, ndizotheka kusankha mtunduwo, ngakhale kuti mutha kuzisiya mosayenera. Pambuyo pa zoikamo zonse zomwe zimafunikira zimalowetsedwa, dongo pa batani la "Ok".
  14. Zenera lokhazikika pazenera ku Microsoft Excel

  15. Pambuyo pake, maselo onse, zomwe zimagwirizana ndi zomwe zafotokozedwa pamwambapa zidzawonetsedwa ndi utoto.

Phwando la maselo mu utoto wofanana ndi ma microsoft Excel

Mutawunika matebulo, mutha kudziwa zambiri. Monga mukuwonera, ndi nthawi yomwe ikubwereketsa (miyezi 36) kuti tipeze ndalama zotchulidwa pamwezi, tifunika kutenga ngongole yomwe ilibe 80,000.00 ma rubles, omwe alipo, 40,000 sakukonzekera.

Kukula kwakukulu kwa chobwereketsa pansi pa nthawi yobwereketsa ndi zaka zitatu ku Microsoft Excel

Ngati tikufunabe kutenga ngongole ya ma ruble 900,000, nthawi ya ngongole iyenera kukhala zaka 4 (miyezi 48). Pokhapokha ngati izi, kukula kwa malipiro pamwezi sikungapitirire malire a Ruble ruble 29,000.

Ngongole ya Ngongole Yabwino Kwambiri Ngongole Yoyambirira ku Microsoft Excel

Chifukwa chake, pogwiritsa ntchito matebulo ndi kusanthula "ndi" motsutsana ndi njira iliyonse, wobwereketsa akhoza kusankhana mwatsatanetsatane pa zobwereketsa posankha njira yoyankha kwambiri kuchokera konse.

Zachidziwikire, tebulo lolowa m'malo silingagwiritsidwe ntchito kuwerengera ngongole, komanso kuthana ndi ntchito zina.

Phunziro: Mawonekedwe oyenera ku Excel

Mwambiri, ziyenera kudziwika kuti tebulo logwirizira ntchito ndi chida chothandiza kwambiri komanso chophweka kuti mudziwe zotsatira ndi mitundu yosiyanasiyana yazitsulo. Kugwiritsa ntchito mawonekedwe onse a munthawi yomweyo, kuwonjezera apo, mutha kuwona kuwona zomwe zalandilidwa.

Werengani zambiri