Excel ya shahara sosai tsakanin masu lissafi, masana tattalin arziki da masu bada kudi, bawai sabili da yawa kayan aikin don aiwatar da lissafin kudi daban-daban. Ainihin cikar ayyuka na wannan jigon an sanya shi ne ga rukuni na ayyukan kuɗi. Yawancinsu zasu iya zama da amfani ba kawai ga kwararru ba, har ma ga ma'aikata a cikin masana'antu masu alaƙa, da kuma ga masu amfani da talakawa a cikin bukatunsu na gida. Bari muyi la’akari da waɗannan fasalolin aikace-aikacen dalla-dalla, kuma mu ba da kulawa ta musamman ga shahararrun masu aiki da wannan rukunin.
Saiti ta amfani da ayyukan kuɗi
Dataungiyar bayanan mai aiki sun haɗa da samfurori sama da 50. Za mu dabam bi akan goma mafi shahara daga cikinsu. Amma da farko, bari mu bincika yadda za a buɗe jerin kayan aikin kuɗi don motsi don warware takamaiman matsala.
Canjin zuwa wannan akwatin kayan aiki an fi cika shi ta sauƙi ta Hanyar Aiki.
- Zaɓi tantanin da za a nuna sakamakon lissafin, kuma danna maɓallin "Saka aikin"wanda yake kusa da layin tsari.
- Mai maye aikin yana farawa. Danna filin. "Kategorien".
- Lissafin groupsungiyar rukunin mai aiki yana buɗe. Zabi suna daga ciki "Kudi".
- An ƙaddamar da jerin kayan aikin da muke buƙata. Mun zaɓi takamaiman aikin don kammala aikin kuma danna maɓallin "Ok". Sannan taga hujjojin mai aikin da aka zaɓa ya buɗe.
A cikin Aikin Aiki, Hakanan zaka iya bi ta shafin Tsarin tsari. Bayan samun canjin wurin, ana buƙatar danna maballin akan kintinkiri "Saka aikin"sanya a cikin kayan aiki Laburaren Ma’aikata. Nan da nan bayan wannan, Zazzabin Aiki yana farawa.
Hakanan akwai hanya don zuwa zuwa ga ma'aikacin kuɗi da ake so ba tare da buɗe farkon farawar maye ba. Don waɗannan dalilai a cikin rukuni ɗaya Tsarin tsari a cikin rukunin saiti Laburaren Ma’aikata a kan kintinkiri, danna maballin "Kudi". Bayan haka, jerin zaɓi na duk kayan aikin da ke cikin wannan toshe zai buɗe. Zaɓi abun da ake so kuma danna kan sa. Nan da nan bayan haka, taga yadda zai tattauna.
Darasi: Wizard ɗin Aiki a cikin Excel
Shiga ciki
Ofaya daga cikin abubuwanda ake nema daga masu aiki don masu bada bashin kuɗi shine aikin Shiga ciki. Yana ba ku damar lissafin fa'idodin amintattu ta hanyar yarjejeniya, ranar tasiri (biyan bashin), farashin 100 rubles na darajar fansa, ragin shekara-shekara, adadin fansa don 100 rubles na darajar fansa da adadin biyan (mitar). Wadannan sigogi sune mahawara akan wannan tsari. Bugu da kari, akwai mahawara na zabi. "Basis". Duk waɗannan bayanan za a iya shigar da su kai tsaye daga maballin cikin filayen da ke dacewa da taga ko adana su a cikin sel a cikin zanen Excel. A cikin maganar ta ƙarshe, maimakon lambobi da kwanan wata, kuna buƙatar shigar da hanyoyin shiga cikin waɗannan sel. Hakanan zaka iya shigar da aiki a cikin masarar dabara ko yanki a kan takardar da hannu ba tare da kiran taga mahawara ba. A wannan yanayin, dole ne ku bi fa'idodin da ke gaba:
= INCOME (Kwanan wata_sog; kwanan wata_initial_on karfi; Farashi; Farashi; fansho "Matsakaici; [Basis])
BS
Babban maƙasudin aikin BS shine ƙayyade ƙimar saka hannun jari na gaba. Jayayyarsa ita ce darajar kuɗi na tsawon lokacin (Biya), jimlar adadin lokaci ("Lambar_) da kuma biyan kuɗi na kowane lokaci ("Plt") Hujjar zabin ta hada da darajar yanzu (Zab) da saita lokacin biyan kuɗi a farkon ko a ƙarshen lokacin ("Nau'in") Bayanin yana da salon magana kamar haka:
= BS (Bet; Kol_per; Plt; [Ps]; [Type])
VSD
Mai aiki VSD ƙididdige farashin ciki na dawowar saboda tsabar kuɗi. Hujjar da kawai ake buƙata ga wannan aikin ita ce darajar kuɗi na tsabar kudi, wanda za'a wakilta a kan takardar aikin Excel ta hanyar yawan bayanai a cikin sel ("Dabi'u") Haka kuma, a farkon sallar zangon ya kamata a nuna adadin hannun jari tare da "-", da kuma sauran kuɗin shiga. Bugu da kari, akwai mahawara na zabi "Neman". Yana nuna ƙididdigar yawan riba. Idan baku fayyace shi ba, to ta hanyar tsoho an dauki wannan darajar azaman 10%. Tsarin rubutu dabarun shine kamar haka:
= VSD (Darajoji; [Mu'addara])
Ma'aikatar cikin gida
Mai aiki Ma'aikatar cikin gida yana aiwatar da lissafin kuɗin da aka daidaita na yawan dawowa, la'akari da kashi ɗaya daga cikin kuɗaɗen kudade. A cikin wannan aikin, ban da kewayon tsabar kuɗi ("Dabi'u") muhawara ita ce kudurin samar da kudade da kuma maimaitawa. Dangane da haka, syntax kamar haka:
= Ma'aikatar Harkokin Cikin Gida (Darajoji; Bet_financer; Bet_reinvestir)
KYAUTA
Mai aiki KYAUTA tana lissafin adadin biyan kuɗi na lokacin da aka ƙayyade. Muhawara na aikin ita ce ƙimar sha'awa na tsawon lokacin (Biya); lambar lokaci ("Lokaci"), ƙimar abin da ba zai iya wuce jimlar adadin lokatai ba; yawan lokaci ("Lambar_); halin yanzu (Zab) Bugu da kari, akwai mahawara na zabi - darajar nan gaba ("Bs") Wannan dabara za a iya amfani da ita ne kawai idan an yi biyan kuɗi a kowane lokaci daidai. Syntax din nasa yana da tsari mai zuwa:
= PRPLT (Bet; Lokaci; Q_per; Ps; [BS])
PMT
Mai aiki PMT tana lissafin adadin lokacin biyan kuɗi tare da wadatar riba. Ba kamar aikin da ya gabata ba, wannan ba shi da hujja "Lokaci". Amma ƙara magana takan ƙara "Nau'in", wanda ke nuna a farkon ko a ƙarshen lokacin, ya kamata a biya kuɗi. Sauran sigogi gaba daya sun zo daidai da dabara da suka gabata. Gaskiyar magana kamar haka:
= PLT (Bet; Call_per; Ps; [BS]; [Type])
PS
Tsarin tsari PS amfani da shi don ƙididdige darajar hannun jarin na yanzu. Wannan aikin kishiyar mai aiki ne PMT. Tana da daidai da ɗamarar maganganu iri ɗaya, amma maimakon takaddara mai ƙimar yanzu ("PS"), wanda a ƙididdigar zahiri, adadin lokacin biyan kuɗi ("Plt") Gaskiyar magana kamar haka:
= PS (Bet; Kol_per; Plt; [BS]; [Type])
NPV
Ana amfani da bayanin da ke gaba don ƙididdige abubuwan da ke ciki na yanzu ko na yanzu. Wannan aikin yana da muhawara guda biyu: ragin ragi da darajar biyan kuɗi ko ragi. Gaskiya ne, na biyu daga cikinsu na iya samun zaɓuɓɓuka 254 waɗanda ke wakiltar hanyoyin samun kuɗi. Sanarwar wannan dabara ita ce:
= NPV (Farashi; Darajar1; Darajar2; ...)
TAFIYA
Aiki TAFIYA yayi lissafin kudin ruwa akan kamfani. Hujjojin wannan ma'aikaci shine adadin kwanakin ("Lambar_), adadin biyan kuɗi na yau da kullun ("Plt"da kuma adadin biyan (Zab) Bugu da kari, akwai karin mahawara na zartarwar: darajar nan gaba ("Bs") kuma wata alama a farkon ko a ƙarshen lokacin za a biya kuɗi ("Nau'in") Ginin kalma yana ɗaukar wadannan hanyar:
= RATE (Kol_per; Plt; Ps [BS]; [Type])
Tasiri
Mai aiki Tasiri yayi lissafin ainihin (ko tasiri) ƙimar sha'awa. Wannan aikin yana da hujjoji biyu ne kawai: yawan lokuta a cikin shekara don amfani da sha'awa, kazalika da ƙididdigar mara iyaka. Ginin sa yana kama da haka:
= MAFARKI (Nom_Stand; Kol_per)
Munyi la'akari da kawai ayyukan shahararrun ayyukan kuɗi. Gabaɗaya, yawan masu aiki daga wannan rukunin ya ninka sau da yawa. Amma ko da tare da waɗannan misalai, inganci da sauƙi na amfani da waɗannan kayan aikin suna bayyane a bayyane, wanda ke sauƙaƙe ƙididdigar yawan amfani ga masu amfani.
