Contents
- Yadda ake Aika Sheets na Excel 2013 zuwa Yanar Gizo
- Yi aiki tare da littattafan aiki a cikin Excel Online
- Yadda ake ƙirƙirar littafin aiki a cikin Excel Online
- Yadda ake gyara littattafan aiki a cikin Excel Online
- Yadda ake Raba takardar Aiki tare da Wasu Masu amfani a Excel Online
- Yadda ake toshe gyara wasu sel akan takardar da aka raba
- Yadda ake shigar da takardar Excel a cikin Yanar Gizo ko Blog
- Mashups a cikin Excel Web App
A cikin ɗayan labarin, mun yi nazarin dabarun canza zanen Excel zuwa HTML. A yau da alama kowa yana motsawa zuwa ajiyar girgije, don haka me yasa muka fi muni? Sabbin fasaha don raba bayanan Excel akan Intanet hanya ce mai sauƙi, tare da fasali da fa'idodi da yawa waɗanda zaku iya amfani da su.
Tare da zuwan Excel Online, ba kwa buƙatar ƙarar lambar HTML don buga maƙunsar bayanai akan gidan yanar gizo. Ajiye littafin aikinku kawai akan layi kuma samun dama gare shi daga ainihin ko'ina, raba shi tare da wasu, kuma kuyi aiki tare akan maƙunsar rubutu iri ɗaya. Yin amfani da Excel Online, za ku iya shigar da takardar Excel a cikin gidan yanar gizo ko blog kuma ku ba baƙi damar yin hulɗa tare da shi don samun ainihin bayanin da suke so su samu.
Daga baya a cikin wannan labarin, za mu kalli waɗannan da sauran abubuwa da yawa waɗanda Excel Online ke bayarwa.
Yadda ake Aika Sheets na Excel 2013 zuwa Yanar Gizo
Idan kawai kuna farawa tare da sabis na girgije gabaɗaya da Excel Online musamman, to farkon farawa mai sauƙi shine raba littafin aikin da ake da shi ta amfani da masaniyar Excel 2013 da aka saba akan kwamfutarka.
Ana adana duk takaddun kan layi na Excel a cikin sabis na gidan yanar gizo na OneDrive (tsohon SkyDrive). Kamar yadda wataƙila kuka sani, wannan ma'adana ta kan layi ya ɗan daɗe yanzu kuma yanzu an haɗa shi cikin Microsoft Excel azaman umarnin dubawa sau ɗaya. Bugu da kari, baƙi, watau sauran masu amfani waɗanda kuke raba maƙunsar bayananku da su ba sa buƙatar asusun Microsoft nasu don dubawa da shirya fayilolin Excel ɗin da kuke rabawa tare da su.
Idan har yanzu ba ku da asusun OneDrive, kuna iya ƙirƙirar ɗaya a yanzu. Wannan sabis ɗin mai sauƙi ne, kyauta kuma tabbas ya cancanci kulawar ku tunda yawancin aikace-aikacen Microsoft Office 2013 suite (ba Excel kaɗai) ke goyan bayan OneDrive ba. Bayan yin rijista, bi waɗannan matakan:
1. Shiga cikin asusun Microsoft ɗin ku
Tabbatar cewa kun shiga cikin asusun Microsoft ɗinku daga Excel 2013. Buɗe littafin aikin Excel ɗin ku kuma duba a kusurwar dama ta sama. Idan kun ga sunan ku da hotonku a can, to ku ci gaba zuwa mataki na gaba, in ba haka ba danna shiga (Input).
Excel zai nuna taga yana tambayar ku don tabbatar da cewa da gaske kuna son ba da izinin Office don haɗawa da Intanet. Danna A (Ee) sannan shigar da bayanan asusun Windows Live ɗin ku.
2. Ajiye takardar ku ta Excel zuwa gajimare
Tabbatar, don kwanciyar hankalin ku, cewa littafin aikin da ake so a buɗe yake, wato, ainihin wanda kuke son rabawa akan Intanet. Ina so in raba littafi Jerin Kyautar Holidaydomin yan uwa da abokaina su kalla su taimaka 🙂
Tare da buɗe littafin aiki, je zuwa shafin Fillet (Fayil) kuma danna Share (Raba) a gefen hagu na taga. Zaɓin tsoho zai kasance Gayyato Mutane (Gayyatar wasu mutane), sannan kuna buƙatar danna Ajiye Zuwa Gajimare (Ajiye zuwa Cloud) a gefen dama na taga.
Bayan haka, zaɓi wuri don adana fayil ɗin Excel. An jera OneDrive da farko a hagu kuma an zaɓa ta tsohuwa. Dole ne kawai ku saka babban fayil ɗin don adana fayil ɗin a ɓangaren dama na taga.
lura: Idan ba ka ga abin menu na OneDrive, to, ba ka da asusun OneDrive, ko kuma ba ka shiga cikin asusunka ba.
Na riga na ƙirƙiri babban fayil na musamman Mai tsara Kyauta, kuma ana nuna shi a cikin jerin manyan fayilolin kwanan nan. Kuna iya zaɓar kowane babban fayil ta danna maɓallin Categories (Bayyana) a kasa yanki Jakunkuna na baya-bayan nan (Faylolin kwanan nan), ko ƙirƙirar sabon babban fayil ta danna dama da zaɓi daga menu na mahallin New (ƙirƙira) > Jaka (fayil). Lokacin da aka zaɓi babban fayil ɗin da ake so, danna Ajiye (Ajiye).
3. Raba takardar Excel Ajiye akan Yanar Gizo
Littafin aikin ku na Excel ya riga ya kasance kan layi kuma kuna iya duba shi a cikin OneDrive na ku. Idan kuna buƙatar raba takaddun Excel da aka adana akan Intanet, to kawai ku ɗauki mataki ɗaya - zaɓi ɗayan hanyoyin da Excel 2013 ke bayarwa don rabawa:
- Gayyato Mutane (Gayyatar wasu mutane). An zaɓi wannan zaɓi ta tsohuwa. Kawai shigar da adireshin imel na abokan hulɗa (s) da kuke son raba takardar Excel da su. Lokacin da ka fara bugawa, Excel's autocomplete zai kwatanta bayanan da ka shigar da sunaye da adireshi a cikin littafin adireshi kuma ya nuna maka jerin zaɓuɓɓukan da suka dace da za a zaɓa daga ciki. Idan kana so ka ƙara lambobi da yawa, shigar da su rabu da ƙananan lambobi. Bugu da ƙari, za ka iya amfani da neman lambobin sadarwa a cikin littafin adireshi, don yin wannan, danna gunkin Bincika Littafin Adireshi (Bincika a cikin littafin adireshi). Kuna iya saita haƙƙoƙin samun dama don dubawa ko gyarawa ta zaɓi zaɓin da ya dace daga jerin abubuwan da aka saukar a dama. Idan ka ƙididdige lambobi masu yawa, to za a saita izini zuwa iri ɗaya ga kowa, amma daga baya za ku iya canza izini ga kowane mutum daban-daban. Hakanan zaka iya ƙara saƙon sirri ga gayyatar. Idan ba ku shigar da komai ba, Excel zai ƙara muku faɗakarwa gabaɗaya.
A ƙarshe, kuna buƙatar zaɓar ko dole ne a shigar da mai amfani a cikin asusun Windows Live don samun damar takaddar Excel ta kan layi. Ban ga wani takamaiman dalili na tilasta musu yin hakan ba, amma ya rage naku.
Lokacin da komai ya shirya, danna maɓallin Share (Gaba ɗaya shiga). Kowane wanda aka gayyata zai karɓi imel mai ɗauke da hanyar haɗi zuwa fayil ɗin da kuka raba. Don buɗe takardar ku ta Excel akan layi, mai amfani kawai yana buƙatar danna hanyar haɗin
Bayan latsa Share (Share), Excel zai nuna jerin sunayen lambobin da kuka raba fayil ɗin dasu. Idan kana son cire lamba daga lissafin ko canza izini, danna dama akan sunan wannan lambar kuma zaɓi zaɓin da ya dace daga menu na mahallin.
- Samun hanyar Rarraba (Samu mahada). Idan kuna son ba da damar yin amfani da takardar Excel ta kan layi ga mutane da yawa, to hanya mafi sauri ita ce aika musu hanyar haɗi zuwa fayil ɗin, alal misali, ta jerin imel ɗin Outlook. Zaɓi zaɓi Samun hanyar Rarraba (Get Link) a gefen hagu na taga, hanyoyi guda biyu zasu bayyana a gefen dama na taga: Duba hanyar haɗi (Haɗi zuwa Duba) da Gyara mahaɗin (Haɗi don Gyarawa). Kuna iya ƙaddamar da ɗaya ko duka biyun.
- Aika zuwa Social Networks (Buga zuwa Social Media). Sunan wannan zaɓi yana magana don kansa kuma da wuya yana buƙatar ƙarin bayani, sai dai magana ɗaya. Idan ka zaɓi wannan hanyar, ba za ka sami jerin hanyoyin sadarwar zamantakewa a cikin ɓangaren dama na taga ba. Danna mahaɗin Danna nan don haɗa hanyoyin sadarwar zamantakewa (Ƙara hanyoyin sadarwar zamantakewa) don ƙara asusunku zuwa Facebook, Twitter, Google, LinkedIn, da dai sauransu.
- Emel (Aika ta imel). Idan kuna son aika littafin aikin Excel azaman abin haɗe-haɗe (a matsayin fayil ɗin Excel na yau da kullun, PDF ko XPS) ko ta Fax Intanet, zaɓi wannan hanyar a gefen hagu na taga da zaɓin da ya dace a gefen dama.
tip: Idan kuna son iyakance yanki na littafin aikin Excel wanda sauran masu amfani ke iya gani, buɗe shafin Fillet (Fayil) sashe info (Bayani) kuma latsa Zaɓuɓɓukan Duba Mai lilo (Zaɓuɓɓukan Duba Mai Bincika). Anan zaku iya saita waɗanne zanen gado da waɗanne abubuwa masu suna za a iya nunawa akan gidan yanar gizo.
Shi ke nan! Littafin aikinku na Excel 2013 yanzu yana kan layi kuma yana samuwa ga zaɓaɓɓun masu amfani. Kuma ko da ba ku son haɗin gwiwa da kowa, wannan hanyar za ta ba ku damar shiga fayilolin Excel daga ko'ina, ko kuna cikin ofis, aiki a gida ko tafiya zuwa wani wuri.
Yi aiki tare da littattafan aiki a cikin Excel Online
Idan kun kasance masu ƙarfin gwiwa mazauna cikin sararin samaniya, to zaku iya sarrafa Excel Online cikin sauƙi yayin hutun abincin rana.
Yadda ake ƙirƙirar littafin aiki a cikin Excel Online
Don ƙirƙirar sabon littafi, danna ƙaramin kibiya kusa da maɓallin Create (Ƙirƙiri) kuma zaɓi daga jerin zaɓuka Littafin aiki na Excel (Littafin Excel).
Don sake suna littafin kan layi, danna sunan tsoho kuma shigar da sabon.
Don loda littafin aiki na yanzu zuwa Excel Online, danna Upload (Loka) akan sandar kayan aikin OneDrive kuma zaɓi fayil ɗin da ake so a adana akan kwamfutarka.
Yadda ake gyara littattafan aiki a cikin Excel Online
Bayan ka buɗe littafin aiki a cikin layi na Excel, za ka iya aiki da shi ta amfani da Excel Web App (kamar yadda ake shigar da Excel akan kwamfuta ta sirri), watau shigar da bayanai, rarrabuwa da tacewa, ƙididdigewa ta hanyar amfani da dabaru, da hango bayanai ta amfani da sigogi.
Akwai babban bambanci guda ɗaya kawai tsakanin sigar gidan yanar gizo da sigar gida ta Excel. Excel Online ba shi da maɓalli Ajiye (Ajiye) saboda yana adana littafin aiki ta atomatik. Idan kun canza tunanin ku, danna Ctrl + Zsoke aikin, kuma Ctrl + Ydon sake gyara aikin da aka soke. Don wannan dalili, zaka iya amfani da maɓallan gyara (Soke) / Redo (Dawo) tab Gida (Gida) a cikin sashin gyara (Soke).
Idan kuna ƙoƙarin gyara wasu bayanai, amma babu abin da ya faru, to tabbas littafin yana buɗewa cikin yanayin karantawa kawai. Don kunna yanayin gyarawa, danna Shirya ɗawainiya (Edit Littafi) > Shirya a cikin Excel Web App (Shirya a cikin layi na Excel) kuma yi saurin canje-canje daidai a cikin burauzar gidan yanar gizon ku. Don samun damar ƙarin abubuwan binciken bayanai na ci gaba kamar PivotTables, Sparklines, ko don haɗi zuwa tushen bayanan waje, danna. Gyara a cikin Excel (Buɗe a cikin Excel) don canzawa zuwa Microsoft Excel akan kwamfutarka.
Lokacin da ka ajiye takarda a cikin Excel, za a adana ta inda ka ƙirƙiri ta asali, wato a cikin ma'ajiyar girgije ta OneDrive.
tip: Idan kuna son yin canje-canje cikin sauri zuwa littattafai da yawa, to hanya mafi kyau ita ce buɗe jerin fayiloli a cikin OneDrive ɗinku, nemo littafin da kuke buƙata, danna-dama akansa kuma zaɓi aikin da ake so daga menu na mahallin.
Don raba takardar aikinku a cikin Excel Online, danna Share (Shared) > Raba da Mutane (Share)…
… sannan zaɓi ɗayan zaɓuɓɓukan:
- Gayyato Mutane (Aika hanyar haɗi) - kuma shigar da adireshin imel na mutanen da kuke son raba littafin tare da su.
- Samo hanyar haɗi (Sami hanyar haɗi) - kuma haɗa wannan hanyar haɗin zuwa imel, saka shi akan gidan yanar gizo ko a shafukan sada zumunta.
Hakanan zaka iya saita haƙƙin samun dama ga lambobin sadarwa: haƙƙin gani kawai ko ba da izini don shirya takaddar.
Lokacin da mutane da yawa ke gyara takardar aiki a lokaci guda, Excel Online nan da nan yana nuna kasancewarsu da sabuntawa da aka yi, muddin kowa yana gyara takaddar a cikin Excel Online kuma ba a cikin Excel na gida akan kwamfutar ba. Idan ka latsa ƙaramin kibiya kusa da sunan mutumin a kusurwar dama ta dama na takardar Excel, za ka iya ganin ainihin tantanin halitta wanda mutumin yake gyarawa a halin yanzu.
Idan kuna raba takaddun aikin kan layi tare da ƙungiyar ku, kuna iya ba su izini don gyara wasu sel, layuka, ko ginshiƙai kawai a cikin takaddar Excel. Don yin wannan, a cikin Excel akan kwamfutar gida, kuna buƙatar zaɓar kewayon (s) waɗanda kuke ba da izinin gyarawa, sannan ku kare takaddun aiki.
- Zaɓi kewayon sel waɗanda masu amfani da ku za su iya gyarawa, buɗe shafin review (Bita) kuma a cikin sashe canje-canje (canje-canje) danna Bada Masu Amfani Su Shirya Yanayi (Ba da izinin canza jeri).
- A cikin akwatin maganganu Bada Masu Amfani Su Shirya Yanayi (Ba da izinin canza jeri) danna maɓallin New (Ƙirƙiri), tabbatar da kewayon daidai kuma danna Takardar Kariya (Takarda Kare). Idan kana son ƙyale masu amfani da ku don gyara jeri da yawa, sannan danna maɓallin sake. New (ƙirƙira).
- Shigar da kalmar wucewa sau biyu kuma loda amintaccen takardar zuwa OneDrive.
Don ƙarin bayani game da wannan, da fatan za a karanta labarin Kulle da buɗe takamaiman wuraren takardar da aka karewa.
Yadda ake shigar da takardar Excel a cikin Yanar Gizo ko Blog
Idan kuna son buga littafin aikinku na Excel zuwa gidan yanar gizo ko blog, bi waɗannan matakai masu sauƙi guda 3 a cikin Gidan Yanar Gizo na Excel:
- Bude littafin aiki a cikin Excel Online, danna Share (Shared) > Embed (embed), sannan danna maballin Generate (ƙirƙira).
- A mataki na gaba, za ku ayyana daidai yadda takardar zata kasance akan gidan yanar gizo. Akwai zaɓuɓɓuka masu zuwa a gare ku:
- Abin da za a nuna (Abin da ya kamata a nuna). A cikin wannan sashe, zaku iya tantance ko kuna son shigar da littafin gabaɗayan aikin ko kuma wani ɓangarensa kawai, kamar kewayon sel, tebur pivot, da sauransu.
- Appearance (Bayyana). Anan zaka iya siffanta bayyanar littafin (nuna ko ɓoye layin grid, shafi da kanun layi, haɗa da hanyar zazzagewa).
- hulda (Mu'amala). Ba da izini ko kar a ƙyale masu amfani su yi hulɗa tare da tebur ɗin ku - rarraba, tace kuma shigar da bayanai cikin sel. Idan kun ƙyale shigarwar bayanai, to, canje-canjen da wasu mutane suka yi a cikin sel akan Intanet ba za a adana su a cikin ainihin littafin aiki ba. Idan kana son a buɗe takamaiman tantanin halitta lokacin buɗe shafin yanar gizon, duba akwatin Koyaushe farawa da wannan tantanin halitta da aka zaɓa (Koyaushe farawa daga wannan tantanin halitta) kuma danna tantanin halitta da ake so a yankin Preview (Preview), wanda ke gefen dama na akwatin maganganu.
- girma (Mai girma). Shigar nan faɗi da tsayin taga tebur a cikin pixels. Don ganin ainihin girman taga, danna Duba girman girman gaske (ainihin girman girman gani) sama da taga Preview (Sambanta). Ka tuna cewa zaka iya saita girman ya zama aƙalla 200 x 100 pixels kuma aƙalla 640 x 655 pixels. Idan kana buƙatar samun girman daban-daban wanda ya wuce waɗannan iyakoki, to daga baya za ku iya canza lambar a kowane editan HTML, kai tsaye a kan rukunin yanar gizonku ko blog.
- Duk abin da za ku yi shi ne danna Copy (Kwafi) a ƙasa sashe Lambar shiga ( code embed) kuma liƙa lambar HTML (ko JavaScript) a cikin bulogi ko gidan yanar gizonku.
lura: Lambar da aka saka ita ce iframe, don haka tabbatar da cewa rukunin yanar gizonku yana goyan bayan wannan alamar kuma shafin yanar gizon ku yana ba da damar yin amfani da shi a cikin posts.
Appeded Excel Web App
Abin da kuke gani a ƙasa takardar Excel ce mai mu'amala wacce ke nuna dabarar da aka bayyana a aikace. Wannan tebur yana ƙididdige adadin kwanaki nawa suka rage har zuwa ranar haihuwar ku na gaba, ranar tunawa, ko wani taron daban, kuma yana canza rata a cikin inuwar kore, rawaya, da ja. A cikin aikace-aikacen Yanar Gizo na Excel, kawai kuna buƙatar shigar da abubuwan da suka faru a shafi na farko, sannan gwada canza ranakun da suka dace kuma ku ga sakamakon.
Idan kuna sha'awar tsarin da aka yi amfani da shi anan, da fatan za a duba labarin Yadda ake saita tsarin kwanan wata a cikin Excel.
Bayanan Fassara: A wasu masu bincike, wannan iframe bazai iya nunawa daidai ko a'a ba.
Mashups a cikin Excel Web App
Idan kana son ƙirƙirar kusanci tsakanin takaddun gidan yanar gizon ku na Excel da sauran aikace-aikacen yanar gizo ko ayyuka, zaku iya amfani da JavaScript API ɗin da ke kan OneDrive don ƙirƙirar mashups masu hulɗa daga bayananku.
A ƙasa zaku iya ganin mashup ɗin Destination Explorer wanda ƙungiyar Excel Web App ta ƙirƙira a matsayin misalin abin da masu haɓakawa za su iya ƙirƙira don gidan yanar gizonku ko bulogi. Wannan mashup yana amfani da JavaScript na Sabis na Excel da APIs Taswirorin Bing don taimakawa masu ziyara a rukunin yanar gizo su zaɓi hanyar tafiya. Kuna iya zaɓar wuri akan taswira kuma mashup ɗin zai nuna muku yanayin a wannan wurin ko yawan masu yawon bude ido da ke ziyartar wuraren. Hoton da ke ƙasa yana nuna wurinmu 🙂
Kamar yadda kake gani, aiki a cikin Excel Online abu ne mai sauƙi. Yanzu da muka rufe abubuwan yau da kullun, zaku iya ci gaba da bincika fasalinsa kuma kuyi aiki tare da zanen gadonku cikin sauƙi da ƙarfin gwiwa!