Excel Chidule tebulo: mmene kulenga ndi ntchito? Kugwira ntchito ndi kupambana PivotTables

Ambiri owerenga ofesi amakumana mavuto ambiri pamene kuyesera kulenga ndi kusintha zikalata Office. Nthawi zambiri izi chifukwa chakuti makampani ntchito mapulogalamu angapo ofesi mfundo zimene akhoza zimasiyana kwambiri. Makamaka m'mavuto angalenge kupambana PivotTables.

Mwamwayi, ndi posachedwapa anatuluka MS Office 2010-2013, zomwe kokha za chiwerengero cha pulogalamu kusinthidwa kwa owona processing malemba, spreadsheets, zinasokoneza makompyuta ndi zitsanzo komanso zimathandiza kuti ntchito nawo imodzi antchito angapo mu malo makampani ndi mwayi wamtengo wapatali.

N'chifukwa chake Baibulo latsopano?

Kuti timvetse funso limeneli, muyenera kuganizira zonse za kusintha kwambiri amene anachitika ndi Maapatimenti izi ofesi.

Monga kale, ndi kupambana ndi kufunika chachiwiri pulogalamu osati limakupatsani kulenga matebulo ophweka, koma ngakhale kulenga Nawonso achichepere mwachilungamo zovuta. Mofanana ndi zigawo zina, yawonjezedwa "Office" batani, kuwonekera pa zomwe mungathe kupulumutsa chikalatacho mu mtundu anakhumba, kusintha kapena mwachindunji miyeso wofunikila chitetezo chilichonse. Iwo anali kwambiri akweza chitetezo gawo kwa bukuli.

Koma kusintha kwambiri kuti kupambana, tisaiwale kukonza zolakwika angapo mu kachitidwe, chifukwa cha zimene Mabaibulo m'mbuyomu nthawi zambiri zolakwa zazikulu kwambiri kuwerengetsera lapansi.

Izo ziyenera ananena kuti Baibulo latsopano phukusi - imeneyi si ya mapulogalamu ofesi, komanso chida champhamvu, oyenera kuthetsa ngakhale zinthu zovuta kwambiri. Pamene inu mukhoza kumvetsa ife lero tikambirana kupambana chikatikati tebulo.

Kodi ndi chiyani icho?

Kusintha kwambiri mu Baibulo latsopano "Office" ndi mawonekedwe awo kwathunthu perekroenny, yomwe imatchedwa kuti ndiAmene wa Njanji (riboni). matepi malamulo onse 1500 ndi conveniently m'magulumagulu ndi siyana, kotero mulibe yaitali kuwapeza. Atsatila ndi magawo awa, kutukula awonjezera kupambana kuchita bwino PivotTable.

Today tikambirana kupambana «kwa dummies." matebulo Chidule - chida chapadera, imene zotsatira za ndondomeko ndi bwino m'magulumagulu. Mwachidule, iwo angagwiritsidwe ntchito kuona kuti anthu ambiri a anthu kapena zinthu zina anagulitsa zonse wogulitsa kwa kosangalatsa wake. Komanso, ntchito pa nthawi imene m'pofunika:

• Konzani kuwerengetsera mawunikidwe kulemba lipoti lomaliza.
• Kuwerengetsa zonse chizindikiro awo payokha.
• Ndisonyezeni grouping ndi mtundu deta.
• Zosefera ndi mozama kusanthula deta.

M'nkhaniyi tiona njira yosavuta anawalenga. Mudzaphunzila mmene kupambana chikatikati tebulo zimathandiza kuti ndi kutanthauzira nthawi zino, kulenga ndi kuwerenga zilizonse mwatsatanetsatane.

Pangani chikalata anakhumba

Choncho mmene kulenga chikatikati tebulo kupambana? Choyamba muyenera kulenga chikalata chosavuta chimene timapanga deta yoganizira ina. Mbali imodzi ayenera chifukwa cha chizindikiro chimodzi. Tengani chitsanzo losavuta:

• zogulitsa nthawi.
• Katundu anagulitsa.
• The mtengo okwana malonda.

Choncho, mwa magawo onse kwaiye mu pagawo lililonse makamaka link: amaganiza kuti nsapato taguliswa 9 am, phindu anapanga N-rubles.

matebulo masanjidwe

Atakonza mfundo zonse pachiyambi, kuika cholozera mu selo loyamba la ndime yoyamba, kutsegula tsamba "Ikani" kenako dinani batani "Chidule Table". Inu nthawi yomweyo onani bokosi kukambirana zimene mungachite ntchito zotsatirazi:

• Ngati inu nthawi yomweyo akanikizire "Chabwino" batani, ndiye kupambana PivotTables adzakhala yomweyo anasonyeza pa pepala osiyana.
• Kwathunthu ikonza excretion.

Zikatero, ndi kutukula zimatipatsa mwayi kudziwa osiyanasiyana maselo adzakhala anasonyeza mudziwe anafuna. Patatha izi, wosuta ayenera kudziwa kumene tebulo yatsopano polenga, kuti alipo kapena kumene analengedwa pa chipepalacho. Mwa kuwonekera "Chabwino," inu nthawi yomweyo kuona kutsogolo kwa tebulo wokonzeka. Pa chilengedwe cha matebulo chikatikati mu kupambana ndi pafupifupi anamaliza.

Kumanja ya pepala ili m'madera amene inu ntchito. Minda akhoza anakokera padafika m'madera osiyana, kenako deta ndi kuzionetsa mu tebulo. Motero, chikatikati tebulo kudzakudikira udzakhazikitsidwe pa kumanzere kwa workspace lapansi.

Kugwizana pamene kukanikiza mbewa batani kumanzere, "mankhwala", kutumiza kukhala "mutu bala", ndi kumadula "Uwerenge Sales" mofanana patsogolo njira mu "mtengo" (kumanzere kwa pepalalo). Umo ndi momwe mukhoza kupeza kuchuluka kwa malonda a kusanthula nthawi yonse.

Kupanga ndi grouping nthawi zino

Kudziwa malonda pa kutalika kwa nthaŵi yomwe, muyenera kumanga ndime zogwirizana mu tebulo yokha. Kuti muchite izi muyenera kupita mu pepala "Data" ndiyeno kumanga atatu ndime watsopano nthawi yomweyo pambuyo pa tsiku. Sankhani ndime ndi dzina la mankhwala, kenako dinani batani "Ikani".

Nkofunika, kuti onse mizati kumene analenga anali mkati tebulo alipo deta ndi gwero. Pankhaniyi, chilengedwe cha matebulo chikatikati mu kupambana kachiwiri kuchita. Inu amangokhala kuwonjezera minda yatsopano deta ankafuna.

ntchito chilinganizo

Mwachitsanzo, makoma kumene analenga angatchedwe "Chaka", "Mwezi", "Miyezi-zaka." Kuti deta timasamala ndi aliyense wa iwo adzayenera kulembetsa chilinganizo osiyana mawerengedwe a:

• The "lapachaka" amaika chilinganizo cha maonekedwe: "= YEAR" (kunena za tsiku).
• Mwezi ayenera wodzilemekeza ndi mawu akuti: "= MWEZI" (komanso za tsiku).
• Mu ndime yachitatu ya mawonekedwe ife kumanga mfundo ya "= CONCATENATE" (kunena za chaka ndi mwezi).

Chotero, ife tikupeza mizati atatu deta ndi zonse pachiyambi. Tsopano kupita ku menyu "Chidule" dinani pa malo aliwonse kanthu pa gome pa mbewa batani bwino, ndiyeno anatsegula menyu nkhani kusankha item "Pezani". Samalani! Mosamala kulemba mitunduyi mu kupambana PivotTables, monga kulakwitsa chilichonse kungachititse kuti zolakwa kulosera.

Kodi kuchita Khadili malonda deta?

Kachiwiri tikulimbikira kumanzere mbewa batani dinani "Chaka" ndipo Mkokereni mu "Dzina mzati", ndiyeno nkuyamba tebulo mwachidule amasonyeza zotsatira za mtundu wa malonda mankhwala kudutsa zaka zonse. Ndipo ngati inu mukufuna kuti tisanthule basi malonda pamwezi? Ifenso akanikizire LMB "Mwezi", kukokera izi pansi ndime pachaka.

Kuti tipeze mphamvu zithunzi kusintha pamwezi mu malonda pa zaka zambiri, "Mwezi" kuti angakokere mwachindunji mu ndime pachaka, poyamba anasunthira "Dzina mzati". Atamaliza stepi ino, mudzaona tebulo mu ulaliki zotsatirazi:

• Kuchuluka kwa malonda a mankhwala makamaka kwa chaka chonse.
• Mphamvu ya malonda ya aliyense wa iwo kwa zaka.

Chotsani deta ya issuance wa

Amaganiza kuti nkhani ya, tiyenera kuchotsa deta October, choncho tilibe ziwerengero mabuku pa izo. The mwachidule tebulo kuyang'ana "Report Woganiza" ndipo Mkokereni kwa "Chaka - Mwezi".

fyuluta limapezeka pamwamba pa tebulo mukufuna ponya bokosilo pafupi "Sankhani zinthu angapo." Pambuyo pake, mndandanda limapezeka, uncheck October, ndiyeno dinani "Chabwino".

Motero, mungathe kuwonjezera ndi kuchotsa zinthu sefa, n'kupanga yofunika kwambiri ndipo muyenera mayesero. pulogalamu basi linaŵerengera ziwerengero kwa miyezi imene mukufuna, bwino kusonyeza mphamvu ya kusintha zizindikiro.

Timayembekezera zolosera

Yesani kulosera za zotsatira za malonda kwa nthawi yaitali kubwera. Kuti tichite zimenezi, muyenera kuletsa zotsatira chisanadze nawo kuti sizinapange cholakwa mu Mapa kwaiye.

Kuti tichite zimenezi, anaika cholozera mu "Grand Total", ndiye dinani batani "Chotsani okwana chachikulu." Kenako, pomwe zodziwikiratu za kupambana PivotTables njira tafotokozazi ife (alemba pa mbewa batani bwino, kusankha "Pezani").

Chifukwa, deta izi anatayika ku mwachidule tebulo wathu. Kumanga chifaniziro zithunzi Zoneneratu pa malonda, kuika cholozera kwa chaka, zimene mukufuna kuti chiyambi, ndiyeno ife dinani chakumanja kumanzere batani pa batani "Ndandanda kulosera chitsanzo."

Pambuyo kuti pali kukongola ndi nkhani Zithunzi kuperekedwa mu mawonekedwe zithunzi kuyembekezera zotsatira za ntchito ogula pa kuneneratu chidwi. Izi adzapulumutsa mphamvu zanu ndalama zomwe zingagwiritsidwe ntchito pa kugula katundu zofunika.

Ife ntchito zina deta mapangidwe PivotTable ndi

Ndi bwino kuganizira mfundo zovuta kwambiri kupambana. Tebulo mwachidule akhoza analenga pamaziko a zikalata zomwe akhala lolembedwa ndi anthu enanso.

Itithandiza liziyenda "kuphatikiza". pulogalamu imeneyi zimathandiza inu kuti basi kuphatikiza mawu a m'chikalata ndi adiresi zofunika, dzina kapena zina zofunika kulenga Zoneneratu zogwirizana kuti mu nkhani iyi ndi chofunika.

kuphatikiza ntchito Mabaibulo pambuyo pa "ofesi" sanasinthe kwambiri poyerekeza Office 2003. Komabe mafunso Nawonso achichepere kusankha gwero deta angathe kuchitidwa ndi ntchito ya Microsoft akafufuzidwe. Kuti deta mwachidule kupambana spreadsheet, muyenera kukhala zinthu ziwiri:

• Nkhani yaikulu lili ndi mfundo zimene muyenela, komanso kumunda kusonyeza pulogalamu kupambana, deta kuti anaikapo mu mpukutuwu. Tebulo waukulu ndi muyezo chikalata, spreadsheet, koma muyenera mwachindunji mu kukambirana kuphatikiza (Mail kuphatikiza Mthandizi), zomwe ziyenera kugwiritsidwa ntchito monga chachikulu cha.
• Gwero deta muli zinthu zimene zili zofunika kwa yokonza Mapa lapansi. Mukhoza jambulani tebulo latsopano mu njira imene ife ndafotokozera pamwamba.

Pamene ndondomeko ya chilengedwe cha zikalata Mwachidule, pulogalamu amalenga buku aliyense wa zolembedwa zopezeka mu file deta gwero. owona awa akhoza kuwonetsedwa mu gawo osiyana chikalata latsopano, kapena ntchito ngati kugawa kwa chikatikati tebulo lanu.

Munthu akhoza kungowauzira alemba pa munda Napempha kwa anu batani kumanzere mbewa, ndipo mukhoza kuona gwero la deta m'malo mwa mayina mundawo kuoneka chikalata waukulu. Minda akhoza yomangiridwa kulikonse chikalatacho.

magulu ntchito

Komanso mungagwiritse ntchito AMADZIFUNSA gulu, kutanthauza "kufunafuna" ndi FILLIN tanthauzo 'adzaze "yotsatira ndi NEXTIF, WINA. Mukhozanso nyimbo magawo mfundo Mapa kuzionetsa mu tebulo komaliza. Pezani kulowa anakhumba n'zotheka pogwiritsa ntchito fyuluta wapadera kapena basi kuthetsa deta, monga tanena kale pamwambapa.

Mukakonzeka kulenga chikalata mbuye, kuphatikiza kukambirana bokosi amalola wosuta kuzindikira ndi kukonza zinthu zolakwika zisanachitike. Pamene chirichonse ndi kufufuzidwa, mukhoza bwinobwino akanikizire batani "kuphatikiza". Koma ngati pophatikizana ayenera ikuchitika kudzera e-mail, mudzakhala chinachititsa kukhazikitsa pulogalamu makalata (ngati simunakhala anaika kale).

Ngati kumene kulakwitsa chilichonse, ndi m'kati nkhani pophatikizana zokhudza munda molakwa chinanena chikalata china, kapena kugwiritsa ntchito deta ndi mu mtundu Yachilendo. Choncho, njirayi ayenera ndemangayi.

Ambiri, kupambana (ntchito ndi PivotTables zimene taona) amalola osati kusanthula ndi zovuta mphamvu kugula, komanso anawalenga pamaziko a amaneneratu.