Momwe mungamasulire ID ya Apple

Njira yosunthira njira ndi chida chowerengera chomwe mungathetsere mavuto osiyanasiyana. Makamaka, nthawi zambiri amagwiritsidwa ntchito pokonzekera. Mu Excel, chida ichi chingagwiritsidwe ntchito kuthetsa ntchito zosiyanasiyana. Tiyeni tiwone momwe kayendedwe ka kusuntha kagwiritsidwa ntchito mu Excel.

Kugwiritsa ntchito pafupipafupi

Tanthauzo la njirayi ndikuti pothandizira pali kusintha kwazomwe zimakhazikitsidwa mndandanda wa masewera omwe amatha kusankhidwa kuti awonetsetse deta. Chida ichi chikugwiritsidwa ntchito powerengera zachuma, kukonzekera, pakuchita malonda pa malonda a malonda, ndi zina zotero. Ndi bwino kugwiritsa ntchito njira yopita ku Excel pogwiritsa ntchito chida champhamvu kwambiri chowerengetsera deta, chomwe chimatchedwa Pulojekiti yofufuza. Kuwonjezera apo, pazinthu izi, mungagwiritse ntchito ntchito yomangidwa mu Excel. MALANGIZO.

Njira 1: Kufufuza Package

Pulojekiti yofufuza ndi Excel yowonjezera yomwe imaletsedwa ndi chosasintha. Choyamba, choyamba, chiyenera kuchitapo kanthu.

1. Pitani ku tabu "Foni". Dinani pa chinthu. "Zosankha".



2. Muwindo lazomwe likuyambira, pitani ku gawo Zowonjezera. Pansi pazenera pamunda "Management" parameter ayenera kukhazikitsidwa Zowonjezeretsa Zolemba. Dinani pa batani "Pitani".



3. Timalowa muzenera zowonjezera. Ikani nkhuni pafupi ndi chinthucho "Analysis Package" ndipo dinani pa batani "Chabwino".

Pambuyo pake phukusi "Kusanthula Deta" inatsegulidwa, ndipo batani lofanana ndilo likuwonekera pa katoni mu tabu "Deta".

Tsopano tiyeni tiyang'ane momwe mungagwiritsire ntchito mwachindunji mphamvu za phukusi. Kusanthula deta kuti agwire ntchito yoyendetsa njira yogwiritsira ntchito. Tiyeni, malinga ndi chidziwitso cha ndalama zomwe tapeza pa nthawi 11 zapitazi, tidziwiratu mwezi wa 12. Kuti tichite izi, timagwiritsa ntchito tebulo yodzaza ndi deta ndi zipangizo. Pulojekiti yofufuza.

1. Pitani ku tabu "Deta" ndipo dinani pa batani "Kusanthula Deta"yomwe imayikidwa pa tepi ya zipangizo mu chipika "Kusanthula".



2. Mndandanda wa zipangizo zomwe zilipo Pulojekiti yofufuza. Timasankha kuchokera kwa iwo dzina "Kusuntha Avereji" ndipo dinani pa batani "Chabwino".



3. Window yolowera deta imayambika pofuna kusuntha maulosi ambiri.

   Kumunda "Nthawi yolowera" tchulani adiresi yamtunduwu, komwe ndalama zowonongeka pamwezi zilibe selo, deta yomwe iyenera kuwerengedwa.

   Kumunda "Nthawi" Tchulani nthawi yomwe mukugwiritsira ntchito pogwiritsa ntchito njira yosavuta. Choyamba, tiyeni tiyeseko kwa miyezi itatu, choncho tilowetseni "3".

   Kumunda "Kugawa Malo" muyenera kufotokozera mtundu wosasinthika pa pepala, kumene deta idzawonetsedwa pambuyo pa kukonzekera, zomwe ziyenera kukhala selo limodzi lalikulu kuposa nthawi yolowera.

   Onaninso bokosi pafupi "Zolakwika zofanana".

   Ngati ndi kotheka, mukhoza kuyang'ana bokosi pafupi "Kupanga" kuti zisonyezedwe, ngakhale ifeyo sikofunikira.

   Pambuyo pokonza zonse, pangani pa batani. "Chabwino".



4. Pulogalamuyi imasonyeza zotsatira za kukonza.



5. Tsopano tizitha kuwombera kwa miyezi iwiri kuti tisonyeze kuti zotsatira zake ndi zolondola. Pachifukwa ichi, timayendetsa chidachi kachiwiri. "Kusuntha Avereji" Pulojekiti yofufuza.

   Kumunda "Nthawi yolowera" Siyani zomwezo monga momwe zinalili kale.

   Kumunda "Nthawi" ikani chiwerengerocho "2".

   Kumunda "Kugawa Malo" timafotokozera adiresi ya mtundu wopanda kanthu, womwe, kachiwiri, uyenera kukhala selo imodzi yayikulu kuposa nthawi yolowera.

   Zotsala zosungidwa zasinthika. Pambuyo pake, dinani pa batani "Chabwino".



6. Pambuyo pake, pulogalamuyi ikuwerengera ndikuwonetsa zotsatira pawindo. Kuti mudziwe kuti ndi yani yomwe ili yoyenera, tiyenera kuyerekezera zolakwika. Chizindikiro ichi chaching'ono, chokwanira chokwanira cha zotsatira. Monga momwe mukuonera, chifukwa cha zolakwika zonse mu chiwerengero cha miyezi iwiri yolimbitsa pansi ndi zochepa kuposa miyezi itatu. Choncho, mtengo womwe unanenedweratu wa December ukhoza kuonedwa kukhala mtengo wowerengedwa ndi njira yoperekera nthawi yomaliza. Kwa ife, mtengo uwu ndi 990.4,000 rubles.

Njira 2: gwiritsani ntchito PAGESO ntchito

Mu Excel pali njira yina yogwiritsira ntchito njira yogwiritsira ntchito. Kuti mugwiritse ntchito, muyenera kugwiritsa ntchito ntchito zosiyanasiyana zomwe zimagwira ntchito, zomwe ndizofunika kwambiri MALANGIZO. Mwachitsanzo, tidzagwiritsa ntchito tebulo lomwelo la ndalama zogwirira ntchito monga momwe zinaliri poyamba.

Monga nthawi yotsiriza, tifunika kupanga nthawi zosavuta. Koma nthawi ino zochita sizidzakhala zokha. Lembani mtengo wapatali kwa awiri ndi miyezi itatu kuti muthe kuyerekezera zotsatira.

Choyamba, ife timayesa mtengo wapatali kwa nthawi ziwiri zapitazo pogwiritsa ntchito ntchitoyo MALANGIZO. Tikhoza kuchita izi kokha kuyambira mu March, chifukwa cha masiku otsogolera pali kusiyana kwamtengo wapatali.

1. Sankhani selo muzomwe zilibe kanthu mu mzere wa March. Kenako, dinani pazithunzi "Ikani ntchito"yomwe ili pafupi ndi bar.



2. Yatsegula zenera Oyang'anira ntchito. M'gululi "Zotsatira" kuyang'ana mtengo "SRZNACH"sankhani ndipo dinani pa batani "Chabwino".



3. Fesito yotsutsana ndi otsogolera imayambira. MALANGIZO. Mawu ake omveka ndi awa:

   = GAWO (nambala1; nambala2; ...)

   Mtsutso umodzi wokha ukufunika.

   Ifeyo, mmunda "Number1" Tiyenera kupereka chiyanjano kumtunda kumene ndalama za nthawi ziwiri zapitazo (January ndi February) zikuwonetsedwa. Ikani chotsekeracho m'munda ndikusankha maselo ofanana pa pepalalo m'ndandanda "Ndalama". Pambuyo pake, dinani pa batani "Chabwino".



4. Monga momwe mukuonera, zotsatira za kuwerengera zaka ziwiri zapitazo zinkawonetsedwa mu selo. Kuti tichite miyeso yofanana kwa miyezi yonse yotsala ya nthawiyi, tifunika kufotokozera fomu iyi ku maselo ena. Kuti tichite izi, timakhala chithunzithunzi m'makona a kumunsi a selo omwe ali ndi ntchito. Mtolowo umatembenuzidwa kukhala chizindikiro chodzaza, chomwe chikuwoneka ngati mtanda. Gwiritsani batani lamanzere la mchenga ndi kukokera pansi mpaka kumapeto kwa chigawocho.



5. Timapeza chiwerengero cha zotsatira za miyezi iwiri isanathe chaka chisanafike.



6. Tsopano sankhani selo muzotsatira zopanda kanthu mu mzere wa April. Ikani foni yotsutsa ntchito MALANGIZO mofananamo monga momwe tafotokozera kale. Kumunda "Number1" lowetsani makonzedwe a maselo omwe ali m'mbali "Ndalama" kuyambira Januari mpaka March. Kenaka dinani pa batani "Chabwino".



7. Pogwiritsira ntchito chikhomo chodzaza, lembani fomuyi kumasebulo apamwamba pansipa.



8. Kotero, ife tinkawerengera zoyenera. Tsopano, monga mmbuyomu, tidzasowa kuti tiwone mtundu wanji wa kusanthula bwino: ndi anti-aliasing mu miyezi iwiri kapena itatu. Kuti muchite izi, muwone kusiyana kwake ndi zizindikiro zina. Choyamba, ife tikuwerengera kutembenuka kwathunthu pogwiritsa ntchito ndondomeko ya Excel. ABS, m'malo mwa nambala zabwino kapena zoipa zimabwezeretsanso modulus. Mtengo uwu udzakhala wofanana ndi kusiyana pakati pa ndalama zenizeni kwa mwezi wosankhidwa ndi zomwe zanenedwa. Ikani chithunzithunzi m'khola yotsatira yopanda kanthu mu mzere wa May. Fuula Mlaliki Wachipangizo.



9. M'gululi "Masamu" sankhani dzina la ntchitoyi "Abs". Timakanikiza batani "Chabwino".



10. Ntchito yotsutsana zenera ikuyamba. ABS. M'munda umodzi "Nambala" tchulani kusiyana pakati pa zinthu za maselo muzitsulo "Ndalama" ndi "Miyezi iwiri" May. Kenaka dinani pa batani "Chabwino".



11. Pogwiritsira ntchito chikhomo chodzaza, timatsanzira ndondomekoyi ku mizere yonse patebulo kupyolera mu November.



12. Yerengani kuchuluka kwapadera kwa kupatuka kwachindunji kwa nthawi yonseyo pogwiritsa ntchito kale omwe tikudziŵa kale ntchito MALANGIZO.



13. Timachita chimodzimodzi kuti tipeze kutengeka kwathunthu kwa miyezi itatu. Choyamba timagwiritsa ntchito ntchitoyi ABS. Nthawi iyi yokha, timalingalira kusiyana pakati pa zomwe zili mu maselo ndi ndalama zomwe zilipo, zomwe zimagwiritsidwa ntchito pogwiritsa ntchito njira yogwiritsira ntchito miyezi itatu.



14. Kenaka, timawerengera deta yonse yosokonekera pogwiritsa ntchito ntchitoyi MALANGIZO.



15. Gawo lotsatira ndi kuwerengera kusokonekera kwache. Ndilofanana ndi chiŵerengero cha kutembenuka kwathunthu ku chizindikiro chenichenicho. Pofuna kupewa makhalidwe oipa, timagwiritsanso ntchito mwayi umene operekera amapereka ABS. Panthawiyi pogwiritsira ntchito ntchitoyi, timagawaniza kutengeka kwathunthu pakagwiritsa ntchito njira yogwiritsira ntchito miyezi iŵiri ndi ndalama zenizeni kwa mwezi wosankhidwa.



16. Koma kupotoka kwachiyanjano kumawonekera ngati peresenti. Choncho, sankhani zofunikira pa pepala, pita ku tab "Kunyumba"kumene mumagwiritsidwe ntchito "Nambala" Mu gawo lapadera lokonza mapangidwe, yikani mapepala apamwamba. Pambuyo pake, zotsatira za kuwerengera zosokonekera zikuwonetsedwa peresenti.



17. Timachita ntchito yofananamo powerengera zosiyana ndi deta pogwiritsira ntchito kufuula kwa miyezi itatu. Pokhapokha pa nkhaniyi, kuti tiwerenge ngati gawo, timagwiritsa ntchito gawo lina la tebulo, lomwe tiri nalo dzina "Abs. Kupita (3m)". Ndiye ife timamasulira mawerengedwe a nambala ku chiwerengero.



18. Pambuyo pake, timayesa chiwerengero chazomwe timakhala nazo pazitsulo zonsezi ndi zolakwika, monga momwe tisanagwiritsire ntchito ntchitoyi MALANGIZO. Popeza timatenga miyeso yeniyeni pa ntchitoyi ngati zifukwa za ntchitoyi, sitisowa kutembenuka kwina. Wogwiritsira ntchito pa pulogalamuyi amapereka zotsatirapo kale muzolowera.



19. Tsopano ife tabwera ku kuwerengera kwa kusemphana kwathunthu. Chizindikiro ichi chidzatilozera kufanizitsa bwino momwe chiwerengerochi chikuyendera pakagwiritsa ntchito anti-aliasing kwa miyezi iwiri ndi itatu. Kwa ife, kusokonezeka kwachikhalidwe kudzakhala kofanana ndi mizu yachitsulo cha chiwerengero cha mndandanda wa kusiyana kwa ndalama zenizeni ndi chiwerengero chakusuntha chogawanika ndi chiwerengero cha miyezi. Pofuna kuwerengera pulogalamuyi, tiyenera kugwiritsa ntchito ntchito zingapo, makamaka MALO, SUMMKRAVN ndi ACCOUNT. Mwachitsanzo, kuti muwerenge kusintha kwapadera mukamagwiritsira ntchito mzere wokonzetsa kwa miyezi iwiri mu Meyi, kwa ife, njirayi ikugwiritsidwa ntchito:

    = ROOT (SUMKVRAZN (B6: B12; C6: C12) / ACCOUNT (B6: B12))

    Timakopera izo kwa maselo ena a m'mbaliyo ndi kuwerengera kwa kupotoza kwachizolowezi kudzera mwa chizindikiro chodzaza.



20. Ife timachita ntchito yofananamo powerengera kuperewera kwayomwe kwa miyendo itatu yosuntha.



21. Pambuyo pake, timawerengera mtengo wa nthawi yonse ya zizindikiro izi, kugwiritsa ntchito ntchitoyi MALANGIZO.



22. Poyerekeza kuwerengera pogwiritsira ntchito njira yogwiritsira ntchito njira yochepetsera pa miyezi iwiri ndi itatu pogwiritsa ntchito zizindikiro monga kutembenuka kwathunthu, kutembenuka kwapadera ndi kupotoza koyenera, tingathe kunena mosapita m'mbali kuti miyezi iŵiri yokonzetsa imapereka zotsatira zowonjezereka kuposa kugwiritsira ntchito miyezi itatu kuyendetsa. Izi zikusonyezedwa ndi mfundo yakuti zizindikiro zomwe tazitchula pamwambazi ndi zosachepera miyezi itatu.



23. Choncho, ndalama zogwiritsidwa ntchito za kampaniyi mu December zidzakhala 990.4,000 rubles. Monga mukuonera, mtengo uwu ndi wofanana ndi umene tulandira, kupanga chiwerengero pogwiritsira ntchito zida Pulojekiti yofufuza.

Phunziro: Excel ntchito wizara

Tinawerengetsera zogwiritsira ntchito njira yogwiritsira ntchito njira ziwiri. Monga momwe mukuonera, njirayi ndi yosavuta kuchita pogwiritsira ntchito zipangizo. Pulojekiti yofufuza. Komabe, ena ogwiritsa ntchito samakhulupirira nthawi zonse mawerengedwe ndipo amasankha kugwiritsa ntchito mawerengedwe. MALANGIZO ndi ogwira ntchito ogwirizana kuti atsimikizire njira yodalirika. Ngakhale, ngati chirichonse chikuchitidwa molondola, pa zotsatira zake zotsatira za kuwerengera ziyenera kukhala zofanana.