Kugwiritsa ntchito ntchito ya PSTR mu Microsoft Excel

Nthawi zina, wogwiritsa ntchito amayang'anizana ndi ntchito yobwereranso ku cell ina nambala inayake ya anthu, kuyambira munthu amene akuwonetsa pa akauntiyo kumanzere. Ntchitoyi imachita ntchito yayikulu ya izi. PSTR. Kugwira kwake ntchito kumawonjezereka ngati othandizira ena amagwiritsidwa ntchito limodzi ndi, mwachitsanzo Sakani kapena DZIWANI. Tiyeni tiwone mwachidule zomwe mawonekedwe a ntchitoyo ali PSTR ndikuwona momwe imagwirira ntchito pa zitsanzo zapadera.

Kugwiritsa ntchito PSTR

Ntchito yayikulu ya wothandizira PSTR lili ndi kutulutsa kuchokera patsamba lojambulidwalo nambala yaanthu osindikizidwa, kuphatikiza malo, kuyambira wolemba omwe akuwonetsedwa pa akauntiyo kupita kumanzere. Ntchitoyi ndi ya gulu la olemba ntchito. Kapangidwe kake kamakhala motere:

= PSTR (mawu; poyambira_ poyambira; chiwerengero cha zilembo)

Monga mukuwonera, njira iyi imakhala ndi mfundo zitatu. Zonsezi ndizofunikira.

Kukangana "Zolemba" ili ndi adilesi ya pepalalo momwe mawu omwe ali ndi zilembo zochotseredwa amapezeka.

Kukangana "Kuyambira" yowonetsedwa mwa manambala omwe akuwonetsa kuti ndi ndani mu akauntiyo, kuyambira kumanzere, muyenera kuchotsa. Khalidwe loyamba limawerengeredwa monga "1"chachiwiri cha "2" etc. Ngakhale malo omwe amawerengedwa amawerengedwa.

Kukangana "Chiwerengero cha otchulidwa" ili ndi chidziwitso chowerengera cha manambala, kuyambira kuyambira poyambira, omwe amayenera kutulutsidwa kumalo omwe akulimbana. Powerengera, monga momwe mumakambirana m'mbuyomu, malo amatchulidwa.

Chitsanzo 1: kuchotsera kamodzi

Fotokozani zitsanzo za ntchito PSTR yambani ndi mlandu wosavuta mukafuna kutulutsa mawu amodzi. Zachidziwikire, zosankha zotere sizimagwiritsidwa ntchito pochita, chifukwa chake timapereka chitsanzo chokha ngati mawu oyambira a opareshoni.

Chifukwa chake, tili ndi tebulo la ogwira nawo ntchito. Ndime yoyamba ikuwonetsa mayina, maina awo ndi mafotokozedwe awo antchito. Tiyenera kugwiritsa ntchito wothandizira PSTR kungotulutsa dzina lokha kuchokera pa mndandanda wa Pyotr Ivanovich Nikolaev muchipinda chosonyezedwacho.

1. Sankhani gawo la pepalalo momwe zikuluzikulu zidzachitikire. Dinani batani "Ikani ntchito"lomwe lili pafupi ndi mzere wa fomula.



2. Zenera limayamba Ogwira Ntchito. Pitani ku gulu "Zolemba". Timasankha dzinalo PSTR ndipo dinani batani "Zabwino".



3. Woyendetsa Window Window Woyambitsa PSTR. Monga mukuwonera, pazenera ili chiwerengero cha minda chofanana ndi kuchuluka kwa zotsutsana za ntchitoyi.

   M'munda "Zolemba" lowetsani zolumikizana za foni yomwe ili ndi dzina la ogwira ntchito. Pofuna kuti tisayendetse adilesi pamanja, timangoika chikhazikitso m'munda ndikudina kumanzere pachinthucho chomwe chili ndi zomwe tikufuna.

   M'munda "Kuyambira" lembani nambala ya chizindikiro, kuyambira kumanzere, komwe dzina la wantchito limayambira. Powerengera, timaganiziranso mipata. Kalata "N"ndi zomwe dzina la wogwira ntchito wa Nikolaev limayamba, ndi munthu wachisanu ndi chiwiri mzere. Chifukwa chake, timayika manambala m'munda "15".

   M'munda "Chiwerengero cha otchulidwa" Muyenera kutchulapo kuchuluka kwa zilembo zomwe zimapanga dzina lomaliza. Muli ndi zilembo zisanu ndi zitatu. Koma poganiza kuti palibenso anthu ena m'chipindamo dzina lomaliza, titha kutchulanso ena. Ndiye kuti, m'malo mwathu, mutha kuyika chiwerengero chilichonse chomwe ndi chofanana kapena chachikulu kuposa eyiti. Timayika, mwachitsanzo, angapo "10". Koma ngati panali mawu ena, manambala kapena zizindikilo zina mu foni pambuyo pa dzina lomaliza, ndiye kuti tizingoyika nambala yeniyeni ya zilembo ("8").

   Pambuyo polemba data yonse, dinani batani "Zabwino".



4. Monga mukuwonera, izi zitachitika, dzina la wantchito lidawonetsedwa mu gawo loyamba lomwe tidafotokoza Chitsanzo 1 khungu.

Phunziro: Excel Feature Wizard

Chitsanzo 2: kuchotsera gulu

Koma, ndichachidziwikire, kuti ndicholinga chogwira ntchito ndikosavuta kuyendetsa galimoto mu dzina limodzi kuposa kugwiritsa ntchito njira iyi. Koma kusamutsa gulu la chidziwitso pogwiritsa ntchito ntchito ndizoyenera.

Tili ndi mndandanda wa mafoni. Dera lililonse lachitsanzo limatchulidwa ndi liwu Smartphone. Tiyenera kuyika mayina a mitundu yopanda liwu ili mgulu lina.

1. Sankhani gawo loyambirira la gawo lomwe zotsatirazo zikuwonetsedwa, ndikuyitanitsa windo la wotsutsa PSTR momwemonso monga mwa chitsanzo cham'mbuyomu.

   M'munda "Zolemba" fotokozerani adilesi ya koyamba kakholilo ndi komwe mungapeze.

   M'munda "Kuyambira" tifunika kufotokoza nambala yaumwini kuyambira pomwe idachotsedwa data. M'malo mwathu, mu foni iliyonse, dzina la mtunduwo limakhala ndi mawu Smartphone ndi malo. Chifukwa chake, mawu omwe mukufuna kuwonetsa mu khungu lina pena paliponse amayamba ndi gawo la khumi. Khazikitsani nambala "10" m'munda uno.

   M'munda "Chiwerengero cha otchulidwa" muyenera kukhazikitsa nambala ya zilembo zomwe zili ndi mawu owonetsedwa. Monga mukuwonera, dzina la mtundu uliwonse lili ndi zilembo zingapo. Koma choona kuti pambuyo pa dzina lachitsanzo, zolembedwazo m'mamaselo zimatha kupulumutsa. Chifukwa chake, titha kukhazikitsa m'gululi nambala iliyonse yomwe ili yofanana kapena yayikulu kuposa chiwerengero cha zilembo zazitali kwambiri pamndandandawu. Khazikitsani nambala iliyonse ya zilembo "50". Zina mwa mafoni awa sizipitilira 50 otchulidwa, kotero njirayi ikuyenerera kwathu.

   Pambuyo poti pulogalamuyo yaikidwa, dinani batani "Zabwino".



2. Pambuyo pake, dzina la mtundu woyamba wa smartphone limawonetsedwa mu khungu lokonzedweratu pagome.



3. Pofuna kuti tisamayike formula payokha mu cell iliyonse, timakopera pogwiritsa ntchito cholembera. Kuti muchite izi, ikani cholozera cha ngodya chapansi chakumanja kwa chilinganizo. Cholozera chimasinthidwa kukhala chikhomo chodzaza momwe muli mtanda wawung'ono. Gwirani batani lakumanzere ndikulikokera kumapeto kwenikweni kwa mzati.



4. Monga mukuwonera, gawo lonse pambuyo pake lidzadzaza ndi zomwe tikufuna. Chinsinsi ndikuti mkangano "Zolemba" imayimira kalozera ndipo imasinthanso momwe maselo omwe akujambulawo amasintha.



5. Koma vuto ndilakuti ngati mwadzidzidzi tidzaganiza zosintha kapena kuchotsa mzere wokhala ndi chidziwitso choyambirira, ndiye kuti zomwe zili patsamba loyilo sizikuwonetsedwa molondola, chifukwa zimagwirizana ndi njira.

   

   Kuti "mumasulidwe" zotsatira kuchokera kumipukutu yoyambirira, timachita zolemba zotsatirazi. Sankhani mzere womwe uli ndi fomula. Kenako, pitani tabu "Pofikira" ndikudina chizindikiro Copyili mu block Clipboard pa tepi.

   

   Monga chinthu china, mutha kukanikiza kuphatikiza kiyi mutatsindika Ctrl + C.

6. Kenako, osachotsa masankhidwewo, dinani kumanzere. Zosankha zam'mawu zimatsegulidwa. Mu block Ikani Zosankha dinani pachizindikiro "Makhalidwe".



7. Zitatha izi, m'malo mwazomwe zimapangidwira, mfundozo zimayikidwa mugawo losankhidwa. Tsopano mutha kusintha kapena kuchotseratu choyambirira. Izi sizingasinthe zotsatira zake.

Chitsanzo 3: Kugwiritsa ntchito ophatikiza

Komabe, chitsanzo pamwambapa ndichoperewera chifukwa chakuti liwu loyamba m'maselo onse opezeka liyenera kukhala ndi ofanana manambala. Ntchito ndi ntchito PSTR ogwiritsira ntchito Sakani kapena DZIWANI ichulukitsa mwayi wogwiritsa ntchito njira.

Ogwiritsa ntchito zolemba Sakani ndi DZIWANI bwezeretsani malo omwe alembedwa pamawuwo.

Ntchito Syntax Sakani kutsatira:

= SEARCH (search_text; text_to_search; Start_position)

Ntchito Syntax DZIWANI zikuwoneka ngati:

= FINDANI (kusaka_katundu; wowonera_mawu; poyambira)

Kwakukulukulu, zotsutsana za ntchito ziwiri izi ndizofanana. Kusiyana kwawo kwakukulu ndikuti wothandizira Sakani mukamakonza deta siyikhala yomvera chisoni, koma DZIWANI - imawerengera.

Tiyeni tiwone momwe mungagwiritsire ntchito opareshoni Sakani kuphatikiza ndi ntchito PSTR. Tili ndi tebulo pomwe mayina amitundu yosiyanasiyana ya zida zamakompyuta omwe ali ndi dzina la generic amalembedwa. Pomaliza, tifunika kutulutsa dzina la mitunduyo popanda dzina la mtundu. Chovuta ndichakuti ngati m'mbuyomu dzina lodziwika bwino lazinthu zonse linali lofanana ("smartphone"), pamndandanda womwe ulipo ndizosiyana ("kompyuta", "kuwunika", "oyankhula", ndi zina). ndi zilembo zingapo. Kuti tithane ndi vutoli, timafunika wothandizira Sakanizomwe tidzaikamo PSTR.

1. Timasankha koyamba kakholilo komwe datayo izichotsa, ndipo mwanjira yomwe timatchulira zenera zotsutsa PSTR.

   M'munda "Zolemba", mwachizolowezi, tikuwonetsa khungu loyambirira la gawolo lomwe lili ndi zomwe zomwe zalembedwa. Chilichonse sichisinthike.



2. Nayi mtengo wa munda "Kuyambira" ikhazikitsa mfundo yoti ntchitozo zimagwira Sakani. Monga mukuwonera, deta yonse yomwe ili pamndandandayo imalumikizidwa chifukwa chakuti dzina lachitsanzo limakhala ndi danga. Chifukwa chake, wothandizira Sakani adzafufuza malo oyamba mu khungu la magwero ndi kunena kuchuluka kwa chizindikiro cha ntchitoyi PSTR.

   Kuti mutsegule zenera zotsutsa Sakani, ikani chidziwitso kumunda "Kuyambira". Kenako, dinani chizindikiro chamtundu wamakona atatu, cholowera kumunsi. Chizindikirochi chili pamlingo womwewo woyenera windo ngati batani. "Ikani ntchito" Ndi mzere wazanjira, koma kumanzere kwawo. Mndandanda wa ogwiritsa ntchito omwe atha kugwiritsidwa ntchito posachedwapa akutseguka. Popeza palibe dzina pakati pawo Sakani, kenako dinani chinthucho "Zina ...".



3. Zenera limatseguka Ogwira Ntchito. Gulu "Zolemba" sankhani dzinalo Sakani ndipo dinani batani "Zabwino".



4. Woyendetsa Window Window Woyambitsa Sakani. Popeza tikufuna danga, m'munda "Zofufuza" ikani malo pokhazikitsa cholozera pamenepo ndikusindikiza fungulo lolingana pa kiyibodi.

   M'munda Sakani fotokozerani ulalo wa khungu loyamba la chipilalo ndi zomwe mungapeze. Ulalowu udzakhala wofanana ndi womwe tidawonetsa m'munda "Zolemba" pawindo la otsutsana PSTR.

   Kutsutsana pamunda "Kuyambira" osafunikira. M'malo mwathu, sikofunikira kuti mudzaze kapena mutha kukhazikitsa manambala "1". Ndi zilizonsezi zomwe mungasankhe, kufufuzaku kuchitika kuchokera koyambirira kwa lembalo.

   Pambuyo poti deta yaikidwa, musathamangire kukanikiza batani "Zabwino", popeza ntchitoyo Sakani ndi chisa. Ingodinani dzina PSTR bala.



5. Pambuyo pochita zomalizira zomaliza, timangobwereranso pawindo laopani PSTR. Monga mukuwonera, mundawo "Kuyambira" yadzaza kale mawonekedwe Sakani. Koma kachitidwe kameneka kamaonetsa danga, ndipo timafunikira wina wotsatira danga, kuchokera pomwe dzina lachitsanzo limayamba. Chifukwa chake, ku data yomwe ilipo m'munda "Kuyambira" kuwonjezera mawu "+1" opanda mawu.

   M'munda "Chiwerengero cha otchulidwa"monga mu chitsanzo chapitacho, timalemba nambala iliyonse yomwe ndi yoposa kapena lofanana ndi chiwerengero cha anthu omwe akutchulidwa kwambiri motere. Mwachitsanzo, timayika nambala "50". Kwa ife, izi ndizokwanira.

   Mutatha kuchita zonsezi, dinani batani "Zabwino" pansi pazenera.



6. Monga mukuwonera, zitatha izi dzina la mtundu wa chipangizocho lidawonetsedwa mu khungu lina.



7. Tsopano, pogwiritsa ntchito Fill Wizard, monga momwe munachitira kale, koperani formula ku maselo omwe ali pansi pazigawozi.



8. Mayina amitundu yonse ya zida akuwonetsedwa mu maselo omwe akulimbana nawo. Tsopano, ngati pakufunika kutero, mutha kuthana ndi kulumikizana ndi izi ndi gawo la data, monga momwe zinalili m'mbuyomu, mwa kukopera ndi kubetcha mfundo zotsatizana. Komabe, izi sizofunikira nthawi zonse.

Ntchito DZIWANI ntchito molumikizana ndi kachitidwe PSTR ndi mfundo yomweyo monga wothandizira Sakani.

Monga mukuwonera, ntchitoyo PSTR ndi chida chosavuta kwambiri chowonetsera chidziwitso chofunikira mu khungu lomwe limanenedweratu. Chowonadi chakuti sichotchuka kwambiri pakati pa ogwiritsa ntchito chafotokozedwa ndikuti ogwiritsa ntchito ambiri, omwe amagwiritsa ntchito Excel, amalabadira kwambiri ntchito zamasamu, m'malo mwalemba. Mukamagwiritsa ntchito fom iyi pophatikizana ndi ena ogwira ntchito, magwiridwe antchito ake amathandizidwanso.