Sab saum toj 5 Microsoft Excel Lub Tswv Yim thiab Tricks hauv Office 365
Txawm hais tias koj ua haujlwm hauv kev sau nyiaj, sau cov ntawv xa nyiaj, lossis tsuas yog ua qee tus lej xwb, Microsoft Excel yog qhov kev pabcuam tseem ceeb rau cov lag luam thiab cov neeg siv khoom ib yam nkaus. Txawm li cas los xij, tsis zoo li lwm cov kev pabcuam Office 365, Excel tsom rau cov ntaub ntawv hnyav, uas tuaj yeem ua rau muaj kev ntshai rau qee tus. Tsis txhob txhawj, vim tam sim no peb muab rau koj saib qee qhov peb nyiam Excel cov lus qhia thiab kev ua kom yuam kev rau Office 365. Cov lus qhia thiab kev ua kom yuam kev no yuav tsis tsuas txuag koj lub sijhawm tab sis kuj tseem ua kom yooj yim thiab pab ua rau koj tus kws tshaj lij Excel.
Siv qee qhov shortcuts
Zoo ib yam li lwm cov kev pabcuam Office 365, muaj ntau cov keyboard shortcuts uas tuaj yeem siv hauv Excel.
Thaum cuam tshuam nrog cov lej thiab cov ntawv tshaj tawm uas tuaj yeem nthuav dav yuav luag txhua kab thiab kab, cov ntawv luv no tuaj yeem ua rau txuag koj qee lub sijhawm thiab mob taub hau.
Peb tau sib sau ua ke qee qhov peb nyiam .
- CTRL + Nkag mus: rov ua cov ntawv nyeem. Nyem rau ntawm tag nrho cov pab pawg ntawm cov hlwb thiab tom qab ntawd ntaus yam koj xav rov ua dua hauv lub xov tooj kawg, tom qab ntawd nias Ctrl + Nkag. Qhov koj sau mus rau txhua lub cell..
- Alt + F1: Siv qhov shortcut no los tsim cov kab kos ntawm tib daim ntawv raws li koj cov ntaub ntawv. Ib yam li ntawd, nias . yuav F11 Txhawm rau tsim ib daim duab ntawm ib daim ntawv cais
- Ua haujlwm + F3 Siv qhov shortcut no los ntxig ib txoj haujlwm
- Alt + H + D + C: Siv qhov shortcut no los rho tawm ib kab
- Alt + H + B: Siv qhov shortcut no ntxiv ciam teb rau ib lub xovtooj
- Ctrl + Ua haujlwm + $: Siv qhov shortcut no los siv cov qauv txiaj
- Ctrl + Ua haujlwm + %: Siv qhov shortcut no los siv qhov feem pua ntawm hom ntawv
- Ctrl + Ua haujlwm + &: Siv qhov shortcut no los siv daim ntawv qhia ciam teb
- F5: Siv qhov shortcut txav mus rau ib lub xovtooj. Cia li ntaus F5 thiab format lub cell los yog lub npe ntawm tes
Sim IFS Boolean kev ua haujlwm txhawm rau tshem tawm qhov xav tau ntawm cov qauv nested
IFS yog lub luag haujlwm hauv zos hu ua "Yog, qhov no, tom qab ntawd, thiab qhov ntawd." Qhov no yog siv los ntawm cov kws tshuaj ntsuam thoob plaws lub ntiaj teb, thiab nws tuaj yeem ntsuas ntau yam hauv Excel kom koj tsis tas yuav siv cov qauv nested.
Lub feature tuaj yeem siv los ntawm kev nkag mus =IFS nyob rau hauv lub formula bar, ua raws li cov nqe lus. Tom qab ntawd IFS kuaj xyuas seb cov xwm txheej puas tau ua tiav thiab yuav rov qab tus nqi uas phim qhov TRUE. Ib qho piv txwv IFS tau qhia hauv qab no.
Hauv cov duab hauv qab no, peb tab tom siv cov qauv los tsim cov qhab nia hauv daim ntawv nthuav qhia.
Siv cov xwm txheej bar los xyuas cov xwm txheej ntawm cov ntaub ntawv
Tsis muaj leej twg nyiam ua kev suav ceev, tab sis Excel tuaj yeem ua cov ntaub ntawv sai sai rau koj. Yog tias koj muaj ib daim ntawv ntawm cov lej, lossis cov lej, cov xwm txheej bar tau yooj yim ua koj cov lej yam tsis tas yuav ntaus tus qauv. Qhov no suav nrog scalar, scalar, min, max, sum. Koj tsuas yog yuav tsum tau taw qhia cov ntaub ntawv kom pib. Muaj tsawg zaus, tej zaum koj yuav tau ua kom nws ua ntej. Yog hais tias yog li ntawd, right-click on the status bar, and click to enable the options for the stats you want to see.
Sim cov ntaub ntawv tuav kom pom koj cov ntaub ntawv visually
Cov ntaub ntawv loj yog qhov tseem ceeb, tab sis tsis muaj dab tsi pom ntau dua li infographics. Nrog cov ntaub ntawv Bars feature hauv Excel, koj tuaj yeem ntxiv cov kab rau koj cov ntxhuav uas twb muaj lawm yam tsis tau ntxiv cov duab. Koj tuaj yeem ua qhov no los ntawm kev xaiv cov ntaub ntawv thiab cov hlwb uas koj xav tau teeb tsa, thiab tom qab ntawd mus rau Homepage Tsev, thiab xaiv Kev cai Formatting , xaiv Data Bars. Tom qab ntawd koj tuaj yeem xaiv los ntawm gradient sau lossis xim sau.
Nug Excel rau kev pab
Yog tias koj pom koj tus kheej poob hauv Excel, qhov program nws tus kheej tuaj yeem pab tau. Tsuas yog nyem rau ntawm lub npov saum toj uas nws hais tshawb Thiab koj tuaj yeem tshawb nrhiav txoj haujlwm koj tab tom nrhiav ua hauv Excel.
Tom qab ntawv lub thawv tshawb nrhiav yuav qhia koj nrog kev xaiv. Xwb, koj tuaj yeem sau ntawv " Pab” Hauv qhov kev tshawb nrhiav bar no kom hu thiab nrhiav cov npe nrov Excel cov ncauj lus thiab cov haujlwm. Qee cov ncauj lus uas tau teev tseg ntawm no yog cov kab, kev ua haujlwm, cov hlwb, cov qauv, hom, cov rooj, thiab lwm yam.
Koj puas tuaj yeem tau txais qib siab dua hauv Excel?
Muaj ntau yam koj tuaj yeem ua nrog Microsoft Excel, thiab nws nyuaj rau npog nws hauv ib qho kev tshaj tawm. Peb cov lus qhia thiab kev ua kom yuam kev tsuas yog kov ntawm lub hauv paus, tab sis muaj ntau yam ntxiv kom pom. Qhia rau peb hauv cov lus hauv qab no koj tus kheej cov lus qhia thiab kev ua kom yuam kev rau Excel thiab Office 365.
Yuav ua li cas kho Microsoft Excel yuam kev codes
