{"id":6989,"date":"2025-12-25T13:47:36","date_gmt":"2025-12-25T06:47:36","guid":{"rendered":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/?p=6989"},"modified":"2025-12-25T13:47:36","modified_gmt":"2025-12-25T06:47:36","slug":"huong-dan-su-dung-excel-365-chi-tiet","status":"publish","type":"post","link":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/huong-dan-su-dung-excel-365-chi-tiet\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Excel 365 chi ti\u1ebft"},"content":{"rendered":"

H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Excel 365 c\u01a1 b\u1ea3n cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u<\/strong><\/h2>\n

Sau khi \u0111\u00e3 \u0111\u0103ng k\u00fd t\u00e0i kho\u1ea3n Excel Microsoft 365 th\u00e0nh c\u00f4ng, \u0111\u1ec3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o v\u00e0 \u0111em l\u1ea1i hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c t\u1ed1t nh\u1ea5t ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 tham kh\u1ea3o h\u01b0\u1edbng d\u1eabn chi ti\u1ebft d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

<\/span>C\u00e1ch t\u1ea1o c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c m\u1edbi<\/h3>\n

Sau khi \u0111\u00e3 \u0111\u0103ng nh\u1eadp Microsoft 365 Excel th\u00e0nh c\u00f4ng, ng\u01b0\u1eddi d\u00f9ng s\u1ebd ti\u1ebfn h\u00e0nh m\u1edf \u1ee9ng d\u1ee5ng Excel tr\u00ean m\u00e1y t\u00ednh. Khi \u0111\u00f3 giao di\u1ec7n m\u00e0n h\u00ecnh s\u1ebd xu\u1ea5t hi\u1ec7n, \u0111\u1ec3 t\u1ea1o c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c m\u1edbi ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 click tr\u1ef1c ti\u1ebfp v\u00e0o\u00a0S\u1ed5 l\u00e0m vi\u1ec7c tr\u1ed1ng<\/b>\u00a0ho\u1eb7c click ch\u1ecdn\u00a0M\u1edbi<\/b>.<\/p>\n

\"\"<\/p>\n

Ngo\u00e0i ra, khi \u0111ang th\u1ef1c hi\u1ec7n m\u1ed9t b\u1ea3ng t\u00ednh dang d\u1edf m\u00e0 ng\u01b0\u1eddi d\u00f9ng mu\u1ed1n t\u1ea1o m\u1ed9t c\u1eeda s\u1ed5 m\u1edbi l\u00e0m vi\u1ec7c c\u00f3 th\u1ec3 click ch\u1ecdn\u00a0T\u1ec7p<\/b>\u00a0>> ti\u1ebfp \u0111\u1ebfn ch\u1ecdn\u00a0M\u1edbi\u00a0<\/b>>> sau \u0111\u00f3 ch\u1ecdn Trang t\u00ednh tr\u1ed1ng \u0111\u1ec3 b\u1eaft \u0111\u1ea7u.<\/p>\n

<\/span>C\u00e1ch t\u1ea1o b\u1ea3ng<\/h3>\n

T\u1ea1o b\u1ea3ng trong Excel 365 l\u00e0 m\u1ed9t trong nh\u1eefng vi\u1ec7c c\u1ef1c k\u1ef3 \u0111\u01a1n gi\u1ea3n m\u00e0 b\u1ea5t c\u1ee9 ng\u01b0\u1eddi d\u00f9ng n\u00e0o c\u0169ng \u0111\u1ec1u c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c.<\/p>\n

Click ch\u1ecdn\u00a0Ch\u00e8n<\/b>\u00a0>> ti\u1ebfp \u0111\u1ebfn ch\u1ecdn\u00a0B\u1ea3ng<\/b>\u00a0>> \u0111i\u1ec1n d\u1eef li\u1ec7u \u00f4 ho\u1eb7c h\u00e0ng\u00a0 mu\u1ed1n t\u1ea1o b\u1ea3ng sau \u0111\u00f3 click ch\u1ecdn\u00a0OK<\/b>.<\/p>\n

\"\"<\/p>\n

C\u00e1ch t\u1ea1o bi\u1ec3u \u0111\u1ed3<\/h3>\n

Sau khi \u0111\u00e3 t\u1ea1o b\u1ea3ng v\u1edbi d\u1eef li\u1ec7u th\u00e0nh c\u00f4ng, ng\u01b0\u1eddi d\u00f9ng m\u1edbi c\u00f3 th\u1ec3 t\u1ea1o bi\u1ec3u \u0111\u1ed3. T\u01b0\u01a1ng t\u1ef1 nh\u01b0 c\u00e1c t\u1ea1o b\u1ea3ng, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 t\u1ea1o bi\u1ec3u \u0111\u1ed3 trong Excel 365 v\u1edbi c\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n c\u01a1 b\u1ea3n nh\u01b0:<\/p>\n

Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u mu\u1ed1n t\u1ea1o bi\u1ec3u \u0111\u1ed3, click ch\u1ecdn\u00a0Ch\u00e8n<\/b>\u00a0>> ti\u1ebfp \u0111\u1ebfn ch\u1ecdn bi\u1ec3u \u0111\u1ed3, t\u1ea1i \u0111\u00e2y ch\u1ecdn c\u00e1c d\u1ea1ng bi\u1ec3u \u0111\u1ed3 m\u00e0 b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng nh\u01b0 bi\u1ec3u \u0111\u1ed3 tr\u00f2n, bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1eddng, bi\u1ec3u \u0111\u1ed3 c\u1ed9t\u2026<\/p>\n

\"\"<\/p>\n

\u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u<\/h3>\n

Ri\u00eang v\u1edbi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong Excel 365, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n thi\u1ebft l\u1eadp \u0111\u1ecbnh d\u1ea1ng \u0111\u1ec3 ph\u00e2n bi\u1ec7t r\u00f5 r\u00e0ng v\u00e0 \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c trong qu\u00e1 tr\u00ecnh th\u1ef1c hi\u1ec7n.<\/p>\n

Click ch\u1ecdn \u00f4 ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u m\u00e0 ng\u01b0\u1eddi d\u00f9ng c\u1ea7n \u0111\u1ecbnh d\u1ea1ng sau \u0111\u00f3 click ch\u1ecdn\u00a0Chung<\/b>. Ti\u1ebfp \u0111\u1ebfn ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u ph\u00f9 h\u1ee3p nh\u01b0 s\u1ed1, ti\u1ec1n t\u1ec7, k\u1ebf to\u00e1n, ng\u00e0y, th\u1eddi gian\u2026<\/p>\n

\"\"<\/p>\n

S\u1eed d\u1ee5ng h\u00e0m t\u00ednh<\/h3>\n

Trong ph\u1ea7n m\u1ec1m Excel 365 \u0111\u00e3 \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp s\u1eb5n c\u00e1c h\u00e0m t\u00ednh t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao \u0111\u1ec3 ng\u01b0\u1eddi d\u00f9ng s\u1eed d\u1ee5ng. Do \u0111\u00f3, sau khi \u0111\u00e3 t\u1ea1o b\u1ea3ng v\u00e0 \u0111i\u1ec1n \u0111\u1ea7y \u0111\u1ee7 th\u00f4ng tin d\u1eef li\u1ec7u v\u00e0o c\u00e1c \u00f4 ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 d\u00f9ng c\u00e1c h\u00e0m b\u1eb1ng c\u00e1ch \u0111i\u1ec1n v\u00e0o \u00f4 tr\u1ed1ng \u201c=ch\u1ecdn h\u00e0m mong mu\u1ed1n\u201d.<\/p>\n

M\u1ed9t v\u00e0i c\u00e1c h\u00e0m c\u01a1 b\u1ea3n m\u00e0 ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 tham kh\u1ea3o nh\u01b0:<\/p>\n

    \n
  • H\u00e0m SUM t\u00ednh t\u1ed5ng<\/li>\n
  • H\u00e0m AVERAGE t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh<\/li>\n
  • H\u00e0m COUNT \u0111\u1ec3 \u0111\u1ebfm<\/li>\n
  • H\u00e0m IF n\u1ebfu<\/li>\n
  • H\u00e0m MAX v\u00e0 MIN \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t v\u00e0 nh\u1ecf nh\u1ea5t trong b\u1ea3ng t\u00ednh<\/li>\n<\/ul>\n

    Tr\u00ean \u0111\u00e2y l\u00e0 nh\u1eefng th\u00f4ng tin chi ti\u1ebft v\u1ec1 c\u00e1ch d\u00f9ng excel 365 c\u01a1 b\u1ea3n m\u00e0 ch\u00fang t\u00f4i mu\u1ed1n mang \u0111\u1ebfn cho b\u1ea1n. Hy v\u1ecdng r\u1eb1ng v\u1edbi nh\u1eefng h\u01b0\u1edbng d\u1eabn excel c\u01a1 b\u1ea3n n\u00e0y b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m vi\u1ec7c m\u01b0\u1ee3t m\u00e0 nh\u1ea5t v\u1edbi Excel Microsoft 365.<\/p>\n

     <\/p>\n","protected":false},"excerpt":{"rendered":"

    H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Excel 365 c\u01a1 b\u1ea3n cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u Sau khi \u0111\u00e3 \u0111\u0103ng k\u00fd t\u00e0i kho\u1ea3n<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/posts\/6989"}],"collection":[{"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/comments?post=6989"}],"version-history":[{"count":5,"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/posts\/6989\/revisions"}],"predecessor-version":[{"id":7020,"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/posts\/6989\/revisions\/7020"}],"wp:attachment":[{"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/media?parent=6989"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/categories?post=6989"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/tags?post=6989"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}