txheem
Nrog rau Lub Caij Ntuj Sov 2018 Hloov Kho, Excel 2016 tau txais kev hloov pauv tshiab muaj peev xwm ntxiv cov ntaub ntawv tshiab rau cov hlwb - Shares (Cov khoom lag luam) и Daim ntawv qhia (Geography). Cov cim sib thooj tau tshwm sim ntawm lub tab Cov ntaub ntawv (Hnub) hauv pab pawg Cov hom ntaub ntawv (Cov ntaub ntawv hom):
Nws yog dab tsi thiab nws noj nrog dab tsi? Yuav siv qhov no li cas hauv kev ua haujlwm? Dab tsi ntawm qhov kev ua haujlwm no siv tau rau peb qhov kev muaj tiag? Cia peb xav txog nws.
Nkag mus rau hom ntaub ntawv tshiab
Kom meej meej, cia peb pib nrog geodata thiab coj cov lus hauv qab no "rau kev sim":
Ua ntej, xaiv nws thiab tig mus rau hauv "ntse" keyboard shortcut Ctrl+T los yog siv lub khawm Format ua ib lub rooj tab Tsev (Lub Tsev — Format as Table). Tom qab ntawd xaiv tag nrho cov npe hauv nroog thiab xaiv hom ntaub ntawv Geography tab Cov ntaub ntawv (Hnub):
Daim ntawv qhia lub cim yuav tshwm rau sab laug ntawm cov npe, qhia tias Excel tau lees paub cov ntawv hauv lub xov tooj ntawm tes ua lub npe thaj chaw ntawm lub tebchaws, nroog, lossis cheeb tsam. Nyem rau ntawm lub cim no yuav qhib lub qhov rais zoo nkauj nrog cov ntsiab lus ntawm cov khoom no:
Dab tsi tsis lees paub yuav raug cim nrog cov lus nug, thaum nias, lub vaj huam sib luag yuav tshwm nyob rau sab xis, qhov twg koj tuaj yeem kho qhov kev thov lossis sau cov ntaub ntawv ntxiv:
Qee lub npe tuaj yeem muaj ob lub ntsiab lus, piv txwv li Novgorod tuaj yeem yog Nizhny Novgorod thiab Veliky Novgorod. Yog tias Excel tsis paub nws raws li nws yuav tsum tau, ces koj tuaj yeem nyem rau ntawm lub cell thiab xaiv cov lus txib Hom ntaub ntawv – Hloov (Cov ntaub ntawv hom - Kho kom raug), thiab tom qab ntawd xaiv qhov kev xaiv raug los ntawm cov uas muaj nyob rau hauv lub vaj huam sib luag ntawm sab xis:
Ntxiv cov kab lus nthuav dav
Koj tuaj yeem yooj yim ntxiv kab ntxiv nrog cov ntsiab lus rau txhua yam khoom rau lub rooj tsim. Piv txwv li, rau cov nroog, koj tuaj yeem ntxiv cov kab nrog lub npe ntawm cheeb tsam lossis cheeb tsam (admin faib), cheeb tsam (chaw), lub teb chaws (lub teb chaws / cheeb tsam), hnub tsim (hnub tsim), pejxeem (pej xeem), latitude thiab longitude (latitude, longitude) thiab txawm lub npe ntawm tus kav nroog (tus thawj coj).
Txhawm rau ua qhov no, koj tuaj yeem nyem rau ntawm lub icon pop-up nyob rau sab xis sab xis ntawm lub rooj:
… lossis siv cov qauv uas yuav xa mus rau ib lub xovtooj uas nyob ib sab thiab ntxiv ib qho chaw rau nws, thiab tom qab ntawd xaiv qhov kev xaiv uas xav tau los ntawm cov npe hauv qab ntawm cov lus qhia:
... lossis tsuas yog tsim lwm kab, sau nws nrog lub npe tsim nyog (pejxeem, Cov kab mob thiab lwm yam) los ntawm daim ntawv teev npe nrog cov lus qhia:
Yog tias koj sim tag nrho cov no ntawm ib kem tsis yog nrog cov nroog, tab sis nrog lub teb chaws, koj tuaj yeem pom ntau qhov chaw:
Ntawm no yog cov ntsuas kev lag luam (cov nyiaj tau los ntawm ib tus neeg, tus nqi poob haujlwm, se), thiab tib neeg (fertility, mortality), thiab thaj chaw (tsob hav zoov, CO2 emissions) thiab ntau ntxiv - yuav luag 50 yam hauv tag nrho.
Lub hauv paus ntawm tag nrho cov ntaub ntawv no yog Is Taws Nem, lub tshuab tshawb nrhiav Bing thiab Wikipedia, uas tsis dhau yam tsis muaj kab - qhov no tsis paub ntau yam rau Peb Lub Tebchaws lossis muab tawm hauv daim ntawv tsis zoo. Piv txwv li, ntawm cov kav nroog, tsuas yog Sobyanin thiab Poltavchenko muab tawm, thiab nws suav tias yog lub nroog loj tshaj plaws hauv Peb Lub Tebchaws ... koj yuav tsis twv seb qhov twg! (tsis yog Moscow).
Nyob rau tib lub sijhawm, rau Tebchaws Meskas (raws li kuv qhov kev soj ntsuam), lub kaw lus ua haujlwm ntau dua, uas tsis yog qhov xav tsis thoob. Tsis tas li ntawd rau Tebchaws Meskas, ntxiv rau cov npe ntawm cov chaw nyob, koj tuaj yeem siv ZIP code (ib yam zoo li peb tus lej xa ntawv), uas tsis paub meej txog qhov chaw nyob thiab txawm tias cheeb tsam.
Lim los ntawm implicit parameter
Raws li cov txiaj ntsig zoo, hloov cov hlwb mus rau hom ntaub ntawv tshiab ua rau nws muaj peev xwm lim cov kab ntawv tom qab ntawm implicit tsis los ntawm cov ntsiab lus. Yog li, piv txwv li, yog tias cov ntaub ntawv nyob rau hauv kem raug lees paub tias yog Geography, koj tuaj yeem lim cov npe ntawm lub nroog los ntawm lub tebchaws, txawm tias tsis muaj kab lus meej nrog lub npe ntawm lub tebchaws:
Muab tso rau hauv daim ntawv qhia
Yog tias koj siv hauv lub rooj lees paub cov npe ntawm thaj chaw tsis yog lub nroog, tab sis ntawm lub teb chaws, cheeb tsam, cheeb tsam, xeev lossis xeev, tom qab ntawd ua rau nws muaj peev xwm tsim tau ib daim duab qhia pom siv lub rooj siv hom kab kos tshiab. Daim duab tab Ntxig - Maps (Ntxig - Maps):
Piv txwv li, rau cov cheeb tsam, thaj chaw thiab cov koom pheej, qhov no zoo li zoo heev:
Tau kawg, nws tsis tas yuav pom cov ntaub ntawv tsuas yog los ntawm daim ntawv teev npe ntawm cov ntsiab lus. Hloov chaw ntawm cov pej xeem, koj tuaj yeem tso saib cov kev txwv thiab KPIs hauv txoj kev no - muag, tus naj npawb ntawm cov neeg siv khoom, thiab lwm yam.
Hom ntaub ntawv Tshuag
Qhov thib ob hom ntaub ntawv, Tshuag, ua hauj lwm raws nraim tib txoj kev, tab sis yog tailored rau paub cov Tshuag indices:
... thiab cov npe ntawm cov tuam txhab thiab lawv cov npe luv (tickers) ntawm kev sib pauv:
Thov nco ntsoov tias tus nqi lag luam (kev lag luam cap) tau muab rau qee qhov laj thawj hauv cov nyiaj sib txawv, zoo, qhov no tsis paub Gref thiab Miller, pom tseeb 🙂
Kuv xav ceeb toom koj tam sim ntawd tias kev siv tag nrho cov no rau kev lag luam yuav tsis ua haujlwm zoo, vim. cov ntaub ntawv tsuas yog hloov kho ib zaug ib hnub, uas, feem ntau, qeeb dhau rau kev lag luam. Txhawm rau hloov kho ntau zaus thiab cov ntaub ntawv tshiab, nws yog qhov zoo dua los siv macros lossis cov lus nug rau kev sib pauv hauv Is Taws Nem siv Power Query.
Lub neej yav tom ntej ntawm cov ntaub ntawv tshiab
Undoubtedly, qhov no tsuas yog qhov pib, thiab Microsoft feem ntau yuav nthuav dav cov txheej txheem ntawm cov ntaub ntawv tshiab no. Tej zaum, dhau sijhawm, koj thiab kuv yuav txawm muaj lub sijhawm los tsim peb tus kheej hom, ua kom zoo rau cov haujlwm tshwj xeeb. Xav txog ib hom, piv txwv li, rau kev nthuav tawm cov ntaub ntawv hais txog tus neeg ua haujlwm lossis cov neeg siv khoom, muaj nws cov ntaub ntawv tus kheej thiab txawm tias ib daim duab:
HR cov thawj coj xav li ntawd, koj xav li cas?
Los yog xav txog tej yam ntaub ntawv uas khaws cov ntsiab lus (qhov loj, qhov hnyav, xim, nqe) ntawm txhua yam khoom lossis kev pabcuam ntawm daim ntawv teev nqi. Los yog ib hom uas muaj tag nrho cov kev ua si txheeb cais ntawm ib pab pawg football. Los yog cov ntaub ntawv huab cua keeb kwm? Vim li cas ho tsis?
Kuv paub tseeb tias peb muaj ntau yam nthuav ua ntej 🙂
- Ntshuam bitcoin tus nqi los ntawm kev pauv online rau Excel siv Power Query
- Visualization ntawm geodata ntawm daim ntawv qhia hauv Excel
- Hloov cov nqi nrog CONVERT muaj nuj nqi