Dos uye Dont's In Data Data mu Excel

01 ye 08

Excel Data Entry Overview

Iyi dzidzo inosanganisira mamwe ezvinyorwa zvinonzi DOs uye DON'Ts yekupinda dhidhiyo mumapurogiramu eparashiriti akadai seExcel, Google Spreadsheets, uye Open Office Calc.

Kupinda data nenzira yakakodzera nguva yokutanga inogona kudzivisa matambudziko gare gare uye kuita kuti zvive nyore kushandisa zvidzidzo zvakawanda zveExcel uye zvinhu zvakadai semafomu nemashadi.

III neDON'Ts ndezvi:

1. Gadzirira pepa rako resafa
2. Usarega Mhemberero Mitsara kana Columns Paunenge Uchitaura Dhiyabhorosi Dhidhiyo
3. Chengetedza Kazhinji uye Ponesa Munzvimbo Maviri
4. Usashandise Numeri seColumn Headings uye Usasanganisira Units neData
5. Unoshandisa Cell References uye Zita Rakatorwa muMafomu
6. Usarega Masero ane Zvimiti Zvisavhurwa
7. Ita Zita Dzako

Ronga Ruponeso Rwako

Kana zvasvika pakunopinda data kuExcel, iri pfungwa yakanaka yekuita zvishoma kuronga usati watanga kuisa.

Kuziva kuti pepa rekushandiswa richashandiswa sei, iyo inenge ichinyorwa, uye chii chichaitwa neyo data inogona kuchinja zvikuru kurongwa kwekupedzisira kwebasa racho.

Kuronga usati waita unogona kuchengetedza nguva gare gare kana sarashiti inofanirwa kugadziriswa kuti iite zvakajeka uye nyore nyore kushanda nayo.

Zvokufunga nezvazvo

• Chinangwa chepadhetiti chii?
• Shandheti yacho inobata mari yakawanda sei?
• Mifananidzo inoda here?
• Ko spreadsheet ichadhindwa here?

Chinangwa cheSpreadsheet chii?

• Chinangwa chepasiteteti chichabatsira kuziva nzvimbo ye data, sezvo inonyanya kukosha ruzivo inofanira kuonekwa uye nyore nyore kusvika.
• Ndezvipi kuverenga zvinodiwa? Iko kuverenga kunobata maitiro uye mabasa zvinodikanwa uye kwavanozove.

Ipadhesheti Inobata Zvakawanda Sei?

Nhamba ye data iyo spreadsheet inotanga kubata uye kuti yakawedzerwa sei gare gare ichakanganisa nhamba yemashizha ekushandiswa akashandiswa.

• Usaparadzira deta yako kunze kwazvo sezvo ichigona kuita kuti ruzivo rwakananga ruzive ruwane kuwana uye kuverenga kuisa mahwendefa akawanda kana mabhuku ebasa zvinogona kutanga kuchinja kushanda kwa Excel.
• Pamusoro pemashizha makuru emabasa , dzimwe nguva inobatsira kuratidza hutano hunokosha huri pamusoro pemusoro wemusoro, kwete kukumanikidza vashandisi kupfuudzira kusvika pasi pebasa rekuona kuti vaone ruzivo.

Zvinyorwa Zvinodiwa Here?

Kana zvose kana chikamu chenyaya yacho ichifanira kuratidzwa muchati kana mifananidzo, zvinogona kukanganisa kurongwa kwemashoko,

• Zvichienderana nemhando yechati, data inogona kudiwa kuiswa zvakasiyana - zvakadai sokushandura chidimbu chechikwata chepati.
• Pamapepanheti makuru, marati anogona kutamiswa kuti aparadzanise mapeji kuti adzore kuputika

Chikwangwani Chichadhindwa Here?

Nzira iyo urongwa huri kurongwa hunogona kuitika kana zvose kana zvimwe zve data zvichinyorwa, zvichienderana nekuti nharaunda kana mamiriro ekugadzirwa kwemamiriro ezvinhu anosarudzwa uye nhamba yemashizha inodiwa.

• Kana kuonekwa kwemafirimu pamusana wekunyora tsamba yakakura mapepa (8 1/2 X 11) inofanira kushandiswa, funga kuisa yakawanda yedhesi mumigwagwa pasi pemamwe mapuranga mashoma, kuitira kuti zvose zvinyorwa zvionekwe pane rimwe pepa.
• Kana mahwendefa akawanda achidikanwa, funga kudhinda chinyorwa zvinyorwa pamusoro peji rimwe nerimwe kuti uite kuverenga data nyore nyore.
• Kana mazamu akawanda e data achida kudhindwa, nzvimbo yekugadzirisa inogona kuchengeta zvinyorwa zvose pane peji rimwe. Zvakare, kana mahwendefa akawanda achidikanwa, shandisa zvinyorwa zvepamusoro pamusoro peji rimwe nerimwe.
• Kana matanhi achifanira kudhindwa, kuvamutsira kune rimwe pepa pepa rinogona kuita kuti basa rive nyore.

02 of 08

Usarega Mhemberero Mitsara kana Columns muDzimwe Dhiyabhorosi

Kusiya mitsetse isina ruvara kana mapuranga mumatafura epa data kana mazamu akaenzana e data anogona kuita kuti zvive zvakaoma kushandisa zvakanaka zvinhu zvakawanda zveExcel zvakadai semashadi, tafura dzepivot, uye mamwe mabasa.

Kunyange pasina masero mumutsara kana koromo ine data anogona kukonzera matambudziko sekuratidzwa mumufananidzo uri pamusoro.

Kusavapo kwezvivako zvisina chinhu kuchaitawo kuti zvive nyore kune Excel kuona uye kusarudza zvose zvakabatana maererano nedzimwe ruzivo kana zvinhu zvakadai sokusarudza , kutsausa, kana AutoSum zvinoshandiswa.

Panzvimbo pokusiya mitsetse isina ruvara kana mapurumoni, shandisa miganhu kana mafomati misoro uye mabhii achishandura kana kutsindira kuitira kuti aparadze data uye anoita kuti zvive nyore kuverenga.

Pinda deta yako yedhesi-akachenjera kana zvichibvira.

• Paunenge uchiisa pepa rako, ita zvinyorwa zvinotsanangurwa pamusoro pekona yekutanga yefurafura nemashoko ari pasi apa.
• Kana pane nhepfenyuro yakawanda yedheta, nyora imwe pashure peimwe mumakoroni (kuruboshwe kuenda kurudyi) ine musoro wezvikamu zvakasiyana-siyana zvepa data kumusoro.

Ramba Uine Dambudziko Risiri Rakasiyana

Kunyange zvazvo kuchengeta dambudziko rakabatana pamwe chete kunokosha, panguva imwechete, zvinogona kubatsira kuchengetedza maitiro asina kufanana e data akasiyana.

Kusiya zvinyorwa zvisina ruvara kana mitsetse pakati pezvikwata zvakasiyana-siyana zvemedhi kana mamwe mashoko pane pepa rekushanda ichaita kuti zvive nyore kune Excel kuti ione zvakanaka uye sarudza marongerwo akafanana kana tafura dze data.

03 of 08

Chengetedza Kazhinji

Kukosha kwekuponesa basa rako kazhinji hakukwanisi kudarika-kana kunotaurwa kakawanda.

Zvechokwadi, kana uri kushandisa shanduro-yebasa-yakasimudzwa - yakadai seGoogle Spreadsheets kana Excel Online - saka kuchengetedza haisi nyaya, sezvo hapana chirongwa chine chisarudzo chekuchengetedza asi, panzvimbo pezvo, shanda ne auto auto feature.

Kwemakombiyuta-based programs kunyange, shure kwekuchinja kwemaviri kana matatu - kana iri kuwedzera deta, kuita shanduko yekuchinja, kana kupinda mufomula - kuchengetedza pepa rekushanda.

Kana izvozvo zvichiita sezvakawandisa, chengetedza zvishoma pamaminetsi maviri kana matatu.

Kunyange zvazvo kugadzikana kwemakombiyuta uye kombiyuta yakavandudza zvikuru mumakore mashomanana apfuura, software yacho ichiri kuparara, kusakundikana kwesimba kunenge kuchiitika, uye vamwe vanhu dzimwe nguva vanofamba pamusoro petsvimbo yako ye simba uye vanovhomora kunze kwechikwata chemasvingo.

Uye kana zvikaitika, kurasikirwa kwemhando ipi zvayo yedhidziro - huru kana duku - kunongowedzera basa rako sezvo iwe uchiedza kugadzirisa zvawaita kare.

Excel ine motokari yakachengetedza, iyo inowanzoshanda zvakanaka, asi haifaniri kuvimbwa. Iva netsika yekuchengetedza iwe pachako deta nekugara uchiponesa.

Shortcut ku Saving

Kuponesa hakufaniri kuva basa rakaoma rokutamisa mutsara kumabhoni uye nekudhonza pazvifananidzo, pinda muitiro wekuchengetedza uchishandisa keyboard yekutsvaga kusanganiswa kwe:

Ctrl + S

Chengetedza munzvimbo mbiri

Chimwe chinhu chekuponesa icho chisingagoni kuderedzwa ndechekukosha kwekuponesa deta yako munzvimbo mbiri dzakasiyana.

Nzvimbo yechipiri ndeyechokwadi, iyo yakachengetedzwa, uye yakataurwa kakawanda, "Zvigadziro zvakafanana neshuwarisi: ivai uye iwe pamwe haungazodi, hauna imwe uye iwe uchada".

Iyo yakanakisisa yokuchengetedza imwe iri mune imwe nzvimbo yakasiyana yemuviri kubva kune yakatanga. Mushure mezvose, chii chinangwa chokuva nemapepa maviri efaira kana ivo

• iri pari imwechete dhirairi inokundikana here?
• pane imwe kombiyuta, iyo inobirwa?
• mune imwe chivako chinopisa pasi?

Mabhuku Akachengetedzwa Kwewebhu

Zvakare, kugadzirisa kuchengetedza hakufaniri kuita basa rakaoma kana rinopedza nguva.

Kana kuchengeteka kusingabhadhari - pepa rekushandisa ndiro urongwa hweDVD yako - email iwe pachako ikopi uchishandisa tsamba yewebhu kuitira kuti kopi inogara pavhavha inenge yakakwana.

Kana kuchengeteka chiri dambudziko, kusachengetwa kwewebhu kunenge kusarudzo - kunyange nekambani inonyanya kugadzirisa zvinhu zvakadaro uye inopa mari yekuita saizvozvo.

Mumamiriro ekuparadzira mapepa epaIndaneti, zvichida, varidzi vepurogiramu vanochengetedza mavharivha avo - uye izvi zvinosanganisira zvose zveseti yevashandi. Asi kuti ugare wakachengeteka, teerera kopi yefaira iwe pakombiyuta yako.

04 of 08

Usashandise Numeri seColumn Headings uye Usasanganisira Units neData

Shandisa misoro iri pamusoro pehurukuro uye panotangira mitsara yekuona deta yako, sezvo vachiita mabasa akaita sekusarudza zvakajeka, asi usashandise nhamba dzakadai sa - 2012, 2013, uye zvakadaro - kuzviita.

Sezvinoratidzwa mumufananidzo wepamusoro, mutsara uye mutsara wemisoro iyo inongova nhamba chete inogona kunge isina kuwanikwa ichibatanidzwa mukuverenga. Kana mafomu ako ane mabasa akadai se:

• AutoSum ,
• AutoMax ,
• AutoAverage .

izvo zvinongotanga kusarudza huwandu hwemashoko ehutano hwebasa.

Kazhinji, mabasa akadaro anotanga kutarisa mapurumendi emafoni pamusoro apa paanenge aripo uye kuruboshwe kune mutsara wematare, uye chero zvinyorwa zviri nhamba chete zvichange zvichisanganiswa mumutsetse wakasarudzwa.

Numeri inoshandiswa semutsara wemutsara inogonawo kukanganisa seimwe nyaya dzakasarudzwa kana ikasarudzwa sechikamu chetsanho chechati pane pane marata emazita.

Fomu nhamba mumasero ekutungamirira sekutumira kana kuumba mavara emavara nekupfuura nhamba imwe neimwe ne apostrophe (') - yakadai se'2012 uye' 2013. Apo apostrophe hairatidze muchitokisi, asi inoshandura nhamba yacho kutumira deta.

Chengetedza Unite mumusoro

Usaiti: pinda mari, kutonhora, kurema kana zvimwe zviyero mune imwe sero ine nhamba ye data.

Kana iwe uchidaro, pane mukana wakanaka wekuti Excel kana Google Spreadsheets ichatarisa data yako yese semagwaro.

Panzvimbo pacho, isa zvikamu mumusoro uri kumusoro kwei column, iyo, sezvinoitika, ichaita kuti izvo zvinyorwa zvinyorwa zvinyorwa uye hazvizogadziri dambudziko rinokurukurwa pamusoro apa.

Nyora kune Kuruboshwe, Numeri kuruboshwe

Nzira yakakurumidza yekuudza kana iwe une mavara kana nhamba yedata ndeyekutarisa kuenzaniswa kwedata iri muchitokisi. Nekusavapo, deta data yakanamirwa kuruboshwe mu Excel neGoogle Spreadsheets uye nhamba ye data inowirirana nekodzero muchitokisi.

Kunyange zvazvo kuenzaniswa kusina kuchinja kunogona kuchinjwa nyore nyore, kuisa maitiro hakusi kushandiswa kusvikira mushure mekunge data yose uye mazano ashandiswa, saka kusagadzikana kwekugadzirisa kungakupa chiziviso kare pane chimwe chinhu chakashata mubasa remabasa.

Percent and Currency Symbols

Nzira yakanakisisa yekupinda yese dheta mubhuku rekushanda ndeyokupinda nhamba yefa imwe chete uye fomisa sero kuti iratidze nhamba zvakanaka-uye izvi zvinosanganisira zvikamu uye mari yakawanda.

Excel uye Google Spreadsheets, zvisinei, vanobvuma mazana zviratidzo zvinoshandiswa muchitokisi pamwe chete nenhamba uye vose vari vaviri vanozivawo zviratidzo zvemari yakafanana, sechiratidzo chemadhora ($) kana kuti british pound chiratidzo (£) kana vakanyorwa mu sero pamwe nenhamba yedata, asi mamwe emari zviratidzo, zvakadai seSouth African Rand (R), zvingangodudzirwa semashoko.

Kuti udzivise zvinetso zvinogona kuitika, tevera zvinotaurwa pamusoro apa zvakanakisisa uye pinda muwandu uye wobva waisa sero kuti uwane mari pane kuisa mufananidzo wekuda mari.

05 of 08

Unoshandisa Cell References uye Zita Rakatorwa muMafomu

Zvose zviyero zvemasero uye mazita akasiyana-siyana zvinogona kuva uye dzinofanira kushandiswa nenzira yekuita kuti zvikurumidze uye zviri nyore kuchengetedza mazano uye nekuwedzera, pepa reese rega, kusina zvikanganiso uye kusvikira zvino.

• Maferensi emasero inobatanidza tsamba yerineni uye mutsara nhamba yesero - yakadai seA1, B23, uye W987 - uye inoshandiswa kuzivisa nzvimbo ye data mune pepa rekushanda.
• A zita rakarongeka kana zita rinotsanangurwa rakafanana neshoko rinoshandiswa mukati maro zvokuti rinoshandiswa kuzivisa sero kana rutivi rwemasero mune pepa rekushanda.

Referencing Data in Form

Mafomu anoshandiswa muExcel kuti aite zviyero - zvakadai sekuwedzera kana kubvisa.

Kana nhamba chaiyo inowanikwa mune mafomu - akadai se:

= 5 + 3

Nguva imwe neimwe iyo data ichishandura- inotaura ku7 ne6, iyo yakarongwa inofanira kuchinjwa uye nhamba yacho yakashandurwa kuitira kuti chirevo chive:

= 7 + 6

Kana, pane kudaro, iyo data inopinda mumasekeri mune pepa rekushanda, zvinyorwa zveseti - kana mazita ekuronga - zvinogona kushandiswa mumutauro panzvimbo pehuwandu.

Kana nhamba ye5 inopinda muchitokisi A 1 ne3 muchitokisi A2, chimiro chinova:

= A1 + A2

Kuti uvandudze data, shandura zviri mukati memasero A1 neA2, asi fomu yacho inoramba yakangofanana - Excel inongorongedza mhinduro yefomu.

Kuchengetwa kwekufamba kwenguva nekuedza kunowedzerwa kana pepa rekushandira rine zvinyorwa zvakaoma uye kana maverengero akawanda achitaura imwechete data sezvo data inoda kungoshandiswa pane imwe nzvimbo uye mazita ose anoitaura ichavandudzwa.

Kushandisa zvinyorwa zvitsanangudzo kana mazita akasiyana-siyana zvinoitawo kuti pepa rako rekuchengeteka rive rakachengeteka, sezvo richikubvumira kuti udzivirire mafomu kubva pakuchinja kwekukanganisa paunenge uchisiya masero e data anoshandura kuwanika.

Kutaura paData

Chimwe chikamu cheExcel neGoogle Spreadsheets ndechokuti vanokubvumira kupinda ma cell reference kana mazita emararamiro mumashonga achitsanangura -zvinosanganisira kuvhara pane imwe sero kuti uise zvinyorwa mumutambo.

Kutaura kunoderedza kukanganisa kwezvikanganiso zvakakonzerwa nokunyora mune zvisina kururama seferensi rekutsvaga kana kusafuratira zita remhando.

Shandisa Mazita Akarongerwa Kusarudza Data

Kupa nzvimbo yezita rakaganhurana zita rinogona kuita kuti zvive nyore nyore kusarudza data kana uchiita maitiro kana kuisa maitiro.

Kana uwandu hwenharaunda huchichinja, huwandu hwezita rinogona kushandiswa nyore nyore achishandisa Mutariri weZita .

06 of 08

Usarega Makero Aine Zvimwe Zvisina Kudzivirirwa

Mushure mokupedza nguva yakawandisa kuwana maitiro avo akajeka uye vachishandisa yakakodzera masero ezvinyorwa, vanhu vazhinji vanoita chikanganiso chekusiya maitiro aya anowanzokonzerwa nekukurumidza kana kuchinja nemaune.

Nokuisa deta mumasero mubasa rekushandura uye kurondedzera iyo data mumashonga, inobvumira masero ane zvinyorwa kuti akavharwa uye, kana zvichidiwa, password yakachengetedzwa kuti igare yakachengeteka.

Panguva imwecheteyo, masero ane data anogona kusara asina kuzarurwa kuitira kuti kuchinja kunogona kuiswa nyore kuitira kuchengeta spreadsheet kusvika zvino.

Kuchengetedza pepa rekushanda kana bhuku rebhuku inyaya mbiri:

1. Iva nechokwadi chokuti iyo yakakodzera masero akavharwa
2. Isa chidziro chekuchengetedza chisarudzo - uye kana chichidiwa, wedzera izwi

07 of 08

Ita Zita Dzako

Rongedza deta yako mushure mekunge wapedza kupinda iyo.

Kushanda nemataundi mashoma esingafambidzwi muExcel kana Google Spreadsheets haisi kazhinji dambudziko, asi sezvo nhamba ye data inowedzera saka zvinonetsa kushanda nayo zvakanaka.

Dhidhiyo yakarongwa zviri nyore kunzwisisa uye kuongorora uye mamwe mabasa uye zvishandiso, zvakadai seVLOOKUP uye SUBTOTAL inoda deta rakarongwa kuitira kuti idzorere mhinduro dzakarurama.

Uyewo, kusarudza deta yako nenzira dzakasiyana kunogona kuita kuti zvive nyore kuona maitiro asina kuonekwa pakutanga.

Kusarudza Dhidzi Rinofanira Kurongwa

Dare risati ragona kugadziriswa, Excel inoda kuziva ruzivo rwakananga ruchagadziriswa, uye kazhinji, Excel yakanaka chaizvo pakusarudza nzvimbo dzedunhu rakabatana-chero bedzi painenge rapinda,

1. hapana mitsara isina kana mahwendefa yakasara mukati memunharaunda yakabatana;
2. uye mitsetse isina kuvhara uye misoro yakasara pakati penharaunda ye data yakabatana.

Excel ichasarudza kunyange, zvakarurama chaizvo, kana nzvimbo ye data ine mazita emumunda uye isabvisa rutsara urwu kubva pane zvinyorwa zvinofanira kusarudzwa.

Zvisinei, kubvumira Excel kukasarudza mararamiro okugadziriswa kunogona kuva mungozi - kunyanya nehuwandu hwemashoko akaoma kutarisa.

Kushandisa Mazita kuChina Data

Kuti uone kuti iyo yakakodzera data yakasarudzwa, tsanangurira huwandu usati watanga mararamiro.

Kana rutivi rwakadaro rwuri kurongedzwa kakawanda, nzira yakanakisisa ndeyokupa iyoName.

Kana zita rinotsanangurwa kuti urongwa hutsanangurwe, tanga zita racho muBhokisi Razita , kana kuti riisarudze kubva pane rakaderedzwa pasi rakanyorwa uye Excel richakurumidza kujekesa mararamiro akaenzana ezvinyorwa mubhuku rekushanda.

Ridhi Rows and Columns and Sorting

Mitsetse yakavanzwa uye mapoka ehurukuro haatauri panguva yekusarudza, saka inofanirwa kushandiswa asati aitika.

Somuenzaniso, kana mutsetse 7 wakavanzwa, uye chikamu chehuwandu hwemashoko akagadziriswa, hunoramba huri mutsetse 7 pane kutamirwa kunzvimbo yakarurama sechikonzero chechimiro.

Izvo zvinoenda kune zvikamu zve data. Kuronga nemitsetse kunosanganisira kugadzirisa mazamu ematafura, asi kana Kovha yeBh yakavanzwa isati yasvika, icharamba iri seChitamende B uye isingadzoserwi nemamwe mapuranga muurongwa hwakatarwa.

08 we 08

Zvose Numeri Inofanira Kuva Zvitoro seNumeri

Nyaya: Tarisai kuti nhamba dzose dziri kuchengetwa se nhamba. Kana mhinduro yacho isiri izvo zvaunotarisira, iyo korome inogona kunge ine nhamba dzakachengetwa sezvinyorwa uye kwete se nhamba. Semuenzaniso, nhamba dzisina kunaka dzakatumirwa kubva kune mamwe maitiro ekugadzirisa kana nhamba inowanikwa nekutungamirira '(apostrophe) inochengetwa semashoko.

Kana iwe ukakurumidza kusarudza deta neA AZ kana ZA bhoja, zvinhu zvinogona kuenda zvakashata zvakashata. Kana pane mutsara usina ruvara kana asina mahwendefa mukati mematare, chikamu che data chinogona kurongedzwa, asi imwe dhesi isingabvunzwi. Fungidzira marara aunenge uine, kana mazita uye nhamba yefoni zvisingachagoni kufanana, kana kana mirairo ichienda kuvanhu vasina kunaka!

Nzira iri nyore kuti uone kuti mararamiro akaenzana e data akasarudzwa asati asarudza ndekupa Zita.

Mhedziso yechipiri inobata chaizvo izvo zvinonzi Excel. Kana iwe uine sero rimwe rakasarudzwa, Excel inosarudza kusarudza kusarudza hurefu (zvakadai sokudzvinyirira Ctrl + Shift + 8) yakabatanidzwa nemumwe kana kuti zvinyorwa zvisingatauri nemiromo. Icho chinoongorora mutsara wokutanga mumusara wakasarudzwa kuti uone kana ine musoro wekasi kana kwete.

Iyi ndiyo iyo kusarudza nechekushandisa zvigadziri zvingave zvinyengeri-musoro wako (uchifunga kuti une imwe) inosangana nemimwe mirayiridzo yakaoma kuitira kuti Excel kuiziva seyo musoro. Somuenzaniso, kana paine chero masero mashoma mumutsara wepamusoro, Excel inogona kufunga kuti haisi musoro. Saizvozvowo, kana mutsara wepamusoro wakarongedzwa zvakafanana nemamwe mitsara mumatafura e data, zvino zvingasazviziva. Uyewo, kana tafura yako yedhadha ine zvinyorwa zvachose uye mutsara wako wepamusoro hauine chinhu kunze kwemashoko, Excel icha-nguva dzose nguva-kusakwanisa kuziva mutsara we musoro. (Mutsara unoratidzika seimwe mutsara we data kuExcel.)

Kungoga mushure mokusarudza mararamiro uye kusarudza kana kune mutsara we musoro iyo Excel ingangodaro yakaronga. Iwe unofara sei nemigumisiro inobva pakuti kana Excel yakava nekusarudza kwepamusoro uye mutsara wepamusoro wekururamisira zvakarurama. Somuenzaniso, kana Excel isingafungi kuti une mutsara wepamusoro, uye iwe unoita, ipapo musoro wako wakarongwa mumuviri we data; izvi kazhinji chinhu chakaipa.

Kuti uoneke kuti dheta rako re data rakanzwisiswa zvakanaka, shandisa nzira yeCtrl + Shift + 8 kuti uone kuti Excel inosarudzai; ichi ndicho chichagadziriswa. Kana ikasaenderana nemitarisiro yako, iwe unofanirwa kuchinja unhu hwe data iri mutafura yako, kana iwe unofanirwa kusarudza dhenda rekushandisa usati washandisa Hurongwa hwebhokisi yebhokisi.

Kuti uoneke kuti musoro wako unozivikanwa zvakanaka, shandisa nzira yeCtrl + Shift + 8 kuti usarudze ruzivo rwemashoko, zvino tarisa mutsara wokutanga. Kana musoro wako usina chinhu masero pakati peavo vakasarudzwa mumutsara wokutanga kana mutsara wokutanga wakarongedzwa semutsara wechipiri, kana iwe une mutsara wepamusoro unotsanangurwa, ipapo Excel inotora iwe usina mutsara wepamusoro zvachose. Kugadzirisa izvi, ita shanduko mumutsara wako wepamusoro kuti uone kuti inozivikanwa zvakanaka neExcel.

Pakupedzisira, mabheji ose anogona kunge aripo kana tafura yako yedhadha iko kushandisa mutsara wepamusoro-soro. Excel ine nguva yakaoma yekuzviziva. Iwe unowedzera dambudziko apo iwe unotarisira kuti iise mitsetse isina kuvhara mumusoro iyo; hazvigoni kuzviita zvakananga. Iwe unokwanisa, zvisinei, unongosarudza mitsetse yose yaunoda kugadzirisa usati waita rudzi. Mune mamwe mazwi, taura zvakananga pane zvaunoda kuti Excel iite; musarega Excel ichiita mafungiro enyu.
Dhesi Nenguva Dzakachengetwa seMagwaro

Kana migumisiro yekutsvaga nezuva isingashandisi sezvinotarisirwa, iyo data iri mumutsetse ine chinyorwa chinogona kunge ine mazuva kana nguva dzakachengetwa semashoko ekunyora panzvimbo pane nhamba (mazuva uye nguva dzakangoshandiswa nhamba yedata).

Mumufananidzo wepamusoro, nhoroondo yeA. Peterson yakaguma pazasi kwerwendo, apo, zvichibva pazuva rekubhadhara - November 5, 2014 -, rekodhi yacho inofanira kunge yakaiswa pamusoro pezvinyorwa zve A. Wilson, iyo zvakare ine zuva rakakwereta raNovember 5.

Chikonzero chemigumisiro isingatarisirwi ndeyokuti zuva rakakwereta kuna A. Peterson rakachengetwa semashoko, panzvimbo pekuverenga
Mixed Data uye Quick Sorts.

Paunenge uchishandisa nzira yakakurumidza yemhando yezvinyorwa zvine mashoko uye nhamba ye data zvakakanganiswa pamwe chete, Excel inoshandisa nhamba uye nhamba yezvinyorwa zvakasiyana-siyana - kuisa zvinyorwa nemashoko ekunyora pasi pasi pezita rakarongwa.

Excel inogonawo kusanganisira mutsara wehurukuro mumigumisiro yemhando - kuidudzira ivo seimwe mutsara wemashoko ekunyora pane kufanana nemazita emumunda etafura ye data.
Rongedza Manyevero - Sarudzai Bhokisi Remutauro

Sezvinoratidzwa mumufananidzo wepamusoro, kana Hurukuro yebhokisi yebhokisi iri kushandiswa, kunyange kune marudzi pane imwe korombo, Excel inoratidza mharidzo inokuyambira kuti yakasangana nemashoko akachengetwa semashoko uye inopa iwe sarudzo ku:

Ronga chero chinhu chinoratidzika senhamba sehamba
Rongedza nhamba uye nhamba dzachengetwa sezvinyorwa zvakasiyana

Kana ukasarudza sarudzo yekutanga, Excel ichaedza kuisa dhidhiyo dhesi panzvimbo yakakodzera yemigumisiro yakadaro.

Chisarudzo chechipiri uye Excel ichaisa zvinyorwa zvine dhiyabhorosi data pasi pemigumisiro yemhando - sezvinoitwa nemitambo yakakurumidza.