Thaum tsis paub tias yog daim phiaj xwm twg, koj tuaj yeem siv Excel los tsim thiab tswj hwm koj daim ntawv qhia hnub. Muaj ntau yam txheej txheem daim ntawv qhia hnub muaj uas koj tuaj yeem hloov kho rau qhov koj nyiam, uas yuav nrawm dua li sim ua daim ntawv qhia hnub nyoog koj tus kheej. Koj tseem tuaj yeem nqa daim ntawv teev cov xwm txheej ntawm daim ntawv nthuav tawm thiab xa lawv mus rau hauv koj daim ntawv qhia hnub Outlook.
Cov kauj ruam
Txoj Kev 1 ntawm 2: Siv Tus Qauv Excel
Kauj Ruam 1. Pib daim ntawv Excel tshiab
Thaum koj nyem rau "File" tab lossis Office button thiab xaiv "Tshiab," koj yuav pom ntau yam qauv sib txawv los xaiv los ntawm.
- Rau qee qhov qauv ntawm Excel, xws li Excel 2011 rau Mac, koj yuav tsum xaiv "Tshiab los ntawm Tus Qauv" los ntawm Cov Ntawv qhia zaub mov hloov chaw "Tshiab."
- Tsim daim ntawv qhia hnub los ntawm tus qauv yuav tso cai rau koj los tsim daim ntawv qhia hnub dawb uas koj tuaj yeem sau nrog cov xwm txheej. Nws yuav tsis hloov ib qho ntawm koj cov ntaub ntawv rau hauv daim ntawv qhia hnub. Yog tias koj xav hloov cov npe Excel cov ntaub ntawv rau hauv Outlook daim ntawv qhia hnub, saib ntu tom ntej.
Kauj Ruam 2. Tshawb nrhiav daim ntawv qhia hnub
Nyob ntawm qhov version ntawm Chaw Haujlwm koj tab tom siv, tej zaum yuav muaj ntu "Calendars", lossis koj tsuas tuaj yeem ntaus "daim ntawv qhia hnub" rau hauv kev tshawb nrhiav. Qee qhov qauv ntawm Excel yuav muaj ob peb daim ntawv qhia hnub qhia meej ntawm nplooj ntawv tseem ceeb. Yog tias cov no ua tau raws li koj xav tau, koj tuaj yeem siv lawv, lossis koj tuaj yeem tshawb nrhiav rau txhua daim ntawv qhia hnub sib txawv muaj nyob hauv online.
Koj tuaj yeem tau txais qhov tshwj xeeb nrog koj tshawb fawb nyob ntawm koj xav tau. Piv txwv, yog tias koj xav tau daim ntawv qhia hnub kawm ntawv, koj tuaj yeem tshawb "daim ntawv qhia hnub kawm ntawv" dua
Kauj Ruam 3. Teev tus qauv rau hnub tim raug
Thaum tus qauv thauj khoom, koj yuav pom koj daim ntawv qhia hnub dawb. Hnub yuav zoo li tsis raug, tab sis feem ntau koj tuaj yeem hloov qhov no siv cov ntawv qhia zaub mov uas tshwm thaum koj xaiv hnub.
- Cov txheej txheem yuav txawv me ntsis nyob ntawm tus qauv koj tab tom siv. Feem ntau koj tuaj yeem xaiv lub xyoo lossis hli tso tawm thiab tom qab ntawd nyem lub pob that uas tshwm ntawm nws ib sab. Qhov no yuav tso saib cov kev xaiv uas koj tuaj yeem xaiv los ntawm, thiab daim ntawv qhia hnub yuav hloov kho tau.
- Koj tuaj yeem tuaj yeem teem hnub hnub pib lub hli zoo ib yam los ntawm kev xaiv nws thiab xaiv qhov tshiab.
Kauj Ruam 4. Txheeb xyuas cov lus qhia
Ntau tus qauv yuav muaj lub thawv ntawv nrog cov lus qhia uas tuaj yeem qhia koj txog yuav hloov cov hnub lossis hloov kho lwm qhov chaw rau daim ntawv qhia hnub hli. Koj yuav tsum tau tshem tawm cov kab ntawv no yog tias koj tsis xav kom lawv tshwm ntawm koj daim ntawv qhia hnub luam tawm.
Kauj Ruam 5. Kho qhov pom kev uas koj xav hloov
Koj tuaj yeem kho qhov zoo ntawm ib qho ntawm cov ntsiab lus los ntawm kev xaiv ib qho thiab tom qab ntawd hloov pauv hauv Tsev tab. Koj tuaj yeem hloov cov ntawv, xim, qhov loj me, thiab ntau ntxiv ib yam li koj xav tau yam khoom hauv Excel.
Kauj Ruam 6. Nkag mus rau koj cov xwm txheej
Tom qab koj daim ntawv qhia hnub tau teeb tsa kom raug, koj tuaj yeem pib nkag mus rau cov xwm txheej thiab cov ntaub ntawv rau hauv. Xaiv lub xovtooj uas koj xav ntxiv ib qho kev tshwm sim rau thiab pib ntaus ntawv. Yog tias koj xav tau tso ntau tshaj ib yam hauv ib hnub, tej zaum koj yuav tsum muaj tswv yim nrog koj qhov kev sib nrug.
Txoj Kev 2 ntawm 2: Ntshuam Cov Npe Excel rau hauv Outlook Calendar
Kauj Ruam 1. Tsim daim ntawv tshiab uas seem hauv Excel
Koj tuaj yeem xa cov ntaub ntawv los ntawm Excel rau hauv koj daim ntawv qhia hnub Outlook. Qhov no tuaj yeem ua cov khoom lag luam zoo li lub sijhawm ua haujlwm yooj yim dua.
Kauj Ruam 2. Ntxiv cov headers kom raug rau koj daim ntawv teev npe
Nws yuav yooj yim dua rau ntshuam koj cov npe rau hauv Outlook yog tias koj daim ntawv nthuav tawm nrog cov npe zoo. Sau cov npe hauv qab no rau thawj kab:
- Ntsiab lus
- Hnub Pib
- Sijhawm Pib
- Hnub Kawg
- Sijhawm Kawg
- Nqe lus piav qhia
- Qhov chaw
Kauj Ruam 3. Nkag mus rau txhua daim ntawv teev npe nkag rau hauv kab tshiab
Qhov "Kawm" teb yog lub npe ntawm qhov xwm txheej zoo li nws tshwm ntawm koj daim ntawv qhia hnub. Koj tsis tas yuav nkag mus rau qee yam rau txhua qhov haujlwm, tab sis koj yuav xav tau yam tsawg kawg "Hnub Pib" ntxiv rau "Subject."
- Nco ntsoov sau hnub tim rau hauv tus qauv MM/DD/YY lossis DD/MM/YY hom kom nws tuaj yeem nyeem tau zoo los ntawm Outlook.
- Koj tuaj yeem ua qhov xwm txheej uas nthuav tawm ntau hnub los ntawm kev siv "Pib Hnub" thiab "Hnub Kawg" teb.
Kauj Ruam 4. Qhib cov ntawv "Txuag Raws Li"
Thaum koj ua tiav ntxiv cov xwm txheej rau koj cov npe, koj tuaj yeem khaws daim ntawv theej ntawm nws hauv hom ntawv uas nyeem tau los ntawm Outlook.
Kauj Ruam 5. Xaiv "CSV (Comma delimited)" los ntawm cov ntawv qhia zaub mov hom
Nov yog hom ntawv sib xws uas tuaj yeem raug xa mus rau ntau yam haujlwm sib txawv, suav nrog Outlook.
Kauj Ruam 6. Txuag cov ntawv
Muab cov npe sau npe thiab khaws cia hauv CSV hom. Nyem "Yog" thaum nug los ntawm Excel yog tias koj xav txuas ntxiv.
Kauj Ruam 7. Qhib koj daim ntawv qhia hnub Outlook
Outlook los nrog Chaw Ua Haujlwm, thiab koj yuav feem ntau nws tau teeb tsa yog tias koj muaj Excel teeb tsa. Thaum Outlook qhib, nyem lub pob "Calendar" nyob rau hauv kaum sab laug-laug los saib koj daim ntawv qhia hnub.
Kauj Ruam 8. Nyem rau "File" tab thiab xaiv "Qhib & Export
" Koj yuav pom ntau txoj hauv kev los tuav cov ntaub ntawv Outlook.
Kauj ruam 9. Xaiv "Ntshuam/Export
" Qhov no yuav qhib lub qhov rai tshiab rau ntshuam thiab xa tawm cov ntaub ntawv nkag mus thiab tawm ntawm Outlook.
Kauj Ruam 10. Xaiv "Ntshuam los ntawm lwm qhov program lossis ntawv" thiab tom qab ntawd "Comma Separated Values
" Koj yuav raug ceeb toom kom xaiv cov ntawv koj xav thauj los ntawm.
Kauj Ruam 11. Nyem "Xauj" thiab nrhiav cov ntaub ntawv CSV uas koj tau tsim hauv Excel
Feem ntau koj yuav tsum muaj peev xwm pom nws hauv koj Cov Ntawv Teev Npe yog tias koj tsis hloov qhov chaw nyob hauv Excel.
Kauj Ruam 12. Xyuas kom "Daim Ntawv Teev Npe" raug xaiv raws li cov ntawv tais ceev tseg
Nws yuav tsum raug xaiv txij li koj nyob hauv Daim Ntawv Pom Zoo hauv Outlook.
Kauj Ruam 13. Nyem "Ua tiav" txhawm rau import cov ntawv
Koj cov npe yuav ua tiav thiab cov xwm txheej yuav raug ntxiv rau koj daim ntawv qhia hnub Outlook. Koj tuaj yeem pom koj cov xwm txheej hauv qhov chaw raug, nrog lub sijhawm teem raws li koj daim ntawv teev npe. Yog tias koj suav nrog cov lus piav qhia, koj yuav pom cov no tom qab xaiv qhov xwm txheej.
