Rajistar Kasuwanci na Excel-High-Low-Close

01 na 09

Rajista Kasuwanci na Excel Overview

Ƙarin Maɓalli na Ƙananan Girma-Girma-Girma shine nau'in ma'auni wanda aka yi amfani da su na farko don nuna canje-canje a darajar dukiya mai ladabi - irin su hannun jari - a kan lokaci da aka ba.

Sassan sassa na ginshiƙi da ayyukansu shine:

• Lissafin da ke tsaye a kan zane yana nuna adadin darajar don samfurin don lokaci tare da saman layin da ke nuna farashin farashin mafi girma da kuma ƙasa na layin da ke nuna farashin mafi ƙasƙanci.
• Alamar alama - rawanin zane mai launin rawaya. Maganin sama na triangle yana nuna farashin ƙarshe ga jari
• Gumakan sandan da ke tsaye suna nuna ƙarar ko yawan hannun jari da aka saya don lokaci

Taimako na Taswirar Stock Market na Excel

Wannan koyaswar tana biye da ku ta hanyar ƙirƙirar kasuwa na kasuwa na Volume-High-Low-Close a Excel.

Koyarwar farko ta haifar da zane-zane na asali kuma sannan ta yi amfani da jerin zaɓuɓɓuka da aka jera a ƙarƙashin Abubuwan Taɗi a kan rubutun don samar da ginshiƙi da aka gani a cikin hoto a sama.

Tutorial Topics

1. Shigar da Zaɓin Bayanan Shafin
2. Ƙirƙirar Maɓalli na Ƙananan-Girma-Girma-Girgije
3. Amfani da Siffofin Shafin don ƙara Chart da Axes Titles
4. Tsarin Labarun Gigogi da Lambobi
5. Tsarin Maƙallan Alamar
6. Canza Shafin Yanayin Shafin Farko
7. Canza Plot Area Background Color
8. Ƙara Dalilan 3-D da ƙwaƙwalwar saiti

02 na 09

Shigar da Zaɓin Bayanan Shafin

Shigar da Bayanin Shafin

Mataki na farko a ƙirƙirar Haɗin Ƙananan-Ƙananan-Ƙananan shine shigar da bayanai a cikin takardun aiki .

Lokacin shigar da bayanai , kiyaye waɗannan dokoki a hankali:

• A duk lokacin da ya yiwu, shigar da bayananka cikin ginshikan kamar yadda aka nuna a hoton da ke sama
• Sanya kayan aikinku tare da take don kowane jerin bayanai a saman shafin da bayanai a cikin kwayoyin da ke ƙasa
• Kada ku bar layuka marar launi ko ginshiƙai lokacin shigar da bayananku saboda wannan zai haifar da yankunan da ba a san a cikin shafuka ba

Lura: Koyarwar ba ta haɗa da matakai don tsara tsarin aiki ba kamar yadda aka nuna a hoton da ke sama. Bayani game da zaɓuɓɓukan tsara aikin aiki suna samuwa a cikin wannan Tutorial Shirya Talla .

Zaɓin Bayanan Shafin

Da zarar an shigar da bayanai, mataki na gaba shine don zaɓar bayanan da za a adana shi.

A cikin takardun aiki na ainihi, kawai wani ɓangare na bayanan za a hada da shi cikin sashin layi. Zaɓin ko nuna alama ga bayanan, sabili da haka, ya gaya wa Excel abin da bayanin zai hada da abin da ya ƙi.

Bugu da ƙari, zuwa lambar ƙidayar, tabbatar da cewa sun hada da dukkanin lakabobi da layi waɗanda ke bayyana bayananku.

Tutorial Matakai:

1. Shigar da bayanai kamar yadda aka gani a cikin hoton da ke cikin sel A1 zuwa E6.
2. Jawo zaɓi Kwayoyin A2 zuwa E6 don haskaka su

03 na 09

Ƙirƙirar Maɓalli na Ƙananan-Girma-Girma-Girgije

Ana samun dukkan sigogi ƙarƙashin Saka shafin rubutun a cikin Excel.

Sanya linzamin linzaminka a kan sashin layi zai kawo bayanin siffin.

Danna a kan wani fannin yana buɗe wani digo mai nuna duk nau'in nau'i nau'i a wannan rukunin.

Lokacin ƙirƙirar kowane ginshiƙi a Excel, shirin ya fara haifar da abin da ake kira ma'auni mai amfani ta amfani da bayanan da aka zaɓa.

Bayan haka, yana da ku a tsara tsarin da ke amfani da samfurin Chart mai samuwa.

Tutorial Matakai:

1. Idan kuna amfani da Excel 2007 ko Excel 2010, danna kan Saka> Sauran Shafuka> Ƙari> Ƙararrawa-Ƙananan-Low-Close a cikin kintinkiri
2. Idan kana amfani da Excel 2013, danna kan Saka> Sanya Stock, Surface ko Radar Shafuka> Kasuwanci> Ƙararrawa-Ƙananan-Ƙananan-kusa a cikin kintinkiri
3. Ƙararren ma'auni na Ƙananan-Ƙananan-Girgije, kamar abin da aka gani a cikin hoton da ke sama, ya kamata a ƙirƙira kuma sanya a cikin takardar aikinku.

Matakan da suka rage a cikin rubutun koyawa na wannan ginshiƙi don daidaita siffar da aka nuna a Page 1.

04 of 09

Yin amfani da kayan aikin Shafin

Gano Taswirar Kayan Gida

Idan ya zo game da tsara hotunan a Excel, yana da mahimmanci ka tuna cewa baza ka yarda da tsarawar tsoho ba ga wani ɓangare na wani ginshiƙi. Ana iya canja dukkan sassa ko abubuwa na ginshiƙi.

Zaɓuɓɓukan tsarawa don sigogi sun fi yawanci a kan shafuka uku na rubutun da ake kira Ƙungiyar Shafin

Yawanci, waɗannan shafuka uku ba a bayyane ba. Don samun dama gare su, kawai danna kan tsarin da aka kirkiro da ku da shafuka uku - Zane, Layout, da Tsarin - an kara da su zuwa rubutun.

Sama da waɗannan shafuka uku, za ku ga rubutun Saitunan Kayan aiki .

A cikin matakai na ƙasa da ke ƙasa za mu ƙara da sake suna sunayen sarakuna da kuma maɓallin layi sannan kuma mu motsa sakon layi ta amfani da zaɓuɓɓukan da aka samo ƙarƙashin Layout tab.

Ƙara Matsayin Aiki na Gida

Gidan da aka kwance yana nuna kwanakin tare da kasan ginshiƙi.

1. Danna kan ma'auni na asali a cikin takardun aiki don kawo ɗayan shafuka na kayan aiki
2. Danna kan Layout tab
3. Danna maɓallin Axis don buɗe jerin saukewa
4. Danna maɓallin Aiki na Farko na Farko> Rubutun Aiki na ƙasa don ƙara sunan tsoho Axis Title zuwa chart
5. Jawo zaɓi tsohuwar lakabi don haskaka shi
6. Rubuta a cikin taken " Ranar "

Ƙara lambobin Aiki na Farko na Farko

Hanya na tsakiya na tsaye yana nuna ƙarar hannun jari da aka sayar a gefen hagu na ginshiƙi.

1. Danna kan ginshiƙi idan ya cancanta
2. Danna kan Layout tab
3. Danna maɓallin Axis don buɗe jerin saukewa
4. Danna maɓallin Lissafi na Farko na Farko> Zaɓin zaɓin Title don ƙara sunan tsoho Axis Title zuwa ginshiƙi
5. Jawo zaɓi tsohuwar lakabi don haskaka shi
6. Rubuta a cikin taken " Volume "

Ƙara maƙallin Lissafi na Farko

Hanya na biyu na tsaye yana nuna yawan farashin farashin da aka sayar tare da gefen dama na ginshiƙi.

1. Danna kan ginshiƙi idan ya cancanta
2. Danna kan Layout tab
3. Danna maɓallin Axis don buɗe jerin saukewa
4. Danna mahimman rubutun sakandare na biyu> Zaɓin zaɓin zaɓi don ƙara sunan tsoho Axis Title zuwa chart
5. Jawo zaɓi tsohuwar lakabi don haskaka shi
6. Rubuta a cikin taken " Stock Price "

Ƙara Rubutun Shafi

1. Danna kan ginshiƙi idan ya cancanta
2. Danna maɓallin Layout na rubutun
3. Danna Rubutun Chart> Aiki na Shafin don ƙara lambobin da aka ba da su na ainihi zuwa ginshiƙi
4. Jawo zaɓi tsohuwar lakabi don haskaka shi
5. Rubuta a cikin lakabin da ke ƙasa a kan layi biyu - amfani da Maɓallin shigarwa a kan keyboard don raba layin: Kayan Kayan Kayan Kuki na Cookie da Farashin

Ƙaddamar da Shafin Girma

Ta hanyar tsoho, labarin labarun yana samuwa a gefen dama na ginshiƙi. Da zarar mun ƙara mahimman lamuni na gefe na biyu, abubuwa suna da yawa a cikin wannan yanki. Don rage ƙwaƙwalwa za mu motsa labarin a saman sashin da ke ƙarƙashin maɓallin ginshiƙi.

1. Danna kan ginshiƙi idan ya cancanta
2. Danna maɓallin Layout na rubutun
3. Danna kan Faɗakar don buɗe jerin saukewa
4. Danna kan nuna Maɓalli a Zaɓin Zaɓin don motsa labarin a ƙasa da taken shafukan

05 na 09

Tsarin Labels da Lambobi

Zaɓuka Zaɓuɓɓukan Font

A mataki na baya, an ambaci cewa mafi yawan tsarin tsarawa don sigogi an samo a ƙarƙashin Chart Titles .

Wata ƙungiyar zabin tsarin da ba'a samuwa a nan su ne kayan aikin tsara kayan rubutu - irin su launi da launi, m, jigilar, da kuma daidaitawa.

Ana iya samun waɗannan a ƙarƙashin shafin shafin Rubutun - font section.

Danna Latsa Maɓallin Abubuwa da Toolbar

Hanyar da ta fi sauƙi, ko da yake, samun dama ga waɗannan zaɓuɓɓuka ita ce ta danna danna akan kashi da kake so ka tsara.

Yin haka yana buɗe maɓallin dama-dama ko menu na mahallin wanda ya hada da ƙananan kayan aiki.

Tun da yake yana cikin ɓangaren mahallin mahallin, zaɓuɓɓukan tsarawa akan sauƙin kayan aiki sun danganta da abin da ka danna.

Alal misali, idan ka danna-dama a kan ɗaya daga cikin ƙananan ƙananan ƙararrawa a cikin zane, kayan aikin kayan aiki yana ƙunshe ne kawai tsarin tsarawa wanda za a iya amfani da shi tare da wannan nau'in mahadar.

Danna-dama ɗaya daga cikin takalma ko labari ya ba ka tsarin zabin rubutu wanda yayi kama da waɗanda aka samu a ƙarƙashin shafin shafin Rubin.

Jagorar Maɓallin Gyara Hoto

A cikin wannan mataki na koyawa, muna so mu canza launi na duk lakabi, da labari, da lambobi - lambobin da kwanan wata a cikin ma'auni - zuwa launin launi mai kama da na ƙananan ƙarfe.

Maimakon yin kowanne ɗayan daban ko da yake, za mu iya ajiye wani lokaci ta hanyar canza launi na duk alamu da dabi'u a cikin sigogi a lokaci ɗaya.

Wannan gajeren hanya ya shafi zaɓin dukan sashin ta danna kan farar fata maimakon ka danna kan abubuwa ɗaya,

Tsarin dukkan lakabobi da darajar

1. Dama dama a kan farar fararen gefe don buɗe mahallin mahallin mahallin
2. Danna maɓallin ƙananan hagu zuwa hannun dama na Font Color icon a cikin mahaɗin kayan aiki na mahallin don buɗe mahaɗin Launuka
3. Danna kan Ƙarar Blue 1, Darker 25% don canza duk alamomi da dabi'u a cikin ginshiƙi zuwa wannan launi

Tsayar da Girman Rubutun Girma

Siffar jumlar tsoho don maɓallin ginshiƙi shine maki 18 wanda ya dandafs da sauran rubutun kuma ya rage yanki na filin. Don magance wannan halin da ake ciki za mu sauke ma'auni na lakabi zuwa matakai 12.

1. Danna maɓallin Chart don zaɓar shi - ya kamata a kewaye shi da akwatin
2. Jawo zaɓi lakabi don haskaka shi
3. Danna-dama a kan alamar haske don buɗe menu mahallin
4. Danna maɓallin ƙananan hagu zuwa hannun dama na Font Size icon - lambar 18 a cikin jeri na sama na kayan aiki na mahallin - don bude jerin jerin sauƙaƙe na samfuran masu yawa masu samuwa
5. Danna kan 12 a cikin jerin don canza lakabin lakabi zuwa lakabi 12
6. Danna kan gefen bayanan don share haskaka a kan maɓallin ginshiƙi
7. Yankin yanki na ginshiƙi ya kamata ya karu a girman

06 na 09

Tsarin Maƙallan Alamar

Alamar kusa ta kusa don ginshiƙi - wanda yake nuna alamar farashin rufewa - ƙananan layi ne na baki. A cikin sakonmu, alamar ba ta da wuya a gani - musamman ma lokacin da yake tsakiyar tsakiyar ƙananan zane kamar yadda yake a kan 6th, 7th, da 8th Fabrairu.

Don magance halin da ake ciki, za mu canza alamar zuwa alamar tauraron inda maɗaukaki yake wakiltar farashin farashin kayayyaki na wannan ranar.

Har ila yau, za mu canza girman da launi na triangle zuwa launin rawaya don haka yana tsaye a waje da ƙananan ƙarfe.

Lura : Idan muka sauya mutum Alamar alamar - faɗi don Fabrairu 6 - Alamar kawai don wannan ranar zai canza - ma'anar muna bukatar sake maimaita matakai guda hudu don canza dukkan alamu.

Don canza alamar alama ga dukan kwanakin hudu a lokaci ɗaya muna buƙatar canza Gidan Gina a cikin sashin layi.

Tutorial Steps

Kamar yadda a cikin mataki na gaba na koyawa, za muyi amfani da menu na mahallin don kammala wannan mataki.

Canza Girbin Alamar

1. Danna sau ɗaya a kan labari don zaɓar shi - ya kamata a kewaye shi da akwatin
2. Danna sau ɗaya a kan kalma Rufe cikin labarin don zaɓar shi - kawai kalmar Close ya kamata a kewaye da akwatin
3. Danna madaidaiciya akan kalma Bude don buɗe menu mahallin
4. Danna kan Zaɓin Bayanan Rarraba Bayanan a cikin kayan aiki na mahaɗin don bude akwatin maganganu
5. Danna Maɓalli Ya cika a cikin hagu na hannun hagu na maganganun Data Data
6. Danna kan Tabbatar Cika cikin maɓallin dama na akwatin maganganu
7. Latsa maɓallin ƙasa zuwa hannun dama na Ƙungiyar Launi a hannun dama don buɗe Ƙungiyar Launi
8. Danna kan rawaya a ƙarƙashin Launuka Tsare don canza launin alamar zuwa launin rawaya
9. Ka bar akwatin maganganu don buɗe mataki na gaba a cikin koyawa

Canza Alamar Alamar da Girma

1. Danna kan Zaɓuɓɓukan Maɓallan a cikin hagu na hannun hagu na akwatin maganganu na Data Series
2. Danna kan Bugu da kari a ƙarƙashin Yanayin Alamar Marker a hannun dama na akwatin maganganu
3. Danna kan maɓallin ƙasa zuwa hannun dama na gunkin icon a hannun dama don bude jerin jerin saukewa
4. Danna kan maƙallan a cikin jerin don canza alamar
5. A ƙarƙashin Girman , zabin ƙara yawan adadin ma'adinan zuwa 8
6. Danna maɓallin Gungura don rufe akwatin maganganu kuma komawa cikin takardun aiki .

07 na 09

Canza Shafin Yanayin Shafin Farko

Don canza launin launi na kowane ginshiƙi, za mu sake yin amfani da menu na mahallin. Za'a zabi launi mai launi a cikin mahallin mahallin kamar launi mai launi-fari ko da yake yana bayyana ya fi launin fari fiye da fararen.

Tutorial Matakai:

1. Dama dama a kan farar fararen gefe don buɗe mahallin mahallin mahallin
2. Danna maɓallin ƙananan hagu zuwa hannun dama na Shafi Fill icon - zane na iya - a cikin kayan aiki na kayan aiki don buɗe mahaɗin Launuka
3. Danna White, Bayanin 1, Darker 25% don canza launin launi na baya zuwa launin toka

08 na 09

Canza Plot Area Background Color

Matakan da za a canza launin launi na yanki na kusa kamar waɗanda ke canza launin launi don dukan jigon.

Launi da aka zaɓa don wannan nau'in mahadar yana bayyana kamar haske mai launin shuɗi ko da yake an lasafta shi azaman duhu a cikin launi.

Lura: Yi la'akari da kada ka zaba jerin layin grid da aka shimfiɗa a cikin filin yanki maimakon bayan gari.

Tutorial Matakai:

1. Danna danna a kan filin farar fata don buɗe filin yanki na yanki
2. Danna maɓallin ƙananan hagu zuwa hannun dama na Shafi Fill icon - zane na iya - a cikin kayan aiki na kayan aiki don buɗe mahaɗin Launuka
3. Danna kan Dark Blue, Rubutun 2, Sauƙaƙa 80% don canza wuri mai launi na yanki zuwa haske mai haske.

09 na 09

Ƙara Dalilan 3-D da ƙwaƙwalwar saiti

Ƙara Dalilan Ƙaddamarwa na 3-D

Ƙara mahimmanci na 3-D shine ainihin taɓawa wanda yake ƙara da zurfin zurfin zuwa zane. Ya bar chart tare da mai da ido a waje waje.

1. Dama dama a kan farar fararen gefe don buɗe mahallin mahallin mahallin
2. Danna Zaɓin Yanki na Zaɓuɓɓuka a cikin mahaɗan kayan aiki don bude akwatin maganganu
3. Danna maɓallin 3-D a cikin hagu na hannun hagu na akwatin maganganu na Chart Area
4. Danna maɓallin ƙasa zuwa hannun dama na Dutsen Dutsen a hannun dama don bude sashin layi na zaɓuɓɓuka
5. Danna maɓallin Convex a cikin kwamitin don saita adadi mai kyau zuwa chart
6. Danna maɓallin Gungura don rufe akwatin maganganu kuma komawa cikin takardun aiki

Sake zanen hoton

Maimaita zane shine wani mataki na zaɓi. Amfanin yin launi ya fi girma shi ne cewa yana rage siffar da aka tsara ta hanyar tafin gefe na biyu a gefen dama na ginshiƙi.

Har ila yau, zai kara yawan yanki na yanki wanda ya sa sauƙin rubutu ya fi sauƙi don karantawa.

Hanyar da ta fi dacewa don sake mayar da sutura ita ce ta yi amfani da ƙananan hanyoyi da suka zama masu aiki a kusa da gefen ginshiƙi bayan da ka danna kan shi.

1. Danna sau ɗaya a kan shafukan baya don zaɓar dukan ginshiƙi
2. Zaɓin ginshiƙi yana ƙara layin launi mai laushi zuwa gefen waje na ginshiƙi
3. A kusurwa na wannan zane-zane mai zane yana da manyan kayan aiki
4. Sauke maɓallin linzamin ka a kan kusurwar sasai har sai maɓin ya canza cikin arrow mai maƙalli guda biyu
5. Lokacin da maɓin shine wannan arrow mai maɓalli, danna maɓallin linzamin hagu kuma cire dan kadan dan kadan don fadada ginshiƙi. Zane zai sake girma a duka tsawonsa da nisa. Yankin yanki ya kamata ya karu da girman.

Idan ka bi duk matakai a cikin wannan koyaswar a wannan mahangar karamar kasuwa na Girma-High-Low-Close ya kamata yayi kama da misali da aka nuna a hoton a shafi na 1 na wannan tutorial.