Excel ba kawai edita ba ne, amma kuma kayan aiki ne mai ƙarfi don lissafin lissafi da lissafi daban-daban. Aikace-aikacen yana da adadi mai yawa na ayyuka waɗanda aka tsara don waɗannan ayyuka. Gaskiya ne, ba duk waɗannan fasalullurorin ba sa aiki da tsohuwa. Waɗannan ɓoyayyen fasali sune akwatinan kayan aiki. "Nazarin Bayanai". Bari mu gano yadda zaku taimaka.
Kunna akwatin kayan aiki
Don amfani da kayan aikin da aikin ya bayar "Nazarin Bayanai", kuna buƙatar kunna ƙungiyar kayan aiki Kunshin Nazarinta bin wasu matakai cikin saiti na Microsoft Excel. Algorithm na waɗannan ayyuka kusan iri ɗaya ne ga ire-iren shirin na 2010, 2013 da 2016, kuma yana da ƙananan bambance-bambance a cikin sigar 2007.
Kunnawa
- Je zuwa shafin Fayiloli. Idan kana amfani da sigar Microsoft Excel 2007, to a maimakon maballin Fayiloli danna icon Ofishin Microsoft a saman kusurwar hagu na taga.
- Mun danna ɗayan abubuwan da aka gabatar a ɓangaren hagu na taga wanda ke buɗe - "Zaɓuɓɓuka".
- A cikin bude zaɓuɓɓukan Excel na zaɓi, je zuwa sashin "Karin abubuwa" (wanda zai yi rubutu daya ne a gefen hagu na allo).
- A cikin wannan sashin, za mu nuna sha'awar zuwa kasan taga. Akwai siga "Gudanarwa". Idan fom ɗin juzu'iyya da ke da alaƙa da ita ya fi ƙima daraja ban da Addara Add-ins, sannan kuna buƙatar canza shi zuwa ƙayyadadden. Idan an saita wannan abun, to kawai danna kan maballin "Ku tafi ..." a kan hakkinsa.
- Windowara karamin falon ƙara onara yana buɗewa. Daga cikin su, kuna buƙatar zaɓi Kunshin Nazarin kuma kashce shi. Bayan haka, danna maɓallin "Ok"wanda yake a saman ƙasan dama na taga.
Bayan aiwatar da waɗannan matakan, za a kunna aikin da aka ƙididdige, kuma kayan aikinta suna a kan kintinkiri na Excel.
Addamar da ayyukan ƙungiyar Binciken Bayanai
Yanzu zamu iya gudanar da kowane kayan aikin rukuni "Nazarin Bayanai".
- Je zuwa shafin "Bayanai".
- A cikin shafin da yake buɗewa, toshe kayan aikin yana kan gefen dama na haƙarƙarin "Bincike". Latsa maballin "Nazarin Bayanai"wanda aka sanya shi a ciki.
- Bayan wannan, taga tare da manyan jerin kayan aikin daban-daban waɗanda aikin ke bayarwa "Nazarin Bayanai". Daga cikinsu akwai abubuwa masu zuwa:
- Daidaitawa
- Histogram;
- Juyowa
- Samfurowa;
- Sanya mai amfani;
- Random mai samar da mai lamba;
- Statisticsididdigar mai ba da labari
- Binciken fourier;
- Daban-daban nau'ikan bincike na bambance-bambancen, da sauransu.
Zaɓi aikin da muke son amfani da shi kuma danna maɓallin "Ok".
Aiki cikin kowane aiki yana da tsarin aikin shi. Yin amfani da wasu kayan aikin rukuni "Nazarin Bayanai" aka bayyana a cikin darussan daban.
Darasi: Tsarin Nazari na Gaskiya
Darasi: Nazarin ci gaba a cikin Excel
Darasi: Yadda za a yi rubutun tarihi a cikin Excel
Kamar yadda kake gani, kodayake akwatinan kayan aiki Kunshin Nazarin kuma ba ta kunna ta hanyar tsoho ba, aiwatar da kunna shi abu ne mai sauki. A lokaci guda, ba tare da sanin ingantaccen tsarin aikin ba, ba shi yiwuwa mai amfani da sauri zai iya kunna wannan aikin mai amfani da ƙididdiga.
