Njengoko "Eksele" ukwenza uhlobo itheyibhile edityanisiweyo

iitafile Isishwankathelo ezi uboniso interactive ulwazi kuvumela abasebenzisi ukuba ukuhlalutya amaqela kunye izixa ezikhulu lwe data kwindawo emfutshane, ifomu tabular ngenxa ingxelo lula nohlalutyo. Enye inzuzo yalo msebenzi e-Excel kukuba ikuvumela ukuba ukuhlela, hide ukubonisa iindidi ezahlukeneyo yifayile eyodwa ukuba nembono enye lwe data. Kweli nqaku uyakwazi ukufunda imiyalelo malunga ukuba "Eksele" wenze njani itafile.

Inyathelo 1 ka-3: Ilungiselela ukusuka ekuqaleni

Qala Microsoft Excel.

Nqakraza kwi ayithem yemenyu "Data" uze ukhethe summary table (Qaphela: ekwi thengiso lwenguqulelo ye Excel 2007/2010, enze "Faka"> summary table).

Khankanya ukufumana idata ukuba uzimisele ukuba iimeko. Ukuba le nkcazelo kuluhlu Excel evulekileyo okwangoku, i-software ukhetha ngokuzenzekelayo uluhlu iiseli. Nqakraza "Landelayo".

Qinisekisa ukuba ukhetho "kuluhlu New" kukhethiwe emva ngokucofa i "Landelayo" ukusuka kwinyathelo elidlulileyo. Emva kokuba ukwenzile oko, nqakraza "Gqiba".

Inyathelo lesi-2 ka-3: Indlela ukudala itafile "Eksele"

Ukuba kuyimfuneko, ukunyenyisa uluhlu kwi bokisi yemiyalezo. Ezi mpawu ziye ibekwe phantsi kule ayithem yemenyu "Khetha itafile." Ukuba umthombo ulwazi etafileni yi yangaphandle, wadalwa kwinkqubo eyahlukileyo (umzekelo, Access), nqakraza i "Sebenzisa imithombo yedatha yangaphandle." Emva koko, ufumane umba menu "Khetha Uqhagamshelo" uze ucofe kwi kwibhokisi yencoko yababini osihloko sithi "Izixhobo ezikhoyo".

Yenza ukhetho lwendawo ukuyila yePivotTable. Ngokunga gqibekanga, Imo Excel kwenza njengento iphepha elitsha ukuba zongezwe ncwadi. Ukuthetha ukuba "Eksele" indlela yokwenza etafileni ukuze kwabonakala kuxwebhu owawulinikiwe, kufuneka nqakraza kwi ukhetho "esele List" iqhosha, uze ucacise indawo yeseli yokuqala kwi bokisi yemiyalezo "Indawo".

Nqakraza "Kulungile". Emva koko, yongeza igridi entsha mnyama i-PivotTable, uze emva koko kufuneka ukubonisa ipheyini yomsebenzi "Field uluhlu lwePivotTable." Le panel yahlulwe ezimbini.

Vula umba we menu 'Khetha amasimi ukongeza kwingxelo' uze ufakele zonke amagama ingentsimi lwemvelaphi data.

egcwalisa

Njengoko "Eksele" ukwenza itheyibhile? Ukuqhubeka ukuze enze imiyalelo, kufuneka ufumane ibhokisi kwikhusi, yahlulelwe kwii ariya umsebenzi ezine, ekufuneka icacise icebo lokucoca ulwelo, iilebhile umhlathi, imigca kunye nemilinganiselo.

Yabela intsimi kwi lo msebenzi "PivotTable List Field" kwiindawo zalo ezahlukahlukeneyo. Tsala igama entsimini umba we menu 'Khetha amasimi ukongeza kwingxelo' ngamnye kwimimandla ezine.

Yenza uhlengahlengiso xa kuyimfuneko ude ubone iziphumo zakho efanelekileyo.

Inyathelo 3 ka-3: Ukuqonda amagama okuqala, okanye indlela wenze itafile kwi "Eksele" lula

Okokuqala zama ukuqonda iinkcazelo eziphambili. Kukho amagama eziliqela ezinokubangela ukuba, ekuqaleni, kubonakala abangenagama.

Yintoni lokucoca ulwelo? Lo mmandla iqulethe amasimi ukuba bafune ulwazi ezicaciswe kule summary table, xa kucocwa ulwelo ngesandla kubo naluphi uphawu. Ukuba ngabamakishi kwiimviwo ingxelo. Umzekelo, ukuba icwangciselwe kwi "Unyaka" njenge lokucoca, ungakwazi ukubonisa data isishwankathelo kwitheyibhile ixesha elithile okanye yonke le minyaka.

imiqolo nomsayino - le ndawo intsimi wokuchaza indawo idatha kwiikholam summary table.

Utyikityo imikrozo - uthe mmandla uquka intsimi wokuchaza indawo idatha ifakiwe emgceni.

Fields ziqulathe amaxabiso ezichaza oko data zimelwe kwi kwiiseli ze yePivotTable. Ngamanye amazwi, oku ulwazi kushwankathelwe kwikholam yokugqibela (ihlanganiswe ngokungagqibekanga).

Field evela idatha engumthombo ukuba kokunika iphepha (okanye filter) iyavezwa kwi ingxelo yePivotTable.

Ukuqonda yeenqobo ngentla, kwakunye nezinye izicwangciso ziya kukuvumela ukuba siqonde ngcono ukuba "Eksele" wenze njani itafile. Khumbula ukuba iinguqulelo ezahlukileyo zale program, ezinye izinto menu zinokwahluka.