Yuav Ua Li Cas Kab Kab Hauv Microsoft Excel: 12 Cov Kauj Ruam

Cov txheej txheem:

Yuav Ua Li Cas Kab Kab Hauv Microsoft Excel: 12 Cov Kauj Ruam
Yuav Ua Li Cas Kab Kab Hauv Microsoft Excel: 12 Cov Kauj Ruam

Video: Yuav Ua Li Cas Kab Kab Hauv Microsoft Excel: 12 Cov Kauj Ruam

Video: Yuav Ua Li Cas Kab Kab Hauv Microsoft Excel: 12 Cov Kauj Ruam
Video: Cas Tsis Xaiv Koj - R-Lin Thoj New Song Original By Zaj Dub [Official MV] 2023 2024, Tej zaum
Anonim

Qhov wikiHow qhia koj yuav tsim kab kab los ntawm Microsoft Excel cov ntaub ntawv. Koj tuaj yeem ua qhov no ntawm ob qho tib si Windows thiab Mac versions ntawm Excel.

Cov kauj ruam

Ntu 1 ntawm 2: Tsim Kab Duab

Ua Kab Kab hauv Microsoft Excel Kauj Ruam 1
Ua Kab Kab hauv Microsoft Excel Kauj Ruam 1

Kauj Ruam 1. Qhib Microsoft Excel

Ob npaug nias rau lub cim Excel program, uas zoo li dawb "X" ntawm daim nplaub tshev ntsuab. Excel yuav qhib rau nws qhov home page.

Yog tias koj twb muaj Excel daim ntawv nthuav qhia nrog cov ntaub ntawv nkag mus, hloov ob npaug rau nyem rau ntawm daim ntawv thiab hla ob kauj ruam tom ntej

Ua Kab Kab hauv Microsoft Excel Kauj Ruam 2
Ua Kab Kab hauv Microsoft Excel Kauj Ruam 2

Kauj Ruam 2. Nyem Phau Ntawv Tsis Txaus Siab

Nws nyob ntawm Excel home page. Ua li ntawd yuav qhib daim ntawv tshiab rau koj cov ntaub ntawv.

Ntawm Mac, Excel tsuas yog qhib rau phau ntawv ua haujlwm tsis siv neeg nyob ntawm koj qhov chaw. Yog tias yog, hla cov kauj ruam no

Ua Kab Kab hauv Microsoft Excel Kauj Ruam 3
Ua Kab Kab hauv Microsoft Excel Kauj Ruam 3

Kauj Ruam 3. Sau koj cov ntaub ntawv

Ib kab duab kab yuav tsum muaj ob txoj hauv kev txhawm rau ua haujlwm. Sau koj cov ntaub ntawv rau hauv ob kab. Txhawm rau siv tau yooj yim, teeb tsa koj cov ntaub ntawv X-axis (sijhawm) hauv kab sab laug thiab koj cov kev soj ntsuam kaw hauv kab sab xis.

Piv txwv li, taug qab koj cov peev nyiaj xyoo yuav muaj hnub nyob hauv kab sab laug thiab kev siv nyiaj sab xis

Ua Kab Kab hauv Microsoft Excel Kauj Ruam 4
Ua Kab Kab hauv Microsoft Excel Kauj Ruam 4

Kauj Ruam 4. Xaiv koj cov ntaub ntawv

Nyem thiab luag koj tus nas los ntawm sab laug-tes ntawm tes hauv pab pawg cov ntaub ntawv mus rau hauv qab-txoj cai ntawm tes hauv cov pab pawg. Qhov no yuav qhia tag nrho koj cov ntaub ntawv.

Nco ntsoov tias koj suav nrog kab ntawv kab ntawv yog tias koj muaj lawv

Ua Kab Kab hauv Microsoft Excel Kauj Ruam 5
Ua Kab Kab hauv Microsoft Excel Kauj Ruam 5

Kauj Ruam 5. Nyem rau Insert tab

Nws nyob rau sab laug ntawm kab ntsuab uas nyob rau sab saum toj ntawm Excel qhov rai. Qhov no yuav qhib qhov Ntxig toolbar hauv qab ntawm kab ntsuab.

Ua Kab Kab hauv Microsoft Excel Kauj Ruam 6
Ua Kab Kab hauv Microsoft Excel Kauj Ruam 6

Kauj Ruam 6. Nyem rau "Kab Duab" icon

Nws yog lub thawv uas muaj ob peb kab kos rau ntawm nws hauv Cov duab pawg ntawm kev xaiv. Cov ntawv qhia zaub mov nco-down yuav tshwm.

Ua Kab Kab hauv Microsoft Excel Kauj Ruam 7
Ua Kab Kab hauv Microsoft Excel Kauj Ruam 7

Kauj Ruam 7. Xaiv kab kos

Hover koj tus cursor nas hla kab kab qauv hauv cov ntawv qhia zaub mov kom pom nws yuav zoo li cas nrog koj cov ntaub ntawv. Koj yuav tsum pom lub qhov rai teeb tsa tshwm hauv nruab nrab ntawm koj lub qhov rais Excel.

Ua Kab Kab hauv Microsoft Excel Kauj Ruam 8
Ua Kab Kab hauv Microsoft Excel Kauj Ruam 8

Kauj Ruam 8. Nyem rau kab kos

Thaum koj txiav txim siab ntawm tus qauv, nyem nws yuav tsim koj kab kab nyob nruab nrab ntawm Excel qhov rai.

Ntu 2 ntawm 2: Kho Koj Cov Duab

Ua Kab Kab hauv Microsoft Excel Kauj Ruam 9
Ua Kab Kab hauv Microsoft Excel Kauj Ruam 9

Kauj Ruam 1. Kho koj lub teeb duab tsim

Thaum koj tsim koj daim duab, cov Tsim toolbar yuav qhib. Koj tuaj yeem hloov koj daim duab tsim thiab pom los ntawm txhaj ib qho ntawm cov kev hloov pauv hauv ntu "Chart Styles" ntu ntawm lub cuab yeej.

Yog tias lub cuab yeej no tsis qhib, nyem koj lub teeb thiab tom qab ntawd nyem rau Tsim tab nyob rau ntawm daim kab xev ntsuab.

Ua Kab Kab hauv Microsoft Excel Kauj Ruam 10
Ua Kab Kab hauv Microsoft Excel Kauj Ruam 10

Kauj Ruam 2. Tsiv koj kab duab kab

Nyem thiab luag qhov chaw dawb nyob ze rau sab saum toj ntawm kab kab kom txav nws.

Koj tseem tuaj yeem txav cov ntu tshwj xeeb ntawm kab kab (piv txwv li, lub npe) los ntawm kev nyem thiab rub lawv ib puag ncig hauv kab kab kab qhov rai

Ua Kab Kab hauv Microsoft Excel Kauj Ruam 11
Ua Kab Kab hauv Microsoft Excel Kauj Ruam 11

Kauj Ruam 3. Hloov kho daim duab

Nyem thiab rub ib qho ntawm lub voj voos ntawm ib qho ntawm cov npoo lossis kaum ntawm lub qhov rais teeb tsa hauv lossis tawm kom nqaim lossis nthuav koj daim duab.

Ua Kab Kab hauv Microsoft Excel Kauj Ruam 12
Ua Kab Kab hauv Microsoft Excel Kauj Ruam 12

Kauj Ruam 4. Hloov daim duab lub npe

Nyem ob npaug rau lub npe ntawm kab ntawv, tom qab ntawv xaiv kab ntawv "Cov Ntawv Teev Npe" thiab ntaus koj daim duab lub npe. Nyem qhov twg tawm ntawm kab lus lub npov lub npe yuav txuag cov ntawv.

Koj tuaj yeem ua qhov no rau koj daim duab duab kab ntawv cov kab ntawv ib yam

Pom zoo: