Lokacin haɓaka manyan ayyuka, ƙarfin ma'aikaci ɗaya ba ya isa. Gaba ɗaya gungun kwararru suna cikin wannan aikin. A zahiri, kowannensu ya sami damar shiga cikin takaddun, wanda shine aikin hadin gwiwa. Dangane da wannan, batun tabbatar da wadatar shiga lokaci daya ya zama mai matukar gaggawa. Excel yana da kayan aikinsa na iya samarwa. Bari mu fahimci yanayin aikace-aikacen Excel a cikin yanayin aikin lokaci ɗaya na masu amfani da yawa tare da littafi guda.
Tsarin aiki tare
Excel ba zai iya ba kawai samar da dama ga fayil ɗin ba, har ma don magance wasu matsalolin da suka bayyana a yayin haɗaka tare da littafi guda. Misali, kayan aikin aikace-aikacen suna baka damar bin diddigin canje-canje da mahalarta daban daban, kazalika ka amince dasu ko kuma ka basu. Zamu gano abin da shirin zai iya bayarwa ga masu amfani da ke fuskantar irin wannan aiki.
Raba
Amma duk muna farawa da fahimtar yadda ake raba fayil. Da farko dai, dole ne a faɗi cewa hanyar don kunna yanayin haɗin gwiwar tare da littafi ba za a iya yin sa akan uwar garke ba, amma a kwamfutar gida kawai. Sabili da haka, idan an adana takaddar a kan sabar, to, da farko, dole ne a canja shi zuwa PC na gida kuma a can duk ayyukan da aka bayyana a ƙasa ya kamata a riga an yi su.
- Bayan an ƙirƙiri littafin, je zuwa shafin "Duba" kuma danna maballin "Samun damar shiga littafin"wanda yake a cikin shinge na kayan aiki "Canza".
- Sannan sai an kunna taga damar sarrafa fayil. Duba akwatin kusa da sigar a ciki. "Ba da izinin masu amfani da yawa don shirya littafin a lokaci guda". Bayan haka, danna maballin "Ok" a kasan taga.
- Akwatin maganganu yana bayyana acikin abin da aka sanar da kai don aje fayil ɗin tare da canje-canjen da aka yi. Latsa maballin "Ok".
Bayan matakan da ke sama, raba fayil ɗin daga na'urori daban-daban kuma a ƙarƙashin asusun mai amfani daban-daban zai buɗe. Wannan yana nunawa ta gaskiyar cewa a saman ɓangaren taga bayan taken littafin an bayyana sunan yanayin samun shiga - "Janar". Yanzu ana iya canja wurin fayil ɗin zuwa uwar garken.
Saiti Farawa
Bugu da kari, duk a cikin taga damar fayil iri ɗaya, zaka iya saita saitunan tsarin aiki lokaci guda. Kuna iya yin haka nan da nan lokacin da aka kunna yanayin haɗin gwiwar, ko kuma za ku iya shirya saitunan kaɗan. Amma, ba shakka, kawai babban mai amfani wanda ke daidaita ayyukan gaba ɗaya tare da fayil ɗin zai iya sarrafa su.
- Je zuwa shafin "Cikakkun bayanai".
- Anan zaka iya tantance ko don kiyaye rajistar canjin, kuma idan haka ne, wane lokaci (ta tsohuwa, an sanya kwanaki 30).
Hakanan yana ƙayyade yadda za a sabunta canje-canje: kawai lokacin da aka ajiye littafin (ta tsohuwa) ko bayan ƙayyadadden lokaci.
Wani muhimmin misali shine abu "Ga canje-canje masu sabani". Yana nuna yadda shirin yakamata yayi hali idan masu amfani da yawa suna tallata lokaci guda. Ta hanyar tsoho, an saita yanayin bukatar akai-akai, wanda aikin mahalarta aikin yana da fa'ida. Amma zaka iya haɗawa da yanayin kullun wanda amfana koyaushe shine wanda ya sami nasarar adana canjin da farko.
Bugu da kari, in ana so, zaku iya kashe zabin buga takardu da tacewa daga bayanan mutum ta hanyar cire abubuwan da suka dace.
Bayan haka, kar a manta da yin canje-canjen da aka yi ta danna maɓallin "Ok".
Ana buɗe fayil ɗin da aka raba
Bude fayil a cikin abin da aka kunna raba yana da wasu fasali.
- Kaddamar da Excel kuma je zuwa shafin Fayiloli. Bayan haka, danna maballin "Bude".
- Littafin bude taga yana farawa. Je zuwa ga kundin adireshi ko rumbun kwamfutarka a inda littafin yake. Zaɓi sunan shi kuma danna maɓallin "Bude".
- An buɗe littafin gabaɗaya. Yanzu, idan ana so, za mu iya canza sunan a ƙarƙashin wanda zamu gabatar da canje-canje na fayil a cikin log ɗin. Je zuwa shafin Fayiloli. Bayan haka za mu matsa zuwa sashin "Zaɓuɓɓuka".
- A sashen "Janar" akwai toshe saiti "Keɓaɓɓun Ofishin Microsoft". Anan a fagen Sunan mai amfani Kuna iya canza sunan asusunku zuwa wani. Bayan an gama dukkan saitunan, danna maballin "Ok".
Yanzu zaku iya fara aiki tare da daftarin aiki.
Duba ayyukan membobin
Haɗin kai ya tanadi kula da daidaituwa da kuma daidaita ayyukan dukkan mambobin ƙungiyar.
- Don duba ayyukan da wani takamaiman mai amfani yayi yayin aiki akan littafi, kasancewa a cikin shafin "Duba" danna maballin Gyarawanda ke cikin rukunin kayan aiki "Canza" a kan tef. A cikin menu wanda yake buɗe, danna maballin Haskaka Gyara.
- Ana buɗe buɗe shafin faci Ta hanyar tsohuwa, bayan an raba littafin, ana kunna ayyukan gyara ta atomatik, kamar yadda alamomin ke tabbatar da abin da ya zo daidai ya bayyana.
Ana yin rikodin duk canje-canje, amma akan allon ta tsohuwa ana nuna su azaman launi na sel a cikin kusurwar hagu ta hagu, kawai tun daga ƙarshen lokacin da mai amfani ya ajiye takaddar. Haka kuma, ana daidaita layin dukkan masu amfani a kan dukkan takaddar. Ayyukan kowane ɗan takara suna alama a cikin launi daban.
Idan dalla dalla akan wayar da aka yiwa alama, bayanin kula yana buɗewa, wanda ke nuna ta wane ne kuma lokacin da aka yi wannan aikin.
- Don canza dokoki don nuna daidaituwa, muna komawa zuwa taga saiti. A fagen "Da lokaci" Za'a zaɓi zaɓuɓɓuka masu zuwa don zaɓin lokacin don gyaran gyare-gyare:
- nuna tunda ceton da ya gabata;
- duk gyare-gyaren da aka adana a cikin bayanan;
- wadanda har yanzu ba a duba su ba;
- farawa daga takamaiman ranar da aka nuna.
A fagen "Mai amfani" zaku iya zaɓar takamaiman ɗan takara wanda gyaransa zai nuna, ko kuma ya bar nuni ga ayyukan duk masu amfani banda kanku.
A fagen "A kewayon", zaku iya saka takamaiman kewayo akan takarda, wanda zaiyi la'akari da ayyukan mambobin ƙungiyar don nunawa akan allonku.
Bugu da kari, ta hanyar duba akwatunan da ke gaba da kayan mutum, zaku iya kunna ko musanya ayyukan gyara akan allon da nuna canje-canje a wani takarda daban. Bayan an saita dukkan saiti, danna maballin "Ok".
- Bayan wannan, ayyukan mahalarta za a nuna su a kan takardar la’akari da tsarin da aka shigar.
Duba mai amfani
Babban mai amfani yana da ikon yin amfani da ko ƙin gyara wasu mahalarta. Wannan yana buƙatar waɗannan matakai.
- Kasancewa a cikin shafin "Duba"danna maballin Gyara. Zaɓi abu Yarda / Kin Amincewa da Gyara.
- Na gaba, taga facin zai buɗe. A ciki, kuna buƙatar yin saiti don zaɓar waɗancan canje-canje waɗanda muke son amincewa ko ƙi. Ayyukan wannan taga ana yin su ne bisa ga irin nau'in da muka yi la'akari da su a sashin da ya gabata. Bayan an saita saiti, danna maballin "Ok".
- Window mai zuwa yana nuna duk matakan daidaitawa waɗanda suka gamsar da sigogin da muka zaba a baya. Bayan da aka ba da fifiko ga takamaiman gyara a cikin jerin ayyukan, kuma danna maɓallin daidai wanda yake kasan ƙasan taga a ƙarƙashin jerin, zaku iya karɓar wannan abun ko ku ƙi shi. Hakanan akwai yiwuwar karɓar ƙungiya ko ƙin duk waɗannan ayyukan.
Share mai amfani
Akwai wasu lokuta da ake buƙatar share mai amfani da mutum. Wannan na iya zama saboda gaskiyar cewa ya bar aikin, kuma kawai don dalilai na fasaha, alal misali, idan aka shigar da asusun ba daidai ba ko mahalarta sun fara aiki daga wata na'urar. A cikin Excel akwai irin wannan damar.
- Je zuwa shafin "Duba". A toshe "Canza" a kan tef danna kan maɓallin "Samun damar shiga littafin".
- Farashin damar sarrafa fayil ɗin da aka saba yana buɗewa. A cikin shafin Shirya Akwai jerin duk masu amfani waɗanda ke aiki tare da wannan littafin. Zaɓi sunan mutumin da kake so ka cire, danna maɓallin Share.
- Bayan wannan, akwatin buɗe magana ana buɗe ta wanda aka yi gargadin cewa idan wannan mahalarta yana shirya littafin a wannan lokacin, to duk ayyukansa ba za su sami ceto ba. Idan kun amince da shawarar ku, to danna "Ok".
Za'a share mai amfani.
Taƙaitawar Littattafan Janar
Abin takaici, aikin lokaci ɗaya tare da fayil a cikin Excel yana ba da iyakoki da yawa. A cikin fayil ɗin da aka raba, babu ɗayan masu amfani, ciki har da babban ɗan takara, wanda zai iya yin ayyukan da ke gaba:
- Createirƙiri ko canza rubutun;
- Tablesirƙiri tebur
- Rarrabe ko haɗa ƙwayoyin cuta;
- Yi ma'amala tare da bayanan XML
- Newirƙiri sabon tebur;
- Goge zanen gado;
- Yi tsari na tsari da kuma wasu ayyuka da yawa.
Kamar yadda kake gani, ƙuntatawa suna da muhimmanci sosai. Idan, alal misali, sau da yawa zaka iya yin ba tare da aiki tare da bayanan XML ba, to ba tare da ƙirƙirar teburin ba, ba zaku iya tunanin yin aiki a Excel ba. Me za ku yi idan kuna buƙatar ƙirƙirar sabon tebur, haɗa sel ko yin wani aiki daga jerin abubuwan da ke sama? Akwai mafita, kuma abu ne mai sauqi: kuna buƙatar kashe takaddara na ɗan lokaci, yin canje-canjen da suka wajaba, sannan kuma a sake haɗa fasalin haɗin gwiwar.
Ana kashe rabawa
Lokacin da aka kammala aikin akan aikin, ko kuma, idan ya zama dole a yi canje-canje ga fayil ɗin, jerin abubuwan da muka ambata a sashin da ya gabata, ya kamata ka kashe yanayin haɗin gwiwar.
- Da farko dai, duk mahalarta dole ne su adana canje-canje kuma su fita fayil ɗin. Babban mai amfani kawai ya rage don aiki tare da takaddar.
- Idan kana buƙatar adana bayanan ayyukan bayan an cire hanyar damar, to, kasancewa a cikin shafin "Duba"danna maballin Gyara a kan tef. A menu na buɗe, zaɓi "Haskaka gyare-gyare ...".
- Wurin nuna alama yana buɗewa. Saitunan da ke nan ana buƙatar shirya su kamar haka. A fagen "Cikin lokaci" saita siga "Duk". Sunaye na filin adawa "Mai amfani" da "A kewayon" ya kamata cirewa Dole ne a aiwatar da irin wannan tsari tare da sigogi "Haskaka gyare-gyare akan allon". Amma akasin sigogi "Yi canje-canje a kan wani takarda daban"akasin haka, ya kamata a saita kaska. Bayan an gama amfani da waɗannan maɓallan na sama, danna maballin "Ok".
- Bayan wannan, shirin zai samar da sabon takarda da ake kira Magazine, wanda zai ƙunshi duk bayanan da ke kan wannan fayil ɗin a tebur.
- Yanzu ya rage don kashe rabawa kai tsaye. Don yin wannan, located a cikin shafin "Duba", danna maballin da muka riga muka sani "Samun damar shiga littafin".
- Ana rarraba window na raba rabawa. Je zuwa shafin Shiryaidan aka bude taga a wani shafin. Cire abin "Ba da izinin masu amfani da yawa su canza fayil ɗin a lokaci guda". Don gyara canje-canje danna maɓallin "Ok".
- Akwatin tattaunawa ana buɗe ta inda aka yi gargaɗin cewa yin wannan matakin zai sa ya yiwu a raba takarda. Idan kun kasance da tabbaci game da shawarar da aka yanke, to danna kan maɓallin Haka ne.
Bayan matakan da ke sama, za a rufe raba fayil kuma a share facin log ɗin. Bayani game da ayyukan da aka yi a baya za a iya gani yanzu a cikin nau'i na tebur kawai akan takardar Magazineidan an dauki matakan da suka dace don adana wannan bayanin a baya.
Kamar yadda kake gani, shirin na Excel yana ba da ikon taimakawa damar raba fayil da aiki tare lokaci daya. Bugu da kari, ta amfani da kayan aikin musamman zaku iya bin diddigin ayyukan mambobin kungiyar masu aiki. Wannan yanayin har yanzu yana da wasu iyakancewar aiki, wanda, koyaya, ana iya keɓance shi ta hanyar hana damar amfani da ɗan lokaci da aiwatar da abubuwan da sukakamata a yanayin aiki na al'ada.
