Ithebula eli-enchant ku-Excel

Imvamisa, udinga ukubala umphumela wokugcina wenhlanganisela ehlukahlukene yedatha yokufaka. Ngakho-ke, umsebenzisi uzokwazi ukuhlola zonke izinketho zesenzo okungenzeka, akhethe lezo, umphumela wokusebenzisana kwawo wanelisa, futhi, ekugcineni, khetha inketho ephelele kakhulu. Ku-Excel, kunethuluzi elikhethekile lokwenza lo msebenzi - "Ithebula Ledatha" ("Ithebula Lokungena esikhundleni"). Ake sibheke ukuthi ungayisebenzisa kanjani ukwenza lezi zimo ezingenhla.

Ngaphezu kwalokho, kungaphawulwa ukuthi inani lokukhokha kwanyanga zonke ngo-12,5% ngonyaka otholwe ngenxa yokusetshenziswa kwetafula elithathelwanayo lilingana nenani elifanayo lenzalo esilitholile ngokusebenzisa umsebenzi we-PL. Lokhu kuphinde kufakazele ukunemba kokubalwa.

Ngemuva kokuhlaziya lolu hlu lwetafula, kufanele kushiwo ukuthi, njengoba sibona, kuphela ngesilinganiso se-9.5% ngonyaka kuvula isilinganiso esamukelekayo sokukhokha kwanyanga zonke (ngaphansi kwama-ruble angama-29,000).

Isifundo: Ukubalwa Kwenkokhelo Ye-Annuity e-Excel

Indlela 2: Usebenzisa ithuluzi elinokuhlukahluka okubili

Vele, ukuthola amabhange okwamanje, anikeza imalimboleko ngaphansi kwe-9.5% ngonyaka, kunzima kakhulu, uma kunjalo. Ngakho-ke, ake sibheke ukuthi yiziphi izinketho ezikhona ezingeni elamukelekayo lenkokhelo yanyanga zonke ekuhlanganisweni okuhlukahlukene kwezinye izinto eziguqukayo: ubukhulu bomzimba wemalimboleko nenkathi yesikweletu. Ngasikhathi sinye, inani lenzalo lizoshiywa lingashintshiwe (12,5%). Ekuxazululeni lo msebenzi, sizosiza ithuluzi eli- "Itafula ledatha" lisebenzisa okuguquguqukayo okubili.

1. I-Blacksmith entsha ye-tabular uhlu. Manje kumagama amakholomu kuzokhonjiswa isikhathi sesikweletu (kusuka eminyakeni emi-2 kuye kwayi-6 ezinyangeni ezimbalwa ngonyaka), futhi emigqeni - kusuka kuma-ruble wemalimboleko (kusuka ku-950,000 kuya ku-950000 ama-ruble anesinyathelo ama-ruble ayi-10,000). Kulokhu, isimo esiphoqelekile ukuthi iseli, lapho ifomula yokubala itholakala khona (esimweni sethu, i-PLT) yayisensimini yamagama emigqa namakholomu. Ngaphandle kokwenza lesi simo, ithuluzi ngeke lisebenze lapho usebenzisa okuguquguqukayo okubili.



2. Ngemuva kwalokho sabela lonke uhla lwetafula, kufaka phakathi igama lamakholomu, imigqa namaseli ngefomula ye-PLT. Iya kuthebhu "yedatha". Njengasesikhathini esedlule, chofoza ku "Ukuhlaziya" uma "", "ekusebenzeni" kwamathuluzi "amathuluzi. Uhlu oluvula, khetha "Ithebula Ledatha ...".



3. Iwindi le- "Data Table" liqala. Kulokhu, sizodinga zombili izinkambu. Kumanani "wokufakwa esikhundleni kumakholomu ensimini" endle, akhombisa izixhumanisi zeseli eliqukethe isikhathi semalimboleko kwidatha eyinhloko. Kumanani "wokufakwa esikhundleni senkambu", chaza ikheli leseli lamapharamitha omthombo aqukethe inani lomzimba wemalimboleko. Ngemuva kwayo yonke imininingwane ifakiwe. Ubumba enkombeni ethi "KULUNGILE".



4. Uhlelo lwenza ukubalwa futhi lugcwalisa ububanzi bedatha ye-tabular. Endleleni yokuhlangana kwemigqa namakholomu, manje usungabona ukuthi kuzoba yini inkokhelo yanyanga zonke, ngenani elihambisanayo lamaphesenti wonyaka kanye nesikhathi semalimboleko esibekiwe.



5. Njengoba ubona, amanani amaningi. Ukuxazulula eminye imisebenzi, kungahle kube nokuningi. Ngakho-ke, ukwenza ukukhishwa kwemiphumela kubukwe kakhudlwana futhi ngokushesha kunqume ukuthi imaphi amanani angazalisi isimo esibekiwe, ungasebenzisa amathuluzi wokubuka. Kuthu, kuzoba ukufometha okunemibandela. Sigqamisa wonke amanani wekhasi letafula, ngaphandle kwezihloko zemigqa namakholomu.



6. Sithuthela kuthebhu "Yasekhaya" kanye noClay "kwisithonjana" esinemibandela ". Itholakala kumathuluzi we- "Styles" block ku-Ribbon. Kumenyu yokuyeka, khetha into "imithetho yokwabiwa kwamaseli". Ohlwini olwengeziwe lokuchofoza esimweni esithi "Ngaphansi ...".



7. Ukulandela lokhu, kuvulwa iwindi lokufomatha elinemibandela. Ensimini yesobunxele, sicacisa inani elingaphansi kwamaseli azoqokonyiswa. Njengoba sikhumbula, sisenelisa yithi lapho inkokhelo yemalimboleko yanyanga zonke izoba ngama-ruble angama-29,000. Faka le nombolo. Ensimini efanele, kungenzeka ukuthi ukhethe umbala wokukhetha, yize ungakushiya ngokuzenzakalelayo. Ngemuva kwazo zonke izilungiselelo ezidingekayo zifakiwe, ubumba enkombeni ethi "KULUNGILE".



8. Ngemuva kwalokho, wonke amaseli, amanani ahambelana nesimo esichazwe ngenhla azoqokonyiswa ngombala.

Ngemuva kokuhlaziya uhlu lwethebula, ungenza iziphetho ezithile. Njengoba ubona, nge-Life Elensind Ebolekwe njengamanje (izinyanga ezingama-36) ukutshala imali ebalulwe ngenhla yenkokhelo yanyanga zonke, kudingeka sithathe imali mboleko engadluli ama-ruble angama-80,000,00, okungukuthi, angama-40,000 angahle ahlelwe ekuqaleni.

Uma sisahlose ukuthatha imali mboleko yama-ruble angama-900,000, isikhathi sesikweletu kufanele sibe yiminyaka emi-4 (izinyanga ezingama-48). Kulokhu kuphela, usayizi wenkokhelo yanyanga zonke ngeke udlule umngcele osunguliwe wama-ruble angama-29,000.

Ngakho-ke, ukusebenzisa lo mlungu wetafula nokuhlaziya "futhi" ngokumelene "ngakunye okukhethwa kukho, obolekayo angathatha isinqumo esithile ezimweni zokubolekwa ngokukhetha inketho yokuphendula kakhulu kusuka kukho konke okungenzeka.

Vele, ithebula lokufakwa esikhundleni lingasetshenziswa hhayi kuphela ukubala izinketho zesikweletu kuphela, kepha futhi nokuxazulula ubuningi beminye imisebenzi.

Isifundo: Ukufomatha okunemibandela ku-Excel

Ngokuvamile, kufanele kuqashelwe ukuthi ithebula lokufakwa esikhundleni yithuluzi eliwusizo kakhulu futhi elilula lokuthola umphumela ngezinhlanganisela ezahlukahlukene zokuhlukahluka. Ukufaka zombili ukufomatha okunemibandela ngasikhathi sinye ngayo, ngaphezu kwalokho, ungabona ngeso lengqondo imininingwane etholakele.