Pehea e hana ai i kahi papa pīpī ma Excel

ʻO Excel ka papahana kamepiula i hoʻohana nuiʻia. He mea pono no ka laweʻana i nā helu helu, kaʻikeʻikepili, kaʻikeʻana, e kahakaha ana i nā papa kuhikuhi, nā papa hana maʻalahi a me nā papa hana maʻalahi.

Inā pili ʻoe i nā ʻikepili, a laila pili paha ʻoe i nā ʻōwili. ʻO  Microsoft Excel   kahi polokalamu ākea ākea ākea a nui kahi manawa kūpono e hoʻohana ai ʻoe ia mea. Hiki iā ʻoe ke hana maikaʻi me ka Excel; ʻoi aku, hāʻawi i nā repositories e like me Excel template i nā hana manawaleʻa maikaʻi loa e hoʻomaikaʻi i kāu huahana. Hāʻawi ʻo Excel i nā pono hana he nui. ʻO kahi mea paahana e hiki iā ia ke kōkua iā ʻoe e hoʻoili i ka ʻikepili ʻo Pivot table. Pehea e hiki ai iā ʻoe ke hana i kahi papa pivot i Excel? E heluhelu no ka ʻike ʻana.

Nā papa pākuʻi: Kuhi pōkole.

E hoʻomaopopo mua e like me kahi papa pivot - kahi i kūkulu ʻia o Microsoft Excel. ʻO kahi papa ʻōpala he hōʻike i ka hōʻuluʻulu ʻana o kāu ikepili ma kahi pālahalaha Excel. Hāʻawi ia i nā loina maikaʻi e kōkua iā ʻoe e hoʻomaopopo i nā ʻano ma hope o kāu data. Pono paha ʻoe e hana i nā hōʻike e pili ana i kāu ʻikepili, a me ka papa pivot i maʻalahi i kēia.

Why is it called a “Pivot table”? This is because you can  huli a transpipe paha   this table using another attribute of your data. Let’s gain a deeper understanding of this.

Loaʻa iā ʻoe nā tausani o nā lālani ma kahi pālahalaha Excel me nā ʻano nui a mau kolamu paha. Hiki i ka papa ʻaina nui ke kōkua iā ʻoe e kiʻi i kahi ʻano e pili ana i kekahi o kēia mau ʻano, aʻo kahi papa pivot kekahi e hiki ke hāʻawi i kahi ʻano i kekahi ʻano.

No kēia, pono ʻoe e hoʻololi i ka papa, pivoting iā ia ma kahi o nā ʻano. ʻAʻole pono ʻoe e hoʻololi i ka ʻike i kekahi ʻano, ʻaʻole pono hoʻi e hoʻohui i kahi kolamu no kēia.

ʻO ka pōmaikaʻi o nā papa pivot.

No ke aha e aʻo ai e hana i nā papa pivot e kōkua iā ʻoe? E noʻonoʻo ʻoe he kau pākaha ʻoe me nā lālani he mau tausani. Kahi kēia pepa pālahalaha i ka ikepili kūʻai no nā huahana like ʻole a kākau iā ia i nā kaukani o nā kūʻai aku.

Mālama ia i nā ʻike like ʻole e like me ka loaʻa kālā a me ke kumukūʻai no kēlā me kēia kālepa. Makemake ʻoe e ʻike i ka huahana a kūʻai aku i nā mea ʻoi aku a me ka huahana e hāʻawi i ka pakeneka waiwai kiʻekiʻe loa.

Me ka ʻole o kahi mea hana e like me ka papa pīpī, pono ʻoe e hōʻuluʻulu i ka loaʻa kālā a me nā uku no kēlā me kēia huahana mai nā mau mano o nā kālepa. Ma hope, pono ʻoe e nānā i ka huahana i hāʻawi i ka loaʻa kālā nui loa.

Me ke kōkua o nā papa pivot, hiki ke hana maʻalahi i kēia. E hōʻemi kēia hiʻohiʻona i nā kikoʻī e like me ka loaʻa kālā a me ke kumukūʻai e ka huahana. Hiki iā ʻoe ke haʻi aku iā lākou e like me ka nui o ka loaʻa kālā a me ka uku holoʻokoʻa.

ʻO nā pōmaikaʻi o nā papa pivot penei:

• Hiki iā ʻoe ke hana maʻalahi iā lākou me nā helu liʻiliʻi.
• Hiki iā ʻoe ke hana maʻalahi i nā papa pākuʻi a koho i nā kolamu kūpono wale nō, e mālama ana i kāu hoʻoili ʻana.
• ʻO nā papa ʻaina Pivot e hōʻuluʻulu i ka ʻikepili i hōʻike ʻia ma nā kaukani o nā lālani a mālama i ka hoʻoikaika lima.

Hiki iā ʻoe ke hoʻomaopopo maʻalahi i nā hiʻohiʻona ma ka ʻike me ke kōkua o nā papa pivot.

• Kōkua nā papa pākuʻi iā ʻoe i ka maʻalahi e hana i nā hōʻike mai kāu ikepili.

ʻO kahi papa hoʻohālike e hana ai i ka papa ʻāina pivot.

E hana mākou i kahi papa pivot mai kahi pālahalaha e hoʻonā i kahi pilikia hypothetical. E lawe i kahi mau minuke e hoʻomaopopo i ka pilikia.

Ke hoʻohana nei kēia ʻatikala i kahi panana e hiki ke hoʻoiho ʻia mai nei. Hoʻohana ʻia ka mea hoʻohālikelike e koho i kahi kikowaena kūʻai kalepa a me ke kūʻai aku.

I loko o ka paukū Excel e hōʻike ʻia ana ʻo 'List List' ua loaʻa iā mākou nā kolamu penei:

• Nāhele B: ʻAe #.
• ʻ Clelo C: ʻAʻālua Code.
• Koloa D: ʻAno Helu.
• ʻ Elelo E: wehewehe.
• Kolike F: Ka mea nona.
• Kolamu G: Ka lā kūʻai mua kūʻai.
• Kākau H: Kūʻai kūʻai.
• Kūlana I: Kūʻai Kūʻai.
• Kākau J: Kūʻai kūʻai paʻa.
• ʻ Klelo K: Ka lā kūʻai.
• ʻ Llelo L: I kūʻai ʻia e.
• Kūlana M: kelepona kūʻai.

E manaʻo kākou e makemake ka mea kūʻai nāna i hoʻonohonoho i ke kūʻai kūʻai garage i ke nānā ʻana i nā mea i kūʻai ʻia. Makemake ka mea kūʻai aku e ʻike i ka huina o nā mea a pau a lākou e kūʻai ai a me ke kumukūʻai a lākou i loaʻa ai mai nā mea i kūʻai ʻia.

Hiki i nā ʻōlelo hana i hana e hana i kahi papa pivot ma Excel.

E hana i nā aʻe aʻe nei:

Ua hoomakau- 1. Hoʻomaka e hana i ka papa ʻāina

E kaomi i ke koho INSERT, a laila kaomi i ka Pivot Table.

2. E koho i ka nui o ka 'ikepili a me kahi o ka papa pivot hou.

Koho i ka awelika data e pili pū ana i nā kolamu mai ka ʻike i makemake ʻia i ka papa pivot. Pono ʻoe e hōʻoia ua loaʻa nā kolamu i ka kolamu poʻo.

E lilo i kahi excel pro: E hui pū me kā mākou papa!

E hoʻokiʻekiʻe i kāu mau akamai mai ka novice i ke koa me kā mākou hana maikaʻi loa 365 mau papa hana, hoʻolālāʻia e hana i nā mea'ē aʻe.

E kākau inoa ma aneʻi

Ma ka maʻamau, makemake pū ʻo Excel e hana ia i kahi papa pivot i kahi papa hana hou. Inā makemake ʻoe e hana i ka papa pivot i ka papa hana like, a laila hiki iā ʻoe ke koho i kēlā koho. I kēlā hihia, pono ʻoe e kuhikuhi i ka wahi.

3. E nānā i nā kīʻaha no ka papa pivot mai ka papa inoa.

E nānā i ka ʻaoʻao ʻaoʻao ʻākau ma kahi e hōʻike ai ʻo Excel i ka papa inoa o nā mahina. Hōʻike pū ia i nā wahi i hiki ai iā ʻoe ke huki a hoʻohemo i kahi mahina. Ua kapa ʻia nā ʻāina like:

• Nā kānga.
• Kālā.
• Nā Rū.
• Nā helu waiwai.

4. Kāomi a hoʻohemo i nā pā kūpono e hana ai i kāu papa pivot.

I kā mākou pilikia hypothetical, pono mākou e loaʻa i ka huina o ka helu a ka mea kūʻai aku a me ka nui a lākou i loaʻa ai mai ke kūʻai aku i kēia mau mea, ʻo ia hoʻi ka mea nona nā huahana i kūʻai ʻia. No ka mea e kāloʻume ana mākou i ka ʻikepili no nā mea āpau, ke koho nei mākou i ka kolamu Nūhou Nūmihī e like me ka lālani ma ka papa pivot. Pā mākou i ka māla Nūhou Nuhipepa i ka ROWS wahi.

He aha nā waiwai e nānā nei mākou i kēia ʻatikala? He nā lāʻau paʻa paha kēia, ke kumukūʻai kūʻai, a me ke kumu kūʻai kūʻai maoli. ʻO nā kolamu e pili ana i ka datasheet kumu nui Nānā Kūleʻa, Kūʻai Kūʻai a Kūʻai Kūʻai maoli, kēlā. ʻO kēia nā kolamu I, H a me J i ka ʻōpala nui.

ʻĀnō manaʻo e makemake ka mea kūʻai aku e kānana i kēia ʻikepili e helu i ka nui o kā lākou kālā i ka mea nona ka haku. Hiki iā lākou ke hana i kahi kānana no ka mea like me ka hoʻohui ʻana i ka māla Kuleana i ka ʻāpana kānana, e like me ka hōʻike ma lalo nei.

• Hiki iā mākou ke loaʻa i ke kumukūʻai o ka huahana i nā huaʻōlelo?
• Hiki iā mākou ke hoʻohui i kahi kīnā 'item' i nā lālani?

5. E loaʻa i nā pane i koi ʻia i nā huaʻina o ka pakeneka ma ka papa pivot.

Ma kahi o ka hāʻawi ʻana i nā kumukūʻai i nā helu, hiki iā mākou ke kuhikuhi i ka pakeneka ʻo lākou. Pono ʻoe i mea e hōʻike ai iā lākou he mau pakeneka o ka nui maoli. Kaomi i ka papa kuhikuhi i lalo i ka mākeke o Sum of Market Market ma ka VALUES ma ka wahi o ka pā hale hoʻonohonoho a me ka iho ʻana.

E koho i ka koho Nūlā Mālama Pūnaewele, ʻo ia ka koho hope loa ma ka papa inoa hāʻule. Hōʻike ʻo Excel i ʻelua mau ʻano koho i ʻaneʻi. Hiki iā ʻoe ke ʻike i ke ʻano mua o nā koho i loko o ka papa i kapa ʻia Mahele i nā waiwai e. Aia nā koho e like me Sum, Count, Average, etc. ʻAʻole mākou e hoʻohana i kēia mau koho no kā mākou pilikia kūikawā.

Hoʻohana mākou i ke ʻano o nā koho ʻē aʻe, i kākau ʻia i ka pā Show Values ​​As. Hōʻike ʻo Excel ʻAʻole Kahi ʻia ma ka maʻamau aʻe.

I kēia manawa, pono ʻoe e hoʻololi i ka ʻAʻole helu helu helu i ka % o Grand Total mai ka papa kuhikuhi i hāʻule. ʻO kēia no ka mea e makemake e loaʻa i ka nui o kēlā me kēia kumukūʻai e like me ke kaona o ka huina.

E kuhikuhi i ka helu 10 e ʻike i ka papa ʻāina pivot hopena. Maanei, hōʻike ka papa pivot i ka loaʻa kālā no kēlā me kēia ʻano o ka waihona ma ka ʻōlelo pākēneka. Ma kēia laʻana, ʻo ka 'Basketball me Kobe Signature' he kumukūʻai kiʻekiʻe loa.

ʻĀnō, ʻae ʻia, e nānā kāua i nā kumukūʻai ʻē aʻe o ka pakeneka, ma ke koho ʻana i '% o Grand Total' no ke kumukūʻai Sticker a me ke kumu kūʻai kumu kūʻai maoli.

6. Hoʻopili i kāu nānā ma ka kānana i nā lālani.

He aha kāu inā makemake e kāpae i kahi mea mai ka loiloi? Pono ʻoe e kānana i nā lālani ma ka papa pivot. Kaomi i ka papa kuhikuhi i lalo ma kahi o nā Row Labels.

Wehe i ka pahu hana kū'ē i ka mea āu e makemake ai e haʻalele mai ka nānā ʻana. Wehe mākou Guitar i kēia laʻana.

Ke haʻalele ʻoe i ka Guitar mai ka loiloi, ʻike iā ʻoe ua loli ka nui o ka pakeneka no nā kumukūʻai ʻē aʻe, ʻoiai ʻo kēia ka ʻokoʻa o ka huina.

7. Ka hoʻohui ʻana i kahi kahua 'Item Code' i nā lālani pilikino.

Ano, e nānā i ka pakeneka o ka huina kūʻai e kēlā me kēia code nene, e hoʻoneʻe a e hoʻokahe i ka mahina ‘Item Code’ i ka wahi “Rows” o ka hoʻokumu pākōkōlio a i ka drop-and-drop. E nānā i ka papaʻa pivot hopena. Hōʻike ka papa ʻaina i ka helu o kēlā me nā helu helu ʻokoʻa i ka nui o ke kumukūʻai i loaʻa i ka nui.

Hopena:

He ikaika ka Microsoft Excel. Eia kekahi, ʻo ka repositories e like me ke alo palapala ʻo Excel e hāʻawi i nā hana kōkua maikaʻi loa e kōkua iā ʻoe e hoʻokō wikiwiki. Ma luna o kēlā, ua kaha i nā mea i kūkulu ʻia e like me nā papa pivot no ka ʻike data. Ma kēia alakaʻi, ua hana mākou i ka papa pivot mai ka ʻike data Excel ma ka hoʻohana ʻana i kahi ala maʻalahi. E hoʻohana i kēia mea kaha ikaika ʻo Excel e hana i kāu ʻike!

Snezhina Piskova

ʻO Snezhina kahi mea e makemake ai e kūʻai aku me ka makemake o Excel. He haumāna a he Hoʻokele Hoʻokele ʻO Media a me ka ʻOihana Hoʻolālā, me kahi wīwī i ka hoʻolālā kiʻi a me ka hoʻokele hanana. Ma kāna manawa manawa he leʻaleʻa kona makemake ʻana e aʻo hou i nā ʻōlelo hou, huakaʻi a heluhelu hoʻi.