Microsoft Excel zai iya sauƙaƙe aikin mai amfani tare da tebur da kuma maganganun lambobi, sarrafa shi. Ana iya samun wannan ta amfani da kayan aiki na wannan aikace-aikacen, da kuma ayyuka daban-daban. Bari mu dubi siffofin da suka fi dacewa na Microsoft Excel.
Ayyukan Vpr
Ɗaya daga cikin shahararrun siffofin a cikin Microsoft Excel shine VLOOKUP. Tare da wannan aikin, zaka iya darajar dabi'u na ɗayan ɗaya ko da yawa, ja zuwa wani. A wannan yanayin, ana nema ne kawai a cikin shafi na farko na tebur. Sabili da haka, lokacin da bayanai ke canje-canje a cikin teburin tushe, ana samar da bayanai ta atomatik a cikin tebur da aka samo, wanda za'a iya yin lissafi daban. Alal misali, bayanai daga teburin da farashin farashin farashin kayayyaki za a iya amfani dashi don lissafin alamun a cikin teburin, game da ƙarar sayayya cikin ka'idodin kuɗi.
An fara CDF ta hanyar saka na'urar "CDF" daga Wizard Wurin aiki a cikin tantanin halitta inda za'a nuna bayanai.
A cikin taga wanda ya bayyana, bayan an fara wannan aikin, kana buƙatar saka adireshin cell ko kewayon kwayoyin daga wanda za'a zartar da bayanan.
Darasi: Yin amfani da WFD a cikin Microsoft Excel
Tsarin Tables
Wani muhimmin alama na Excel shine ƙirƙirar matakan pivot. Tare da wannan aikin, za ka iya tattara bayanai daga sauran Tables bisa ga ka'idodi daban-daban, kazalika da yin lissafi tare da su (jimla, ninka, raba, da dai sauransu), da kuma fitar da sakamakon a cikin tebur daban. A lokaci guda, akwai matakai masu yawa don kafa matakan filayen pivot.
Za'a iya kirkiro tebur a cikin "Saka" ta danna kan "abin da ake kira" Pivot Table "button.
Darasi: Yin amfani da PivotTable a Microsoft Excel
Yin sigogi
Don nuni na bayyane da aka sanya a cikin tebur, zaka iya amfani da sigogi. Ana iya amfani da su don ƙirƙirar gabatarwa, rubuta takardun bincike, don dalilai na bincike, da dai sauransu. Microsoft Excel tana samar da kayan aiki mai yawa don samar da nau'ukan iri daban-daban.
Don ƙirƙirar ginshiƙi, kana buƙatar zaɓar saiti na sel tare da bayanan da kake son nunawa na ido. Bayan haka, kasancewa a cikin "Saka" tab, zaɓi kan rubutun irin nau'in zane wanda ka yi la'akari da mafi dacewa don cimma burin da aka saita.
Tsarin zane na musamman, wanda ya haɗa da kafa sunayensa da kuma hanyoyi, an yi a cikin shafin "Aiki tare da zane".
Ɗaya daga cikin nau'i na chart ne graphics. Ka'idar da suka yi shine daidai da sauran nau'ikan zane.
Darasi: Yin amfani da sigogi a cikin Microsoft Excel
Formulas a cikin EXCEL
Don yin aiki tare da bayanan lambobi a cikin Microsoft Excel, yana dace don amfani da matakan da suka dace. Tare da taimakonsu, zaka iya yin aiki da yawa tare da bayanai a cikin teburin: Bugu da ƙari, ƙaddamarwa, ƙaddamarwa, rarraba, ƙaddamarwa zuwa mataki na cirewa daga tushen, da dai sauransu.
Domin yin amfani da wannan tsari, kana buƙatar a tantanin salula inda kake shirin nuna sakamakon, sanya alamar "=". Bayan wannan, ana gabatar da samfurin kanta, wanda zai iya haɗa da alamomin lissafi, lambobi, da adiresoshin salula. Domin saka adireshin tantanin tantanin halitta daga abin da aka tattara bayanai don lissafi, kawai danna shi tare da linzamin kwamfuta, kuma haɗin zai bayyana a tantanin halitta don nuna sakamakon.
Har ila yau, Microsoft Excel za a iya amfani dashi azaman ƙwararri na yau da kullum. Don yin wannan, a cikin maɓallin tsari ko a kowace tantanin halitta kawai shigar da kalmomin ilmin lissafi bayan alamar "=".
Darasi: Aiwatar da matakan a cikin Microsoft Excel
IF aikin
Ɗaya daga cikin siffofin da aka fi amfani da shi a Excel shine aikin "IF". Tare da taimakonsa, zaka iya saita tantanin tantanin halitta sakamakon fitar da sakamakon daya lokacin da aka sadu da wani yanayi, da kuma wani sakamako, idan akwai rashin cikawar.
Haɗin aikin wannan shine kamar "IF (maganganun magana; [sakamakon idan gaskiya]; [sakamakon idan ƙarya])".
Tare da taimakon masu aiki "DA", "OR" da kuma aikin da aka haɓaka "IF", za ka iya saita yarda da wasu sharuɗɗa, ko ɗaya daga cikin yanayi da yawa.
Darasi: Yin amfani da aikin IF a cikin Microsoft Excel
Macros
Yin amfani da macros a cikin Microsoft Excel, za ka iya rikodin aiwatar da wasu ayyuka, sannan ka danna su ta atomatik. Wannan muhimmanci yana adana lokacin yin aiki mai yawa irin wannan.
Za'a iya rikodin Macros ta hanyar kunna rikodin ayyukan su a cikin shirin, ta hanyar maɓallin dace akan tef.
Har ila yau, ana iya yin amfani da macros ta yin amfani da harshe na ainihi na ainihi a cikin edita na musamman.
Darasi: Yin amfani da Macros a cikin Microsoft Excel
Tsarin Yanayin
Domin zaɓar wasu bayanai a cikin tebur, ana amfani da aikin tsara yanayin. Tare da wannan kayan aiki, zaka iya siffanta ka'idojin zaɓi na cell. Tsarin tsari na kanta zai iya yin shi a cikin hanyar tarihi, launi mai launi, ko saitin gumaka.
Domin ci gaba da tsara tsari, kana buƙatar zaɓar mahaɗin jinsunan da za ku tsara, yayin a cikin shafin shafin. Daga gaba, a cikin kayan aiki na Styles, danna maballin, wadda ake kira Ƙaddamar Tsarin. Bayan haka, kana buƙatar zaɓar zaɓin tsarawa wanda ka yi la'akari da mafi dacewa.
Tsarin za a yi.
Darasi: Aiwatar da Tsarin Yanayi a cikin Microsoft Excel
Smart Table
Ba duk masu amfani san cewa tebur ba, kawai a cikin fensir, ko yin amfani da iyakoki, Microsoft Excel ya gane a matsayin wuri mai sauki na sel. Domin wannan bayanin da aka sa a matsayin tebur, dole ne a sake fasalin.
Anyi wannan ne kawai. Da farko, zaɓar layin da ake so tare da bayanan, sa'an nan, kasancewa a cikin shafin "Home", danna maɓallin "Tsarin azaman tebur". Bayan haka, lissafi yana bayyana tare da zaɓuɓɓuka daban-daban don zane-zane. Zaɓi mafi dace da su.
Har ila yau, ana iya kirkiro tebur ta danna kan maɓallin "Launin", wanda yake a cikin shafin "Saka", bayan zaɓar wani yanki na takaddun bayanai.
Bayan haka, za a iya saita sassan da aka zaɓa na sel na Microsoft Excel a matsayin tebur. A sakamakon haka, alal misali, idan ka shigar da wasu bayanai a cikin kwayoyin dake a iyakoki na tebur, za'a saka su ta atomatik a wannan tebur. Bugu da ƙari, yayin da kake gungurawa, zane na tebur zai kasance a cikin fagen gani.
Darasi: Ƙirƙirar rubutu a Microsoft Excel
Zaɓin zaɓi na yanayin
Tare da taimakon aikin zaɓin zabin, za ka iya tattara bayanan bayanan da ya danganci sakamakon ƙarshe da kake bukata.
Domin amfani da wannan aikin, kana buƙatar shiga cikin "Data" tab. Bayan haka, kana buƙatar danna kan "Bincike" idan "button, wanda yake a cikin kayan aikin" Data tare da Data "sa'an nan kuma zaɓi" Zaɓin zaɓi "... a cikin jerin da ya bayyana.
Zaɓin zaɓin saiti ya tsage. A cikin filin "Shigar a tantanin salula" dole ne ka saka hanyar haɗi zuwa tantanin salula wanda ya ƙunshi tsari da ake so. A cikin filin "Darajar" dole ne a ƙayyade ƙarshen sakamakon da kake so ka samu. A cikin "Canjin Canjin dabi'u" yana buƙatar ka saka ƙayyadaddun tantanin halitta tare da darajar gyaran.
Darasi: Neman Zaɓin Zaben a cikin Microsoft Excel
Ayyukan "INDEX"
Ayyukan da aikin INDEX ya samar yana da kusa da damar da CDF ke aiki. Har ila yau yana ba ka damar bincika bayanai a cikin tsararren dabi'u, kuma mayar da su zuwa tantanin halitta da aka ƙayyade.
Maganar wannan aiki shine kamar haka: "INDEX (radiyon layin waya; lambar layin; lambar shafi)."
Wannan ba cikakken jerin ayyukan da suke samuwa a Microsoft Excel ba. Mun dakatar da hankali kawai a kan mafi mashahuri, kuma mafi mahimmancin su.
