Contents
Microsoft Excel ya kasance samfurin software da aka daɗe ana nema saboda ɗimbin kayan aikin aiki daban-daban waɗanda ke sauƙaƙe aiki tare da shirin da kuma hanzarta matakai daban-daban. Samun isasshen matakin abubuwan abubuwan Excel, zaku iya haɓaka matakai da ayyuka da yawa sosai. Ɗayan irin wannan fasalin mai amfani shine Data Analysis.
Muhimmin! Ba a shigar da wannan kunshin akan kwamfutoci ta tsohuwa ba, don haka shigarwar dole ne a yi shi da hannu idan ya cancanta.
Wannan labarin zai tattauna hanya mai sauƙi kuma mai tasiri don kunna kunshin software tare da umarnin mataki-mataki. Hakanan zaka sami umarni masu sauƙi don zazzage shi idan ba a sanya shi a kwamfutarka ba.
Menene wannan aikin a cikin Excel, kuma me yasa ake buƙata
Wannan aikin yana dacewa kuma yana da amfani lokacin da ake buƙatar yin ƙididdiga mai rikitarwa ko tabbatar da bayanan da aka shigar, sau da yawa yana ɗaukar lokaci mai yawa ko kuma ba zai yiwu a yi shi da hannu ba kwata-kwata. A irin waɗannan lokuta, dama ta musamman daga Excel "Binciken Bayanai" ya zo don ceto. Yana ba ku damar dubawa da sauri da sauƙi da tsara bayanai masu yawa, sauƙaƙe ayyukan aikin ku da adana ku lokaci mai yawa. Bayan amfani da wannan aikin, za a nuna ginshiƙi akan takardar tare da sakamakon rajistan da rarraba zuwa jeri.
Yana da mahimmanci a yi la'akari! Idan ya zama dole don nazarin zanen gado da yawa, ana ba da shawarar bayar da umarni ga kowane takarda daban don samun rahoton kansa ga kowane ɗayansu.
Idan an riga an shigar da kunshin da ake buƙata akan kwamfutar don amfani da wannan aikin, to kuna buƙatar zuwa shafin "Data", sannan zuwa shafin "Analysis" kuma zaɓi zaɓin "Data analysis". Lokacin da ka danna shi, shirin yana farawa kuma nan da nan ya ba da sakamakon da ake so bayan sarrafa duk abubuwan da aka shigar ta atomatik. Idan wannan aikin bai samuwa ba, kuna buƙatar zazzage "Kunshin Nazari". Wannan babban fakitin bayanan Excel ne wanda ke ba da ƙarin fasali da ayyuka don aiki da su.
Yadda ake kunna add-in a cikin Excel
Umurnai don ba da damar ƙara bayanan Binciken Bayanai:
- Je zuwa shafin "File".
- Zaɓi zaɓin Zabuka.
- Zaɓi zaɓin "Ƙara-kan".
- Je zuwa shafin "Excel Add-ins".
- Duba akwatin da ke kusa da zaɓin "Kit ɗin Bincike".
- Tabbatar da zaɓinku ta danna Ok.
Idan ba a sami zaɓin da ake so ba, bi umarnin da ke ƙasa:
- Je zuwa menu "Akwai Add-ons".
- Zaɓi zaɓin "Browse".
- Idan ba a shigar da saƙon "Ba a shigar da Kayan Aikin Binciken Bayanai ba", danna Ee.
- An fara aiwatar da shigar da kunshin bayanan software.
- Jira shigarwa don kammala kuma kunshin zai kasance a shirye don amfani.
Menene bambanci tsakanin kunna kunshin a cikin Excel 2010, 2013 da 2007
Tsarin kunnawa na wannan add-on kusan iri ɗaya ne ga duka nau'ikan guda uku, tare da ɗan bambanci a farkon tsarin ƙaddamar da shirin. A cikin sababbin sigogin, kuna buƙatar zuwa shafin "Fayil" don kunnawa, kuma a cikin sigar 2007 babu irin wannan shafin. Domin kunna kunshin a cikin wannan sigar, kuna buƙatar zuwa menu na Microsoft Office a kusurwar hagu na sama, wanda ke nuna da'irar da launuka huɗu. Ƙarin kunnawa da tsarin shigarwa kusan iri ɗaya ne ga sababbin nau'ikan Windows da tsofaffi.
Kayan aikin bincike na Excel
Bayan shigarwa da gudanar da kunshin "Data Analysis", ayyuka masu zuwa za su kasance a gare ku don amfani:
- samfurori;
- ƙirƙirar histogram;
- tsara lambar bazuwar;
- ikon yin matsayi (kashi da ordinal);
- kowane nau'i na bincike - regression, watsawa, daidaitawa, covariance da sauransu;
- yi amfani da canjin Fourier;
- da sauran ayyuka masu amfani don ƙididdigewa, tsara zane-zane da sarrafa bayanai ta hanyoyi da yawa.
Tare da wannan umarnin mataki-mataki, zaku iya haɗa kunshin bincike da sauri a cikin Excel, zai taimaka don sauƙaƙe aikin aiwatar da ayyukan bincike mai rikitarwa da sauƙin aiwatarwa har ma da adadi mai yawa na bayanai da yawa. Shigarwa da kunna kunshin abu ne mai sauƙi kuma baya ɗaukar lokaci mai yawa, ko da novice mai amfani zai iya ɗaukar wannan aikin.