01 ya 09
Chitsanzo cha Msika wa Stock Excel
Chithunzi cha Msika Wogulitsa Msika Wachidule Ndi mtundu wa tchati kapena graph zomwe zimagwiritsidwa ntchito makamaka kusonyeza kusintha kwa mtengo wa katundu wogulitsa - monga masitima - pa nthawi yapadera.
Zina mwazigawo za tchati ndi ntchito zake ndi izi:
- Mzere wochepa wokhoma pa tchati ukuwonetsera zamtengo wapatali zogulitsa kwa nthawiyo ndi pamwamba pa mzere wowonetsera mtengo wamtengo wapatali ndi pansi pa mzere wowonetsa mtengo wamtengo wapatali kwambiri
- Mzere wotsekemera - katatu chikasu. Phokoso lakumtunda la katatu likuwonetsa mtengo wotseka wa katundu
- Mabotolo ozungulira a buluu amasonyeza vesi kapena nambala ya magawo ogulitsidwa pa nthawi
Msonkho wa Masitolo a Stock Excel
Maphunzirowa akukutsogolerani popanga tchati cha Masitolo a Zogulitsa Pakati Pafupi.
Choyamba phunziroli limapanga tchati chachitsulo chachikulu ndikugwiritsa ntchito njira zosankha zomwe zili pansi pa Chitsulo Chayi pa Riboni kuti zibweretse tchati chomwe chikuwonetsedwa pa chithunzi pamwambapa.
Mitu Yophunzitsa
- Kulowa ndi Kusankha Data Chachidule
- Kupanga Chinthu Choyambirira-Tchati Chokwera Kwambiri
- Kugwiritsa ntchito Chithunzithunzi Chakuda kuwonjezera Matawo ndi Mitu Yotchulidwa
- Malemba ndi Makhalidwe A Chati
- Kupanga zojambula zowonekera
- Kusintha Chapafupi Chigawo Chakumbuyo
- Kusintha Chigawo Choyambira
- Kuonjezerapo zotsatira za 3-D Zowonongeka ndi Kukonzanso Tchati
02 a 09
Kulowa ndi Kusankha Data Chachidule
Kulowa Data Data
Chinthu choyamba pakupanga tchati Chokwanira-Chotsika Chotsatira ndicholowetsa deta muzenera .
Mukalowetsa deta , kumbukirani malamulo awa:
- Pamene kuli kotheka, lowetsani deta yanu muzitsulo monga momwe tawonetsera pa chithunzi pamwambapa
- Ikani pepala lanu lamasewero ndi mutu wa mndandanda uliwonse wa deta pamwamba pa chigawocho ndi deta mu maselo omwe ali pansipa
- Musasiye mzere kapena mizere yopanda kanthu mukalowetsa deta yanu momwe izi zidzakhalire opanda kanthu pa tchati
Zindikirani: Maphunziro samaphatikizapo masitepe opangidwira tsambali monga momwe taonera pa chithunzi pamwambapa. Zomwe mungapange pazomwe mungapangire zolemba pamasewerawa zikupezeka mu phunziroli la Basic Excel Formatting .
Kusankha Data Data
Deta ikadalowa, sitepe yotsatira ndiyo kusankha deta kuti ikhale yolembedwa.
M'masamba enieni, gawo limodzi la deta likhoza kuphatikizidwa pa tchati. Kusankha kapena kufotokozera deta, kotero, imauza Excel zomwe zili ndizolemba ndi zomwe zimanyalanyaza.
Kuphatikiza pa chiwerengero cha chiwerengero, onetsetsani kuti mukuphatikizapo mndandanda wa mndandanda ndi maina omwe akufotokozera deta yanu.
Maphunziro:
- Lowani deta monga momwe mukuwonera pa chithunzi pamwambapa mu maselo A1 mpaka E6.
- Kokani osankha maselo A2 kuti E6 awoneke
03 a 09
Kupanga Chitsa Choyambirira-Tchati Chokwera Kwambiri
Makhadi onse amapezeka pansi pa Insert tab ya Ribbon mu Excel.
Kuyika pointer yanu yamagulu pa gulu la tchati kudzafotokozera tchatichi.
Kusindikiza pa gulu kumatsegula pansi ndikuwonetsa mitundu yonse ya tchati yomwe ilipo mu gawo limenelo.
Pogwiritsa ntchito tchati iliyonse mu Excel, pulogalamuyi imayambitsa zomwe zimatchedwa tchati loyambirira kugwiritsa ntchito deta yosankhidwa.
Pambuyo pake, ndi kwa inu kukonza tchati pogwiritsa ntchito zida za Chati .
Maphunziro:
- Ngati mukugwiritsa ntchito Excel 2007 kapena Excel 2010, dinani pa Insert> Other Charts> Stock> Vuto-Low-Low-Close mu nkhono
- Ngati mukugwiritsa ntchito Excel 2013, dinani pa Insert> Insert Stock, Surface kapena Radar Charts> Stock> Low-Low-Low-Close mu nkhono
- Chojambula chamsika chamakono chokwanira Chotsitsa Pakati, chofanana ndi chomwe chikuwonetsedwa pa chithunzi pamwambapa, chiyenera kukhazikitsidwa ndikuyikidwa patsamba lanu.
Zotsalira zomwe zili mu phunziroli zimapanga chithunzi ichi kuti chifanane ndi chithunzi chomwe chili pa Tsamba 1.
04 a 09
Kugwiritsa ntchito Chithunzithunzi Zida
Zida Zamatsenga
Ponena za malemba ojambula mu Excel, nkofunika kukumbukira kuti simukuyenera kuvomereza kusintha kwachinsinsi kwa gawo lililonse la tchati. Mbali zonse kapena zigawo za tchati zikhoza kusinthidwa.
Zokonzera zojambulazo za ma chart makamaka zimapezeka pa ma tebulo atatu a riboni omwe amatchedwa Chachi Tools
Kawirikawiri, ma tepi atatu sali owoneka. Kuti muwapeze, dinani pa chithunzi choyambirira chomwe mwangopanga ndi matabu atatu - Kulinganiza, Kuyika, ndi Maonekedwe - akuwonjezeredwa ku riboni.
Pamwamba pa ma tabo atatuwa, mudzawona mutu wa Chati Tools .
Muzitsatila za m'munsimu tidzawonjezera ndi kutchula dzina la maudindo komanso mutu wa tchati komanso kusuntha nthano za tchati pogwiritsa ntchito njira zomwe zili pansi pa tabu ya Chida chachitsulo.
Kuwonjezera Mzere Wosakaniza Mutu
Mzere wosakanikirana umasonyeza masiku omwe ali pansi pa tchati.
- Dinani pa tchati chofunikira pa tsambalo kuti mukweretse ma tabu a zida
- Dinani pa Tsambali layout
- Dinani pa Axis Titles kuti mutsegule mndandanda wotsika
- Dinani pa Primary Primary Horizontal Axis Title> Title Pansi pa Axis mungakonde kuwonjezera mutu wosasintha Title Axis kwa chart
- Kokani mutu wosasinthika kuti uwoneke
- Lembani mutu wakuti " Tsiku "
Kuwonjezera Mutu Woyimilira Wotsindika
Chigawo choyang'ana choyimira chikuwonetsera mavoti omwe amagulitsidwa kumbali ya kumanzere kwa tchati.
- Dinani pa tchati ngati kuli kofunikira
- Dinani pa Tsambali layout
- Dinani pa Axis Titles kuti mutsegule mndandanda wotsika
- Dinani pa Primary Primary Vertical Axis Title> Chosinthidwa Chotsatira Chothandizira kuti muwonjezere mutu wosasinthika mutu Wotsitsa Title ku chart
- Kokani mutu wosasinthika kuti uwoneke
- Lembani mutu wakuti " Volume "
Kuwonjezera Mutu Wachilendo Wowonjezera
Mzere wachiwiri wowonongeka ukuwonetsera kuchuluka kwa mitengo yamtengo wogulitsidwa kumbali yakumanja ya tchati.
- Dinani pa tchati ngati kuli kofunikira
- Dinani pa Tsambali layout
- Dinani pa Axis Titles kuti mutsegule mndandanda wotsika
- Dinani pa Mndandanda Wachigawo Chachilumikizidwe Chotsatira> Chosinthidwa Chotsatira Chotsatira kuti muwonjezere mutu wosasinthika mutu Wotsitsa Title ku chart
- Kokani mutu wosasinthika kuti uwoneke
- Lembani mutu wakuti " Mtengo wa Zagulitsa "
Kuwonjezera Mutu wa Chati
- Dinani pa tchati ngati kuli kofunikira
- Dinani pa Tsatanetsatane tab ya riboni
- Dinani pa Tsati la Chitsitsi> Chakudya Chachikulu pamwamba pazithunzi kuti muwonjezere Chithunzi Chachaputala chachaputala pa tchati
- Kokani mutu wosasinthika kuti uwoneke
- Lembani mutu womwe uli pansipa pa mizere iwiri - gwiritsani ntchito Key entry mu makina kuti agawani mizere: The Cookie Shop Stock Volume ndi mtengo
Kusuntha Lamulo la Tchati
Mwachinsinsi, nthano ya tchati ili pa dzanja lamanja la tchati. Titangowonjezera mutu wothandizira wotsindikiza, zinthu zimakhala zochepa kwambiri m'deralo. Pochepetsa kuchepetsedwa tidzasunthira nthano pamwamba pa tchati pansi pa mutu wa chithunzi.
- Dinani pa tchati ngati kuli kofunikira
- Dinani pa Tsatanetsatane tab ya riboni
- Dinani pa Lembali kuti mutsegule mndandanda wotsika
- Dinani pawonetsani Lamulo pa Njira Yabwino kuti musunthane nthano pansi pa mutu wa tchati
05 ya 09
Kupanga Malemba ndi Makhalidwe Atsati
Zosankha Zolemba Maonekedwe
Mu sitepe yapitayi, adatchulidwa kuti ambiri mwazithunzi zojambula zazithunzi zili pansi pa maudindo Atsati .
Gulu limodzi la zosankha zojambulidwa zomwe sizipezeka pano ndizolemba zida zolemba - monga kukula kwa mazenera ndi mtundu, bold, italics, ndi mgwirizano.
Izi zikhoza kupezeka pansi pa tsamba la Home la riboni - mazenera gawo.
Zolemba Powonongeka Pamanja Pamanja ndi Toolbar
Njira yophweka, komabe, pakupeza njira izi ndikulumikiza molondola pa zomwe mukufuna kupanga.
Kuchita zimenezi kumatsegula pang'onopang'ono zolongosola kapena zolemba zomwe zili ndi timatabwa tating'ono.
Popeza ndi mbali ya mndandanda wamakono, zosankha zomwe mungapange pazamasamba zikusintha malinga ndi zomwe mwazilemba.
Mwachitsanzo, ngati mutsegula molondola pa imodzi ya voliyumu ya voliyumu mu tchatiyi, chombocho chimakhala ndi njira zokhazokha zomwe zingagwiritsidwe ntchito ndi gawoli.
Kulemba molondola imodzi ya matayala kapena nthano kukupatsani zolemba zolemba zofanana zomwe zikupezeka pansi pa tsamba la Home la Ribbon.
Kujambula Tchati Chotsitsa
Mu gawo ili la phunziroli, tikufuna kusintha mtundu wa maudindo onse, nthano, ndi chiyeso - nambala ndi nthawi mu mamba yachitsulo - ku mtundu wa buluu wofanana ndi wa voliyumu.
M'malo mochita chilichonse mosiyana, tingathe kusunga nthawi mwa kusintha mtundu wa malembo onse ndi zofunika pa tchati nthawi imodzi.
Njira yotsatilayi ikuphatikizapo kusankha tchati chonse poyang'ana pa chiyero choyera m'malo moyika pazomwe zilipo,
Kupanga Malemba Onse ndi Malamulo
- Dinani pazithunzi zoyera kuti mutsegule mndandanda wazithunzi
- Dinani pamsana wawong'ono mpaka kumanja kwa Chithunzi Chajambula Chokongoletsera muzithunzithunzi zamakono kuti mutsegule Pulogalamu Yoyang'ana Mutu
- Dinani pa Blue Accent 1, Mdima 25% kuti musinthe malemba onse ndi malingaliro ake pa tchatichi mpaka mtunduwo
Kuwongolera Tsamba la Tsamba la Tsamba
Kukula kwa mausitidwe osasinthika pa mutu wa chithunzi ndi mfundo 18 yomwe imaphatikizapo malemba ena komanso imachepetsanso dera lachitsulo. Kuti tithetse vutoli tidzasiya kukula kwa mutu wa tchati pazithunzi 12.
- Dinani pa Tsatanetsatane wa Chati kuti muzisankhe - ziyenera kuzunguliridwa ndi bokosi
- Kokani mutu kuti uwonetsetse
- Dinani pamanja pamutu wapamwamba kuti mutsegule mndandanda wa masewera
- Dinani pazitsulo zazing'ono mpaka kumanja kwa Chithunzi Chachizindikiro - nambala 18 mu mzere wapamwamba wa toolbar - kutsegula mndandanda wotsika wa maonekedwe apamwamba
- Dinani pa 12 m'ndandanda kuti musinthe ndondomeko ya mutu wa tchati kuti mufike pa mfundo 12
- Dinani kumbuyo kwa tchati kuti muwonetsetse zofunikira pa mutu wa tchati
- Chigawo chokhazikika cha tchatichi chiyeneranso kuwonjezeka kukula
06 ya 09
Kupanga zojambula zowonekera
Chotsatira chachinsinsi chachitsulo - chomwe chimasonyeza mtengo wogulitsa - ndi mzere wochepa wakuda wosakanikirana. M'ndandanda yathu, chikhomocho sichitheka kuwona - makamaka ngati chiri pakati pa buluu la voliyumu monga momwe zilili pa 6, 7, ndi 8 Februwari.
Kuti tithetse vutoli, tidzasintha chizindikiro ku katatu komwe pamwamba pake ikuimira mtengo wotseka wa katundu wa tsikulo.
Tidzasintha kukula kwake ndi mtundu wa katatu kuti ukhale wachikasu kuti uime motsutsana ndi buluu la mipiringidzo.
Zindikirani : Ngati titasintha munthu Wotseka Malire - lankhulani pa February 6 - kokha chizindikiro cha tsikulo chidzasintha - kutanthauza kuti tifunika kubwereza masitepe omwewo kuti tisinthe zizindikiro zonse.
Kusintha chizindikiro pamasiku onse anayi nthawi yomweyo tifunika kusintha Kowalowetsa muzithunzi za tchatichi.
Maphunziro Otsogolera
Monga mu sitepe yapitayi ya phunzirolo, tidzakambirana zolemba zomwe tikuyenera kuchita kuti titsirize sitepe iyi.
Kusintha Mtundu Wachizindikiro
- Dinani kamodzi pa nthano kuti muzisankhe - ziyenera kuzunguliridwa ndi bokosi
- Dinani kamodzi pa liwu Lembani mwatsatanetsatane kuti muzisankhe - mawu okha Close ayenera kuzunguliridwa ndi bokosi
- Dinani pa mawu oti Tsekani kutsegula mndandanda
- Dinani pa Foni ya Dongosolo la Deta muzitsulo zamakono kuti mutsegule dialog box
- Dinani pa Marker Lembani zenera lamanzere lawonekedwe la bokosi la Format Data Series
- Dinani pa Zowirikiza Lembani muwindo lamanja la dialog
- Dinani kumsana wotsika kupita kumanja kwa chithunzi chakumanja kuwindo lamanja kuti mutsegule gulu la Colors
- Dinani chikasu pansi pa Standard Colours kuti musinthe mtundu wa chilembo kukhala wachikasu
- Chokani ku bokosi lamasamba kutsegulira gawo lotsatira mu phunziroli
Kusintha mtundu wa Marker ndi Kukula
- Dinani pa Makanema a Marker muwindo lamanzere lawonekedwe la Format Data Series
- Dinani pa Zomangidwe pansi pa Zolemba Zamtundu Wachizindikiro muwindo lamanja la dialog
- Dinani kumsana wotsika kupita kumanja kwa chithunzi chayimanja muwindo lamanja kuti mutsegule ndondomeko yochepetsa
- Dinani pa katatu mu mndandanda kuti musinthe chizindikiro
- Powonjezerapo, kusankha kumakula kukula kwa katatu mpaka 8
- Dinani pa batani Yotseka kuti mutseke bokosilo ndikubweranso kuntchito.
07 cha 09
Kusintha Chapafupi Chigawo Chakumbuyo
Kuti musinthe mtundu wa chithunzi cha tchati chonse, tidzakhalanso kugwiritsa ntchito makondomu. Mtundu wa maonekedwe m'ndandanda wamakono umatchulidwa ngati mtundu wonyezimira ngakhale kuti ukuwonekera kuti ndi wofiira kuposa woyera.
Maphunziro:
- Dinani pazithunzi zoyera kuti mutsegule mndandanda wazithunzi
- Dinani pamtsinje waung'ono mpaka kumanja kwajambula Zithunzi Zodzaza - utoto ukhoza - muzithunzithunzi zofotokozera kuti mutsegule gawo lazithunzi
- Dinani pa White, Background 1, Mdima 25% kuti musinthe mtundu wa tchati ku imvi
08 ya 09
Kusintha Chigawo Choyambira
Masitepe oti musinthe mtundu wa chigawo cha chiwembu ndi ofanana ndi omwe akusintha mtundu wa chithunzi cha tchati chonsecho.
Mtundu wosankhidwa pa gawoli la tchati ukuwonekera ngati buluu ngakhale kuti uli wofiira wa buluu m'kati mwake.
Zindikirani: Samalani kuti musasankhe mizere yoyendetsera galasi yomwe ikuyenda kudera la chiwembu osati malo enieni.
Maphunziro:
- Dinani kumene kumalo oyera a chigawo choyambirira kuti mutsegule masewera omwe mumakhala nawo
- Dinani pamtsinje waung'ono mpaka kumanja kwajambula Zithunzi Zodzaza - utoto ukhoza - muzithunzithunzi zofotokozera kuti mutsegule gawo lazithunzi
- Dinani pa Mdima Wakuda Bwino, Mutu 2, Wowonjezera 80% kuti musinthe mtundu wa chigawo cha chilengedwe kuti muwone buluu.
09 ya 09
Kuonjezerapo zotsatira za 3-D Zowonongeka ndi Kukonzanso Tchati
Kuonjezera zotsatira za 3-D zovuta
Kuonjezera zotsatira za 3-D zimakhala zokopa zokometsera zomwe zimawonjezera pang'ono pa tchati. Icho chimachoka pa tchatichi ndi mawonekedwe apansi kunja.
- Dinani pazithunzi zoyera kuti mutsegule mndandanda wazithunzi
- Dinani pazithunzi Chachigawo Chachigawo muzithunzithunzi zamakono kuti mutsegule dialog box
- Dinani pa mawonekedwe a 3-D muwindo lamanzere la bokosi la Chigawo Chamawonekedwe
- Dinani pamsana wotsika kumanja kwa chithunzi Chakumwamba kuwindo lamanja kuti mutsegule gulu la zosankha zabwino
- Dinani pa Chonchi chotsatira pazowonjezera kuti muike pamphepete mwazithunzi
- Dinani pa batani Yotseka kuti mutseke bokosilo ndikubweranso kuntchito
Onaninso Tchati
Kukhazikitsanso tchati ndichinthu china chodziwiratu. Phindu lopanga tchati chachikulu ndikuti limachepetsa kuyang'ana kwakukulu komwe kumapangidwa ndi mzere wachiwiri wodutsa kumanja kwa tchati.
Zidzakhalanso kukula kwa chigawo cha chiwembu chomwe chiwerengero cha tchatichi chidzawerengeka mosavuta.
Njira yosavuta yosinthira tchati ndiyo kugwiritsa ntchito zovuta zomwe zimagwira ntchito mozungulira pambali pa tchati kamodzi mukangobwereza.
- Dinani kamodzi pa chiyambi cha tchati kuti musankhe tchati chonsecho
- Kusankha chithunzicho kumaphatikizapo mzere wofiira wabuluu kumbali yina ya tchati
- M'makona a ndondomeko iyi ya buluu ndizomwe zimagwira ntchito
- Sungani chojambula chanu cha mouse pamodzi pamakona mpaka pointer isinthe muvi wakuda wakuda
- Pamene pointer ndi mzere wotsitsika, kanikizani pakanzere lakumapeto kwa mouse ndipo ponyani panja pang'ono kuti mukulitse chithunzicho. Tchaticho chidzawonjezerekanso m'litali ndi m'lifupi. Malo a chiwembu ayenera kuwonjezera kukula kwake.
Ngati mwatsatira zonsezi mu phunziro ili panthawiyi Chithunzi Chapafupi cha Masitolo Chakumsika Chofanana Chiyenera kufanana ndi chitsanzo chomwe chili mu chithunzi patsamba 1 la phunziro ili.