ZAZZAGE SHIRIN EXCEL KYAUTA

Send

Yin aiki tare da adadi mai yawa na bayanai na iya zama babban aiki mai wahala idan babu shirye-shirye na musamman a kusa. Tare da taimakonsu, zaku iya ware lambobi cikin sauƙi da layuka da ginshiƙai, aiwatar da ƙididdigar atomatik, yin abubuwan sakawa iri-iri, da ƙari mai yawa.

Microsoft Excel shine mafi mashahuri shirin don tsara bayanai masu yawa. Ya ƙunshi dukkanin ayyukan da ake buƙata don irin wannan aikin. A cikin hannayen gwani, Excel na iya yin yawancin ayyukan a maimakon mai amfani. Bari muyi la'akari da mahimman kayan aikin.

Tablesirƙiri tebur

Wannan shine mafi mahimmancin aiki wanda dukkanin aikin in Excel yake farawa. Godiya ga yawancin kayan aiki, kowane mai amfani zai iya ƙirƙirar tebur daidai da zaɓin da suke so ko kuma bisa tsarin da aka bayar. An fadada ginshiƙai da layuka zuwa girman da ake so tare da linzamin kwamfuta. Za'a iya yin iyaka.

Saboda bambancin launi, yin aiki tare da shirin ya zama mafi sauƙi. Komai a bayyane yake rarraba kuma baya hade cikin taro ɗaya na launin toka.

A cikin aiwatarwa, ana iya share ko ƙara lambobi. Hakanan zaka iya aiwatar da daidaitattun ayyuka (yanke, kwafa, manna).

Kayan salula

Sel a cikin Excel ana kiranta yanki na shiga tsakanin layi da shafi.

Lokacin tattara tebur, koyaushe yana faruwa cewa wasu dabi'u suna da lambobi, wasu suna da kuɗi, kwanan wata na uku, da sauransu. A wannan yanayin, ana sanya tantanin halitta takamaiman tsari. Idan akwai buƙatar aiwatar da aiki ga duk sel na shafi ko layi, to ana amfani da tsara tsari don yankin da aka ƙayyade.

Tsarin tebur

Wannan aikin ya shafi dukkan ƙwayoyin, watau, ga teburin kanta. Shirin yana da ginanniyar ɗakunan karatu na shaci, wanda ke adana lokaci akan bayyanar ƙira.

Tsarin tsari

Formulas ana kiransu maganganu waɗanda ke yin wasu ƙididdiga. Idan kun shigar farkonsa a cikin tantanin halitta, to a cikin jerin abubuwanda za'a gabatar duk zabin dazai yiwu, saboda haka ba lallai bane a haddace su da zuciya ba.

Ta amfani da waɗannan dabarun, zaku iya yin lissafin da yawa akan ginshiƙai, layuka, ko kuma a tsari da tsari. Dukkanin waɗannan abubuwa sun daidaita ta mai amfani don takamaiman aiki.

Saka Abubuwa

Kayan aikin ginannun yana ba ku damar sakawa daga abubuwa daban-daban. Zai iya zama wasu tebur, zane, hotuna, fayiloli daga Intanit, hotuna daga kyamarar kwamfuta, hanyoyin haɗi, zane, da ƙari.

Batun bita

A cikin Excel, kamar yadda yake a cikin sauran shirye-shiryen ofishin Microsoft, an haɗa ginanniyar fassarar bayanai da kundin adireshin inda ake aiwatar da saitunan yare. Hakanan zaka iya ba da damar duba sihiri.

Bayanan kula

Kuna iya ƙara bayanin kula a kowane yanki na tebur. Waɗannan ƙayyadaddu ne na musamman waɗanda bayanin shigar game da abubuwan ciki ya shiga. Za'a iya barin bayanin abu aiki ko a ɓoye, a cikin wane yanayi ne zai bayyana lokacin da ka hau kan sel tare da linzamin kwamfuta.

Musammam Bayyanar

Kowane mai amfani na iya tsara bayyanar shafukan da windows kamar yadda suke so. Duk filin aikin za'a iya bude shi ko kuma karya shi ta hanyar layi mai kyau a shafuka. Wannan ya zama dole don bayanin zai dace da takarda da aka buga.

Idan wani bai gamsu da amfani da grid ba, zaku iya kashe shi.

Wani shirin yana ba ku damar yin aiki tare da shirin guda a cikin windows daban-daban, wannan ya dace musamman tare da adadi mai yawa. Wadannan windows ana iya shirya su ba da tsari ko tsari gaba daya.

Kayan aiki mai dacewa shine sikelin. Tare da shi, zaku iya ƙaruwa ko rage nuni daga wuraren aiki.

Kanun labarai

Gungura ta tebur mai shafuka masu yawa, zaku iya lura cewa sunayen shafin ba su shuɗe ba, wanda ya dace sosai. Bai kamata mai amfani ya koma farkon teburin kowane lokaci don gano sunan shafin ba.

Munyi la'akari da mahimman kayan aikin kawai. A cikin kowane shafin akwai kayan aikin daban-daban, kowannensu yana yin ƙarin aikin sa. Amma a cikin labarin ɗaya yana da wuya matuƙar a haɗa shi duka.