Usebenza kanjani ku-Excel 2010

Excel kuyingxenye-Microsoft Office 2010 ejwayelekile iphakethe futhi isetshenziselwa PC yomsebenzisi nge-spreadsheet.

Ngizozama ukuphendula umbuzo kanjani ukusebenza Excel. Ngalolu hlelo, thina kuqala ukudala i ibhuku Excel ehlanganisa amashidi eziningana. It kungadalwa ngezindlela ezimbili.

On PC ideskithophu, chofoza ngakwesokudla imenyu yamashothikhathi, khetha "yakha ishidi-Microsoft Excel" noma "ukuvula uhlelo usebenzisa izinqamuleli bese udala ibhuku elisha."

Uhlelo Excel ivumela ukuhlaziya idatha amatafula nemibiko isifinyezo, ukwenza ukubalisa kube ezahlukene zezibalo e idokhumenti by amafomula engena, ukwakha amashadi professional namagrafu zikuvumela ukuba sihlaziye amathebula edatha.

Hhayi ngokufingqiwe kalula kanjalo emfushane sihloko inkulumo mayelana nendlela ukusebenza i-Excel, yini kwenkululeko uhlelo, lokho ofuna ifomula musa. Kodwa ake ngiqale indaba ekuqaleni.

Ngaphambi uvula incwadi equkethe lamaseli angenalutho. Ngaphambi kokuba uqale ukusebenza nabo, funda interface hlelo , kuye ngokuthi version. I 2010 version has a phezulu amathebhu tape. Eyokuqala wabo - "Ekhaya". Ngaphezu kwalokho, amathebhu ahlelwe ukwenza imisebenzi umsebenzisi: "Faka" "Ikhasi Isakhiwo", "Umthetho ofingqiwe", "Idatha" "Buyekeza" "Buka" futhi "Izengezo". Kumelwe alazi ngamathuluzi, esemgwaqweni amathebhu idatha.

Phawula inkinobho Office. It yakhelwe ukubonisa imiyalo futhi ewindini, phezulu kwesobunxele.

Ake sithi udale idokhumenti zezimali lapho ungabona ukuhamba imali, idatha engenayo, ukubala nenzuzo nokulahlekelwa. Nanti ithuba lokwenza ukuhlaziywa olugcwele lomsebenzi zezimali. Indlela i-Excel ukwakha leli phepha ukuze bangabhekani?

Okokuqala, faka idatha yezinombolo kumaseli ukuthi ehlangana etafuleni. Ukufaka idatha kuseli kumelwe wenze kuso asebenzayo. Ukuze wenze lokhu, khetha ke uchofoze bese ufaka ulwazi olufunayo.

Emva ukugcwalisa zonke izinkambu senza out ithebula nge ukwaba yonke indawo yokusebenza. Ngo imenyu umongo, kubangelwa inkinobho yegundane kwesokudla, ukhethe umugqa "Ifomethi Amaseli." Lapha, sikhetha ithuluzi "Imingcele" futhi silisebenzise.

Le menu imiyalo etholakalayo kanye nezinye ukuze ahlelwe amatafula. Usebenza kanjani ku-Excel, uBaba ayakumthumela egameni lami lwemibhalo. Hlola nabo bebodwa. Thola futhi ngokucophelela ufunde okokufundisa, lobeka ngokuningiliziwe izimiso kanjani ukusebenza Excel 2010. Khetha uhla lwemibhalo nge umsebenzi njengendlela ithiyori ngaphandle mkhuba ayizwakali. Ukuphelelisa nezimfuno, uzokwazi ukuhlanganisa lo ulwazi theory kanye ufunde imigomo yomsebenzi Excel ngokushesha.

Ukusebenza Excel amafomula

Ngemva kokubhaliswa amatafula sokubalwa isebenza kwimodi okuzenzakalelayo (nesofthiwe Excel, eqinisweni, senzelwe le njongo), kufanele ufake izinombolo ezifanele kanye nezimpawu kubha ifomula, futhi kakhulu kuseli. Ukusebenza amafomula ku-Excel - omunye uyabaqinisa spreadsheet. Lapha ungakwazi ukwenza noma yikuphi ukuqhutshwa: kwalokho, ukukhupha, ukubuyabuyelela, division, impande square, imisebenzi ukubala futhi logarithms; ungathola isamba izinombolo kanye izibalo kusho.

Formula obulandela setshwayo, okuyinto ukubeka kubha ifomula ke kwemisebenzi zibhaliwe abakaki, ahlukaniswa-semicolon.

Ukuze uthole okwengeziwe lapho etadisha ngokujulile izimiso umsebenzi kulolu hlelo, udinga ukuthatha izifundo ezikhethekile. Futhi ukuqala udinga kuphela isifiso sokuba ngifunde imithetho eziphilayo ezinika ukuqonda sendlela usebenze nge-Excel.