Excel kab kos, lawv yog dab tsi, yuav ua li cas los tsim ib daim ntawv qhia thiab yuav ua li cas xaiv daim ntawv pom zoo

Daim ntawv Excel yog ib qho kev pom uas sawv cev rau cov ntaub ntawv hauv Excel.

Koj yuav muaj peev xwm txheeb xyuas cov ntaub ntawv zoo dua los ntawm kev saib daim duab hauv Excel ntau dua li cov lej hauv cov ntaub ntawv.

Excel npog ntau cov kab kos uas koj tuaj yeem siv los sawv cev koj cov ntaub ntawv.

Lub sijhawm nyeem ntawv kwv yees: 14 minuti

Tsim ib daim ntawv qhia hauv Excel yog ib qho yooj yim. Saib ntawm daim duab pab peb txheeb xyuas ntau yam kev ntsuas tsuas yog saib ntawm nws.

Yuav ua li cas los tsim ib daim ntawv Excel

Cov kauj ruam tseem ceeb hauv kev tsim daim ntawv Excel yog:

• Xaiv cov ntaub ntawv kom suav nrog hauv daim duab
• Xaiv hom kab ntawv koj xav siv
• Hloov qhov tsim ntawm koj daim ntawv qhia
• Hloov daim duab formatting
• Exporting daim duab

Xaiv cov ntaub ntawv los siv hauv daim duab

Thawj kauj ruam thaum tsim daim ntawv Excel yog xaiv cov ntaub ntawv koj xav siv hauv daim duab lossis daim duab.

Cov kab kos tuaj yeem sib piv ob lossis ntau cov ntaub ntawv los ntawm koj daim ntawv Excel, nyob ntawm cov ntaub ntawv koj xav sib txuas lus hauv daim ntawv.

Thaum koj tau txheeb xyuas koj cov ntsiab lus cov ntaub ntawv, koj tuaj yeem xaiv cov ntaub ntawv los suav nrog hauv koj daim ntawv qhia.

Siv koj tus cursor los qhia cov hlwb uas muaj cov ntaub ntawv koj xav kom suav nrog hauv daim ntawv. Cov hlwb uas tau xaiv yuav raug tsom nrog tus ciam teb ntsuab.

Thaum koj tau xaiv koj cov ntaub ntawv, koj tuaj yeem txav mus rau kauj ruam tom ntej thiab xaiv koj hom kab ntawv.

Xaiv hom kab ntawv koj xav siv

Excel muaj ntau hom kab kos los siv los tso saib cov ntaub ntawv.

Koj tuaj yeem sib txuas lus li cas koj nthuav qhia koj cov ntaub ntawv sib txawv, nyob ntawm seb hom kab ntawv koj siv.

Thaum koj tau xaiv koj cov ntaub ntawv, nyem qhov Insert tab, tom qab ntawd nyem lub pob pom pom hauv kab ntawv hauv pawg ntawm Ribbon. Koj yuav pom ntau hom kab ntawv xaiv los ntawm. Nyem OK thiab daim ntawv yuav tshwm hauv koj phau ntawv ua haujlwm.

Kuj tseem muaj qhov txuas mus rau hom kab ntawv nrov tshaj plaws hauv pawg Charts ntawm Ribbon. Koj tuaj yeem siv cov nyees khawm no los hloov hom kab ntawv txhua lub sijhawm.

Hloov hom kab kos

Koj tuaj yeem yooj yim hloov mus rau lwm hom kab ntawv txhua lub sijhawm:

1. Xaiv daim duab.
2. Ntawm kab ntawv tsim tab, nyob rau hauv hom pab pawg, nyem Hloov Daim Ntawv Qhia Hom.

3. Ntawm sab laug, nyem Kem.

4. Nyem OK.

Hloov kab / kab

Yog tias koj xav pom cov tsiaj (hloov lub hlis) ntawm kab rov tav, ua cov kauj ruam hauv qab no.

1. Xaiv daim duab.
2. Ntawm kab ntawv Tsim tab, hauv cov ntaub ntawv pawg, nyem Hloov Kab / Kab.

Tau txais cov txiaj ntsig hauv qab no

Qhov chaw ntawm cov lus dab neeg

Txhawm rau txav cov lus dab neeg mus rau sab xis ntawm daim duab, ua cov kauj ruam hauv qab no.

1. Xaiv daim duab.
2. Nyem lub + khawm nyob rau sab xis ntawm daim ntawv, nyem lub xub nyob ib sab ntawm Legend, thiab nyem Txoj Cai.

Kev Pheej Hmoo:

Cov ntawv sau

Koj tuaj yeem siv cov ntaub ntawv sau los tsom koj cov neeg nyeem cov kev xav ntawm cov ntaub ntawv ib zaug lossis cov ntaub ntawv taw qhia.

1. Xaiv daim duab.
2. Nyem ib lub bar ntsuab xaiv lub Rau Hli cov ntaub ntawv series.
3. Tuav CTRL thiab siv tus yuam sij xub los xaiv lub Rau Hli dolphin pejxeem (me me ntsuab bar).
4. Nyem lub + khawm nyob rau sab xis ntawm daim ntawv thiab nyem lub thawv kos ib sab ntawm Cov Ntawv Sau.

Kev Pheej Hmoo:

Hom kab kos

Microsoft Excel tam sim no muaj 17 hom kab ntawv sib txawv muaj rau siv.

Txhua hom kab ntawv muaj qhov tshwj xeeb saib thiab lub hom phiaj.

Histogram

Daim ntawv qhia kab ke ua ke yog siv los tso saib cov kab ntawm ob lossis ntau dua cov ntaub ntawv teev nyob rau hauv kab kab ntsug. Cov kab ntsug tau muab ua ke ua ke vim tias txhua qhov dataset sib koom tib cov ntawv cim axis. Clustered kab muaj txiaj ntsig zoo rau kev sib piv cov ntaub ntawv ncaj qha.

Kab duab

Daim ntawv qhia kab yog siv los tso saib cov ntaub ntawv sib txawv ntawm lub sijhawm, txuas cov ntaub ntawv cov ntsiab lus ntawm cov kab ncaj. Cov kab kos tuaj yeem sib piv cov ntaub ntawv dhau sijhawm rau ib lossis ntau pawg thiab tuaj yeem siv los ntsuas kev hloov pauv ntev lossis luv luv ntawm lub sijhawm.

Daim duab paj nruag

Daim ntawv qhia ncuav qab zib, lossis daim duab ncuav qab zib, yog siv los qhia cov ntaub ntawv raws li feem pua ​​​​ntawm tag nrho. Tag nrho cov ncuav qab zib sawv cev rau 100% ntawm tus nqi koj ntsuas, thiab cov ntsiab lus ntawm cov ntaub ntawv yog ib feem lossis feem pua ​​​​ntawm cov ncuav qab zib. Daim duab ncuav qab zib muaj txiaj ntsig zoo rau kev pom qhov kev koom tes ntawm txhua cov ntaub ntawv taw qhia rau tag nrho cov ntaub ntawv.

Clustered daim ntawv qhia

Ib daim ntawv qhia bar, lossis daim duab bar, yog siv los tso saib cov ntaub ntawv ntawm ob lossis ntau dua cov ntaub ntawv teev nyob rau hauv kab rov tav pawg. Cov kab kab rov tav tau muab ua ke ua ke vim tias txhua cov ntaub ntawv sib koom ua ke tib daim ntawv lo. Clustered bars muaj txiaj ntsig zoo rau kev sib piv cov ntaub ntawv ncaj qha.

Thaj tsam daim duab

Ib daim ntawv qhia cheeb tsam, lossis daim ntawv qhia cheeb tsam, yog ib kab kab kos nrog thaj chaw sau hauv qab txhua kab nrog cov xim xim rau txhua cov ntaub ntawv teev.

Scatter zaj dab neeg

Ib daim phiaj tawg, lossis cov phiaj xwm tawg, yog siv los tso saib ob lossis ntau pawg ntawm cov ntaub ntawv los nrhiav kev sib raug zoo thiab kev sib txawv ntawm cov ntaub ntawv muaj nuj nqis. Scatter plots muaj txiaj ntsig zoo rau kev txheeb xyuas cov xwm txheej hauv cov ntaub ntawv teev tseg thiab tsim kom muaj lub zog ntawm kev sib raug zoo ntawm cov txiaj ntsig hauv cov ntaub ntawv teev.

Daim duab qhia chaw puv

Daim duab qhia chaw uas muaj daim ntawv qhia yog siv los tso saib cov ntaub ntawv qhia qib siab hauv ib daim ntawv qhia. Daim duab qhia chaw muaj txiaj ntsig zoo rau kev pom cov duab qhia cov ntaub ntawv raws li qhov chaw nyob. Hom daim ntawv qhia no tam sim no muaj kev txwv tseem ceeb ntawm hom ntaub ntawv nws tuaj yeem tso tawm.

Daim ntawv qhia

Ib daim ntawv qhia, lossis daim ntawv qhia, yog siv los tso saib tus nqi txav ntawm ib lub sijhawm. Qee qhov txiaj ntsig uas tuaj yeem siv rau hauv cov kab kos no yog Qhib Nqe, Kaw Nqe, Siab, qis thiab ntim. Cov kab kos duab muaj txiaj ntsig zoo rau kev saib cov khoom lag luam tus nqi sib txawv thiab kev hloov pauv lub sijhawm.

Nto graph

Daim duab saum npoo, lossis daim duab saum npoo, yog siv los tso saib cov ntaub ntawv ntawm ob lossis ntau dua cov ntaub ntawv teev nyob rau hauv qhov chaw ntsug. Vertical nto yog pawg ua ke, raws li txhua cov ntaub ntawv sib qhia tib cov ntawv cim axis. Surfaces muaj txiaj ntsig zoo rau kev sib piv cov ntaub ntawv ncaj qha.

Radar daim ntawv qhia

Daim duab radar (tseem hu ua kab laug sab chart) yog siv los npaj ib lossis ntau pawg ntawm cov txiaj ntsig hla ntau qhov sib txawv. Lawv muaj txiaj ntsig zoo thaum nws tsis tuaj yeem sib piv ncaj qha thiab muaj txiaj ntsig tshwj xeeb rau kev saib xyuas kev ua haujlwm lossis cov ntaub ntawv tshawb fawb.

Treemap daim ntawv qhia

Daim ntawv Treemap yog ib hom kev pom cov ntaub ntawv uas muab kev pom hierarchical ntawm koj cov ntaub ntawv, ua kom pom cov qauv yooj yim. Ntawm daim duab ntoo, txhua lub ntsiab lus lossis ceg yog sawv cev los ntawm cov duab plaub, cov duab plaub me me uas sawv cev rau pawg pawg lossis cov ceg ntoo.

daim ntawv Sunburst

Ib daim duab Sunburst yog ib hom ntaub ntawv visualization uas muab ib tug hierarchical saib ntawm cov ntaub ntawv, ua kom nws yooj yim rau pom cov qauv. Ntawm Sunburst, txhua qeb yog nthuav tawm nyob rau hauv ib ncig. Txhua lub nplhaib sawv cev rau ib theem nyob rau hauv hierarchy, qhov twg theem siab tshaj sib haum mus rau lub nplhaib innermost. Cov rings sab nrauv taug qab cov subcategories.

Histogram graph

Ib tug histogram yog ib qho cuab yeej tshuaj ntsuam nrov siv hauv ntiaj teb kev lag luam. Zoo ib yam li daim ntawv qhia bar, cov histogram compresses cov ntaub ntawv kom yooj yim dua kev txhais lus los ntawm pab pawg neeg cov ntsiab lus rau hauv ntau yam los yog bins.

Box thiab whisker graph

A Box thiab Whisker chart yog ib daim ntawv teev cov lej uas sau cov ntaub ntawv nyob rau hauv lawv cov statistical quartiles (yam tsawg kawg, thawj quartile, nruab nrab, peb quartile, thiab siab tshaj).

Daim duab dej tsaws tsag

Daim ntawv qhia dej tsaws tsag, qee zaum hu ua choj daim ntawv qhia, qhia cov lej ntawm cov txiaj ntsig ntxiv rau lossis rho tawm ntawm tus nqi pib. Piv txwv suav nrog cov nyiaj tau los ntawm cov nyiaj tau los lossis tus nqi ntawm cov khoom lag luam hauv lub sijhawm.

Funnel daim ntawv qhia

Daim duab funnel yog ib feem ntawm Excel tsev neeg ntawm cov kab kos hierarchical. Funnel charts feem ntau yog siv rau hauv kev lag luam lossis kev muag khoom los qhia qhov tseem ceeb ntawm ib theem mus rau lwm qhov. Funnel charts xav tau ib qeb thiab tus nqi. Cov kev coj ua zoo tshaj plaws qhia qhov tsawg kawg ntawm peb kauj ruam.

Daim ntawv qhia ua ke

Daim ntawv qhia combo siv ob hom kab ntawv Excel hauv ib daim ntawv. Lawv siv los tso saib ob qhov sib txawv datasets ntawm tib lub ncauj lus.

Kev Nyeem Ntawv

• Yuav tsim daim ntawv tshaj tawm xov xwm nrog Microsoft Project li cas
• Excel statistical functions: Tutorial nrog piv txwv rau kev tshawb fawb, ntu plaub
• Excel statistical functions: Tutorial nrog piv txwv, ib feem
• Yuav ua li cas sau ntawv hais qhia thiab yuav ua li cas rub tawm cov ntaub ntawv los ntawm koj cov dej num tswj nrog MS Project
• Pivot Tables: lawv yog dab tsi, yuav ua li cas tsim hauv Excel thiab Google. Tutorial nrog piv txwv

Ercole Palmeri