Inyathelo ngu step imiyalelo yokwenza ngayo itshathi e-Excel

Ebomini bethu, nje akakwazi ukwenza ngaphandle uthelekiso ezahlukeneyo. Amanani - oko akusoloko kulula ukufunda, nto leyo esisizathu sokuba abantu beza kunye kwitshati.

Eyona umsebenzisi-friendly inkqubo ukuhlela iintlobo ezahlukeneyo - Microsoft Office Excel. Ukuze ufunde indlela yokwenza itshati Excel, kwaye kuya kuxoxwa ngazo kweli nqaku.

Le nkqubo ayikho inzima kakhulu, siya kufuneka ulandele kuphela algorithm ethile.

Step by imiyalelo step, indlela yokwenza itshati e-Excel

1. Vula uxwebhu: kwiqhosha "Qalisa" - "Zonke iiNkqubo" - eneenkcukacha «Microsoft Office» - uxwebhu "Excel".

2. Yenza itheyibhile data ezinqwenelekayo yokuvelisa olubonakalayo kwitshati. Khetha uluhlu anama data yamanani.

3. Shaya "ekunikeni wizard." Umyalelo: "Faka" - "Diagram".

Ikhusi ukubonisa ibhokisi yencoko yababini Wizard ukwakha itshati. Kwakhona uya kusinceda ukumisela umyalelo, ukuba ukwenza njani kwitshati e-Excel. Kodwa oku ukusebenza kufuneka enze amanyathelo ezine ezilula.

1. Inyathelo lokuqala iza kuba ukukhetha uhlobo yetshathi. Njengoko kubonakala ukusuka kuluhlu oluboniswe, kukho iintlobo-ntlobo: igrafu kunye kwitshathi imimandla h, ngumbala osetyenziselwa ukuzoba, njalo phezu komhlaba. Ukukhetha kwakhona iintlobo ezikhoyo itshathi siko. Umzekelo isiboniso lomzobo kwishedyuli elizayo, ungabona kwisiqingatha lasekunene le window.

2. Inyathelo lesibini kukuba ukuphendula umbuzo zendlela yokwenza itshati Excel, kuya kungena umthombo data. Sithetha kwipleyiti enye, nto leyo kukhankanyiwe kumhlathi wesibini inxalenye yokuqala nqaku. Xa "inani" ithuba lokubuza igama kumqolo ngamnye (okanye umhlathi kwetafile) ucwangciso elizayo.

3. Eyona nto kakhulu voluminous №3: Options Itshati «". Hamba kwizithuba:

• Ngasentla. Apha ungacwangcisa-caption of axis nganye letshathi ze unike igama lakhe.

• Axis. Khetha uhlobo axis: ixesha axis, lo ezimanyeneyo iindidi, ezifana ubhaqo oluzenzekelayo.

• Imigca grid. Apha uyakwazi ukukhetha, okanye icala, ukuba asuse ezisisiseko okanye imigca eliphakathi lombane schedule.

• Legend. Kuya ekuvumela ukuba ubonise okanye ufihle lamandulo, uze ukhethe indawo yayo.

• Table Data. Wongeza Itheyibhile yeengcombolo kwingingqi ekwakheni ikamva lo mzobo.

• Labels Data. Oku kuquka iinkcukacha utyikityo kwaye ubonelela iintlobo njengomahluli phakathi parameters.

indalo yakho ukuvela kwiskrini. Nangona Wizard Chart likuvumela ukuba ukujonga kwithayimthebhile elizayo kuzo zonke nqanaba yomsebenzi wabo, ekugqibeleni usafuna into ukuze kulungiswe.

Umzekelo, nqakraza kwi mouse isibini izihlandlo kule nkqubela iqhosha le mouse lasekunene (kodwa hayi yena!), Ungenza imvelaphi apho shedyuli ikwafumaneka umbala okanye itshintshe izicwangciso zosapho lohobo (isimbo, ubungakanani, umbala, krwela).

Xa kabini nqakraza ziyafana zonke, nqakraza-ekunene kwi migca itshati, ungakwazi ukufometha umgca ngokwayo igridi yemizobo, wabeka udidi lwabo, ubukhulu kunye nombala, kwaye ukutshintsha nezinye iparameters ezininzi. indawo Plot nayo iyafumaneka ukuze ukufometha kunoko, kwizikim umbala.

Siyathemba ukuba ufumane impendulo kakhulu ongenantandabuzo kwaye elula lo mbuzo: "Indlela yokwenza itshati e-Excel»?. Yinto elula kakhulu, ukuba ulandele le miyalelo ilapha ngentla. Sininqwenelela impumelelo!