Cov ntoo hauv tsev yog ib lub tsev kawm ntawv ib txwm ua, thiab yog txoj hauv kev lom zem los qhia tib neeg txog koj caj ces. Excel muaj peev xwm ntawm cov phiaj xwm kev nrhiav caj ceg zoo ib yam, tab sis rau cov phiaj xwm tshawb fawb ntev koj yuav xav tau software tshwj xeeb.
Cov kauj ruam
Txoj Kev 1 ntawm 3: Siv Tus Qauv
Kauj Ruam 1. Tsim daim ntawv tshiab los ntawm tus qauv
Xaiv Cov Ntaub Ntawv → Tshiab los ntawm Tus Qauv yog tias muaj kev xaiv nyob tam sim no. Ntawm qee qhov qauv ntawm Excel, tsuas yog xaiv Cov Ntaub Ntawv → Tshiab qhib lub pane uas koj tuaj yeem xaiv ntawm tus qauv.
Kauj Ruam 2. Tshawb nrhiav tsev neeg tsob ntoo qauv
Tsev neeg cov qauv ntoo tsis tau teeb tsa ua ntej, yog li koj yuav tsum txuas nrog internet kom pom nws. Tshawb nrhiav "tsev neeg tsob ntoo" txhawm rau nrhiav ob qho kev xaiv muaj rau rub tawm dawb. Yog tias koj tsis pom qhov tshawb nrhiav, saib hauv qab "Microsoft Office Online," "Office.com," lossis "Online templates," nyob ntawm koj li Excel version. Xaiv ntu "Tus Kheej", tom qab ntawd tshawb rau tsev neeg cov qauv ntoo.
Yog tias koj siv Excel 2007 lossis dhau los, koj yuav tsis pom cov kev xaiv no. Koj tuaj yeem tshawb hauv online rau cov qauv tsis raug cai, lossis hla mus rau ntu hauv qab no rau lwm txoj kev xaiv
Kauj Ruam 3. Sim daim ntawv qhia tsev ntoo yooj yim
Daim ntawv "Tsev neeg tsob ntoo" yog daim ntawv nthuav qhia yooj yim nrog cov xim dawb los qhia txog tsob ntoo tsev neeg. Tsuas muaj chav rau koj tus kheej thiab plaub tiam ntawm cov poj koob yawm txwv ncaj qha. Qhov no ua rau nws xaiv zoo rau cov phiaj xwm hauv tsev kawm ntawv, tab sis tsis txuas ntxiv kev tshawb nrhiav caj ces. Txhawm rau siv nws, tsuas yog nyem rau ntawm cov xim dawb thiab ntaus lub npe ntawm koj tsev neeg.
Txhawm rau ntxiv cov cell rau koj cov nus muag, theej-paste "koj" cell mus rau lwm lub cell hauv tib kab ntawv kom tig nws tib xim ntsuab. Ib yam li ntawd, koj tuaj yeem luam tawm-muab koj niam koj txiv lub cell tso rau hauv tib kab ntawv kom ua kom lub teeb ntsuab ntsuab rau koj tus phauj thiab txiv ntxawm
Kauj Ruam 4. Tsim tsob ntoo tsev neeg loj dua
Yog tias koj tab tom ua haujlwm ntawm tsob ntoo nyuaj dua, xaiv qhov "Family tree" template hloov chaw. Qhov no siv SmartArt qhov tshwj xeeb, uas xav tau Excel 2007 lossis tom qab. Koj tseem tuaj yeem nyem cov xwm txheej thiab ntaus koj cov txheeb ze lub npe, tab sis koj tau txais ntau yam ntxiv nrog rau:
- Nyem rau txhua qhov chaw hauv daim ntawv kom cov Ntawv Pane tshwm. Qhov no cia koj hloov kho tsev neeg tsob ntoo los ntawm cov npe yooj yim, cog. Txhawm rau ntxiv lwm tus txheeb ze, nias lub + khawm nyob rau sab saum toj ntawm lub pane. Nrog lub cell tshiab xaiv, siv cov → lossis ← khawm kom txav nws ntawm ntau tiam neeg. Nyem thiab luag kom txav nws hauv qab lub npe ntawm nws tus tub lossis tus ntxhais.
- Saum toj no ntawm daim ntawv nws tus kheej, SmartArt ribbon cov ntawv qhia muaj ntau qhov kev xaiv pom. Piv txwv li, nyem lub cim Hierarchy kom pom kev xaiv ntawm txoj hauv kev los tso saib cov ntaub ntawv.
Txoj Kev 2 ntawm 3: Siv SmartArt (Excel 2007 lossis tom qab)
Kauj Ruam 1. Nyem rau SmartArt lub cim hauv cov ntawv qhia zaub mov
Hauv cov khoos phis tawj niaj hnub no ntawm Excel, koj tuaj yeem siv qhov tshwj xeeb hu ua "SmartArt" los ua daim duab zoo nkauj dua. Xaiv "SmartArt" hauv cov ntawv qhia zaub mov saum toj ntawm daim ntawv dawb paug kom pib.
Hauv Excel 2007, hloov qhov xaiv Insert tab, tom qab ntawd pom SmartArt hauv Pawg Duab
Kauj Ruam 2. Tsim tus hierarchy
Tam sim no tias cov ntawv qhia zaub mov kab ntawv tau nthuav tawm SmartArt xaiv, xaiv lub cim Hierarchy, ze rau sab laug ntawm cov ntawv qhia zaub mov. Xaiv qhov pom kev ntawm qhov koj xaiv, thiab nws yuav tshwm nyob rau ntawm daim ntawv nthuav qhia.
Kauj Ruam 3. Sau daim ntawv tsev neeg
Daim duab tshiab tuaj yeem rub ncig thiab nthuav dav ib yam li cov khoom Excel. Nyem rau ntawm txhua tus duab lossis kab uas tsis pub dhau hauv daim duab los sau lub npe ntawm koj tsev neeg tsob ntoo.
Xwb, siv Text Pane uas tshwm thaum koj xaiv daim duab. Ib qho kev hloov pauv uas koj ua hauv kab ntawv kab ntawv yuav cuam tshuam rau daim duab qhov tsos
Txoj Kev 3 ntawm 3: Siv Daim Ntawv Qhia Yooj Yim
Kauj Ruam 1. Xaiv Insert Shape
Tsim ib daim ntawv Excel tshiab. Nyem Ntxig rau saum cov ntawv qhia zaub mov lossis cov ntawv qhia zaub mov, tom qab ntawd Zoo li. Xaiv ib lub duab plaub, oval, lossis lwm yam duab.
Kauj Ruam 2. Muab nws tso rau hauv daim ntawv nthuav qhia
Nyem thiab luag hauv daim ntawv nthuav qhia kom "kos" cov duab. Txhawm rau ua nws lub voj voos lossis lub xwmfab zoo meej, tuav cia ⇧ Hloov thaum koj rub.
Kauj Ruam 3. Sau koj lub npe kom zoo
Nyem rau ntawm qhov qis tshaj plaws thiab ntaus koj lub npe. Kho qhov font loj, xim, thiab lwm yam yog tias koj xav tau ua ntej txav mus rau qib tom ntej.
Kauj Ruam 4. Luam thiab muab tshuaj txhuam los tsim cov duab ntau dua
Xaiv cov duab uas koj nyuam qhuav kos thiab luam nws nrog Ctrl+C (⌘ Cmd+C ntawm Mac). Muab tshuaj txhuam ntau npaum li koj xav tau los ntawm kev nias Ctrl+V ntau zaus.
Kauj Ruam 5. Npaj lawv hauv tsob ntoo tsev neeg
Nyem thiab rub cov duab mus rau hauv tsev ntoo tsim. Feem ntau, koj yuav tso ib daim duab rau hauv qab ntawm daim ntawv, ob kab uake saum toj no, ob qhov ntau dua saum lawv, thiab lwm yam.
Kauj Ruam 6. Ntxig kab
Rov qab mus rau Insert Shapes menu thiab xaiv kab zig zag. Nyem thiab luag hauv daim ntawv nthuav tawm kom rub kab txuas ib lub duab nrog ob daim duab (niam txiv) saum nws. Raws li ua ntej, theej-muab tshuaj txhuam los tsim cov kab tshiab thiab rub lawv mus rau hauv txoj haujlwm.
Kauj Ruam 7. Sau cov ntaub ntawv xaiv
Yog tias koj nyiam, koj tuaj yeem suav hnub yug lossis sau ntawv hauv qab txhua lub npe. Koj tuaj yeem ntxiv qhov no sab hauv cov duab nws tus kheej, lossis nyem rau ntawm daim ntawv spreadsheet cell hauv qab txhua lub npe thiab ntaus cov ntaub ntawv nyob ntawd.