Yuav Paub
- Tsim ib daim ntawv qhia siv cov kab kos: Xaiv Insert > Daim Ntawv Pom Zoo, tom qab ntawd xaiv qhov koj xav ntxiv rau daim ntawv tshaj tawm.
- Create a report with pivot tables: Xaiv Insert > PivotTable. Xaiv cov ntaub ntawv ntau yam koj xav txheeb xyuas hauv Table/Range teb.
- Print: Mus rau File > Print, hloov kev taw qhia rau Landscape, scaling rau Fit Txhua Kab ntawm Ib Nplooj Ntawv, thiab xaiv Print Tag Nrho Cov Ntawv Ua Haujlwm.
Kab lus no piav qhia yuav ua li cas los tsim ib daim ntawv tshaj tawm hauv Microsoft Excel siv cov txuj ci tseem ceeb xws li tsim cov kab kos thiab cov ntxhuav, tsim cov ntxhuav pivot, thiab luam tawm daim ntawv tshaj tawm. Cov ntaub ntawv hauv kab lus no siv rau Excel 2019, Excel 2016, Excel 2013, Excel 2010, thiab Excel rau Mac.
Tsim cov kab kos yooj yim thiab cov lus rau daim ntawv qhia Excel
Tsim cov ntawv ceeb toom feem ntau txhais tau tias sau cov ntaub ntawv thiab nthuav tawm tag nrho hauv ib daim ntawv uas yog daim ntawv tshaj tawm rau tag nrho cov ntaub ntawv. Cov nplooj ntawv ceeb toom no yuav tsum tau muab tso rau hauv txoj hauv kev uas yooj yim luam tawm thiab.
Ib qho ntawm cov cuab yeej siv tshaj plaws uas tib neeg siv hauv Excel los tsim cov ntawv ceeb toom yog daim duab thiab cov cuab yeej rooj. Txhawm rau tsim ib daim ntawv qhia hauv daim ntawv qhia Excel:
-
Xaiv Insert los ntawm cov ntawv qhia zaub mov, thiab hauv pawg kab kos, xaiv hom kab ntawv koj xav ntxiv rau daim ntawv tshaj tawm.
Image -
Nyob hauv kab ntawv Tsim cov ntawv qhia, hauv pawg Cov Ntaub Ntawv, xaiv Xaiv Cov Ntaub Ntawv.
Image -
Xaiv daim ntawv nrog cov ntaub ntawv thiab xaiv tag nrho cov hlwb uas muaj cov ntaub ntawv koj xav tau daim ntawv (xws li headers).
Image -
Daim duab yuav hloov kho hauv koj daim ntawv tshaj tawm nrog cov ntaub ntawv. Cov headers yuav raug siv los sau cov ntawv nyob rau hauv ob axis.
Image -
Rov ua cov kauj ruam saum toj no los tsim cov kab kos tshiab thiab cov duab kos uas tsim nyog sawv cev rau cov ntaub ntawv koj xav qhia hauv koj daim ntawv tshaj tawm. Thaum koj xav tau tsim ib daim ntawv tshaj tawm tshiab, koj tuaj yeem muab cov ntaub ntawv tshiab tso rau hauv cov ntaub ntawv nplooj ntawv, thiab cov kab kos thiab cov duab hloov tshiab tau txais.
Image Muaj ntau txoj hauv kev los teeb tsa ib daim ntawv qhia siv Excel. Koj tuaj yeem suav nrog cov duab kos thiab kab kos rau tib nplooj ntawv raws li cov ntaub ntawv tabular (tus lej), lossis koj tuaj yeem tsim ntau nplooj ntawv kom pom kev tshaj tawm ntawm ib daim ntawv, cov ntaub ntawv tabular nyob rau lwm daim ntawv, thiab lwm yam.
Siv PivotTables los tsim Daim Ntawv Qhia Los ntawm Excel Spreadsheet
Pivot ntxhuav yog lwm lub cuab yeej muaj zog rau kev tsim cov ntawv ceeb toom hauv Excel. Pivot cov rooj pab nrog khawb tob rau hauv cov ntaub ntawv.
-
Xaiv daim ntawv nrog cov ntaub ntawv koj xav txheeb xyuas. Xaiv Insert > PivotTable.
Image -
Nyob hauv Tsim PivotTable kev sib tham, hauv Table/Range teb, xaiv qhov ntau ntawm cov ntaub ntawv koj xav txheeb xyuas. Hauv qhov chaw nyob, xaiv thawj lub xovtooj ntawm daim ntawv ua haujlwm uas koj xav tau kev tshuaj xyuas mus. Xaiv OK kom tiav.
Image -
Qhov no yuav tso cov txheej txheem pivot rooj tsim hauv daim ntawv tshiab. Hauv thaj chaw PivotTable Fields, thawj daim teb uas koj xaiv yuav yog qhov chaw siv.
Image Hauv qhov piv txwv no, cov lus pivot no yuav qhia cov ntaub ntawv tsheb khiav hauv lub vev xaib los ntawm lub hli. Yog li, ua ntej, koj yuav xaiv Hnub.
-
Tom ntej no, luag cov ntaub ntawv teb koj xav qhia cov ntaub ntawv rau hauv thaj chaw muaj txiaj ntsig ntawm PivotTable teb pane. Koj yuav pom cov ntaub ntawv xa los ntawm cov ntawv sau rau hauv koj lub rooj pivot.
Image -
Lub rooj pivot sib sau tag nrho cov ntaub ntawv rau ntau yam khoom los ntawm kev ntxiv lawv (los ntawm lub neej ntawd). Hauv qhov piv txwv no, koj tuaj yeem pom lub hli twg tau pom nplooj ntawv ntau tshaj plaws. Yog tias koj xav tau ib qho kev txheeb xyuas sib txawv, tsuas yog xaiv tus nqes-down xub ntawm ib sab ntawm cov khoom hauv qhov muaj txiaj ntsig pane, tom qab ntawd xaiv Tus Nqi Teb Chaw
Image -
Nyob rau hauv tus nqi teb chaw dialog box, hloov lub laij lej hom rau qhov twg koj nyiam.
Image - Qhov no yuav hloov kho cov ntaub ntawv hauv lub rooj pivot raws li. Siv txoj hauv kev no, koj tuaj yeem ua txhua qhov kev tshuaj xyuas koj nyiam ntawm cov ntaub ntawv hauv qhov chaw, thiab tsim cov kab kos pivot uas tso tawm cov ntaub ntawv hauv koj daim ntawv tshaj tawm raws li qhov koj xav tau.
Yuav Ua Li Cas Sau Koj Daim Ntawv Qhia Excel
Koj tuaj yeem tsim cov ntawv luam tawm los ntawm txhua daim ntawv uas koj tsim, tab sis ua ntej koj yuav tsum ntxiv nplooj ntawv headers.
-
Xaiv Insert > Text > Header&footer.
Image -
Hloov lub npe rau nplooj ntawv tshaj tawm, tom qab ntawd format nws kom siv loj dua cov ntawv ib txwm. Rov ua cov txheej txheem no rau txhua daim ntawv tshaj tawm uas koj npaj yuav luam tawm.
Image -
Tom ntej no, zais cov nplooj ntawv uas koj tsis xav tau suav nrog hauv daim ntawv tshaj tawm. Txhawm rau ua qhov no, nyem rau ntawm daim ntawv tab thiab xaiv Hide.
Image -
Tau luam koj daim ntawv qhia, xaiv File > Print. Hloov kev taw qhia rau Landscape, thiab scaling rau Haum Txhua Kab ntawm Ib Nplooj Ntawv.
Image -
Xaiv Print tag nrho Phau Ntawv Qhia. Tam sim no thaum koj luam koj daim ntawv tshaj tawm, tsuas yog cov ntawv tshaj tawm uas koj tsim yuav luam tawm ua ib nplooj ntawv.
Koj tuaj yeem luam koj daim ntawv tshaj tawm rau hauv ntawv, lossis luam tawm ua PDF thiab xa tawm raws li email txuas.
