Maitiro ekuita donhwe pasi runyorwa muExcel

Microsoft Excel

Kana isu tikataura nezve maspredishiti, isu tinofanirwa kutaura nezveExcel, chikumbiro chakarova musika muna 1985, asi hachina kuzova chirevo mumusika kusvika 1993, apo chakapfuura Wemasimbaose Lotus-1-2-3. Nhasi Excel iri inosanganiswa pamwe uye isingaparadzanisike kubva kuOfisi 365.

Kwemakore, Excel yakangovandudza, ichipa huwandu hwakawanda hwemhinduro, mhinduro kumakambani nevanhu vamwe nevamwe. Rimwe remabasa arinotipa, zvese kune vashandisi uye nemakambani, ndiko mukana we gadzira anodonhedza zvinyorwa, basa rinobatsira kwazvo ratinodzidzisa rinotevera.

Excel inowanikwa kune ese Windows uye macOS uye kuburikidza newebhu, mune zvizere shanduro. Kunyangwe chiri chokwadi kuti tine vhezheni inowanikwa yemafoni nhare, izvi haina kukwana zvakadaro senge iyo yatinogona kuwana mune desktop desktop. Matanho ekutevera kugadzira donhwe-pasi runyorwa muExcel akafanana muWindows, macOS uye kuburikidza neWebhu vhezheni.

Kunyangwe ivo vachigona chete kugadzirwa kuburikidza ne desktop desktop yeExcel, idzi vanogona kubvunzwa uye nekudyidzana nechero ipi vhezheni yeExcel, kusanganisira iyo yakadzikiswa vhezheni iyo Microsoft inotipa isu kuburikidza neOfisi kunyorera mbozhanhare mbozha, application yemahara zvachose.

Ndeapi mazita ekudonhedza pasi

Excel kudonhedza pasi runyorwa

Iwo ekudonhedza-pasi zvinyorwa, zvinotibvumidza isu Sarudza kubva pane chinyorwa cheimwe sarudzo imwe chete, kusara kwezvimwe. Rudzi urwu rwezvinyorwa rinotibvumidza isu kushandisa default maitiro tichidzivirira kupinda kweanokanganisa dhata kana nezviperengo zvikanganiso (izvo zvinotibvumidza isu kuti tiite chaiwo mafirita ekutsvaga).

Mumakambani, izvi zvinyorwa zvinobvumidza iwe kuronga uye kubata ako ezuva nezuva mabasa uye manejimendi mune yakanyanya basa nzira, pamwe nekupa iyo yehunyanzvi yekubata isingambokuvadza. Huwandu hwekudonhedza-pasi zvinyorwa izvo zvatinogona kugadzira hazvina muganho, saka tinogona kugadzira runyorwa bhokisi kune yega yega maseru pane pepa.

Mitsara - pivot matafura muExcel
Nyaya inoenderana:
Maitiro ekugadzira tafura yepivot muExcel pasina zvinetswa

Aya marudzi ezvinyorwa anonyanya kubatsira pakugadzira invoice (uko pfungwa yega yega yakasiyana neiya yapfuura), track kushanya, gadzira dhatabhesi kuti ushandise mafirita etsika izvo zvinotibvumidza isu kudzora masheya mumatura ... Kana iwe wasvika pane ino chinyorwa, zvingangoita kuti iwe uri kujekeserwa nezvekubatsira iwe kwaunofunga kupa kune ino inoshamisa Excel basa.

Maitiro ekugadzira kudonhedza pasi zvinyorwa muExcel

Iwo anodonhedza-pasi rondedzero anowana iyo data kubva kumatafura ayo isu atinofanirwa kumbogadzira kuti tishandise sosi Kana icho chinangwa cheshiti isu chatinoda kugadzira iyo yekudonha-pasi zvinyorwa ndezvokuzviprinta, isu tinofanirwa seta sosi yedata kune rimwe rakaparadzana sheet, jira ratingaidza kuti Data.

Sezvandataura pamusoro apa, mune rimwe jira tinokwanisa kugadzira zvinyorwa zvisingaperi, saka kana tisingade kugadzira pepa renzvimbo imwe neimwe yedhata, tinogona kushandisa pepa rimwe chete, pasina kubvisa data ratakashanda se sosi yezvinyorwa zvatakatogadzira. Kana tangojekesa nezve mashandiro avo, tinokuratidza matanho aunofanira kutevera gadzira kudonhedza zvinyorwa muExcel.

Gadzira dhata sosi

Excel dhata sosi

Chinhu chekutanga chatinofanira kuita kugadzira dhata sosi, dhata iyo inoshandiswa kugadzira iyo yekudonhedza-pasi zvinyorwa. Kana isu tisina kumbogadzira iyi data, iyo yekudonha-pasi runyorwa havana chavangaratidza. Kugadzira iyo sosi yedata, isu tinovhura jira nyowani muExcel, tinya kaviri pazita uye isu tichaitumidza zita kuti Data.

Kuti usabatanidzwe neiko ari manyuko e data erimwe nerimwe rezita rekudonha-pasi ratiri kuda kugadzira, isu tinofanirwa kunyora sekutanga kukoshesa zita rezita racho, angave maguta, mamodheru, nyika, zvipfeko ... Kana isu tichizogadzira runyorwa chete, hazvidi kuti unyore zita muchitokisi chekutanga.

Tevere, isu tinofanirwa kunyora dzese sarudzo dzatinoda zvinoratidzwa mune yekudonha-pasi runyorwa, imwe pazasi peimwe mukoramu imwechete kuti zviite nyore kusarudza sosi yedata. Kana tangogadzira sosi yedata, tinogona kugadzira kudonhedza pasi zvinyorwa.

Gadzira yakadonhedza-pasi runyorwa

Excel kudonhedza pasi runyorwa

  • Pakutanga tinosarudza masero kwatinoda kuti madonhwe ekudonhedza aoneke.
  • Tevere, tinya pane iyo Dhata sarudzo (kwete pepa) pane ribhoni. Mukati mesarudzo, tinya pane Kusimbiswa kwedata.

Gadzira zvinyorwa muExcel

  • Mukati meKugadziridza tebhu> Maitiro ekusimbisa> Tendera isu sarudza Lista.
  • Tevere tinoenda kuKutanga bhokisi uye tinya pane icon pamagumo ebhokisi kuenda Sarudza huwandu hwesero uko data iriko.

Masero anowanikwa mumatanho eExcel

  • Tevere, tinya paData jira uye isu tinosarudza huwandu hwesero uko data iriko, tichisiya zita rechitokisi iro ratitendera kuti tizive iyi data. Kana tangosarudza dhatabhesi, tinodzvanya Enter.

Excel

  • Isu takatogadzira yedu yekutanga kudonhedza pasi runyorwa pane chikuru Excel sheet. Mumasero ese atakasarudza kuratidza kudonhedza pasi, museve wezasi wave kuratidzwa uyo unotikoka kuti tinyore ku Sarudza kubva pane zvese sarudzo izvo zvatakambomisikidza muData peji.

Kana tango gadzira yekutanga kudonhedza runyorwa, isu tinofanirwa ita zvakafanana kugadzira mamwe ese ekudonhedza zvinyorwa izvo zvatinoda kana zvatinoda.


Iva wekutanga kutaura

Siya yako yekutaura

Your kero e havazobvumirwi ichibudiswa. Raida minda anozivikanwa ne *

*

*

  1. Inotarisira iyo data: Actualidad Blog
  2. Chinangwa cheiyo data: Kudzora SPAM, manejimendi manejimendi.
  3. Legitimation: Kubvuma kwako
  4. Kutaurirana kwedata
  5. Dhata yekuchengetedza: Dhatabhesi inobatwa neOccentus Networks (EU)
  6. Kodzero: Panguva ipi neipi iwe unogona kudzora, kupora uye kudzima ruzivo rwako