5 hanyoyi masu kisa don amfani da Microsoft Excel
Excel shi ne tsarin kayan shafukan lantarki.
Fayil na lantarki shine tsarin kwamfuta na kwamfuta wanda aka yi amfani dashi don adanawa, shiryawa da sarrafa bayanai .
Abin da ake amfani da Excel don
Shirye-shirye na kwasfan lantarki na asali ne bisa asali akan takardun bayanan takarda da aka yi amfani da su don lissafin kuɗi. Saboda haka, shimfidar launi na ƙididdigar da aka ƙera kwamfyuta daidai yake da takarda. Ana adana bayanan da aka haɗa a cikin tebur - waxanda suke da tarin karamin gilashi na tsakiya ko sassan da aka tsara a cikin layuka da ginshiƙai.
Hanyoyin Excel da sauran shirye-shirye na ɗakunan rubutu na iya ajiye ɗakunan shafuka masu yawa a cikin fayil ɗaya kwamfuta.
An ƙayyade fayiloli mai sarrafa fayil azaman littafin littafi kuma kowanne shafi a cikin ɗawainiyar takardun aiki ne daban.
Excel Sauran
Sauran shirye-shiryen shafukan layi na yanzu suna amfani da su:
Google Sheets (ko Shafukan Lissafin Google) - kyautaccen tsarin yanar gizon yanar gizo;
Intanit na Excel - kyauta mai sauƙi, ƙaddamarwa, tushen yanar gizo na Excel;
Open Calculator - kyauta mai saukewa, shirin sauƙaƙe.
Siffofin Fassara da Fassara
Idan ka dubi allo na Excel - ko duk wani allon layin rubutu - ka ga tebur na gwaninta ko grid na layuka da ginshiƙai , kamar yadda aka nuna a hoton da ke sama.
A cikin sababbin sashe na Excel, kowanne takarda yana dauke da kimanin layuka miliyan daya kuma fiye da ginshiƙan 16,000, wanda ya buƙaci tsari na magancewa domin ya lura da inda aka samo asusun.
Lissafin da aka kwance suna gano su ta lambobi (1, 2, 3) da ginshiƙan tsaye ta haruffa na haruffa (A, B, C). Ga ginshiƙuka fiye da 26, ginshiƙai an gano ta biyu ko fiye haruffa kamar AA, AB, AC ko AAA, AAB, da dai sauransu.
Hanya tsakanin tsakanin shafi da jere, kamar yadda aka ambata, shi ne karamin akwati na rectangular da aka sani da tantanin halitta.
Tantanin shine asalin ma'aunin don adana bayanai a cikin takardun aiki, kuma saboda kowane ɗigon rubutu yana dauke da miliyoyin wadannan sel, kowannensu an gano ta hanyar tantancewar salula.
Siffar salula shine hade da harafin shafi da lambar jere kamar A3, B6, da AA345. A waɗannan nassoshin cell, harafin shafi na farko an rubuta su a farko.
Bayanin Bayanai, Formulas, da Ayyuka
Nau'in bayanai da tantanin halitta zasu iya riƙe sun hada da:
- Lambobi;
- Rubutu;
- Dates da lokuta;
- Boolean dabi'u ;
- Formulas .
Ana amfani da takaddamfan lissafi domin ƙididdiga - yawanci yana hada bayanai da ke cikin wasu kwayoyin. Wadannan ƙwayoyin, duk da haka, ana iya samuwa a ɗayan ɗayan rubutu daban-daban ko a cikin takardun aiki.
Samar da wata takarda farawa ta shigar da alamar daidai a cikin tantanin halitta inda kake son amsawa ta nuna. Formulas na iya haɗawa da tantancewar salula akan wurin samo bayanai da kuma ɗaya ko fiye da ayyuka masu mahimmanci .
Ayyukan ayyuka a Excel da sauran shafukan yanar gizo na lantarki suna ƙera su ne a cikin ƙididdiga waɗanda aka tsara don sauƙaƙe da aiwatar da fasalin lissafi - daga ayyuka na yau da kullum kamar shigar da kwanan wata ko lokaci zuwa ƙananan hadaddun irin su gano takamaiman bayanin da ke cikin manyan manyan bayanai na bayanai .
Bayanan Excel da Bayani
Ana amfani da shafukan rubutu don amfani da bayanan kudi. Formulas da ayyukan da aka yi amfani da su a kan wannan irin bayanai sun hada da:
- Yin ayyuka na tushen ilmin lissafi kamar su ginshiƙai ko jerin layuka .
- Gano dabi'u kamar riba ko asarar.
- Ana kirga kudade na biya don bashi ko jinginar gidaje.
- Gano matsakaicin, iyakar, mafi ƙarancin da sauran dabi'un kididdiga a cikin kewayon bayanai.
- Gudanar da Abin da-Idan bincike game da bayanan - inda aka canza canje-canje a lokaci ɗaya don ganin yadda canjin ya canza wasu bayanai - irin su kudi da riba.
Sauran Ayyuka na Excel
Sauran aikace-aikacen yau da kullum da aka yi amfani da Excel domin sun hada da:
- Bayyanawa ko tsara bayanai don taimakawa masu amfani wajen gano abubuwan da suka shafi bayanai.
- Shirya bayanai don yin amfani da muhimman bayanai masu sauƙi don ganowa da ganewa.
- Rubutun bayanai da sigogi don amfani a cikin rahotannin.
- Kayyade da kuma tace bayanai don samun bayani na musamman.
- Haɗin keɓaɓɓun bayanai da sigogi don amfani a wasu shirye-shirye kamar Microsoft PowerPoint da Kalma.
- Ana shigo da bayanai daga shirye-shiryen bayanai don bincike.
Fayil ɗin rubutu sune asali na 'kisa samfurori ' don kwakwalwa ta sirri sabili da ikon haɗaka da kuma fahimtar bayanai. Shirin shirye-shirye na farko da suka hada da VisiCalc da Lotus 1-2-3 suna da alhakin girma a shahararrun kwakwalwa kamar Apple II da IBM PC a matsayin kayan aiki.