01 ka 05
Ukwethulwa kwamathebula we-Pivot ku-Google Amadokhumenti
Amatafula we-Pivot anikeze ithuluzi lokuhlaziya idatha elinamandla elifakwe ngaphakathi kwesofthiwe yakho yamapredishithi yamanje. Banikeza ikhono lokufingqa idatha ngaphandle kokusetshenziswa kwedatha yokuxhumana noma imisebenzi ehlanganisiwe. Esikhundleni salokho, banikeza isikhombimsebenzisi esibonakalayo esivumela abasebenzisi ukudala imibiko eyenziwe ngokwezifiso ngaphakathi kwespredishithi ngokumane behudula futhi belahle izakhi zedatha kumakholomu noma imigqa oyifunayo. Ukuze uthole imininingwane eminingi ekusetshenzisweni kwamatafula we-pivot, funda Isingeniso kumathebula wePivot. Kulesi sifundo, sihlola inqubo yokwakha itafula le-Google Docs. Ungase ube nesithakazelo ekufundiseni kwethu okuhlobene ekwakheni amathebula e-Pivot ku- Microsoft Office Excel 2010 .
02 ka 05
Vula idokhumenti ye-Google Amadokhumenti kanye Nomthombo Wakho
Qala ngokuvula iMicrosoft Excel 2010 futhi uhambe uye efonini yomthombo oyifisa ukuyisebenzisa etafuleni lakho le-pivot. Lo mthombo wedatha kufanele ube nezinkambu ezihlobene nokuhlaziywa kwakho kanye nedatha eyanele ukunikeza isibonelo esinamandla. Kulesi sifundo, sisebenzisa i-database yesibalo sokubhalisa inkambo yomfundi. Uma ungathanda ukulandela, ungafinyelela ifayela futhi ulisebenzise njengoba sihamba ngokudala isinyathelo setafula le-pivot ngesinyathelo.
03 ka 05
Dala ithebula lakho le-Pivot
Uma usuvule ifayela, khetha umbiko we-Pivot Table kusuka kwimenyu yedatha. Uzobona iwindi le-Pivot Table elingenalutho, njengoba kuboniswe ngenhla. Ifasitela iphinde ihlanganise i-Message Editor pane ehlangothini lwesokudla evumela ukuthi ulawule okuqukethwe kwetafula le-pivot.
04 ka 05
Khetha Amakholomu Nemizila Ye-Pivot Table Yakho
Manje uzoba nephepha lokusebenzela eliqukethe ithebula elingenalutho le-pivot. Kuleli phuzu, kufanele ukhethe amakholomu nemigqa ongathanda ukuyifaka etafuleni, kuye ngokuthi inkinga yebhizinisi ozama ukuyixazulula. Kulesi sibonelo, sizokwenza umbiko obonisa ukubhaliswa kwenkambo ngayinye ehlinzekwa yisikole eminyakeni embalwa edlule.
Ukwenza lokhu, sisebenzisa i-Report Editor ebonakala ngakwesokudla kwewindi, njengoba kuboniswe ngenhla. Chofoza isixhumanisi se-Add Field eduze kwezingxenye zekholomu nezigqawu kule festile bese ukhetha amasimu ongathanda ukuwafaka etafuleni lakho le-pivot.
Njengoba ushintsha indawo yamasimu, uzobona ushintsho lwetafula le-pivot ekhasini lokusebenzela. Lokhu kuyasiza kakhulu, njengoba ikuvumela ukuba ubuke kuqala ukufometha kwetafula njengoba uyiklama. Uma kungewona ngempela ukuthi uzama ukwakha, mane uhambise amasimu azungeze futhi ukubuka kuqala kuzoguquka.
05 ka 05
Khetha Inani Lokubhekiselwe kwethebula le-Pivot
Okulandelayo, khetha isici sedatha oyifisa ukuyisebenzisa njengelitshe lakho. Kulesi sibonelo, sizokhetha inkambo yenkambo. Ukukhetha le nsimu kusigaba sama-Values kuphumela kuthebula le-pivot eliboniswe ngenhla - umbiko wethu oyifunayo!
Ungakhetha futhi ukulungisa ithebula lakho le-pivot ngezindlela eziningi. Okokuqala, ungashintsha indlela amaseli etafula lakho abalwa ngayo ngokuchofoza umcibisholo eduze kokufingqa Ngxenye yesigaba sama-Values. Ungakhetha futhi noma yimiphi imisebenzi elandelayo ngokufingqa idatha yakho:
- Sum
- Bala
- Count Unique
- Isilinganiso
- Isikhulu
- Min
- I-Median
- Umkhiqizo
Ngaphezu kwalokho, ungasebenzisa isigaba sekhasi le-Report Filter ukuze ungeze izihlungi embikweni wakho. Izihlungi zikuvumela ukuba ukhawulele izakhi zedatha ezifakiwe ezibalweni zakho. Isibonelo, ungase ukhethe ukuhlunga zonke izifundo ezifundiswa ngumfundisi othile oshiye isikhungo. Uzokwenza lokhu ngokudala isihlungi kumkhakha we-Instructor, bese ukhetha lowo mfundisi ohlwini.