Ungasivumela kanjani isengezo Sokuhlaziywa Kwedatha kusipredishithi se-Excel

I-Microsoft Excel sekuyisikhathi eside ingumkhiqizo wesofthiwe ofunwa kakhulu ngenxa yesethi ebanzi yamathuluzi okusebenza ahlukahlukene enza kube lula ukusebenza nohlelo futhi asheshise izinqubo ezahlukahlukene. Ukuba nezinga elanele lezingxenye ze-Excel, ungathuthukisa kakhulu izinqubo nemisebenzi eminingi. Esinye isici esinjalo esiwusizo Ukuhlaziywa Kwedatha.

Kubalulekile! Le phakheji ayifakiwe kumakhompyutha ngokuzenzakalela, ngakho-ke ukufakwa kufanele kwenziwe mathupha uma kunesidingo.

Lesi sihloko sizoxoxa ngendlela elula nephumelelayo yokwenza iphakheji yesofthiwe isebenze ngemiyalo yesinyathelo ngesinyathelo. Uzothola nemiyalelo elula yokuyilanda uma ingafakiwe kukhompyutha yakho.

Uyini lo msebenzi ku-Excel, futhi kungani udingeka

Lo msebenzi ufanelekile futhi uwusizo uma kunesidingo sokwenza ukubala okuyinkimbinkimbi noma ukuqinisekiswa kwedatha efakiwe, ngokuvamile kuthatha isikhathi esiningi noma akunakwenzeka ukwenza ngesandla nhlobo. Ezimweni ezinjalo, ithuba elikhethekile elivela ku-Excel "Ukuhlaziywa Kwedatha" lisiza. Ikuvumela ukuthi uhlole ngokushesha futhi kalula futhi ubhale inani elikhulu ledatha, wenze imisebenzi yakho ibe lula futhi ukonge isikhathi esiningi. Ngemva kokusebenzisa lo msebenzi, ishadi lizovezwa eshidini nemiphumela yesheke nokuhlukaniswa kube amabanga.

Kubalulekile ukucabangela! Uma kudingekile ukuhlaziya amashidi amaningana, kunconywa ukuthi ukhiphe umyalo weshidi ngalinye ngokwehlukana ukuze kube nombiko walo walo ngalinye.

Uma iphakheji edingekayo isivele ifakiwe kukhompyutha ukuze usebenzise lo msebenzi, khona-ke udinga ukuya kuthebhu ethi "Idatha", bese uye kuthebhu ethi "Ukuhlaziya" bese ukhetha inketho ethi "Ukuhlaziywa kwedatha". Uma uchofoza kulo, uhlelo luyaqala futhi ngokushesha lunikeze umphumela oyifunayo ngemva kokucubungula ngokuzenzakalelayo konke okokufaka. Uma lo msebenzi ungatholakali, udinga ukulanda "Iphakheji Lokuhlaziya". Lena iphakheji yedatha ye-Excel ethuthukisiwe ehlinzeka ngezici nokusebenza okwengeziwe ongasebenza ngakho.

Ungasivumela kanjani isengezo ku-Excel

Imiyalo yokunika amandla isengezo Sokuhlaziywa Kwedatha:

• Yiya kuthebhu "Ifayela".
• Khetha inketho ethi Izinketho.
• Khetha inketho ethi "Izengezo".
• Yiya kuthebhu ethi “Excel Add-ins”.
• Thikha ibhokisi eduze kwenketho ethi “Ikhithi yamathuluzi okuhlaziya”.
• Qinisekisa ukukhetha kwakho ngokuchofoza okuthi KULUNGILE.

Uma inketho oyifunayo ingatholakalanga, landela imiyalo engezansi:

• Iya kumenyu ethi “Izengezo ezitholakalayo”.
• Khetha inketho ethi "Phequlula".
• Uma umyalezo othi “Data Analysis ToolPak ayifakiwe” uvela, chofoza Yebo.
• Inqubo yokufaka iphakheji yedatha yesofthiwe isiqalile.
• Linda ukuthi ukufakwa kuqedwe futhi iphakheji izobe isilungele ukusetshenziswa.

Uyini umehluko phakathi kokusebenza kwephakheji ku-Excel 2010, 2013 kanye no-2007

Inqubo yokwenza kusebenze lesi sengezo icishe ifane kuzo zontathu izinguqulo, kunomehluko omncane ekuqaleni kwenqubo yokwethulwa kohlelo. Ezinguqulweni ezintsha, udinga ukuya kuthebhu ethi "Ifayela" ukuze usebenze, futhi kunguqulo 2007 ayikho ithebhu enjalo. Ukuze uvule iphakheji kule nguqulo, udinga ukuya kumenyu ye-Microsoft Office ekhoneni eliphezulu kwesokunxele, elikhonjiswa umbuthano onemibala emine. Inqubo eyengeziwe yokuvula nokufaka icishe ifane kuzo zombili izinguqulo ezintsha ze-Windows nezindala.

Amathuluzi okuhlaziya e-Excel

Ngemva kokufaka nokusebenzisa iphakheji "Yokuhlaziywa Kwedatha", imisebenzi elandelayo izotholakala ukuze uyisebenzise:

• amasampula;
• ukudala histograms;
• ukukhiqizwa kwezinombolo okungahleliwe;
• ikhono lokwenza izinga (iphesenti kanye ne-ordinal);
• zonke izinhlobo zokuhlaziya - ukuhlehla, ukuhlakazeka, ukuhlobana, ukuhlangana nokunye;
• sebenzisa i-Fourier transform;
• kanye neminye imisebenzi engokoqobo yokubala, ukuhlela amagrafu nokucubungula idatha ngezindlela eziningi.

Ngalo myalelo wesinyathelo ngesinyathelo, ungakwazi ukuxhuma ngokushesha iphakheji lokuhlaziya ku-Excel, kuzosiza ukwenza lula umsebenzi wokwenza umsebenzi wokuhlaziya oyinkimbinkimbi futhi ucubungule kalula ngisho nenani elikhulu ledatha nenani. Ukufaka nokusebenzisa iphakheji kulula futhi akuthathi isikhathi esiningi, ngisho nomsebenzisi we-novice angaphatha lo msebenzi.