Zamkatimu
Nthawi zambiri, wogwiritsa ntchito Excel amayang'anizana ndi kufunikira kodzaza ma cell ndi data yokonzedwa motsatira ndondomeko yomveka. Kapena, mwachitsanzo, kupanga chiwonetsero cha zomwe mtengo wa chizindikirocho udzakhala ndi nthawi yeniyeni, ngati zomwe zikuchitika panopa zikupitirira. Tsopano simuyenera kudziwa zambiri zamitundu yonseyi. Kudina pang'ono kwa mbewa ndikokwanira, ndipo vuto lathetsedwa. Zonse ndi chifukwa cha autocomplete.
Mbali imeneyi ndi yodabwitsa kwambiri. Mwachitsanzo, zimakulolani kuti mulembe msanga miyezi ya kalendala kapena kupanga kuti tsiku la 15 ndi lomaliza la mwezi uliwonse liwonetsedwe (mwachitsanzo, mu malipoti owerengera ndalama).
Kodi mungapindule bwanji ndi mbali yaikulu imeneyi?
Pakona yakumanja yakumanja pali lalikulu, polikoka, mutha kupitiliza mndandanda wazinthu zomwe zili ndi mtundu wina. Mwachitsanzo, ngati tsiku loyamba ndi Lolemba, ndiye pochita opareshoni yosavuta, mukhoza kuika mfundo zotsatirazi: Lachiwiri, Lachitatu, Lachinayi, Lachisanu, ndi zina zotero.
Ngati mu selo ngati 1,2,4 pali seti ya zikhalidwe, ndiye posankha zonse ndikukokera bokosi pansi, mukhoza kupitiriza mndandanda wa nambala mpaka 8, 16, 32, ndi zina zotero. Izi zimakuthandizani kuti muchepetse kwambiri ndalama za nthawi.
Momwemonso, mndandanda wa mayina a mwezi umapangidwa.
Ndipo izi ndi momwe kugwiritsa ntchito autocomplete pakukula kwa masamu kumawonekera. Muchitsanzo chathu, timagwiritsa ntchito ma cell awiri okhala ndi 1,3, motsatana, kenako autocomplete imapitiliza mndandanda wa manambala.
Komanso, kulandirira kudzagwira ntchito ngakhale nambala ili mkati mwazolemba. Mwachitsanzo, ngati mulemba "1 kotala" ndikukokera bokosi pansi, mumapeza zotsatirazi.
Kwenikweni, izi ndi zoyambira zonse zomwe muyenera kudziwa. Koma ngati mukufuna kudziwa luso logwira ntchito ndi Excel mwaukadaulo, mutha kuzolowera tchipisi ndi zidule.
Pogwiritsa ntchito Autocomplete Data List
Zachidziwikire, kupanga mndandanda wa miyezi kapena masiku a sabata sizomwe Excel ingachite. Tiyerekeze kuti tili ndi mndandanda wa mizinda yomwe kampani yathu yakhazikitsa malo ogwirira ntchito. Choyamba muyenera kulemba mndandanda wathunthu mu chinthu cha "Sinthani mindandanda", yomwe ingapezeke kudzera mu mndandanda wa mndandanda Fayilo - Zosankha - Zapamwamba - Zambiri - Sinthani mindandanda.
Kenako, zenera lidzawonekera ndi mndandanda wa mndandanda womwe umapangidwa mu Excel zokha.
Palibe ambiri a iwo pano. Koma kusamvetsetsa kumeneku kungakonzedwe mosavuta. Kuti muchite izi, pali zenera lakumanja lomwe kulembedwa kolondola kwamtengo wapatali uXNUMXbuXNUMXbis. Kujambulira kungatheke m'njira ziwiri, zonse ndi ma koma komanso muzambiri. Ngati pali deta yambiri, ikhoza kutumizidwa kunja. Mwanjira iyi mutha kusunga nthawi yambiri.
Chofunika ndi chiyani pa izi? Choyamba muyenera kupanga mndandanda wa mizinda kwinakwake mu chikalatacho, ndiyeno ingopangani ulalo kumunda womwe uli pansipa.
Mndandandawu tsopano wapangidwa ndipo ungagwiritsidwe ntchito kudzaza ma cell ena onse.
Kuphatikiza pa mindandanda yamalembedwe, Excel imapangitsa kuti zitheke kutsata manambala, komanso mndandanda wamasiku omwe amakonzedwa molingana ndi dongosolo linalake. Kumayambiriro kwa nkhaniyi, imodzi mwa njira zogwiritsira ntchito izo inaperekedwa, koma iyi ndi mlingo woyambirira. Mutha kugwiritsa ntchito chida ichi mosavuta, ngati ace weniweni.
Choyamba, timasankha mindandanda yofunikira (imodzi kapena zingapo) pamodzi ndi gawo lamitundu yomwe idzagwiritsidwe ntchito pamndandanda. Kenako, timapeza batani la "Dzazani" pagawo lapamwamba ndi menyu yomwe ikuwoneka, dinani batani la "Progression".
Kenako, zenera lokhala ndi zoikamo limawonekera.
Kumanzere kwake pali mabatani a wailesi omwe mungakhazikitse malo otsatizana amtsogolo: ndi mizere kapena mizati. Pachiyambi choyamba, mndandandawo udzatsikira pansi, ndipo kachiwiri, udzapita kumanja.
Pomwepo kumanja kwa malo osungirako pali gulu lomwe mungasankhe mtundu wa chiwerengero cha chiwerengero. Pali zingapo zomwe mungasankhe:
- Masamu. Mtengo mu selo iliyonse yotsatira ndi nambala inayake yaikulu kuposa yam'mbuyomo. Mtengo wake umatsimikiziridwa ndi zomwe zili mugawo la "Step".
- Zojambulajambula. Mtengo uliwonse wotsatira ndi wokulirapo kangapo kuposa wam'mbuyo. Zochuluka bwanji zimatengera sitepe yomwe wosuta wasonyeza.
- Madeti. Ndi njira iyi, wosuta akhoza kupanga ndondomeko ya masiku. Ngati musankha mtundu uwu, zokonda zina za muyeso zimatsegulidwa. Amaganiziridwa polemba ndondomekoyi: tsiku, tsiku logwira ntchito, mwezi, chaka. Chifukwa chake, ngati musankha chinthu cha "tsiku logwira ntchito", ndiye kuti kumapeto kwa sabata sikuphatikizidwa pamndandanda.
- Kumaliza zokha. Njirayi ikufanana ndi kukokera pansi kumanja ngodya. M'mawu osavuta, Excel imasankha yokha ngati ikufunika kupitiliza mndandanda wa manambala kapena ndikwabwino kupanga mndandanda wautali. Ngati mungatchule 2 ndi 4 pasadakhale, otsatirawa adzakhala ndi manambala 6, 8, ndi zina zotero. Ngati musanayambe kudzaza maselo ambiri, ndiye kuti ntchito ya "linear regression" idzagwiritsidwa ntchito (iyi ndi njira yosangalatsa kwambiri yomwe imakulolani kuti mupange zowonetseratu malinga ndi zomwe zilipo).
Pansi pa bokosi la zokambirana, monga mukuonera kale, pali njira ziwiri: kukula kwa sitepe, zomwe takambirana pamwambapa, ndi malire.
Mukamaliza ntchito zonse, muyenera kukanikiza batani "Chabwino". Momwemonso, mndandanda wa masiku ogwira ntchito kwa nthawi inayake umapangidwa (mwachitsanzo, mpaka 31.12.2020/XNUMX/XNUMX). Ndipo wosuta sayenera kupanga kuchuluka kwamayendedwe osafunikira!
Ndi zimenezotu, kukhazikitsa kwatha. Tsopano tiyeni tiwone njira zina zaukadaulo zomaliza.
Pogwiritsa ntchito mbewa
Iyi ndiye njira yabwino kwambiri yokwaniritsira zokha, kukulolani kuti muzichita zinthu zovuta kwambiri. Pali njira ziwiri za momwe mungagwiritsire ntchito: kugwiritsa ntchito batani lakumanzere kapena kumanja. Mwachitsanzo, ntchitoyo ndi kulemba mndandanda wa manambala okonzedwa mokwera, pamene mtengo uliwonse wotsatira umawonjezeka ndi chimodzi. Nthawi zambiri, pa izi, gawo limalowetsedwa mu cell yoyamba, ndi deuce yachiwiri, kenako amakoka bokosi pakona yakumanja yakumanja. Koma ndizotheka kukwaniritsa cholinga ichi ndi njira ina - mwa kungodzaza selo loyamba. Ndiye muyenera kuukokera pansi kuchokera pansi pomwe ngodya. Pambuyo pake, batani mu mawonekedwe a lalikulu lidzawonekera. Muyenera alemba izo ndi kusankha "Dzazani" chinthu.
Mutha kugwiritsanso ntchito "Dzazani mafomu okha", omwe mutha kuwonjezera mawonekedwe a cell okha.
Koma pali njira yachangu: kugwira Ctrl batani pamene kukokera selo mu kufanana.
Zowona, ndizoyenera kungomaliza motsatira manambala. Ngati mungayese kukoka chinyengo ichi ndi data yamtundu wina, ndiye kuti mfundo zauXNUMXbuXNUMX zimangokopera m'maselo otsatirawa.
Pali njira yofulumizitsa kuyimba kwa menyu yankhani. Kuti muchite izi, kokerani bokosilo pogwira batani lakumanja la mbewa.
Kenako gulu la malamulo lidzawoneka. Chifukwa chake, mutha kuyitanitsa bokosi lazokambirana ndi zosintha zina zowonjezera zokha podina chinthu cha "Kupititsa patsogolo". Koma pali malire amodzi. Kutalika kotsatizana kwakukulu mu nkhaniyi kudzakhala kokha ku selo lotsiriza.
Kuti kumalizidwa kokwanira kuchitike mpaka pamtengo wofunikira (nambala kapena tsiku linalake), muyenera kukanikiza batani lakumanja la mbewa, mutalozera cholozera m'bokosilo, ndikukokera cholembera pansi. Cholozera kenako chimabwerera. Ndipo chomaliza ndikumasula mbewa. Zotsatira zake, menyu yankhani yokhala ndi makonzedwe a autocomplete idzawonekera. Sankhani njira. Apa, selo limodzi lokha limasankhidwa, kotero muyenera kufotokoza magawo onse a autofill pazikhazikiko: malangizo, sitepe, mtengo wa malire, ndikusindikiza OK batani.
Ntchito yosangalatsa kwambiri ya Excel ndikuyandikira kwa mzere komanso kufotokozera. Zimapangitsa kukhala kotheka kupanga zolosera za momwe zikhalidwe zidzasinthira, kutengera mtundu womwe ulipo. Monga lamulo, kuti mupange kulosera, muyenera kugwiritsa ntchito ntchito zapadera za Excel kapena kuwerengera zovuta, momwe zikhalidwe zodziyimira pawokha zimasinthidwa. Ndikosavuta kuwonetsa chitsanzo ichi muzochita.
Mwachitsanzo, pali mphamvu ya chizindikiro, yomwe mtengo wake umawonjezeka ndi chiwerengero chomwecho nthawi iliyonse.
Ndizosavuta kumvetsetsa momwe zikhalidwe zimanenedweratu ndi mizere yozungulira (pamene chizindikiro chilichonse chotsatira chikuwonjezeka kapena kutsika ndi mtengo wina). Ntchito za Standard Excel ndizoyenera izi, koma ndi bwino kujambula chithunzi chomwe chikuwonetsa mzere wamayendedwe, equation ya ntchitoyo, ndi mtengo woyembekezeredwa kuti umveke bwino.
Kuti mudziwe chomwe chizindikirocho chidzakhala m'mawerengero, powerengera, muyenera kutenga regression equation ngati maziko (kapena gwiritsani ntchito ndondomeko zomwe zapangidwa mu Excel). Zotsatira zake, padzakhala zochita zambiri zomwe si aliyense amene angamvetse kuchokera pamleme.
Koma kusinthika kwa mzere kumakupatsani mwayi kuti musiye mafomu ovuta komanso kukonza chiwembu. Ingogwiritsani ntchito autocomplete. Wogwiritsa ntchito amatenga mitundu ingapo pazidziwitso zomwe zimapangidwira. Maselo awa amasankhidwa, ndiye kuti batani lakumanja la mbewa likukanidwa, lomwe muyenera kukokera mndandanda ndi chiwerengero chofunikira cha maselo (malingana ndi mtunda wa mfundoyi m'tsogolomu yomwe mtengo woloserawo umawerengedwa). Menyu yankhani idzawonekera, pomwe muyenera kusankha chinthu cha "Linear Approximation". Ndizomwezo, kulosera kumaperekedwa komwe sikufuna luso lapadera la masamu, kukonza chiwembu kapena kupeza njira.
Ngati zizindikiro zikuwonjezeka nthawi iliyonse ndi peresenti inayake, ndiye kuti tikukamba za kukula kwakukulu. Mwachitsanzo, kulosera za kusinthika kwa mliri kapena kulosera chiwongola dzanja cha deposit ku banki kumatengera njira yotereyi.
Palibenso njira ina yabwino yolosera kukula kokulirapo kuposa yomwe tafotokozayi.
Kugwiritsa ntchito mbewa kudzaza madeti
Nthawi zambiri pamafunika kuwonjezera mndandanda wamasiku omwe ulipo kale. Kuti muchite izi, tsiku lina limatengedwa ndikukokera pakona yakumanja yakumanja ndi batani lakumanzere. Chizindikiro cha square chikuwonekera, pomwe mungasankhe njira yodzaza.
Mwachitsanzo, ngati wowerengera ndalama amagwiritsa ntchito spreadsheet, njira ya "masiku a sabata" idzamuyenerera. Komanso, chinthuchi chidzafunidwa ndi akatswiri ena omwe ayenera kupanga mapulani a tsiku ndi tsiku, mwachitsanzo, HR.
Ndipo apa pali njira ina, momwe mungagwiritsire ntchito kudzaza madeti ndi mbewa. Mwachitsanzo, kampani iyenera kulipira malipiro pa 15 ndi tsiku lomaliza la mwezi. Kenako, muyenera kulowa masiku awiri, kuwatambasulira pansi ndikusankha njira yodzaza "ndi miyezi". Izi zitha kuchitika podina batani lakumanzere la mbewa pamalopo pakona yakumanja yakumanja, kapena kugwiritsa ntchito batani lakumanja, ndikutsata kuyimba kwazomwe zikuchitika.
Zofunika! Ya 15 imakhalabe, mosasamala kanthu za mwezi, ndipo yomaliza imakhala yokha.
Ndi batani lakumanja la mbewa mutha kusintha zomwe zikuchitika. Mwachitsanzo, lembani mndandanda wa masiku ogwira ntchito chaka chino, omwe adzakhalabe mpaka 31 December. Ngati mugwiritsa ntchito autofill ndi batani lakumanja la mbewa kapena kudzera pa menyu, yomwe imatha kupezeka pamtunda, ndiye kuti pali njira "Instant fill". Kwa nthawi yoyamba, opanga apereka izi mu Excel 2013. Ndikofunikira kuti maselo adzazidwe motsatira ndondomeko inayake. Izi zikuthandizani kuti musunge nthawi yambiri.
Mawuwo
Kwenikweni, ndizo zonse. Autocomplete ndi chinthu chothandiza kwambiri chomwe chimakuthandizani kuti muzitha kusintha magwiridwe antchito ambiri ndikulosera motengera mapatani. Palibe mafomu owonjezera kapena kuwerengera komwe kumafunikira. Ndikokwanira kukanikiza mabatani angapo, ndipo zotsatira zake zidzawoneka ngati zamatsenga.