I-Excel I-Excel Volume-High-Low-Close Isitoreji seSitokhwe seThengi

01 ka 09

I-Excel yeStock Market Isatifiketi

Isatifiketi se-stock-High-Low-Close ishicilelo yesitoreji yindlela yokutshintshwa kwebhayibhile okanye igrafu esetyenziswe ngokuyinhloko ukubonisa utshintsho kwixabiso lezinto eziphathekayo-ezifana nezitoko - ngexesha elithile.

Icandelo leenxalenye zetshathi kunye nomsebenzi wazo zi:

• Imigca engqinileyo yetshathi ibonisa uluhlu lwexabiso lesitokethi ixesha eliphezulu kunye nomgca wendlela ebonisa inani eliphezulu lezabelo kunye nezantsi lomgca obonisa ixabiso lentlawulo eliphantsi
• Umtsalane wokuvala - unxantathu ophuzi. Ingongoma yeyona nxantathu ibonisa intengo yokuvala yesitokisi
• Imivalo eluhlaza okwesibhakabhaka ibonisa ivolumu okanye inani lezabelo ezithengiswa ngexesha

I-Excel yeSitokethi seTyiteti yeSitokethi

Olu qeqesho lukuhamba ngokudala i-Shift Market-High-Low-Close ishiveke yemakethe ye-stock e-Excel.

Uqeqesho lokuqala ludala isatifiketi yesitokisi esisisiseko kwaye isebenzise iindlela zokufomatha ezidweliswe phantsi kweetrakthi zeTrart kwi- Ribbon ukuvelisa ishati ebonwe kumfanekiso ongentla.

Izihloko zeTutorial

1. Ukungena nokukhetha iDatha yeDatha
2. Ukudala Isatifiketi Esivakalayo-esiphezulu-esiphezulu
3. Ukusebenzisa iItshutshi zeTrash ukufaka i-Chart kunye neAxes Axes
4. Ukufometha amalebula kunye nexabiso
5. Ukufometha uMakishi oValiweyo
6. Ukutshintsha Umgca weNgingqi Umbala
7. Ukutshintshwa kwendawo yoMbala Umbala
8. Ukongeza umphumo we-3-D we-Bevel Effect kunye nokuCwangcisa iShadi

02 we-09

Ukungena nokukhetha iDatha yeDatha

Ukufaka iDatha yeDatha

Isinyathelo sokuqala ekudaleni isatifiketi seVolumu- ephezulu -Vala 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 kwi- Basic Excel Formatting Tutorial .

Ukukhetha iDatha yeDatha

Xa idatha ingeniswe, isinyathelo esilandelayo kukuba ukhethe idatha ukuba ifakwe.

Kwiphepha elifanelekileyo lomsebenzi, kuphela inxalenye yedata iya kufakwa kwishati. Ukukhetha okanye ukugqamisa idatha, ngoko, uxelela i-Excel ukuba yeyiphi idilesi ekufuneka ifake kunye nokuba yintoni engayihoyiyo.

Ukongeza kwidata yenombolo, qiniseka ukuba uquka zonke iikholomu kunye nezihloko zemiqolo ezichaza idatha yakho.

Amanyathelo okufundisa:

1. Faka idatha njengoko iboniswe kumfanekiso ongentla kwiiseli A1 ukuya kwi-E6.
2. Hudula ukhethe iiseli ze-A2 ukuya kwi-E6 ukuzigqamisa

03 ka 09

Ukudala Isatifiketi Esivakalayo-esiphezulu-esiphezulu

Zonke iitshathi zifunyenwe phantsi kweTayiti ye- Ribbon ye- Ribbon e-Excel.

Ukubeka i-pointer yakho ye mouse kwimigangatho yetshathi iya kuvelisa inkcazo yetshathi.

Ukuchofoza kwinqanaba livula ukuhla kwehla kubonisa zonke iintlobo zeeshati ezifumaneka kulolu hlobo.

Xa udala nayiphi na isati e-Excel, inkqubo yokuqala idala into ebizwa ngokuba isatiyi esisiseko usebenzisa idatha ekhethiweyo.

Emva koko, kukuya kuwe ukufomathiza isati usebenzisa i- Tools ekhoyo yeTyrt .

Amanyathelo okufundisa:

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. Isishwankathelo esisezantsi seMatriki-esezantsi-Vala i-stock market, efana neyayiboniswe kumfanekiso ongentla, kufuneka yenziwe ize ifakwe kwiphepha lakho lokusebenzela .

Amanyathelo asele kwiziko lokufundisa ukufomathiza le tstshana ukufanisa umfanekiso oboniswe kwi Page 1.

04 we-09

Ukusebenzisa iItrans Tools

Utshintsho lwezixhobo zeTrati

Xa kuziwa ekufomeni amashadi kwi-Excel, kubalulekile ukukhumbula ukuba akudingeki ukuba wamukele ukufomathiza okungagqibekanga kuyo nayiphi na into yetshathi. Zonke iindawo okanye izinto zetshathi zingatshintshwa.

Izinketho zokufomathiza zetshathi zifumaneka kwiithebhu ezintathu zebhanethi ezibizwa ngokuba ziTyhuthi zixhobo

Ngokuqhelekileyo, ezi zithebhu ezintathu azibonakali. Ukufikelela kuzo, nqakraza kwiqati elisisiseko owayidalile kunye namathathu amathathu - Ukuyila, ukuPhathwa, kunye neFomathi - zongezwa kwidbhoni.

Ngaphezulu kwezi zithuba ezintathu, uza kubona i- Chart Tools Tools .

Kwimanyathelo okufundisa apha ngezantsi siza kwengeza kwaye sichaze kwakhona izihloko zeeteksi kunye nesihloko seetati kunye nokuhambisa umxholo wetshathi usebenzisa izinto ezikhethwe phantsi kwetheyibhile yoLungiselelo lwetekisi.

Ukongeza I-Axis Title I-Horizontal

I-axis ene-horizontal ibonisa imihla ephantsi kwetadi.

1. Cofa kwichati eyisiseko kwiphepha lokusebenzela ukuze uvelise iithebhu zethuluzi leseshati
2. Cofa kwiTyhu yoTywala
3. Cofa kwiAxis Titles ukuvula uluhlu lokuhla
4. Cofa kwiSihloko se-Axisi esiPrayimari esiPhambili> Isihloko Ngezantsi kwe-Axis inketho yokongeza isihloko esizenzekelayo Isihloko se- Axis kwitshathi
5. Hudula ukhethe isihloko esizenzekelayo ukusigxininisa
6. Thayipha kwisihloko esithi " Umhla "

Ukongeza I-Axis yokuqala ye-Axis Title

I-axis eyona nto yokuqala ibonisa ixabiso lezabelo ezithengiswa ngecala lasekhohlo kwetshathi.

1. Cofa kwitshathi xa kuyimfuneko
2. Cofa kwiTyhu yoTywala
3. Cofa kwiAxis Titles ukuvula uluhlu lokuhla
4. Cofa kwiSiqendu se-Axisi esiPhezulu esiPrayimari> Ukhetho lweSitifiketi olujikelezayo ukufaka isihloko esiyiNtloko kwisiXhosa
5. Hudula ukhethe isihloko esizenzekelayo ukusigxininisa
6. Thayipha kwisihloko esithi " Umqulu "

Ukongeza I-Axis I-Axis Title eSekondari

I-axis ebonakalayo yesibini ibonisa uluhlu lweentengo zentengiso ezithengiswa kwicala lasekunene letshathi.

1. Cofa kwitshathi xa kuyimfuneko
2. Cofa kwiTyhu yoTywala
3. Cofa kwiAxis Titles ukuvula uluhlu lokuhla
4. Cofa kwiSixikethi se-Axisi eSekondari eSekondari> Ukhetho lweSihloko olujikelezayo ukuze ungeze isihloko esizenzekelayo Isihloko se- Axis kwishati
5. Hudula ukhethe isihloko esizenzekelayo ukusigxininisa
6. Thayipha kwisihloko esithi " Ixabiso lentengo "

Ukongeza Isihloko soTyati

1. Cofa kwitshathi xa kuyimfuneko
2. Cofa kwiTyhu yoLungiselelo yerbhoni
3. Cofa kwiSihloko soTyati> Ukhetho olungaphezulu kweTyrt ukuze ungeze isihloko seTreyiti esizenzekelayo kwishati
4. Hudula ukhethe isihloko esizenzekelayo ukusigxininisa
5. Thayipha kwisihloko esingezantsi kwimigca emibini - sebenzisa ukhiye wokungena kwikhibhodi ukuze uhlukanise imigca: I-Cookie Shop Stock Volume kunye nexabiso

Ukuhambisa iThethi yeTati

Ngokungagqibekanga, i-legend yetshathi ikhona kwicala lasekunene leseshati. Xa sithe wongeza isihloko sesibini se-axis, izinto zifumana indawo encinane kuloo ndawo. Ukunciphisa ukudibanisa siya kuhambisa umgca phezulu kwitshathi ngaphantsi kwesihloko seetati.

1. Cofa kwitshathi xa kuyimfuneko
2. Cofa kwiTyhu yoLungiselelo yerbhoni
3. Cofa kwiGosa lokuvula uluhlu lokuhla
4. Cofa kwi- Show Legend kwi-Top option ukuhambisa umgca ukuya kwinqanaba lesicatshulwa ngaphantsi

05 ka 09

Ukufakela iiLebhile zeTrafikhi kunye namaxabiso

Izinketho zokufometha kwefonti

Kwinqanaba elidlulileyo, kwakhankanywe ukuba ezininzi zeendlela zokufomathiza zamashadi zazifumaneka phantsi kweeTyitile zeTrart .

Elinye iqela leendlela zokufomatha ezingekho apha zixhobo zokufomathiza itekisi - njengobungakanani besitayela kunye nombala, isibindi, italics kunye nokulungelelaniswa.

Ezi zingatholakala phantsi kweTebhu yaseKhaya yecandelo lomgca wefonti.

I-Excel Cofa iqhosha leMenu kunye nebarbar yesixhobo

Indlela elula, nangona kunjalo, yokufikelela ezi zikhetho ngokuchanekileyo kwiqhosha ofuna ukuyifometha.

Ukwenza njalo kuvula iqhosha lokunqakraza okanye umxholo oquka ibha yamathuluzi okufometha amancinci.

Ekubeni liyinxalenye yemenyu yomxholo, ukhetho lokufomathiza kwibar yamathuluzi lutshintsho kuxhomekeke kwinto ochofoze kuyo.

Umzekelo, ukuba unqakraza ngokukodwa kwimiqulu yevolumu ebluhlaza kwitshathi wena ibar yomxholo iqukethe kuphela iindlela zokufometha ezingasetyenziswe ngale nto yetshathi.

Ukuchofoza ngokuchanekileyo enye yeetayile okanye iimbali kukunika ukhetho lwefomati olukhethiweyo olufana nalabo abathotyelwe phantsi kwethebhu yaseKhaya yebhebhoni.

Ukufometha Isatifiketi

Kule nyathelo ye-tutorial, sifuna ukutshintsha umbala wezo zonke izihloko, i-legend, kunye nemilinganiselo - iinombolo kunye nemihla kwimilinganiselo yeekhonkco - kumbala obomvu ofana neyovalo yevolumu.

Esikhundleni sokwenza ngamnye umntu ngokwahlukileyo nangona, sinokuzigcina ixesha elithile ngokutshintsha umbala wazo zonke iibhile kunye neempawu kwiitshathi ngexesha elinye.

Le mfutshane iquka ukukhetha isatshixo ngokupheleleyo ngokuchofoza kwimvelaphi emhlophe kunokuba ucofe kwizinto ezithile,

Ukufometha zonke iiLabel kunye neemilinganiselo

1. Ukucofa ngokuchanekileyo kwimvelaphi emhlophe yetshathi ukuvula imenyu yenkcazelo yetshathi
2. Cofa kwiincinci ezantsi ezantsi kwesokudla se- Font Color icon kwi-barbar yomxholo ukuvula iPaneli Yemibala Yemibala
3. Cofa kwi- Blue Accent 1, Emnyama 25% ukuguqula zonke iilebula kunye nezindinganiso kwitshati kumbala

Ukunciphisa Ireyiti yesiGaba soBugcisa

Ubungakanani befonti obungagqibekanga kwinqanaba leseshati liyi-18 iphuzu elincinci lenye itekisi kunye nokunciphisa indawo yesalathisi yetshathi. Ukulungisa le meko siza kuhlawula ubungakanani besitayela seetayiti ukuya kuma-12 amanqaku.

1. Cofa kwiSihloko soTyati ukuze ukhethe - kufuneka sijongwe ngebhokisi
2. Hudula ukhethe isihloko ukuze usigqwezele
3. Nqakraza ngakwesokudla kwisihloko esiqakathekileyo sokuvula imenyu yomongo
4. Cofa kwisincinci esincinci ukuya kwesokudla se icon Font Size - inombolo 18 kumgca ophezulu kwibar yomxholo wendawo - ukuvula uluhlu oluphantsi lwezinto ezikhoyo zobungakanani befonti
5. Cofa kwi- 12 kwoluhlu ukutshintsha ifayili yecatshi ukuya kwinqanaba eli-12
6. Cofa kwingembo yetshathi ukuze ususe ukugqwesa kwihloko yetshathi
7. Indawo yesalathisi yetshathi kufuneka ikhulise ngobukhulu

06 ka 09

Ukufometha uMakishi oValiweyo

Ummakishi osondeleyo osondeleyo kwitshathi - ebonisa intengo yokuvala isitofu - ngumgca omncinci omnyama ongezantsi. Kwitshati yethu, umakishi akanakukubona ukubona - ingakumbi xa ikhona phakathi kwimiqulu yemibhobho eluhlaza njengokuba kunjalo ngomhla we-6, wesi-7 ne-8 kaFebhuwari.

Ukulungisa le meko, siya kutshintsha ummakishi kunxantathu apho inqaku eliphezulu limela intengo yokuvala yesitokethi ngaloo mini.

Sizakuguqula ubukhulu kunye nombala wendxantathu ibe yilephu ukwenzela ukuba umele ukhangele imvelaphi ebomvu yemivalo yevolumu.

Qaphela : Ukuba sitshintsha umntu ovala uphawu-Veza ngo-Febhuwari 6-kuphela umakishi waloo mhla uya kutshintsha-kuthetha ukuba kufuneka siphinda amanyathelo afanayo maxesha amane ukutshintsha onke amanqaku.

Ukutshintsha ummaki kuzo zonke ezine iintsuku kanye kanye kufuneka sitshintshe ukungena okuValiweyo kwingcamango yetshathi.

Iimfundiso zeTutorial

Njengoko kwinqanaba langaphambili le-tutorial, siza kusebenzisa imenyu yomxholo ukugqiba eli nyathelo.

Ukutshintsha Umbala weMpawu

1. Cofa kanye kwinqanaba lokulikhetha - kufuneka lijikelezwe ibhokisi
2. Cofa kanye ngelizwi Vala kwi-legend ukuyikhetha - nje igama eliValiweyo kufuneka lijikelezwe ibhokisi
3. Cofa iqhosha kwigama Vala ukuvula imenyu yomongo
4. Cofa kwiFomathi yeCandelo loLwazi lweDatha kwi-barbar yomxholo ukuvula ibhokisi yencoko
5. Cofa kwiMarker Gcwalisa ifowuni yesandla sokunxele sebhokisi yencoko yababini yoCwangciso lweDatha
6. Cofa kwi- Solid Gcwalisa kwiwindow yokunene kwibhokisi yencoko
7. Cofa kwinqolo engezantsi ukuya kwesokudla seMpawu yombala kwiwindow yokunene ukuze uvule ipaneli yamabala
8. Cofa ngephuzi ngaphantsi kweMigangatho yeMigangatho ukutshintsha umbala wokumakisha ube luphuzi
9. Shiya ibhokisi yencoko evulekileyo kwisinyathelo esilandelayo kwisifundo

Utshintshe uhlobo loMakaki kunye noKuphawu

1. Cofa kwiKhetho lokuMakisha kwiwindow ekhohlo lwefayile yencoko yoBucuko lweDatha yeDatha
2. Cofa kwiZakhiwo ezakhelwe phantsi kohlobo lweMpawu zoMakishi kwiwindow yokunene kwibhokisi yencoko
3. Cofa kwinqolo ekhohlo ukuya kwesokudla sohlobo lohlobo kwifestile lesandla sokunene ukuvula uluhlu lokuhla
4. Cofa kwixantathu kuloluhlu ukuguqula umakishi
5. Ngaphantsi kobukhulu, ukhetho ukwandisa ubungakanani benxantathu ukuya ku- 8
6. Cofa kwiQhosha eliValiweyo ukuvala ibhokisi yencoko kwaye ubuyele kwiphepha lokusebenzela .

07 ka 09

Ukutshintsha Umgca weNgingqi Umbala

Ukutshintsha umbala wangasemva kweshati, siya kuphinda sisebenzise imenyu yomongo. Uhlobo lombala kwimenyu yomongo lubhalwe njengombala omhlophe ngaphandle nangona kubonakala kuluhlaza kunamhlophe.

Amanyathelo okufundisa:

1. Ukucofa ngokuchanekileyo kwimvelaphi emhlophe yetshathi ukuvula imenyu yenkcazelo yetshathi
2. Cofa kwiincinci ezantsi ezantsi kwesokudla se- Shape Fill icon - ipeyinti inakho-kwibar yomxholo wendawo yokuvula i-panel Colors panel
3. Cofa kwi- White, Imvelaphi ye-1, i-Darker 25% ukutshintsha umbala wesiqalo somtya kwi-grey

08 ka 09

Ukutshintshwa kwendawo yoMbala Umbala

Amanyathelo okutshintsha umbala wesiqendu kwendawo yesalathisi ephantse efana nalabo abashintsha umbala wesiqendu kwitshati yonke.

Umbala okhethwe kule nkalo yetshathi ibonakala njengombala obomvu nangona kubhalwe njengobomvu obomvu kwipaneli yombala.

Qaphela: Qaphela ukuba ungakhethi imigca yegridi ejikelezayo ehamba kwindawo yendawo yeqonga kunokuba imvelaphi ngokwayo.

Amanyathelo okufundisa:

1. Ukucofa ngakwesokudla kwendawo yangasese yendawo yokuvula ukuvula imenyu yomxholo wendawo yengingqi
2. Cofa kwiincinci ezantsi ezantsi kwesokudla se- Shape Fill icon - ipeyinti inakho-kwibar yomxholo wendawo yokuvula i-panel Colors panel
3. Cofa kwiBlue Blue, Text 2, I-Lighter i-80% ukutshintsha umbala wesiqendu sommandla wokukhanya obala.

09 we 09

Ukongeza umphumo we-3-D we-Bevel Effect kunye nokuCwangcisa iShadi

Ukongeza umphumo we-3-D we-Bevel Effect

Ukongeza umphumo we-3-D umphumo wobuqhetseba obunconyayo obongeza ubuncinane kwitshathi. Ushiya ishati ngokubhekisele ngaphandle.

1. Ukucofa ngokuchanekileyo kwimvelaphi emhlophe yetshathi ukuvula imenyu yenkcazelo yetshathi
2. Cofa kwiKharithi yeTrafik yeNgingqi kwi-bar toolbar ukuvula ibhokisi yencoko
3. Cofa kwifayile ye- 3-D kwifestile yesandla sokunxele sebhokisi yencoko yendawo yefayile yefomathi
4. Cofa kwitolo eliphantsi ukuya kwesokudla se icon ephezulu kwiwindow yokunene ukuvula iphaneli yezinketho ze-bevel
5. Cofa kwiConvex inketho kwiphaneli ukusetha umgca wokutshintshela kwitshathi
6. Cofa kwiQhosha eliValiweyo ukuvala ibhokisi yencoko kwaye ubuyele kwiphepha lokusebenzela

Ukuphonononga kwakhona iTharthi

Ukulungiswa kwakhona kwetadi enye inyathelo lokuzikhethela. Inzuzo yokwenza ishadi elikhulu kukuba liyanciphisa ukubukeka okubanzi okudalwe yisekhsi yesibini engezantsi ngakwesokunene kwiteksi.

Kuya kwandisa ubungakanani bendawo yesalathisi eyenza idatha yetshathi ibe lula ukuyifunda.

Indlela elula yokutshintsha isatshati ukusebenzisa izicwangciso zokubamba ezisebenzayo ezisebenzayo ngaphaya komda wangaphandle kwetshathi emva kokuchofoza kuyo.

1. Nqakraza kamva kwitektha yetshathi ukuze ukhethe ishadi lonke
2. Ukukhetha ishati kufaka umgca oluhlaza okwesibhakabhaka ukuya kumda wangaphandle kwetshathi
3. Kwiinkalo zalo mphahla eluhlaza okwesibhakabhaka ziyakwenza izicwangciso
4. Hambisa i-pointer yakho ye mouse phezu kwelinye lamacangci kude kube i-pointer ishintshela kwintolo emnyama ebanzi
5. Xa i-pointer yile ntloko eneentloko ezimbini, nqakraza iqhosha lasekunene le mouse kwaye uphume ngaphandle ukuze ukwandise ishati. Ishati iya kubuya kwakhona ngobubanzi nobubanzi. Indawo yesalathisi kufuneka ikhulise ngobukhulu.

Ukuba ulandele onke amanyathelo kule khokelo kule ngxelo, umtshini wakho we-Stock-High-Low-Close Market Market ufanane nomzekelo oboniswe kumfanekiso kwiphepha 1 yale khokelo.