Excel software ce daga Excel Microsoft, wanda aka haɗa a cikin kunshin Office. Tare da wannan shirin yana yiwuwa a tsara da haɓaka maƙunsar rubutu, wakiltar da sauransu. Kudin aiwatar da ayyukan ku, yada kashe kuɗi, nazarin hoto. Daga cikin ayyuka da yawa da ke akwai, haɓakar ƙididdiga don sarrafa ƙididdiga ta atomatik ana godiya sosai. Duk don tsara bayanai da daidaita nau'ikan sigogi daban-daban.

Ana amfani da Excel sau da yawa don shirya, musamman:

  • Kasafin kudi, kamar samar da tsarin kasuwanci misali;
  • Ƙididdigar lissafi, tare da yin amfani da hanyoyin lissafi da bayanan lissafin kuɗi, kamar tsabar kudi da riba;
  • Ba da rahoto, auna aikin aikin da kuma nazarin bambance-bambancen sakamako;
  • Lissafi da tallace-tallace. Don gudanar da tallace-tallace da bayanan lissafin kuɗi, yana yiwuwa a yi tunanin siffofin da suka dace da takamaiman bukatun;
  • Tsara, don ƙirƙirar ayyukan ƙwararru da tsare-tsare, kamar binciken tallace-tallace da sauransu;

Menene ainihin ayyukan Excel:

  • Ƙirƙirar tebur,
  • Ƙirƙirar littattafan aiki,
  • Ƙirƙirar maƙunsar bayanai
  • Shigar da bayanai da lissafin atomatik a cikin maƙunsar rubutu,
  • Buga takardar aiki.

Yadda ake aiwatar da wasu ayyuka na asali a cikin Excel?

  1. Ƙirƙirar tebur:

Danna kan Sabon zaɓi sannan zaɓi samfuran da ake da su, waɗanda zasu iya zama: maƙunsar rubutu mara kyau, tsoffin samfura ko sabbin samfuran da ke akwai.

Don ƙirƙirar littafin aiki, danna zaɓin Fayil (wanda yake cikin babban menu), sannan Sabo. Zaɓi zaɓin littafin aikin Blank. Za ku lura cewa takaddun yana da zanen gado 3, ta danna maɓallin linzamin kwamfuta na dama, yana yiwuwa a cire ko saka yawancin zanen gado kamar yadda ya cancanta.

  1. Aiwatar da iyakoki:

Da farko zaži tantanin halitta, danna Zaɓin Zaɓin All (wanda yake a saman menu), sannan zaɓi daga Home tab, zaɓin Font kuma gungura ƙasa zuwa zaɓi na Borders, yanzu kawai kuna buƙatar zaɓi salon da kuke so.

  1. Don canza launi:

Zaɓi tantanin halitta da ake so da rubutun da kake son gyarawa. Je zuwa zaɓin Gida, Ƙararren abu na Font, danna Font Launi da jeri a cikin Jigogi Launuka.

  1. Don daidaita rubutu:

Zaɓi sel masu rubutun, danna Gida, sannan danna Alignment.

  1. Don shafa shading:

Zaɓi cell ɗin da kake son canzawa, je zuwa menu na sama kuma danna Home, sannan zuwa rukunin Rukunin Font, sannan danna Cika Launi. Buɗe Zaɓin Launuka kuma zaɓi launi da kuka fi so.

  1. Shigar da bayanai:

Don shigar da bayanai a cikin maƙunsar bayanai na Excel, kawai zaɓi cell kuma rubuta bayanin, sannan danna ENTER ko, idan kuna so, zaɓi maɓallin TAB don matsawa zuwa tantanin halitta na gaba. Don saka sabbin bayanai a cikin wani layi, danna haɗin ALT+ENTER.

  1. Don yin tasiri:

Bayan shigar da duk bayanan, tsara maƙunsar bayanai da zane-zane ta hanyar da ake so, bari mu ci gaba da buga daftarin aiki. Don buga maƙunsar bayanai, zaɓi tantanin halitta don nunawa. Danna kan babban menu "Fayil" sannan danna Buga. Idan ka fi so, yi amfani da gajeriyar hanyar keyboard, CTRL+P.

A ƙarshe

Idan kuna son ƙarin sani game da amfani da shirin aikin Excel, kada ku yi shakka don horar da kanku kyauta tare da ƙwararrun bidiyoyi akan rukunin yanar gizon mu.