Sithumela amashidi e-Excel ku-inthanethi, sabelane ngawo, siwanamathisele ekhasini lewebhu futhi siwenze asebenzisane

Kwesinye sezindatshana, sifunde amasu okuguqula amashidi e-Excel abe yi-HTML. Namuhla kubonakala sengathi wonke umuntu uthuthela kwisitoreji samafu, ngakho kungani siba sibi kakhulu? Ubuchwepheshe obusha bokwabelana ngedatha ye-Excel nge-inthanethi buyindlela elula, enezici eziningi nezinzuzo ongazisebenzisa.

Ngokufika kwe-Excel Online, awusayidingi ikhodi ye-HTML enzima ukuze uthumele amaspredishithi kuwebhu. Vele ulondoloze ibhuku lakho lokusebenza ku-inthanethi futhi ulifinyelele noma yikuphi, wabelane ngalo nabanye, futhi nisebenze ndawonye kusipredishithi esifanayo. Usebenzisa i-Excel Online, ungakwazi ukushumeka ishidi le-Excel kuwebhusayithi noma ibhulogi futhi uvumele izivakashi ukuthi zihlanganyele nalo ukuze zithole ulwazi oluqondile ezifuna ukulithola.

Kamuva kulesi sihloko, sizobheka lezi nezinye izici eziningi ezihlinzekwa yi-Excel Online.

• Ilayisha Izincwadi Zokusebenzela ze-Excel 2013 (Ezasendaweni) ku-inthanethi
• Dala amashidi aku-inthanethi ku-Excel Online
• Ungahlela kanjani izincwadi zokusebenza ku-Excel Online
• Ukwabelana ngamashidi okusebenzela e-Excel aku-inthanethi
• Ungakuvimba kanjani ukuhlelwa kwamaseli ayintandokazi kumashidi e-excel okwabelwana ngawo
• Ishumeka i-Excel Web App kuwebhusayithi noma kubhulogi
• I-Excel Web App Mashups

Ungawathumela kanjani amaSpredishithi e-Excel 2013 kuwebhu

Uma usanda kuqalisa ngezinsizakalo zamafu ngokuvamile kanye ne-Excel Online ikakhulukazi, isiqalo esilula kungaba ukwabelana ngencwadi yokusebenzela ekhona usebenzisa isixhumi esibonakalayo se-Excel 2013 kukhompyutha yakho.

Wonke amashidi e-Excel Online agcinwe kusevisi yewebhu ye-OneDrive (phambilini eyayaziwa ngokuthi i-SkyDrive). Njengoba kungenzeka uyazi, lesi sitoreji esiku-inthanethi sesinesikhathi eside sikhona futhi manje sesihlanganiswe ne-Microsoft Excel njengomyalo wokuchofoza okukodwa. Ngaphezu kwalokho, izivakashi, okungukuthi abanye abasebenzisi owabelana nabo ngamaspredishithi akho abasadingi i-akhawunti yabo ye-Microsoft ukuze babuke futhi bahlele amafayela e-Excel owabelana nabo.

Uma ungakabi nayo i-akhawunti ye-OneDrive, ungayidala khona manje. Le sevisi ilula, imahhala futhi kufanele nakanjani uyinake njengoba iningi lezinhlelo zokusebenza ze-Microsoft Office 2013 suite (hhayi i-Excel kuphela) zisekela i-OneDrive. Ngemva kokubhalisa, landela lezi zinyathelo:

1. Ngena ngemvume ku-akhawunti yakho ye-Microsoft

Qiniseka ukuthi ungene ngemvume ku-akhawunti yakho ye-Microsoft kusuka ku-Excel 2013. Vula incwadi yakho yokusebenzela ye-Excel bese ubheka ekhoneni eliphezulu kwesokudla. Uma ubona igama lakho nesithombe lapho, qhubekela esinyathelweni esilandelayo, ngaphandle kwalokho chofoza Ngena ngemvume (Okokufaka).

I-Excel izoveza iwindi likucela ukuthi uqinisekise ukuthi ngempela ufuna ukuvumela i-Office ukuthi ixhume ku-inthanethi. Chofoza Yebo (Yebo) bese ufaka imininingwane ye-akhawunti yakho ye-Windows Live.

2. Londoloza ishidi lakho le-excel efwini

Qiniseka, ukuze ube nokuthula kwengqondo, ukuthi ibhuku lomsebenzi olifunayo livuliwe, okungukuthi, leyo kanye ofuna ukwabelana ngayo nabanye ku-inthanethi. Ngifuna ukwabelana ngencwadi Uhlu Lwezipho Zeholideukuze amalungu omndeni wami nabangane bami bakwazi ukuyibuka futhi basize 🙂

Uma ibhuku lokusebenza livuliwe, hamba kuthebhu Ifilimu (Ifayela) bese uchofoza Ungahlukıselana (Ukwabelana) ohlangothini lwesobunxele lwewindi. Inketho ezenzakalelayo izoba Mema Abantu (Mema abanye abantu), bese udinga ukuchofoza Londoloza Kumafu (Londoloza Kumafu) ngakwesokudla kwewindi.

Ngemuva kwalokho, khetha indawo ozogcina kuyo ifayela le-Excel. I-OneDrive isohlwini lokuqala kwesokunxele futhi ikhethwa ngokuzenzakalelayo. Kufanele nje ucacise ifolda ukuze ugcine ifayela engxenyeni efanele yewindi.

Qaphela: Uma ungayiboni into yemenyu ye-OneDrive, kusho ukuthi awunayo i-akhawunti ye-OneDrive, noma awungenanga ngemvume ku-akhawunti yakho.

Sengiyakhile kakade ifolda ekhethekile Umhleli Wesipho, futhi iboniswa ohlwini lwamafolda akamuva. Ungakhetha noma iyiphi enye ifolda ngokuchofoza inkinobho IMIKHAKHA (Ukubuka konke) ngezansi kwendawo Amafolda Akamuva (Amafolda akamuva), noma dala ifolda entsha ngokuchofoza kwesokudla nokukhetha kumenyu yokuqukethwe New (Yakha) > Ifolda (ifolda). Lapho ifolda oyifunayo isikhethiwe, chofoza Londoloza (Gcina).

3. Ukwabelana Ngeshidi le-Excel Elilondolozwe Kuwebhu

Incwadi yakho yokusebenzela ye-Excel isivele iku-inthanethi futhi ungayibuka ku-OneDrive yakho. Uma udinga ukwabelana ngamashidi e-Excel agcinwe ku-inthanethi, kuzomele uthathe isinyathelo esisodwa - khetha enye yezindlela ezinikezwa yi-Excel 2013 yokwabelana:

• Mema Abantu (Mema abanye abantu). Le nketho ikhethwa ngokuzenzakalelayo. Vele ufake ikheli le-imeyili loxhumana nabo ofuna ukwabelana nabo nge-Excel sheet. Uma uqala ukuyibhala, ukuqedela ngokuzenzakalela kwe-Excel kuzoqhathanisa idatha oyifakile namagama namakheli encwadini yakho yamakheli futhi ikubonise uhlu lwezinketho ezifanayo ongakhetha kuzo. Uma ufuna ukwengeza oxhumana nabo abaningi, bafake behlukaniswe ama-semicolon. Ngaphezu kwalokho, ungasebenzisa ukusesha oxhumana nabo encwadini yamakheli, ukwenza lokhu, chofoza isithonjana Sesha Incwadi Yekheli (Sesha encwadini yamakheli). Ungasetha amalungelo okufinyelela okubuka noma ukuhlela ngokukhetha inketho efanelekile ohlwini lokudonsela phansi olungakwesokudla. Uma ucacisa abathintwayo abaningi, izimvume zizosethwa ukuze zifane kuwo wonke umuntu, kodwa kamuva ungakwazi ukushintsha izimvume zomuntu ngamunye. Ungengeza futhi umyalezo womuntu siqu kusimemo. Uma ungafaki lutho, i-Excel izokwengeza umyalo ojwayelekile.

  Okokugcina, udinga ukukhetha ukuthi umsebenzisi kufanele yini angene ku-akhawunti yakhe ye-Windows Live ukuze afinyelele ishidi lakho le-Excel eliku-inthanethi. Angisiboni isizathu esithile sokubaphoqa ukuthi benze lokhu, kodwa kukuwe.

  Uma konke sekumi ngomumo, cindezela inkinobho Ungahlukıselana (Ukufinyelela okuvamile). Omenyiwe ngamunye uzothola i-imeyili equkethe isixhumanisi sefayela owabelane ngalo. Ukuze uvule ishidi lakho le-Excel ku-inthanethi, umsebenzisi udinga nje ukuchofoza isixhumanisi

  

  Ngemuva kokucindezela Ungahlukıselana (Yabelana), i-Excel izobonisa uhlu loxhumana nabo owabelane nabo ngefayela. Uma ufuna ukususa othintana naye ohlwini noma ukushintsha izimvume, chofoza kwesokudla egameni lalo oxhumana naye bese ukhetha inketho efanelekile kumenyu yokuqukethwe.

  

• Thola Isixhumanisi Sokwabelana (Thola isixhumanisi). Uma ufuna ukunikeza ukufinyelela kweshidi le-Excel eliku-inthanethi kubantu abaningi, khona-ke indlela esheshayo iwukubathumela isixhumanisi sefayela, isibonelo, ngohlu lokuposa lwe-Outlook. Khetha inketho Thola Isixhumanisi Sokwabelana (Thola Isixhumanisi) ohlangothini lwesobunxele lwewindi, izixhumanisi ezimbili zizovela ngakwesokudla kwewindi: Bheka Isixhumanisi (Isixhumanisi Sokubuka) kanye Hlela Isixhumanisi (Isixhumanisi Sokuhlela). Ungahambisa eyodwa noma zombili.
• Thumela kumaSocial Networks (Thumela ku-Social Media). Igama lale nketho liyazikhulumela futhi alidingi izincazelo ezengeziwe, ngaphandle kokuphawula okukodwa. Uma ukhetha le ndlela, ngeke uthole uhlu lwamanethiwekhi omphakathi atholakalayo engxenyeni efanele yewindi. Chofoza isixhumanisi Chofoza lapha ukuze uxhume amanethiwekhi omphakathi (Engeza amanethiwekhi omphakathi) ukuze ungeze ama-akhawunti akho ku-Facebook, Twitter, Google, LinkedIn, njll.
• imeyili (Thumela nge-imeyili). Uma ufuna ukuthumela incwadi yokusebenzela ye-Excel njengesinamathiseli (njengefayela le-Excel elivamile, i-PDF noma i-XPS) noma nge-Internet Fax, khetha le ndlela ohlangothini lwesobunxele lwefasitela kanye nenketho efanele ngakwesokudla.

Ithiphu: Uma ufuna ukukhawulela indawo yebhuku le-Excel elibukwa abanye abasebenzisi, vula kuthebhu Ifilimu (Ifayela) isigaba Info (Imininingwane) bese ucindezela Izinketho Zokubuka Isiphequluli (Izinketho Zokubuka Isiphequluli). Lapha ungamisa ukuthi imaphi amashidi nokuthi yiziphi izici eziqanjwe igama ezingaboniswa kuwebhu.

Yilokho kuphela! Incwadi yakho yokusebenza ye-Excel 2013 manje isiku-inthanethi futhi iyatholakala kubasebenzisi abakhethiwe. Futhi ngisho noma ungathandi ukubambisana nanoma ubani, le ndlela izokuvumela ukuthi ufinyelele amafayela e-Excel noma yikuphi, kungakhathaliseki ukuthi usehhovisi, usebenza ekhaya noma uhamba endaweni ethile.

Sebenza ngezincwadi zokusebenza ku-Excel Online

Uma uyisakhamuzi esizethembayo se-Cloud Universe, ungakwazi kalula ukwazi i-Excel Online ngesikhathi sakho sekhefu lasemini.

Ungayakha kanjani incwadi yokusebenzela ku-Excel Online

Ukuze udale ibhuku elisha, chofoza umcibisholo omncane eduze kwenkinobho Dala (Dala) bese ukhetha ohlwini lokudonsela phansi Ibhuku lokusebenzela le-Excel (Incwadi ye-Excel).

Ukuze uqambe kabusha ibhuku lakho eliku-inthanethi, chofoza igama elimisiwe bese ufaka elisha.

Ukulayisha incwadi yokusebenza ekhona ku-Excel Online, chofoza Layisha (Layisha) kubha yamathuluzi ye-OneDrive bese ukhetha ifayela olifunayo elondolozwe kukhompuyutha yakho.

Ungahlela kanjani izincwadi zokusebenza ku-Excel Online

Ngemva kokuvula incwadi yokusebenzela ku-Excel Online, ungakwazi ukusebenza nayo usebenzisa i-Excel Web App (njenge-Excel efakwe kukhompuyutha yomuntu siqu), okungukuthi faka idatha, hlunga bese uhlunga, bala usebenzisa amafomula, futhi ubone ngeso lengqondo idatha usebenzisa amashadi.

Kunomehluko owodwa kuphela obalulekile phakathi kwenguqulo yewebhu kanye nenguqulo yendawo ye-Excel. I-Excel Online ayinayo inkinobho Londoloza (Gcina) ngoba igcina incwadi yokusebenzela ngokuzenzakalelayo. Uma ushintsha umqondo wakho, chofoza I-Ctrl + Zukukhansela isenzo, futhi Ctrl + Yukwenza kabusha isenzo esingahlehlisiwe. Ngenhloso efanayo, ungasebenzisa izinkinobho ukuhlehlisa (Khansela) / Yenza futhi (Buyisa) ithebhu Ikhaya (Ekhaya) esigabeni ukuhlehlisa (Khansela).

Uma uzama ukuhlela idatha ethile, kodwa akwenzeki lutho, lapho-ke cishe incwadi ivulwa ngemodi yokufunda kuphela. Ukuze unike amandla imodi yokuhlela, chofoza Hlela ibhuku lokusebenzela (Hlela Incwadi) > Hlela ku-Excel Web App (Hlela ku-Excel Online) futhi wenze izinguquko ezisheshayo khona kanye esipheqululini sakho sewebhu. Ukuze ufinyelele izici zokuhlaziya idatha ezithuthuke kakhulu njengePivotTables, Sparklines, noma ukuxhuma kumthombo wedatha wangaphandle, chofoza Hlela ku-Excel (Vula ku-Excel) ukuze ushintshele ku-Microsoft Excel kukhompyutha yakho.

Uma ulondoloza ishidi ku-Excel, lizogcinwa lapho owalidala khona ekuqaleni, okungukuthi, kusitoreji samafu se-OneDrive.

Ithiphu: Uma ufuna ukwenza izinguquko ezisheshayo ezincwadini ezimbalwa, khona-ke indlela engcono kakhulu iwukuba uvule uhlu lwamafayela ku-OneDrive yakho, uthole incwadi oyidingayo, uchofoze kwesokudla kuyo bese ukhetha isenzo osifunayo kumenyu yokuqukethwe.

Ungabelana kanjani ngephepha lokusebenza nabanye abasebenzisi ku-Excel Online

Ukuze wabelane ngeshidi lakho lomsebenzi ku-Excel Online, chofoza Ungahlukıselana (Kwabiwe) > Yabelana Nabantu (Yabelana)…

… bese ukhetha okukodwa kokukhethwa kukho:

• Mema Abantu (Thumela isixhumanisi sokufinyelela) - bese ufaka ikheli le-imeyili labantu ofuna ukwabelana nabo ngencwadi.
• Thola isixhumanisi (Thola isixhumanisi) - futhi unamathisele lesi sixhumanisi ku-imeyili, uyithumele kuwebhusayithi noma ezinkundleni zokuxhumana.

Ungakwazi futhi ukusetha amalungelo okufinyelela koxhumana nabo: ilungelo lokubuka kuphela noma ukunikeza imvume yokuhlela idokhumenti.

Lapho abantu abaningi behlela ishidi lokusebenzela ngesikhathi esisodwa, i-Excel Online ikhombisa ngokushesha ubukhona babo nezibuyekezo ezenziwe, inqobo nje uma wonke umuntu ehlela idokhumenti nge-Excel Online hhayi ku-Excel yendawo kukhompuyutha. Uma uchofoza umcibisholo omncane eduze kwegama lomuntu ekhoneni eliphezulu kwesokudla seshidi le-Excel, ungabona kahle ukuthi yiliphi iseli lowo muntu alihlelayo njengamanje.

Ungakuvimba kanjani ukuhlelwa kwamaseli athile eshidini elabelwe

Uma wabelana ngamashidi okusebenza aku-inthanethi nethimba lakho, ungase uthande ukubanika imvume yokuhlela amaseli athile kuphela, imigqa, noma amakholomu kudokhumenti yakho ye-Excel. Ukuze wenze lokhu, ku-Excel kukhompuyutha yendawo, udinga ukukhetha ububanzi (ama) ovumela ukuhlela, bese uvikela ishidi lokusebenza.

1. Khetha ibanga lamaseli abasebenzisi bakho abangawahlela, vula ithebhu Buyekeza (Buyekeza) futhi esigabeni Izinguquko (Izinguquko) chofoza Vumela abasebenzisi ukuhlela amabanga (Vumela ukushintsha ububanzi).
2. Ebhokisini lengxoxo Vumela abasebenzisi ukuhlela amabanga (Vumela ukushintsha ububanzi) chofoza inkinobho New (Dala), qiniseka ukuthi ububanzi bulungile bese uchofoza Vikela Ishidi (Vikela ishidi). Uma ufuna ukuvumela abasebenzisi bakho ukuthi bahlele ububanzi obuningi, bese uchofoza inkinobho futhi. New (Yakha).
3. Faka iphasiwedi yakho kabili bese ulayisha ishidi elivikelekile ku-OneDrive.

Ukuze uthole ulwazi olwengeziwe mayelana nalokhu, sicela ufunde isihloko esithi Ukukhiya nokuvula izindawo ezithile zeshidi elivikelwe.

Ungashumeka Kanjani Ishidi le-Excel Kuwebhusayithi noma Ibhulogi

Uma ufuna ukushicilela incwadi yakho yokusebenza ye-Excel kuwebhusayithi noma ibhulogi, landela lezi zinyathelo ezi-3 ezilula ku-Excel Web App:

1. Vula ibhuku lokusebenza ku-Excel Online, chofoza Ungahlukıselana (Kwabiwe) > Shumeka (shumeka), bese uchofoza inkinobho Qalisa (Yakha).
2. Esinyathelweni esilandelayo, uchaza kahle ukuthi ishidi kufanele libukeke kanjani kuwebhu. Izinketho ezilandelayo ziyatholakala kuwe:
   • Okufanele sikubonise (Yini okufanele iboniswe). Kulesi sigaba, ungacacisa ukuthi uyafuna yini ukushumeka incwadi yokusebenzela yonke noma ingxenye yayo nje, njengohlu lwamaseli, ithebula le-pivot, nokunye.
   • ukubukeka (Ukubukeka). Lapha ungenza ngendlela oyifisayo ukubukeka kwencwadi (bonisa noma ufihle imigqa yegridi, ikholomu nezihloko zomugqa, faka isixhumanisi sokulanda).
   • Ukuxhumana (Ukusebenzelana). Vumela noma ungavumeli abasebenzisi ukuthi bahlanganyele netafula lakho - hlunga, hlunga futhi ufake idatha kumaseli. Uma uvumela ukufakwa kwedatha, izinguquko ezenziwe ngabanye abantu kumaseli aku-inthanethi ngeke zigcinwe ebhukwini lokusebenza lasekuqaleni. Uma ufuna ukuthi iseli elithile livulwe lapho uvula ikhasi lewebhu, maka ibhokisi Njalo qala ngale seli ekhethiwe (Njalo qala kule seli) bese uchofoza iseli oyifunayo endaweni Buka kuqala (Ukubuka kuqala), etholakala kwesokudla sebhokisi lengxoxo.
   • Ubukhulu (Ubukhulu). Faka lapha ububanzi nobude bewindi letafula ngamaphikseli. Ukuze ubone ubukhulu bangempela bewindi, chofoza Buka usayizi wangempela (usayizi wokubuka wangempela) ngaphezu kwewindi Buka kuqala (Buka kuqala). Khumbula ukuthi ungasetha usayizi ukuthi okungenani ube amaphikiseli angu-200 x 100 futhi okungenani abe ngamaphikiseli angu-640 x 655. Uma udinga ukuthola usayizi ohlukile oweqa le mikhawulo, ngemva kwalokho ungakwazi ukushintsha ikhodi kunoma yimuphi umhleli we-HTML, ngokuqondile kusayithi lakho noma kubhulogi.
3. Okufanele ukwenze ukuchofoza Kopisha (Kopisha) ngezansi kwesigaba Shumeka ikhodi (shumeka ikhodi) bese unamathisela ikhodi ye-HTML (noma i-JavaScript) kubhulogi noma iwebhusayithi yakho.

Qaphela: Ikhodi eshumekiwe iyi-iframe, ngakho qiniseka ukuthi isayithi lakho liyayisekela le thegi futhi ibhulogi yakho iyayivumela ukuthi isetshenziswe kokuthunyelwe.

Uhlelo lokusebenza lwewebhu olushumekiwe lwe-Excel

Okubona ngezansi ishidi le-Excel elisebenzisanayo elibonisa indlela echaziwe esebenza. Leli thebula libala ukuthi zingaki izinsuku ezisele ngaphambi kosuku lwakho lokuzalwa olulandelayo, usuku lwakho lokuzalwa, noma omunye umcimbi, futhi lifaka imibala izikhala ngemibala ehlukahlukene eluhlaza, ophuzi, nokubomvu. Ku-Excel Web App, udinga nje ukufaka imicimbi yakho kukholamu yokuqala, bese uzama ukushintsha izinsuku ezihambisanayo futhi ubone imiphumela.

Uma ufuna ukwazi ngefomula esetshenziswe lapha, sicela ubheke isihloko Ungasetha kanjani ukufometha kwedethi enemibandela ku-Excel.

Inothi Lomhumushi: Kwezinye iziphequluli, le iframe ingase ingabonisi kahle noma ingabonakali nhlobo.

I-Mashups ku-Excel Web App

Uma ufuna ukwakha ukusebenzelana okuseduze phakathi kwamashidi akho ewebhu e-Excel nezinye izinhlelo zokusebenza zewebhu noma amasevisi, ungasebenzisa i-JavaScript API etholakala ku-OneDrive ukuze udale ama-mashups asebenzisanayo kusuka kudatha yakho.

Ngezansi ungabona i-Destination Explorer mashup edalwe ithimba le-Excel Web App njengesibonelo salokho onjiniyela abangakudalela iwebhusayithi yakho noma ibhulogi. Le mashup isebenzisa i-Excel Services JavaScript kanye ne-Bing Maps APIs ukuze isize izivakashi zesayithi zikhethe umzila wokuhamba. Ungakhetha indawo kumephu futhi i-mashup izokukhombisa isimo sezulu kuleyo ndawo noma inombolo yezivakashi ezivakashela lezo zindawo. Isithombe-skrini esingezansi sibonisa indawo yethu 🙂

Njengoba ubona, ukusebenza ku-Excel Online kulula kakhulu. Manje njengoba sesihlanganise okuyisisekelo, ungaqhubeka uhlola izici zayo futhi usebenze ngamashidi akho kalula nangokuzethemba!