Kanjani ukuze ufunde ukuthi usebenze nge-Excel ngokwakho: incazelo yohlelo, izincomo kanye nokubuyekeza

Noma yimuphi umuntu usebenzisa ikhompyutha emsebenzini wabo wansuku zonke, ngandlela-thile enobuso obuncane Excel ehhovisi izicelo kufakwe ejwayelekile iphakethe-Microsoft Office. Itholakala kuwo wonke izinguqulo iphakethe. Ngokuvamile, njengoba ujwayele hlelo, abaningi, abasebenzisi uyazibuza kanjani ukufunda ukusebenza ngokuzimela Excel?

Luyini uhlelo Excel?

Ukuqala ukuchaza ukuthi yini i-Excel, futhi kungani udinga lolu hlelo lokusebenza. Mhlawumbe abaningi nizwile ukuthi uhlelo umhleli isipredishithi, kodwa imithetho kusebenta kwato ngokuyisisekelo sihluke kulabo amatafula wadala eZwini.

Uma etafuleni Igama izenzo isici ngaphezulu elibonisa umbhalo kanye nokwaziswa sokuqhafaza, ishidi Excel-spreadsheet - is, eqinisweni, umshini esihlanganisiwe zezibalo, okuyinto akwazi ezihlukahlukene Computing esekelwe kuchazwa izinhlobo idatha amafomula, okuzokwenza kube nguwe noma ezinye ukusebenza zezibalo noma we-Aljibhra.

Kanjani ukufunda ukusebenza ngokuzimela Excel futhi kungase kwenziwe?

Njengoba kusho Heroine we ifilimu "Ihhovisi Romance", ungakwazi nonogwaja ukufundisa ukubhema. Ngomqondo onabile, akukho engenakwenzeka. Zama ukuqonda izimiso eziyisisekelo ukusebenza isicelo futhi sizogxila ukuqonda izici eziyisisekelo.

Yiqiniso, abantu bangempela ababeyizazi imininingwane yalolu hlelo, ethi kungenzeka, isibonelo, Nokho ukulanda umsebenzi othile isifundo ku-Excel, njengoba umkhuba imibukiso, ikakhulukazi amazwana abasebenzisi imfundamakhwela, izinto ezinjalo zivame okwethulwa ifomu abstruse kakhulu, futhi kungaba budisi ukuwazwisisa.

Kubonakala sengathi best yokufunda inketho kuyoba ukufunda izici eziyinhloko ohlelweni, bese uwasebenzisa, ngomqondo ongokomfanekiso, "i ukubheja abafundile." Akubuzwa, kumelwe siqale sifunde ukusebenza kuqala-Microsoft Excel izakhi (izifundo uhlelo show Kungako-ke okwamanje), ukuze uzenzele ophelele izimiso umsebenzi.

Izakhi eziyinhloko ezidinga ukunakwa kwakho

Into yokuqala ukuthi kuqhakambisa umsebenzisi uma isicelo iqala, lolu hlu njengoba itafula, lapho kuthiwa iseli elise olunezinombolo ngezindlela ezahlukene, kuye ngokuthi version isicelo. Ezinguqulweni phambilini amakholomu ebekwe izinhlamvu umugqa izibalo kanye nezinombolo. Okunye ukukhishwa yonke mshini enikeziwe kuphela kuyi-Internet.

Yini na? Yebo, kuphela ukuze akwazi ukucacisa inombolo cell ukuze ucacise uhlobo oluthile Ukubalwa indlela yokusetha izixhumanisi ohlelweni mgudumbili kuze kube seqophelweni njalo. Kamuva, kuyoba sobala ukuthi ukusebenza nabo.

Esinye isici esibalulekile - ibha ifomula - inkambu ekhethekile, esehambile «f _x» isithonjana. Kukulo muzi lapho kuchazwa bonke imisebenzi. Ngaphezu kwalokho, le misebenzi zezibalo akhonjiswa ngendlela efanayo njengoba bamukeleke ngezigaba international (setshwayo "=", ukubuyabuyelela "*" ukuhlukanisa "/", njll). Amanani Trigonometric futhi zivumelana abizwa ngamazwe (isono, cos, TG, njll). Kodwa kungcono kakhulu elula. Operations nzima kuyoba ukuthuthukisa ngokusebenzisa uhlelo inkomba noma izibonelo eziqondile, ngoba ezinye ifomula angabukeka likubeka ngokucacile (lomchazi, logarithmic, tensor,-matrix, njll).

Kusukela phezulu, njengoba kwezinye izinhlelo Ihhovisi iphaneli main futhi main menu izinto kusukela amaphuzu ayinhloko wokusebenza izinkinobho ukufinyelela okusheshayo umsebenzi othile.

Uhlobo lwedatha kanye nemisebenzi elula nabo

Ukucutshungulwa kanjani ukusebenza e-Excel hlelo, akunakwenzeka ngaphandle ukuqonda izinhlobo ukhiye idatha afakwe amaseli etafuleni. Vele wazi ukuthi ngemva enquma olunye ulwazi, ungacindezela ukhiye, Esc ukhiye, noma umane ukuhambisa isikwele yeseli oyifunayo kwenye - idatha egcinwe. Uhlela iseli by kabili ngokucindezela noma ngokucindezela F2, futhi uma sebeqedile ukugcina idatha okokufaka kuphela uma ucindezela Faka.

Manje amagama ambalwa angafakwa kuseli ngayinye. Ifomethi imenyu icele ngokuchofoza ngakwesokudla ku yiseli evuliwe. Ngakwesokunxele kukhona ikholomu ekhethekile nohlobo idatha (Ngokuvamile, izinombolo, umbhalo, amaphesenti, usuku, njll). Uma ukhetha format jikelele, uhlelo, ukukhuluma cishe, uqobo inquma ukuthi kubukeka kanjani ukubaluleka langena (isibonelo, uma uthayipha 1/1/16, uzobe obonwa usuku 1 Januwari 2016).

Uma ufaka inombolo ongayisebenzisa ucacise inombolo yezindawo zedesimali (okuzenzakalelayo uboniswa ngohlamvu olulodwa, kodwa uma ufaka uhlelo imizuliswano emibili nje ukubaluleka sobala akashintshi nakuba kuyiqiniso).

Uma usebenzisa, bathi, umbhalo idatha uhlobo ukuthi umsebenzisi wayengangenanga emkhunjini, lizovezwa ngokufana ncamashí nalokho ngomshini on the keyboard, ngaphandle noma yiziphi izinguquko.

Nakhu Kuyathandeka: uma hambisa isikhombisi iseli akhethiwe ekhoneni elingezansi kwesokudla engu- izovela, okuyinto edonsa ngenkathi ephethe inkinobho yesinxele, ungakwazi ukukopisha idatha ngendlela elandelayo ngoba iseli oyifunayo. Kodwa idatha zizoshintsha. Uma sithatha isibonelo esifanayo ne usuku, ukubaluleka elilandelayo uyoboniswa ngo-January 2, njll ukukopisha okunjalo kuwusizo lapho nizibekela amafomula afanayo amaseli ahlukene (futhi ngezinye izikhathi ngisho izibalo cross).

Uma sikhuluma amafomula ungasebenzisa indlela ezimbili ngoba imisebenzi elula. Ngokwesibonelo, i-isamba A1 namaseli B1, okumele ibalwe kuseli C1, kubalulekile uma sikubeka isikwele C1 ensimini bese usetha ukubala ifomula «= A1 + B1». Ungenza kungenjalo, enikezwa ifomula "= INANI (A1: B1)» (le ndlela kuyinto lisebenza nakakhulu izikhala ezinkulu phakathi amaseli, nakuba ungasebenzisa summation okuzenzakalelayo, kanye uhlelo olubhalwe ngolimi lwesiNgisi sum SUM umyalo).

Uhlelo Excel: indlela ukusebenza Excel amashidi

Lapho ukusebenza amaqabunga angakhiqiza ezihlukahlukene nemisebenzi: ukwengeza amashidi, ukushintsha igama labo, susa njll ezingadingekile Kodwa into ebaluleke kakhulu wukuthi kungenzeka iyiphi amaseli ezisebusweni amashidi ezahlukene exhumene amafomula ezithile (ikakhulukazi uma amanani amakhulu izinhlobo ezahlukene ulwazi wangena).

Kanjani ukuze ufunde ukuthi usebenze nge-Excel ngokwakho ukusetshenziswa izikhombo izibalo? Kuyinto elula kangaka cha. Njengoba lobuya abasebenzisi, kanye kahle umhleli etafuleni, ukwenza ngaphandle kosizo kuyoba nzima ngempela. Udinga ukufunda okungenani usizo uhlelo zohlelo. Indlela elula iqondiswa ku-formula efanayo amaseli by Ukukhetha kwabo (kungenziwa uyibhala olulodwa, futhi ehlukile. Futhi, uma inani iqondiswa emasimini amaningi, kungenzeka ukubhalisa "= INANI", bese umane Uvula aboshezelwa Ctrl ukhiye ukwaba amaseli oyifunayo. Kodwa lokhu isibonelo bakudala kakhulu.

Izici ezengeziwe

Kodwa lolu hlelo ngeke nje ukudala amatafula nge izinhlobo ezahlukene zedatha. Kususelwa kubo ngenjongo ambalwa, ungakwazi ukwakha zonke izinhlobo emagrafu nemashadi ngokucela ukwakhiwa ngokuzenzekelayo zemisebenzi ekhethiwe amaseli, noma ucacise it ngesandla uma ufaka imenyu elihambisana.

Ngaphezu kwalokho, lolu hlelo uyakwazi ukusebenzisa ekhethekile izengezo, izikripthi elisebenzisekayo esekelwe Basic Visual. Ungakwazi ukufaka amanye izinto ngesimo ihluzo, video, alalelwayo noma yini enye. Ngokuvamile, ukuntuleka kwamathuba. Futhi lapha kumayelana ingxenye encane nje kuphela konke okwazi lolu hlelo eliyingqayizivele.

Kodwa ukuthi uzothini, ke kuyindlela efanele kuyinto ukubala matrix ukuxazulula zibalo ezahlukene yimuphi yinkimbinkimbi, ukuthola amazinga eqile imisebenzi ukudala database zizihlobanise nezinye izinhlelo zokusebenza njenge-Microsoft Finyelela, nokunye okuningi - nje ingekho ohlwini.

yi

Manje, mhlawumbe, kuyacaca ukuthi umbuzo kanjani ukuze ufunde ukuthi usebenze nge-Excel bebodwa, akunjalo futhi kulula ukubhekana nazo. Yiqiniso, uma uzwa izimiso eziyisisekelo emsebenzini kumhleli, setha imisebenzi eyisisekelo abangu ayisebenzi. Umsebenzisi Izibuyekezo zifakazela ukuthi kuyinto engenzeka ukuba afunde esiphezulu isonto elilodwa. Kodwa uma udinga ukusebenzisa izibalo eziyinkimbinkimbi, ngisho nangaphezu kwalokho, umsebenzi ebhekisela egciniwe, kunjengokungathi abangafuni zazingekho izincwadi ekhethekile noma izifundo nje abakwazi ukukwenza. Ngaphezu kwalokho, it is kungenzeka kudingeke donsa up ngisho nolwazi lwawo algebra futhi geometry inkambo esikoleni. Ngaphandle kwalokhu, ukusebenzisa ngokugcwele umhleli ithebula akazange ngisho baphupha.