Timatumiza mapepala a Excel pa intaneti, kugawana nawo, kuwayika pamasamba ndikupangitsa kuti azilumikizana

Mu imodzi mwazolembazo, tidaphunzira njira zosinthira ma sheet a Excel kukhala HTML. Lero zikuwoneka kuti aliyense akusunthira kusungirako mitambo, ndiye nchifukwa chiyani tikuipiraipira? Ukadaulo watsopano wogawana data ya Excel pa intaneti ndi njira yosavuta, yokhala ndi zinthu zambiri ndi maubwino omwe mungagwiritse ntchito.

Kubwera kwa Excel Paintaneti, simukufunikanso khodi yolemetsa ya HTML kuti mutumize masamba pa intaneti. Ingosungani buku lanu lantchito pa intaneti ndikulipeza paliponse, ligawane ndi ena, ndikugwirira ntchito limodzi patsamba limodzi. Pogwiritsa ntchito Excel Online, mutha kuyika pepala la Excel patsamba kapena bulogu ndikulola alendo kuti azitha kulumikizana nawo kuti adziwe zomwe akufuna.

Pambuyo pake m'nkhaniyi, tiwona izi ndi zina zambiri zomwe Excel Online imapereka.

• Kukweza Mabuku Ogwiritsa Ntchito a Excel 2013 (Akumeneko) pa intaneti
• Pangani masamba pa intaneti mu Excel Online
• Momwe mungasinthire mabuku ogwirira ntchito mu Excel Online
• Kugawana Mapepala Ogwiritsa Ntchito Pa intaneti a Excel
• Momwe mungaletsere kusintha kwa ma cell omwe mumawakonda pamapepala ogawana nawo
• Kuyika Excel Web App mu Webusaiti kapena Blog
• Excel Web App Mashups

Momwe Mungatumizire Mapepala a Excel 2013 ku Webusaiti

Ngati mutangoyamba kumene ndi ntchito zamtambo nthawi zambiri komanso Excel Online makamaka, ndiye kuti kungoyambira kosavuta kungakhale kugawana buku lomwe lilipo pogwiritsa ntchito mawonekedwe odziwika bwino a Excel 2013 pakompyuta yanu.

Mapepala onse a Excel Online amasungidwa mu utumiki wapaintaneti wa OneDrive (omwe kale anali SkyDrive). Monga mukudziwira, kusungidwa kwapaintaneti kumeneku kwakhalako kwakanthawi ndipo tsopano kuphatikizidwa mu Microsoft Excel ngati lamulo lodina kamodzi. Kuphatikiza apo, alendo, mwachitsanzo, ogwiritsa ntchito ena omwe mumagawana nawo ma spreadsheets safunanso akaunti yawo ya Microsoft kuti awone ndikusintha mafayilo a Excel omwe mumagawana nawo.

Ngati mulibe akaunti ya OneDrive, mutha kupanga imodzi pompano. Utumikiwu ndi wosavuta, waulere komanso wofunika kwambiri kuti musamalire chifukwa mapulogalamu ambiri a Microsoft Office 2013 suite (osati Excel okha) amathandizira OneDrive. Mukalembetsa, tsatirani izi:

1. Lowani muakaunti yanu ya Microsoft

Onetsetsani kuti mwalowa muakaunti yanu ya Microsoft kuchokera ku Excel 2013. Tsegulani buku lanu lantchito la Excel ndikuyang'ana pakona yakumanja yakumanja. Ngati muwona dzina lanu ndi chithunzi pamenepo, pitirirani ku sitepe yotsatira, mwinamwake dinani Lowani muakaunti (Zolowetsa).

Excel iwonetsa zenera ndikukufunsani kuti mutsimikizire kuti mukufunadi kulola Office kuti ilumikizane ndi intaneti. Dinani inde (Inde) ndiyeno lowetsani zambiri za akaunti yanu ya Windows Live.

2. Sungani pepala lanu la Excel kumtambo

Onetsetsani, kuti mukhale ndi mtendere wamumtima, kuti buku lantchito lomwe mukufuna latsegulidwa, ndiye kuti, ndendende lomwe mukufuna kugawana nawo pa intaneti. Ndikufuna kugawana nawo buku Mndandanda wa Mphatso za Tchuthikotero kuti achibale anga ndi anzanga aziwonera ndikuthandizira 🙂

Ndi buku lotseguka, pitani ku tabu Filamu (Fayilo) ndikudina Share (Kugawana) kumanzere kwa zenera. Njira yokhazikika idzakhala Itanani Anthu (Itanirani anthu ena), ndiye muyenera dinani Sungani Ku Cloud (Sungani ku Cloud) kumanja kwa zenera.

Pambuyo pake, sankhani malo osungira fayilo ya Excel. OneDrive imatchulidwa koyamba kumanzere ndipo imasankhidwa mwachisawawa. Inu muyenera mwachindunji chikwatu kupulumutsa wapamwamba kumanja pa zenera.

Zindikirani: Ngati simukuwona chinthu cha menyu cha OneDrive, ndiye kuti mulibe akaunti ya OneDrive, kapena simunalowe muakaunti yanu.

Ndapanga kale foda yapadera Gift Planner, ndipo ikuwonetsedwa pamndandanda wamafoda aposachedwa. Mutha kusankha chikwatu china chilichonse podina batani Categories (Mwachidule) m'munsimu dera Mafoda aposachedwa (Mafoda aposachedwa), kapena pangani chikwatu chatsopano podina kumanja ndikusankha kuchokera pazosankha yatsopano (Pangani) > Foda (chikwatu). Mukasankha chikwatu chomwe mukufuna, dinani Save (Sungani).

3. Kugawana Mapepala a Excel Osungidwa pa Webusaiti

Buku lanu lantchito la Excel lili kale pa intaneti ndipo mutha kuliwona mu OneDrive yanu. Ngati mukufuna kugawana mapepala a Excel osungidwa pa intaneti, muyenera kungotenga sitepe imodzi - sankhani imodzi mwa njira zoperekedwa ndi Excel 2013 pogawana:

• Itanani Anthu (Itanirani anthu ena). Izi zimasankhidwa mwachisawawa. Ingolowetsani imelo adilesi ya (a) omwe mukufuna kugawana nawo pepala la Excel. Mukangoyamba kuyilemba, kumaliza kwathunthu kwa Excel kumafanizira zomwe mudalemba ndi mayina ndi ma adilesi omwe ali m'buku lanu la maadiresi ndikuwonetsani mndandanda wazofananira zomwe mungasankhe. Ngati mukufuna kuwonjezera angapo ojambula, lowetsani iwo olekanitsidwa ndi semicolons. Komanso, mungagwiritse ntchito kusaka kulankhula mu adiresi buku, kuchita izi, dinani chizindikiro Sakani Bukhu Lamadilesi (Fufuzani m’buku la maadiresi). Mutha kukhazikitsa maufulu opezeka kuti muwone kapena kusintha posankha njira yoyenera kuchokera pamndandanda wotsikira kumanja. Ngati mungatchule olumikizana nawo angapo, ndiye kuti zilolezo zidzakhazikitsidwa kuti zikhale zofanana kwa aliyense, koma kenako mutha kusintha zilolezo za munthu aliyense payekhapayekha. Mukhozanso kuwonjezera uthenga wanu pa kuitanirako. Ngati simulowetsa chilichonse, Excel idzakuwonjezerani chidziwitso.

  Pomaliza, muyenera kusankha ngati wogwiritsa ntchitoyo alowe muakaunti yawo ya Windows Live kuti athe kupeza tsamba lanu la Excel pa intaneti. Sindikuwona chifukwa china chilichonse chowakakamiza kuchita izi, koma zili ndi inu.

  Zonse zikakonzeka, dinani batani Share (Kufikira pagulu). Aliyense woitanidwa adzalandira imelo yokhala ndi ulalo wa fayilo yomwe mudagawana. Kuti mutsegule pepala lanu la Excel pa intaneti, wogwiritsa ntchito amangodina ulalo

  

  Pambuyo pokanikiza fayilo ya Share (Gawani), Excel iwonetsa mndandanda wa omwe mudagawana nawo fayilo. Ngati mukufuna kuchotsa wolumikizana nawo pamndandanda kapena kusintha zilolezo, dinani kumanja pa dzina la munthuyu ndikusankha njira yoyenera pamenyu yankhaniyo.

  

• Pezani Ulalo Wogawana (Pezani ulalo). Ngati mukufuna kupatsa mwayi wopezeka pa intaneti ya Excel kwa anthu ambiri, ndiye kuti njira yachangu ndikuwatumizira ulalo wa fayilo, mwachitsanzo, kudzera pamndandanda wamakalata a Outlook. Sankhani njira Pezani Ulalo Wogawana (Pezani Ulalo) kumanzere kwa zenera, maulalo awiri adzawonekera kumanja kwa zenera: Onani Chigwirizano (Link to View) ndi Sinthani Ulalo (Ulalo Wosintha). Mutha kupereka chimodzi kapena zonse ziwiri.
• Tumizani ku Social Networks (Post to Social Media). Dzina lachisankhochi limadzinenera lokha ndipo silifuna kufotokozera kwina, kupatula ndemanga imodzi. Mukasankha njirayi, simungapeze mndandanda wa malo ochezera a pa Intaneti pawindo loyenera. Dinani ulalo Dinani apa kuti mulumikizane ndi malo ochezera (Onjezani malo ochezera) kuti muwonjezere maakaunti anu ku Facebook, Twitter, Google, LinkedIn, ndi zina.
• Email (Tumizani ndi imelo). Ngati mukufuna kutumiza buku lantchito la Excel ngati cholumikizira (monga fayilo ya Excel, PDF kapena XPS) kapena kudzera pa Fax ya intaneti, sankhani njira iyi kumanzere kwazenera ndi njira yoyenera kumanja.

Tip: Ngati mukufuna kuchepetsa gawo la buku la Excel lomwe limawonedwa ndi ogwiritsa ntchito ena, tsegulani pa tabu Filamu (Fayilo) gawo Info (Zambiri) ndikusindikiza Zosankha Zowonera Msakatuli (Zosankha za Msakatuli). Apa mutha kusintha kuti ndi masamba ati ndi zinthu zotchulidwa zomwe zitha kuwonetsedwa pa intaneti.

Ndizomwezo! Buku lanu lantchito la Excel 2013 tsopano lili pa intaneti ndipo likupezeka kwa ogwiritsa ntchito omwe asankhidwa. Ndipo ngakhale simukufuna kuyanjana ndi aliyense, njirayi ikuthandizani kuti mupeze mafayilo a Excel kuchokera kulikonse, kaya muli muofesi, mukugwira ntchito kunyumba kapena mukuyenda kwinakwake.

Gwirani ntchito ndi mabuku ogwirira ntchito mu Excel Online

Ngati ndinu munthu wokhala ndi chidaliro cha Cloud Universe, ndiye kuti mutha kudziwa bwino Excel Online panthawi yopuma masana.

Momwe mungapangire buku lantchito mu Excel Online

Kuti mupange buku latsopano, dinani kamuvi kakang'ono pafupi ndi batani Pangani (Pangani) ndikusankha kuchokera pamndandanda wotsitsa Buku la ntchito la Excel (Buku la Excel).

Kuti mutchulenso buku lanu lapaintaneti, dinani dzina losakhazikika ndikulowetsa lina.

Kuti mukweze buku lantchito lomwe lilipo ku Excel Online, dinani Kwezani (Kwezani) pazida za OneDrive ndikusankha fayilo yomwe mukufuna yosungidwa pakompyuta yanu.

Momwe mungasinthire mabuku ogwirira ntchito mu Excel Online

Mukatsegula bukhu lantchito mu Excel Online, mutha kugwira nalo ntchito pogwiritsa ntchito Excel Web App (monga momwe Excel idayikidwira pakompyuta yanu), mwachitsanzo, lowetsani deta, sinthani ndikusefa, kuwerengera pogwiritsa ntchito ma fomula, ndikuwona m'maganizo mwanu deta pogwiritsa ntchito ma chart.

Pali kusiyana kumodzi kokha pakati pa tsamba lawebusayiti ndi mtundu wamba wa Excel. Excel Online ilibe batani Save (Sungani) chifukwa imasunga bukhuli basi. Ngati musintha malingaliro anu, dinani Ctrl + Zkuletsa ntchitoyo, ndi Ctrl + Ykuti achitenso zomwe sizinachitike. Kwa cholinga chomwecho, mungagwiritse ntchito mabatani konthani (Chotsani) / Bwezerani (Kubwerera) tabu Kunyumba (Kunyumba) mu gawo konthani (Kuletsa).

Ngati mukuyesera kusintha zina, koma palibe chomwe chimachitika, ndiye kuti bukuli limatsegulidwa powerenga-pokha. Kuti muyambitse kusintha, dinani Sinthani Buku la Ntchito (Sinthani Bukhu) > Sinthani mu Excel Web App (Sinthani mu Excel Online) ndikusintha mwachangu mu msakatuli wanu. Kuti mupeze zowunikira zapamwamba kwambiri monga PivotTables, Sparklines, kapena kulumikizana ndi gwero la data lakunja, dinani Sinthani mu Excel (Tsegulani mu Excel) kuti musinthe kukhala Microsoft Excel pa kompyuta yanu.

Mukasunga pepala mu Excel, lidzasungidwa pomwe mudalipangira, ndiye kuti, mu yosungirako mitambo ya OneDrive.

Tip: Ngati mukufuna kusintha mwachangu m'mabuku angapo, ndiye kuti njira yabwino ndikutsegula mndandanda wamafayilo mu OneDrive yanu, pezani buku lomwe mukufuna, dinani kumanja kwake ndikusankha zomwe mukufuna kuchokera pamenyu yankhaniyo.

Momwe Mungagawire Tsamba Lantchito ndi Ogwiritsa Ena mu Excel Online

Kuti mugawane tsamba lanu mu Excel Online, dinani Share (Gawo) > Share ndi Anthu (Gawani)…

…kenaka sankhani chimodzi mwazosankhazo:

• Itanani Anthu (Tumizani ulalo wofikira) - ndipo lowetsani adilesi ya imelo ya anthu omwe mukufuna kugawana nawo bukuli.
• Pezani chiyanjano (Pezani ulalo) - ndikulumikiza ulalowu ku imelo, tumizani patsamba lawebusayiti kapena pamasamba ochezera.

Mutha kukhazikitsanso ufulu wofikira kwa omwe mumalumikizana nawo: ufulu wongowona kapena kupereka chilolezo kuti musinthe chikalatacho.

Pamene anthu angapo akusintha pepala nthawi imodzi, Excel Online nthawi yomweyo imawonetsa kupezeka kwawo ndi zosintha zomwe zachitika, malinga ngati aliyense akusintha chikalatacho mu Excel Online osati mu Excel wakomweko pakompyuta. Mukadina kachidutswa kakang'ono pafupi ndi dzina la munthuyo pakona yakumanja kwa pepala la Excel, mutha kuwona ndendende kuti ndi selo liti lomwe munthuyo akukonza pano.

Momwe mungaletsere kusintha kwa ma cell ena papepala logawana

Ngati mukugawana mapepala ogwirira ntchito pa intaneti ndi gulu lanu, mungafune kuwalola kuti asinthe ma cell, mizere, kapena mizere muzolemba zanu za Excel. Kuti muchite izi, mu Excel pakompyuta yanu, muyenera kusankha mitundu (ma) yomwe mumalola kusintha, ndikuteteza tsambalo.

1. Sankhani ma cell angapo omwe ogwiritsa ntchito anu angasinthe, tsegulani tabu Review (Unikani) ndi mgawo kusintha (Zosintha) dinani Lolani Ogwiritsa Ntchito Kusintha Masanjidwe (Lolani kusintha magawo).
2. Mu dialog box Lolani Ogwiritsa Ntchito Kusintha Masanjidwe (Lolani kusintha magawo) dinani batani yatsopano (Pangani), onetsetsani kuti mndandandawo ndi wolondola ndikudina Tetezani Mapepala (Tetezani pepala). Ngati mukufuna kulola ogwiritsa ntchito kusintha magawo angapo, dinani batani kachiwiri. yatsopano (Pangani).
3. Lowetsani mawu achinsinsi anu kawiri ndikukweza pepala lotetezedwa ku OneDrive.

Kuti mudziwe zambiri za izi, chonde werengani nkhani Kutseka ndi kutsegula madera ena a pepala lotetezedwa.

Momwe Mungayikitsire Mapepala a Excel mu Webusaiti kapena Blog

Ngati mukufuna kusindikiza buku lanu la Excel patsamba kapena bulogu, tsatirani njira zitatu zosavuta izi mu Excel Web App:

1. Tsegulani buku lantchito mu Excel Online, dinani Share (Gawo) > Sakanizani (embed), kenako dinani batani kupanga (Pangani).
2. Mu sitepe yotsatira, mumafotokoza ndendende momwe pepala liyenera kuwonekera pa intaneti. Njira zotsatirazi zilipo kwa inu:
   • Zoyenera kusonyeza (Zomwe ziyenera kuwonetsedwa). Mu gawoli, mutha kufotokoza ngati mukufuna kuyika bukhu lonselo kapena gawo lake, monga ma cell angapo, tebulo la pivot, ndi zina zotero.
   • Maonekedwe (Mawonekedwe). Apa mutha kusintha mawonekedwe a bukhulo (kuwonetsani kapena kubisa mizere ya gridi, mizere ndi mitu yamizere, kuphatikiza ulalo wotsitsa).
   • Kuyanjana (Kulumikizana). Lolani kapena musalole ogwiritsa ntchito kuyanjana ndi tebulo lanu - sankhani, sefa ndikulowetsani deta m'maselo. Ngati muloleza kulowa kwa data, ndiye kuti zosintha zomwe anthu ena apanga m'maselo a pa intaneti sizingasungidwe mu bukhu loyambirira. Ngati mukufuna kuti selo linalake litsegulidwe potsegula tsamba, chongani bokosilo Nthawi zonse yambani ndi selo losankhidwa (Nthawi zonse yambani kuchokera mu cell iyi) ndikudina cell yomwe mukufuna mderali chithunzithunzi (Zowoneratu), yomwe ili kumanja kwa bokosi la zokambirana.
   • miyeso (Miyeso). Lowetsani apa m'lifupi ndi kutalika kwa zenera la tebulo mu ma pixel. Kuti muwone miyeso yeniyeni ya zenera, dinani Onani kukula kwenikweni (kukula kweniyeni) pamwamba pa zenera chithunzithunzi (Zowoneratu). Kumbukirani kuti mutha kuyika kukula kwake kukhala ma pixels osachepera 200 x 100 komanso ma pixel opitilira 640 x 655. Ngati mukufuna kupeza kukula kosiyana komwe kumadutsa malirewa, ndiye pambuyo pake mukhoza kusintha kachidindo mu mkonzi uliwonse wa HTML, mwachindunji pa tsamba lanu kapena blog.
3. Zomwe muyenera kuchita ndikudina Koperani (Koperani) m'munsimu gawo Kutsitsa kachidindo (ikani kachidindo) ndikumata kachidindo ka HTML (kapena JavaScript) mubulogu kapena tsamba lanu.

Zindikirani: Khodi yoyikapo ndi iframe, choncho onetsetsani kuti tsamba lanu likugwirizana ndi chizindikiro ichi ndipo blog yanu imalola kuti igwiritsidwe ntchito pazolemba.

Yophatikizidwa ndi Excel Web App

Zomwe mukuwona pansipa ndi pepala lolumikizana la Excel lomwe likuwonetsa njira yomwe yafotokozedwa ikugwira ntchito. Tebuloli limawerengetsera kuti kwatsala masiku angati kuti tsiku lanu lobadwa, tsiku lokumbukira tsiku lotsatira, kapena chochitika china chichitike, ndipo imakongoletsa mipatayo m'mithunzi yobiriwira, yachikasu, ndi yofiira. Mu Excel Web App, mumangofunika kuyika zochitika zanu mugawo loyamba, kenako yesani kusintha masiku ofananira ndikuwona zotsatira.

Ngati mukufuna kudziwa njira yomwe yagwiritsidwa ntchito pano, chonde onani nkhaniyi Momwe mungakhazikitsire masanjidwe amasiku okhazikika mu Excel.

Zolemba Zomasulira: M'masakatuli ena, iframe iyi ikhoza kusawonetsedwa bwino kapena ayi.

Mashups mu Excel Web App

Ngati mukufuna kupanga kulumikizana kwapafupi pakati pa masamba anu a Excel ndi mapulogalamu kapena ntchito zina zapaintaneti, mutha kugwiritsa ntchito JavaScript API yomwe ikupezeka pa OneDrive kupanga mashups olumikizana kuchokera mu data yanu.

Pansipa mutha kuwona masanjidwe a Destination Explorer opangidwa ndi gulu la Excel Web App monga chitsanzo cha zomwe opanga atha kupanga patsamba lanu kapena blog. Kuphatikizikaku kumagwiritsa ntchito JavaScript ya Excel Services JavaScript ndi Bing Maps API kuthandiza obwera patsamba kusankha njira yoyendera. Mutha kusankha malo pamapu ndipo mashup amakuwonetsani nyengo pamalopo kapena kuchuluka kwa alendo omwe amabwera kumadera amenewo. Chithunzi chomwe chili pansipa chikuwonetsa komwe tili 🙂

Monga mukuwonera, kugwira ntchito mu Excel Online ndikosavuta. Tsopano popeza tafotokoza zoyambira, mutha kupitiliza kuyang'ana mawonekedwe ake ndikugwira ntchito ndi mapepala anu mosavuta komanso molimba mtima!