16 h??m Excel ????n gi???n ng?????i s??? d???ng ??i???n th??ch n??i v??? 16 h??m??Excel m???nh m??? v?? tuy???t v???i??nh?? th??? n??o??, nh???ng g?? c?? Pivot Table, c??c c??ng th???c l???ng nhau v????logic Boolean??. D?????i ????y l?? 16 h??m Excel ????n gi???n v?? t??nh n??ng hay c???a Excel, s??? gi??p b???n ti???t ki???m r???t nhi???u th???i gian.

N???u b???n l?? m???t ph???n c???a Excel 99 ph???n tr??m, d?????i ????y l?? 16 h??m Excel ti???n d???ng m?? s??? gi??p b???n c?? ???????c t???t tr??n con ???????ng c???a b???n ????? l??m ch??? b???ng t??nh.

16 h??m Excel ????n gi???n nh??ng r???t c???n thi???t cho ng?????i hay d??ng Excel:

= SUM ()

H??m ?????u ti??n m?? b???t k??? ai n??n bi???t ?????u cho Excel bi???t ????? th???c hi???n s??? h???c c?? b???n.??Gi??? s??? b???n mu???n c??c s??? trong ?? A2 v?? ?? B2 ???????c th??m v??o c??ng nhau trong ?? C2.??T???t c??? nh???ng g?? b???n c???n l??m l?? nh???p??=SUM(A2:B2)??v??o C2, sau ???? nh???n??Enter.????Ngay l???p t???c b???n s??? th???y t???ng c???a hai ?? xu???t hi???n.

B???n c?? th??? s??? d???ng h??m n??y v?? h???u h???t c??c h??m ???????c li???t k?? ??? ????y, ????? bao g???m nhi???u ?? nh?? b???n y??u c???u.??B???n c??ng c?? th??? ch???n ch??ng v???i con chu???t c???a b???n, nh??ng t??i t??m th???y n?? d??? d??ng h??n nhi???u ????? g?? v??o m???t lo???t c??c t??? b??o.

= AVERAGE ()

Trung b??nh th???c hi???n ch??nh x??c nh???ng g?? n?? n??i v?? ho???t ?????ng t????ng t??? nh?? SUM.??N???u b???n c?? m???t trang t??nh c?? thu nh???p h??ng th??ng c???a b???n trong n??m qua trong c??c c???t t??? A2 ?????n A13, h??y nh???p????=AVERAGE(A2:A13)??v??o A14 ????? nh???n ???????c m???c trung b??nh c???a t???t c??? thu nh???p h??ng th??ng.

M???t l???n n???a, b???n c??ng c?? th??? s??? d???ng con tr??? chu???t c???a m??nh ????? nh???p v?? k??o l??m n???i b???t m???t d???i ?? ho???c s??? d???ng????Control + Nh???p????????? t??ch t???ng ??.

= MEDIAN ()

Trung b??nh v?? trung b??nh th?????ng b??? nh???m l???n, nh??ng ch??ng kh??ng gi???ng nhau.??C??c trung b??nh c?? m???t nh??m c??c s??? nh?? (trong v?? d??? c???a ch??ng t??i d?????i ????y) 2, 6, 15, 31, v?? 56, v?? t??m ra ??i???m gi???a c???a nh??m.??N??i c??ch kh??c, m???t n???a s??? n???m tr??n trung v???, v?? m???t n???a ??? d?????i.??Ch??ng t??i ???? so s??nh m???c trung b??nh v???i m???c trung b??nh trong ???nh ch???p m??n h??nh ????? cho b???n th???y s??? kh??c bi???t.

????? c?? ???????c trung v??? cho nh??m tr??n trong c???t E, trong ?? E7 ch??ng ta ???? g?? c??ng th???c????=MEDIAN(E2:C6) and??nh???n??Enter??.??Trong tr?????ng h???p v?? d??? c???a ch??ng t??i, trung v??? l?? 15. ???? c?? m???t s??? ch???n s??? trong chu???i, trung v??? s??? l?? trung ??i???m gi???a hai s??? gi???a.

= MIN ()

N???u b???n c???n t??m s??? nh??? nh???t trong m???t d???i ??, h??m MIN c?? th??? gi??p b???n th???c hi???n ??i???u ????.??Vi???c s??? d???ng????=MIN(B3:B39)??s??? cung c???p cho b???n s??? l?????ng nh??? nh???t c?? trong c??c ?? ????.

= MAX ()

Max l?? ?????i t??c c???a MIN v?? ng?????c l???i cho b???n bi???t s??? l???n nh???t ch???a trong m???t d???i ??.

= TRIM ()

N???u b???n sao ch??p v??n b???n t??? m???t ch????ng tr??nh kh??c v??o Excel, b???n th?????ng c?? th??? k???t th??c v???i kho???ng tr???ng d?? th???a l??m cho b???ng t??nh c???a b???n tr??? th??nh m???t tr???i nghi???m h??nh ???nh.??TRIM c?? th??? gi??p b???n l??m s???ch n??.

TRIM ch??? c?? th??? x??? l?? v??n b???n t??? m???t ?? ????n l???.??V?? v???y, h??y b???t ?????u b???ng c??ch d???n d???p v??n b???n trong ?? B1 b???ng c??ch g??????=TRIM(B1)??v??o ?? C1, v?? d???.??K???t qu??? s??? ???????c l??m s???ch v??n b???n trong ?? C1.??L???p l???i ch???c n??ng cho b???t k??? ?? n??o kh??c m?? b???n c???n d???n d???p.

N???u b???n mu???n d???n d???p c??c ng???t d??ng, h??y th??? CLEAN thay v?? TRIM.

= COUNT ()

N???u b???n c???n bi???t c?? bao nhi??u ?? trong m???t ph???m vi nh???t ?????nh ch???a s???, ?????ng b???n t??m ?????m b???ng tay ??? ch??? c???n s??? d???ng h??m COUNT.??V?? d???: n???u b???n c?? k???t h???p c??c s??? v?? v??n b???n trong ?? A21-A50, h??y nh???p v??o ?? A51??=COUNT(A21:50)v?? b???n s??? kh??ng c?? c??u tr??? l???i trong th???i gian ng???n.

H??m COUNT c???a 16 h??m Excel c?? th??? cho b???n bi???t s??? l?????ng ?? trong chu???i ch???a s??? thay v?? t???, ng??y th??ng ho???c c??c lo???i m???c nh???p kh??c.????i???u n??y c?? th??? h???u ??ch khi b???n ??ang qu???n l?? m???t b???ng t??nh ph???c t???p.

= COUNTA ()

T????ng t??? nh?? v?? d??? tr??n, b???n c?? th??? s??? d???ng??=COUNTA()????? ?????m s??? l?????ng ?? trong m???t ph???m vi nh???t ?????nh ch???a c??c k?? t??? nh?? s???, v??n b???n ho???c k?? hi???u, c??ng nh?? c??c gi?? tr??? l???i.

= LEN ()

N???u b???n mu???n ?????m s??? k?? t??? trong m???t ??, bao g???m c??? kho???ng tr???ng, h??y ki???m tra LEN.??B???n mu???n bi???t c?? bao nhi??u k?? t??? trong ?? A1???Ch??? c???n g????=LEN(A1)v??o m???t ?? kh??c v?? b???n s??? t??m ra.

= CONCATENATE ()

??i???u n??y l???y d??? li???u t??? hai ?? v?? bi???n n?? th??nh m???t.??Ki???m tra??c??i nh??n tr?????cc???a ch??ng ta v?????c??c h??m Excel??????? xem n?? c?? th??? h???u ??ch nh?? th??? n??o.

= DAYS ()

B???n mu???n bi???t s??? ng??y gi???a hai ng??y trong b???ng t??nh???V?? d???: n???u b???n c?? v?? d???, ng??y 5 th??ng 9 n??m 2018 trong ?? A4 v?? 27 th??ng 12 n??m 2018 trong A5 ch??? s??? d???ng??=DAYS(A5, A4)????? nh???n ???????c c??u tr??? l???i d?????i d???ng s??? ??m – th?? vi???c ?????o ng?????c th??? t??? c???a c??c ?? s??? cho b???n m???t s??? d????ng.

= NETWORKDAYS ()

T??nh to??n c??c ng??y trong tu???n v??o n??m 2019.

Bi???t s??? ng??y l?? tuy???t v???i, nh??ng n???u b???n c???n bi???t c?? bao nhi??u ng??y trong tu???n bao g???m, h??y chuy???n sang NETWORKDAYS (???? l?? ‘ng??y l??m vi???c th???c t???’) thay th???.??H??m n??y s??? d???ng c??ng m???t ?????nh d???ng nh?? DAYS, nh??ng b???n c???n s??? d???ng th??? t??? t??ng d???n ????? c?? s??? kh??ng ??m.??V?? v???y,??=NETWORKDAYS(A4, A5)s??? cung c???p cho b???n 80 v?? kh??ng -80.

= SQRT ()

B???n c???n bi???t c??n b???c hai c???a 1764???G????=SQRT(1764)v??o m???t ??, nh???n??Enter??, v?? b???n s??? t??m th???y c??u tr??? l???i cho cu???c s???ng, v?? tr???, v?? t???t c??? m???i th???, bao g???m c??? v?? d??? c??ng th???c.

= NGAY ()

B???n mu???n xem ng??y gi??? hi???n t???i b???t c??? khi n??o b???n m??? m???t trang t??nh c??? th??????Nh???p =??NOW()v??o ?? n??i b???n mu???n ng??y v?? b???n ???? ho??n t???t.??N???u b???n mu???n xem m???t ng??y trong t????ng lai t??? b??y gi???, b???n c?? th??? s??? d???ng m???t c??i g?? ???? nh?? th??? n??o??=NOW()+32.??H??m b??y gi??? kh??ng l???y b???t k??? ?????i s??? n??o, v?? v???y ?????ng ?????t b???t k??? th??? g?? v??o gi???a c??c d???u ngo???c vu??ng.

= ROUND ()

Nh?? t??n g???i c???a n??, h??m n??y cho ph??p b???n l??m tr??n s???.??ROUND y??u c???u hai ?????i s???: m???t s??? ho???c ?? v?? s??? ch??? s??? ????? l??m tr??n.??N???u b???n c?? s??? 231.852645 trong A1, v?? d???,??=ROUND(A1, 0)cung c???p cho b???n 232,??=ROUND(A1, 1)cung c???p cho b???n 232,9 v????=ROUND(A1, -1)tr??? v??? 230.

= ROUNDUP (), = ROUNDDOWN ()

N???u b???n mu???n ki???m so??t tr???c ti???p h??n tr??n l??m tr??n l??n ho???c xu???ng c?? ch???c n??ng cho ??i???u ???? qu??.??ROUNDUP v?? ROUNDDOWN s??? d???ng ch??nh x??c ?????nh d???ng ?????i s??? gi???ng nh?? ROUND.??????? t??m hi???u th??m v??? v??ng v?? c??c ?????i t??c c???a n??, h??y xem??c??c trang h??? tr??? c???a Microsoft??.