Mukati
NeZhizha 2018 Updates, Excel 2016 yakagamuchira shanduko nyowani yekuwedzera rudzi rutsva rwe data kumaseru - mugove (Zvitoro) и mepu (Geography). Iyo inoenderana icons yakaonekwa pane iyo tab Data (Zuva) muboka Dhata Dhata (Data mhando):
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.
Kupinda mhando itsva yedata
Kuti tijekese, ngatitangei ne geodata totora tafura inotevera “yekuedza”:
Kutanga, sarudza woishandura kuita "smart" keyboard shortcut Ctrl+T kana kushandisa bhatani Fomati setafura Tab Home (Kumba - Fomati seTafura). Zvadaro sarudza mazita ose eguta uye sarudza rudzi rwe data Geography Tab Data (Zuva):
Chiratidzo chemepu chichaonekwa kuruboshwe kwemazita, zvichiratidza kuti Excel yaziva zvinyorwa muchitokisi sezita renzvimbo yenyika, guta, kana dunhu. Kudzvanya pane iyi icon kuchavhura hwindo rakanaka rine ruzivo rwechinhu ichi:
Izvo zvisina kuzivikanwa otomatiki zvichamakwa nemucherechedzo wemubvunzo, kana wadzvanywa, pani ichaonekwa kurudyi, kwaunogona kukwenenzvera chikumbiro kana kuisa imwe data:
Mamwe mazita anogona kuva nezvaanoreva zviviri, semuenzaniso Novgorod anogona kunge ari maviri Nizhny Novgorod uye Veliky Novgorod. Kana Excel isingaizive sezvainofanirwa, saka unogona kudzvanya-kurudyi pachitokisi uye wosarudza iwo rairo Data Type - Shanduko (Rudzi rweData - Rongedza), wobva wasarudza sarudzo chaiyo kubva kune inopihwa mupaneru kurudyi:
Kuwedzera Detail Columns
Iwe unogona nyore kuwedzera mamwe makoramu ane ruzivo rwechinhu chimwe nechimwe patafura yakagadzirwa. Semuenzaniso, kumaguta, unogona kuwedzera makoramu ane zita redunhu kana dunhu (admin chikamu), nharaunda (nzvimbo), nyika (nyika / dunhu), zuva rakavambwa (zuva rakavambwa), huwandu hwevanhu (huwandu), latitude uye kureba. (latitude, longitude) uye kunyange zita rameya (mutungamiri).
Kuti uite izvi, unogona kudzvanya pane pop-up icon pakona yepamusoro yekurudyi yetafura:
... kana shandisa fomula inonongedzera kune sero riri padyo wowedzera doti kwairi, wobva wasarudza sarudzo yaunoda kubva pane yekudonhedza-pasi rondedzero yezviyero:
... kana kungogadzira imwe koramu, uchiitumidza nezita rakakodzera (Population, Agents etc.) kubva pane yekudonhedza pasi ine mazano:
Kana iwe ukaedza zvese izvi pakholamu kwete nemaguta, asi nenyika, unogona kuona mamwe minda:
Heano zviratidzo zvehupfumi (mari inowanikwa pamunhu, chiyero chekushaikwa kwemabasa, mitero), uye vanhu (kubereka, kufa), uye geographical (nzvimbo yesango, CO2 emissions) nezvimwe zvakawanda - inenge 50 parameters yose.
Kunobva ruzivo urwu rwese iInternet, injini yekutsvaga Bing uye Wikipedia, iyo isingapfuuri pasina mutsara - chinhu ichi hachizivi zvinhu zvakawanda zveNyika Yedu kana kupa kunze nenzira yakakanganiswa. Semuenzaniso, pakati pemeya, Sobyanin naPoltavchenko chete ndivo vanopa, uye anofunga nezveguta rakakura kwazvo muNyika Yedu ... haufe wakafungidzira kuti ndeipi! (kwete Moscow).
Panguva imwecheteyo, kune States (maererano nekuona kwangu), iyo system inoshanda zvakanyanya nekuvimbika, izvo hazvishamise. Zvakare kuUSA, pamusoro pemazita enzvimbo dzekugara, unogona kushandisa ZIP kodhi (chimwe chinhu chakaita seyedu yepositi kodhi), iyo inonyatso ratidza pachena nzvimbo dzekugara uye kunyange matunhu.
Kusefa neinoperera parameters
Seyakanaka mhedzisiro, kushandura maseru kuita mhando nyowani dzedata kunoita kuti zvikwanise kusefa makoramu akadaro gare gare pane akajeka maparamendi kubva kune izvo. Saka, semuenzaniso, kana iyo data iri mukoramu ichizivikanwa seGeography, unogona kusefa runyorwa rwemaguta nenyika, kunyangwe pasina koramu ine zita renyika:
Ratidza pamepu
Kana iwe ukashandisa mutafura inocherechedzwa mazita enzvimbo kwete emaguta, asi enyika, matunhu, matunhu, mapurovhinzi kana matunhu, saka izvi zvinoita kuti zvikwanise kugadzira mepu yekuona uchishandisa tafura yakadaro uchishandisa mhando nyowani yemachati. Cartograph Tab Pinza – Mepu (Isa - Mepu):
For example, for regions, territories and republics, this looks very nice:
Ehe, hazvifanirwe kuona chete data kubva kune yakarongwa runyorwa rwemashoko. Panzvimbo yehuwandu hwevanhu, unogona kuratidza chero parameters uye KPIs nenzira iyi - kutengesa, nhamba yevatengi, nezvimwe.
Stock data type
Yechipiri dhata mhando, Stocks, inoshanda nenzira imwecheteyo, asi yakagadzirirwa kuziva ma stock indices:
... uye mazita emakambani nemazita avo akapfupikiswa (tickers) pakutsinhana:
Ndokumbira utarise kuti kukosha kwemusika (market cap) kunopihwa nekuda kwechimwe chikonzero muzvikamu zvakasiyana zvemari, zvakanaka, chinhu ichi hachizivi Gref naMiller, zviri pachena 🙂
Ndinoda kukuyambirai ipapo kuti kushandisa zvese izvi zvekutengesa hazvishande zvakanaka, nekuti. iyo data inovandudzwa kamwe chete pazuva, iyo, kazhinji, inononoka pakutengesa. Kuti uwane mamwe magadzirirwo enguva dzose uye ruzivo rwemazuva ano, zviri nani kushandisa macros kana mibvunzo kuchinjanisa kuburikidza neInternet uchishandisa Power Query.
Remangwana remhando itsva dze data
Pasina kupokana, uku kunongova kutanga, uye Microsoft ingangowedzera seti yemhando nyowani dze data. Zvichida, nekufamba kwenguva, iwe neni tichava nemukana wekugadzira isu pachedu mhando, dzakarodzwa kune chaiwo mabasa ebasa. Fungidzira mhando, semuenzaniso, yekuratidza data nezve mushandi kana mutengi, ine yake yega data uye kunyange mufananidzo:
Mamaneja eHR angade chinhu chakadaro, iwe unofungei?
Kana kuti fungidzira rudzi rwe data rinochengeta ruzivo (saizi, uremu, ruvara, mutengo) wechinhu chimwe nechimwe kana sevhisi pane mutengo runyorwa. Kana kuti mhando ine nhamba dzemutambo wechimwe chikwata chenhabvu. Kana nhoroondo yemamiriro ekunze data? Kuregererei?
Ndine chokwadi chekuti tine zvakawanda zvinonakidza zvinhu pamberi 🙂
- Ngenisa bitcoin mwero kubva pamhepo kuchinjana kuenda kuExcel uchishandisa Power Query
- Kuona geodata pamepu muExcel
- Kushandura kukosha neCONVERT basa