Cov kev qhia Excel no rau cov neeg pib tshiab suav nrog cov screenshots thiab cov piv txwv nrog cov lus qhia ntxaws ib kauj ruam. Ua raws li cov ntawv txuas hauv qab no kom paub txhua yam koj xav tau kom sawv thiab khiav nrog Microsoft cov ntawv tshaj tawm nrov software.
Kab lus no siv rau Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel rau Mac, thiab Excel rau Android.
Nkag siab cov ntsiab lus ntawm Excel Screen
Nkag siab txog Cov Ntsiab Lus Excel Cov Ntsiab Lus npog cov ntsiab lus tseem ceeb ntawm daim ntawv ua haujlwm Excel. Cov ntsiab lus no suav nrog:
- Cells thiab active cells
- Ntxiv daim ntawv icon
- kab ntawv
- kab zauv
- Status bar
- Formula bar
- Npe box
- File tab
Nyob zoo ib tsoom niam txiv kwv tij phooj ywg sawv daws
Tshawb nrhiav ib qho yooj yim Excel Spreadsheet
Excel Kauj Ruam los ntawm kauj ruam Basic Tutorial npog cov hauv paus ntawm kev tsim thiab formatting ib daim ntawv nthuav dav hauv Excel. Koj yuav kawm yuav ua li cas:
- Ntau cov ntaub ntawv
- Tsim cov qauv yooj yim
- Define a named range
- Luam cov qauv nrog tus tuav tuav
- Thov tus lej formatting
- Ntxiv cell formatting
Tsim cov qauv nrog Excel Math
Xav kawm ntxiv, rho tawm, sib faib, thiab faib hauv Excel, saib Yuav Ua Li Cas Siv Cov Qauv Lej Yooj Yim Zoo Li Ntxiv thiab rho tawm hauv Excel. Qhov kev qhia no tseem suav nrog kev nthuav tawm thiab hloov qhov kev txiav txim ntawm kev ua haujlwm hauv cov qauv. Txhua lub ntsiab lus suav nrog cov piv txwv ib ntus ntawm yuav ua li cas los tsim cov qauv uas ua ib lossis ntau dua ntawm plaub txoj haujlwm lej hauv Excel.
Ntxiv Tus lej Nrog SUM Function
Ntxiv kab thiab kab ntawm cov lej yog ib qho ntawm cov haujlwm tshaj plaws hauv Excel. Txhawm rau ua kom txoj haujlwm no yooj yim dua, siv SUM ua haujlwm. Ceev cov kab los yog kab ntawm cov lej hauv Excel qhia koj li cas:
- Nkag siab txog SUM muaj nuj nqi syntax thiab cov lus sib cav
- Enter the SUM function
- Ntxiv cov lej nrawm nrog AutoSUM
- Siv SUM function dialog box
Tsiv lossis Luam Cov Ntaub Ntawv
Thaum koj xav luam tawm lossis txav cov ntaub ntawv mus rau qhov chaw tshiab, saib Shortcut Keys to Cut, Copy, and Paste Data in Excel. Nws qhia koj yuav ua li cas:
- Copy data
- Muab cov ntaub ntawv nrog cov ntawv teev cia
- copy thiab paste siv cov yuam sij shortcut
- Luam cov ntaub ntawv siv cov ntawv qhia zaub mov
- Luam cov ntaub ntawv siv cov ntawv qhia zaub mov ntawm lub Tsev tab
- Tsiv cov ntaub ntawv nrog cov yuam sij luv
- Tsiv cov ntaub ntawv nrog cov ntawv qhia zaub mov thiab siv lub Tsev tab
Ntxiv thiab tshem cov kab thiab kab
Xav tau kho qhov layout ntawm koj cov ntaub ntawv? Ntxiv thiab rho tawm kab thiab kab hauv Excel piav qhia yuav ua li cas nthuav lossis txo qhov chaw ua haujlwm raws li xav tau. Koj yuav kawm txog txoj hauv kev zoo tshaj los ntxiv lossis tshem tawm cov lus lossis ntau kab thiab kab uas siv cov keyboard shortcut lossis cov ntsiab lus hauv cov ntawv qhia zaub mov.
Hide and Unhide Kum and Rows
Yuav ua li cas nkaum thiab tshem cov kab, kab, thiab Cells hauv Excel qhia koj yuav ua li cas nkaum ntu ntawm daim ntawv ua haujlwm kom yooj yim rau kev tsom mus rau cov ntaub ntawv tseem ceeb. Nws yooj yim coj lawv rov qab thaum koj xav pom cov ntaub ntawv zais dua.
Nkag Hnub
Kom kawm paub siv cov keyboard shortcut yooj yim los teeb tsa hnub thiab sijhawm, saib Siv Shortcut Keys Ntxiv Hnub Nyoog Tam Sim No / Lub Sijhawm hauv Excel. Yog tias koj xav kom muaj hnub hloov tshiab txhua lub sijhawm qhib daim ntawv ua haujlwm, saib Siv Hnub Nyoog Hnub no hauv Cov Ntawv Ua Haujlwm hauv Excel.
Enter Data in Excel
Dos and Dont's of Entering Data in Excel npog cov kev coj ua zoo tshaj plaws rau kev nkag cov ntaub ntawv thiab qhia koj yuav ua li cas:
- Plan daim ntawv ua haujlwm
- Tau cov ntaub ntawv
- Nkag mus rau nqe lus thiab cov ntaub ntawv
- Tiv thaiv daim ntawv ua haujlwm
- Siv cell references in formulas
- Sorrt data
Tsim kab ntawv kab
Yuav siv kab kos thiab duab hauv Excel piav qhia yuav ua li cas siv cov duab kos los qhia kev sib piv ntawm cov khoom ntawm cov ntaub ntawv. Txhua kab hauv kab ntawv sawv cev rau cov ntaub ntawv sib txawv ntawm daim ntawv ua haujlwm.
Create a Line Graph
Yuav ua li cas thiab tsim cov kab kos hauv Excel hauv 5 Cov kauj ruam qhia koj yuav ua li cas taug qab cov kev hloov hauv lub sijhawm. Txhua kab hauv daim duab qhia txog kev hloov pauv ntawm tus nqi rau ib tus nqi ntawm cov ntaub ntawv ua haujlwm.
Visualize Data With a Pie Chart
Nkag siab Excel Daim Ntawv Qhia Cov Ntaub Ntawv, Cov Ntsiab Lus Cov Ntaub Ntawv, thiab Cov Ntawv Sau Cov Ntaub Ntawv npog yuav ua li cas siv daim duab ncuav qab zib kom pom qhov feem pua. Ib cov ntaub ntawv ib zaug yog npaj thiab txhua daim ntawm lub ncuav qab zib sawv cev rau ib qho ntaub ntawv tus nqi los ntawm daim ntawv ua haujlwm.
