Excel ba kawai wani editan rubutu ba ne, amma har ma kayan aiki mai karfi don lissafin ilmin lissafi da lissafi. Aikace-aikacen yana da ƙididdiga masu yawa waɗanda aka tsara don waɗannan ɗawainiya. Gaskiya, ba duk waɗannan siffofin an kunna ta tsoho ba. Waɗannan halayen ɓoye sun haɗa da samfurin kayan aiki. "Tasirin Bayanan Bayanai". Bari mu gano yadda za a kunna shi.
Ƙare Block Tool
Don amfani da siffofin da aikin ke bayarwa "Tasirin Bayanan Bayanai", kana buƙatar kunna ƙungiyar kayan aiki "Shirye-shiryen Bincike"ta hanyar yin wasu ayyuka a cikin saitunan Microsoft Excel. Abubuwan alƙawari na waɗannan ayyukan sun kasance kamar su na iri-iri a cikin shekara ta 2010, 2013 da 2016, kuma yana da ƙananan bambance-bambance a cikin 2007.
Kunnawa
- Danna shafin "Fayil". Idan kana amfani da Microsoft Excel 2007, maimakon maɓallin "Fayil" danna icon Microsoft Office a saman kusurwar hagu na taga.
- Danna kan ɗaya daga cikin abubuwan da aka gabatar a gefen hagu na taga bude - "Zabuka".
- A cikin bude sassan sigogi na Excel, je zuwa sashe Ƙara-kan (wanda ya faru a cikin jerin a gefen hagu na allon).
- A cikin wannan ɓangaren, zamu yi sha'awar ɓangaren ƙananan taga. Akwai saiti "Gudanarwa". Idan a cikin nau'in da aka fadi game da shi, darajar ta bambanta Ƙara Add-insto, kana buƙatar canza shi zuwa kayyade. Idan an shigar da wannan abu, kawai danna kan maballin. "Ku tafi ..." zuwa ga dama.
- Ƙananan taga na ƙara-insikun ƙara yana buɗewa. Daga cikinsu, kana buƙatar zaɓar abu "Shirye-shiryen Bincike" da kuma ajiye shi. Bayan haka, danna maballin "Ok"located a sosai saman gefen dama na taga.
Bayan yin waɗannan ayyuka, za a kunna aikin da aka ƙayyade, kuma kayan aikinsa suna samuwa a kan rubutun na Excel.
Fara ayyukan ayyukan ƙungiyar Data Analysis
Yanzu za mu iya gudanar da wani kayan aiki a cikin rukuni. "Tasirin Bayanan Bayanai".
- Jeka shafin "Bayanan".
- A cikin bude shafin a kan gefen dama na tef ɗin shi ne toshe kayan aiki. "Analysis". Danna maballin "Tasirin Bayanan Bayanai"wanda aka sanya shi a ciki.
- Bayan haka, an kaddamar da taga tare da babban jerin kayan aiki daban-daban wanda aikin yayi "Tasirin Bayanan Bayanai". Daga cikin su akwai fasali masu zuwa:
- Daidaitawa;
- Tarihin tarihin;
- Tsaro;
- Samfur;
- Musanyawa mai mahimmanci;
- Random yawan janareta;
- Ƙididdiga masu fasali;
- Karin bayani na Fourier;
- Daban-daban na bincike na bambancin juna, da dai sauransu.
Zaɓi aikin da muke so mu yi amfani da kuma danna maballin. "Ok".
Ayyukan aiki a kowace aikin yana da nasa algorithm na ayyuka. Amfani da wasu kayan aiki "Tasirin Bayanan Bayanai" aka bayyana a cikin darussan darussa.
Darasi: Ƙarƙashin Magana a Excel
Darasi: Binciken lalata a Excel
Darasi: Yadda za a yi tarihi a Excel
Kamar yadda kake gani, ko da yake toshe kayan aiki "Shirye-shiryen Bincike" kuma ba'a kunna ta tsoho ba, tsarin aiwatar da juya shi yana da sauki. A lokaci guda, ba tare da sanin wani algorithm na ayyuka ba, yana da wuya cewa mai amfani zai iya yin aiki da sauri wannan aiki mai mahimmanci.
