- Kua pahemo kē tēnei kaupapa.
Akoranga Ripanga Pivot i roto i te Excel
Akohia me pēhea te matatau ki ngā Ripanga Pivot me te waihanga i ngā pūrongo ngaio i roto i te Excel
Ko ngā ripanga pivot tētahi o ngā taputapu tino kaha a Excel mō te waihanga pūrongo, te whakakotahi raraunga, me te huri i ngā raraunga hei mōhiohio.
o tēnei akoranga e waru hāora te roa, he ako i a koe ki te whakamahi i ngā ripanga pivot, mai i te taumata taketake mō te hunga kāore anō kia mōhio ki te taputapu, ā, kia matatau ake ai ki ōna mahi. Hei te mutunga o te akoranga, ka taea e koe te whakamahi i ngā ripanga pivot hei whakaoti rapanga o ia rā i roto i tō kamupene.
Hunga Whāinga
Ngā tohunga o ngā mara katoa e hiahia ana ki te tātari, ki te whakarāpopoto, me te whakaatu tere i ngā raraunga: ngā kaitātari, ngā kaiawhina, ngā kaiwhakahaere, ngā kaiwhakahaere, me ētahi atu kaiwhakamahi Excel.
Te whakarite me te hanganga raraunga
- Te whakarite i ngā raraunga hei waihanga i tētahi ripanga kauwhata
- Te whakamahi i ngā ripanga hei pūtake mō te waihanga i tētahi ripanga kauwhata
- Te mahi me ngā pātengi raraunga maha i roto i tētahi ripanga pivot mā te whakamahi i te Power Query me ngā whanaungatanga ripanga
Te Waihanga i tētahi Ripanga Pivot
- Ngā āpure, ngā horahanga, me ngā tūemi o tētahi ripanga kauwhata
- Te whakarōpū me te tātari i ngā raraunga i roto i tētahi ripanga kauwhata
- Te waihanga i ngā pūrongo mai i ngā tātari pūrongo
- Te Whakahōputu i ngā Uara Ripanga Kaurori
- Te Tirotiro Iho – Pāwhiri Rua
- Te mahi me ngā pūtau kau
- Te whakahou i te ripanga kauwhata me te whakarerekē i te pūtake raraunga
Ngā Tahora me te Whakaaturanga Raraunga
- Te hōputu me ngā momo kāhua o te ripanga kaurori
- Te whakarite i te tahora: Ngā Tapeke Iti, Ngā Tapeke Whānui, Te Tahora Pūrongo, me ngā rārangi kau
Tātaritanga mā te whakamahi i ngā Ripanga Pivot
- Te whakarōpū/te wetewete aunoa me te ā-ringa mā te rā, te tuhinga, me te tau
- Whakarāpopototia ngā uara mā te: Tapeke, tau, toharite, iti rawa, me te mōrahi
- Whakaatuhia ngā uara penei: % o te Tapeke Katoa, % o, rerekētanga o, % Rerekētanga o, Tapeke Whakaemi i roto, me te % Tapeke Whakaemi i roto
- Te Whakahōputu Āhuatanga i roto i ngā Ripanga Pivot
Te waihanga i ngā tūtohi hihiri
Te whakamahi i te Wehewehenga Raraunga (Ngā Tapatapahi) hei waihanga i ngā pūrongo hihiri, i ngā Papatohu rānei
Te Waihanga i ngā Pūrongo Ngaio
- Te Whakamahi i a InfodadosTabelaPinâmica: Te Mono i a ia, Te Waihanga i ngā Pūrongo Māmā me ngā Pūrongo Hihiri
- Te Waihanga i tētahi Āpure Tatau
- Te Waihanga i tētahi Tūemi Kua Tatauhia
- Aunoatanga Pūrongo
Haunga ngā tohutohu matatau me ngā whakamārama taipitopito mō ngā kōwhiringa ripanga kauwhata.
Kaiako
Paulo José Mendes
He miihini paerua nō USP (Te Whare Wānanga o São Paulo), he tohunga ki Whakaputa mai i te Vanzolini Foundation, ā, he tohu Paerua mō te Kounga mai i UPC Barcelona. He hoa whakatū o Barcino Solutions – Excel for Business i te tau 2010, kua whakaako kē i ngā akoranga Excel ki ngā kamupene o ngā rahi rerekē, pērā i: Johnson & Johnson, Boticário, Siemens, Ecorodovias, JBS, Polenghi, Coca-Cola, GE, me ētahi atu.
Ngā Mōhiotanga Hiranga
Te Rā: 22 me te 23 o Hune 2026
Ngā Hāora: 2 i te ahiahi ki te 6 i te ahiahi
Hōputu: Ipurangi
Taumahatanga mahi: 8 hāora
Kei roto i te utu te akoranga, ngā rauemi, me te tiwhikete hiko.
Hōputu: Tukunga Ipurangi – Ka whakapaohotia ora te akoranga, ā, ka taea e ngā ākonga te mātaki i runga i te rorohiko me te ipurangi. Ka taea e ngā ākonga te taunekeneke ki te kaiako, te tuku kōrero me te pātai i te wā o te akoranga.
Kua oti te whakangungu, ā, kei a koe tonu ētahi pātai?
Kia oti te whakangungu, e 30 ngā rā e wātea ana ki ngā ākonga hei whakautu i ā rātou pātai ki te kaiako mā te īmēra.
Ka taea hoki te whakahaere i tēnei whakangungu i roto i te kamupene, mā te kanohi ki te kanohi, mā te ipurangi rānei.
Mō ētahi atu kōrero e pā ana ki te Akoranga Ripanga Pivot Excel, whakapā mai mā te waea ki (11) 3230-2714, tirohia rānei te hononga: https://bit.ly/3IpqwSc
