Mukamagwira ntchito ndi matebulo, malingaliro omwe akuwonetsedwa mmenemo ali oyamba. Koma chigawo chofunikira ndichinthu chomwecho. Ogwiritsa ntchito ena amaganiza kuti ichi ndi chinthu chachiwiri ndipo samamvetsera kwambiri. Ndipo mopanda phindu, chifukwa tebulo lokonzedwa bwino ndilofunika kwambiri kuti liwone bwino komanso kumvetsetsa kwa ogwiritsa ntchito. Kuwonetseratu ma data kumathandiza kwambiri pa izi. Mwachitsanzo, mothandizidwa ndi zipangizo zowonetsera mungathe kujambula maselo a tebulo malinga ndi zomwe zili. Tiyeni tione momwe tingachitire izi mu Excel.
Ndondomeko yosintha mtundu wa maselo malinga ndi zomwe zili
Inde, nthawi zonse zimakhala zokondweretsa kukhala ndi tebulo lokonzedwa bwino, momwe maselo, malinga ndi zomwe zilipo, amajambula mu mitundu yosiyanasiyana. Koma mbaliyi ndi yofunika kwambiri pa matebulo aakulu omwe ali ndi deta yambiri. Pachifukwa ichi, mtundu wodzaza maselo umathandiza kwambiri kuti ogwiritsira ntchito adziwe zambiri pazomwezi, chifukwa zikhoza kunenedwa kuti zakhazikitsidwa kale.
Zida zamapepala zingayesedwe kuti azijambula pamanja, koma kachiwiri, ngati tebulo liri lalikulu, zidzatenga nthawi yochuluka. Kuwonjezera apo, muzinthu zambiri zoterezi chinthu chomwe munthu angakhale nacho ndi zolakwika zidzapangidwa. Osatchulidwa kuti tebulo ikhoza kukhala yamphamvu ndipo deta yomwe ili mmenemo nthawi ndi nthawi amasintha, ndipo mochuluka. Pachifukwa ichi, kusintha mwapadera mtundu wonsewo kumakhala kosatheka.
Koma pali njira yotulukira. Kwa maselo omwe ali ndi machitidwe okhwima (kusintha), maimidwe ovomerezeka amagwiritsidwa ntchito, ndipo kwa chiwerengero cha deta, mungagwiritse ntchito chida "Pezani ndi kusintha".
Njira 1: Kupanga Maonekedwe Okhazikika
Pogwiritsa ntchito maonekedwe ovomerezeka, mungathe kukhazikitsa malire amtundu umene maselo adzajambulidwa mu mtundu kapena mtundu wina. Kujambula zithunzi kudzachitidwa mosavuta. Ngati selolo likuyendera, chifukwa cha kusintha, limadutsa malire, ndiye chinthu ichi chidzabwezeredwa mosavuta.
Tiyeni tiwone momwe njirayi ikugwirira ntchito pachitsanzo. Tili ndi tebulo la malipiro a malonda, omwe deta imagawanika mwezi uliwonse. Tiyenera kuwonetsera ndi mitundu yosiyanasiyana zinthu zomwe ndalamazo sizing'ono 400000 rubles, kuchokera 400000 mpaka 500000 rubles ndi kupitirira 500000 ruble.
- Sankhani ndime yomwe mukudziwira za ndalama za malonda. Kenaka pita ku tabu "Kunyumba". Dinani pa batani "Mafomu Okhazikika"yomwe ili pa tepiyi mu zida za zipangizo "Masitala". M'ndandanda yomwe imatsegula, sankhani chinthucho "Utsogoleri wa Malamulo ...".
- Kuyamba kuyang'anila zenera malamulo malamulo omasulira. Kumunda "Onetsani malamulo omasulira" ziyenera kukhazikitsidwa "Chidutswa Chamakono". Mwachindunji, ziyenera kufotokozedwa pamenepo, koma pokhapokha mutayang'ana, fufuzani ndipo ngati simukugwirizana, musinthe mazenera malinga ndi malangizidwewa. Pambuyo pake muyenera kusindikiza batani "Pangani malamulo ...".
- Fenera yolenga chikhalidwe choyika maonekedwe chimatsegulidwa. Mundandanda wa mitundu ya malamulo, sankhani malo "Pangani maselo okhawo omwe ali". Mulojekiti ikufotokozera lamulo mu gawo loyamba, kusinthana kuyenera kukhala pa malo "Makhalidwe". Mu gawo lachiwiri, ikani kasinthasintha ku malo "Zochepa". Mu gawo lachitatu timasonyeza ubwino, zinthu za pepala zomwe zili ndi mtengo wochepa kusiyana ndi zomwe zidzakongoletsedwe mu mtundu wina. Kwa ife, mtengo uwu udzakhala 400000. Pambuyo pake, dinani pa batani "Format ...".
- Zenera la mawonekedwe a maselo amatsegulidwa. Pitani ku tabu "Lembani". Sankhani mtundu wodzaza umene tikufuna, kuti maselo ali ndi mtengo wochepa 400000. Pambuyo pake, dinani pa batani "Chabwino" pansi pazenera.
- Timabwerera kuwindo kuti tipeze maulamuliro a maonekedwe ndi dinani pa batani kumeneko. "Chabwino".
- Pambuyo pachitachi, tidzakonzanso kutero Mtsogoleri Woyang'anira Malamulo Okhazikitsa. Monga mukuonera, lamulo limodzi lawonjezeredwa kale, koma tiyenera kuwonjezera zina ziwiri. Choncho, dinani batani "Pangani malamulo ...".
- Ndipo kachiwiri ife tikufika ku ulamuliro kulenga zenera. Pitani ku gawo "Pangani maselo okhawo omwe ali". Mu gawo loyambirira la gawo ili, chotsani parameter "Cell Value", ndipo mwachiwiri mumakhala chosintha pa malo "Pakati pa". Mu gawo lachitatu muyenera kufotokoza mtengo woyambirira wa mapepala omwe adzakonzedwe. Kwa ife, nambala iyi 400000. Muchinayi, timasonyeza mtengo wotsiriza wa mtundu uwu. Icho chidzakhala 500000. Pambuyo pake dinani pa batani "Format ...".
- Muwindo lamapangidwe timasunthira ku tabu. "Lembani", koma nthawi ino tikusankha mtundu wina, ndiye dinani pa batani "Chabwino".
- Mutabwerera ku ulamuliro wowonekera zenera, dinani pa batani. "Chabwino".
- Monga momwe tikuonera, mu Mtsogoleri Woyang'anira takhazikitsa malamulo awiri. Kotero, izo zimakhalabe kuti apange gawo lachitatu. Dinani pa batani "Pangani lamulo".
- Mu ulamuliro kulenga zenera, ife timasunthira ku gawo kachiwiri. "Pangani maselo okhawo omwe ali". M'munda woyamba, chotsani "Cell Value". Mu gawo lachiwiri, yikani kusintha kwa apolisi "Zambiri". Mu gawo lachitatu timayendetsa mu nambala 500000. Ndiye, monga momwe zinalili kale, dinani pa batani "Format ...".
- Muzenera "Sezani maselo" sungani ku tabu kachiwiri "Lembani". Panthawiyi, sankhani mtundu wosiyana ndi milandu iwiri yapitayi. Dinani pa batani. "Chabwino".
- Mu kulenga malamulo zenera, sindikizani batani kachiwiri. "Chabwino".
- Kutsegulidwa Mtsogoleri woweruza. Monga mukuonera, malamulo onse atatu adalengedwa, kotero dinani batani "Chabwino".
- Tsopano zinthu za tebulo zimakhala zofiira molingana ndi zomwe zidafotokozedwe ndi malire muzokhazikitsidwa zovomerezeka.
- Ngati titasintha zomwe zili m'modzi mwa maselo, pamene tikudutsa malire a malamulo ena, ndiye kuti gawo ili la pepala lidzasintha mtundu.
Kuonjezerapo, maonekedwe ovomerezeka angagwiritsidwe ntchito mosiyana ndi zojambulajambula.
- Pambuyo pake Mtsogoleri Woyang'anira timapita ku kulenga mawonekedwe a mawonekedwe, kenaka khalani muchigawo "Pangani maselo onse malinga ndi mfundo zawo". Kumunda "Mtundu" Mukhoza kusankha mtundu, mithunzi yomwe idzakwaniritse zinthu za pepala. Kenaka dinani pa batani. "Chabwino".
- Mu Mtsogoleri Woyang'anira Dinani batani "Chabwino".
- Monga mukuonera, patatha izi, maselo omwe ali m'ndandanda ali ndi mitundu yosiyana ya mtundu womwewo. Pamene mtengo umene uli ndi chidziwitso cha pepalachi, mthunzi ndi wopepuka, wosachepera - wakuda.
Phunziro: Mafomu omvera mu Excel
Njira 2: Gwiritsani ntchito Chida Chopeza ndi Kuwala
Ngati tebulo ili ndi deta yomwe simukufuna kusintha pa nthawi, ndiye kuti mungagwiritse ntchito chida kusintha mtundu wa maselo mwawo, wotchedwa "Pezani ndi kuonetsa". Chida ichi chidzakuthandizani kuti mupeze malingaliro omwe mwasankha ndikusintha mtundu mu maselowa kwa wogwiritsa ntchito. Koma ziyenera kukumbukira kuti posintha zinthu zomwe zili m'mapangidwe a pepala, mtundu sudzasintha, koma udzasintha. Kuti musinthe mtundu wa weniweni, muyenera kubwereza ndondomekoyi kachiwiri. Choncho, njira iyi siili yabwino kwambiri pa matebulo ndi zokhutiritsa.
Tiyeni tiwone momwe izo zimagwirira ntchito pachitsanzo, zomwe timatenga tebulo limodzi la ndalama zomwe timalandira.
- Sankhani ndondomekoyi ndi deta yomwe iyenera kupangidwa ndi mtundu. Ndiye pitani ku tabu "Kunyumba" ndipo dinani pa batani "Pezani ndi kuonetsa"yomwe imayikidwa pa tepi mu zida za zipangizo Kusintha. M'ndandanda yomwe imatsegula, dinani pa chinthucho "Pezani".
- Foda ikuyamba "Pezani ndi kusintha" mu tab "Pezani". Choyamba, tiyeni tipeze zoyenera ku 400000 ruble. Popeza tilibe maselo omwe mtengo ungakhale wochepa 300000 ma ruble, ndiye, makamaka, tikuyenera kusankha zinthu zonse zomwe zili ndi nambala yochokera 300000 mpaka 400000. Mwamwayi, sitinganene mwachindunji izi, monga momwe mukugwiritsira ntchito maonekedwe ovomerezeka, mwa njira iyi n'kosatheka.
Koma pali mwayi wochita chinachake mosiyana, chomwe chidzatipatsa zotsatira zomwezo. Mutha kukhazikitsa chitsanzo chotsatira mu bar "3?????". Funso la funso limatanthauza khalidwe lililonse. Choncho, pulogalamuyi idzafufuza ma nambala onse asanu ndi limodzi omwe amayamba ndi chiwerengero. "3". Izi zikutanthauza kuti zotsatira zofufuzira zidzakhala ndi mfundo zamtengo wapatali 300000 - 400000zomwe tikusowa. Ngati tebulo ili ndi nambala zochepa 300000 kapena zochepa 200000ndiye aliyense amayenda mu zana zikwi zana kufufuza kuyenera kuchitidwa mosiyana.
Lowani mawuwo "3?????" kumunda "Pezani" ndipo dinani pa batani "Pezani zonse".
- Pambuyo pake, zotsatira za zotsatira zofufuzira zikuwonetsedwa m'munsi mwawindo. Dinani botani lamanzere lamanzere pa aliyense wa iwo. Ndiye lembani kuphatikiza kwachinsinsi Ctrl + A. Pambuyo pake, zotsatira zonse zofufuzira zimatsindikizidwa ndipo, panthawi imodzimodzi, zinthu zomwe zili m'ndandanda zomwe zotsatirazi zikuwonetsera zikuwonetsedwa.
- Pamene zinthu zomwe zili m'ndandanda zasankhidwa, musachedwe kutseka zenera. "Pezani ndi kusintha". Kukhala mu tab "Kunyumba" kumene tinasunthira kale, pitani ku tepi ya zida "Mawu". Dinani pa katatu kupita kumanja kwa batani Lembani Mtundu. Mitundu yosiyanasiyana yodzaza imatsegulidwa. Sankhani mtundu umene tikufuna kuwugwiritsa ntchito ku mapepala omwe ali ndi ziyeso zosakwana 400000 ruble.
- Monga momwe mukuonera, maselo onse a m'mbali yomwe zikhalidwezo sizing'ono 400000 ma ruble omwe amawonekera mu mtundu wosankhidwa.
- Tsopano tikufunika kujambula zinthu, zomwe zikhalidwe zimachokera 400000 mpaka 500000 ruble. Mtundu uwu umaphatikizapo manambala omwe akufanana ndi chitsanzo. "4??????". Timayendetsa mumalo osaka ndikusindikiza pa batani "Pezani Zonse"poyamba kusankha ndime yomwe tikufunikira.
- Mofananamo ndi nthawi yapitayi mu zotsatira zosaka timapanga chisankho chotsatira chonse chogwiritsidwa ntchito pophatikiza chinsinsi chophatikiza CTRL + A. Pambuyo pa kusunthira kwa chithunzi chodzaza mtundu. Timalumikiza pa izo ndikusindikiza pa pictogram ya hue yomwe tikusowa, yomwe idzajambula zinthu za pepala, kumene miyezo ikuyendera kuchokera 400000 mpaka 500000.
- Monga mukuonera, mutatha izi zonse zigawo za tebulo zomwe zili ndi deta panthawiyi 400000 ndi 500000 yowunikiridwa ndi mtundu wosankhidwa.
- Tsopano tikuyenera kusankha makhalidwe otsiriza - zambiri 500000. Pano ife tiri ndi mwayi, chifukwa manambala onse ali ochuluka 500000 ali pamtundu uliwonse 500000 mpaka 600000. Choncho, muyeso lofufuzira lolowani mawu "5?????" ndipo dinani pa batani "Pezani Zonse". Ngati pangakhale zamtengo wapatali kuposa 600000, tiyeneranso kufufuzira mawuwo "6?????" ndi zina zotero
- Apanso, sankhani zotsatira zosaka pogwiritsa ntchito kuphatikiza Ctrl + A. Kenaka, pogwiritsa ntchito batani pa riboni, sankhani mtundu watsopano kuti mudzaze nthawi yopitirira 500000 ndi chifaniziro chomwecho monga ife tinachitira kale.
- Monga momwe mungathe kuwonera, mutatha kuchitapo kanthu, zigawo zonse za mndandanda zidzakhala zojambulapo, malinga ndi chiwerengero cha chiwerengero chomwe chaikidwa mwa iwo. Tsopano mukhoza kutseka zenera lofufuzira podalira batani yoyenera kumbali yakumanja yawindo, popeza ntchito yathu ingathe kuthandizidwa kuthetsedwa.
- Koma ngati tibwezera chiwerengerocho ndi zina zomwe zimadutsa malire omwe apangidwira mtundu wina, mtundu sudzasintha, monga momwe zinalili kale. Izi zikusonyeza kuti njirayi idzagwira ntchito mokhazikika pokhapokha m'ma tebulo omwe data silikusintha.
Phunziro: Mungachite bwanji kufufuza mu Excel
Monga momwe mukuonera, pali njira ziwiri zojambulira maselo malinga ndi ziwerengero zomwe ali nazo: kugwiritsa ntchito mawonekedwe ovomerezeka ndi kugwiritsa ntchito chida "Pezani ndi kusintha". Njira yoyamba ikupita patsogolo kwambiri, chifukwa imakulolani kuti mudziwe bwino momwe zinthu zidzakhalire. Komanso, ndi maonekedwe oyenera, mtundu wa chinthucho umasintha ngati zinthu zomwe zili mmenemo zimasintha, zomwe njira yachiwiri sangachite. Komabe, selo lidzaza malingana ndi mtengo pogwiritsa ntchito chida "Pezani ndi kusintha" Ndizotheka ndithu kugwiritsa ntchito, koma m'matawuni ozungulira.
