01 ngo 05
Ukuzisa iifayile zePivot kwi-Google Amadokhumenti
Iitafile zePivot zinika ithuluzi lokuhlaziya idatha elinamandla elifakwe kwisofthiwe yakho yangoku yespredishithi. Banikezela amandla okufingqa idatha ngaphandle kokusetyenziswa kwedatha yolwazi okanye imisebenzi ehlanganisiweyo. Kunoko, banikezela umzobo ocacileyo ovumela abasebenzisi ukudala iingxelo ezenziwe ngokwezifiso kwi-spreadsheet ngokutshiza kunye nokulahla izinto zeenkcukacha kwiikholomu okanye kwimigqa efunwayo. Ukufumana iinkcukacha ezongezelelweyo malunga nokusetyenziswa kwamatafula e-pivot, funda Isingeniso kwiiTable Tivables. Kule tutorial, sihlola inkqubo yokwakha itafile ye-pivot kwi-Google Amadokhumenti. Unokuba nomdla kwi-tutorial yethu ehambelanayo kwiZakhiwo zePivot kwi- Microsoft Office Excel 2010 .
02 we 05
Vula i-Google Amadokhumenti kunye nomqulu wakho womthombo
Qala ngokuvula iMicrosoft Excel 2010 kwaye uhamba ngefayili yomthombo onqwenela ukuyisebenzisa kwitafile yakho yepivot. Lo mthombo wedatha kufuneka ube neenkalo ezihlobene nokuhlalutya kwakho kunye nolwazi olwaneleyo ukubonelela ngomzekelo oqinileyo. Kule tutorial, sisebenzisa isampula yolwazi lokubhalisa kwiklasi yesampula. Ukuba ungathanda ukulandelelana, unokufikelela kwifayile kwaye uyisebenzise njengoko sihamba ngokudala isiteyibhile sepivot kwisinyathelo.
03 we 05
Yakha Itafile Yakho Yesiqalo
Emva kokuba uvule ifayile, khetha iPivot Table Report kwiMenu yedatha. Emva koko uza kubona iwindi yePivot Table window, njengoko kuboniswe ngentla. Ifestile iquka idibanti ye-Report Editor ngakwesokunene evumela ukuba ulawule okuqukethwe kwetafile ye-pivot.
04 we 05
Khetha iikholam kunye neendlela zeTable Table yakho
Ngoku uya kuba nephepha elitsha lokusebenzela eliqukethe itafile yepivot engenanto. Kulo nqaku, kufuneka ukhethe iikholomu kunye nemigqa ongathanda ukuyifaka kwitafile, kuxhomekeke kwingxaki yezolimo ozama ukuyixazulula. Kulo mzekelo, siza kudala ingxelo ebonisa ukubhaliswa kwikhosi nganye eyenziwa sisikolo kwiminyaka embalwa edlulileyo.
Ukwenza oku, sisebenzisa i-Report Editor ebonakala kwicala lasekunene lewindow, njengoko kuboniswe ngentla. Nqakraza isiHlomelo seNgcaciso ecaleni kwinqanaba kunye neefowuni kunye neefowuni uze ukhethe amasimi ongathanda ukuwafaka kwitafile yakho yepivot.
Njengoko utshintshe indawo yamasimi, uya kubona i-table yempembelelo yokutshintsha kwiphepha lokusebenzela. Oku kuncedo kakhulu, njengoko kukuvumela ukuba ukhangele ukufomathiza kwetafile njengoko uyiyilwe. Ukuba akuyiyo kanye into ozama ukuyakha, vele uhambise amasimi azungeze kwaye i-preview iya kutshintsha.
05 we 05
Khetha Ixabiso lokuThagetha kwiTable Table
Emva koko, khetha inkcazelo yedatha enqwenela ukuyisebenzisa njengejolise kuyo. Kulo mzekelo, siza kukhetha indawo yekhosi. Ukukhetha le ntsimi kwiCandelo leMilinganiselo kuphumela kwitafile ye-pivot eboniswe ngasentla - ingxelo esiyifunayo!
Unokukhetha kwakhona ukucwangcisa itafile yakho yepivot ngeendlela ezininzi. Okokuqala, unako ukuguqula indlela iiseli zetafile yakho zibalwa ngokuchofoza isicatshulwa esilandelayo ukuSigqitha ngengxenye yeCandelo lamaxabiso. Unokhetha ukhethe nayiphi na le mi sebenzi elandelayo ngokufingqa idatha yakho:
- Sum
- Bala
- Count Unique
- Umyinge
- UMax
- Min
- Median
- Mveliso
Ukongeza, ungasebenzisa icandelo lefayile yeNgxelo yefayile ukufaka izihlomelo kwingxelo yakho. Izihlungi zivumela ukuba ukhawuleze iinkcukacha zedata ezifakiwe kwiibalo zakho. Umzekelo, unokukhetha ukucoca zonke izifundo ezifundiswa ngumfundisi othile oshiye isiko. Uza kwenza oku ngokuklama icebo kwi-Field instructor, uze ukhethe loo myalelo kwiluhlu.