Cov kab ntawv pab qhia cov lej ua lej hauv cov graphical format, yooj yim rau kev nkag siab ntawm cov ntaub ntawv loj. Tsis tas li, siv cov kab kos, koj tuaj yeem qhia qhov kev sib raug zoo ntawm cov ntaub ntawv sib txawv.
Microsoft lub chaw haujlwm suite tivthaiv, Lo Lus, kuj tseem tuaj yeem koj tsim cov duab kos. Peb yuav qhia txog kev yuav ua li cas hauv qab no.
Nco tseg: Qhov muaj nyob ntawm koj lub khoos phis tawm ntawm Microsoft Excel software tsim tawm muab cov hauv kev zoo rau kev tsim cov duab kos hauv Lus 2003, 2007, 2010 - 2016. Yog tias Excel tsis tau nruab, Microsoft Graph siv los tsim cov duab kos. Daim duab qhia nyob rau hauv cov ntaub ntawv no yuav nthuav tawm nrog cov ntaub ntawv cuam tshuam (cov lus). Koj tuaj yeem tsis tsuas yog nkag mus rau koj cov ntaub ntawv hauv lub rooj no, tab sis kuj tuaj yeem muab nws nkag los ntawm cov ntawv sau lossis txawm muab nws los ntawm lwm cov haujlwm.
Tsim cov qauv qhia
Koj tuaj yeem ntxiv ib daim duab kos rau Word rau ob txoj hauv kev - muab nws tso rau hauv cov ntawv lossis ntxig rau Excel daim ntawv uas yuav cuam tshuam nrog cov ntaub ntawv ntawm Excel daim ntawv. Qhov sib txawv ntawm cov kos duab no yog qhov uas lawv khaws cov ntaub ntawv lawv muaj thiab lawv yuav hloov kho sai li cas tom qab tso rau hauv MS Word.
Nco tseg: Qee daim duab kos yuav tsum tau muaj kev npaj tshwj xeeb ntawm cov ntaub ntawv ntawm MS Excel ntawv.
Yuav ua li cas ntxig ib daim duab kos los ntawm kev teeb tsa nws hauv ib daim ntawv?
Daim duab Excel ntawm qhov sau rau hauv Lo Lus yuav tsis hloov txawm tias koj hloov kho cov ntaub ntawv. Cov khoom tau muab tso rau hauv daim ntawv dhau los ua ib feem ntawm cov ntawv, tsis kam ua ib feem ntawm cov khoom siv.
Muab hais tias tag nrho cov ntaub ntawv khaws cia rau hauv Ib Lo Lus Qhia, nws yog qhov tshwj xeeb tshaj yog siv los ua paj ntaub nyob rau hauv rooj plaub uas koj tsis tas yuav hloov cov ntaub ntawv no tib, coj mus rau hauv tus account cov ntaub ntawv. Tsis tas li, kev siv yog qhov zoo dua los siv thaum koj tsis xav tau cov neeg siv uas yuav ua haujlwm nrog cov ntaub ntawv yav tom ntej txhawm rau hloov kho txhua yam ntaub ntawv ntsig txog.
1. Sab laug-nyem rau ntawm daim ntawv uas koj xav ntxiv rau hauv daim ntawv.
2. Mus rau hauv lub tab "Ntxig".
3. Hauv pawg "Cov lus piv txwv" xaiv "Daim duab".
4. Hauv lub thawv ntawv lub thawv uas pom, xaiv daim qauv yam xav tau thiab nyem OK.
5. Tsis tsuas yog daim ntawv nthuav qhia yuav tshwm sim rau ntawm daim ntawv, tab sis kuj Excel, uas yuav nyob rau hauv lub qhov rais muab faib. Nws tseem yuav ua kom pom cov qauv ntaub ntawv.
6. Hloov cov qauv ntaub ntawv tau muab rau hauv Excel Excel sib cais lub qhov rai nrog cov nqi koj xav tau. Ntxiv rau cov ntaub ntawv, nws yog qhov hloov tau los hloov cov piv txwv ntawm kev kos npe kos npeKem 1) thiab lub npe ntawm cov lus dab neeg (Kab 1).
7. Tom qab koj nkag mus rau cov ntaub ntawv tsim nyog nyob rau hauv Excel qhov rais, nyem rau ntawm lub cim "Hloov cov ntaub ntawv hauv Microsoft Excel»Thiab txuag tsab ntawv: Cov ntaub ntawv - Txuag Raws Li.
8. Xaiv qhov chaw kom khaws daim ntawv thiab sau lub npe yam xav tau.
9. Nyem "Txuag"Cov. Tam sim no daim ntawv tuaj yeem raug kaw.
Qhov no tsuas yog ib qho ntawm txoj hauv kev uas koj tuaj yeem kos daim duab los ntawm cov lus hauv Lus.
Yuav ua li cas ntxiv txuas Daim Ntawv Excel rau ib daim ntawv?
Txoj kev no tso cai rau koj los tsim ib daim ntawv ncaj qha hauv Excel, hauv nplooj ntawv sab nraud ntawm qhov kev pabcuam, thiab tom qab ntawd tsuas yog nkag mus rau nws cov ntawv uas cuam tshuam rau hauv MS Word. Cov ntaub ntawv muaj nyob hauv daim qauv txuas yuav raug hloov thaum hloov pauv / hloov tshiab dhau rau daim ntawv sab nraud uas lawv tau khaws cia. Lo lus nws tus kheej tsuas yog khaws lub chaw nyob ntawm cov peev txheej, nthuav tawm cov ntaub ntawv cuam tshuam uas hais hauv nws.
Txoj hauv kev los tsim cov duab kos yog qhov tshwj xeeb tshaj yog thaum koj xav tau cov ntaub ntawv hauv cov ntawv uas koj tsis yog lub luag haujlwm. Qhov no yuav yog cov ntaub ntawv sau los ntawm lwm tus neeg uas yuav hloov kho lawv raws li tsim nyog.
1. Txiav daim duab ntawm Excel. Koj tuaj yeem ua qhov no los ntawm nias lub pob. "Ctrl + X" lossis nrog nas: xaiv ib daim duab thiab nyem "Txiav" (pawg "Ntawv los teev cia"tab "Tsev").
2. Hauv lo lus Word, nyem qhov chaw uas koj xav tau ntxig tus duab qhia.
3. Siv kab ntawv los siv cov yuam sij "Ctrl + V" lossis xaiv qhov tsim nyog hais kom ua nyob rau hauv cov tswj kav: Muab tshuaj txhuam.
4. Khaws daim ntawv nrog daim duab kab ntawv tso rau hauv.
Nco tseg: Cov kev hloov koj ua rau tus thawj Excel daim ntawv (cov ntawv sab nraud) yuav tshwm rau hauv Lo Lus Teev rau hauv koj tau tso nrog daim ntawv. Txhawm rau hloov cov ntaub ntawv thaum koj qhib cov ntaub ntawv dua tom qab kaw nws, koj yuav tsum paub meej cov ntaub ntawv hloov tshiab (khawm Yog lawm).
Hauv qhov piv txwv tshwj xeeb, peb tau soj ntsuam cov ntawv qhia ncuav qab zib hauv Lo Lus, tab sis hauv txoj kev no koj tuaj yeem ua ib daim duab ntawm txhua yam, yog nws daim duab qhia cov kab ntawv, xws li hauv cov piv txwv dhau los, histogram, npuas daim duab, lossis lwm yam.
Hloov cov qauv lossis cov qauv ntawm daim qauv qhia
Koj tuaj yeem hloov kho cov tsos ntawm daim qauv uas koj tau tsim hauv Lo Lus. Nws tsis yog qhov tsim nyog los ua rau tus kheej ntxiv cov ntsiab lus tshiab, hloov pauv ntawm lawv, teeb tsa lawv - yeej ib txwm ua tau los siv cov qauv npaj ua los yog cov qauv tsim, ntawm cov uas muaj ntau ntawm Microsoft program. Txhua cov qauv lossis cov qauv ib txwm tuaj yeem hloov kho tus kheej thiab kho raws li qhov tsim nyog lossis xav tau, ib yam li koj tuaj yeem ua haujlwm nrog txhua tus neeg ntawm daim duab.
Yuav thov cov txheej txheem tiav li cas?
1. Nyem rau ntawm daim duab uas koj xav hloov thiab mus rau lub tab "Tus tsim qauv"nyob rau hauv lub ntsiab tab "Ua haujlwm nrog cov duab kos".
2. Xaiv cov qauv teeb koj xav siv (pawg Txheej Txheem).
3. Cov ntawv ntawm koj daim duab qhia yuav raug hloov.
Yuav thov li cas npaj-ua qauv?
1. Nyem rau ntawm daim duab uas koj xav thov ua tiav cov style tiav thiab mus rau lub tab "Tus tsim qauv".
2. Xaiv cov qauv koj xav siv rau koj daim duab hauv cov pab pawg. Cov Cim Ntxaij.
3. Cov kev hloov pauv yuav cuam tshuam koj daim duab qhia tam sim ntawd.
Yog li, koj tuaj yeem hloov pauv koj cov duab kos, uas yog hu ua ntawm kev mus, xaiv cov qauv tsim nyog thiab qauv, nyob ntawm seb dab tsi xav tau ntawm lub sijhawm. Piv txwv li, koj tuaj yeem tsim ob peb lub ntsej muag sib txawv rau kev ua haujlwm, thiab tom qab ntawd hloov los ntawm, es tsis txhob tsim cov tshiab (peb yuav tham txog yuav ua li cas khaws cov kab kos ua qauv hauv qab)Cov. Piv txwv li, koj muaj kab kos nrog kab ntawv lossis kab ntawv ci, xaiv cov qauv tsim nyog, koj tuaj yeem ua daim duab nrog cov feem pua hauv Lo Lus los ntawm nws.
Yuav ua li cas kom hloov pauv daim ntawv teeb?
1. Nyem rau ntawm daim duab lossis ib pawg keeb kwm uas nws qhov koj xav hloov. Qhov no tuaj yeem ua lwm txoj hauv kev:
- Nyem rau txhua qhov chaw ntawm daim duab coj los ua kom lub twj. "Ua haujlwm nrog cov duab kos".
- Nyob hauv tab "Hom ntawv"pab pawg "Tam sim no thooj" nyem rau ntawm xub nyob ib sab "Daim Ntawv Ntsiab", tom qab uas koj tuaj yeem xaiv qhov khoom xav tau.
2. Hauv lub tab "Tus tsim qauv", hauv pawg Txheej Txheem nyem rau ntawm thawj cov khoom - Ntxiv Ntawv Cim Caij.
3. Hauv cov ntawv qhia pop-up, xaiv qhov koj xav ntxiv lossis hloov.
Nco tseg: Cov kev xaiv Layout uas koj xaiv thiab / lossis hloov tsuas yog siv rau cov khoom xaiv uas raug xaiv. Thaum koj tau xaiv tag nrho daim duab, piv txwv li qhov ntsuas “Cov Ntawv Cov Ntaub Ntawv” yuav raug siv rau tag nrho cov ntsiab lus. Yog tias tsuas yog cov ntaub ntawv taw tes raug xaiv, cov pauv yuav raug siv tshwj rau nws.
Yuav ua li cas hloov cov ntaub ntawv ntawm cov qauv qhia cov ntsiab lus?
1. Nyem rau ntawm kab ntawv lossis nws tus kheej keeb kwm uas nws nyiam koj hloov.
2. Mus rau hauv lub tab "Hom ntawv" seem "Ua haujlwm nrog cov duab kos" thiab ua qhov tsim nyog ua:
- Txhawm rau xaiv cov duab piav qhia xaiv, xaiv "Tus qauv ntawm cov xaiv tau tawg" hauv pawg "Tam sim no thooj"Cov. Tom qab ntawd, koj tuaj yeem tsim qhov tsim nyog xaiv hom kev xaiv.
- Txhawm rau hloov cov hom, uas yog lub hauv paus ntawm daim ntawv qhia, xaiv cov yam xav tau hauv cov pab pawg "Daim Duab Ntxoo"Cov. Ntxiv nrog rau kev hloov pauv hom, koj tuaj yeem sau hom duab nrog xim, hloov xim ntawm nws cov qauv, ntxiv cov teebmeem.
- Txhawm rau sau cov ntawv, xaiv qhov xav yam hauv pawg. WordArt Cov QauvCov. Ntawm no koj tuaj yeem ua tiav "Sau cov lus", "Cov ntsiab lus qhia" lossis ntxiv cov teebmeem tshwj xeeb.
Yuav ua li cas kom txuag tau daim duab ua tus qauv?
Nws feem ntau tshwm sim hais tias daim duab daim duab tsim los ntawm koj yuav xav tau yav tom ntej, zoo ib yam lossis nws cov analogue, qhov no tsis tseem ceeb. Hauv qhov xwm txheej no, nws yog qhov zoo tshaj plaws los khaws cov ntawv qhia ua tus qauv - qhov no yuav ua rau yooj yim thiab ua haujlwm nrawm yav tom ntej.
Txhawm rau ua qhov no, tsuas yog nyem rau ntawm kab ntawv hauv txoj nyem nas thiab xaiv Khaws Cia Ua Tus Qauv.
Hauv qhov rai uas tshwm, xaiv ib qho chaw kom txuag, qhia kom meej cov ntaub ntawv npe thiab nyem "Txuag".
Qhov ntawd yog txhua yam, tam sim no koj paub yuav ua li cas los tsim ib daim duab hauv cov lus uas tau teeb tsa lossis txuas nrog, muaj qhov sib txawv, uas, los ntawm txoj kev, tuaj yeem hloov pauv thiab kho kom haum rau koj cov kev xav tau lossis qhov xav tau tsim nyog. Peb xav kom koj ua haujlwm zoo thiab kev cob qhia zoo.
