I-Excel akuyona nje umhleli wespredishithi, kodwa futhi ithuluzi elinamandla ngezibalo ezihlukahlukene zezibalo nezibalo. Isicelo sinomsebenzi omkhulu wemisebenzi eyenzelwe le misebenzi. Kuyiqiniso, akuzona zonke lezi zici ezenziwe ngokuzenzakalelayo. Lezi zici ezifihliwe zihlanganisa isethi yamathuluzi. "Ukuhlaziywa kwedatha". Ake sithole ukuthi singayivula kanjani.
Vumela Ithuluzi Vimba
Ukusebenzisa ngokunenzuzo izici ezinikezwa umsebenzi "Ukuhlaziywa kwedatha", udinga ukucupha iqembu lamathuluzi "I-Package Analysis"ngokwenza izenzo ezithile ezilungiselelweni ze-Microsoft Excel. I-algorithm yalezi zenzo isifana nezinhlelo zohlelo ngo-2010, 2013 no-2016, futhi inezingxabano ezincane kuphela ku-2007 version.
Ukuqalisa
- Chofoza ithebhu "Ifayela". Uma usebenzisa inguqulo ye-Microsoft Excel 2007, esikhundleni se-inkinobho "Ifayela" chofoza isithonjana I-Microsoft Office ekhoneni eliphezulu elingakwesokunxele lewindi.
- Chofoza kwenye yezinto ezinikezwe ngakwesokunxele kwefasitela evuliwe - "Izinketho".
- Ewindini le-Excel yemingcele evulwe, iya esigatshaneni Engeza-ons (phuma ohlwini olwesokunxele kwesikrini).
- Kulesi sigaba, sizobe nesithakazelo engxenyeni engezansi yewindi. Kukhona ipharamitha "Ukuphathwa". Uma ifomu lokudonsa eliphathelene nalo, inani lihlukile Faka i-Excelkhona-ke udinga ukuguqula kulokho okushiwo. Uma le nto ifakwe, mane uchofoze inkinobho. "Hamba ..." kwesokudla sakhe.
- Iwindi elincane le-add-ins elitholakalayo livula. Phakathi kwabo, kudingeka ukhethe into "I-Package Analysis" bese uyikhipha. Emva kwalokho, cindezela inkinobho "Kulungile"etholakala phezulu kakhulu kwesokudla kwes window.
Ngemva kokwenza lezi zenzo, umsebenzi ocacisiwe uzosebenza, futhi amathuluzi ayo atholakala ku-Ribbon Excel.
Ukuqala imisebenzi yeqembu le-Data Analysis group
Manje singakwazi ukugijima noma iyiphi yamathuluzi eqenjini. "Ukuhlaziywa kwedatha".
- Iya kuthebhu "Idatha".
- Emathebhu avulwe ngakwesokunene kwe-tape kuyisithi yamathuluzi. "Ukuhlaziywa". Chofoza inkinobho "Ukuhlaziywa kwedatha"okuthunyelwe kuyo.
- Ngemuva kwalokho, iwindi iqaliswa ngohlu olukhulu lwamathuluzi ahlukahlukene umsebenzi owanikezayo "Ukuhlaziywa kwedatha". Phakathi kwazo yizici ezilandelayo:
- Ukuhlanganisa;
- I-Histogram;
- Ukulawulwa;
- Isampula;
- Ukunciphisa okuphambene;
- I-generator yenombolo engahleliwe;
- Izibalo ezichazayo;
- Ukuhlaziywa kweFourier;
- Izinhlobo ezahlukene zokuhlaziywa kokuhlukahluka, njll.
Khetha umsebenzi esifuna ukuyisebenzisa bese uchofoza inkinobho. "Kulungile".
Yenza umsebenzi ngamunye ine-algorithm yayo yezenzo. Ukusebenzisa amathuluzi weqembu elithile "Ukuhlaziywa kwedatha" kuchazwe ngezifundo ezihlukene.
Isifundo: Ukuhlaziywa kwe-Correlation ku-Excel
Isifundo: Ukuhlaziywa komthetho ku-Excel
Isifundo: Indlela yokwenza i-histogram ku-Excel
Njengoba ungabona, nakuba ibhokisi lamathuluzi "I-Package Analysis" futhi ingasetshenzisiwe ngokuzenzakalelayo, inqubo yokuyivula ilula kakhulu. Ngesikhathi esifanayo, ngaphandle kolwazi lwe-algorithm ecacile yezenzo, akunakwenzeka ukuthi umsebenzisi uzokwazi ukusheshe asebenze lo msebenzi obalulekile kakhulu wezibalo.
