01 ya 05
Kuyika Masamba Pivot ku Google Docs
Ma tebulo apamwamba amapatsa chida chothandizira kusanthula deta mkati mwa pulogalamu yanu yamakono. Amapereka luso lofotokoza mwachidule deta popanda kugwiritsa ntchito deta yolumikizana kapena ntchito zonse. M'malo mwake, amapereka mawonekedwe owonetsera omwe amalola ogwiritsa ntchito kupanga mapepala omwe amawoneka mwadongosolo m'databuloli powangokera ndi kutaya zigawo za deta kumalo oyenera kapena mizere. Kuti mudziwe zambiri pazogwiritsa ntchito matebulo ozungulira, werengani Mau Oyamba ku Masamba A Pivot. Mu phunziro ili, tikuyang'ana njira yopanga tebulo la pivot ku Google Docs. Mwinanso mutha kukhala ndi chidwi ndi phunziro lathu lothandizira pomanga matebulo a Pivot ku Microsoft Office Excel 2010 .
02 ya 05
Tsegulani Google Docs ndi Gwero Lanu la Chitsimikizo
Yambani mwa kutsegula Microsoft Excel 2010 ndikuyenda ku fayilo yoyamba yomwe mukufuna kugwiritsa ntchito patebulo lanu. Chitsimikizo ichi chiyenera kukhala ndi magawo okhudzana ndi kusanthula kwanu ndi deta yokwanira kuti mupereke chitsanzo cholimba. Mu phunziro ili, timagwiritsa ntchito mndandanda wa mayina olembetsera maphunziro a ophunzira. Ngati mukufuna kutsatira, mukhoza kupeza fayilo ndikugwiritsira ntchito pamene tikuyenda popanga phazi la pivot pang'onopang'ono.
03 a 05
Pangani Pepala Lanu la Pivot
Mukangotsegula fayilo, sankhani Pivot Table Report kuchokera ku Dongosolo la Deta. Mudzawona mawindo opanda kanthu a Pivot Table, monga momwe taonera pamwambapa. Zenera likuphatikizapo Report Editor pane kumbali yakumanja yomwe imakulolani kuti muyang'ane zomwe zili mu tebulo la pivot.
04 ya 05
Sankhani Mazenera ndi Mizere pa Pepala Lanu la Pivot
Mudzakali ndi tsamba latsopano lomwe liri ndi tebulo lopanda kanthu. Panthawiyi, muyenera kusankha mizere ndi mizere yomwe mukufuna kuikamo patebulo, malingana ndi vuto la bizinesi yomwe mukuyesera kuthetsa. Mu chitsanzo ichi, tidzakhazikitsa lipoti lomwe limasonyeza kulembetsa maphunziro omwe amaperekedwa ndi sukulu zaka zingapo zapitazi.
Kuti tichite izi, timagwiritsa ntchito Report Editor yomwe imapezeka kumanja kwawindo, monga momwe tawonetsera pamwambapa. Dinani Malo Owonjezera pa Mtsinje pafupi ndi ndime ndi mzere wazenera pawindo ili ndipo sankhani minda yomwe mungafune kuiika pa tebulo lanu lapivot.
Mukasintha malo a minda, mudzawona tebulo la pivot kusintha pa tsamba. Izi ndizothandiza kwambiri, chifukwa zimakulolani kuti muyambe kukonza mapepala pamene mumapanga. Ngati sizomwe mukuyesa kumanga, sungani minda yozungulira ndikuwonetseratu kusintha.
05 ya 05
Sankhani Mtengo Wofunika pa Pivot Table
Kenako, sankhani zinthu zomwe mukufuna kugwiritsa ntchito ngati cholinga chanu. Mu chitsanzo ichi, tidzasankha gawo la maphunziro. Kusankha mundawu muzotsatira za chigawo cha mndandanda mu tablete ya pivot yomwe ili pamwambapa - lipoti lathu lofunidwa!
Mungasankhenso kukonza tebulo lanu la pivot m'njira zosiyanasiyana. Choyamba, mukhoza kusintha momwe maselo a tebulo lanu amawerengera mwa kuwombera muvi pafupi ndi Kuphatikizidwa Ndi gawo la Malemba. Mutha kusankha zosankha zonse zotsatirazi mwachidule deta yanu:
- Chidule
- Chiwerengero
- Chiwerengero Chokha
- Avereji
- Max
- Mphindi
- Zamkatikati
- Mtundu
Kuwonjezera apo, mungagwiritse ntchito gawo la Report Filter gawo kuti muwonjezere zojambulira ku lipoti lanu. Zosakaniza zimakulolani kuti mulepheretse zinthu zomwe zikuphatikizidwa zomwe mukuphatikizidwa muzowerengera zanu. Mwachitsanzo, mungasankhe kuchotsa maphunziro onse omwe amaphunzitsidwa ndi aphunzitsi omwe achokapo. Mungachite izi mwa kupanga fyuluta pamunda wa Mlangizi, ndikusankhira wophunzirayo kuchokera mndandanda.