Ua lilo ʻo Excel, ma kāna pono ponoʻī, i ka noi ʻoi loa e hana i nā papaha o kēlā me kēia ʻano, mai nā mea e ʻae iā mākou e hoʻokō i ka helu mahina i kēlā me kēia lā i nā pākaukau pili pūnaewele, me ka ʻae ʻana iā mākou e hōʻike i ka ʻikepili a lākou e hoʻokomo ai i nā pakuhi.
ka papa inoa iho a me nā papa hōʻeuʻeu a Excel e ʻae ai iā mākou e hana, ʻelua o nā hana i hiki iā mākou ke hana e loaʻa ka mea nui loa mai ia mea, ʻo ka hope kekahi o nā hana mana i hāʻawi ʻia e kēia noi ma loko o Office 365.
ʻO
He aha nā papa nui
Maliʻa paha ma mua o hoʻokahi manawa ua lohe ʻoe i nā papa nui, kekahi o nā ʻoi aku ka hana a me ka mana i hāʻawi ʻia e Excel iā mākou a ʻae iā mākou e hoʻokele wikiwiki a maʻalahi hoʻi i ka nui o ka ʻikepili.
Nā papa hōʻeuʻeu hiki iā mākou ke hana me Excel, ʻaʻole wale mākou e ʻae i ka ʻikepili mai nā papa, akā ʻae pū mākou iā mākou unuhi i ka ʻikepili mai nā ʻikepili i hana ʻia me Access, Ka noi a Microsoft no ka hoʻokumu ʻana i nā waihona.
Ok, akā he aha nā pākaukau pivot? Nā papa nui nā kānana i hiki iā mākou ke noi i nā hōkeo ʻikepili a ʻae pū kēlā iā mākou e hoʻokō i nā hōʻuluʻulu o nā hopena. Inā hoʻohana mau ʻoe i nā kānana i kāu mau papa helu, inā ʻoe e hoʻohana i nā papa nui, e ʻike ʻoe i ka hoʻemi ʻia o ka manawa e launa pū ai me lākou.
Pehea e hana ai i nā pākaukau pivot
E hana i nā papa nui. pono mākou i kahi ʻikepili, kumu ʻikepili i hiki ke lilo i pāhaukau a mākou e hoʻohana maʻamau ai e mālama i ka ʻikepili. Inā mākou e hoʻohana i kahi database i hana ʻia ma Access, hiki iā mākou ke hoʻonohonoho i ke kumuhana ʻikepili i ka papaʻaina kahi e waiho ai nā moʻolelo āpau.
Inā he waihona palapala ke kumu ʻikepiliMe nā ʻikepili i hoʻokaʻawale ʻia e nā pānaʻi, hiki iā mākou ke hana mai kēlā faile i kahi pākaukau kahi e lawe ai i ka ʻikepili e hana i nā papa nui. Inā ʻo kēia ʻano faila pālahalaha ke kumu wale nō o nā faile a mākou e hana ai i nā pākaukau hōʻeuʻeu, pono mākou e ʻike i ka hiki ke huki i ka ʻikepili i kahi ʻano ʻē aʻe a i ʻole hana i kahi macro e mālama pono i ka hana ʻana i nā papa hōʻeuʻeu i kēlā me kēia manawa. lawe mākou i ka ʻikepili.
ʻOiai paha e hōʻike ana kona inoa i ka paʻakikī, ʻaʻohe mea ʻē aʻe mai ka ʻoiaʻiʻo. Hana i nā papa pivot he hana maʻalahi loa ia, inā mākou e hāhai i nā anuu a pau a mākou e kuhikuhi ai ma lalo.
Hoʻohalike i ke kumu ʻikepili
I ka manawa e hana ʻia ka waihona, pono mākou e hoʻopili iā ia i Excel hiki ke hoʻomaopopo ʻo nā pūnaewele i loaʻa nā ʻikepili a ʻo nā huna i loaʻa nā inoa o nā moʻolelo e makemake mākou e kānana e hana i nā papa ikaika.
No ka hoʻonohonoho ʻana i ka pākaukau, ʻo ka mea mua a mākou e hana ai, ʻo ke koho ʻana i nā pūnaewele āpau i ʻāpana o ka pākaukau a kaomi ma ka pihi Hōʻike ma ke ʻano he pākaukau ma ka lipine Home.
E hōʻike ʻia nā ʻōkuene like ʻole ma lalo, nā hoʻolālā ʻaʻole e hoʻololi wale i nā mea hoʻohanohano o ka papa, akā e haʻi iā Excel he kumu ʻikepili hiki. I kēlā ʻāpana, ʻaʻohe mea e koho ai mākou e koho. I ka nīnau Aia ma hea ka ʻikepili ma ka papa? Pono mākou e hōʻoia i ka pahu i nā poʻo inoa i ka papa inoa.
Ma kēia ala, hōʻike mākou iā Excel i ka lālani mua o ka papa e hōʻike i ka inoa o ka ʻikepili i ka papa, i mea e hana ai i nā papa ikaika, ka mea e ʻae iā mākou e hoʻopili i nā kānana automated. I ka manawa e loaʻa iā mākou ka pākaukau me ka ʻikepili, a ua hoʻonohonoho pono iā ia, hiki iā mākou ke hana i nā papa ikaika.
Hana i nā papa pivot
- ʻO ka mea mua a mākou e hana ai koho pākaukau Aia i hea nā ʻikepili e lilo i ʻāpana o ka pākaukau hōʻeuʻeu, me nā keena e hōʻike mai iā mākou i ke ʻano o ka ʻikepili a lākou e hoʻokomo ai (i kā mākou kaona kulanakauhale, limahana, kuhikuhi, Kg).
- A laila, hele mākou i ka lipine a kaomi ma Kōkuhi.
- I loko o Insert, kaomi Pākaukau hōʻeuʻeu a me kahi pahu kamaʻilio i kapa ʻia Hana i ka pākaukau pivot.
- Ma loko o kēia pahu kamaʻilio ʻike mākou i ʻelua mau koho:
- Koho i ka ʻikepili āu e makemake ai e kālailai. E like me kā mākou i koho ai i ka pākaukau a mākou e makemake ai e hoʻohana e hana i ka papa ikaika, ua hōʻike ʻia i koho ʻia ma lalo o ka inoa ʻo Table1. Hiki iā mākou ke hoʻololi i kēia inoa inā manaʻo mākou e hoʻohui i nā papa i ka pā like.
- Koho i kahi āu e makemake ai e kau i ka pākaukau pivot. Inā makemake ʻole mākou e kāwili i ka ʻikepili kumu me ka pākaʻa pivot, pono e hana i kahi pākaukau hou, i hiki iā mākou ke kāhea i ka Pivot Table, i mea e huikau ʻole ai me ka pepa kahi e hōʻike ʻia ai ka ʻikepili, hiki iā mākou ke kāhea i ka ʻikepili. .
Inā ua hana mākou i nā ʻanuʻu āpau, e like ka hopena me ka mea i ke kiʻi ma luna. Inā ʻaʻole, pono ʻoe e hele ma nā ʻanuʻu āpau. I ka panela ma ka ʻākau (panela hiki iā mākou ke neʻe i loko o ka noi a waiho paha iā ia e lana ana) e hōʻike ʻia ka ʻike i koho ʻia e mākou e hoʻopili i nā kānana a mākou e pono ai.
ʻO nā palena i hiki iā mākou ke hoʻonohonoho i kēia:
Nā kānga
Maanei mākou e kau ai (ma ke kauō ʻana i nā kahua i luna) nā kahua a mākou e makemake ai e hōʻike e hōʻike ana i kahi nui a i kahi helu. I ka hihia o ka laʻana, ua hoʻonoho wau i ke kahua kaona kulanakauhale, limahana a me kahi kūmole e hiki ai ke koho i ka helu o nā kūmole. ua kūʻai lilo ʻia aku (Kaona, Limahana a me nā Kūmole) aiʻole e nā Kaona, nā limahana a i ʻole nā kūmole.
Ma loko o nā waiwai, ua hoʻokomo mākou i ka hōʻuluʻulu manaʻo o nā kūmole āpau ua kūʻai ʻia aku. I ke kumu o ka laʻana, 6 e hōʻike ana i ka helu o nā kūmole i kūʻai aku i nā limahana a pau o nā kūmole āpau i ke kaona ʻo Novelda.
ʻO nā Columns
I kēia ʻāpana, pono mākou e kau i nā kahua āpau a mākou e makemake ai Hōʻike ʻia i kahi mana kolamu kulu iho e koho a hōʻike i nā hopena āpau e pili ana i kēlā waiwai.
I ka hihia o kahi laʻana, ua hoʻonohonoho mākou i ka māla ʻo Munisipal i nā kolamu, i hōʻike ʻia ai iā mākou ka huina o ka helu o nā kūmole i kūʻai ʻia i nā kaona āpau. Inā mākou e hoʻohana i nā kānana, aia ma luna, hiki iā mākou ke kānana hou i nā hopena, e hoʻokumu ana i ke kūmole kikoʻī i kūʻai ʻia a ʻo ka mea hana i kūʻai aku iā lākou.
Nā lālani
ʻAe ka ʻaoʻao o nā lālani iā mākou e hoʻokumu i nā waiwai i loaʻa hōʻike ʻia e nā lālani a ʻo ka hana e like me nā kolamu akā ke hoʻololi nei i ke ʻano. E like me kā mākou e ʻike ai i ke kiʻi ma luna, ke waiho nei i ke kahua Munisipal i nā faila, hōʻike ʻia nā hopena ʻimi i nā lālani a ʻaʻole i nā kolamu.
Nā Kuleana
I kēia ʻāpana pono mākou e hoʻohui i nā kahua a mākou e makemake ai hōʻike huina. Ke kauō ʻana i ka māla Kg i ka ʻāpana Waiwai, hana ʻia kahi kolamu kahi e hōʻike ʻia ai ka nui o kg i kūʻai ʻia e nā kaona, ʻo ia ka kānana Row i hoʻohui ʻia e mākou.
Ma loko o kēia ʻāpana, loaʻa iā mākou kahi Pūnaewele Pūnaewele. Hoʻonohonoho ʻia e hōʻike a helu o nā kūlanakauhale a huahana paha. Ua hoʻonohonoho ʻia ka huina o ke kahua KG no laila hōʻike huina Kg. No ka hoʻololi ʻana i ka hana a mākou e makemake ai e hana ma ka home ma kekahi o nā kahua i hoʻokumu ʻia, pono mākou e kaomi ma ka (i) aia ma ka ʻaoʻao ʻākau o ke kahua.
Pane kūpono
Inā ua hana ʻoe i kēia mamao, e noʻonoʻo paha ʻoe pivot tables he honua paʻakikī loa pono ʻole e hoʻopā. ʻO ka ʻokoʻa, pehea ʻoe i ʻike ai i kēia ʻatikala, nā mea āpau i ka hoʻāʻo, ka hoʻāʻo ʻana a me ka hoʻāʻo ʻana a hiki i ka hiki iā mākou ke hōʻike i ka ʻikepili e like me kā mākou makemake e hōʻike ʻia.
Inā ʻoe e hoʻohui i kahi māla i kahi ʻāpana āu e makemake ʻole ai, pono ʻoe e huki iā ia mai ka pepa a hemo ia. Hoʻonohonoho ʻia nā pākaʻa nui no ka nui o ka ʻikepili, ʻaʻole no nā papa o 10 0 20 mau moʻolelo. No kēia mau hihia, hiki iā mākou ke hoʻohana pololei i nā kānana.
E lilo i mea mua e wehewehe