Sei kudzidza kushanda muna Excel pachako: tsananguro chepurogiramu, vanorumbidza uye wongororo

munhu upi kushandisa kombiyuta yavo nezuva basa, imwe nzira kana imwe nemamiriro Excel hofisi zvikumbiro akabatanidza mureza Microsoft Office pasuru. Inowanika mushanduro dzose pasuru. Uye kazhinji, sezvo kujairirana chirongwa, vazhinji, vanoshandisa vari kushamisika sei kudzidza kushanda vakazvimiririra vari Excel?

Chii purogiramu Excel?

Kutanga kutsanangura chinonzi Excel, uye nei uchifanira Anwendung ichi. Zvimwe vakawanda vakanzwa kuti chirongwa ari spreadsheet mupepeti, asi nheyo yayo inoshanda Evhangeri yemvura noMweya ndiyo matafura avo vakasikwa muShoko.

Kana tafura Shoko anoita zvakawanda chaikosha dzinoratidza chinyorwa uye graphical ruzivo, jira Excel spreadsheet - iri, Chokwadi, rakabatana kwemasvomhu muchina, iyo inokwanisa kubudisa dzakasiyana-siyana kadambari kwakavakirwa yakajeka date mhando uye Masvomhu, ichazovapo mumwe kana zvimwe kwemasvomhu kana algebraic oparesheni.

Sei kudzidza kushanda vakazvimiririra vari Excel uye anogona here zviitwe?

Sezvakareva heroine pamusoro firimu "Office Romance", anogona uye netsuro kudzidzisa kusvuta. Pfungwa, hapana hazviiti. Edza kunzwisisa zvinodiwa zvinokosha kushanda kushanda uye ichanyanya pamusoro kunzwisisa zvayo zvinokosha zvinhu.

Chokwadika, vanhu chaivo aiziva chaizvo chikumbiro, achiti kuti zvinokwanisika Somuenzaniso Zvisinei kukopa vamwe Tutorial basa kupinda Excel,, sezvo tsika inoratidza uye kunyanya mhinduro ruzivo vanoshandisa, zvinhu zvakadai vanowanzoratidzwa mu zvakare abstruse chimiro, uye zvinogona kuva zvakaoma kunzwisisa.

Kunenge kuti zvakanakisisa kudzidza kusarudza richava kudzidza chikuru zviri purogiramu, uye ipapo kushandisa navo, saka kutaura, "imwe bheji akadzidza." Zviri pachena kuti unofanira kutanga kufunga inokosha functionality pakati Microsoft Excel zvinhu (zvidzidzo zviri chirongwa zvinoratidza kuti nezvazvo), kuti iwe uve mufananidzo wakakwana basa dzemitemo.

Huru zvinhu zvinoda dzako

Chinhu chokutanga inotiratidza inodzidzisa apo chikumbiro yatanga, mazita ichi sezvo tafura, umo dziri muchitokisi vakaverengwa dzakasiyana, zvichienderana shanduro chikumbiro. Mushanduro mbiru varehwa tsamba uye mutsetse Nhamba uye nhamba adarika. Other zvabudiswa ose nyora yakapiwa chete mune digitaalinen chimiro.

Ko sei? Hongu, chete kuti nguva dzose kukwanisa kuona sero nhamba kuti tsanangurai imwe mhando kukarukureta sei wakaisa Coordonatele ari maviri-dimensional hurongwa kusvikira. Gare gare, zvichava pachena sei kuti kushanda navo.

Chimwe chikamu chinokosha - ari nzira pakapuranga - chaiyo munda, abva «add _X» kuvake. Zvakanga pano kuti rinotsanangurwa kushandiswa zvose. Uyezve, akavhiyiwa izvi kwemasvomhu zvinoratidzwa saizvozvo sezvazvakanyorwa unogamuchirwa munyika dzakawanda kupatsanura (chiratidzo yakaenzana "=", chokuwanziridza "*" kupesana "/", etc.). The trigonometric tsika uyewo anoenderana dzakawanda mazita (chivi, Kosi, nkm, etc.). Asi zviri nyore chaizvo. Operations kuoma zvichaita kuva kuburikidza bhuku gadziriro kana mienzaniso yakananga, sezvo vamwe payakavakirwa vangatarira kunyatsonanga chaizvo (exponential, theorem, tensor, chizvaro, etc.).

Kubva kumusoro, sezvo zvimwe Office mapurogiramu Nde emadziro uye huru Muterere zvinhu huru kushanda mabhatani uye nokukurumidza kuwana imwe ushande.

Mhando date uye nyore kushanda navo

Kukurukura sei kushandira Excel-chirongwa, hazvibviri pasina kunzwisisa mhando kiyi nemashoko wapinda tafura mumasero. Just dzinoti kuti pashure varwere mamwe mashoko, unogona achizviendesa kupinda kiyi, Esc kiyi, kana kungoita kufambisa rectangle yacho achida muchitokisi chimwe - umboo inochengeterwa. Editing kamuri ne miviri-nekudzvanya kana nokutsikirira F2, uye pamusoro kupedziswa kuchengeta mashoko kuva chiyamuro chete kana unopfuurira Enter.

Zvino mashoko mashomanana kuti zvingaonekwa akapinda muchitokisi chimwe nechimwe. Format Muterere naro nokusarurama-nekudzvanya pamusoro zvinoshingaira muchitokisi. Kuruboshwe pane chinokosha mbiru pamwe date mhando (general, Numeric, chinyorwa, muzana, zuva, etc.). Kana wasarudza talk format, purogiramu, nehasha kutaura, pacharo anosarudza kuti akaita kukosha wakapinda (somuenzaniso, kana iwe kutaipa 1/1/16 achapiwa kuzivikanwa, kubudikidza musi 1 January 2016).

Kana vachipinda nhamba ungashandisa kutaridzwa nhamba grade nzvimbo (default unoratidzwa mumwe hunhu, asi kana mapinda chirongwa vaitenderera maviri chete pachena kukosha, kunyange vechokwadi haachinji).

Kana kushandisa, itii, rugwaro Data mhando kuti inodzidzisa haana apinda, chichagamuchirwa kuratidzwa chaizvo sezvo zviri vataipa pamusoro keyboard, pasina chinhu kuchinja.

Pano ndizvo inyaya: kana iwe kutamisira cursor kuti sero kusarudzwa panzvimbo dzapasi rworudyi kukona muchinjikwa achaonekwa, riri kudhonza apo wakabata rworuboshwe mbeva bhatani, unogona kutevedzera mashoko ari zvinotevera kuti muchitokisi achida. Asi Data zvichachinja. Kana isu kutora muenzaniso iwoyo pamwe musi, rinotevera ukoshi kucharatidzwa musi waJanuary 2, etc. kungatonziwo kwakadaro rinokosha kana kuisa chete zvokuimba kuti masero siyana (uye dzimwe nguva kunyange muchinjikwa Masvomhu).

Kana isu nezvazvo Masvomhu unogona kushandisa hunyambiri nzira nokuda nyore mashandiro. Somuenzaniso, nokuti Verengai A1 uye masero B1, izvo zvinofanira dzaona muchitokisi C1, zvakakodzera ndokuisa ari rectangle C1 munda uye akaisa kukarukureta payakavakirwa «= A1 + B1». Unogona kuita kudaro, inopiwa payakavakirwa "= Verengai (A1: B1)» (nzira iri kushanda makuru nemaburi masero, kunyange ungashandisa otomatiki summation, uyewo Chirungu shanduro Verengai Verengai murayiro).

Excel chirongwa: sei kushanda Excel machira

Kana tichishanda mashizha zvinogona siyana zvokuita: kuwedzera machira, kushandura zita ravo, zvinomuomera kuikanganwa zvisingakoshi etc. Asi chinonyanya kukosha ndechokuti chero masero kuti dziri machira akasiyana kunogona kuva kune chokuita nedzimwe Masvomhu (kunyanya kana yakawanda marudzi mashoko akapinda).

Sei kudzidza kushanda Excel pachako kushandisa okutarisawo uye Masvomhu? Hazvisi nyore. Sezvo inofambiswa kubva vanoshandisa, kamwe pakugona tafura mupepeti, ita pasina rubatsiro ichava zvakaoma. Unofanira kuverenga kupfuura rubatsiro gadziriro yacho. Nzira iri nyore chinotarisirwa mune imwe nzira masero nokuda kusarudzwa kwavo (zvinogona kuitwa jira chete, uye pamusoro zvakasiyana. Uyezve, kana dzakabatwa uwandu muminda kakawanda, zvinokwanisika kuti kunyoresa "= Verengai", uye ipapo anongoti Anovhura clamped anokosha Ctrl govera hunokwanisa masero. Asi ichi ndicho muenzaniso kupfuura chinyakare.

mamwe Features

Asi chirongwa haagoni chete kusika matafura nezvirwere akasiyana mashoko. Zvichienderana navo vaviri mumasekonzi, unogona kuvaka zvemarudzi ose calculators nemachati nokubvunza kuti otomatiki kuvakwa yasarudzwa chikuva masero, kana tsanangurai nayo manually kana kupinda runoenzanirana Muterere.

Uyezve, chirongwa anokwanisa kushandisa wedzera-Ons, executable mumanyoro yakavakirwa Visual Basic. Unogona pinza chero zvinhu muchimiro Graphics, mavhidhiyo, makaseti kana chimwe chinhu. Kazhinji, kushaya mikana. Uye pano anonetseka chete chiduku chikamu zvose anokwanisa nemamwe chirongwa ichi.

Asi chii kutaura, ndizvo zvakarurama nzira iri kuverenga chizvaro kugadzirisa equations siyana upi kunzwisisa, kuwana kunyanyisa mitambo pakusika Database uye kushamwaridzana navo nevamwe mafomu akadai Microsoft Access, uye zvakawanda - chete kwete kuverengwa.

mugumisiro

Zvino, zvichida, zviri pachena kuti mubvunzo sei kudzidza kushanda muna Excel pachavo, hazvina kudaro uye nyore kubata nadzo. Chokwadi, kana ukadzidza dzinokosha basa iri mupepeti, akaisa dzinokosha akavhiyiwa havana kushanda. User ongororo zvinopupurira kuti zvinobvira kudzidza vaifanira vhiki imwe. Asi kana uchida kushandisa Masvomhu zvikuru kunzwisisa, uye zvakatonyanya kudaro, basa achitaura kuti Database, sokunge vasingade hapana mabhuku anokosha kana kosi nyore kuita. Uyezve, zviri zvichida chaizvo kuti gondo kunyange ruzivo rwavo nemasvomhu uye geometry kubva kosi chikoro. Pasina izvi, kushandisa tafura mupepeti yakazara havana kunyange kufungidzira.