Microsoft's Excel daim ntawv thov daim ntawv thov tau tsim los tso cai rau cov neeg siv los teeb tsa thiab txhais lawv cov ntaub ntawv siv cov yam ntxwv zoo xws li pivot ntxhuav, cov qauv thiab macros. Qee zaum, cov neeg siv cov ntawv no yuav xav tau hloov lossis hloov cov ntaub ntawv txhawm rau teb cov lus nug txog qhov tshwm sim. Hloov pauv lub hauv paus ntawm lub rooj pivot tuaj yeem ua rau tsis meej pem, vim tias cov khoom siv feem ntau nyob ntawm daim ntawv cais, tab sis nws muaj peev xwm hloov pauv cov ntaub ntawv los ntawm yam tsis poob qhov kev teeb tsa ntawm koj lub rooj.
Cov kauj ruam
Kauj ruam 1. Tua tawm Microsoft Excel
Koj tuaj yeem siv ob lub desktop duab, Cov Haujlwm uas tau teev tseg hauv Start menu lossis Quick Launch taskbar, nyob ntawm koj lub khoos phis tawj
Kauj Ruam 2. Qhib cov ntawv uas muaj cov lus pivot thiab cov ntaub ntawv
Kauj Ruam 3. Hloov kho qhov tsim nyog rau cov ntaub ntawv qhov chaw
- Tej zaum koj yuav tsum tau ntxig lossis tshem kab thiab kab.
- Ua kom ntseeg tau tias txhua kab ntawv nkag tau muaj cov ncauj lus piav qhia.
Kauj Ruam 4. Xaiv daim ntawv ua haujlwm uas muaj cov lus pivot los ntawm txhaj rau lub tab uas tsim nyog
Kauj Ruam 5. Nyem sab hauv lub rooj pivot kom yuam lub rooj pivot cov cuab yeej ntawv qhia zaub mov kom pib
- Hauv Excel 2007 thiab 2010, koj yuav pom Cov Pivot Cov Cuab Yeej Cov Ntawv qhia zaub mov tshwm, hais txog xim liab, saum toj no Cov Kev Xaiv thiab Tsim tab hauv kab ntawv.
- Hauv Excel 2003, xaiv "Pivot Table thiab Pivot Chart Reports" los ntawm Cov Ntawv Qhia.
Kauj Ruam 6. Kho qhov chaw cov ntaub ntawv ntau rau koj lub rooj pivot
- Hauv Excel 2007 thiab 2010, xaiv "Hloov Cov Ntaub Ntawv Tau Txais" los ntawm Pawg Cov Ntaub Ntawv ntawm kev xaiv.
- Hauv Excel 2003, tshaj tawm Wizard cov khoom siv los ntawm txoj cai-nias hauv lub rooj pivot thiab xaiv "Wizard" los ntawm cov ntawv qhia zaub mov pop-up. Nyem rau "Tom ntej" khawm kom txog thaum koj pom lub vijtsam nrog cov ntaub ntawv ntau yam.
- Hauv txhua lub khoos phis tawm ntawm Excel, nrog cov ntaub ntawv cov ntaub ntawv tau hais tseg, nyem thiab rub kom pom qhov tshiab ntau rau koj cov ntaub ntawv.
- Koj tseem tuaj yeem piav qhia ntau yam kom suav nrog ntau kab thiab kab.
Kauj Ruam 7. Hloov kho lub rooj pivot los ntawm txhaj rau "Refresh" khawm
Lub pob no yuav muaj lub cim cim cim liab, lub cim ntsuab "rov ua dua tshiab" lossis yooj yim lo lus "Hloov tshiab," nyob ntawm koj li kev qhia thiab qib ntawm kev ua tus kheej ntawm Excel
Yees duab - Los ntawm kev siv qhov kev pabcuam no, qee cov ntaub ntawv yuav raug muab qhia rau YouTube
Lub tswv yim
- Nco ntsoov rov ua dua koj lub rooj pivot txhua lub sijhawm koj hloov pauv cov ntaub ntawv keeb kwm. Txwv tsis pub, qhov kev hloov pauv yuav tsis muaj kev cuam tshuam hauv koj cov lus pivot.
- Koj tsis tuaj yeem hloov pauv cov ntaub ntawv los ntawm kev siv lub rooj pivot. Txhua qhov kev hloov pauv yuav tsum tau ua rau cov ntaub ntawv keeb kwm thiab tom qab ntawd rov ua dua tshiab hauv cov lus pivot.
- Cov txheej txheem hloov pauv cov ntaub ntawv keeb kwm hauv kab ntawv pivot yog tib yam. Nco ntsoov hloov lub hauv paus thiab rov ua dua koj daim ntawv yog tias koj tseem tau tsim daim ntawv pivot los ntawm koj cov ntaub ntawv keeb kwm.
