Excel 2010
1
Các hàm trong excel
e. Danh mục các Các Hàm Quản lý Cơ sở dữ liệu và Danh
sách
 trong mt ct ca
 ca m d liu, theo mu kic ch nh.
a s liu trong mt ct ca
 ca m d liu, theo mu kic ch nh.
DCOUNTA (database, field, crng" trong mt ct ca
 ca m d liu, theo mu kic ch nh.
 t mt ct ca m
 d liu, khp vu kic ch nh.
DMAX (database, field, criteria) : Tr v tr ln nht trong mt ct ca mt danh
a m d liu, theo mu kic ch nh.
DMIN (database, field, criteria) : Tr v tr nh nht trong mt ct ca mt danh
a mt  d liu, theo mu kic ch nh.
Excel 2010
2
 trong mt ct ca mt danh
a m d liu, theo mu kic ch nh.
 lch chun ca mt tp hp
theo mu, b d liu trong mt ct ca ma
m d liu, theo mu kic ch nh.
 lch chun ca mt tp hp theo

u ki t c ho phn
u kit m
u kit s  v  nhp
u kin  
I GIAN
Mt s  di gian trong Excel:
Excel h tr 
u t  u t c
din gii theo h 
H th Excel ph thut lp trong Regional Options ca
Control Panel. M thng ca M n
 sa l th
Khi bn nhp m p l  tr t chu
bc tham chiu t  tr v li.
=NOW() Cho hi ca h thng
Excel 2010
4
a h thng
 a D (Tr v th t c m
ki
=MONTH(D) C a D
 a D
 a 2 m mt

=EDATE Tr v mc thi gian xc hoc sau mc ch nh
=EOMONTH Tr v c hoc sau mc ch nh
HOUR()

second: S ch t con s t n 59. Nu l 
  gi ng.
:
TIME(14, 45, 30) = 2:45:30 PM
TIME(14, 65, 30) = 3:05:30 PM
TIME(25, 85, 75) = 2:26:15 AM
Excel 2010
6
t hu dng
t con s 

TIMEVALUE()
Chuyi mt chung th th 
th c
 = TIMEVALUE(time_text)
time_text: Chun cn chuyi
:
TIMEVALUE("26:15") = 0.09375 (= 2:15:00 AM)
=WEEKDAY Tr v s th t cn t  
=WEEKNUM Tr v s th t ca tu  
=WORKDAY Tr v c xc hoc sau mc th
c hc hn chuyn vi
ct ht my pha m, m ht 6 ti
y m ht 25% (hic) thi gian...
Hoc m vitheo 
vi tr  vic?
  l ca mt khong thi gian trong m

Excel 2010
8
Gng hvii gian s c t 
ng nhau.
 n chuy thng
k  m

 = DAYS360(start_date, end_date [, method])
i dia
khong thi gian cp bt kt
qu tr v ca m s xy ra li nu bn nhp trc tip
i dng text.
method: M  ch 
hay theo kiu M.
* FALSE: (hou M: N
c
c a
 tip.
 start_date ho
a mng s 
:  ch giu mt

DAYS360("01/01/2008", "31/5/2008") = 150
DAYS360("01/01/2008", "31/5/2008", TRUE) = 149
Excel 2010