Ayyuka a cikin Excel suna ba ku damar gudanar da ayyuka daban-daban masu rikitarwa a cikin 'yan danna kaɗan. Kayan aiki mai dacewa kamar "Mayen Alamar". Bari mu kalli yadda yake aiki da abin da zaku iya tare dashi.
Aikin Wizard na Aiki
Mayan fasalin kayan aiki ne a cikin hanyar karamin taga wanda dukkanin ayyukan da ake samu a cikin Excel ana rarrabe su a cikin rukuni, wanda ke ba da damar samun sauƙin su. Hakanan yana ba da ikon shigar da hujjoji na dabara ta hanyar kera mai hoto.
Je zuwa Mayen aikin
Mayan fasalin Kuna iya farawa ta hanyoyi da yawa a lokaci daya. Amma kafin ku kunna wannan kayan aikin, kuna buƙatar zaɓar tantanin da za'a saka fom ɗin kuma saboda haka, sakamakon zai nuna.
Hanya mafi sauki da za a shiga ita ce ta danna maballin "Saka aikin"located a hagu na dabara tsari. Wannan hanyar tana da kyau saboda zaka iya amfani dashi daga kowane shafin shirin.
Bugu da ƙari, za'a iya ƙaddamar da kayan aikin da muke buƙata ta hanyar zuwa shafin Tsarin tsari. Sannan yakamata ku danna maballin a gefen hagu na hagu "Saka aikin". An samo shi a cikin toshe kayan aiki. Laburaren Ma’aikata. Wannan hanyar ta fi muni ta gabata a waccan hanyar in ba ka kasance a shafin ba Tsarin tsari, to lallai zakuyi ƙarin matakai.
Hakanan zaka iya danna kowane maɓallin kayan aiki. Laburaren Ma’aikata. A lokaci guda, jerin za su bayyana a cikin jerin abubuwan da aka saukar, a kasan wanda akwai wani abu "Sanya aikin ...". Anan ya zama dole a danna shi. Amma, wannan hanyar ta fi rikicewa fiye da wacce ta gabata.
Hanyar mai sauƙin canzawa zuwa Masters yana latsa hade hade Canji + F3. Wannan zabin yana samar da motsi mai sauri ba tare da ƙarin “motsawar jiki” ba. Babbar dibu ita ce ba kowane mai amfani bane yake iya kiyaye duk abubuwan haɗuwar hotkey a kansa. Don haka ga masu farawa a cikin haɓakar Excel, wannan zaɓin bai dace ba.
Abubuwan rukuni a cikin Wizard
Ko wace hanya na kunnawa kuka zaba daga bisa, a kowane yanayi, bayan wadannan ayyukan, taga yana farawa Masters. A saman taga akwai filin bincike. Anan zaka iya shigar da sunan aikin kuma danna maɓallin Nemoda sauri sami abin da ake so kuma samun damarsa.
A tsakiyar ɓangaren taga yana gabatar da jerin abubuwa-digo-iri na ayyukan ayyuka waɗanda suke wakilta Maigidan. Don ganin wannan jeri, danna maballin a cikin nau'in alwati mai juyawa ta dama da shi. Wannan yana buɗe cikakken jerin samfuran da ke akwai. Zaka iya gungura ƙasa ta amfani da sandar sashin gefe.
Dukkanin ayyuka sun kasu kashi biyu ne:
- Rubutu
- Kudi;
- Kwanan wata da lokaci
- Hanyoyi da hanyoyin shirya bayanai;
- Istididdiga
- Nazari;
- Aiki tare da bayanan bayanan;
- Tabbatar da kaddarorin da dabi'u;
- Mai hankali
- Injiniya
- Lissafi;
- Ma'anar Mai amfani
- Yarbuwa.
A cikin rukuni Ma'anar Mai amfani akwai ayyukan da mai amfani ya tattara ko aka saukar dashi daga hanyoyin waje. A cikin rukuni "Amincewa" abubuwa daga tsoffin juzu'ai na Excel ana yin su don sababbin takwarorinsu sun wanzu. An tattara su a cikin wannan rukunin don tallafawa jituwa tare da takardun da aka kirkiro a cikin tsoffin sigogin aikace-aikacen.
Bugu da kari, wannan jerin ya ƙunshi ƙarin nau'ikan biyu: "Cikakken jerin haruffa" da "10 da aka yi amfani da kwanan nan". A cikin rukunin "Cikakken jerin haruffa" Akwai cikakken jerin duk ayyukan, ba tare da la'akari da rukuni ba. A cikin rukunin "10 da aka yi amfani da kwanan nan" akwai jerin abubuwan abubuwa goma da suka gabata wanda mai amfani ya koma dashi. Ana sabunta wannan lissafin koyaushe: an cire abubuwa da aka yi amfani dasu a baya, kuma an ƙara sababbi.
Zaɓin aikin
Domin zuwa taga muhawara, da farko, kuna buƙatar zaɓar nau'in da ake so. A fagen "Zaɓi aiki" ya kamata a lura da sunan da ake buƙata don yin takamaiman aiki. A kasan taga akwai alamar a yanayin magana a kan abin da aka zaɓa. Bayan an zaɓi takamaiman aiki, kuna buƙatar danna kan maɓallin "Ok".
Hujjojin Aiki
Bayan haka, taga muhawara na aiki yana buɗewa. Babban abu na wannan taga shine filayen muhawara. Ayyuka daban-daban suna da muhawara daban-daban, amma yanayin aiki tare da su ya kasance iri ɗaya ne. Zai yiwu ya kasance da yawa, ko wataƙila ɗayan. Tattaunawa na iya zama lambobi, nassoshin tantanin halitta, ko ma hanyoyin shiga jerin hanyoyin.
- Idan muka yi aiki da lamba, muna shigar da shi ne kawai daga maballin cikin filin, daidai da yadda muke fitar da lambobi cikin sel.
Idan ana amfani da hanyar haɗin yanar gizo azaman hujja, to kuna iya rijistar su da hannu, amma yafi dacewa a yi in ba haka ba.
Sanya siginan kwamfuta a cikin filin muhawara. Ba tare da rufe taga ba Masters, zaɓi tantanin ko duk kewayoyin sel waɗanda kuke buƙatar aiwatarwa tare da siginan kwamfuta akan takardar. Bayan haka, a cikin filin taga Masters ana shigar da daidaitawar sel ko kewayon ta atomatik. Idan aiki yana da muhawara da yawa, to a cikin hanyar zaka iya shigar da bayanai a cikin filin na gaba.
- Bayan an shigar da dukkan mahimman bayanan, danna kan maɓallin "Ok", ta hanyar fara aiwatar da aikin aiwatar da aiki.
Aikin aiwatarwa
Bayan kun danna maballin "Ok" Maigidan yana rufewa kuma aikin da kansa ake kashewa. Sakamakon kisa yana iya zama mafi bambanta. Ya dogara ne akan ayyukan da aka gabatar gabanin tsari. Misali, aikin SAURARA, wanda aka zaba a matsayin misali, ya taƙaita duk muhawara da aka shigar kuma yana nuna sakamakon a cikin tantanin halitta daban. Ga wasu zaɓuɓɓuka daga lissafin Masters sakamakon zai bambanta gaba daya.
Darasi: Abubuwan Kyakkyawan fasali na Excel
Kamar yadda kake gani Mayan fasalin kayan aiki ne mai sauƙin amfani wanda ke sauƙaƙa aikin sosai tare da tsari a cikin Excel. Tare da shi, zaku iya bincika abubuwan da suka zama dole daga jerin, sannan kuma ku shigar da hujjoji ta hanyar zanen mai hoto. Don masu farawa Maigidan musamman ma babu makawa.
