Cov txheej txheem:

Kuv yuav taug qab cov sij hawm them nqi hauv Excel li cas?
Kuv yuav taug qab cov sij hawm them nqi hauv Excel li cas?

Video: Kuv yuav taug qab cov sij hawm them nqi hauv Excel li cas?

Video: Kuv yuav taug qab cov sij hawm them nqi hauv Excel li cas?
Video: Data Science with Python! Filtering Data with pandas 2024, Kaum ib hlis
Anonim

Koj tuaj yeem siv ib qho Excel spreadsheet khaws cia taug qab ntawm koj cov sij hawm them nqi : Tsuas sau lub sij hawm pib hauv ib kab, lub sij hawm kawg hauv kab thib ob thiab rho tawm thawj zaug ntawm qhov thib ob.

Tsis tas li ntawd, kuv yuav xam cov sij hawm them nqi hauv Excel li cas?

Txoj Kev Pain-Free Add Up The Billable Teev

  1. Format lub sij hawm raws li nram no:
  2. Siv cov qauv hauv qab no los xam qhov ntev ntawm lub sijhawm, hauv feeb, ntawm txhua lub sijhawm siv rau qhov teeb meem:
  3. Excel ua rau ib feem ntawm ib hnub thaum nws ua qhov kev suav no - cov qauv sib npaug los ntawm 1440 kom tig mus rau hauv feeb.

Tsis tas li, koj taug qab sijhawm hauv Excel li cas? Qhib cov ntaub ntawv validation rau lub cell raws li hauv qab no:

  1. Xaiv cell B2.
  2. Los ntawm cov ntawv qhia zaub mov, xaiv Validation.
  3. Ntawm qhov chaw tab, xaiv Hnub los ntawm Daim Ntawv Tso Cai Tso Npe.
  4. Xaiv ntau dua los ntawm cov ntaub ntawv teev npe.
  5. Nkag mus rau 1/1/1900 hauv Hnub Pib Hnub, raws li qhia hauv daim duab O, thiab nyem OK.

Tom qab ntawd, ua li cas koj khaws cov sij hawm them nqi?

Nov yog tsib kauj ruam yooj yim kom taug qab koj lub sijhawm them nqi

  1. Muaj System. Txiav txim siab thaum pib koj puas yog daim ntawv lossis hom digital?
  2. Ua siab tawv.
  3. Ua piav qhia.
  4. Siv ib qho App.
  5. Sau Koj Sijhawm.

Yuav ua li cas koj xam tag nrho cov sij hawm ua hauj lwm hauv ib hlis hauv Excel?

  1. Xam tag nrho cov sij hawm ua hauj lwm hauv ib lub hlis nrog cov qauv.
  2. Nkag mus rau cov qauv no: =NETWORKDAYS(A2, B2) * 8 mus rau hauv ib lub xovtooj dawb uas koj xav muab cov txiaj ntsig, thiab tom qab ntawd nias Enter, thiab koj yuav tau txais hnub tim hom cell raws li hauv qab no screenshot qhia:

Pom zoo: