Zamkatimu
Ndi Zosintha za Chilimwe cha 2018, Excel 2016 idalandira luso latsopano lowonjezera mtundu watsopano wa data pama cell - magawo (Stocks) и Map (Geography). Zithunzi zofananira zidawonekera pa tabu Deta (Tsiku) pagulu Mitundu Yambiri (mitundu yama data):
What is it and what is it eaten with? How can this be used at work? What part of this functionality is applicable to our reality? Let’s figure it out.
Kulowetsa mtundu watsopano wa data
Kuti timveke bwino, tiyeni tiyambe ndi geodata ndikutenga tebulo ili "loyesa":
Choyamba, sankhani ndikusintha kukhala njira yachidule ya kiyibodi ya "smart". Ctrl+T kapena kugwiritsa ntchito batani Pangani ngati tebulo tsamba Kunyumba (Kunyumba - Pangani Monga Table). Kenako sankhani mayina onse amizinda ndikusankha mtundu wa data Geography tsamba Deta (Tsiku):
Chizindikiro cha mapu chidzawonekera kumanzere kwa mayina, kusonyeza kuti Excel yazindikira malemba omwe ali mu selo ngati dzina la malo a dziko, mzinda, kapena dera. Kudina chizindikirochi kudzatsegula zenera lokongola lomwe lili ndi zambiri za chinthu ichi:
Zomwe sizinadziwike zokha zidzalembedwa ndi funso, mukadina, gulu lidzawoneka kumanja, komwe mungayesere pempholo kapena kuyika zina zowonjezera:
Mayina ena amatha kukhala ndi matanthauzo awiri, mwachitsanzo Novgorod akhoza kukhala Nizhny Novgorod ndi Veliky Novgorod. Ngati Excel siyikuzindikira momwe iyenera kukhalira, ndiye kuti mutha dinani kumanja pa selo ndikusankha lamulo Mtundu wa Data - Kusintha (Mtundu Wa data - Sinthani), kenako sankhani njira yoyenera kuchokera pa zomwe zaperekedwa pagawo lakumanja:
Kuwonjezera Tsatanetsatane Columns
Mutha kuwonjezera mizati yowonjezera ndi tsatanetsatane wa chinthu chilichonse patebulo lopangidwa. Mwachitsanzo, m'mizinda, mutha kuwonjezera zipilala ndi dzina la chigawo kapena dera (gawo la admin), dera (dera), dziko (dziko / dera), tsiku lokhazikitsidwa (tsiku lokhazikitsidwa), kuchuluka kwa anthu (anthu), latitude ndi longitude. (latitude, longitude) ndipo ngakhale dzina la meya (mtsogoleri).
Kuti muchite izi, mutha kudina chizindikiro cha pop-up pakona yakumanja kwa tebulo:
…
... kapena ingopangani gawo lina, ndikulitchula ndi dzina loyenera (Anthu, wothandizila etc.) kuchokera pamndandanda wotsikira pansi wokhala ndi malangizo:
Mukayesa zonsezi pamndandanda osati ndi mizinda, koma ndi mayiko, mutha kuwona magawo enanso:
Nazi zizindikiro zachuma (ndalama pa munthu aliyense, kuchuluka kwa ulova, misonkho), ndi anthu (chonde, kufa), ndi malo (dera la nkhalango, mpweya wa CO2) ndi zina zambiri - pafupifupi magawo 50 onse.
Gwero la chidziwitso chonsechi ndi intaneti, injini yofufuzira Bing ndi Wikipedia, yomwe siimadutsa popanda kufufuza - chinthu ichi sichidziwa zinthu zambiri za Dziko Lathu kapena chimapereka mawonekedwe opotoka. Mwachitsanzo, pakati pa mameya, ndi Sobyanin ndi Poltavchenko okha omwe amapereka, ndipo amawona mzinda waukulu kwambiri m'dziko lathu ... simudzaganiza kuti ndi uti! (osati Moscow).
Nthawi yomweyo, ku States (malinga ndi zomwe ndawonera), dongosololi limagwira ntchito modalirika kwambiri, zomwe sizodabwitsa. Komanso ku USA, kuwonjezera pa mayina a malo okhala, mutha kugwiritsa ntchito zip code (chinthu ngati nambala yathu ya positi), yomwe imazindikiritsa malo okhala komanso zigawo.
Kusefa ndi magawo osamveka
Monga mbali yabwino, kutembenuza ma cell kukhala mitundu yatsopano ya data kumapangitsa kuti zitheke kusefa zipilala zotere pambuyo pake pamagawo osamveka kuchokera mwatsatanetsatane. Kotero, mwachitsanzo, ngati deta yomwe ili m'ndandanda imadziwika kuti Geography, ndiye kuti mukhoza kusefa mndandanda wa mizinda ndi dziko, ngakhale ngati palibe ndime yomwe ili ndi dzina la dziko:
Onetsani pamapu
Ngati mugwiritsa ntchito patebulo lodziwika mayina a malo osati amizinda, koma mayiko, zigawo, zigawo, zigawo kapena zigawo, ndiye kuti mutha kupanga mapu owoneka pogwiritsa ntchito tebulo lotere pogwiritsa ntchito mtundu watsopano wa ma chart. Zojambula tsamba Ikani - Mapu (Ikani - Mapu):
For example, for regions, territories and republics, this looks very nice:
Inde, sikofunikira kuti muwonetsetse deta yokhayo kuchokera pamndandanda watsatanetsatane watsatanetsatane. M'malo mwa kuchuluka kwa anthu, mutha kuwonetsa magawo ndi KPIs mwanjira iyi - malonda, kuchuluka kwa makasitomala, ndi zina.
Mtundu wa data ya stock
Mtundu wachiwiri wa data, Stocks, umagwira ntchito chimodzimodzi, koma umapangidwira kuzindikira ma indices:
... ndi mayina amakampani ndi mayina awo achidule (tickers) pakusinthana:
Chonde dziwani kuti mtengo wamsika (msika wamsika) umaperekedwa pazifukwa zina m'magawo osiyanasiyana andalama, chabwino, chinthu ichi sichikudziwa Gref ndi Miller, mwachiwonekere 🙂
Ndikufuna kukuchenjezani nthawi yomweyo kuti kugwiritsa ntchito zonsezi pochita malonda sikungagwire ntchito bwino, chifukwa. deta imasinthidwa kamodzi kokha patsiku, zomwe, nthawi zambiri, zimakhala zochedwa kwambiri pa malonda. Kuti mupeze zosintha pafupipafupi komanso zaposachedwa, ndikwabwino kugwiritsa ntchito ma macros kapena mafunso posinthana pa intaneti pogwiritsa ntchito Power Query.
Tsogolo la mitundu yatsopano ya data
Mosakayikira, ichi ndi chiyambi chabe, ndipo Microsoft ikulitsa mtundu wamitundu yatsopano yotere. Mwina, pakapita nthawi, inu ndi ine tidzakhala ndi mwayi wopanga mitundu yathu, yokonzedwa kuti igwire ntchito zinazake. Tangoganizani mtundu, mwachitsanzo, wowonetsa zambiri za wogwira ntchito kapena kasitomala, wokhala ndi chidziwitso chake komanso chithunzi:
Oyang'anira HR angafune izi, mukuganiza bwanji?
Kapena lingalirani mtundu wa data womwe umasunga tsatanetsatane (kukula, kulemera, mtundu, mtengo) wa chinthu chilichonse kapena ntchito pamndandanda wamitengo. Kapena mtundu womwe uli ndi ziwerengero zonse zamasewera a timu inayake ya mpira. Kapena mbiri yakale yanyengo? Kulekeranji?
Ndikutsimikiza kuti tili ndi zinthu zambiri zosangalatsa 🙂
- Lowetsani mtengo wa bitcoin kuchokera pakusinthana pa intaneti kupita ku Excel pogwiritsa ntchito Power Query
- Kuwona kwa geodata pamapu mu Excel
- Kutembenuza ma values ndi ntchito ya CONVERT