Momwe mungawonjezere chithunzi ku mbiri ya Instagram

Microsoft Excel si chabe editor spreadsheet, koma komanso ntchito yamphamvu kwambiri yowerengera zosiyanasiyana. Chotsatirachi, chidutswa ichi chinabwera ndi zinthu zomangidwa. Pothandizidwa ndi ntchito zina (ogwira ntchito), n'zotheka kufotokoza ngakhale zikhalidwe za kuwerengera, zomwe zimatchedwa zoyenera. Tiyeni tiphunzire zambiri za momwe mungagwiritsire ntchito pamene mukugwira ntchito ku Excel.

Kugwiritsa ntchito njira

Zolinga ndizo zomwe pulogalamu imachita zinthu zina. Zimagwiritsidwa ntchito zosiyanasiyana zosiyanasiyana. Dzina lawo nthawi zambiri limakhala ndi mawu "NGATI". Gulu ili la opaleshoni, choyamba, liyenera kutchulidwa COUNTES, COUNTERSILN, Miyeso, SUMMESLIMN. Kuwonjezera pa ogwira ntchito opangidwa, zofunikira mu Excel zimagwiritsidwanso ntchito mu maonekedwe ovomerezeka. Taganizirani momwe amagwiritsira ntchito pogwiritsa ntchito zipangizo zosiyanasiyana za pulogalamuyi pang'onopang'ono.

COUNTES

Ntchito yaikulu ya wogwira ntchito COUNTESomwe ali gulu la owerengetsera, ndiloloĊµerengedwa ndi machitidwe osiyana a maselo omwe amakwaniritsa chikhalidwe china. Mawu ake omasulira ndi awa:

= COUNTERS (muyeso; ndondomeko)

Monga mukuonera, wogwiritsira ntchitoyi ali ndi zifukwa ziwiri. "Mtundu" ndi adiresi ya zinthu zambiri pa pepala momwe chiwerengerocho chiyenera kupangidwa.

"Criterion" - iyi ndi ndemanga yomwe imapangitsa kuti maselo a malo omwe adalonjezedwe azikhala nawo kuti athe kuwerengedwa. Monga choyimira, chiwerengero cha chiwerengero, malemba, kapena kutchulidwa kwa selo yomwe ili ndi chigwiritsidwe ntchito ingagwiritsidwe ntchito. Pachifukwa ichi, kuti muwonetsere zoyenera, mungagwiritse ntchito zotsatirazi: "<" ("zochepa"), ">" ("zambiri"), "=" (zofanana), "" ("osati ofanana"). Mwachitsanzo, ngati mumatchula mawuwo "<50", ndiye chiwerengero chidzaganizira zokhazokha zomwe zikufotokozedwa ndi kutsutsana "Mtundu"momwe muli ziwerengero zosachepera 50. Kugwiritsa ntchito malembawa kufotokozera magawowo kudzakhala koyenera pazochita zina zonse, zomwe zidzakambidwe mu phunziro ili m'munsimu.

Ndipo tsopano tiwone chitsanzo chapadera cha momwe wogwiritsira ntchitoyo amagwira ntchito.

Kotero, pali tebulo yosonyeza ndalama za masitolo asanu pa sabata. Tifunika kupeza chiwerengero cha masiku panthawiyi, pomwe ndalama zogulitsa 2 zosungirako zowonjezera zoposa 15,000.

  1. Sankhani pepala lolemba momwe woyendetsa adzatulutsa zotsatira za kuwerengera. Pambuyo pake dinani pazithunzi "Ikani ntchito".

  2. Yambani Oyang'anira ntchito. Sungani kuti musiye "Zotsatira". Kumeneko timapeza ndikusankha dzina "COUNTES". Ndiye muyenera kudinkhani pa batani "Chabwino".

  3. Kutsegulira kwawindo lazitsulo la woyang'anira pamwambapa. Kumunda "Mtundu" onetsani malo a maselo omwe chiĊµerengerocho chidzapangidwe. Kwa ife, sankhani zomwe zili mu mzerewu. "Gulani 2"momwe zikhalidwe za patsiku zimapezeka. Ikani cholozera mmalo mwachindunji, ndipo mutagwiritsa ntchito batani lamanzere, sankhani zofananazo mu tebulo. Adilesi ya osankhidwayo ikuwonekera pawindo.

    Mu gawo lotsatira "Criterion" ndikufunikira kusankha padera pokhapokha. Kwa ife, muyenera kuwerengera zokhazokha patebulo limene mtengo ulipo kuposa 15,000. Choncho, pogwiritsa ntchito kambokosi, timalowetsa mafotokozedwe kumtundu womwewo. ">15000".

    Zonsezi zitatha, dinani pa batani. "Chabwino".

  4. Pulogalamuyi ikuwerengera ndikuwonetsa zotsatira mu gawo la pepala limene lasankhidwa lisanakhazikitsidwe. Oyang'anira ntchito. Monga momwe mukuwonera, pamapeto pake zotsatira zake zili zofanana ndi nambala 5. Izi zikutanthauza kuti muyiyi yosankhidwa mu maselo asanu mulipo zoposa 15,000. Izi ndizo, tikhoza kunena kuti kusungira 2 masiku asanu kuchokera pazofukufuku zisanu ndi ziwiri, ndalamazo zinapitirira 15,000 rubles.

PHUNZIRO: Mbuye wa Ntchito mu Excel

COUNTERSILN

Ntchito yotsatira yomwe imayendetsera zoyenera ndiyo COUNTERSILN. Iyenso ndi ya gulu la owerengetsera. Ntchito COUNTERSILN ndi kuwerengera maselo m'magulu omwe atchulidwa omwe amakwaniritsa zochitika zina. Ndizoona kuti mungathe kufotokozera chimodzi, koma magawo angapo, ndipo mumasiyanitsa woyendetsa kuchokera kumbuyo. Mawu omasulira ndi awa:

= DZIKO (condition_range1; chikhalidwe1; condition_range2; chikhalidwe2; ...)

"Chikhalidwe Chachikhalidwe" ali ofanana ndi kutsutsana koyamba kwa mawu apitalo. Ndiko kulumikizana ndi dera lomwe maselo omwe amakumana ndi zikhalidwe zomwe adziwerengera adzawerengedwa. Wogwiritsa ntchitoyi amakulolani kuti mutchule malo angapo nthawi imodzi.

"Mkhalidwe" ndilo lingaliro lomwe limatsimikizira kuti ndi zinthu ziti zomwe zimayikidwa pazomwe ziwerengedwere zidzawerengedwera, ndi zomwe sizidzatero. Dera lililonse la deta likuyenera kufotokozera chikhalidwe chokha, ngakhale chikugwirizana. Ndikofunika kuti magulu onse ogwiritsidwa ntchito monga malo ovomerezeka ali ndi mizere yofanana ndi mizere.

Kuti muike magawo angapo a dera lomwelo la deta, mwachitsanzo, kuti muwerenge chiwerengero cha maselo omwe amtengo wapatali kuposa nambala inayake koma osachepera nambala ina, aligwiritsiridwa ntchito: "Chikhalidwe Chachikhalidwe" Nthawi zingapo zimatanthauzira zofanana zomwezo. Koma nthawi imodzimodzimodzi ndi mfundo zofanana "Mkhalidwe" ayenera kufotokozera zosiyana.

Pogwiritsa ntchito chitsanzo cha tebulo lomwelo ndi malonda a masabata, tiyeni tiwone momwe zimagwirira ntchito. Tifunika kupeza chiwerengero cha masiku a sabata pamene ndalama zomwe zili muzipinda zonse zomwe zapezeka zimakhala zovomerezeka. Miyezo ya ndalama ndi izi:

  • Sungani ma ruble 1 - 14,000;
  • Sungani 2 - 15,000 rubles;
  • Sungani ma ruble 3 - 24,000;
  • Sungani mabakiteriya 4 - 11,000;
  • Sungani ma ruble 5 - 32,000.
  1. Kuti muchite ntchito yomwe ili pamwambapa, sankhani zinthu zomwe zili patsamba lamasewero ndi chithunzithunzi chomwe zotsatira za kusinthidwa kwa deta ziwonetsedwe. COUNTERSILN. Timakani pa chithunzi "Ikani ntchito".

  2. Kupita Mlaliki Wachipangizo, kusunthira kuti ibwezere kachiwiri "Zotsatira". Mndandanda uyenera kupeza dzina COUNTERSILN ndipo mupange kusankha. Pambuyo pochita zochitikazo, muyenera kudina pa batani. "Chabwino".

  3. Pambuyo pochita masinthidwewa pamwambapa, zenera likutsuka. COUNTERSILN.

    Kumunda "Chikhalidwe Chachigawo1" muyenera kulowa mu adiresi ya mzere momwe deta yomwe imagulitsira Masitolo 1 a sabata. Kuti muchite izi, ikani malonda mmunda ndikusankha mzere woyenera pa tebulo. Makonzedwe amawonetsedwa pawindo.

    Poganizira kuti kusungirako 1 tsiku ndi tsiku phindu la ndalama ndi 14,000 rubles, ndiye kumunda "Chikhalidwe 1" lowetsani mawu ">14000".

    M'minda "Chikhalidwe Range2 (3,4,5)" Zogwirizanitsa za mizere ndi mapepala a mlungu ndi mlungu mwasungidwe ka Store 2, Sungani 3, Sungani 4 ndi Kusunga 5 ziyenera kulowetsedwa. Timachita zomwezo mogwirizana ndi ndondomeko yomweyi monga kutsutsana koyamba kwa gulu lino.

    M'minda "Chikhalidwe2", "Chikhalidwe3", "Chikhalidwe4" ndi "Chikhalidwe5" timabweretsa zofunikira ">15000", ">24000", ">11000" ndi ">32000". Monga momwe mungaganizire, mfundo izi zimagwirizana ndi nthawi ya ndalama, kuposa momwe zimagwirira ntchito yosungiramo katundu.

    Mutatha kulumikiza deta yonse (10 minda yonse), dinani pa batani "Chabwino".

  4. Pulogalamuyi ikuwerengera ndikuwonetsa zotsatira pawindo. Monga mukuonera, ndilofanana ndi nambala 3. Izi zikutanthauza kuti mu masiku atatu kuchokera sabata losanthula, ndalama zomwe zili m'mabwalo onse zimadutsa chiwerengero chawo.

Tsopano tiyeni tisinthe ntchito pang'ono. Tiyenera kuwerengetsera chiwerengero cha masiku omwe Shopu 1 inalandira ndalama zoposa 14,000 rubles, koma rubles zosakwana 17,000.

  1. Ikani cholozera mmalo momwe chiwonetserocho chiwonetsedwera pa pepala la zotsatira zowerengera. Timakani pa chithunzi "Ikani ntchito" pa malo ogwira ntchito pa pepala.

  2. Popeza posachedwapa tinagwiritsa ntchito njirayi COUNTERSILN, tsopano sikoyenera kupita ku gululo "Zotsatira" Oyang'anira ntchito. Dzina la woyendetsa ntchitoyi lingapezeke m'gululi "Posachedwapa Anagwiritsidwa Ntchito". Sankhani ndipo dinani pa batani. "Chabwino".

  3. Zenera lazitsulo zomwe tidziwa kale zimatsegula. COUNTERSILN. Ikani cholozera mmunda "Chikhalidwe Chachigawo1" ndipo, mutagwiritsa ntchito batani lamanzere, sankhani maselo onse omwe ali ndi mapepala a tsiku la Masitolo 1. Iwo ali mu mzere, womwe umatchedwa "Gulani 1". Pambuyo pake, makonzedwe a malo omwe atchulidwa adzawonetsedwa pawindo.

    Chotsatira, ikani cholozera mmunda "Chikhalidwe1". Pano tikuyenera kufotokoza malire omwe ali m'maselo omwe angakhale nawo mu mawerengedwe. Tchulani mawu ">14000".

    Kumunda "Chikhalidwe Chachiwiri" ife timalowa mu adiresi yomweyo momwe ife tinalowera mmunda "Chikhalidwe Chachigawo1", ndiko kuti, tilowetsanso ma makonzedwe a maselo omwe ali ndi ndalama kuchokera pa chiyambi choyamba.

    Kumunda "Chikhalidwe2" onetsani malire apamwamba a kusankha: "<17000".

    Pambuyo pazochitika zonse zomwe zafotokozedwa, dinani pa batani. "Chabwino".

  4. Pulogalamuyi imapereka zotsatira za kuwerengera. Monga momwe tikuonera, mtengo wonse ndi 5. Izi zikutanthauza kuti mu masiku asanu mwa asanu ndi awiriwo, ophunzira a sitolo yoyamba analipo kuyambira 14,000 mpaka 17,000 rubles.

Miyeso

Wogwiritsira ntchito wina yemwe amagwiritsa ntchito njira ndi Miyeso. Mosiyana ndi ntchito zam'mbuyomu, izo zimatanthawuza masamu a masamu. Ntchito yake ndi kuwonjezera deta mu maselo omwe amakumana ndi vuto linalake. Chidule chake ndi:

= SUMMERS (muyeso; ndondomeko; [sum_range]]

Kutsutsana "Mtundu" akulozera kumalo a maselo omwe adzayang'aniridwa kuti azitsatira. Ndipotu, zimakhazikitsidwa chimodzimodzi monga kutsutsana kwa ntchito yomweyi. COUNTES.

"Criterion" - ndi mtsutso wovomerezeka womwe umapanga chisankho chosankha maselo kuchokera ku deta yolongosoka kuti awonjezere. Mfundo zoyenera kufanana ndi zomwe zidafanana ndi oyang'anira apitalo, zomwe tinkaziganizira ndizimenezi.

"Chiwerengero cha Kusambira" - Izi ndizofuna kukambirana. Ikuwonetseratu dera lapadera la mndandanda momwe chidulecho chidzachitikire. Ngati muzisiya ndipo simunanenenso, ndiye kuti mwachindunji ndikulingalira kuti ndi ofanana ndi kufunika kokangana "Mtundu".

Tsopano, monga nthawizonse, taganizirani momwe ntchitoyi ikugwirira ntchito. Kuchokera pa tebulo lomwelo, ife tikuyang'anizana ndi ntchito yowerengera kuchuluka kwa ndalama mu Shopu 1 pa nthawi kuyambira 11.03.2017.

  1. Sankhani selo limene zotsatira zake zidzawonetsedwa. Dinani pazithunzi "Ikani ntchito".

  2. Kupita Mlaliki Wachipangizo mu block "Masamu" pezani ndi kusankha dzina "SUMMESLI". Timasankha pa batani "Chabwino".

  3. Ntchito yotsutsana zenera ikuyamba. Miyeso. Lili ndi minda itatu yomwe ikugwirizana ndi zotsutsana za wotchulidwa.

    Kumunda "Mtundu" ife timalowa m'dera la tebulo momwe zikhalidwe zomwe zimayang'aniridwa kuti zigwirizane ndi zikhalidwe zidzakhalapo. Momwe timachitira izi zidzakhala mndandanda wamadontho. Ikani cholozera m'munda uno ndi kusankha maselo onse okhala ndi masiku.

    Popeza tikufunikira kuwonjezera ndalama kuchokera pa March 11, ndiye kumunda "Criterion" timayendetsa mtengo ">10.03.2017".

    Kumunda "Chiwerengero cha Kusambira" muyenera kufotokoza dera lanu, zomwe zimayendera mogwirizana ndi ndondomeko zomwe zafotokozedwa zidzatchulidwa. Kwa ife, izi ndizofunika zamtengo wapatali. "Shop1". Sankhani zofanana zowonjezera pepala.

    Pambuyo pa kuyambitsidwa kwa deta zonse, tsambani pa batani "Chabwino".

  4. Pambuyo pake, zotsatira za ntchito yothandizira deta zidzasonyezedwa mu gawo lapaderalo la worksheet. Miyeso. Kwa ife, ndi ofanana ndi 47921.53. Izi zikutanthauza kuti kuyambira pa 11.03.2017, mpaka kumapeto kwa nyengo yowerengedwera, ndalama zonse zogulitsa 1 zinkakhala ma ruble 47,921.53.

SUMMESLIMN

Tidzatsiriza kafukufuku wa ogwira ntchito omwe amagwiritsa ntchito zoyenera, poyang'ana ntchitoyi SUMMESLIMN. Ntchito ya masamuyi ndikutanthauzira zomwe zili pa tebulo, zosankhidwa malinga ndi magawo angapo. Mphatikiti wa wogwiritsira ntchitoyi ndi:

= SUMMESLIMN (sum_range_range; condition_range1; chikhalidwe1; chikhalidwe_range2; chikhalidwe2; ...)

"Chiwerengero cha Kusambira" - Iyi ndi mtsutso womwe ndi adiresi ya gulu, maselo omwe, mogwirizana ndi chikhalidwe china, adzawonjezeredwa.

"Chikhalidwe Chachikhalidwe" - ndemanga yokhala ndi deta yambiri, yowunika kuti zitsatidwe;

"Mkhalidwe" - Kukangana komwe kukuyimira chotsatira cha kusankha.

Ntchitoyi imaphatikizapo ntchito ndi maofesi angapo omwe amagwira ntchito yomweyo.

Tiyeni tiwone momwe njirayi ikugwiritsira ntchito kuthetsa mavuto panthawi ya tebulo lathu la malonda pa malo ogulitsira. Tidzafunika kuwerengera ndalama zomwe zatulutsidwa ndi Shopu 1 kuyambira pa March 09 mpaka March 13, 2017. Pachifukwa ichi, kufotokozera kwa ndalama kumangoganizira za masiku okhawo, zomwe ndalamazo zinapitirira 14,000 rubles.

  1. Sankhani selo kachiwiri kuti muwonetse chiwerengero chonse ndipo dinani pazithunzi. "Ikani ntchito".

  2. Mu Wizard ntchitoChoyamba, tikusunthira ku chipika. "Masamu", ndipo apo timasankha chinthu chotchedwa "SUMMESLIMN". Dinani pa batani "Chabwino".

  3. Mawindo a ogwiritsira ntchito, omwe atchulidwa pamwambapa, akuyambitsidwa.

    Ikani cholozera mmunda "Chiwerengero cha Kusambira". Mosiyana ndi zifukwa zotsatizana, izi ndi za mtundu umodzi ndipo zikutanthauza mfundo zambiri zomwe zidzasinthidwe. Kenaka sankhani malo a mzere "Shop1"M'zimene zimayikidwa ziyeso za ndalama zogulitsa.

    Pambuyo pa adiresi ikuwonetsedwa pawindo, pitani kumunda "Chikhalidwe Chachigawo1". Pano tidzakhala tikuwonetsa makonzedwe a chingwe ndi masiku. Timapanga chithunzi cha batani lamanzere ndi kusankha masabata onse patebulo.

    Ikani cholozera mmunda "Chikhalidwe1". Choyamba ndikuti tifotokoze mwachidule detayi pasanafike pa March 09. Choncho, ife timalowa mu mtengo ">08.03.2017".

    Pitani kuzokangana "Chikhalidwe Chachiwiri". Pano muyenera kulowa muzomwezi zomwe zinalembedwa m'munda "Chikhalidwe Chachigawo1". Timachita chimodzimodzi, ndiko kuti, powonetsa mzere ndi masiku.

    Ikani cholozera mmunda "Chikhalidwe2". Chikhalidwe chachiwiri ndi chakuti masiku omwe ndalama zidzawonjezeredwa sizikhala patapita kuposa March 13. Choncho, lembani mawu awa: "<14.03.2017".

    Pitani kumunda "Chikhalidwe Chachiwiri". Pachifukwa ichi, tifunika kusankha mndandanda womwewo omwe adalandila adiresi monga mndandanda wa masamu.

    Pambuyo pa adiresi ya ndondomekoyi yowonekera pawindo, pitani kumunda "Chikhalidwe3". Pokumbukira kuti chikhalidwe chokha chomwe chiposa 14,000 rubles chidzalowetsa mufupikitsa, tikupanga zolemba izi: ">14000".

    Pambuyo pachitsiriza chomaliza, dinani pa batani "Chabwino".

  4. Pulogalamuyi imasonyeza zotsatira pa pepala. Ndilofanana ndi 62491.38. Izi zikutanthauza kuti kuyambira pa 09 mpaka 13 March 2017, kuchuluka kwa ndalama pamene muwonjezerapo masiku omwe muliposa 14,000 rubles anali mabomba 62,491.38.

Kupanga Maonekedwe

Chomaliza, chofotokozedwa ndi ife, chida, pamene tigwiritsira ntchito ndi njira zomwe zimagwiritsidwa ntchito, ndi maonekedwe ovomerezeka. Amapanga maselo omwe amawongolera omwe amakumana ndi zikhalidwezo. Taonani chitsanzo chogwira ntchito ndi maonekedwe ovomerezeka.

Onetsetsani maselo awo pa tebulo mu buluu, komwe maulendo a tsikulo amaposa 14,000 rubles.

  1. Sankhani zinthu zonse zomwe zili mu tebulo, zomwe zikuwonetsa ndalama zomwe zimagulitsa malonda masana.

  2. Pitani ku tabu "Kunyumba". Timakani pa chithunzi "Mafomu Okhazikika"adaikidwa mu chipika "Masitala" pa tepi. Mndandanda wa zochitika zimatsegulidwa. Ife timalowamo mmalo mwake "Pangani malamulo ...".

  3. Zowonetsera mawindo a chibadwidwe cha ulamuliro akulowetsedwa. M'munda wa mtundu wosankha malamulo sankhani dzina "Pangani maselo okhawo omwe ali". Mu gawo loyambirira la chikhalidwecho chimachokera pa mndandanda wa zosankha zosankhidwa kusankha "Cell Value". Mu gawo lotsatira, sankhani malo "Zambiri". M'kupita kwa nthawi, timasonyeza ubwino wokha, womwe uli waukulu ndikusintha zinthu zomwe zili patebulo. Tili ndi zikwi khumi ndi ziwiri (14,000). Kusankha mtundu wa maonekedwe, dinani pa batani. "Format ...".

  4. Kujambula zenera kuyatsegulidwa. Pitani ku tabu "Lembani". Kuchokera pazomwe mungakonde kudzazitsa mitundu, sankhani buluu podalira pazitsulo lamanzere. Pambuyo pa mtundu wosankhidwa ukuwonetsedwa "Chitsanzo"dinani batani "Chabwino".

  5. Icho chimabwereranso kuwindo lazenera lazenera. Komanso kumadera "Chitsanzo" kuwonetsedwa mu buluu. Pano tikufunika kuchita chinthu chimodzi: dinani pa batani "Chabwino".

  6. Pambuyo pachitsiriza chomaliza, maselo onse a osankhidwa, omwe ali ndi chiwerengero choposa 14000, adzadzala ndi mtundu wa buluu.

Kuti mudziwe zambiri za momwe mungapangidwire maonekedwe anu, mufotokoze m'nkhani yapadera.

PHUNZIRO: Kujambula kwapadera pa Excel

Monga momwe tikuonera, mothandizidwa ndi zipangizo zomwe amagwiritsira ntchito zofunikira pa ntchito yawo, mu Excel imodzi ikhoza kuthetsa ntchito zosiyanasiyana. Izi zikhoza kukhala zowerengera zonse ndi zoyenera, ndi kupanga, komanso kuchita ntchito zina zambiri. Zida zazikulu zomwe zimagwira ntchito pulojekitiyi ndizofunikira, ndiko kuti, ndi zikhalidwe zina zomwe ntchitoyi yatsegulidwira, ndiyiyi ya ntchito zomangidwa, komanso zolemba zovomerezeka.

Posts Popular

https://termotools.com ny.termotools.com © Instagram 2024