Yuav ua li cas yuav ua tau High School-Qis-Tshaj Tshuag Market Cov Ncauj Lus hauv Excel

01 ntawm 07

Excel Tshuag lag luam daim ntawv qhia

Lus Cim: Peb cov neeg coob hu rau daim duab raug xa mus rau hauv Excel ua ib qho qauv .

Daim duab High Low-Low-qis qhia txhua hnub txhua hnub, qis, thiab nqi kaw rau ib qho khoom lag luam li ib lub sijhawm.

Ua kom tiav cov kauj ruam hauv cov ncauj lus hauv qab no yuav tsim tau ib qho kev ua lag luam lag luam zoo ib yam li cov duab saum toj no.

Cov kauj ruam pib tsim ib daim ntawv sau qhia thiab qhov kawg ntawm peb siv ntau tus qauv uas muaj nyob hauv Design , Layout , thiab Hom tabs ntawm txoj kab .

Cov Ntsiab Lus Kawm

1. Nkag mus rau Cov Ntaub Ntawv Tshaj Lij
2. Xaiv cov ntaub ntawv qhia
3. Tsim Daim Qauv Tshuag Tshawb Lag Luam Tshawb Xyuas
4. Formatting Tshuag Daim Ntawv Qhia - Xaiv ib Qib Siab
5. Formatting Tshuag Daim Ntawv Qhia - Xaiv ib Hom Phiaj
6. Ua Ntawv Tshaj Lij Daim Ntawv Tshaj Xo - Ntxiv Npe ntawm Daim Ntawv Tshawb Fawb

02 ntawm 07

Nkag Mus Siv Cov Ntawv Qhia Cov Ntawv Qhia

Thawj kauj ruam hauv kev tsim Daim Ntawv Tshaj Loj Tshaj High School-Low-Close yog sau cov ntaub ntawv rau hauv daim ntawv ua haujlwm .

Thaum nkag mus rau cov ntaub ntawv , khaws cov cai tswj no:

• Thaum twg ua tau, sau koj cov ntaub ntawv hauv txhua raws li muaj nyob hauv daim duab saum toj no
• Tso tawm koj daim ntawv ua haujlwm nrog lub npe rau txhua daim ntawv xov xwm rau sab saum toj ntawm kem thiab cov ntaub ntawv hauv lub hlwb hauv qab no
• Tsis txhob tso daim ntawv dawb los yog txhua kab ntawv thaum nkag hauv koj cov ntaub ntawv raws li qhov no yuav tsim ib qho chaw seem hauv daim duab

Lus Cim: Qhov kev nyeem tsis suav nrog cov kauj ruam ntawm kev ua cov ntawv sau qhia raws li muaj nyob hauv daim duab saum toj no. Cov ntaub ntawv nyob rau hauv daim ntawv xaiv cov txheej txheem formatting options yog muaj nyob rau hauv no yooj yim Excel formatting nyeem .

Cov Kauj Ruam Tutorial

Sau cov ntaub ntawv raws li pom hauv daim duab saum toj no rau hauv hlwb A1 rau D6.

03 ntawm 07

Xaiv cov ntawv qhia cov ntawv

Ob Qhov Kev Xaiv rau Kev Xaiv Cov Ntawv Qhia Cov Ntaub Ntawv

Yog xav tau kev pabcuam rau cov lus qhia no, saib daim duab saum toj no.

Siv tus nas

1. Luag xaiv nrog nas khawm kom highlight lub hlwb uas muaj cov ntaub ntawv yuav tsum tau muaj nyob rau hauv daim ntawv qhia.

Siv cov Keyboard

1. Nias rau sab sab laug ntawm daim phiaj xwm qhia.
2. Hold down tus yuam sij SHIFT rau cov keyboard.
3. Siv cov xub tuav ntawm cov keyboard los xaiv cov ntaub ntawv kom muab tso rau hauv daim ntawv qhia kev npaj txhij.

Ceebtoom: Nco ntsoov xaiv ib lub npe kab thiab lub npe uas koj xav kom muab tso rau hauv daim phiaj qhia.

Cov Kauj Ruam Tutorial

1. Highlight lub block ntawm hlwb ntawm A2 rau D6, uas muaj xws li lub npe lub npe thiab kab npe tab sis tsis yog lub npe, siv ib qho ntawm cov saum toj no.

04 ntawm 07

Tsim Daim Qauv Tshuag Tshawb Lag Luam Tshawb Xyuas

Yog xav tau kev pabcuam rau cov lus qhia no, saib daim duab saum toj no.

1. Nyem rau ntawm Ntxig Ribbon tab.
   
2. Nias ntawm ib daim ntawv qhia kev lag luam los qhib cov ntawv sau tseg
   
   (Hovering koj tus nas pointer ntau dua ib daim ntawv qhia dav yuav ua kom tiav cov lus piav qhia ntawm daim phiaj).
   
3. Nias ntawm ib hom ntawv qhia kom xaiv nws.

Cov Kauj Ruam Tutorial

1. Yog tias koj siv Excel 2007 lossis Excel 2010, nias ntawm Txuas> Lwm Kab Ntawv> Tshuag> Ntim-Qes-Qes-Zej Zog nyob rau hauv txoj kab
2. Yog tias koj siv Excel 2013, nias ntawm Insert> Insert Stock, Surface los Radar Charts> Tshuag> Volume-High-Low-Close in the ribbon
3. Daim ntawv sau ua lag luam High School-Low-Close yog tsim thiab muab tso rau hauv koj daim ntawv ua haujlwm. Cov nplooj ntawv hauv qab no ua rau daim ntawv teev lus qhia no ua kom haum cov duab uas tau pom hauv thawj kauj ruam ntawm phau ntawv qhia no.

05 ntawm 07

Xaiv ib lub Style

Yog xav tau kev pabcuam rau cov lus qhia no, saib daim duab saum toj no.

Thaum koj nyem rau ntawm ib daim duab, peb tabs - Tus Tsim, Layout, thiab Hom ntawv tabs ntxiv rau daim ntawv sau nyob rau hauv lub npe ntawm Daim Phiaj Nqa (Chart Tools) .

Xaiv ib tug qauv rau Tshuag Tshuag Khoom Chart

1. Nias ntawm daim ntawv qhia nyiaj.
2. Ndliv qhov Tsim Tsa .
3. Nias rau ntawm tus xub nqes hauv qab ntawm sab laug hauv qab ntawm Chart Styles vaj huam sib luag los tso saib tag nrho cov qauv muaj.
4. Xaiv Style 39.

06 ntawm 07

Xaiv Ib Hom Style

Yog xav tau kev pabcuam rau cov lus qhia no, saib daim duab saum toj no.

Thaum koj nyem rau ntawm ib daim duab, peb tabs - Tus Tsim, Layout, thiab Hom ntawv tabs ntxiv rau daim ntawv sau nyob rau hauv lub npe ntawm Daim Phiaj Nqa (Chart Tools) .

Cov Kauj Ruam Tutorial

1. Nyem ntawm daim ntawv qhia tom qab.
2. Nias rau ntawm Hom ntawv .
3. Nias rau ntawm tus xub nqes hauv qab ntawm sab laug hauv qab ntawm Chart Styles vaj huam sib luag los tso saib tag nrho cov qauv muaj.
4. Xaiv Cov Nyom Nyuaj Tshuam - Hloov 3.

07 ntawm 07

Muab Lub Npe Rau Daim Ntawv Tshawb Fawb Rau Daim Ntawv Tshawb Xyuas

Yog xav tau kev pabcuam rau cov lus qhia no, saib daim duab saum toj no.

Thaum koj nyem rau ntawm ib daim duab, peb tabs - Tus Tsim, Layout, thiab Hom ntawv tabs ntxiv rau daim ntawv sau nyob rau hauv lub npe ntawm Daim Phiaj Nqa (Chart Tools) .

Cov Kauj Ruam Tutorial

1. Nias ntawm Layout tab.
   
2. Nias ntawm Daim Ntawv Qhia Chart nyob rau hauv tshooj lus ceeb toom.
   
3. Xaiv qhov kev xaiv thib peb - Tshaj Piav Qhia .
   
4. Ntaus nyob rau hauv lub npe "Cov Khw Muag Khoom Tshaj Tawm Txhua Hnub" rau ob kab.

Nyob rau ntawm lub sij hawm no, koj daim ntawv yuav tsum thooj li daim ntawv qhia npaj tseg hauv thawj kauj ruam ntawm phau ntawv qhia no.