Tooj naj npawb los yog cov hnub tim yog tus naj npawb uas siv Excel siv xam cov hnub thiab lub sij hawm uas sau rau hauv daim ntawv ua haujlwm, txawm tias yog kev xuas tes los yog raws li cov qauv ntawm cov hnub suav.
Excel nyeem lub tshuab computer lub moos kom thiaj li khiav tau cov sijhawm ntawm lub sijhawm pib txij hnub pib lub sijhawm pib hnub ntawd.
Ob Hnub Hnub Uas Nruab Nrab
Los ntawm lub neej ua ke, tag nrho cov versions ntawm Excel uas khiav ntawm lub qhov rais operating system, cia lub hnub ua ib qho txiaj ntsig uas muaj pes tsawg hnub ntawm txij thaum ib tag hmo 1, 1900, ntxiv rau cov xuab moos, feeb, thiab vib nas this rau hnub tam sim no.
Versions ntawm Excel uas khiav ntawm Macintosh computers neej ntawd mus rau ob lub hnub nruab nrab.
- Txij li thaum Excel 2011, lub hnub yug lub hnub yog lub 1900 hnub system uas guarantees hnub compatibility nrog Excel rau lub qhov rais.
- Rau Excel 2008 thiab ua ntej versions ntawm Excel (Macintosh), lub hnub tim pib nruab rau lub Ib Hlis 1, 1904, thiab raug xa mus rau xyoo 1904 .
Tag nrho versions of Excel txhawb ob lub hnub nruab hnub thiab kev hloov ntawm ib qho mus rau ib qho yog yooj yim ua tau siv cov kev pab cuam cov kev xaiv.
Teeb Zauv Cov Zauv
Nyob rau hauv xyoo 1900, tus naj npawb 1 yog lub 1 Hlis Ntuj hnub tim 1, 1900, 12:00 teev sawv ntxov thaum tus naj npawb 0 yog lub hnub tim khawv ntawm Lub Ib Hlis Ntuj 0, 1900.
Nyob rau xyoo 1904, cov naj npawb 1 yog lub Ib Hlis 2, 1904, thaum tus naj npawb 0 qhia txog Lub Ib Hlis 1, 1904, 12:00:00
Lub sij hawm khaws cia ua Decimals
Cov sij hawm hauv ob qho tib si teev cia ua zauv zauv ntawm 0.0 thiab 0.99999, nyob qhov twg
- 0.0 yog 00:00:00 (teev: feeb: feeb);
- 0.5 yog 12:00 teev (12 pm);
- 0.99999 yog 23:59:59.
Qhia cov hnub thiab sijhawm nyob hauv tib lub xov tooj hauv ib daim ntawv ua haujlwm, muab cov zauv thiab cov zauv ntawm ib tug zauv.
Piv txwv li, thaum xyoo 1900, 12 teev tsaus ntuj thaum Lub Ib Hlis 1, 2016, yog tus xov tooj 42370.5 vim nws yog 42370 thiab ib nrab hnub (lub sij hawm muab khaws cia ua ib hnub tag nrho) tom qab Lub Ib Hlis 1, 1900.
Ib yam li ntawd, nyob rau xyoo 1904, tus xov tooj 40908.5 sawv cev 12 teev tsaus ntuj rau Lub Ib Hlis 1, 2016.
Cov Zauv Siv Siv
Ntau, yog tias tsis yog feem ntau, cov haujlwm uas siv Excel rau cov ntaub ntawv cia thiab cov laij leb, siv cov hnub thiab lub sijhawm ua qee txoj kev. Piv txwv li:
- Lub sij hawm ntev yuav tau suav cov hnub ntawm hnub tam sim no thiab yav dhau los lossis txiav txim siab txog hnub uas muaj ntau hnub tom ntej siv cov kev khiav haujlwm xws li NETWORKDAYS thiab EDATE
- Timesheets xam lub sij hawm pib ntawm thiab pib thiab xaus lub sijhawm, thiab cov sijhawm, ntxiv sijhawm raws li tsim nyog siv cov qauv uas ntxiv lossis rho cov hnub thiab sijhawm.
- Lub sijhawm thwj cim ib daim ntawv nrog lub hnub thiab lub sijhawm tam sim no yuav ua tau nrog cov keyboard shortcuts uas nyeem cov xov tooj tam sim no .
Tshaj tawm cov hnub tso tawm thiab / los yog lub sijhawm twg thaum twg daim ntawv khom nqi tau qhib lossis rov los nrog lub TAU thiab TODAY cov haujlwm.
Vim Li Cas Hnub Nruab Hnub?
Luv luv, PC versions ntawm Excel ( Qhov rais thiab DOS operating systems), pib siv 1900 lub hnub nruab rau kev xav ntawm kev sib haum xeeb nrog Lotus 1-2-3 , feem ntau tshaj tawm spreadsheet kev pab cuam thaum lub sij hawm.
Qhov teeb meem nrog qhov no yog tias thaum Lotus 1-2-3 tau tsim, xyoo 1900 tau muab tso rau hauv li ntawm leap xyoo, thaum qhov tseeb nws tsis yog. Yog li ntawd, cov kauj ruam ntxiv ntawm qhov programming yuav tsum tau coj los kho qhov yuam kev.
Tam sim no versions ntawm Excel khaws lub 1900 hnub system rau lub hom phiaj ntawm kev sib haum nrog cov ntawv khom nqi tau tsim nyob rau hauv dhau los versions ntawm qhov kev pab cuam.
Txij li thaum tsis muaj Macintosh version ntawm Lotus 1-2-3 , thawj lub versions ntawm Excel rau Macintosh tsis xav tau kev txhawj xeeb nrog cov teeb meem sib haum xeeb thiab lub xyoo 1904 tau raug xaiv kom tsis txhob muaj cov teeb meem programming cuam tshuam txog 1900 cov teeb meem tsis xaus xyoo.
Ntawm qhov tod tes, nws puas tau tsim ib qhov teeb meem sib nrauj ntawm daim ntawv khom nqi hauv Excel rau Qhov Rai thiab Excel rau Mac, uas yog vim li cas tag nrho cov tshiab versions ntawm Excel siv 1900 hnub system.
Hloov Lub Hnub Tim Xyooj
Lus Cim : Tsuas pub siv ib hnub xwb uas yuav siv tau rau ib phau ntawv sau ua haujlwm. Yog tias lub sijhawm ua haujlwm rau ib phau ntawv uas dhau los muaj cov hnub hloov, cov hnub hloov plaub lub xyoo thiab ib hnub vim lub sijhawm sib txawv nruab nrab ntawm ob lub hnub nruab nrab saum toj no.
Txhim kho hnub tim rau ib phau ntawv hauv Excel 2010 thiab tom qab ntawd:
- Qhib lossis hloov mus rau phau ntawv workbook los hloov;
- Nias rau ntawm cov ntaub ntawv tab qhib cov ntaub ntawv qhia zaub mov;
- Nias ntawm kev xaiv hauv cov ntawv qhia zaub mov qhib lub Excel xaiv dialog box ,
- Nias rau qhov Advanced hauv vaj huam sib luag ntawm lub thawv sab laug;
- Nyob rau hauv Thaum xam xyuas cov lus hauv phau ntawv no ntawm sab tes tuav, xaiv los yog tshem tawm Tus Siv 1904 hnub kos khij;
- Nias qhov sau kom kaw lub thawv ntawv thiab rov qab los rau hauv phau ntawv.
Txhim kho hnub tim rau ib phau ntawv hauv Excel 2007:
- Qhib lossis hloov mus rau phau ntawv workbook los hloov;
- Ndliv qhov Office Button qhib lub Office Office ;
- Nias ntawm kev xaiv hauv cov ntawv qhia zaub mov qhib lub Excel Options dialog box;
- Nias rau qhov Advanced hauv vaj huam sib luag ntawm lub thawv sab laug;
- Nyob rau hauv Thaum xam xyuas cov lus hauv phau ntawv no ntawm sab tes tuav, xaiv los yog tshem tawm Tus Siv 1904 hnub kos khij;
- Nias qhov sau kom kaw lub thawv ntawv thiab rov qab los rau hauv phau ntawv.