Contents
Me ka Summer 2018 Updates, ua loaʻa iā Excel 2016 kahi mana hou e hoʻohui i kahi ʻano ʻikepili hou i nā cell - Māhele (Stocks) и Map (Geography). Ua ʻike ʻia nā kiʻi like ʻole ma ka pā 'Ikepili (Lā) ma ka hui ʻAno ʻIkepili (ʻAno ʻikepili):
He aha ia a he aha ka mea e ʻai ʻia ai? Pehea e hoʻohana ai i kēia ma ka hana? He aha ka ʻāpana o kēia hana e pili ana i kā mākou ʻoiaʻiʻo? E noʻonoʻo kākou.
Ke komo nei i kahi ʻano ʻikepili hou
No ka akaka, e hoʻomaka kākou me ka geodata a lawe i ka papa "no nā hoʻokolohua":
ʻO ka mea mua, koho iā ia a hoʻololi iā ia i kahi pōkole keyboard "akamai". Ctrl+T a i ʻole ka hoʻohana ʻana i ke pihi Hōʻano ma ke ʻano he pākaukau uku pila Home (Home — Hōpili e like me ka Papa). A laila koho i nā inoa kūlanakauhale a pau a koho i ke ʻano ʻikepili ʻO Geography uku pila 'Ikepili (Lā):
E hōʻike ʻia kahi kiʻi palapala palapala ma ka ʻaoʻao hema o nā inoa, e hōʻike ana ua ʻike ʻo Excel i ka kikokikona i loko o ke kelepona ʻo ia ka inoa ʻāina o kahi ʻāina, kūlanakauhale, a i ʻole ka ʻāina. Ke kaomi ʻana i kēia ikona e wehe i kahi puka aniani nani me nā kikoʻī o kēia mea:
ʻO ka mea i ʻike ʻole ʻia e hōʻailona ʻia me kahi māka nīnau, ke kaomi ʻia, e ʻike ʻia kahi panel ma ka ʻākau, kahi e hiki ai iā ʻoe ke hoʻomaʻemaʻe i ka noi a i ʻole ke komo ʻana i nā ʻikepili hou aʻe:
Hiki i kekahi mau inoa ke loaʻa ka manaʻo ʻelua, no ka laʻana ʻo Novgorod hiki iā Nizhny Novgorod a me Veliky Novgorod. Inā ʻaʻole ʻike ʻo Excel e like me ka mea e pono ai, a laila hiki iā ʻoe ke kaomi ʻākau ma ke kelepona a koho i ke kauoha ʻAno ʻIkepili - Hoʻololi (ʻAno ʻIkepili — Hoʻoponopono), a laila koho i ke koho pololei mai nā mea i hāʻawi ʻia ma ka panel ma ka ʻākau:
Hoʻohui i nā kolamu kikoʻī
Hiki iā ʻoe ke hoʻohui i nā kolamu hou me nā kikoʻī no kēlā me kēia mea i ka papa i hana ʻia. No ka laʻana, no nā kūlanakauhale, hiki iā ʻoe ke hoʻohui i nā kolamu me ka inoa o ka ʻāina a i ʻole ka ʻāina (māhele admin), ʻāpana (wahi), ʻāina ('āina / ʻāina), lā i hoʻokumu ʻia (lā i hoʻokumu ʻia), heluna kanaka (ka lehulehu), latitude a me longitude. (latitu, longitude) a me ka inoa o ka mayor (alakaʻi).
No ka hana ʻana i kēia, hiki iā ʻoe ke kaomi i ka ikona pop-up ma ke kihi ʻākau o luna o ka papa:
… a i ʻole e hoʻohana i kahi ʻano e pili ana i kahi cell pili a hoʻohui i kahi kiko iā ia, a laila koho i ke koho i makemake ʻia mai ka papa inoa hāʻule iho o nā hōʻailona:
... a i ʻole e hana i kahi kolamu ʻē aʻe, e kapa ʻia me ka inoa kūpono (Ka heluna kanaka, konohiki etc.) mai ka papa inoa hāʻule iho me nā hōʻailona:
Inā ʻoe e hoʻāʻo i kēia mau mea a pau ma ke kolamu ʻaʻole me nā kūlanakauhale, akā me nā ʻāina, hiki iā ʻoe ke ʻike i nā māla hou aʻe:
Eia nā hōʻailona hoʻokele waiwai (loaʻa no kēlā me kēia kapita, uku hana ʻole, ʻauhau), a me ke kanaka (fertility, mortality), a me ka ʻāina (ka ululāʻau, CO2 emissions) a ʻoi aku - kokoke i 50 mau palena.
ʻO ke kumu o kēia ʻike a pau ʻo ia ka Pūnaewele, ka ʻenekini ʻimi Bing a me Wikipedia, ʻaʻole e hele me ka ʻike ʻole ʻia - ʻaʻole ʻike kēia mea i nā mea he nui no ko mākou ʻāina a i ʻole hāʻawi ʻia ma kahi ʻano ʻino. No ka laʻana, ma waena o nā mayors, ʻo Sobyanin a me Poltavchenko wale nō ka hāʻawi ʻana, a manaʻo ʻo ia ʻo ke kūlanakauhale nui loa ma Ko mākou ʻāina ... ʻaʻole ʻoe e koho i ka mea! (ʻaʻole Moscow).
I ka manawa like, no nā Moku'āina (e like me kaʻu mau ʻike), ʻoi aku ka hilinaʻi o ka ʻōnaehana, ʻaʻole ia he mea kupanaha. No USA kekahi, ma ka hoʻohui ʻana i nā inoa o nā noho, hiki iā ʻoe ke hoʻohana i kahi code ZIP (kahi mea e like me kā mākou code postal), kahi i ʻike maopopo ʻole ai i nā noho a me nā ʻāpana.
Ke kānana ʻana ma nā ʻāpana ʻokoʻa
Ma ke ʻano he hopena ʻaoʻao maikaʻi, ʻo ka hoʻohuli ʻana i nā cell i nā ʻano ʻikepili hou e hiki ai ke kānana i kēlā mau kolamu ma hope o nā ʻāpana implicit mai nā kikoʻī. No laila, no ka laʻana, inā ʻike ʻia ka ʻikepili ma ke kolamu ʻo Geography, a laila hiki iā ʻoe ke kānana i ka papa inoa o nā kūlanakauhale ma ka ʻāina, ʻoiai inā ʻaʻohe kolamu me ka inoa o ka ʻāina:
Hōʻike ma ka palapala ʻāina
Inā ʻoe e hoʻohana ma ka papa ʻaina i nā inoa ʻāina ʻaʻole no nā kūlanakauhale, akā no nā ʻāina, nā ʻāpana, nā ʻāpana, nā panalāʻau a i ʻole nā mokuʻāina, a laila hiki iā ia ke kūkulu i kahi palapala ʻāina ʻike me ka hoʻohana ʻana i kēlā papa me ka hoʻohana ʻana i kahi ʻano palapala hou. Kāleka uku pila Hoʻokomo – Nā palapala ʻāina (Hookomo — palapala aina):
No ka laʻana, no nā ʻāpana, nā ʻāina a me nā repubalika, maikaʻi loa kēia:
ʻOiaʻiʻo, ʻaʻole pono e nānā wale i ka ʻikepili mai ka papa inoa o nā kikoʻī i manaʻo ʻia. Ma kahi o ka heluna kanaka, hiki iā ʻoe ke hōʻike i nā ʻāpana a me nā KPI ma kēia ala - kūʻai aku, helu o nā mea kūʻai aku, etc.
ʻAno ʻikepili waihona
ʻO ka ʻano ʻikepili ʻelua, ʻo Stocks, hana ma ke ʻano like, akā ua hoʻopili ʻia no ka ʻike ʻana i nā helu waiwai:
… a me nā inoa o nā hui a me ko lākou mau inoa pōkole (tickers) ma ka hoʻololi:
E ʻoluʻolu e hāʻawi ʻia ke kumukūʻai mākeke (palena mākeke) no kekahi kumu i nā ʻāpana kālā like ʻole, maikaʻi, ʻaʻole ʻike kēia mea iā Gref a me Miller, maopopo 🙂
Makemake wau e aʻo koke iā ʻoe ʻaʻole e hana maikaʻi ka hoʻohana ʻana i kēia mau mea no ke kālepa ʻana, no ka mea. Hoʻololi hou ʻia ka ʻikepili i hoʻokahi manawa wale nō i ka lā, ʻo ia hoʻi, i ka nui o nā hihia, lohi loa no ke kālepa ʻana. No ka hoʻonui pinepine ʻana a me ka ʻike hou, ʻoi aku ka maikaʻi o ka hoʻohana ʻana i nā macros a i ʻole nā nīnau e hoʻololi ai ma o ka Pūnaewele me ka Power Query.
ʻO ka wā e hiki mai ana o nā ʻano ʻikepili hou
ʻO ka mea kānalua, ʻo ka hoʻomaka wale nō kēia, a e hoʻonui paha ʻo Microsoft i ka hoʻonohonoho o ia ʻano ʻikepili hou. Malia paha, i ka wā lōʻihi, e loaʻa iā ʻoe a me aʻu ka manawa e hana ai i kā mākou ʻano ponoʻī, i hoʻomaʻamaʻa ʻia no nā hana hana kikoʻī. E noʻonoʻo i kahi ʻano, no ka laʻana, no ka hōʻike ʻana i ka ʻikepili e pili ana i kahi limahana a mea kūʻai paha, i loaʻa kāna ʻikepili pilikino a me kahi kiʻi paha:
Makemake nā luna HR i kēlā mea, pehea kou manaʻo?
A i ʻole e noʻonoʻo i kahi ʻano ʻikepili e mālama i nā kikoʻī (ka nui, ke kaumaha, ke kala, ke kumukūʻai) o kēlā me kēia mea a i ʻole lawelawe ma kahi papa inoa. A i ʻole he ʻano i loaʻa nā helu pāʻani āpau o kekahi hui pôpeku. A i ʻole ka ʻikepili o ka wā kahiko? Kainō?
Manaʻo wau he nui nā mea hoihoi ma mua 🙂
- Hoʻokomo i ka helu bitcoin mai ka hoʻololi pūnaewele i Excel me ka hoʻohana ʻana i ka Power Query
- ʻO ka ʻike ʻana i ka geodata ma kahi palapala ʻāina ma Excel
- Ke hoʻololi nei i nā waiwai me ka hana CONVERT