Mukati
- Maitiro ekutumira Excel 2013 Sheets kuWebhu
- Shanda nemabhuku ebasa muExcel Online
- Maitiro ekugadzira bhuku rebasa muExcel Online
- Maitiro ekugadzirisa mabhuku ebasa muExcel Online
- Maitiro ekugovera pepa rekushanda nevamwe vashandisi muExcel Online
- Maitiro ekuvharisa kugadzirisa kwemamwe maseru papepa rakagovaniswa
- Maitiro ekuisa Excel Sheet muWebhusaiti kana Blog
- Mashups muExcel Web App
Mune chimwe chezvinyorwa, takadzidza maitiro ekushandura Excel sheets kuita HTML. Nhasi zvinoita sekunge munhu wese ari kutamira kukuchengetedza gore, saka nei isu tanyanya? Tekinoroji nyowani dzekugovana data reExcel paInternet inzira iri nyore, ine akawanda maficha uye mabhenefiti aunogona kushandisa.
Nekuuya kweExcel Online, iwe hauchada inorema HTML kodhi kutumira maspredishiti pawebhu. Ingo chengetedza bhuku rako rebasa pamhepo woriwana kubva chero kupi zvako, rigovane nevamwe, uye shandai mose paspredishiti rimwe chete. Uchishandisa Excel Online, unogona kumisa pepa reExcel muwebhusaiti kana bhurogi uye wobvumira vashanyi kuti vabatane naro kuti vawane chaizvo ruzivo rwavanoda kuwana.
Gare gare muchinyorwa chino, isu tichatarisa izvi nezvimwe zvakawanda zvimwe zvinhu zvinopihwa neExcel Online.
Maitiro ekutumira Excel 2013 Sheets kuWebhu
Kana iwe uchangotanga nemasevhisi emakore kazhinji uye Excel Online kunyanya, saka kutanga kuri nyore kungave kugovera bhuku rebasa riripo uchishandisa yakajairika Excel 2013 interface pakombuta yako.
Ese Excel Online mapepa anochengetwa muOneDrive (yaimbonzi SkyDrive) web service. Sezvaungangoziva iwe, iyi yekuchengetera yepamhepo yave iripo kwechinguva ikozvino uye yave kusanganiswa muMicrosoft Excel seyo yekudzvanya-imwe interface yekuraira. Pamusoro pezvo, vaenzi, kureva vamwe vashandisi vaunogovera maspredishiti ako havachadi yavo Microsoft account kuti vaone uye vagadzirise mafaera eExcel aunogovana navo.
Kana iwe usati uine OneDrive account, unogona kugadzira imwe izvozvi. Iyi sevhisi yakapfava, yemahara uye yakanyatsokodzera kutariswa kwako sezvo mazhinji ekushandisa eMicrosoft Office 2013 suite (kwete chete Excel) anotsigira OneDrive. Mushure mekunyoresa, tevera matanho aya:
1. Pinda muakaundi yako yeMicrosoft
Ita shuwa kuti wasaina kuakaundi yako yeMicrosoft kubva kuExcel 2013. Vhura bhuku rako rekushanda reExcel uye tarisa mukona yepamusoro kurudyi. Kana iwe ukaona zita rako nemufananidzo ipapo, woenderera kune rinotevera nhanho, zvimwe tinya Nyorera mu (Input).
Excel icharatidza hwindo richikukumbira kuti usimbise kuti unoda chaizvo kubvumira Hofisi kubatana neInternet. Dzvanya Ehe (Hongu) uye wobva waisa yako Windows Live account account.
2. Chengetedza pepa rako reExcel kune gore
Ita shuwa, kuti iwe pachako uve nerunyararo rwepfungwa, kuti bhuku rebasa raunoda rakavhurika, ndiko kuti, iro chairo raunoda kugovera paInternet. Ndinoda kugovera bhuku Holiday Gift Listkuitira kuti nhengo dzemhuri yangu neshamwari dzangu vazvione uye vabatsire 🙂
Nebhuku rebasa rakavhurwa, enda kune tab Fillet (Faira) uye tinya mugove (Kugovana) kuruboshwe rwehwindo. Iyo yakasarudzika sarudzo ichave Koka Vanhu (Koka vamwe vanhu), ipapo unofanira kudzvanya Sevha Ku Cloud (Sevha kuCloud) kurudyi rwehwindo.
Mushure meizvozvo, sarudza nzvimbo yekuchengetedza iyo Excel faira. OneDrive yakanyorwa kutanga kuruboshwe uye inosarudzwa nekusingaperi. Iwe unongofanirwa kutsanangura iyo folda kuchengetedza faira muchikamu chekurudyi chehwindo.
Cherechedza: Kana iwe usingaone chinhu chemenu yeOneDrive, saka hauna account yeOneDrive, kana kuti hauna kusaina kuaccount yako.
Ndakatogadzira folda yakakosha Gift Planner, uye inoratidzwa mune ichangoburwa mafolda runyorwa. Unogona kusarudza chero imwe folda nekudzvanya bhatani CATEGORIES (Ongororo) pazasi nzvimbo Recent Folders (Maforodha achangoburwa), kana gadzira dhairekitori nyowani nekudzvanya-kurudyi uye kusarudza kubva pane yemukati menyu New (Gadzira) > forodha (folder). Kana iyo folda yaunoda yasarudzwa, tinya Save (Chengeta).
3. Kugovera Excel Sheet Rakachengetedzwa paWebhu
Bhuku rako rekushanda reExcel ratova online uye unogona kuriona muOneDrive yako. Kana iwe uchida kugovera Excel mapepa akachengetwa paInternet, saka iwe unongofanirwa kutora nhanho imwe - sarudza imwe yenzira dzinopihwa neExcel 2013 yekugovera:
- Koka Vanhu (Koka vamwe vanhu). Iyi sarudzo inosarudzwa neyakagadzika. Ingoisa iyo email kero yevanobata (s) vaunoda kugovera iyo Excel sheet naye. Paunotanga kuinyora, iyo Excel's autocomplete inofananidza iyo data yawakaisa nemazita nekero mubhuku rako rekero uye inokuratidza rondedzero yezvinoenderana sarudzo dzekusarudza kubva. Kana iwe uchida kuwedzera akawanda mazita, isa iwo akaparadzaniswa nesemicolon. Mukuwedzera, iwe unogona kushandisa kutsvaga kwevanobatika mubhuku rekero, kuti uite izvi, tinya chiratidzo Tsvaga Kero Book (Tsvaga mubhuku rekero). Iwe unogona kuseta kodzero dzekuwana dzekutarisa kana kugadzirisa nekusarudza iyo yakakodzera sarudzo kubva pane yekudonha-pasi runyorwa kurudyi. Kana iwe ukatsanangura akawanda maitirwo, ipapo mvumo ichaiswa kune imwechete kune wese munhu, asi gare gare unogona kushandura mvumo kumunhu wega wega. Iwe unogona zvakare kuwedzera meseji yako pakukoka. Kana iwe usingaise chero chinhu, Excel ichawedzera iyo general kukurumidza iwe.
Chekupedzisira, iwe unofanirwa kusarudza kana mushandisi achifanira kupinda muWindows Live account kuti awane yako yepamhepo Excel sheet. Ini handioni chimwe chikonzero chekuvamanikidza kuita izvi, asi zviri kwauri.
Kana zvese zvagadzirwa, tinya bhatani mugove (General access). Mumwe nemumwe anokokwa achagashira email ine chinongedzo chefaira rawagovera. Kuti uvhure pepa rako reExcel online, mushandisi anongoda kudzvanya pane chinongedzo
Mushure mekutsikirira iyo mugove (Goverana), Excel icharatidza runyoro rwemazita awakagovana nawo faira. Kana iwe uchida kubvisa waunosangana naye kubva pane rondedzero kana kushandura mvumo, tinya-kurudyi pazita remunhu uyu uye sarudza yakakodzera sarudzo kubva pane yemukati menyu.
- Wana Kugovera Link (Tora chinongedzo). Kana iwe uchida kupa mukana kune online Excel sheet kune nhamba huru yevanhu, saka nzira inokurumidza ndeyekuvatumira chinongedzo kune iyo faira, semuenzaniso, kuburikidza neOutlook yekutumira rondedzero. Sarudza imwe sarudzo Wana Kugovera Link (Tora Chinongedzo) kuruboshwe rwehwindo, maviri ekubatanidza achaonekwa kurudyi rwehwindo: View Link (Link to View) uye Edit Link (Link yeKugadzirisa). Unogona kuendesa imwe kana ese ari maviri.
- Tumira kuSocial Networks (Tumira kuSocial Media). Zita resarudzo iyi rinozvitaurira uye haridi dzimwe tsananguro, kunze kwekungotaura kumwe chete. Kana ukasarudza nzira iyi, hauzowani runyorwa rweanowanikwa masocial network munzvimbo chaiyo yehwindo. Baya link Dzvanya apa kuti ubatanidze masocial network (Wedzera masocial network) kuwedzera maakaundi ako kuFacebook, Twitter, Google, LinkedIn, nezvimwe.
- enamel (Tumira ne email). Kana iwe uchida kutumira bhuku rekushanda reExcel sechibatanidzwa (sechinyorwa cheExcel, PDF kana XPS file) kana kuburikidza neInternet Fax, sarudza nzira iyi kuruboshwe rwehwindo uye sarudzo yakakodzera kurudyi.
Tip: Kana iwe uchida kudzikamisa nzvimbo yeExcel bhuku rebasa rinoonekwa nevamwe vashandisi, vhura pane iyo tab Fillet (Faira) chikamu Info (Details) wobva wadzvanya Browser Ona Sarudzo (browser View Options). Pano unogona kugadzirisa kuti ndeapi mapepa uye kuti ndeapi mazita anogona kuratidzwa pawebhu.
Ndizvo zvose! Bhuku rako reExcel 2013 rave online uye rave kuwanikwa kune vakasarudzwa vashandisi. Uye kunyangwe iwe usingade kushandira pamwe nemunhu, nzira iyi ichakubvumidza iwe kuti uwane mafaera eExcel kubva kupi zvako, ungave uri muhofisi, uchishanda kumba kana kuenda kumwe.
Shanda nemabhuku ebasa muExcel Online
Kana iwe uri mugari ane chivimbo weCloud Universe, saka unogona nyore kugona Excel Online panguva yako yekuzorora kwemasikati.
Maitiro ekugadzira bhuku rebasa muExcel Online
Kuti ugadzire bhuku idzva, baya kamuseve kari pedyo nebhatani sika (Gadzira) uye sarudza kubva pane yekudonha-pasi rondedzero Excel bhuku rebasa (Excel Book).
Kutumidza zita rebhuku rako repamhepo, tinya pazita rekutanga woisa rimwe idzva.
Kuti uise bhuku rebasa riripo kuExcel Online, tinya Upload (Rodha) pane OneDrive toolbar uye sarudza faira raunoda rakachengetwa pakombuta yako.
Maitiro ekugadzirisa mabhuku ebasa muExcel Online
Mushure mekuvhura bhuku rebasa muExcel Online, unogona kushanda naro uchishandisa Excel Web App (sezvakangoita neExcel yakaiswa pakombuta yako), kureva kuisa data, rongedza uye sefa, verenga uchishandisa mafomula, uye kuona data uchishandisa machati.
Pane musiyano mumwe chete wakakosha pakati pewebhu vhezheni uye yemuno vhezheni yeExcel. Excel Online haina bhatani Save (Chengetedza) nekuti inochengetedza bhuku rebasa otomatiki. Kana ukachinja pfungwa, tinya Ctrl + Zkukanzura chiito, uye Ctrl + Ykuitazve chiito chisina kuitwa. Nechinangwa chimwe chete, unogona kushandisa mabhatani rongedza (Kanzura) / Redo (Dzoka) tab Home (Kumba) muchikamu rongedza (Kanzura).
Kana iwe uri kuyedza kugadzirisa imwe data, asi hapana chinoitika, saka kazhinji bhuku rinovhurika mukuverenga-chete modhi. Kuti ugone kugadziridza modhi, tinya Rongedza Bhuku rebasa (Rodza Bhuku) > Rongedza muExcel Web App (Rongedza muExcel Online) uye ita shanduko nekukurumidza muwebhu browser yako. Kuti uwane mamwe epamusoro ekuongorora data maficha akadai sePivotTables, Sparklines, kana kubatanidza kune yekunze data sosi, tinya. Rongedza muExcel (Vhura muExcel) kuti uchinje kuMicrosoft Excel pakombuta yako.
Paunochengeta pepa muExcel, rinochengetwa kwawakarigadzira pakutanga, kureva, mune OneDrive gore rekuchengetedza.
Tip: Kana iwe uchida kuita shanduko nekukurumidza kumabhuku akati wandei, saka nzira yakanakisa ndeyekuvhura runyoro rwemafaira muOneDrive yako, tsvaga bhuku raunoda, tinya-kurudyi pariri uye sarudza chiito chaunoda kubva pane yemukati menyu.
Kugovera pepa rako rekushanda muExcel Online, tinya mugove (Zvakagovaniswa) > Goverana Nevanhu (Govera)…
... uye wobva wasarudza imwe yesarudzo:
- Koka Vanhu (Send access link) - uye isa email kero yevanhu vaunoda kugovera bhuku navo.
- Tsvaga hukama (Tora chinongedzo) - uye batanidza iyi link kune email, itumire pawebhusaiti kana pasocial network.
Iwe unogona zvakare kuseta kodzero dzekuwana kune vanobatika: kodzero yekuona chete kana kupa mvumo yekugadzirisa gwaro.
Kana vanhu vakawanda vachigadzirisa pepa rekushanda panguva imwe chete, Excel Online inobva yaratidza kuvapo kwavo uye nekugadzirisa zvakaitwa, chero munhu wese ari kugadzirisa gwaro muExcel Online uye kwete muExcel yepakombiyuta pakombuta. Kana iwe ukadzvanya pamuseve mudiki padivi pezita remunhu mukona yekurudyi yeExcel sheet, unogona kuona chaizvo kuti nderipi sero riri kugadzirisa iye zvino.
Kana iwe uri kugovera mapepa ekushanda epamhepo nechikwata chako, ungangoda kuvapa mvumo yekugadzirisa mamwe maseru, mitsetse, kana makoramu mugwaro rako reExcel. Kuti uite izvi, muExcel pane komputa yemuno, unofanirwa kusarudza iyo nhanho (s) yaunobvumira kugadzirisa, uye wozochengetedza pepa rebasa.
- Sarudza huwandu hwemasero ayo vashandisi vako vanogona kugadzirisa, vhura iyo tab ongorora (Ongorora) uye muchikamu Changes (Changes) tinya Bvumira Vashandisi Kugadzirisa Range (Bvumira kuchinja marara).
- Mubhokisi rehurukuro Bvumira Vashandisi Kugadzirisa Range (Bvumira kuchinja masanji) tinya bhatani New (Gadzira), ita shuwa kuti huwandu hwacho hwakarurama uye tinya Dzivirira Sheet (Chengetedza pepa). Kana iwe uchida kubvumira vashandisi vako kugadzirisa akawanda marenji, wobva wadzvanya bhatani zvakare. New (Gadzira).
- Isa password yako kaviri uye rodha pepa rakachengeteka kuOneDrive.
Kuti uwane rumwe ruzivo nezve izvi, ndapota verenga chinyorwa Kukiya uye kuvhura nzvimbo dzakati dzebepa rakachengetedzwa.
Maitiro ekuisa Excel Sheet muWebhusaiti kana Blog
Kana iwe uchida kushambadza bhuku rako rekushanda reExcel kune webhusaiti kana bhurogi, tevera matanho matatu ari nyore muExcel Web App:
- Vhura bhuku rebasa muExcel Online, tinya mugove (Zvakagovaniswa) > Embed (embed), wobva wadzvanya bhatani tanga (Gadzira).
- Munhanho inotevera, unotsanangura chaizvo kuti pepa rinofanira kutaridzika sei pawebhu. Nzira dzinotevera dziripo kwauri:
- Zvekuratidza (Chii chinofanira kuratidzwa). Muchikamu chino, unogona kutsanangura kana iwe uchida kurovera bhuku rese rebasa kana chikamu charo, senge ruzhinji rwemasero, tafura yepivot, zvichingodaro.
- Kuonekwa (Chitarisiko). Pano iwe unogona kugadzirisa kutaridzika kwebhuku (ratidza kana kuvanza mitsara yegridi, makolamu uye misoro yemitsara, sanganisira yekurodha link).
- Kusangana (Kusangana). Bvumira kana kusatendera vashandisi kudyidzana netafura yako - ronga, sefa uye isa data mumaseru. Kana iwe ukabvumira kupinda kwedata, ipapo shanduko dzakaitwa nevamwe vanhu mumaseru paInternet hadzizochengetwa mubhuku rekutanga rebasa. Kana iwe uchida kuti sero chaiyo rivhurwe pakuvhura peji rewebhu, tarisa bhokisi Gara uchitanga nesero iri rakasarudzwa (Gara uchitanga kubva muchitokisi ichi) uye tinya sero yaunoda munzvimbo Preview (Preview), iyo iri kurudyi rwebhokisi rebhokisi.
- miganhu (Dimensions). Pinda pano hupamhi uye urefu hwehwindo retafura mumapikisi. Kuti uone zviyero zvehwindo, tinya Ona saizi chaiyo (saizi chaiyo yekuona) pamusoro pehwindo Preview (Preview). Rangarira kuti iwe unogona kuseta saizi kuti iite 200 x 100 pixels uye kunyanya 640 x 655 pixels. Kana iwe uchida kuwana hukuru hwakasiyana hunodarika miganhu iyi, ipapo gare gare unogona kuchinja kodhi mune chero HTML editor, zvakananga panzvimbo yako kana bhurogi.
- Chaunofanirwa kuita kudzvanya mufananidzo (Kopi) pazasi chikamu Embed kodhi (embed kodhi) uye namatidza iyo HTML (kana JavaScript) kodhi mubhurogi rako kana webhusaiti.
Cherechedza: Iyo embed kodhi ndeye iframe, saka ita shuwa kuti saiti yako inotsigira iyi tegi uye bhurogi rako rinobvumira kuti rishandiswe mumaposita.
Yakamisikidzwa Excel Web App
Zvaunoona pazasi ishepa reExcel rinopindirana rinoratidza nzira yakatsanangurwa mukuita. Tafura iyi inoverengera kuti mangani mazuva asara kusvika zuva rako rekuzvarwa rinotevera, zuva rekuyeukwa, kana chimwe chiitiko, uye inopenda mikaha mumhando dzakasiyana dzegirinhi, yero, uye tsvuku. MuExcel Web App, iwe unongoda kuisa zviitiko zvako mumutsara wekutanga, wobva waedza kushandura mazuva anoenderana uye woona mhedzisiro.
Kana iwe uchida kuziva nezve formula inoshandiswa pano, ndapota ona chinyorwa Maitiro ekuseta ane conditional date formatting muExcel.
Chiziviso cheMushanduri: Mune mamwe mabhurawuza, iyi iframe inogona kusaratidza zvakanaka kana kusaratidza zvachose.
Mashups muExcel Web App
Kana iwe uchida kugadzira kudyidzana kwepedyo pakati peExcel websheets yako nemamwe mawebhusaiti kana masevhisi, unogona kushandisa JavaScript API inowanikwa paOneDrive kugadzira mashups anodyidzana kubva kudata rako.
Pazasi unogona kuona iyo Destination Explorer mashup yakagadzirwa neExcel Web App timu semuenzaniso wezvinogadzirwa nevagadziri vewebhusaiti yako kana blog. Iyi mashup inoshandisa Excel Services JavaScript uye Bing Mepu APIs kubatsira vashanyi vesaiti kusarudza nzira yekufamba. Unogona kusarudza nzvimbo pamepu uye mashup anokuratidza mamiriro ekunze panzvimbo iyoyo kana nhamba yevashanyi vanoshanyira nzvimbo idzodzo. Iyo skrini pazasi inoratidza kwatinogara 🙂
Sezvauri kuona, kushanda muExcel Online kuri nyore kwazvo. Zvino zvatavhara izvo zvekutanga, unogona kuramba uchiongorora maitiro ayo uye kushanda nemashiti ako zviri nyore uye nekuvimba!