I-Excel akuyona nje isihleli se-isipredishithi, kepha futhi iyithuluzi elinamandla lokubala okuhlukahlukene kwezibalo nezezibalo. Uhlelo lokusebenza linenombolo enkulu yemisebenzi eyenzelwe le misebenzi. Kuyiqiniso, akuzona zonke lezi zici ezenziwa ngokuzenzakalelayo. Lezi zici ezifihliwe yibhokisi lamathuluzi. "Ukuhlaziywa kwedatha". Ake sibheke ukuthi ungayinikeza kanjani amandla.
Vula ibhokisi lamathuluzi
Ukusizakala kwezici ezinikezwe umsebenzi "Ukuhlaziywa kwedatha", udinga ukwenza kusebenze iqembu lamathuluzi Iphakheji Yokuhlaziyangokulandela izinyathelo ezithile kuzilungiselelo zeMicrosoft Excel. I-algorithm yalezi zenzo icishe ifane nakwezinguqulo zohlelo lwango-2010, 2013 nango-2016, futhi inomehluko omncane kuphela ngenguqulo ka-2007.
Ukwenza kusebenze
- Iya kuthebhu Ifayela. Uma usebenzisa inguqulo ye-Microsoft Excel 2007, lapho-ke kunenkinobho Ifayela chofoza isithonjana Ihhovisi leMicrosoft ekhoneni eliphezulu kwesobunxele lewindi.
- Sichofoza kwenye yezinto ezivezwe engxenyeni engakwesokunxele yewindows evulayo - "Izinketho".
- Ewindows ongakhetha ku-Excel, iya esigatshaneni esingezansi "Okengezwayo" (okwenzeka ekugcineni kuhlu olungakwesokunxele kwesikrini).
- Kulesi sigatshana, sizoba nentshisekelo ezansi kwewindi. Kukhona ipharamitha "Abaphathi". Uma ifomu lokwehla lihlobene nalo kufanelekile inani elingahlukile Kengeza i-Excel, lapho-ke udinga ukuyiguqula kokucacisiwe. Uma le nto isethwe, mane uchofoze inkinobho "Hambani ..." ngakwesokunene sakhe.
- Kuvulwa iwindi elincane lezengezo ezifakiwe. Phakathi kwabo, udinga ukukhetha Iphakheji Yokuhlaziya bese umkhaza. Ngemuva kwalokho chofoza inkinobho "Kulungile"itholakala phezulu phezulu kohlangothi lwesokudla lwewindi.
Ngemuva kokwenza lezi zinyathelo, umsebenzi obekiwe uzosebenza, namathuluzi akhe atholakala kubambo lwe-Excel.
Iqala imisebenzi yeqembu lokuhlaziywa kwedatha
Manje sesikwazi ukusebenzisa noma yimaphi amathuluzi eqembu "Ukuhlaziywa kwedatha".
- Iya kuthebhu "Idatha".
- Kuthebhu evulayo, ibhulokhi yamathuluzi itholakala onqenqemeni olungakwesokudla lwe-ribbon "Ukuhlaziywa". Chofoza inkinobho "Ukuhlaziywa kwedatha"elibekwe kuwo.
- Ngemuva kwalokho, iwindows enohlu olukhulu lwamathuluzi ahlukahlukene anikezwa umsebenzi "Ukuhlaziywa kwedatha". Phakathi kwazo kukhona izici ezilandelayo:
- Ukuhlangana
- I-histogram;
- Ukucindezelwa
- Ukusampula;
- Ukubukeka bushelelezi;
- Umakhi wezinombolo ezingahleliwe;
- Izibalo ezichazayo
- Ukuhlaziywa kwe-Fourier;
- Izinhlobo ezahlukahlukene zokuhlaziywa kokwehluka, njll.
Khetha umsebenzi esifuna ukuwusebenzisa bese uchofoza inkinobho "Kulungile".
Umsebenzi emsebenzini ngamunye unesenzo sawo se-algorithm. Kusetshenziswa amathuluzi weqembu "Ukuhlaziywa kwedatha" kuchazwe ngezifundo ezihlukile.
Isifundo: Ukuhlaziywa kwe-Excel Correlation
Isifundo: Ukuhlaziywa kokulungiswa ku-Excel
Isifundo: Ungayenza kanjani i-histogram e-Excel
Njengoba ukwazi ukubona, yize ibhokisi lamathuluzi Iphakheji Yokuhlaziya futhi ayenziwanga ngokuzenzakalelayo, inqubo yokunika amandla ilula. Ngasikhathi sinye, ngaphandle kolwazi lwe-algorithm ecacile yezenzo, akunakwenzeka ukuthi umsebenzisi azokwazi ukwenza kusebenze ngokushesha lo msebenzi omuhle kakhulu wezibalo.
