Enchant tafura muExcel

Kazhinji kazhinji, iwe unofanirwa kuverenga mhedzisiro yekupedzisira yemasanganiswa akasiyana e data rekuisa. Saka, mushandisi anozokwanisa kuongorora zvese zvisarudzo zvekuita, sarudza izvo, mhedzisiro yekudyidzana kwazvinogutsa, uye, pakupedzisira, sarudza sarudzo yakanyanya kunaka. MuBudiriro, pane chishandiso chakakosha kuita basa iri - "Tafura yedata" ("SUPTIDY TAPA"). Ngatitsvagei kuvashandisa kuti vaite zviitiko zviri pamusoro.

Mukuwedzera, zvinogona kucherechedzwa kuti huwandu hwekubhadhara pamwedzi na12,5% pagore rinowanikwa semubhadharo weTechinesekuita neiyo kukosha kwakafanana nekufarira kwatakawana nekushandisa iyo pl basa. Izvi zvinongoratidza zvakare kurongeka kwekuverenga.

Mushure mekuongorora iyi tafura, sezvatinoona, sezvatinoona, chete pamwero wezana 9.5% pagore rinozoitika mukubhadhara kwemwedzi (zvisingasviki zviuru zvina makumi matatu neshanu).

Chidzidzo: Kuverenga kweAnnuity Kubhadhara muExcel

Nzira 2: Uchishandisa chishandiso chine maviri akasiyana

Ehezve, kutsvaga mabhangi parizvino, iyo inopa chikwereti pasi pe9,5% pagore, yakaoma kwazvo, kana zvachose. Naizvozvo, ngatione kuti ndedzipi sarudzo dziripo mune inogamuchirwa mubhadharo wemwedzi nemwedzi mukusanganiswa kwezvimwe zvakasiyana: Ukuru hwembeu yekwereti uye nguva yechikwereti. Panguva imwecheteyo, huwandu hwemubhadharo huchasiyiwa asina kuchinjika (12.5%). Mukugadzirisa basa iri, tichabatsira "data tafura" yekushandisa uchishandisa maviri akasiyana.

1. Blacksmith idzva tabular array. Iye zvino mumazita emakoramu acharatidzwa kiredhiti nguva (kubva pamakore maviri kusvika matanhatu mumwedzi iri mudanho regore rimwe), kubva pamatanho emukuru wechikwereti (kubva pamakumi masere emazana kusvika pamakumi mapfumbamwe nemashanu kusvika 950000 rubles ine nhanho of 10,000 rubles). Mune ino kesi, mamiriro ekumanikidzwa ndechekuti sero, umo iyo yekuverenga iyo fomu inowanikwa (mune yedu kesi, PLT) yaive pamuganho wemazita emitsara nemakoramu. Pasina kuita izvi, chishandiso hachishande kana uchishandisa maviri akasiyana.



2. Ipapo isu tinopa iyo tafura yese yetafura, kusanganisira zita remakoramu, mitsara uye masero ane plt formula. Enda ku "data" tab. Sezvazviri munguva yapfuura, tinya pane "kuongororwa" Ko kana ", mu" kushanda nedata "Toolbar. Mune rondedzero inovhura, sarudza iyo "tafura yedata ...".



3. Iyo "data tafura yetafura" chombo chinotanga. Mune ino kesi, isu tichazoda minda yese. Mu "Kutsiva Kosi pamakoramu mu" Munda, ratidza kuronga kweiyo sero ine nguva yekukwereta mune yekutanga data. Mu "Substitums kukosha kuburikidza ne" munda, taura kero yesero yemasero ma paramita ane kukosha kwemuviri wechikwereti. Mushure mekunge data rese rapindwa. Ivhu pane "ok" bhatani.



4. Chirongwa ichi chinoita kuverenga uye kuzadza iyo tabular data renji. Pakupindirana kwemitsara uye nemakoramu, iwe unogona ikozvino kucherechedza kuti chii chichava mubhadharo pamwedzi, pamwe nekuenderana kunoenderana kwegore negore muzana yenguva yakatarwa.



5. Sezvauri kuona, tsika dzakawanda. Kugadzirisa mamwe mabasa, panogona kunge paine zvimwe. Naizvozvo, kuita kuburitswa kwemhedzisiro yakawanda yekuona uye nekukurumidza sarudza kuti ndeipi kukosha isingagutse mamiriro akataurwa, unogona kushandisa zvishandiso zveviso. Kwatiri, ichave yakamanikidzwa. Isu tinonyatsoratidza zvese kukosha kweiyo tafura yetafura, kusasanganisa misoro yemitsara uye nemakoramu.



6. Isu tinofamba kuenda ku "Imba" tab uye ivhu pane "mamiriro ezvinhu fomati" icon. Iyo iri mu "masitaera" zvishandiso zvekuvhara paRibbon. Mukubvisa menyu, sarudza chinhu "mitemo yekugoverwa kwemasero". Mune yekuwedzera rondedzero yekudzvanya pachinzvimbo "zvishoma ...".



7. Kutevera izvi, iyo mamiriro ekugadzira mamiriro ekuisa hwindo anovhura. Mumunda wokuruboshwe, isu tinotaura huwandu hwakaderera pane kuti ndeapi masero acharatidzwa. Sezvaunoyeuka, isu tinoita kuti tigutse iyo iyo iyo mari yekubhadhara pamwedzi ichave isingasviki zviuru zvina makumi matatu nemakumi matatu. Isa iyi nhamba. Mumunda worudyi, zvinokwanisika kusarudza iyo yakasarudzwa ruvara, kunyangwe iwe uchigona kuzvisiya nekukanganisa. Mushure mekunge zvese zvinodikanwa zvigadziriso zvakapinda, ivhu pane "ok" bhatani.



8. Mushure meizvozvo, masero ese, tsika dzinoenderana nemamiriro acho anotsanangurwa pamusoro acharatidzwa nemavara.

Mushure mekuongorora rondedzero tafura, unogona kuita mhedziso. Sezvauri kuona, nenguva yazvino kukweretesa (36 mwedzi) yekudyara mune iyo yekubhadhara inotaurwa pamusoro apa, isu tinofanirwa kutora chikwereti chisingapfuure 80,000.00 rubles, ndiko kuti, 40,000 pane zvakaderera pane zvakarongwa pakutanga.

Kana isu tichiri kutarisira kutora chikwereti che 900,000 rubles, nguva yechikwereti inofanira kunge iri makore mana (48 mwedzi). Chete mune ino kesi, kukura kwemubhadharo wemwedzi hakupfuure muganho wakagadzwa wezviuru zvamazana matatu ezviuru.

Saka, kushandisa iyi tafura yerudzi uye kuongorora "kwe" uye "sarudzo imwe neimwe, iye anokwereta anogona kutora sarudzo chaiyo pakukweretesa sarudzo kubva pane zvese zvinogoneka.

Ehezve, tafura yekutsiva inogona kushandiswa kwete kungoverengera nzira dzechikwereti, asi zvakare kugadzirisa huwandu hwemamwe mabasa.

Chidzidzo: Conditional Fomati muExcel

Kazhinji, zvinofanirwa kucherechedzwa kuti tafura yekutsiva ndeye chishandiso chakanyanya uye chakareruka chekuziva mhedzisiro ine dzakasiyana siyana musanganiswa. Kunyorera zvese zvakaringana kuumbwa panguva imwe chete nazvo, mukuwedzera, iwe unogona kuona kuti ruzivo rwakatambirwa.