Indlela yokwenza Isatifiketi seSitoreji seSitoreji seSisigxina esiphantsi

01 ngo 07

I-Excel yeStock Market Isatifiketi

Qaphela: Ziziphi izinto ezininzi esizibiza ngegrafu ekubhekiswe kuyo kwi-Excel njengetshathi .

Ishati ephakamileyo-eViweyo eViweyo ibonisa amaxabiso aphezulu aphezulu, aphantsi, kunye nokuvala kwisitokhi phezu kwexesha elinikeziweyo.

Ukugqiba amanyathelo kwiihloko ezingezantsi kuza kuvelisa ishatiketi yemasheke yesikhokelo esifana nomfanekiso ongentla.

Amanyathelo okuqala enza isatiyibrari kunye neyesithathu zokugqibela zisebenzisa iimpawu ezifomathiweyo ezifumaneka phantsi kweMbonakalo , ukuCwangciswa , kunye neFomathi yeTebhoni .

Izihloko zeTutorial

1. Ukufaka idatha yeGrafu
2. Khetha iDatha yeDatha
3. Ukudala Isatifiketi SokuThengiswa KweSiseko seSitoreji
4. Ukufometha Isatifiketi seSitoko - Ukukhetha Isitayela
5. Ukufometha Isatifiketi seSitoko - Ukukhetha isitayela sohlobo
6. Ukufometha Isatifiketi seSitoko - Ukongeza iSihloko kwiShadi leSitokethi

02 we-07

Ukufaka iDatha yeDatha

Isinyathelo sokuqala ekudaleni i-chart ephezulu ye-stock-Low-Close ukufaka idatha kwiphepha lokusebenzela .

Xa ufaka idatha , gcina le mithetho engqondweni:

• Xa kunokwenzeka, faka idatha yakho kwiikholamu njengoko kuboniswe kumfanekiso ongentla
• Yenza iphepha lakho lokusebenzela kunye nesihloko kwinqaku nganye yedatha phezulu kwikholam kunye nedatha kwiiseli ezingezantsi
• Musa ukushiya imigca okanye iikholomu ezingenanto xa ufaka idatha yakho njengoko oku kuza kudala indawo engenanto kwitshati

Qaphela: Uqeqesho alubandakanyi amanyathelo okufometha iphepha lokusebenzela njengoko kuboniswe kumfanekiso ongentla. Ulwazi malunga neendlela zokwenza ifomathi yomsebenzi lufumaneka kule ngqangi yokufundisa ukufometha kwe-Excel .

Iimfundiso zeTutorial

Faka idatha njengoko iboniswe kumfanekiso ongentla kwiiseli A1 ukuya kwi-D6.

03 we-07

Ukukhetha iDatha yeDatha

Iinketho ezimbini zokukhetha iData yeDatha

Ukuze uncede ngale miyalelo, khangela umzekelo womfanekiso ongentla.

Ukusebenzisa iMouse

1. Drag ukhethe kunye nekhompi ye mouse ukugqamisa iiseli eziqulethe idatha ukuba zifakwe kwitshathi.

Ukusebenzisa ikhibhodi

1. Cofa kwi-top left of data yetshathi.
2. Gcina phantsi iqhosha le- SHIFT kwibhodibhodi.
3. Sebenzisa izitshixo zitshixo kwikhibhodi ukhethe idatha ukuba ifakwe kwisatriki yesitokisi.

Qaphela: Qinisekisa ukuba ukhethe nayiphi na iikholomu kunye nezihloko zomqolo ofuna ukuba zifakwe kwitshati.

Iimfundiso zeTutorial

1. Phakamisa ibhloko yeeseli ukusuka ku-A2 ukuya ku-D6, equka izihloko zekholomu kunye nezihloko ezilandelelweyo kodwa kungengesihloko, usebenzisa enye yezi ndlela zingentla.

04 we-07

Ukudala Isatifiketi SokuThengiswa KweSiseko seSitoreji

Ukuze uncede ngale miyalelo, khangela umzekelo womfanekiso ongentla.

1. Cofa kwiTybhu yerobhoni.
   
2. Cofa kwididi yetshathi ukuvula uluhlu lokuhla kweentlobo zeesatriki ezikhoyo
   
   (Ukuhambisa i-pointer yakho ye mouse kwihlobo lwetshathi kuya kuvelisa inkcazo yetshathi).
   
3. Cofa kwindlela yetshathi ukuze ukhethe.

Iimfundiso zeTutorial

1. Ukuba usebenzisa i-Excel 2007 okanye i-Excel 2010, nqakraza ngokufaka> Ezinye iirhafu> I-Stock> I-volume-High-Low-Close kwi-Ribbon
2. Ukuba usebenzisa i-Excel 2013, cofa kwi- Insert> Faka i-Stock, i-Surface okanye i-Radar Charts> I-Stock> I-Volume-High-Low-Vala kwi-Ribbon
3. Isalathisi esisisiseko esisezantsi-Sondeza-Sondeza imakethe yemasheya sidalwa kwaye sifakwe kwiphepha lakho lokusebenzela. Le fayili elandelayo ifomathi yokufomathiza le tstshana ukufanisa umfanekiso oboniswe kwisinyathelo sokuqala sale khokelo.

05 we-07

Ukukhetha Isitayela

Ukuze uncede ngale miyalelo, khangela umzekelo womfanekiso ongentla.

Xa ucofa kwitshathi, iithebhu ezintathu - i-Design, Layout, kunye nefomathi yefomathi zongezwa kwibhebhoni phantsi kwesihloko seTrans Tools .

Ukukhetha Isitayela seTyhiveshi yeSitokisi seSitokisi

1. Cofa kwididi yesitokethi.
2. Cofa kwiThebhu yoyilo .
3. Cofa kwiNqakraza engaphezulu phantsi kwinqanaba lasekunene lepaneli yeTyrtti yeTrash ukubonisa zonke izitayela ezikhoyo.
4. Khetha Isitayela 39.

06 we-07

Ukukhetha isitayela sohlobo

Ukuze uncede ngale miyalelo, khangela umzekelo womfanekiso ongentla.

Xa ucofa kwitshathi, iithebhu ezintathu - i-Design, Layout, kunye nefomathi yefomathi zongezwa kwibhebhoni phantsi kwesihloko seTrans Tools .

Iimfundiso zeTutorial

1. Cofa kwingembo yetshathi.
2. Cofa kwiTebhu yefomathi.
3. Cofa kwiNqakraza engaphezulu phantsi kwinqanaba lasekunene lepaneli yeTyrtti yeTrash ukubonisa zonke izitayela ezikhoyo.
4. Khetha Impembelelo Enamandla - Isivakalisi 3.

07 we-07

Ukongeza Isihloko kwiShadi leSitokethi

Ukuze uncede ngale miyalelo, khangela umzekelo womfanekiso ongentla.

Xa ucofa kwitshathi, iithebhu ezintathu - i-Design, Layout, kunye nefomathi yefomathi zongezwa kwibhebhoni phantsi kwesihloko seTrans Tools .

Iimfundiso zeTutorial

1. Cofa kwiTyhu yoTywala.
   
2. Cofa kwiSihloko soTyati phantsi kwecandelo leeLebels .
   
3. Khetha ukhetho lwesithathu - Ngaphezulu kweTrart .
   
4. Thayipha kwisihloko esithi "I-Cookie Shop Shop Daily Stock Value" kwimigca emibini.

Ngeli nqanaba, itshati yakho imele ifane nesatriki yesitokhwe esiboniswe kwisinyathelo sokuqala sale khokelo.