Indlela yokwenza uhlalutyo lwedatha kwi-Excel: Imiyalelo yokuSebenza

Inkqubo ye-Excel ayisiyo nje i-gabus yomhleli, kodwa nesixhobo esinamandla sokukhutshwa kwezibalo kunye neenkcukacha-manani. Isihlomelo sinenani elikhulu lemisebenzi eyenzelwe le misebenzi. Kuyinyani, ayizizo zonke ezi mpawu zisebenza ngokungagqibekanga. Kungenxa yokuba ezo zinto zifihliweyo zibandakanya iseti yezixhobo zohlalutyo lwedatha. Masifumanise ukuba ingavulwa njani.

Ukujika kwibhloko yesixhobo

Ukuthatha ithuba lezinto "zohlalutyo lwedatha", kufuneka isebenze kwiqela elithi "iphakheji yohlalutyo" ngokwenza isenzo esithile kwiisetingi ezithile zeMicrosoft Excel. I-algorithm yezi zenzo iphantse yalingana nenkqubo ye-2010, yowama-2013 nango-2013 nango-2013 nango-2013, kwaye ineemehluko ezincinci kwinguqulo encinci kwinguqulo ka-2007.

Ukusebenza

1. Yiya kwi "Ifayile" yethebhu. Ukuba usebenzisa uhlobo lweMicrosoft Excel 2007, emva koko endaweni yeqhosha lefayile, cofa i icon ye-Microsoft kwikona ephezulu yefestile.



2. Cofa kwenye yezinto eziboniswe kwicala lasekhohlo lefestile evulekileyo "parameter".



3. Kwifestile evuliweyo yeeparamitha ze-Excel, yiya "kwicandelwana" "



4. Kweli Candelo, siya kuba nomdla kwinxalenye esezantsi yefestile. Kukho iparameter "yolawulo". Ukuba kwifom eyehlayo enxulumene nayo, kufanelekile ukuba ixabiso le-"Excel Yongeza i-injini", ke kufuneka uyitshintshe kwi-Ofisi echaziweyo. Ukuba le nto ifakiwe, ndicofa nje kwi "Go ..." kwiqhosha layo.



5. Ifestile encinci ye-uperperstral ekhoyo. Phakathi kwazo, kufuneka ukhethe into "yephakheji yohlalutyo" kwaye ubeke uphawu malunga nalo. Emva koko, cofa kwiqhosha "Kulungile" elibekwe phezulu kwicala lasekunene lefestile.

Emva kokwenza le nto, umsebenzi ochaziweyo uya kusebenza, kwaye isixhobo sayo isixhobo sifumaneka kwi-ribbon ye-Excel.

Iqhuba imisebenzi yohlalutyo lwedatha

Ngoku sinokuqhuba nasiphi na isixhobo sohlalutyo lwedatha.

1. Yiya kwi-"data" ithebhu.



2. Kwithebhu yokuba i-ribbn ivulwe kumda osekunene weteyiphu. Cofa kwi "Uhlalutyo lweDatha", efumaneka kuyo.



3. Emva koko, iwindow isungulwe luluhlu olukhulu lwezixhobo ezahlukeneyo ezibonelela ngenqaku lohlalutyo lwedatha. Phakathi kwazo unokuqaqambisa ezi mpawu zilandelayo:
   • Ulungelelwaniso;
   • Igrafu ye-bar;
   • Ingcinezelo;
   • Isampulu;
   • I-Extoneial Comood;
   • Umvelisi wenombolo engaqhelekanga;
   • Izibalo ezichazayo;
   • Uhlalutyo olune;
   • Iindidi ezahlukeneyo zohlalutyo lokusasazwa, njl.

   Khetha into esifuna ukuyisebenzisa kwaye icinezele iqhosha "Kulungile".

Umsebenzi ngamnye kwi-algorithm yayo. Ukusetyenziswa kwezixhobo zeqela lohlalutyo lwedatha kuchazwe kwizifundo ezahlukeneyo.

Isifundo: Uhlalutyo lokunxibelelana nge-Excel

Isifundo: Uhlalutyo lokubuyisela kwi-Excel

Isifundo: Ungayenza njani i-chandogram kwi-Excel

Njengoko sibona, nangona iPlaysi yohlalutyo "ibhloko yebhloko ayisebenzi ngokungagqibekanga, inkqubo yokufakwa kwayo ilula. Kwangelo xesha, ngaphandle kokwazi i-algorithm ecacileyo yesenzo, umsebenzisi akunakulindeleka ukuba isebenze ngokukhawuleza oku kuluncedo kwemali matata.