Kushanda matafura "Excel": danho nedanho instructions, zvinhu uye vanorumbidza

Most vanoshandisa makombiyuta musi Windows hurongwa papfungwa yakatarwa kuti Microsoft Office uchapisika atarisana MS Excel kushanda. In ruzivo vanoshandisa chirongwa kunokonzera vamwe nematambudziko kukura, asi kushanda "Eksele" pamwe Masvomhu nematafura hazvisi zvokuti zvakaoma sezvo zvingaita sokuti pakutanga aitarire, kana uchiziva dzinokosha vakaisa pasi mupanda.

Chii Excel?

Nekupedza Excel munhu wakakwana kwemasvomhu muchina kuita muzvizhinji kuti svomhu, algebraic, trigonometric, uye vamwe akavhiyiwa zvikuru kunzwisisa nokuita kushanda akawanda inokosha mashoko nemifananidzo, hazvina nguva dzose ukama masvomhu.

Kushanda matafura "Excel" rinoreva kushandiswa mikana yakawanda pamwe uye kadambari, uye bani rugwaro, uye Multimedia. Asi ayo chimiro chirongwa yepakutanga yakanga akasikwa zvakananga somunhu kwemasvomhu mupepeti simba. Zvisinei, vamwe, tora rokutanga chikumbiro chipi karukureta pamwe yemhando zvinhu. Chakadzama kukanganisa!

Jobs "Eksele" pamwe tafura beginners: kutanga kuziva inowanikwa

Danho rokutanga pashure kuzarura chirongwa, inodzidzisa anoona chikuru hwindo, rine dzinokosha chidhiraivho uye midziyo basa. In akazotevera shanduro hwindo rinowanika kana watanga kushanda, izvo proposes kuti pave faira idzva, ne default inonzi "Book 1" kana kusarudza template mamwe matanho.

Kushanda "Excel" spreadsheet nokuda beginners pachikuva wokutanga kuziva chete chirongwa anofanira kungoitirwa kunyatsoreva chinhu tafura kusika. Patinenge funga zvinokosha.

Main munda inoremekedzwa tafura pacharo, iro rakakamurwa masero. Mumwe vakaverengwa, nemhaka maviri-dimensional Coordinates - rwonzi nhamba uye mbiru tsamba rokuti (somuenzaniso, kutora Excel 2016). vakaverengwa Izvi zvinodiwa kuti mune nzira dependencies zvakajeka aigona havatsananguri chaizvo sero data, kushanda izvo zvichashandiswa akabudiswa.

Kubva kumusoro, sezvo mune dzimwe muhofisi zvikumbiro, pane eDare huru Muterere, uye chete pazasi - Ezvemutauro. Pasi payo pane mutsetse chairo apo iwe kupinda yemaitiro, uye zvishoma kuruboshwe unogona kuona hwindo pamwe Coordonatele ari parizvino basa sero (ndiro rectangle). Bottom emadziro rinoratidza machira uye zvido zvevanhu kwebasa mubato, uye pasi payo vari bhatani mhando chinja uye Zoom. Kurudyi ari wehunyambiri kanyika pamusoro jira kuti kwira / pasi.

Mhando inokosha date chiyamuro oparesheni uye majemusi

Pakutanga, zvinofungirwa kuti basa iri "Eksele 'matafura kubudikidza inodzidzisa kuti beginners kujaira narwo yaizivikanwa kushandiswa, somuenzaniso zvakafanana murugwaro mupepeti Shoko.

Senguva dzose, netafura anogona kuita kopi oparesheni, kana kuzvicheka muwedzero data, kupinda rwezuva kana Numeric mashoko.

Asi vachiisa zvishoma vakasiyana munhu akaita murugwaro vapepeti. Chokwadi chokuti chirongwa iri pakutanga configured kuti vapiwa kuziva inodzidzisa kunonyora iri kushingaira muchitokisi. Somuenzaniso, kana mapinda tambo 01/02/2016, humboo chichange kuzivikanwa somunhu zuva, uye muchitokisi panzvimbo akapinda nhamba chichava zuva ari nyore muchimiro - 02/01/2016. Change kuratidzwa youduku inogona nyore (pana kuti gare gare).

Uye saka zvakaita nhamba. Unogona kupinda chero Numeric data, kunyange ane zvemasanga uwandu grade nzvimbo, uye ivo vachava uratidzwe muchimiro umo vose anoshandiswa kuona. Asi, kana iwe kupinda imwe integer, zvichava kupiwa pasina mantissa (grade nzvimbo sezvo zeros). Change Zvinogonekawo.

Asi iwe apera, vakawanda ruzivo vanoshandisa vari kuedza kutamira inotevera sero uchishandisa kiibhodhi museve kiyi (zvakafanana sei zvinogona kuitwa muShoko matafura). Uye zvikasashanda. Sei? Asi chete nokuti basa ne "Excel" spreadsheet akasiyana chinyorwa mupepeti Shoko zvikuru yekudyidzana. Kuchinja kunogona kuitwa vachisundira Kupinda huru kana nokuzvisarudzira zvinoshingaira rectangle mumwe sero nokushandisa rworuboshwe mbeva watinya. Kana anyora chinhu ari kushingaira muchitokisi, wokudhinda Esc, chiyamuro zvichabviswa wacho.

Zviito pamwe machira

Kushanda machira pakutanga kukonzera matambudziko havafanire. Pasi pemapuranga ane wedzera bhatani machira pashure kudzvanya iyo ichava itsva tafura otomatiki kuchinjirwa pazviri uye chaiyo ine zita ( "Sheet 1", "Page 2", uye zvichingodaro. D.).

Double-watinya, unogona Activate ari renaming mumwe wavo. Uyewo, kurudyi-watinya Muterere zvinogona kushandiswa dzindodana wokuwedzera Muterere, apo pane zvishoma mirayiro inokosha.

zvinogona masero

Zvino chinhu chinonyanya kukosha - sero pamanyorerwo - mumwe inokosha pfungwa, riri chii chinoratidza mhando date dzichashandiswa nokuda kuziva zviri mariri. Calling nemanyorerwo fora zvinogoneka kuburikidza kurudyi-watinya Muterere, apo mutsetse yakakodzera anosarudzwa kana nokutsikirira F2.

The hwindo kuruboshwe inoratidza zvinogona zvose zvinowanikwa, uye kodzero rinoratidza nzira kuti mashoko kuratidza. Kana iwe tarisa muenzaniso pamwe musi pamusoro apa, sezvo pamanyorerwo anosarudzwa, "Date", uye kodzero yokugadza aida chimiro (somuenzaniso, 1 February 2016).

zvimwe zvinogona anogona kushandiswa kuita kwemasvomhu amabasa, asi ari nyore nyaya, sarudza Number. Kurudyi, pane mhando dzakawanda chiyamuro, mumwe Pointer nokuwanda digits mushure grade pfungwa iri mantissa mumunda uye kuisa rimwe boka separator. Kushandisa dzimwe Numeric zvinogona (exponential, fractional, mari uye zvichingodaro. D.), Uyezve, anogona kuiswa zvinodiwa parameters.

By default, otomatiki mashoko Kuzivikanwa kuisa chimwe format. Asi kana iwe kutaipa netsamba shomanana kana chirongwa anogona nomuzvarirwo kuichinja zvimwewo. Naizvozvo, kupinda rwezuva yezviri musero zvakafanira kuisa akakodzera kuzvipedza.

Kushanda "Excel" pamwe Masvomhu (tafura): Example

Pakupedzisira, mashoko mashoma pamusoro Masvomhu. Nokuti kutanga, ngatikurukurei muenzaniso Verengai nhamba mbiri muna A1 uye A2. Chikumbiro zvinosanganisira otomatiki summation bhatani pamwe mamwe mabasa (dzemaitirwe ari svomhu zvinoreva kunonyanyisa, zvishoma, uye zvichingodaro. D.). Simply kuisa basa sero riri chete mbiru, pazasi, uye kusarudza mari zvicharangarirwa kuverengwa kwaita. Zvakafanana mabasa nokuda chinjikira tsika, asi basa muchitokisi kusvikira mari unofanira kuisa zvakanaka.

Asi iwe unogona kupinda nzira yemaitiro manually (basa ne matafura "Excel" uye zvinoratidza zvinogona kana otomatiki oparesheni haina inopiwa). Nokuti zvakaenzana vanofanira kuva nzira nomuzariro kuti inofananidza uye taurira kushanda A1 + A2 kana pachiyero (A1; A2), uye kana uchida tsanangurai zvakawanda masero, shandisa fomu pashure chiratidzo wakaenzana: (A1: A20), pashure pacho vachatitaka It anoti Verengai vose nhamba masero kubva pakutanga kusvika maviri, zvichibatanidzwa.

Charting

Kushanda matafura "Excel" Zvinoshamisawo pakuti inosanganisira kushandisa inokosha zvoga mudziyo Plotting uye chati inobva yasarudzwa siyana.

Nokuti chinangwa ichi, chaiyo bhatani pamusoro pemapuranga, pashure nekudzvanya pamusoro paunogona sarudza chero parameters kana achida ngaaone. Zvadaro, chati kana girafu akaratidza pamusoro jira ive mufananidzo.

Cross-kubatana, mashoko imupota uye ekisipoti

Chirongwa anogona gadza date kutaurirana dzimwe machira akasiyana, shandisa okutarisawo vamwe Manyorerwo mafaira kana zvinhu servers paIndaneti, uye vazhinji nevamwe wedzera-Ons.

Uyezve, Excel mafaira zvinogona aivigirwa kune dzimwe zvinogona (semuenzaniso, PDF), kutevedzera mashoko kubva kwavari, uye zvichingodaro. D. Asi chirongwa anogona kuzarura mafaira zvakasikwa mune dzimwe mafomu (chinyorwa zvinogona, Databases, Web mapeji, XML- magwaro, uye zvichingodaro. d.).

Sezvaunogona kuona, yaaizova dzinenge risina parinogumira mupepeti. Uye, chokwadi, kurondedzera zvose hadzisi nguva yakakwana. Heano zvinokosha kutanga, asi vaifarira User vachafanira kuverenga mashoko okuwedzera, kuti tenzi chirongwa panguva soro chechetere.