Kugwiritsa ntchito kutanthauzira mu Microsoft Excel

Pali zotheka kuti pazotsatira zingapo zomwe mumafunikira muyenera kupeza zotsatira zapakatikati. Mu masamu, izi zimatchedwa kutanthauzira. Mu Excel, njirayi itha kugwiritsidwa ntchito pa data ya tabular komanso kujambula. Tiona njira zonsezi.

Kugwiritsa ntchito kumasulira

Mulingo wawukulu womwe ungagwiritse ntchito kutanthauzira ndikuti phindu lomwe likufunikira liyenera kukhala mkati mwazosanjidwa, osapitirira malire ake. Mwachitsanzo, ngati tili ndi mipikisano 15, 21, ndi 29, ndiye kuti tikapeza ntchito yotsutsa 25, titha kugwiritsa ntchito kutanthauzira. Ndipo pofunafuna mtengo wofananira wotsutsa 30, kulibenso. Uyu ndiye kusiyana kwakukulu pakati pa njirayi ndi kupezekanso.

Njira 1: kutanthauzira kwa ma tabular data

Choyamba, lingalirani kugwiritsa ntchito kumasulira kwa zomwe zimapezeka patebulopo. Mwachitsanzo, timakhala ndi zotsutsana zingapo komanso zogwirizana ndi ntchito, mgwirizano womwe ungafotokozeredwe ndi gulu lolumikizana. Izi zimayikidwa patebulo pansipa. Tiyenera kupeza ntchito yoyenera yotsutsa 28. Njira yosavuta yochitira izi ndi wothandizira. CHITSANZO.

1. Sankhani khungu lopanda kanthu patsamba lomwe wosuta akukonzekera kuwonetsa zomwe zachitika. Kenako, dinani batani. "Ikani ntchito", yomwe ili kumanzere kwa baramu yamu formula.



2. Zenera limayatsidwa Ogwira Ntchito. Gulu "Masamu" kapena "Mndandanda wathunthu wa zilembo" kufunafuna dzina "PREDICTION". Mtengo wofanana utapezeka, sankhani ndikudina batani "Zabwino".



3. Tsamba la mkangano wa ntchito likuyamba CHITSANZO. Ili ndi magawo atatu:
   • X;
   • Mfundo zodziwika bwino;
   • Makhalidwe Abwino a x.

   Mchigawo choyamba, timangofunika kulowetsa pamanja mfundo zotsutsana kuchokera kiyibodi, ntchito yomwe iyenera kupezeka. M'malo mwathu, izi 28.

   M'munda Mfundo zodziwika bwino muyenera kufotokozera magwirizanidwe amtundu wa tebulo momwe zofunikira zogwiridwira ntchito zilimo. Izi zitha kuchitika pamanja, koma ndizosavuta komanso zosavuta kukhazikitsa cholozera m'munda ndikusankha zogwirizana ndi pepalalo.

   Chomwechonso khalani m'munda Makhalidwe Abwino a x mitundu imagwirizana ndi zotsutsana.

   Pambuyo pazofunikira zonse zololedwa, dinani batani "Zabwino".



4. Mtengo wofunikira udziwonetsedwa mu khungu lomwe tidasankha mu gawo loyamba la njirayi. Zotsatira zake ndi nambala 176. Zikhala chifukwa cha kutanthauzira.

Phunziro: Excel Feature Wizard

Njira 2: samasulira graph pogwiritsa ntchito mawonekedwe ake

Njira yotanthauzira ingagwiritsidwenso ntchito pokonza ntchito. Ndizofunikira ngati tebulo pamaziko omwe graph imapangidwira silikuwonetsa ntchito yogwirizana ya imodzi mwa zotsutsana, monga chithunzi pansipa.

1. Timakonza njira yanthawi zonse. Ndiye kuti, kukhala tabu Ikani, sankhani magawo pamiyeso yomwe ntchitoyi ichitikira. Dinani pachizindikiro Tchatikuyikidwa mu chipangizo Ma chart. Kuchokera pamndandanda wazithunzi zomwe zimawonekera, timasankha zomwe timaziona kuti ndizoyenera pazomwezi.



2. Monga mukuwonera, ndandanda imamangidwa, koma osati momwe timafunira. Choyamba, imasweka, chifukwa pamfundo imodzi ntchito yofananira sinapezeke. Kachiwiri, pali mzere wowonjezera pa icho X, yomwe pankhaniyi siyofunika, komanso pamakona otsetsereka ndi mfundo chabe, osati mtengo wotsutsa. Tiyeni tiyesetse kukonza zonsezi.

   Choyamba, sankhani chingwe cholimba cha buluu chomwe mukufuna kuti muchotse ndikudina batani Chotsani pa kiyibodi.



3. Sankhani ndege yonse yomwe chati Pazosankha zomwe zikuwoneka, dinani batani "Sankhani zambiri ...".



4. Zenera losankha deta limayamba. Pamalo abwino Chizindikiro cha nkhwangwa yopingasa dinani batani "Sinthani".



5. Zenera laling'ono limatseguka pomwe muyenera kufotokozera zogwirizanitsa zamtunduwo, zomwe zimatsimikizika kuchokera pazomwe zimawonetsedwa pamakwerero olondola. Khazikitsani chotembezera m'munda Axis Label Range ndikungosankha zomwe zikugwirizana pa pepalalo, zomwe zimakhala ndi zotsutsana za ntchitoyo. Dinani batani "Zabwino".



6. Tsopano tikuyenera kumaliza ntchito yayikulu: kuchotsa kusiyana pogwiritsa ntchito kutanthauzira. Kubwerera ku tsambalo losankha zenera, dinani batani Maselo obisika komanso opanda kanthuili kumunsi kwakumanzere.



7. Zenera loyika maselo obisika komanso opanda kanthu limatseguka. Pamagawo Onetsani maselo opanda kanthu ikani kusintha "Mzere". Dinani batani "Zabwino".



8. Mukabwereranso pazenera losankha, onetsetsani kusintha konse komwe kudachitika podina batani "Zabwino".

Monga mukuwonera, graph imasinthidwa, ndipo kusiyana pogwiritsa ntchito kumasulira kumachotsedwa.

Phunziro: Momwe mungapangire chiwembu ku Excel

Njira 3: gwiritsani ntchito graph

Mutha kutanthauzanso graph pogwiritsa ntchito ND yapadera. Imabweza mitengo yosasindikizidwa ku khungu lomwe ladziwika.

1. Tchati chikamangidwa ndikusinthidwa, monga muyenera, kuphatikizanso kuyika kolondola kwa siginecha, mutha kungotseka kusiyana. Sankhani khungu lopanda kanthu patebulopo pomwe deta imakokedwa. Dinani pa chithunzi chomwe tikudziwa kale "Ikani ntchito".



2. Kutsegula Fotokozerani Wizard. Gulu "Kutsimikizira Zogulitsa ndi Makhalidwe" kapena "Mndandanda wathunthu wa zilembo" pezani ndikuwonetsa cholowacho "ND". Dinani batani "Zabwino".



3. Ntchitoyi ilibe kutsutsana, monga momwe zanenera zidziwitso zimawonekera. Kuti mutseke, dinani batani "Zabwino".



4. Pambuyo pa izi, mtengo wolakwika udawonekera mu foni yosankhidwa "# N / A", koma ndiye, monga mukuwonera, kuswa mu ndandanda kunangochotsedwa.

Itha kupangidwa kukhala yosavuta popanda kuyamba Fotokozerani Wizard, koma ingogwiritsani ntchito kiyibodi yoyendetsa mtengo kuti mu cell yopanda kanthu "# N / A" opanda mawu. Koma zimatengera kale kuti ndi wogwiritsa ntchito uti amene ali wosavuta.

Monga mukuwonera, mu pulogalamu ya Excel, mutha kumasulira ngati deta ya tabular pogwiritsa ntchito ntchitoyo CHITSANZO, ndi zithunzi. Pomaliza, izi ndizotheka kugwiritsa ntchito masanjidwewo kapena kugwiritsa ntchito ntchitoyo Ndkuyambitsa cholakwika "# N / A". Kusankha njira yomwe mungagwiritse ntchito zimatengera zomwe ananena, komanso zomwe munthu angafune.