The Ultimate Guide kuGoogle Sheets

Google Sheets ndechimwe chezvishandiso zvakanakisa zvaunogona kushandisa kuchengetedza data, kutevedzera maitiro ekuita, uye kugadzira dashboard uye mishumo.

Asi kunyangwe chiri chishandiso chinoshamisa chine zvisingaverengeki maficha uye mashandiro, zvinogona kunetsa kubata kune vanotanga - kunyanya kana iwe uchida kugadzira chirevo chekushambadzira kana dashboard, nekukurumidza.

Kwete kunetseka. Kana uri kutsvaga kutanga neGoogle Sheets, uri panzvimbo chaipo. Mugwaro iri, tichave tichitarisa mabhenefiti eGoogle Sheets uye kukufambisa iwe kuburikidza nezvimwe zvekutanga kuti iwe ugone kusimuka kuti ikurumidze nekukurumidza uye nemazvo.

 

Mabhenefiti eGoogle Sheets eKushambadza

Kutaura kuti vatengesi ndivo vanhu ve data-centric ndeyekushomeka. Pakati pekudzoka pakudyara, mutengo pakutenga, uye nezvimwe, vanogara vachitarisa mametric akasiyana uye kuzivisa nezvekufambira mberi.

Zvinogona kuve zvine hunyengeri kuchengetedza ese aya manhamba akatwasuka, zvakadaro. Ndiko uko maspredishiti anouya anobatsira. Nespredishiti rakanyatsorongeka, vatengesi vanogona kukurumidza kuongorora akasimba data seti uye kuita zvine hungwaru, zvine ruzivo sarudzo pamusoro pezvavakaita.

Pakutanga yakaunzwa neMicrosoft muna 1987, Excel yaive chishandiso chekuenda kumakore chekuvaka maspredishiti. Asi kana yakabatana, cloud-based tool Google Sheetsiti yakatangwa muna 2012, vashandisi vazhinji vakaita shanduko kune iyi nyowani (yemahara!) sosi.

Ngatitaure pamusoro pezvakanakira kushandisa Google Sheets zvezvinangwa zvekutengesa tisati takurukura dzimwe sarudzo dzechinyakare (seyakajairwa Excel spreadsheet).

  • Yakavakirwa mumakore. Cloud-based spreadsheets anochengetwa otomatiki, anochengetwa, uye anochengetwa kuburikidza nesevha iri kure. Izvi zvinoreva kuti iwe unogona kuzviwana online kubva chero kupi, chero nguva. Uyezve: Google Sheets inowanikwawo kunze kwenyika.
  • Ndezvemahara. Hapana software inodhura inodiwa - Google Sheets inogara 100% yemahara.
  • Inoshanda pamidziyo yese. Vatengesi vemazuva ano vanochinja pakati pezvishandiso zuva rese - uye Google Sheets inogadzika maitiro iwayo. Unogona kuwana uye kugadzirisa data reGoogle Sheet kubva kune akasiyana siyana emidziyo (senge smartphone yako, piritsi, uye komputa).
  • Ma-add-ons aripo. Tichapinda mune izvo zvekuwedzera zveGoogle Sheets zvishoma gare gare, asi kuwedzera kwekuita uye kuchinjika kweaya maficha ekuwedzera kunoita kuti chishandiso ichi chespredishiti chiwedzere kuita zvakasiyana uye chine simba.

Unogona kunge uchinetseka: Ndeupi musiyano uripo pakati peGoogle Sheets neExcel? Mhinduro pfupi ndeiyi: mutengo, kubatana, uye kuchinjika.

Nepo Excel inoda kunyoreswa kwesoftware (inodhura madhora zana nemakumi matatu), Google Sheets ndeyemahara kune vese vane account yeGoogle. Panyaya yekubatana, Excel inoda kuti iwe uchengetedze uye utumire vhezheni nyowani kana edits dzaitwa, nepo Google Sheets ichigadziridza otomatiki faira rimwe rakagovaniswa kune vese vechikwata. Uye chekupedzisira, nekuti Google Sheets ine kugona kugarisa akawanda akasiyana masanganiswa, inowanzo shanduka pane yakamira software mhinduro seExcel.

Matemu eGoogle Sheets akajairika ekuziva

Tevere, ngatizivei mimwe yemitauro uye mazwi akajairika anoshandiswa pakurevera data mukati meGoogle Sheets.

  • Column: Columns is vertical cell sets.
  • Row: Mitsara ine horizontal cell sets.
  • chitokisi: Masero ndiwo mapoinzi edhata rimwe chete mukati meGoogle Sheet.
  • dungwerungwe: Range inoreva kusarudzwa kwemasero kuyambuka koramu, mutsara, kana zvese.
  • basa: Basa rinoreva mashandiro akavakirwa-mukati eGoogle Sheet iyo inogona kushandiswa kukurumidza kuverenga kukosha, kushandura data, nezvimwe.
  • fomura: Maformula anosanganisa mabasa, mitsara, maseru, makoramu, uye masanji kuti abudise imwe magumo ekupedzisira.

Mashandisiro eGoogle Sheets

Iye zvino tagadzirira kunyura mune zvemberi uye zvidzidzo zvekushandisa Google Sheets.

Kunzwisisa Google Sheets Toolbar

Chimwe chezvinhu zvekutanga kuita kugona zvidhori zviri muGoogle Sheets toolbar. Kuita izvi kunobatsira kuve nechokwadi chekuti uri kuwana zvakanyanya kubva mukugona kwayo uye kuti uri kuchengetedza nguva nemapfupi. Tarisa pane iyo skrini pazasi kuti uone mamwe ekutanga ma icons uye zvinangwa zvavo mukati meiyo toolbar.

google-sheets-toolbar

Image Source

Magadzirirwo eSpreadsheet Itsva

Kana wagadzirira kugadzira spreadsheet itsva, unongoda kutevera nhanho shoma dzekukasika kuti utange. Vhura Google Sheets wodzvanya "Faira"> "Itsva"> "Spreadsheet".

gadzira-nyowani-google-sheet

Paunenge wagadzira yako nyowani spreadsheet, unogona kutanga kuwedzera data. Kana iwe uchida kushanda nespredishiti iripo kubva kuExcel pachinzvimbo, iwe uchafanirwa kuendesa iyo data muGoogle Sheet yako nyowani.

google-sheets-import-file

Kubva ipapo, faira rako richaiswa uye rinoshandurwa otomatiki kuita Google Sheet.

Kugovera uye Kudzivirira Dhata Yako

Kana Google Sheet yako yagadzikwa uye yagarwa nevanhu, iwe unozoda kufunga nezve nzira yekugovera uye kuchengetedza data rako. Dhata inochengetwa otomatiki, saka haufanirwe kunetsekana nechikamu ichocho. Unogona kusarudza waunogovanisa faira rako naye uye kuti vane gadziriso, vataura, kana kuona mvumo. Iwe unogona zvakare kuchengetedza chaiyo data mukati mebepa rako kuitira kuti avo vanogona kuwana vanogona chete kugadzirisa mamwe maseru.

Kugovera faira:

  1. Enda ku "Faira"> "Goverana" (kana kungodzvanya bhatani rebhuruu Govera mukona yekurudyi)
  2. Isa kero yeemail yekuti ndiani wauchange uchigovana naye spreadsheet
  3. Govera mazinga emvumo (akadai sekuti "Ona chete" kana "Inogona kugadzirisa")
  4. Dzvanya "Advanced" uye sarudza chero mamwe mamiriro ekuvanzika anodiwa

Kuchengetedza data:

  1. Enda ku "Data"> "Protected Sheets uye Ranges"
  2. Sarudza "Range" kana "Sheet" (kuchengetedza pepa rose)
  3. Sarudza data yaungade kuchengetedza
  4. Dzvanya "Set Mvumo"
  5. Sarudza kuratidza yambiro yekukanganisa kune chero munhu anoedza kugadzirisa kana kugadzirisa mvumo yevamwe vanhu.

Kuronga Data muGoogle Sheets

Google Sheets chishandiso chine simba chinogona kubata a rira yedata. Izvi zvinoreva kuti data rakawanda raunaro, ndipo pazvinonyanya kuoma kuti uiwane - ndipo panouya kusefa kunobatsira. Google Sheets ine akati wandei mafirita anobvumidza iwe kusarudza iyo data yaunoda kuona uye kuvanza zvausingaite.

Nzira yekuviga sei Data

Google inokutendera kuti uvanze mitsara yese kana makoramu. Izvi zvinova zvinobatsira kana iwe uchida kudzora maonero ekugovana, kana iwe kana iwe uchida kudzora huwandu hwe data rauri kuona chero nguva. Kuti uvanze koramu, tinya-kurudyi koramu yaunoda kuviga, wobva wasarudza “Viga Column”. Kana iwe ukavanza mbiru, miseve miviri ichaonekwa pane yakapfuura uye inotevera makoramu. Dzvanya izvi kuti udzorere chikamu kuti chionekwe zvizere.=

Maitiro eKuomesa Mitsara uye Makoramu

Kutonhora kuchagadzira mutsara unoyangarara kana koramu paunenge uchipururudza uye uchichengeta iyo data muminda iyo mukati memutsara wako wekuona. Semuyenzaniso, kana ukashandisa mutsara wekutanga kunyora makoramu ako, unogona kuomesa mutsara iwoyo kuti usazorangarira kuti koramu yega yega chii paunenge uchipepeta.

Kuomesa mutsara, sarudza "Tarisa"> "Freeze"> "1 mutsara" (kana kusvika X mitsara).google sheets hack: freeze row

Masefa Data

Ko kana iwe uchida kuona ese data muchikamu chimwe chete chinoenderana neimwe nzira? Isa sefa. Mafirita anotendera iwe kuti usarudze maitiro uye kuti iyo nzira inoshanda sei kune yako data. Semuyenzaniso, unogona kusefa yako 'Site Visits' column kuratidza kukosha kwese kunopfuura 1000, kana kusefa bepa rako kumaseru ese ane izwi rekuti “katsi”.

Kuti umise sefa, sarudza "Data"> "Gadzira Sefa." Dzvanya chiratidzo chefunnel chinoonekwa mukoramu, wobva wasarudza kusefa nemamiriro, kukosha, kana alpha kana manhamba kurongeka. Pepa rako rinongoratidza data rinogutsa maitiro ako.

google sheets hack: kugadzira mafirita

Dzidza nezve zvimwe sarudzo dzekusefa pazasi.

Maitiro ekuseta uye kushandisa Google Sheets Offline

Kana uchida kushandisa Google Sheets pasina indaneti, ingotevera matanho ataurwa apa kuti ubatidze kuwana maspredishiti ako pasina Indaneti.

Ramba uchiyeuka:

  • Iwe unofanirwa kuve wakabatana neinternet.
  • Iwe unofanirwa kushandisa iyo Google Chrome browser (usashandise incognito mode)
  • Iwe unozofanirwa kuisa uye kugonesa iyo Google Docs Offline Chrome yekuwedzera.
  • Ita shuwa kuti une nzvimbo yakakwana yemahara pane chako kifaa kuchengetedza mafaera ako ese.

Kubva ipapo:

  1. Vhura Chrome uye ita shuwa kuti uri kusaina mukati.
  2. Enda ku drive.google.com/drive/settings.
  3. Tarisa bhokisi riri padivi pe “Sync Google Docs, Sheets, Slides & Drawings mafaera pakombuta iyi kuti ugone kuagadzirisa pasina Indaneti.”
  4. Kushanda pamafaira pasina Indaneti kubva pakombuta, dzidza maitiro ekuisa Backup uye Sync.

Mazano epamusoro eGoogle Sheets

Iye zvino zvawanzwisisa izvo zvekutanga zveGoogle Sheets, ngatipindei mune mamwe matipi epamberi kuitira kuti utange kushandisa Sheets senyanzvi. Aya matipi anobatsira kuve muhomwe yako yekumashure ... kunyangwe usisaade izvozvi.

Conditional Formatting uye Heatmaps

Conditional fomati inozoisa otomatiki fomati kune sero zvichibva pane preset mamiriro. Semuenzaniso, unogona kusarudza kuratidza sero mutsvuku kana kukosha kwakapinda kuri pazasi zana kana kuverenga "Kukanganisa".

Heatmaps anoshanda zvakafanana pakuti anoshandisa chikero cheruvara kumaseru zvichienderana nemaitiro epakati (value yakakura kupfuura yepakati ichaita seyakasviba ukuwo ukoshi hudiki huchizooneka hukareruka). Izvi zvinokubatsira kuti utarise kukosha pane gradient uye inotaridza nzvimbo dzekunetseka padzo dzekutarisisa pfungwa dzako.

google sheets hack: kugadzira zvimiro zvefomati

Array Formulas

Array mafomula anogona kuita akawanda macalculation kamwechete uye kuburitsa kukosha kunoenderana nekuverenga ikoko. Nepo mafomula mazhinji achida kuti uite nhanho yega yega wakazvimirira (semuenzaniso unganidza mutsara mumwe wobva wawedzera kuhuwandu hwemutsara unotevera), hurongwa hunoita kuti maverengero anyanye kushanda. Izvi zvinobatsira kana uchishanda nehuwandu hwakawanda hwe data.

macro

Iyo Macros inoratidzira inorekodha akatevedzana matanho aungade kuti Google Sheets idzokorore pakuraira. Semuyenzaniso, kana ukashanda nedata idzva rakaiswa mwedzi wega wega, uye uchida kushandura iyo data munhevedzano imwe neimwe nguva, ipapo unogona kurekodha Macro, uye ita kuti Google ikuitire basa racho.

10 Unofanira-Kuziva Google Sheets Formulas

Paunenge waisa data rako uye iwe unofanirwa kuita imwe nekukurumidza-kupeta-nhamba, yakakosha mafomula anogona kukubatsira iwe kuwana mhinduro dzaunoda. Heano mashoma anowanzoshandiswa Mafomu eGoogle Sheets kukurumidza kuongorora yako data.

1. SUM

Iyi formula inowedzera kukosha kwese mukati mechikamu chakasarudzwa.

=SUM(renji)

2. AVERAGE

Iyi fomula inoverengera avhareji yenhamba mukati mehuwandu.

=AVERAGE(renji)

3. FIIRA

Iyi fomula inodzosa shanduro yakasefa yenzvimbo yekwakabva, ichidzora chete mitsetse kana makoramu anozadzisa zvakatarwa. Izvi zvinobatsira kana kupatsanura data negore kana mwedzi.

SEFA(renji, condition1, [condition2])

4. TSVAKA

Iyi fomula inodzosa nzvimbo panotanga kuwanikwa tambo mukati mezvinyorwa. Iyo Tsvaga fomula inobata nyaya.

tsvaga(tsvaga, mavara_yeku_kutsvaga, [kutanga_pa])

5. COUNTIF

Iyi fomula inodzosa nhamba ine zvimiso muchikamu.

=COUNTIF(renji, mucherechedzo)

6. CONCATENATE

Iyi fomula inokutendera kuti ubatanidze kukosha kwemaseru akawanda kuita sero rimwe, semuenzaniso, rekutanga uye rekupedzisira zita.

=CONCATENATE(Kukosha1, “ ”,Kukosha2)

7. VLOOKUP

Izvi zvinomiririra vertical lookup. Formula iyi inotsvaga pasi pekutanga koramu yerenji yekiyi uye inodzosera kukosha kwesero chaiyo mumutsara wawanikwa.

=VLOOKUP(kiyi_yekutsvaga, renji, indekisi, [yakarongwa_yakarongwa]).

dzidza maitiro ekuita VLOOKUP isingasviki miniti.

8. KUTsemura

Iyi fomula inopatsanura mavara kutenderedza mavara kana tambo, uye inoisa chidimbu chega chega musero rakaparadzana mumutsara. Shandisa izvi kana iwe uchida kuputsa mazita ekutanga kubva kune ekupedzisira mazita mune rondedzero yevatengi kana tarisiro.

=SPLIT(zvinyorwa, delimiter, [kupatsanurwa_ne_mumwe nomumwe])

9. SUBSTITUTE

Formula iyi inotsiva mavara aripo nemavara matsva mutambo. Semuyenzaniso: Unogona kutsiva zita rechigadzirwa neritsva pabepa read kopi.

=SUBSTITUTE(zvinyorwa_zve_kutsvaga, tsvaga, tsiva_ne, [nhamba_yechiitiko])

10. ZVAKANAKA

Iyi fomula inogadzirisa mavara mukati mesero kuenda kukesi yemusoro saka haufanirwe kufomati yega yega yega.

= ZVAKANAKA (zvinyorwa)

Kuti uwane mamwe mafomula aunogona kushandisa muGoogle Sheets, shandisa chishandiso chekutsvaga pane spreadsheet mabasa list uye tsvaga yaunoda.

Google Sheets Mabasa & Unyanzvi Iwe Waunofanirwa Kuziva

Maitiro ekugadzira Pivot Tafura

  1. Sarudza maseru ane source data yaunoda kushandisa mupivot tafura yako. Cherechedza: Imwe neimwe column inoda musoro.
  2. Mune menyu kumusoro, tinya "Data"> "Pivot tafura." Dzvanya tafura yepivot (kana isati yatovhurwa).
  3. Muparutivi, padivi pe “Row” kana “Columns,” tinya “Wedzera” wozosarudza kukosha. Cherechedza: Dzimwe nguva iwe uchaona akakurudzirwa matafura epivot zvichienderana nedata rawakasarudza. Kuti uwedzere tafura yepivot, pasi pe "Zvakurudzirwa," sarudza tafura yepivot.
  4. Muchikamu chepadivi, padivi pe "Values," tinya "Wedzera", wobva wasarudza kukosha kwaunoda kuona pamusoro pemitsara yako kana makoramu. Iwe unogona kushandura manyorerwo ako data, kurongwa, kupfupikiswa, kana kusefa.
  5. Padivi pezvauri kuda kushandura, tinya museve wepasi.

google-sheets-pivot-tafura

Mabvisirwo Akaitwa Maduplicates

  1. Sarudza sero raungade kubvisa ruzivo rwakapetwa.
  2. Pinda basa = UNIQUE(
  3. Sarudza maseru aungade kudhonza data kubva
  4. Vhara maparentheses. Basa rako rinofanira kutaridzika seizvi: = UNIQUE (A: A)

Maitiro ekugadzira Drop-Down List

  1. Pedyo ne "Criteria," sarudza imwe sarudzo:
  2. Dzvanya "Data"> "Data kusimbiswa".
  3. Sarudza sero kana maseru auri kuda kugadzira rondedzero yekudonha. Rondedzero kubva mumhando: Sarudza maseru anozoverengerwa murondedzero.
  4. Rondedzero yezvinhu: Isa zvinhu, zvakaparadzaniswa nemakoma uye pasina nzvimbo.
  5. Masero anenge aine museve wepasi. Kuti ubvise museve, bvisa "Ratidza mu-sero bhatani kuratidza runyorwa".
  6. Kana iwe ukaisa data musero risingaenderane nechinhu pane rondedzero, uchaona yambiro. Kana iwe uchida kuti vanhu vangoisa zvinhu kubva pane rondedzero, sarudza "Ramba kuisa" padivi pe "Pa data risiri iro".
  7. Dzvanya "Save". Iwo maseru acharatidza rondedzero yekudonhedza pasi. Kuti uchinje ruvara rwesero zvichienderana nesarudzo, shandisa conditional formatting (tarisa chikamu chiri pamusoro).

Magadzirirwo eGrafu

  1. Sarudza maseru aunoda kuisa muchati yako. Kuti urebe chati yako, wedzera musoro wemutsetse kana koramu.
  2. Dzvanya "Insert"> "Chati".
  3. Muparutivi, tinya "Data"> pasi pe "Chati yerudzi," sarudza chati.
  4. Kugadzirisa chati yako, tinya "Customize."

google-sheets-gadzira-chati

Ungabatanidza sei Masero

  1. Simbisa kana sarudza huwandu hwemasero.
  2. Tinya-kurudyi pamaseru akaiswa uye sarudza "Format Cells".
  3. Dzvanya bhatani rekuti "Batanidza" mubhara rekushandisa, wobva wasarudza yekubatanidza sarudzo yaunoda.

google-sheets-merge-cells

Maitiro ekurodha Google Sheets

Kana iwe uchida kushandisa Excel kana chimwe chishandiso chekuongorora data seti nefaira rako, unogona kutumira iyo faira nyore nyore. Enda ku "Faira"> "Download se". Wobva wasarudza kuti ndeipi fomati yaunoda.

download-google-sheets

Kana iwe uchida rumwe rubatsiro kuti utange, inokurumidza nzira yekutora kosi yekuparara uchishandisa Google Sheets ndeyekuwana iyo yemahara. Google Sheets Cheat Sheet, iyo inotsanangura zvekutanga pane:

  • Kugadzirisa data respredishiti
  • Kushanda nemitsara, makoramu, uye maseru
  • Kugovera/kubatirana mukati mespredishiti yako
  • Kuchengetedza uye kuchengetedza ruzivo rwako
  • Kushandisa zvakakosha mabasa

Iwe unogona zvakare kuwana iyo Mazano Library kuti uwane mamwe mazano ekushandisa Google Sheets.

Kwaungawane Akanakisa Google Sheets Matemplate

Kuvaka maspredishiti matsva kubva kutanga kunogona kutora nguva zvakanyanya, saka usadzorere vhiri kana usingaite. Pane kudaro, tsvaga yagara iripo eGoogle Sheets matemplate aunogona kugadzirisa uye kushandisa kune ako pachako kuedza. Ngatitarisei nzvimbo shoma dzakasiyana kwaunogona kuwana akagadzirira-kushandisa-matemplate ekuedza kwako kushambadzira.

1. HubSpot

kwaunowana google sheets matemplate: hubspot

Raibhurari yeHubSpot yeGoogle Sheets matemplate mugodhi wegoridhe wezviwanikwa kune nyanzvi inoda kuseta spreadsheet nekukurumidza. Muraibhurari ino, iwe unowana template yechero mhando yegwaro raungade, kusanganisira bhajeti rebhizinesi, ongororo yemakwikwi, mushumo wemari, dhibhodhi rekushambadzira, nezvimwe. Iwe unongofanirwa kubatanidza nhamba uye kugadzirisa minda iwe pachako. Iyi sarudzo yakanakira zvakakwana kana iwe uchitsvaga wega template.

Zvikasadaro, iwe unogona kunakidzwa kurodha emahara eHubSpot template kits. Iwo pazasi mabundle ane maGoogle Sheets matemplate akagadzirirwa kukwirisa timu inoshanda-inoshanda yekushambadzira.

  • Yemahara Google Sheets Template Bundle: Hausi kuda kutarisa muraibhurari yese uye kurodha matemplate imwe-ne-imwe? Dhawunirodha iyi kit yekutanga kuti utange maitiro ako ekugadzira spreadsheet.
  • Yemahara Marketing Budget Matemplate: Aya matemplate ekushambadza anogoneka ekushambadzira akanakira kuronda mashandisiro ako ekutengesa chigadzirwa, zvirimo, kushambadzira kwakabhadharwa, nezvimwe.
  • Mahara Edhisheni Karenda Matemplate: Haudi software inodhura kuti utange kuronga karenda yako yekudhinda. Shandisa matemplate aya kuti utange. Ivo zvakare vanowiriranisa neGoogle Calendar kuitira kuti hapana positi inoenda isina kuburitswa kana netsaona yakapfuura.
  • Email Marketing Planning Template: Iyi email yekushambadzira template inokubatsira iwe kufunga, kunatsa, uye kuronga mishandirapamwe yako yekuwedzera ROI uye optimize mhedzisiro yako.

2. Google Template Gallery

kwaungawane google sheets matemplate: google template gallery add-on

Iyi yemahara Google Sheets yekuwedzera inokupa iwe kupinda kune akawanda eakasiyana matemplate mukati meGoogle Sheets. Hapana chikonzero chekudhawunirodha gwaro rekunze kana kuita kopi kubva kune muparidzi waungasavimba naye. Muchishandiso ichi, unogona kuwana matemplate ekugadzirisa purojekiti, kuchengetedza nguva, uye bhajeti. Izvo chete zvakaderera ndezvekuti zvakaoma kutarisa maonerwo ematemplate, nekuti zvigunwe zvidiki.

3. template.net

kwaungawane google sheets matemplate: template.net

Template.net ine raibhurari yakakura yeGoogle Sheets matemplate ayo iwe aunogona kuona zviri nyore uye kugadzirisa kune zvaunoda. Kunyange raibhurari isiri seyekushambadzira-zvakananga, ichiri kupa zvakawanda kune vatengesi kuti vatevedze mishandirapamwe yavo 'ROI, senge iyi. social media marketing budget template. Isu tinokurudzira kupedza imwe nguva uchichera kuburikidza nechinhu ichi kuti uwane template inokushandira iwe.

4. Blockspring

kwaunowana google sheets matemplate: blockspring

Pazviwanikwa zvese zviri muchirongwa ichi, iyi ndiyo yakasarudzika. Sei? Nekuti aya haasi akajeka ekare matemplate kwaunogona kubaya nhamba woenda. Matemplate eBlockspring akabatana nevechitatu-bato masevhisi kudhonza data muspredishiti rako. Panzvimbo yekuti iwe unofanirwa kubatanidza spredishiti yako kune aya echitatu-bato masevhisi, matemplate eBlockspring anokuitira iwe.

Semuenzaniso, template yakanzi "Wana mazano emukati pamusoro wenyaya uchishandisa 'Skyscraper' ongororo” inoshandisa data kubva kuMoz neBing kuti ikuwanire runyoro rwemazano emukati paspredishiti chaipo - pasina iwe kunyatsoshandisa Moz kana Bing. Iwe unongofanira kuisa musoro wenyaya mumunda wakakodzera, uye spreadsheet izere yega.

Iyo chete yakaderera pakushandisa matemplate eBlockspring ndeyekuti iwe unofanirwa kutora mashoma ekuwedzera matanho kuti ivo vashande. Iwe unofanirwa kudhawunirodha iyo Blockspring yekuwedzera paGoogle Sheets, uye wotevera mashoma mirairo yakapusa kuti template itange uye ishande.

Hausati wawana matemplate eGoogle Sheets anokunakira iwe? Tarisa uone mashoma maroundups atinokurudzira:

  • HubSpot's Roundup yeakanakisa Google Sheets Matemplate: Hauna kuwana zvawanga uchitsvaga muraibhurari yeHubSpot yematemplate kana mune imwe yedu template kits? Iyi positi inogadzirisa template kune zvese zvinodiwa. Iwe unozodzidzawo kwekuwana matemplate mukati meGoogle Sheets.
  • Buffer's Google Sheets Matemplate eKushambadza: Mune ino positi, Buffer inonyora akasiyana e "report card" masitaera matemplate eGoogle Sheets anogona kubatsira kuronda nhamburiko dzako dzekushambadzira pamatanho akasiyana enhau enhau se Twitter, Facebook, nemamwe.
  • Smartsheet's Google Sheets Matemplate ekuronga: Smartsheet inopawo matemplate emahara, senge template yechirongwa chepurojekiti, inogona kukubatsira kuronga zvirinani mablog ako uye kutarisa mhinduro.

Iwo Akanakisa eGoogle Sheets Mawedzero

Kuti uwedzere kugona kwako muGoogle Sheets, funga kushandisa ma-add-ons. Heano mamwe mazano mashoma:

TapClicks

Dhonza yako yakabhadharwa yekutsvaga uye yekushambadzira data mune imwe spreadsheet, uye wovashandura kuva akanaka ekubika madhibhodhi iwe uchadada kuratidza mamaneja echikwata chako nevatungamiriri. Ichi chishandiso chakabhadharwa chinotanga pamadhora makumi maviri nemapfumbamwe / mwedzi.

Google Apps Chinyorwa

Google Apps Scripts inopa nzira yekuwedzera kushanda kweGoogle Sheets workspace yako kupfuura zvekutanga. Mutauro we cloud-scripting unokutendera kuti ugadzire, ugadzirise, uye uverenge Google Sheet yako kuburikidza nekubatanidzwa nemamwe maapuro eGoogle. Inokurudzirwa kune vashandisi vepamberi uye vanogadzira. Tarisa uone zvinyorwa pano.

DataKwese

Govera data pakati peExcel, dhatabhesi emuno, Salesforce, uye Google Sheets, pasina kupinza kana kutumira kunze chero mafaera. Izvi zvinoreva kuti kana uri kushandisa Excel uye uchida kuwiriranisa otomatiki data neGoogle Sheets, unogona kuzviita usingade kurodhazve gwaro muSheets.

XLMMiner Analysis ToolPak

Ita statistical analysis nemabasa. Nekuti Analysis ToolPak pakutanga yaive Microsoft Excel yekuwedzera, ichi chishandiso chikuru kwauri kana uri kupinda muGoogle Sheets mushure mekuva mushandisi weExcel.

Zvishandiso zveMasimba Edzero yeGoogle Sheets

Gadzirisa mashandiro echinyakare, sekubvisa zvakapetwa uye kutsvaga chaiwo maitiro. Iwe unogona zvakare kuenzanisa mapepa, ayo anobatsira zvakanyanya kana iwe uri kushanda kubva kune maviri akafanana maspredishiti. Ichi chishandiso chakabhadharwa chinotanga pa $29.95/gore.

SuperMetrics

Gadzira bhizinesi rekubika sisitimu yeSEM, SEO, webhu analytics, uye social media. Haisi chete SuperMetrics inoshandura huwandu hukuru hwe data kuita fomati inonyungudika, asi zvakare inoita otomatiki kuzorodza - saka hapana chikonzero chekudhonza nemaoko data pese paunoda kuona pfupiso yekuita kwako.

Clearbit Sheets

Gadzira zvinyorwa zveemail zvakanangwa uye ukwanise kutungamira nekukurumidza. Iyi yekuwedzera isarudzo huru kana iwe uchitoziva nezve chishandiso chakadai seLinkedIn Sales Navigator. Inozadzisa basa rakafanana, iyo data chete inogara pane yako yakavanzika spreadsheet, saka hapana chikonzero chekusaina kuLinkedIn pese paunoda kuona tarisiro data.

Google Sheets ndiyo inofanirwa-Kuve neChikwata Chese

Iri gwara rinokurumidza kuGoogle Sheets rinofanirwa kukubatsira kuti uwane pekutangira apo iwe unorisimudzira pakuedza kwako kushambadzira. Kubva pakunyatsotevera kurongeka kwemametrics akasiyana kuronga zvirinani kutenderedza zvirimo kuti ubatane nyore nechikwata chako, chishandiso ichi chinogona kukubatsira kuita zvine hungwaru, zvakawanda zvinotsigirwa nedatha sarudzo dzinofambisa zvine musoro kurudzi rwako.

Article Yepakutanga