- Lesi senzakalo sesidlulile kakade.
Inkambo Yethebula Le-Pivot ku-Excel
Funda ukuthi ungawazi kanjani amathebula e-Pivot futhi udale imibiko yobungcweti ku-Excel
Amathebula e-Pivot angenye yamathuluzi anamandla kakhulu e-Excel okudala imibiko, ukuhlanganisa idatha, nokuguqula idatha ibe ulwazi .
Le khosi yamahora angu-8 ihlose ukukufundisa ukuthi ungasebenza kanjani ngamathebula e-pivot, kusukela ezingeni eliyisisekelo kulabo abangakajwayelani nethuluzi, futhi bathuthukele ekuqondeni okuthuthukile kwemisebenzi yalo. Ekupheleni kwekhosi, uzokwazi ukusebenzisa amathebula e-pivot ukuxazulula izinkinga zakho zansuku zonke enkampanini yakho.
Izithameli Eziqondiwe
Ochwepheshe abavela kunoma yimuphi umkhakha abadinga ukuhlaziya, ukufingqa, nokwethula idatha ngokushesha: abahlaziyi, abasizi, abaxhumanisi, abaphathi, abalawuli, kanye nabanye abasebenzisi be-Excel.
Ukulungiswa kwedatha kanye nokuhlela
- Ukulungiselela idatha yokudala ithebula le-pivot
- Ukusebenzisa amathebula njengesisekelo sokudala ithebula le-pivot
- Ukusebenza ngama-database amaningi kuthebula le-pivot usebenzisa i-Power Query kanye nobudlelwano bethebula
Ukudala Ithebula Eliyi-Pivot
- Amasimu, izindawo, nezinto zethebula le-pivot
- Ukuhlunga nokuhlunga idatha kuthebula le-pivot
- Ukudala imibiko kusuka kuzihlungi zemibiko
- Ukufometha Amanani e-PivotTable
- Ukudonsa phansi – Chofoza kabili
- Ukusebenza ngamaseli angenalutho
- Ukubuyekeza ithebula le-pivot nokushintsha umthombo wedatha
Izakhiwo kanye Nokwethulwa Kwedatha
- Ukufometha kanye nezitayela ze-Pivottable
- Ukusetha ukwakheka: Izamba Ezingaphansi, Izamba Ezinkulu, Ukuhlelwa Kwemibiko, kanye nemigqa engenalutho
Ukuhlaziywa Kusetshenziswa Amathebula E-Pivot
- Ukuqoqa/ukuhlukanisa amaqembu ngokuzenzakalela nangokwamandla ngosuku, umbhalo, kanye nenombolo
- Fingqa amanani nge: Isamba, ukubala, isilinganiso, ubuncane, kanye nobuningi
- Bonisa amanani njengo: % we-Grand Total, % ka, umehluko we, % Umehluko we, Isamba Esihlanganisiwe ku, kanye ne-% Isamba Esihlanganisiwe ku
- Ukufometha Okunemibandela Kumathebula E-Pivot
Ukudala amashadi ashukumisayo
Ukusebenzisa Ukuhlukaniswa Kwedatha (Izisiki) ukudala imibiko eguquguqukayo, noma amaDashibhodi
Ukudala Imibiko Yochwepheshe
- Ukusebenzisa i-InfodadosTabelaPinâmica: Ukuyikhubaza, Ukudala Imibiko Elula kanye Nemibiko Eguquguqukayo
- Ukudala Insimu Ebaliwe
- Ukudala Into Ebaliwe
- Bika ukuzenzekela
Ngaphezu kwamathiphu athuthukile kanye nezincazelo ezinemininingwane zezinketho zethebula le-pivot.
Umfundisi
UPaulo José Mendes
Unjiniyela ophothule izifundo zakhe e-USP (eNyuvesi yaseSão Paulo), ogxile ku- Production evela eVanzolini Foundation futhi oneziqu ze-Master's in Quality ezivela e-UPC Barcelona. Ungumlingani wokuqala we-Barcino Solutions – Excel for Business ngo-2010, esevele efundise izifundo ze-Excel ezinkampanini ezinobukhulu obuhlukene, njenge: Johnson & Johnson, Boticário, Siemens, Ecorodovias, JBS, Polenghi, Coca-Cola, GE, phakathi kwabanye.
Ulwazi Olubalulekile
Usuku: 22 no-23 Juni 2026
Amahora: 2 PM kuya ku-6 PM
Ifomethi: Ku-inthanethi
Umthwalo womsebenzi: amahora angu-8
Intengo ifaka phakathi ikhosi, izinto zokwakha, kanye nesitifiketi se-elekthronikhi.
Uhlobo: Ukudluliselwa Kwe-inthanethi – Isifundo sizosakazwa bukhoma futhi abafundi bangayibuka kukhompyutha enokufinyelela kwe-inthanethi. Abafundi bazokwazi ukuxhumana nomfundisi, benze imibono futhi babuze imibuzo phakathi nesifundo.
Uqedile ukuqeqeshwa kodwa usenemibuzo ethile?
Ngemva kokuqeda ukuqeqeshwa, abafundi bazoba nezinsuku ezingu-30 zokuxazulula imibuzo yabo nomfundisi nge-imeyili.
Lokhu kuqeqeshwa kungaqhutshwa kanye kanye, kungaba mathupha noma ku-inthanethi.
Ukuze uthole ulwazi olwengeziwe mayelana ne-Excel Pivot Table Course, xhumana nathi ngocingo ku-(11) 3230-2714 noma ufinyelele kusixhumanisi: https://bit.ly/3IpqwSc
