Babban shirin ba kawai edita ba ne, amma kuma kayan aiki mai ƙarfi don lissafin lissafi daban-daban da ƙididdiga. Rataye yana da yawan ayyuka da aka yi nufin waɗannan ayyukan. Gaskiya ne, ba duk waɗannan abubuwan ana kunna su ta hanyar tsohuwa ba. Wannan shine irin ayyukan da aka nuna ya haɗa da saitin kayan aikin nazarin bayanai. Bari mu gano yadda za'a iya kunna shi.
Juya akan toshe kayan aiki
Don amfani da fasalolin da "Binciken bayanai", kuna buƙatar kunna ƙungiyar "kunshin kayan aikin" ta hanyar aiwatar da wasu ayyukan Microsoft Excel. Algorithm daga cikin waɗannan ayyukan kusan iri ɗaya ne don sigogin 2010, 2013 da 2016, kuma yana da bambance-bambance kawai a cikin sigar 2007.Kunnawa
- Je zuwa shafin "fayil". Idan kana amfani da sigar Microsoft Excel 2007, to, maimakon maɓallin fayil ɗin, danna alamar Microsoft Office a saman kusurwar hagu na taga.
- Latsa ɗayan abubuwan da aka gabatar a gefen hagu na taga wanda ya buɗe shine "sigogi".
- A cikin taga mai fitarwa na prevel sigogi, je zuwa "add-a cikin jerin abubuwan da ke cikin jerin hagu na allo).
- A cikin wannan sashin, zamuyi sha'awar ƙananan ɓangaren taga. Akwai "gudanarwa" siga. Idan a cikin zaɓin juzu'i wanda ya danganta da shi, ya cancanci darajar banda "Excel actor Indine", to kuna buƙatar canza shi zuwa ƙayyadadden ɗaya. Idan an sanya wannan abun, kawai na danna kan "tafi ..." maɓallin zuwa dama.
- Karamin taga na wadatar Superstretreture yana buɗewa. Daga gare su, kuna buƙatar zaɓar abun "kunshin bincike" kuma saka alama game da shi. Bayan haka, danna maɓallin "Ok" wanda yake a saman gefen dama na taga.
Bayan aiwatar da waɗannan ayyukan, za a kunna aikin da aka ƙayyade, ana samun kayan aikin kayan aikinta akan kintinkiri Excel kintinkiri.
Gudanar da ayyukan binciken data
Yanzu zamu iya gudanar da kowane irin kayan aikin bincike na bayanai.
- Je zuwa shafin "bayanai".
- A cikin shafin cewa kintinkiri ya buɗe a gefen dama na tef yana da. Latsa maɓallin bincike na "na", wanda yake a ciki.
- Bayan haka, taga an ƙaddamar da babban jerin kayan aikin da ke ba da fasalin nazarin bayanai. Daga cikinsu za ku iya haskaka abubuwan da ke gaba:
- Hulɗa;
- Mashaya mai kai;
- Tashin hankali;
- Samfurin;
- Wadataccen suttura;
- Janareta lambar janareta;
- Lissafi;
- Bincike na hudu;
- Daban-daban nau'in bincike na watsawa, da sauransu.
Select fasalin da muke son amfani da kuma danna maɓallin "Ok".
Aiki a kowane aiki yana da nasa algorithm. Yin amfani da wasu kayan aikin na binciken bayanan bayanan da aka bayyana a cikin darussan daban.
Darasi: Binciken tabbatarwa na Excel
Darasi: Bincike na juyawa a Excel
Darasi: Yadda ake yin tarihi a Forevie
Kamar yadda muke gani, kodayake ba a kunna kunna kayan aikin "kayan aikin kayan aiki ba ta tsohuwa, aiwatar da ɗaukarsa abu ne mai sauki. A lokaci guda, ba tare da sanin wani bayyananniyar algorithm ba don aiwatarwa, mai amfani ba wanda ake iya shakkar aukuwarsa ya kunshi wannan aikin ƙididdiga mai amfani.