Umdwebo we-Stock Market ophezulu-ophansi-ophansi we-Stock Market

01 ka 09

I-Excel Isitatimende Ishadi Lokubukwa Kwama-Stock

Ishadi lezimakethe zezimakethe ze-stock-High-Low-Close luhlobo lwebhadi noma igrafu elisetshenziswe ngokuyinhloko ukukhombisa izinguquko ngokubaluleka kwezimpahla ezidayiswayo - njengezitoko - esikhathini esinikeziwe.

Izingxenye ze-ishadi kanye nomsebenzi wazo ziyi:

• Imigqa emibala engezansi eshadini ibonisa ububanzi bezinzuzo zesitokisi sesikhathi esiphezulu somugqa obonisa inani lentengo eliphakeme kakhulu nangaphansi komugqa obonisa inani lentengo ephansi kakhulu
• Uphawu lokuvala - unxantathu ophuzi. Iphuzu elingenhla lexantathu likhombisa intengo yokuvala yesitoko
• Imigoqo eluhlaza okwesibhakabhaka ibonisa ivolumu noma inombolo yamasheya athengiswa isikhathi

I-Excel Isitatimende Ishadi Lemakethe ye-Stock Market

Lokhu kufundisa kukuhamba ngokudala ishadi lemakethe yesitoko se-Volume-High-Vala ku-Excel.

I-tutorial kuqala idala ishadi lesitokisi lesisekelo bese isebenzisa izinketho zokufometha ezifakwe ngaphansi kweThuluzi lamathuluzi ku- Ribbon ukukhiqiza ishadi elibonwe esithombeni ngenhla.

Izihloko zezifundo

1. Ukufaka nokukhetha Idata yeDatha
2. Ukwakha Ishadi Elivaliwe Eliphansi-Eliphansi
3. Ukusebenzisa Amathuluzi weThart ukuze ungeze ishadi ne-Axes Titles
4. Ukufometha Amalebula Amashadi Nemigomo
5. Ukufometha umaka ovaliwe
6. Ukushintsha Umbala Ongemuva Wesigcawu
7. Ukushintsha Umbala Wendawo Yombala Ongemuva
8. Ukwengeza umphumela we-3-D we-Bevel nokuphinde uphinde uhlele Ishadi

02 ka 09

Ukufaka nokukhetha Idata yeDatha

Ukufaka idatha yeThadi

Isinyathelo sokuqala ekudaleni ishadi eliphezulu le-Volume-High-Close 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 kule Tifundvo Eyisisekelo Yokufometha I- Excel .

Ukukhetha idatha yedatha

Uma idatha ifakiwe, isinyathelo esilandelayo ukukhetha idatha ezobekwa.

Ekhasini lokusebenzela langempela, ingxenye eyodwa kuphela yedatha ingabandakanywa eshadini. Ukukhetha noma ukugqamisa idatha, ngakho-ke, utshela i-Excel ukuthi yiluphi ulwazi oluzofaka phakathi nalokho okungazinaki.

Ngaphandle kwedatha yenombolo, qinisekisa ukufaka zonke izikhombo zamakholomu nezigqawu ezichaza idatha yakho.

Izinyathelo Zokufundisa:

1. Faka idatha njengoba kuboniswe esithombeni ngenhla kumaseli A1 kuya ku-E6.
2. Hudula ukhethe amaseli A2 kuya ku-E6 ukuze uwaqokomise

03 ka 09

Ukwakha Ishadi Elivaliwe Eliphansi-Eliphansi

Wonke amashadi atholakala ngaphansi kwethebhu Faka i - Ribbon ku-Excel.

Ukubeka isikhombisi sakho semouse phezu kwesigaba seshadi kuzokhipha incazelo yeshadi.

Ukuchofoza kwisigaba kuvula ukwehlisa phansi kubonisa zonke izinhlobo zeshadi ezitholakala kulesi sigaba.

Uma udala noma yisiphi ishadi ku-Excel, uhlelo kuqala ludala lokho okubizwa ngokuthi ishadi eliyisisekelo usebenzisa idatha ekhethiwe.

Ngemuva kwalokho, kungukuthi ukufometha ishadi usebenzisa amathuluzi we-Chart atholakalayo.

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 lamasheya lesikhwama samasheya esivimba se-Volume-High-Low-eliyisisekelo, elifana nelokubonwa esithombeni ngenhla, kufanele lenziwe futhi lifakwe kushidi lakho lokusebenzela .

Izitebhisi ezisele ezithombeni zokufundisa zifometha leli shidi ukufanisa isithombe esiboniswe ekhasini 1.

04 ka 09

Ukusebenzisa Amathuluzi weThart

Ukubukezwa kwamathuluzi we-Chart

Uma kuziwa ekufomeni amashadi ku-Excel, kubalulekile ukukhumbula ukuthi awudingi ukwamukela ukufometha okuzenzakalelayo kunoma iyiphi ingxenye yeshadi. Zonke izingxenye noma izakhi zeshadi zingashintshwa.

Izinketho zokufometha zamashadi zitholakala kakhulu kumathebhu amathathu webhande elihlanganiswa ngokubizwa ngokuthi amaTharthi Amathuluzi

Ngokuvamile, lawa mathubhu amathathu awabonakali. Ukuze ufinyelele kubo, mane uchofoze eshadini eyisisekelo ovele wadala namathebhu amathathu - Ukuklama, Ukuhlelwa, neFomathi - zengezwe kuhabhoni.

Ngaphezulu kwalezi zithebhu ezintathu, uzobona i- Chart Tools Tools .

Esikhathini sezinyathelo zokufundisa ngezansi sizofaka futhi siqambe kabusha izihloko ze-axes kanye nesihloko seshadi kanye nokuhambisa ingqikithi yeshadi usebenzisa izinketho ezitholakala ngaphansi kwethebhu yethuluzi leThuluzi .

Ukungeza i-Axis Isihloko se-Axis

I-axis enezingqimba ikhombisa izinsuku ezansi kweshadi.

1. Chofoza kushadi eliyisisekelo ekhasini lokusebenzela ukuze ukhuphule amathebhu wethuluzi leshadi
2. Chofoza kuthebhu ye- Layout
3. Chofoza ku- Axis Titles ukuvula uhlu lokudonsa phansi
4. Chofoza kwi- Primary Horizontal Axis Title> Isihloko Ngezansi kwe-Axis inketho yokwengeza isihloko esizenzakalelayo Isihloko se- Axis eshadini
5. Hudula ukhethe isihloko esizenzakalelayo ukuze usiqokomise
6. Thayipha isihloko esithi " Usuku "

Ukungeza i-Primary Axis Title Axis

I-axis eyinhloko ebonakalayo ibonisa ivolumu yamasheya athengiswe ngakwesokunxele kweshadi.

1. Chofoza eshadini uma kunesidingo
2. Chofoza kuthebhu ye- Layout
3. Chofoza ku- Axis Titles ukuvula uhlu lokudonsa phansi
4. Chofoza kwi- Primary Axis I-Axis Title> Okukhethwa Kwisihloko Sokushintshaniswa ukuze ungeze isihloko se- Axis Isihloko esizenzakalelayo eshadini
5. Hudula ukhethe isihloko esizenzakalelayo ukuze usiqokomise
6. Thayipha isihloko esithi " Umqulu "

Ukwengeza isihloko se-Axis Vertical Axis

I-axis yesibili ebonakalayo ibonisa izintengo zamasheya ezithengiswa ngakwesokudla kweshadi.

1. Chofoza eshadini uma kunesidingo
2. Chofoza kuthebhu ye- Layout
3. Chofoza ku- Axis Titles ukuvula uhlu lokudonsa phansi
4. Chofoza ku- Axis Isihloko se-Axis yesibili> Isikhethi se-Title shintshiwe ukuze ungeze isihloko se- Axis Isihloko esizenzakalelayo eshadini
5. Hudula ukhethe isihloko esizenzakalelayo ukuze usiqokomise
6. Thayipha isihloko esithi "I- Stock Price "

Ukungeza isihloko seshadi

1. Chofoza eshadini uma kunesidingo
2. Chofoza kuthebhu ye- Layout yedibhoni
3. Chofoza kusihloko se-Ishadi> Okukhethwa kukho kweThart ukuze ungeze Isihloko Ishadi Lesichazamazwi eshadini
4. Hudula ukhethe isihloko esizenzakalelayo ukuze usiqokomise
5. Thayipha isihloko esizansi ngezansi imigqa emibili - sebenzisa ukhiye wokungena kwikhibhodi ukuze uhlukanise imigqa: I-Cookie Shop Stock Volume and Price

Ukuhambisa i-Legend Ishadi

Ngokuzenzakalelayo, umlando weshadi ukhona ngakwesokudla ngakwesokunxele seshadi. Uma sengeze isihloko se-axis esiqondile, izinto zithola indawo encane kule ndawo. Ukunciphisa ukuxubana sizohambisa umlando phezulu kweshadi ngaphansi kwesihloko seshadi.

1. Chofoza eshadini uma kunesidingo
2. Chofoza kuthebhu ye- Layout yedibhoni
3. Chofoza kuLendlovu ukuvula uhlu lokudonsa phansi
4. Chofoza ku- Show Legend ku-Top option ukuze uhambise inganekwane ibe ngaphansi kwesihloko seshadi

05 ka 09

Ukufometha Amalebula Amashadi Nemigomo

Izinketho zokufometha ifonti

Esikhathini esedlule, kushiwo ukuthi izinketho eziningi zokufometha zamashadi zitholakala ngaphansi kwezihloko ze-Chart .

Iqembu elilodwa lokukhethwa kokufometha okungatholakali lapha ngamathuluzi wokufometha umbhalo - njengotshani wefonti nombala, isibindi, ubuhle, nokulungiswa.

Lezi zingatholakala ngaphansi kwethebhu yaseKhaya kwesigaba se- ribbon - isitayela.

I-Excel Right Click Menus kanye Ibha yamathuluzi

Kodwa indlela elula yokuthola lezi zindlela ngokuchofoza kwesokudla kuleso sici ofuna ukuyifometha.

Ukwenza kanjalo kuvula imenyu yokuchofoza noma imenyu yemongo ehlanganisa ibha yamathuluzi encane yokufometha.

Njengoba iyingxenye yemenyu yokuqukethwe, izinketho zokufometha kubha yamathuluzi zishintsha kuye ngokuthi yini ochofozile.

Isibonelo, uma uchofoza ngakwesokudla kwevolumu yevolumu yebhalethi eshadini wena ibha yamathuluzi liqukethe kuphela izinketho zokufometha ezingasetshenziswa ngalesi sici seshadi.

Ukuchofoza ngakwesokudla komunye wamathayili noma izinganekwane kukunika okukhethwa kukho kokufometha kombhalo okufana nalawo atholakala ngaphansi kwethebhu yaseKhaya yebhebhoni.

Ishothikhathi Yokufometha Ishadi

Kulesi sinyathelo sokufundisa, sifuna ukushintsha umbala wazo zonke iziqu, i-legend, namagugu - izinombolo kanye nezinsuku ezilinganisweni zemikhakha - kumbala obala okwesibhakabhaka ofana neyamabhavolumu.

Esikhundleni sokwenza ngamunye ngokwehlukana noma kunjalo, singagcina isikhathi esithile ngokushintsha umbala wazo wonke amalebuli namagugu eshadini ngesikhathi esisodwa.

Le nqamuleli ihilela ukukhetha ishadi lonke ngokuchofoza kwesizinda esimhlophe kunokuchofoza izakhi zomuntu ngamunye,

Ukufometha Wonke Amalebula Nezimiso

1. Chofoza ngakwesokudla ngemuva kwekhadi elimhlophe ukuze uvule imenyu yesimo somdwebo
2. Chofoza kumcibisholo omncane ophansi ngakwesokunxele kwesithonjana se- Font Color kubha yamathuluzi womongo ukuvula iphaneli ye- Theme Colors
3. Chofoza ku- Blue Accent 1, Darker 25% ukushintsha wonke amalebuli namagugu eshadini kulowo mbala

Ukunciphisa Usayizi Wefonti Yegama Lesihloko

Usayizi wefonti ozenzakalelayo wesikhangiso seshadi yi-18 iphuzu elithinta olunye umbhalo futhi linciphisa indawo yendawo yeshadi. Ukuze silungise lesi simo sizokwehlisa usayizi wefonti lesitayela kuya kumaphoyinti angu-12.

1. Chofoza kwiSihloko soKhadi ukuze ukhethe - kufanele sizungezwe ibhokisi
2. Hudula ukhethe isihloko ukuze usiqokomise
3. Chofoza ngakwesokudla isihloko esiqokonyisiwe ukuvula imenyu yesimo
4. Chofoza kumcibisholo omncane ongaphansi kwesokudla kwesithonjana sefonti - inombolo engu-18 emgqeni ophezulu webha yamathuluzi womongo - ukuvula uhlu oludonsela phansi lwamasayizi wefonti atholakalayo
5. Chofoza ku- 12 kuhlu ukuze ushintshe ifayili yethimba leshadi kuya ku-12 iphuzu
6. Chofoza kusemuva leshadi ukuze ususe okugqamile kusihloko seshadi
7. Indawo yendawo yeshadi kufanele futhi ikhule ngesayizi

06 ka 09

Ukufometha umaka ovaliwe

Uphawu oluzenzakalelayo lokushicilela ishadi - olubonisa intengo yokugcina isitokwe - umugqa omncane omsindo omile. Esikhatsini sethu, umaka awukwazi ukubona - ikakhulukazi uma itholakala phakathi kwevolumu yemibhobho eluhlaza okwesibhakabhaka njengoba kunjalo ngo-6, 7, no-8 Febhuwari.

Ukuze silungise lesi simo, sizoguqula umaka kunxantathu lapho iphuzu eliphezulu limelela intengo yokuvala yesitoko salolo suku.

Sizophinde sishintshe usayizi nombala wendangxantathu ube ophuzi ukuze uphume ngokumelene nesizinda esibomvu semivimbo yevolumu.

Qaphela : Uma sishintsha umnikazi we- Close Close - tshela ngo-Febhuwari 6-kuphela umaki walowo suku uzoshintsha - okusho ukuthi kuzodingeka siphinde senze izinyathelo ezifanayo izikhathi ezine ukuze sishintshe wonke amaki.

Ukuze ushintshe umaki kuzo zonke izinsuku ezine ngesikhathi esisodwa kudingeka sishintshe ukungena okuvaliwe emlandweni weshadi.

Izinyathelo Zokufundisa

Njengengxenye yesandulela yesifundo, sizosebenzisa imenyu yokuqukethwe ukuze sigcwalise lesi sinyathelo.

Ukushintsha Umbala Wokumaka

1. Chofoza kanye kwendlovu ukuze ukhethe - kufanele ifakwe ibhokisi
2. Chofoza kanye ngegama Vala emlandweni ukuze ukhethe - igama elithi Close kuphela kufanele lizungezwe ibhokisi
3. Chofoza ngakwesokudla igama Vula ukuvula imenyu yemongo
4. Chofoza ku- Fometha Ukwaziswa kochungechunge lwemininingwane kubha yamathuluzi engqikithi ukuvula ibhokisi lengxoxo
5. Chofoza ku- Marker Gcwalisa ifasiteleni lesokunxele sebhokisi lengxoxo ye- Format Data Series
6. Chofoza kokugcwalisa okuqinile ewindini lokunene lebhokisi lengxoxo
7. Chofoza umcibisholo ophansi ngakwesokudla kwesithonjana sombala ngakwesokudla kwesandla ukuze uvule iphaneli ye- Colors
8. Chofoza ophuzi ngaphansi kwe- Standard Colors ukuze ushintshe umbala womaka ube ophuzi
9. Shiya ibhokisi lengxoxo evulekile isinyathelo esilandelayo ekufundiseni

Ukushintsha Uhlobo Lokumaka Nokulinganisa

1. Chofoza kuzinketho zokumaketha ngakwesokunxele kwifayela lebhokisi lebhokisi le- Idatha yokuDatha idatha
2. Chofoza ku- Yakhelwe ngaphakathi ngaphansi kokukhethwa kohlobo lwe-Marker ngakwesokudla kwesandla lebhokisi lebhokisi
3. Chofoza umcibisholo ophansi ngakwesokudla sohlobo lohlobo kulayini lokunene ukuze uvule uhlu lokudonsa phansi
4. Chofoza kunxantathu ohlwini ukuze ushintshe umaka
5. Ngaphansi kobukhulu, ukhetho ukwandisa ubukhulu bendangathathu kuya ku- 8
6. Chofoza inkinobho ethi Vala ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela .

07 ka 09

Ukushintsha Umbala Ongemuva Wesigcawu

Ukuze ushintshe umbala wangemuva we-ishadi lonke, sizophinde sisebenzise imenyu yokuqukethwe. Ukukhethwa kombala kwimenyu yesimo semidwebo kubhalwe njengombala ongacacile ngisho noma kubonakala sengathi kunegreyfu kunomhlophe.

Izinyathelo Zokufundisa:

1. Chofoza ngakwesokudla ngemuva kwekhadi elimhlophe ukuze uvule imenyu yesimo somdwebo
2. Chofoza umcibisholo omncane ophansi ngakwesokudla seSithombe sokugcwalisa ifomu - upende ungakwazi - kubha yamathuluzi yomongo ukuvula iphaneli ye- Theme Colors
3. Chofoza ku- White, Ingemuva 1, Okumnyama okungu-25% ukushintsha umbala wangemuva weshadi ube grey

08 ka 09

Ukushintsha Umbala Wendawo Yombala Ongemuva

Izinyathelo zokushintsha umbala wangemuva wendawo yesakhiwo zifana ngqo nalabo okushintsha umbala wangemuva weli shidi lonke.

Umbala okhethwe kulolu hlobo lweshadi kubonakala sengathi luhlaza okwesibhakabhaka nakuba lubekwe ohlwini oluhlaza okwesibhakabhaka kumbala webala.

Qaphela: Qaphela ukuba ungakhethi imigqa yegridi enezingqimba egijima endaweni yesakhiwo kunesizinda ngokwaso.

Izinyathelo Zokufundisa:

1. Chofoza ngakwesokudla ngemuva kwesizinda sangasese sendawo ukuze uvule imenyu yomongo wesimo sendawo
2. Chofoza umcibisholo omncane ophansi ngakwesokudla seSithombe sokugcwalisa ifomu - upende ungakwazi - kubha yamathuluzi yomongo ukuvula iphaneli ye- Theme Colors
3. Chofoza ku- Dark Blue, Umbhalo wesi-2, I-Lighter engu-80% ukushintsha umbala wangemuva wesakhiwo ukuze ukhanyise okwesibhakabhaka.

09 ka 09

Ukwengeza umphumela we-3-D we-Bevel nokuphinde uphinde uhlele Ishadi

Ukungeza i-3-D Effect Bevel

Ukwengeza umphumela we-bevel 3-D kuyi-touch yangempela yokwenza izimonyo okwenza kancane ukujula kushadi. Ushiya ishadi ngenqenqemeni elingaphandle elingaphandle.

1. Chofoza ngakwesokudla ngemuva kwekhadi elimhlophe ukuze uvule imenyu yesimo somdwebo
2. Chofoza kuKhetho lwamaShadi weShadi lethebula kubha yamathuluzi yomongo ukuze uvule ibhokisi lengxoxo
3. Chofoza kufomethi ye- 3-D efasiteleni lesokunxele sebhokisi lengxoxo yendawo yefomethi yeThebula
4. Chofoza umcibisholo ophansi ngakwesokudla kwesithonjana esiphakeme efasiteleni lesokudla sokuvula iphaneli yezinketho ze-bevel
5. Chofoza ku-inketho ye- Convex iphaneli ukuze usethe ukudelela kwe-convex eshadini
6. Chofoza inkinobho ethi Vala ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela

Hlela kabusha Ishadi

Ukulungisa kabusha ishadi kungenye isinyathelo sokuzikhethela. Inzuzo yokwenza ishadi elikhudlwana ukuthi liyanciphisa ukubukeka okuxubile okudalwe yi-axis yesibili yokuma ngakwesokunene kweshadi.

Kuzophinde kwandise ubukhulu bendawo yendawo eyenza idatha yedatha ibe lula ukuyifunda.

Indlela elula yokuguqula ishadi ukusebenzisa izibambo zokugqoka ezisebenza ngokuzungezile engxenyeni yangaphandle yeshadi uma uchofoza kuso.

1. Chofoza kanye kwirekhodi leshadi ukuze ukhethe ishadi lonke
2. Ukukhetha ishadi kunezela umugqa ohlaza okwesibhakabhaka ohlangothini lwangaphandle lweshadi
3. Ezingxenyeni zalolu luhlaka oluhlaza okwesibhakabhaka kukhona ukuphatha izinto
4. Hambisa isikhombisi sakho segundane ngaphezu kweyodwa yamakona kuze kube yilapho isichazamazwi sishintsha kumcibisholo omnyama ophethwe kabili
5. Lapho i-pointer yile mcibisholo ophethwe kabili, chofoza inkinobho yesinxele yesinxele bese uphonsa ngaphandle ukuze ukwandise ishadi. Ishadi lizophinde libe nosayizi kokubili ubude nobubanzi. Indawo yesakhiwo kufanele ikhule ngobukhulu.

Uma ngabe ulandele zonke izinyathelo kulokhu okufundiswa kuleli phuzu Ishadi Lama-Stock Market Eliphakeme-Eliphansi-Eliphansi lifanane nesibonelo esiboniswe esithombeni ekhasini 1 lale tutorial.