Indlela yokukhulula i-ID ye-iPhone ye-iPhone

Indlela yokuhamba ehamba phambili iyithuluzi lokubala ongakwazi ukuxazulula izinhlobonhlobo zezinkinga. Ngokuyinhloko, kuvame ukusetshenziselwa ukubikezela. Ku-Excel, leli thuluzi lingasetshenziswa futhi ukuxazulula imisebenzi ehlukahlukene. Ake sibone ukuthi isilinganiso esithintayo sisetshenziswa kanjani ku-Excel.

Isicelo sokulinganisa okuhambayo

Incazelo yale ndlela yukuthi ngosizo lwayo kukhona ukuguqulwa kwamagugu ashukumisayo ngokuphelele wechungechunge olukhethiwe kuya kumazinga we-arithmetic okwesikhathi esithile ngokushelela idatha. Leli thuluzi lisetshenziselwa ukubalwa kwezomnotho, ukubikezela, ngenqubo yokuhweba kwi-stock exchange, njll. Kungcono ukusebenzisa indlela Yokuhamba Ephakathi kwe-Excel ngosizo lensiza enamandla kunayo yonke yokucubungula idatha, okubizwa ngokuthi Iphakethe lokuhlaziya. Ngaphezu kwalokho, ngalezi zinhloso, ungasebenzisa umsebenzi wokwakhiwa kwe-Excel. ISAVERAGE.

Indlela 1: Iphakheji yokuhlaziya

Iphakethe lokuhlaziya i-Excel ukungena okukhutshaziwe ngokuzenzakalelayo. Ngakho-ke, okokuqala, kuyadingeka ukuyivumela.

  1. Hambisa kuthebhu "Ifayela". Chofoza entweni. "Izinketho".
  2. Kuwindi yemingcele eqala, iya esigabeni Engeza-ons. Ngaphansi kwefasitela ensimini "Ukuphathwa" ipharamitha kufanele isethwe Faka i-Excel. Chofoza inkinobho "Hamba".
  3. Sifaka efasiteleni lesengezo. Beka uphawu eduze kwento "I-Package Analysis" bese uchofoza inkinobho "Kulungile".

Ngemuva kwalokhu iphakheji lesenzo "Ukuhlaziywa kwedatha" icushiwe, futhi inkinobho ehambelanayo ibonakala ku-ribbon kuthebhu "Idatha".

Manje ake sibheke ukuthi ungasebenzisa kanjani ngokuqondile amandla okupakethe. Ukuhlaziywa kwedatha ukuze usebenze ngendlela yokuhamba ehambayo. Ake, ngesisekelo solwazi ngemali engenayo eqinile esikhathini esiyi-11 esedlule, yenza isibikezelo ngenyanga yeshumi nambili. Ukwenza lokhu, sisebenzisa itafula eligcwele idatha namathuluzi. Iphakethe lokuhlaziya.

  1. Iya kuthebhu "Idatha" bese uchofoza inkinobho "Ukuhlaziywa kwedatha"okuyinto efakwe kuthebhu yamathuluzi ebhodini "Ukuhlaziywa".
  2. Uhlu lwamathuluzi atholakalayo Iphakethe lokuhlaziya. Sakhetha kubo igama "Ukuhambisa Isilinganiso" bese uchofoza inkinobho "Kulungile".
  3. Iwindi lokungenisa idatha liqaliswe ukuhambisa ukubikezelwa kwesilinganiso.

    Ensimini "Isikhathi sokufaka" cacisa ikheli lebanga, lapho inani lemali ngenyanga likhona ngaphandle kweseli, idatha okufanele ibalwe.

    Ensimini "Isikhathi" ucacise isikhathi sokucubungula amagugu usebenzisa indlela epholisayo. Ukuze uqale, ake sibeke inani elibusayo ezinyangeni ezintathu, ngakho-ke faka isibalo "3".

    Ensimini "Isikhala sokuPhuma" udinga ukucacisa ibanga elingenalutho elingenalutho kushidi, lapho idatha izoboniswa ngemva kokucubungula, okumele kube yinye iseli elikhulu kunesikhawu sokufaka.

    Futhi hlola ibhokisi eliseduze "Amaphutha ajwayelekile".

    Uma kunesidingo, ungabheka ibhokisi eliseduze "Ukupaka" ukuze kuboniswe ukuboniswa, nakuba kunjalo kithi akudingekile.

    Ngemuva kokuthi zonke izilungiselelo zenziwe, chofoza inkinobho. "Kulungile".

  4. Uhlelo lubonisa umphumela wokucubungula.
  5. Manje sizokwenzela ukululaza isikhathi sezinyanga ezimbili ukuze sibonise ukuthi yimiphi imiphumela eyilungile. Ngalesi sizathu, siphinde sisebenzise ithuluzi. "Ukuhambisa Isilinganiso" Iphakethe lokuhlaziya.

    Ensimini "Isikhathi sokufaka" Shiya izindinganiso ezifanayo njengalesi simo esedlule.

    Ensimini "Isikhathi" ufake inombolo "2".

    Ensimini "Isikhala sokuPhuma" sichaza ikheli lebanga elisha elingenalutho, okuyinto, futhi, kumele libe yinye iseli elikhulu kunesikhawu sokufaka.

    Amasethingi asele ashiywe angashintshi. Emva kwalokho, chofoza inkinobho "Kulungile".

  6. Ukulandela lokhu, uhlelo lubala futhi lubonise umphumela esikrinini. Ukuze unqume ukuthi yiyiphi imodeli emibili enembile, kudingeka siqhathanise amaphutha ajwayelekile. Okuncane kule nkhomba, kuphakama amathuba okunemba komphumela. Njengoba ubona, ngoba zonke izindinganiso zephutha elijwayelekile ekubalweni kwezinyanga ezimbili ezihambayo zingaphansi kwesibalo esifanayo ezinyangeni ezingu-3. Ngakho-ke, inani elibikezelwe leDisemba lingabhekwa njengenani elibalwe yindlela yokwehlisa isikhathi sokugcina. Esimweni sethu, le nzuzo yi-rubber 990.4 eyizinkulungwane.

Indlela 2: sebenzisa umsebenzi we-AVERAGE

Ku-Excel kunenye indlela yokusebenzisa indlela yokuhamba ehambayo. Ukuze ulisebenzise, ​​udinga ukusebenzisa inombolo yenqubo ejwayelekile yezinhlelo, okuyisisekelo salo ngenjongo yethu ISAVERAGE. Isibonelo, sizosebenzisa ithebula elifanayo lemali engenayo yebhizinisi njengasekuqaleni.

Njengesikhathi sokugcina, kuzodingeka sakha uchungechunge lwezikhathi ezihlelwe kahle. Kodwa manje lezi zenzo ngeke zizenzeke ngokuzenzekelayo. Bala inani elilinganiselwe kuzo zonke izinyanga ezimbili nezinyanga ezintathu ukuze ukwazi ukuqhathanisa imiphumela.

Okokuqala, sibala amanani ajwayelekile ezinkathini ezimbili zangaphambilini esebenzisa umsebenzi ISAVERAGE. Singakwenza lokhu kuqala kuphela ngo-Mashi, ngoba ngezinsuku ezedlule kukhona ukuphumula kwamagugu.

  1. Khetha iseli kukholomu engenalutho emgqeni ngo-Mashi. Okulandelayo, chofoza isithonjana "Faka umsebenzi"okuyinto eseduze ne-bar yefomula.
  2. Iwindi elisebenzayo Amakhosi omsebenzi. Esikhathini "Isitatimende" ngifuna ukubaluleka "SRZNACH"ukhethe bese uchofoza inkinobho "Kulungile".
  3. Iwindi lempikiswano ye-Operator iqala. ISAVERAGE. I-syntax yakhe ilandelayo:

    = I-AVERAGE (inombolo1; inombolo2; ...)

    Kudingeka ukuphikisana okukodwa kuphela.

    Esikhathini sethu, ensimini "Number1" kufanele sinikeze isixhumanisi ebangeni lapho inzuzo yezikhathi ezimbili zangaphambilini (ngoJanuwari noFebruwari) ibonisiwe. Setha isikhangiso endle bese ukhetha amaseli ahambelana neshidi kukholomu "Inzuzo". Emva kwalokho, chofoza inkinobho "Kulungile".

  4. Njengoba ubona, umphumela wokubala isilinganiso sezikhathi ezimbili zangaphambilini uboniswe esitokisini. Ukuze wenze izibalo ezifanayo kuzo zonke izinyanga ezisele zesikhathi, sidinga ukukopisha leli fomu kwamanye amaseli. Ukuze senze lokhu, siba isikhombisi ekhoneni elingezansi elingakwesokudla seligcini eliqukethe umsebenzi. I-cursor iguqulwa kumaka wokugcwalisa, okubukeka njengesiphambano. Bamba inkinobho yesinxele yesinxele bese uyihudula phansi kuze kube sekugcineni kwekholomu.
  5. Sithola ukubalwa kwemiphumela ejwayelekile ezinyangeni ezimbili ezedlule ngaphambi kokuphela konyaka.
  6. Manje ukhethe iseli kukholomu elandelayo engenalutho emgqeni ngo-Ephreli. Shayela ifasitela lokuphikisana lomsebenzi ISAVERAGE ngendlela efanayo echazwe ngaphambilini. Ensimini "Number1" faka izixhumanisi zamaseli ekholomu "Inzuzo" kusuka ngoJanuwari kuya ku-Mashi. Bese uchofoza inkinobho "Kulungile".
  7. Ukusebenzisa uphawu lokugcwalisa, kopisha ifomula kumaseli etafula ngezansi.
  8. Ngakho, sibalwa amanani. Manje, njengasesikhathini esidlule, kuzodingeka sibone ukuthi yiluphi uhlobo lokuhlaziywa olungcono: nge-anti-aliasing ezinyangeni ezimbili noma ezintathu. Ukwenza lokhu, balala ukuphambana okujwayelekile kanye nezinye izinkomba. Okokuqala, sibala ukuphambuka okuphelele ngokusebenzisa umsebenzi ojwayelekile we-Excel. ABS, okuyinto esikhundleni sezinombolo eziqondile noma ezingalungile ezibuyisela i-modulus yazo. Leli nani lizolingana nomehluko phakathi kwemali engenayo yenyanga ekhethiwe kanye nokubikezela. Setha isikhombisi kukholomu elandelayo engenalutho emgqeni ngoMeyi. Shayela Umsebenzi weWebhu.
  9. Esikhathini "Isibalo" khetha igama lomsebenzi "Abs". Sicindezela inkinobho "Kulungile".
  10. Iwindi lempikiswano yokusebenza iqala. ABS. Ensimini eyodwa "Inombolo" ucacise umehluko phakathi kokuqukethwe kwamaseli kukholomu "Inzuzo" futhi "Izinyanga ezimbili" ngoMeyi. Bese uchofoza inkinobho "Kulungile".
  11. Ukusebenzisa uphawu lokugcwalisa, sikopisha leli fomula kuwo wonke imigqa etafuleni ngoNovemba kubandakanya.
  12. Bala inani elilinganiselwe lokuphambuka okuphelele kwenkathi yonke usebenzisa i-familiar kakade kithi ISAVERAGE.
  13. Senza inqubo efanayo ukuze sibone ukuphambuka okuphelele kwe-sliding eyodwa izinyanga ezingu-3. Sisebenzisa kuqala umsebenzi ABS. Kuphela lesi sikhathi, sibheka umehluko phakathi kokuqukethwe kwamaseli ngenzuzo yangempela kanye nokuhlelwa, kubalwa ngokusebenzisa indlela ehambayo yokuhamba ngezinyanga ezintathu.
  14. Okulandelayo, sibala isilinganiso sazo zonke idatha yokuphambuka ngokuphelele usebenzisa umsebenzi ISAVERAGE.
  15. Isinyathelo esilandelayo ukubala ukuphambuka okuhlobene. Ilingana nesilinganiso sokuphambuka okuphelele kuya kwikhombisi yangempela. Ukuze sigweme amagugu amabi, saphinda sisebenzise amathuba ohlinzekiwe opharetha ABS. Ngalesi sikhathi besebenzisa lo msebenzi, sihlukanisa inani lokuphambukela ngokuphelele uma usebenzisa indlela ehambayo yokuhamba ngezinyanga ezimbili ngenkokhelo yangempela yenyanga ekhethiwe.
  16. Kodwa ukuphambuka okuhambisanayo kuvame ukuboniswa njengephesenti. Ngakho-ke, khetha ibanga elifanele kushidi, iya kuthebhu "Ikhaya"lapho kunamathuluzi okuvimba "Inombolo" Endaweni ekhethekile yokufometha, setha isakhiwo sephesenti. Emva kwalokho, umphumela wokubala ukuphambuka okuhambisanayo kuboniswa ngamaphesenti.
  17. Senza umsebenzi ofanayo wokubala ukuphambana okuhambisanayo nedatha besebenzisa ukushelela izinyanga ezingu-3. Kuphela kulokhu, ukubala njengesahluko, sisebenzisa enye ikholomu yetafula, esinegama "I-Abs. Off (3m)". Khona-ke sihumusha amanani wezinombolo kumaphesenti.
  18. Ngemuva kwalokho, sibala amanani ajwayelekile kuwo wonke amakholomu aneziphambano ezihambelanayo, njengaphambi kokusebenzisa le njongo umsebenzi ISAVERAGE. Njengoba sithatha amanani wephesenti ngomsebenzi njengezingxabano zomsebenzi, asidingi ukuguqulwa okungeziwe. Opharetha okukhiphayo unikeza umphumela kakade kufomethi yephesenti.
  19. Manje siza ekubalweni kokuphambuka okujwayelekile. Lesi sibonakaliso sizosisiza ukuba siqhathanise ngokucacile ikhwalithi yokubala uma usebenzisa i-anti-aliasing izinyanga ezimbili nezinyanga ezintathu. Esikhathini sethu, ukuphambuka okujwayelekile kuzolingana nomsuka wesikwele isamba sezikwele zohlu lwemali engenayo kanye nesilinganiso esihambayo esihlukaniswe ngenani lezinyanga. Ukuze senze isibalo ohlelweni, kufanele sisebenzise inamba yemisebenzi, ikakhulukazi I-ROOT, SUMMKRAVN futhi ACCOUNT. Isibonelo, ukubala ukuphambuka okujwayelekile uma usebenzisa umugqa wokuklabhula izinyanga ezimbili ngoMeyi, kithi, ifomula elilandelayo lizosetshenziswa:

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

    Siyikopisha kwamanye amaseli wekholomu ngokubala kokuphambuka okujwayelekile ngokusebenzisa uphawu lokugcwalisa.

  20. Senza umsebenzi ofanayo wokubala ukuphambana okujwayelekile ukuze isilinganiso esihambayo sezinyanga ezingu-3.
  21. Emva kwalokho, sibala inani elilinganiselwe yesikhathi sonke kokubili lezi zinkomba, ukusebenzisa umsebenzi ISAVERAGE.
  22. Ngemva kokuqhathanisa izibalo ngokusebenzisa indlela yokuhamba ehambayo ngokushelela izinyanga ezimbili no-3 besebenzisa izinkomba ezinjengokuphambuka okuphelele, ukuphambuka kwesihlobo nokuphambuka okujwayelekile, singasho ngokuphepha ukuthi izinyanga ezimbili ukugqamisa kunika imiphumela enokwethenjelwa kunokuba isebenzise izinyanga ezintathu. Lokhu kuboniswa yiqiniso lokuthi izinkomba ezingenhla ezilinganisweni zenyanga ezimbili ezihambayo zingaphansi kwezinyanga ezintathu.
  23. Ngakho-ke, imali engenayo yenkampani ngoDisemba izoba yi-ruble angu-990.4 ayizinkulungwane. Njengoba ungabona, le nzuzo ifana neyayithola, okwenza ukubala ngokusebenzisa amathuluzi Iphakethe lokuhlaziya.

Isifundo: I-Excel umsebenzi wizard

Sasibala isibikezelo sisebenzisa indlela yokuhamba ehamba phambili ngezindlela ezimbili. Njengoba ungabona, le nqubo kulula ukwenza ngamathuluzi. Iphakethe lokuhlaziya. Nokho, abanye abasebenzisi abazithembi njalo ukubala okuzenzakalelayo futhi bakhetha ukusebenzisa umsebenzi wokubala. ISAVERAGE kanye nezinhlelo zokusebenza ezihlobene ukuqinisekisa ukukhetha okuthembekile kakhulu. Noma, uma konke kwenziwa ngendlela efanele, ekuphumeni umphumela wezibalo kufanele ufanelwe ngokuphelele.