Indlela Yokwenza Ishadi Lemakethe Ye-Stock Market Ephezulu-Ephansi e-Excel

01 ngo-07

I-Excel Isitatimende Ishadi Lokubukwa Kwama-Stock

Qaphela: Yiziphi eziningi esibiza igrafu kukhonjiswe ku-Excel njenge ishadi .

Ishadi eliphezulu eliphansi elivaliwe likhombisa amanani aphakeme aphezulu, aphansi, futhi avalayo esitokisini esikhathini esinikeziwe.

Ukugcwalisa izinyathelo ezihlokweni ezingezansi kuzokhipha ishadi lemakethe yezimoto elifana nesithombe ngenhla.

Izinyathelo zokuqala zakha ishadi eliyisisekelo kanti ezintathu zokugcina zisebenzisa izici eziningi zokufometha ezitholakalayo ngaphansi kwethebhu , ukuhlelwa, nokufomatha amathebhu ebhande .

Izihloko zezifundo

1. Ukufaka idatha yeGrafu
2. Khetha Idatha yeshadi
3. Ukwakha Ishadi LaseMbukiso Lomasheya Eyisisekelo
4. Ukufometha Ishadi Le-Stock - Ukukhetha Isitayela
5. Ukufometha Ishadi Lama-Stock - Ukukhetha Isitayela Sokwakheka
6. Ukufometha I-Stock Chart - Ukwengeza Isihloko Ku-Chart Stock

02 ngo-07

Ukufaka idatha yeThadi

Isinyathelo sokuqala ekudaleni ishadi lemakethe yesitoreji esiphezulu-eliphansi-ukufaka idatha kushidi lokusebenzela .

Uma ufaka idatha , gcina le mithetho engqondweni:

• Uma kunokwenzeka, faka idatha yakho kukholomu njengoba kuboniswe esithombeni ngenhla
• Beka ishidi lakho lomsebenzi nesihloko sochungechunge lwemininingwane ngayinye phezulu kwekholomu kanye nedatha kumaseli angezansi
• Ungashiyi imigqa noma amakholomu angenalutho uma ufaka idatha yakho njengoba lokhu kuzokwenza izindawo ezingenalutho eshadini

Qaphela: Isifundo asifaki izinyathelo zokufometha iphepha lokusebenzela njengoba kuboniswe esithombeni ngenhla. Ulwazi olukhethwa kukho lokufometha kweshidi lokusebenza luyatholakala kulesi sifundo esiyisisekelo sokufometha kwe-Excel .

Izinyathelo Zokufundisa

Faka idatha njengoba ibonwe esithombeni ngenhla kumaseli A1 kuya ku-D6.

03 ka-07

Ukukhetha idatha yedatha

Izinketho ezimbili zokukhetha idatha yeshadi

Ukuze uthole usizo ngalezi ziqondiso, bheka isibonelo sesithombe ngenhla.

Ukusebenzisa uMouse

1. Hudula ukhethe inkinobho yegundane ukugqamisa amangqamuzana aqukethe idatha ukuthi ifakwe eshadini.

Ukusebenzisa ikhibhodi

1. Chofoza ngakwesokunxele phezulu kwedatha yeshadi.
2. Gweba ukhiye we- SHIFT kukhibhodi.
3. Sebenzisa okhiye bomcibisholo ekhibhodi ukuze ukhethe idatha ukuze ifakwe eshadini lesitoko.

Qaphela: Qinisekisa ukuthi ukhetha noma yiliphi ikholomu nezihloko zegqawu ofuna ukufakwa eshadini.

Izinyathelo Zokufundisa

1. Qinisekisa ibhokisi lamaseli ukusuka ku-A2 kuya ku-D6, okufaka izihloko zekholomu kanye nezihloko zomugqa kodwa hhayi isihloko, usebenzisa enye yezindlela ezingenhla.

04 ka 07

Ukwakha Ishadi LaseMbukiso Lomasheya Eyisisekelo

Ukuze uthole usizo ngalezi ziqondiso, bheka isibonelo sesithombe ngenhla.

1. Chofoza kuthebhu ye-Ribbon yokufaka.
   
2. Chofoza kwisigaba seshadi ukuze uvule uhlu oluphansi lwezinhlobo zeshadi ezitholakalayo
   
   (Ukuhambisa isikhombisi sakho segundane phezu kohlobo lweshadi kuzokhipha incazelo yeshadi).
   
3. Chofoza kuhlobo leshadi ukuze ukhethe.

Izinyathelo Zokufundisa

1. Uma usebenzisa i-Excel 2007 noma i-Excel 2010, chofoza ku- Faka> Amanye Amashadi> I-Stock> I-Volume-High-Low-Vala ku-Ribbon
2. Uma usebenzisa i-Excel 2013, chofoza ku- Faka> Faka i-Stock, i-Surface noma i-Radar Charts> I-Stock> I-Volume-High-Low-Vala ku-Ribbon
3. Ishadi lamakethe lesikhwama samasheya eliphansi eliphansi-eliphansi lidalwe futhi lifakwa ekhasini lakho lokusebenzela. Amakhasi alandelayo afaka ukufometha leli shidi ukufanisa isithombe esiboniswe esiteji sokuqala salesi sifundo.

05 ka-07

Ukukhetha isitayela

Ukuze uthole usizo ngalezi ziqondiso, bheka isibonelo sesithombe ngenhla.

Uma uchofoza eshadini, amathebhu amathathu - Amathebhu wokuKwakha, uLungiselelo, kanye neFomathi afakwa kwibhoni ngaphansi kwesihloko seThirt Tools .

Ukukhetha isitayela Ishadi Lemakethe Ye-Stock

1. Chofoza kushadi lesitoko.
2. Chofoza kuthebhu Yokuklama .
3. Chofoza kumcibisholo ongaphezulu ongaphezulu ekhoneni elingezansi ngakwesokudla iphaneli yezitayela zeshadi ukuze ubonise zonke izitayela ezitholakalayo.
4. Khetha Isitayela 39.

06 ka-07

Ukukhetha isitayela sefomu

Ukuze uthole usizo ngalezi ziqondiso, bheka isibonelo sesithombe ngenhla.

Uma uchofoza eshadini, amathebhu amathathu - Amathebhu wokuKwakha, uLungiselelo, kanye neFomathi afakwa kwibhoni ngaphansi kwesihloko seThirt Tools .

Izinyathelo Zokufundisa

1. Chofoza kusemuva leshadi.
2. Chofoza kuthebhu yefomethi .
3. Chofoza kumcibisholo ongaphezulu ongaphezulu ekhoneni elingezansi ngakwesokudla iphaneli yezitayela zeshadi ukuze ubonise zonke izitayela ezitholakalayo.
4. Khetha Imiphumela Yomphumela - I-Accent 3.

07 ka-07

Ukwengeza isihloko kwisikweletu se-Stock

Ukuze uthole usizo ngalezi ziqondiso, bheka isibonelo sesithombe ngenhla.

Uma uchofoza eshadini, amathebhu amathathu - Amathebhu wokuKwakha, uLungiselelo, kanye neFomathi afakwa kwibhoni ngaphansi kwesihloko seThirt Tools .

Izinyathelo Zokufundisa

1. Chofoza kuthebhu ye- Layout .
   
2. Chofoza kusihloko seshadi ngaphansi kwesigaba se- Labels .
   
3. Khetha inketho yesithathu - Ishadi eliphezulu .
   
4. Thayipha isihloko esithi "I-Cookie Shop Daily Stock Value" emigqeni emibili.

Kuleli phuzu, ishadi lakho kufanele lifanane neshadi lesitoko eliboniswe esiteji sokuqala salesi sifundo.