Imbonerahamwe ya Exchant muri Excel

Kenshi na kenshi, ugomba kubara ibisubizo byanyuma kubijyanye nuburyo butandukanye bwo kwinjiza amakuru. Rero, umukoresha azashobora gusuzuma uburyo bwose bushoboka, hitamo ibyo, ibisubizo byimikoranire ihaza, kandi, amaherezo, hitamo uburyo bwiza. Muri Excel, hari igikoresho kidasanzwe cyo gukora iki gikorwa - "imbonerahamwe yamakuru" ("kumeza"). Reka tumenye uburyo bwo kubikoresha kugirango dukore ibintu byavuzwe haruguru.

Byongeye kandi, harashobora kumenyekana ko amafaranga yo kwishyura buri kwezi kuri 12.5% ​​kuri buri mwaka yabonetse nkibisubizo byimeza ahuye ninyungu imwe yakiriye akoresha imikorere ya PL. Ibi byongeye kwerekana ukuri kubara.

Nyuma yo gusesengura iyi mbonerahamwe, byakagombye kuvugwa ko, nkuko tubibona, gusa ku gipimo cya 9.5% kuri buri mwaka bizimya urwego rwemewe rwo kwishyura buri kwezi (munsi ya 29000).

Isomo: Kubara buri mwaka byishyura muri Excel

Uburyo 2: Gukoresha igikoresho gifite impinduka ebyiri

Birumvikana ko kugirango ubone amabanki kurubu, itanga inguzanyo munsi ya 9.5% kuri buri mwaka, biragoye cyane, niba muri byose. Noneho, reka turebe uburyo buhari murwego rwemewe rwo kwishyura buri kwezi muburyo butandukanye bwibindi bihinduka: ubunini bwumubiri winguzanyo nigihe cyinguzanyo. Mugihe kimwe, igipimo cyinyungu kizasigara kidahindutse (12.5%). Mugukemura iki gikorwa, tuzafasha igikoresho cya "Data imbonerahamwe" ukoresheje ibice bibiri.

1. Umucungamuzi mushya. Noneho mumazina yinkingi azerekanwa nigihe cyinguzanyo (kuva kumyaka 2 kugeza kuri 6 mumezi mu ntambwe yumwaka umwe), kandi kumurongo - kuva ku mubiri w'inguzanyo (kuva ku 850.000 kuri 950000 ku ntambwe y'amafaranga 10,000). Muri iki gihe, imiterere iteganijwe nuko selile, aho formulaire ibarwa iherereye (kuri twe, PLT) yari iherereye kumupaka wamazina yimisatsi ninkingi. Utiriwe ukora iyi miterere, igikoresho ntikizakora mugihe ukoresheje impinduka ebyiri.



2. Noneho tugenera imbonerahamwe yose, harimo n'izina ryinkingi, imirongo hamwe na selile hamwe na fort formula. Jya kuri tab "data". Nko mu bihe byabanjirije, kanda ahanditse "gusesengura" bigenda bite niba "", muri "gukorana na datant Toolbar. Kurutonde rufungura, hitamo "Imbonerahamwe yamakuru ...".



3. "Imbonerahamwe ya Data" Idirishya ritangira. Muri iki gihe, tuzakenera imirima. Muri "indangagaciro zo gusimbuza ku nkingi mu" murima, berekana ihuriro ry'akagari ririmo igihe cy'inguzanyo ku makuru y'ibanze. Muri "indangagaciro zo gusimbuza ukoresheje" umurima, sobanura aderesi ya selire yinkomoko ikubiyemo agaciro k'umubiri w'inguzanyo. Nyuma yamakuru yose yinjiye. Ibumba kuri buto "OK".



4. Porogaramu ikora kubara no kuzura intera yamakuru. Ku mirongo yimirongo ninkingi, urashobora noneho kwitegereza ibizaba ubwishyu bwa buri kwezi, hamwe n'agaciro gahuye ka buri mwaka n'igihe ntarengwa.



5. Nkuko mubibona, indangagaciro nyinshi. Gukemura indi mirimo, hashobora kubaho byinshi. Kubwibyo, kugirango itangwa ibisubizo Ibisubizo byinshi kandi uhite menya indangagaciro zidahagije imiterere yagenwe, urashobora gukoresha ibikoresho bireba. Ku bitureba, bizaba imiterere. Turagaragaza indangagaciro zose zimeza, ukuyemo imitwe yimirongo ninkingi.



6. Twimukiye kuri tab ya "urugo" kuri "imiterere ya kamere". Iherereye mu bikoresho bya "Style" kuri lente. Muri menu ihagarika, hitamo ikintu "amategeko yo kugabana selile". Kurutonde rwinyongera rwo gukanda kumwanya "bike ...".



7. Gukurikira ibi, uburyo bwo gushiraho asabwa bufungura. Mu murima w'ibumoso, tugaragaza amafaranga ari munsi ya selile zizagaragara. Nkuko ubyibuka, duduhaza aho kwishyurwa buri kwezi bizaba munsi ya 29.000. Injira iyi nimero. Muburyo bwiza, birashoboka guhitamo ibara ryo gutoranya, nubwo ushobora kubireka muburyo busanzwe. Nyuma ya byose bisabwa byinjijwe, ibumba kuri buto "OK".



8. Nyuma yibyo, ingirabuzimafatizo zose, indangagaciro zihuye nimiterere yasobanuwe haruguru izahindurwa ibara.

Nyuma yo gusesengura imbonerahamwe, urashobora gukora imyanzuro. Nkuko mubibona, hamwe nigihe cyo kuguriza (amezi 36) gushora imari murwego rwavuzwe haruguru rwo kwishyura buri kwezi, dukeneye gufata inguzanyo itarenze amafaranga 80.000.00, 40.000 ni munsi yateguwe mbere.

Niba tugifite umugambi wo gufata inguzanyo ya 900.000, igihe cy'inguzanyo kigomba kuba imyaka 4 (amezi 48). Gusa muri uru rubanza, ingano yo kwishyura buri kwezi ntishobora kurenza imipaka yashyizweho yimibare 29000.

Rero, ukoresheje iyi mbonerahamwe hanyuma usesengure "kuri" na "kurwanya" buri buryo, uwagurijwe arashobora gufata icyemezo cyihariye kubijyanye no gutanga inguzanyo muguhitamo igisubizo cyose gishoboka.

Nibyo, imbonerahamwe yo gusimbuza irashobora gukoreshwa gusa kubara gusa kumahitamo yinguzanyo, ariko kandi yakemuye ubwinshi bwiyi mirimo.

Isomo: Imiterere ifatika muri Excel

Muri rusange, twakagombye kumenya ko imbonerahamwe yo gusimbuza aringirakamaro cyane kandi ugereranije igikoresho cyoroshye kugirango umenye ibisubizo hamwe nibihinduka bitandukanye byimiterere. Gusaba ibintu byombi bisabwa icyarimwe hamwe nayo, hiyongereye, urashobora kwiyumvisha amakuru yakiriwe.