Indlela ukusebenza ngo-Excel-2010

Excel yingxenye ye-Microsoft Office 2010 package standard kwaye asetyenziselwa PC lomsebenzisi kunye spreadsheet.

Ndiza kuzama ukuphendula umbuzo ukuba asebenze njani e-Excel. Ngale program, siqala ukwenza yomsebenzi Excel eziquka sheets eziliqela. Oko kwenziwa ngeendlela ezimbini.

Kwi PC desktop, nqakraza-ekunene kwi menu emfutshane ukhethe "Excel List Microsoft ukudala" okanye "ukuvula inkqubo usebenzisa indlela emfutshane kwincoko nokudala incwadi entsha."

Iprogram ye-Excel ivumela uhlalutyo iitafile data kunye neengxelo isishwankathelo, ukwenza izibalo ezahlukeneyo izibalo kweli xwebhu ifomula abangena, ukwakha iitshati zobungcali kunye neegrafu kukuvumela ukuba uhlaziye iitafile data.

Akukho lula kushwankathelwa nje elifutshane inqaku intetho malunga ukuba asebenze njani na Excel, yintoni na umda lwenkqubo, yintoni na ofuna ifomula. Kodwa ke masiqale ukusuka ekuqaleni.

Phambi kokuba uvule incwadi equlethe iiseli lutho. Phambi kokuba uqale ukusebenza nabo, ufunde inkqubo yekhompyutha , ngokuxhomekeka kwinguqulelo. Inguqulelo 2010 uye tape tab eziphezulu. Eyokuqala kuzo - "Ekhaya". Ngaphezu koko, zicwangciswe i tabs ukuba enze imisebenzi zomsebenzisi: "Faka", "Ubeko Page", "Formula", "Data", "Review", "Jonga," yaye "Yongeza Izongezelelo". Kufuneka bawuqhele ngokupheleleyo izixhobo, nto leyo imi tabs data.

Qaphela iqhosha Office. Iyilelwe ukuba ukubonisa imiyalelo kwaye kwi window, kwi ekhohlo phezulu.

Masithi ukudala uxwebhu zemali apho ungabona intshukumo eziinkozo, data ingeniso, ukubalwa ingeniso nelahleko. Nantsi ithuba lokwenza uhlalutyo olupheleleyo lomsebenzi mali. Indlela yokusebenzisa Excel ukwenza uxwebhu onjalo?

Okokuqala, ngenisa idatha yamanani kwi iiseli zidibene kule theyibhile. Ukufaka nkcukacha zibe iseli kufuneka wenze kube esebenzayo. Ukuze wenze oku, khetha oko cofa uze ufake ulwazi olufunayo.

Emva kokugcwalisa onke amasimi yenza ngaphandle itheyibhile ngokuthi ibanike indawo yokusebenza yonke. Xa wemenu yentsingiselo, zibangelwa yi ekunene iqhosha le mouse, khetha umgca "Iiseli Format." Apha, sikhetha i isixhobo "Imida" size silisebenzise.

Le menu imiyalelo ekhoyo kunye nezinye amacwecwe nohlelo. Indlela ukuze bayixube emisontweni Excel, uya ukufundisa ulawulo. Jonga nabo ngokwabo. Fumana ze ufunde ngenyameko tutorial, lobeka ngokweenkcukacha siseko ukuba asebenze njani Excel 2010. Khetha uvimba weefayili kunye umsebenzi ithiyori ngaphandle yokwenza nokungaphumeleli kwawo. Ukuzaliswa ngela, uya kukwazi ukubethelela ulwazi yolwazi yaye bafunde imigaqo umsebenzi Excel ngokukhawuleza.

Ukusebenza ezakhiwe Excel

Emva ukubhaliswa iitafile yokubala isebenza ikwimo oluzenzekelayo (software Excel, enyanisweni, esenzelwe le njongo), kufuneka ufake iinombolo efanelekileyo kunye nemiqondiso ibha yefomyula, kwaye kanye iseli. Ukusebenza kunye neefomyula ukuqikelela Excel - enye ebheka spreadsheets. Apha uyakwazi ukwenza nayiphi na imisebenzi: ukudibanisa, ukuthabatha, ukuphinda-phinda, hlula, ingcambu, imisebenzi yokubala kunye logarithm; uyakwazi ukufumana inani amanani kunye nasekubaleni abangenagama.

Ifomula owandulelayo kophawu olulinganayo, sifakiweyo ibha yefomyula le, ngoko umsebenzi iimpikiswano zibhalwa kwindawo yegama, apho ezahlulwe semicolon.

Kuba kakhulu-olunzulu nokufunda imigaqo yomsebenzi kule nkqubo, kufuneka uthathe izifundo ezizodwa. Kwaye ukuba uqale wena kudingeka nje umnqweno ukufunda imithetho ezibonelela ingqiqo ukuze isebenze ngayo Excel.