Txhua yam hais txog kev tsim ib daim duab hauv Excel. Kauj ruam los ntawm kauj ruam qhia nrog screenshots

Excel yog qhov kev pabcuam zoo kawg nkaus uas tso cai rau koj los ua cov ntaub ntawv tsis yog lej xwb. Nrog nws cov kev pab, koj tuaj yeem pom cov ntaub ntawv los ntawm kev tsim cov duab sib txawv ntawm qhov nyuaj. Nws yog txaus tsuas yog los qhia cov ntaub ntawv nyob rau hauv lub hlwb, thiab qhov kev pab cuam yuav cia li tsim ib daim ntawv raws li lawv. Hais tias nws yog amazing!

Hauv qhov no, tus neeg siv tuaj yeem hloov kho cov duab ntawm daim ntawv uas nws nyiam. Niaj hnub no peb yuav txheeb xyuas kom meej cov cuab yeej muaj nyob hauv Excel thiab lwm yam kev pab cuam zoo sib xws. Tom qab tag nrho, lub hauv paus ntsiab lus tseem ceeb tsis txwv rau qhov chaw ua haujlwm ntawm Microsoft nkaus xwb, puas yog? Yog li ntawd, cov hauv paus ntsiab lus uas tau piav qhia ntawm no tuaj yeem siv tau zoo thaum ua haujlwm nrog lwm cov ntawv nthuav dav xws li LibreOffice, WPS Office, lossis Google Sheets.

Tsim ib daim ntawv raws li cov ntaub ntawv Excel spreadsheet

Ua ntej txuas ncaj qha mus rau hauv cov kab kos Excel, koj yuav tsum nkag siab tias nws yog dab tsi thiab lawv yog dab tsi. Muaj ntau txoj hauv kev los nthuav qhia cov ntaub ntawv:

1. Kev soj ntsuam.
2. Ntawv.
3. Pom kev.
4. Sib tham sib.

Qhov feem ntau paub rau tus neeg nruab nrab yog qhov kev mloog thiab kev nyeem ntawv ntawm kev xa cov ntaub ntawv. Thawj qhov suav nrog kev siv lub suab txhawm rau nthuav qhia qee cov ntaub ntawv, qhov tseeb thiab cov duab. Ib txoj kev uas tsis ntseeg siab heev uas tsis tuaj yeem xa cov ntaub ntawv zoo kawg nkaus. Qhov tsuas yog qhov nws tuaj yeem siv tau rau lub sijhawm nthuav tawm yog los txhawb qee qhov kev xav hauv cov neeg tuaj saib. Cov ntawv tuaj yeem xa cov ntawv, tab sis muaj peev xwm qis dua los ua kom muaj qee yam kev xav. Txoj kev sib tham sib cuam tshuam nrog kev koom tes ntawm cov neeg tuaj saib (piv txwv li, cov tub ua lag luam). Tab sis yog tias peb tham txog cov ntaub ntawv lag luam, ces koj tsis tuaj yeem ua si ntau ntawm no.

Txoj kev pom kev nthuav qhia cov ntaub ntawv qhib ntau qhov zoo. Nws pab ua ke tag nrho cov txiaj ntsig ntawm cov txheej txheem ntxiv. Nws xa cov ntaub ntawv raug heev, vim nws muaj tag nrho cov lej, thiab tus neeg tuaj yeem txheeb xyuas cov ntaub ntawv raws li daim duab. Nws muaj peev xwm evoke kev xav. Piv txwv li, tsuas yog saib daim duab ntawm kev kis tus kabmob coronavirus nyob rau lub sijhawm tsis ntev los no, thiab nws tam sim ntawd paub meej tias daim duab tuaj yeem cuam tshuam rau lub siab ntawm lub hlwb.

Thiab qhov tseem ceeb, nws muaj peev xwm koom nrog ib tus neeg tuaj yeem xaiv saib ib lossis lwm qhov ntawm daim ntawv qhia thiab txheeb xyuas cov ntaub ntawv uas nws xav tau tiag tiag. Qhov no yog vim li cas cov kab kos tau dhau los ua thoob plaws ntiaj teb. Lawv siv nyob rau hauv ntau yam ntawm tib neeg kev ua ub no:

1. Thaum lub sij hawm nthuav qhia cov txiaj ntsig ntawm kev tshawb fawb ntawm ntau theem. Qhov no yog lub ntsiab lus thoob ntiaj teb rau cov tub ntxhais kawm thiab cov kws tshawb fawb tiv thaiv kev tawm tsam. Hom kev nthuav qhia cov ntaub ntawv no, zoo li daim duab, ua rau nws tuaj yeem ntim cov ntaub ntawv ntau rau hauv daim ntawv yooj yim heev thiab nthuav tawm tag nrho cov ntaub ntawv no rau cov neeg tuaj saib dav kom nws pom meej tam sim ntawd. Daim duab no tso cai rau koj los txhawb kev ntseeg siab ntawm tus neeg thov kev pab rau qib master lossis doctoral degree hais.
2. Thaum kev nthuav qhia kev lag luam. Tshwj xeeb tshaj yog tsim cov duab kos yog tsim nyog yog tias tsim nyog los nthuav qhia qhov project rau cov neeg ua lag luam lossis tshaj tawm txog kev nce qib ntawm nws txoj haujlwm.

   Qhov no yuav ua kom pom tseeb tias cov neeg sau ntawv ntawm qhov project lawv tus kheej coj nws tiag. Ntawm lwm yam, cov tub ua lag luam yuav tuaj yeem txheeb xyuas tag nrho cov ntaub ntawv tsim nyog ntawm lawv tus kheej. Zoo, lub ntsiab lus hais txog qhov tseeb tias muaj cov duab kos nyob rau hauv nws tus kheej txhawb kev ntseeg siab, vim hais tias nws yog txuam nrog qhov tseeb ntawm qhov kev nthuav qhia ntawm cov ntaub ntawv, tseem yog ob qho tib si rau thaj chaw no thiab tag nrho cov hauv qab no.

3. Rau kev qhia rau cov thawj coj. Kev tswj hwm nyiam cov lus ntawm cov lej. Ntxiv mus, qhov siab dua nws nyob rau hauv qeb, qhov tseem ceeb dua rau nws. Tus tswv ntawm txhua lub lag luam yuav tsum nkag siab tias qhov no lossis qhov peev nyiaj them ntau npaum li cas, cov haujlwm ntawm cov khoom lag luam twg tsis muaj txiaj ntsig thiab cov txiaj ntsig zoo, thiab nkag siab ntau yam tseem ceeb.

Muaj ntau lwm qhov chaw uas cov kab kos tuaj yeem siv tau. Piv txwv li, hauv kev qhia. Tab sis tsis muaj teeb meem dab tsi rau lub hom phiaj tshwj xeeb lawv tau muab tso ua ke, yog tias lawv ua tiav hauv Excel, qhov tseeb yuav luag tsis muaj dab tsi yuav tsum tau ua. Qhov kev zov me nyuam yuav ua txhua yam rau tus neeg nws tus kheej. Qhov tseeb, tsim cov kab kos hauv Excel tsis yog qhov txawv los ntawm kev tsim cov rooj tsis tu ncua. Yog li ntawd, leej twg tuaj yeem tsim lawv yooj yim heev. Tab sis kom paub meej, cia peb piav qhia lub hauv paus ntsiab lus hauv daim ntawv qhia. Ua raws li cov kauj ruam no:

1. Ua ntej tsim ib daim duab lossis daim duab, koj yuav tsum xub tsim ib lub rooj nrog cov ntaub ntawv uas yuav siv rau qhov no. Cia peb tsim ib lub rooj zoo li no.
2. Tom qab tsim lub rooj, koj yuav tsum nrhiav thaj chaw uas yuav siv rau lub hauv paus ntawm daim ntawv qhia, thiab tom qab ntawd nyem rau ntawm "Insert" tab nrog tus nas laug khawm ib zaug. Tom qab ntawd, tus neeg siv yuav tuaj yeem xaiv hom kab ntawv uas nws nyiam. Qhov no yog ib daim duab, thiab daim ntawv qhia ncuav qab zib, thiab histogram. Muaj chaw nthuav.
   

   Mloog! Cov kev pab cuam sib txawv ntawm lawv tus kheej nyob rau hauv tus naj npawb ntawm hom kab kos uas tsim tau.

3. Koj tuaj yeem siv ntau hom kab kos. Lawv tsuas yog tsis nrov. Txhawm rau saib tag nrho cov npe ntawm hom muaj, mus rau "Daim duab" ntawv qhia zaub mov thiab xaiv ib hom tshwj xeeb muaj. Peb pom tias muaj cov zaub mov txawv me ntsis ntawm no. Tsis muaj ib yam dab tsi txawv ntawm qhov no, txij li cov nyees khawm lawv tus kheej yuav txawv tsis tsuas yog nyob ntawm lub version ntawm chav ua haujlwm suite, tab sis kuj muaj ntau yam ntawm cov kev pab cuam thiab kev ua haujlwm. Ntawm no nws yog ib qho tseem ceeb kom nkag siab txog cov laj thawj ua ntej, thiab txhua yam yuav tsum ua kom nkag siab.
4. Tom qab xaiv hom kab ntawv tsim nyog, nyem rau ntawm nws. Tom qab ntawd koj yuav raug nthuav tawm nrog cov npe ntawm cov subtypes, thiab koj yuav tsum xaiv qhov uas zoo tshaj plaws haum rau koj qhov xwm txheej. Piv txwv li, yog xaiv histogram, ces koj tuaj yeem xaiv ib txwm, bar, ntim, thiab lwm yam. Cov npe ntawm hom nrog cov duab, uas koj tuaj yeem nkag siab tias daim duab kawg yuav zoo li cas, nyob ncaj qha rau hauv cov ntawv qhia zaub mov no.
5. Peb nyem rau ntawm qhov subtype uas peb xav tau, tom qab ntawd qhov program yuav ua txhua yam txiav. Daim duab tshwm sim yuav tshwm sim ntawm qhov screen.
6. Nyob rau hauv peb rooj plaub, daim duab muab tawm raws li nram no.
7. Yog tias peb xaiv hom "Chart", ces peb daim ntawv yuav zoo li no.
8. Daim ntawv ncuav qab zib muaj daim ntawv hauv qab no.

Raws li koj tuaj yeem pom, cov lus qhia tsis nyuaj txhua. Nws yog txaus kom nkag mus rau me ntsis cov ntaub ntawv, thiab lub computer yuav ua tus so rau koj.

Yuav ua li cas ua haujlwm nrog kab kos hauv Excel

Tom qab peb tau ua daim ntawv qhia, peb tuaj yeem hloov kho nws. Txhawm rau ua qhov no, koj yuav tsum nrhiav qhov "Designer" tab nyob rau sab saum toj ntawm qhov program. Lub vaj huam sib luag no muaj peev xwm los teeb tsa ntau yam khoom ntawm daim duab peb tsim ua ntej. Piv txwv li, tus neeg siv tuaj yeem hloov xim ntawm txhua kab, nrog rau kev hloov pauv tseem ceeb. Piv txwv li, hloov hom lossis subtype. Yog li, txhawm rau ua qhov no, koj yuav tsum mus rau "Hloov kab ntawv hom", thiab hauv cov npe uas tshwm sim, koj tuaj yeem xaiv hom xav tau. Ntawm no koj tuaj yeem pom txhua hom muaj thiab subtypes.

Peb kuj tuaj yeem ntxiv qee yam rau hauv daim ntawv tsim. Txhawm rau ua qhov no, nyem rau ntawm lub pob tsim nyog, uas nyob tam sim ntawd ntawm sab laug ntawm lub vaj huam sib luag.

Koj tuaj yeem ua qhov kev teeb tsa sai. Muaj ib qho cuab yeej tshwj xeeb rau qhov no. Lub pob sib thooj rau nws tuaj yeem pom nyob rau sab xis ntawm "Add Chart Element" ntawv qhia zaub mov. Ntawm no koj tuaj yeem xaiv yuav luag txhua qhov kev xaiv tsim uas haum rau txoj haujlwm tam sim no.

Nws kuj tseem muaj txiaj ntsig zoo yog tias muaj kev xaiv ntawm txhua tus ntawm lawv nyob ze ntawm kab. Txhawm rau ua qhov no, koj yuav tsum ntxiv cov ntawv sau los ntawm "Add Chart Element" ntawv qhia zaub mov. Tom qab nyem rau ntawm lub pob no, ib daim ntawv teev npe yuav qhib uas peb txaus siab rau cov khoom sib xws. Tom qab ntawd peb xaiv yuav ua li cas cov kab lus yuav tshwm sim. Hauv peb qhov piv txwv - qhia hauv lub screenshot.

Tam sim no daim ntawv qhia no tsis tsuas yog qhia meej meej cov ntaub ntawv, tab sis nws kuj tuaj yeem siv los nkag siab tias txhua kab txhais li cas.

Yuav ua li cas teeb ib daim ntawv nrog feem pua?

Tam sim no cia peb mus rau cov piv txwv tshwj xeeb. Yog tias peb xav tau los tsim ib daim ntawv qhia uas peb ua haujlwm nrog feem pua, ces peb yuav tsum xaiv ib lub voj voog. Cov lus qhia nws tus kheej yog raws li nram no:

1. Raws li cov txheej txheem tau piav qhia saum toj no, nws yog ib qho tsim nyog los tsim ib lub rooj nrog cov ntaub ntawv thiab xaiv ntau yam nrog cov ntaub ntawv uas yuav raug siv los tsim ib daim duab. Tom qab ntawd, mus rau "Insert" tab thiab xaiv hom tsim nyog.
2. Tom qab cov kauj ruam dhau los ua tiav, qhov kev zov me nyuam yuav qhib lub "Constructor" tab tau txais. Tom ntej no, tus neeg siv yuav tsum txheeb xyuas cov kev xaiv muaj thiab nrhiav qhov twg cov feem pua ​​​​ntawm cov cim tau tshwm sim.
3. Kev ua hauj lwm ntxiv nrog daim ntawv qhia ncuav qab zib yuav ua tau zoo ib yam.

Yuav ua li cas hloov font loj hauv daim ntawv Excel

Customizing daim duab fonts tso cai rau koj ua kom nws yooj yim dua thiab cov ntaub ntawv. Nws kuj tseem muaj txiaj ntsig yog tias nws yuav tsum tau pom ntawm lub vijtsam loj. Feem ntau tus qauv loj tsis txaus pom rau cov neeg los ntawm kab rov qab. Txhawm rau teeb tsa daim duab font loj, koj yuav tsum tau nyem rau ntawm lub cim tsim nyog thiab nyem rau ntawm cov khoom font hauv cov npe uas tshwm.

Tom qab ntawd, koj yuav tsum ua txhua yam tsim nyog hloov kho thiab nyem rau ntawm "OK" khawm kom txuag tau lawv.

Pareto chart - txhais thiab tsim qauv hauv Excel

Ntau tus neeg paub txog txoj cai Pareto, uas hais tias 20% ntawm kev siv zog muab 80% ntawm qhov tshwm sim thiab rov ua dua. Siv lub hauv paus ntsiab lus no, koj tuaj yeem kos ib daim duab uas yuav tso cai rau koj kom pom qhov ua tau zoo tshaj plaws uas qhov tshwm sim yog qhov loj tshaj plaws. Thiab los tsim ib daim ntawv qhia ntawm hom no, cov cuab yeej tsim hauv Microsoft Excel txaus. Txhawm rau tsim ib qho infographic, koj yuav tsum xaiv hom "Histogram". Qhov sib lawv liag ntawm peb qhov kev ua yog raws li nram no:

1. Cia peb tsim ib lub rooj uas piav qhia cov npe ntawm cov khoom. Peb yuav muaj ntau kab. Thawj kab yuav piav qhia tag nrho cov nyiaj ntawm kev yuav khoom hauv cov nyiaj. Kab thib ob sau cov nyiaj tau los ntawm kev muag khoom ntawm cov khoom no.
2. Peb ua qhov zoo tib yam histogram. Txhawm rau ua qhov no, koj yuav tsum nrhiav "Ntxig" tab, thiab tom qab ntawd xaiv hom kab ntawv tsim nyog.
3. Tam sim no peb muaj ib daim ntawv npaj, uas muaj 2 kab ntawm cov xim sib txawv, txhua tus sawv cev rau ib kem tshwj xeeb. Hauv qab no koj tuaj yeem pom cov lus dab neeg ntawm daim ntawv qhia, raws li peb nkag siab qhov twg kab yog.
4. Cov kauj ruam tom ntej uas peb yuav tsum tau ua yog kho cov kab ke uas yog lub luag haujlwm rau cov txiaj ntsig. Peb tab tom ntsib nrog txoj haujlwm ntawm pom nws qhov kev hloov pauv hauv kev hloov pauv. Yog li ntawd, peb xav tau ib hom kab kos "Graph". Yog li ntawd, hauv "Designer" tab, peb yuav tsum nrhiav "Hloov kab ntawv hom" khawm thiab nyem rau ntawm nws. Ces xaiv ib lub sij hawm los ntawm cov npe. Nws yog ib qho tseem ceeb tsis txhob hnov ​​​​qab xaiv cov kab tsim nyog ua ntej ua qhov no.

Tam sim no daim ntawv Pareto npaj txhij. Koj tuaj yeem txheeb xyuas qhov ua tau zoo thiab txiav txim siab yam twg tuaj yeem txi tau yam tsis muaj kev ntshai. Kho daim ntawv qhia no yog ua raws nraim li txoj kev ua ntej. Piv txwv li, koj tuaj yeem ntxiv cov ntawv cim rau cov kab thiab cov ntsiab lus ntawm daim duab, hloov xim ntawm kab, kab, thiab lwm yam.

Yog li, Excel muaj cov cuab yeej loj loj los tsim cov kab kos thiab kho lawv. Yog tias koj sim nrog cov teeb tsa koj tus kheej, ntau dhau los ua kom pom tseeb thiab koj tuaj yeem tsim cov duab ntawm txhua qhov nyuaj thiab ua rau lawv nyeem tau. Thiab qhov no yog raws nraim li tus neeg ua lag luam, tus thawj coj lossis cov neeg siv khoom xav tau. Daim duab pom lawv daim ntawv thov nyob rau hauv txhua qhov ua tau ntawm kev ua haujlwm. Yog li ntawd, Excel yog suav hais tias yog qhov haujlwm tseem ceeb hauv kev txiav txim kom tau nyiaj. Tam sim no koj tau los ze dua lawv. Hmoov zoo.