Kanjani amandla idatha ukuhlaziywa Excel: Imiyalelo Ukusebenza

Uhlelo Excel akuyona nje umhleli yethebula, kodwa futhi ithuluzi elinamandla izibalo ahlukahlukene zezibalo kanye kwezibalo. Isithasiselo has lenqwaba imisebenzi senzelwe lemisebenti. Yiqiniso, akubona bonke lezi zici isebenze ngokuzenzakalelayo. Kuyinto ukuthi imisebenzi efana kufihlwe kuhlanganisa iqoqo ukuhlaziya idatha amathuluzi. Ake sithole ukuthi lingakusiza uvulwe.

Ukuvula block ithuluzi

Ukusizakala izici ukuthi "Idatha Ukuhlaziywa" sici, kudingeka kusebenze "Ukuhlaziywa Iphakheji" iqembu ithuluzi ngokwenza izenzo ezithile kuzilungiselelo-Microsoft Excel. I-algorithm lezi zinyathelo cishe ngoba izinguqulo uhlelo 2010, 2013 no 2016 okufanayo, futhi umehluko kuphela ingane 2007 version.

Kusebenze

1. Iya kuthebhu ethi "File". Uma usebenzisa inguqulo ye-Microsoft Excel 2007, khona-ke esikhundleni inkinobho Ifayela, uchofoza isithonjana-Microsoft Office ekhoneni elingenhla esinxeleni sewindi.



2. Chofoza yezinto okwethulwa ohlangothini esinxeleni sewindi owavula kuyinto "Amapharamitha".



3. Esikhathini Wavula ifasitela we-Excel imingcele, iya "Engeza-e" esigatshaneni (the penultimate ohlwini ohlangothini lwesobunxele kwesikrini).



4. Kulesi sigatshana, sizobe sibe nesithakazelo engxenyeni engezansi window. Kukhona "Management" ipharamitha. Uma ifomu okuya phansi eziphathelene ke, kuyafaneleka value ngaphandle "Excel add-injini", kuyobe sekudingeka ukwenze lokho ukulishintsha ecacisiwe eyodwa. Uma lento ifakiwe, mina vele uchofoze ku- "... Hamba" inkinobho ilungelo kuso.



5. Iwindi encane superstructure etholakalayo liyavuleka. Phakathi kwabo, udinga ukukhetha into "Iphakheji Ukuhlaziywa" wafaka umkhaza ngakho. Ngemva kwalokho, chofoza inkinobho "OK" sise kakhulu phezulu ohlangothini kwesokudla sewindi.

Ngemva kokwenza lezo zenzo, umsebenzi ecacisiwe izoqaliswa, futhi yamathuluzi yayo itholakala ku-Excel Ribbon.

Running Data Ukuhlaziywa Iqembu imisebenzi

Manje singagijima yimiphi ukuhlaziywa idatha ithimba amathuluzi.

1. Iya kuthebhu "yedatha".



2. Esikhathini ithebhu ukuthi iribhoni angavulwa ichopho lesokudla tape itholakala. Chofoza inkinobho ethi "Idatha Analysis ', okuyinto etholakala kulo.



3. Ngemva kwalokho, iwindi yethulwa nge uhlu enkulu amathuluzi ahlukahlukene enikeza idatha Ukuhlaziya sici. Phakathi kwabo ungagqamisa izici ezilandelayo:
   • ukuhlanganisa;
   • Igrafu yebha;
   • Regression;
   • yeSampuli;
   • bushelelezi Exponential;
   • Okungahleliwe inombolo generator;
   • izibalo okuchazayo;
   • Fourier ukuhlaziywa;
   • izinhlobo ezahlukene ukuhlakazwa ukuhlaziywa, njll

   Khetha isici esifuna ukusisebenzisa bese sicindezela inkinobho ethi "Kulungile".

Umsebenzi kumsebenzi ngamunye une-algorithm yayo. Ukusetshenziswa kwezinye izinsimbi zeqembu lokuhlaziya idatha kuchazwe kwizifundo ezihlukile.

Isifundo: Ukuhlaziywa kokuxhumeka ku-Excel

Isifundo: Ukuhlaziywa kabusha kokubuyiselwa ku-Excel

Isifundo: Ungayenza kanjani i-histogram ku-Excel

Njengoba sibona, yize ibhlokhi ye- "Ukuhlaziywa" Ithuluzi "alisebenzi nge-Default, inqubo yokufakwa kwayo ilula impela. Ngasikhathi sinye, ngaphandle kokwazi i-algorithm ecacile yokusebenza, umsebenzisi kungenzeka ukuthi asebenze ngokushesha lo msebenzi owusizo kakhulu wezibalo.