{"id":7496,"date":"2021-08-11T14:56:25","date_gmt":"2021-08-11T07:56:25","guid":{"rendered":"https:\/\/tct.vn\/blog\/?p=7496"},"modified":"2021-08-18T11:08:34","modified_gmt":"2021-08-18T04:08:34","slug":"thu-thuat-excel-cuc-ky-huu-ich-phan-1","status":"publish","type":"post","link":"https:\/\/tct.vn\/blog\/thu-thuat-excel-cuc-ky-huu-ich-phan-1\/","title":{"rendered":"Th\u1ee7 thu\u1eadt Excel c\u1ef1c k\u1ef3 h\u1eefu \u00edch (Ph\u1ea7n 1)"},"content":{"rendered":"

K\u1ef9 n\u0103ng s\u1eed d\u1ee5ng Excel m\u1ed9t c\u00e1ch th\u00e0nh th\u1ea1o v\u00e0 n\u1eafm \u0111\u01b0\u1ee3c c\u00e1c th\u1ee7 thu\u1eadt Excel s\u1ebd gi\u00fap \u00edch r\u1ea5t nhi\u1ec1u cho\u00a0b\u1ea1n. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1\u00a0th\u1ee7 thu\u1eadt Excel c\u1ef1c k\u1ef3 h\u1eefu \u00edch, gi\u00fap b\u1ea1n ng\u00e0y c\u00e0ng tr\u1edf n\u00ean chuy\u00ean nghi\u1ec7p h\u01a1n.<\/strong><\/p>\n

<\/a>S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Flash Fill \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n d\u1eef li\u1ec7u trong nh\u00e1y m\u1eaft.<\/h2>\n

\"\"<\/p>\n

\u0110i\u1ec3m th\u00f4ng minh c\u1ee7a t\u00ednh n\u0103ng n\u00e0y l\u00e0 b\u1ea1n c\u00f3 th\u1ec3 xem tr\u01b0\u1edbc \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp d\u1eef li\u1ec7u v\u00e0o c\u1ed9t theo \u0111\u00fang quy lu\u1eadt. Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang t\u00f4i \u0111\u00e3 nh\u1eadp\u00a0Smith<\/em>, r\u1ed3i nh\u1eadp\u00a0North<\/em>. Excel khi \u0111\u00f3 s\u1ebd \u0111\u01b0a ra \u0111\u1ec1 xu\u1ea5t cho c\u00e1c \u00f4 c\u00f2n l\u1ea1i. N\u1ebfu d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c \u0111i\u1ec1n v\u00e0o \u0111\u00e3 ph\u00f9 h\u1ee3p v\u1edbi \u00fd c\u1ee7a b\u1ea1n, h\u00e3y nh\u1ea5n Enter v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 ti\u1ebfp t\u1ee5c.<\/p>\n

\n

<\/a>T\u00ednh t\u1ed5ng m\u00e0 kh\u00f4ng c\u1ea7n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c<\/h2>\n

\u0110\u00e2y l\u00e0 m\u1ed9t m\u1eb9o h\u1eefu \u00edch cho b\u1ea3ng: Th\u00eam H\u00e0ng T\u1ed5ng m\u00e0 kh\u00f4ng c\u1ea7n vi\u1ebft c\u00f4ng th\u1ee9c. Ch\u1ec9 c\u1ea7n b\u1ea5m v\u00e0o v\u1ecb tr\u00ed b\u1ea5t k\u1ef3 b\u00ean trong b\u1ea3ng Excel. Sau \u0111\u00f3, nh\u1ea5n\u00a0Ctrl+Shift+T<\/strong>\u00a0v\u00e0 Excel s\u1ebd th\u00eam H\u00e0ng T\u1ed5ng v\u00e0o d\u01b0\u1edbi c\u00f9ng<\/p>\n

\"\"<\/p>\n

\n

<\/a>Bi\u1ebfn v\u00f9ng d\u1eef li\u1ec7u th\u00e0nh b\u1ea3ng gi\u00fap n\u1ed5i b\u1eadt d\u1eef li\u1ec7u hi\u1ec7n c\u00f3<\/h2>\n

B\u1ea1n mu\u1ed1n bi\u1ebfn c\u00e1c \u00f4 d\u1eef li\u1ec7u g\u1ed1c b\u00ecnh th\u01b0\u1eddng th\u00e0nh m\u1ed9t b\u1ea3ng Excel ch\u00ednh th\u1ee9c? B\u1ea5m v\u00e0o b\u1ea5t c\u1ee9 \u0111\u00e2u b\u00ean trong d\u1eef li\u1ec7u, r\u1ed3i nh\u1ea5n\u00a0Ctrl+T<\/strong>.<\/p>\n

B\u1ea3ng cung c\u1ea5p t\u1ea5t c\u1ea3 c\u00e1c ch\u1ee9c n\u0103ng h\u1eefu \u00edch, t\u00f4 m\u00e0u c\u00e1c d\u00f2ng v\u00e0 th\u00eam n\u00fat Filter. Ngo\u00e0i ra, b\u1ea3ng c\u0169ng tr\u00f4ng \u0111\u1eb9p h\u01a1n.<\/p>\n

\"\"<\/p>\n

\n

<\/a>T\u00ecm ki\u1ebfm ch\u1ee9c n\u0103ng, h\u00e3y s\u1eed d\u1ee5ng Tell me!<\/h2>\n

B\u1ea1n \u0111\u00e3 s\u1eed d\u1ee5ng m\u1ed9t t\u00ednh n\u0103ng Excel nh\u1ea5t \u0111\u1ecbnh tr\u01b0\u1edbc \u0111\u00e2y … nh\u01b0ng b\u1ea1n kh\u00f4ng th\u1ec3 nh\u1edb n\u00f3 \u1edf \u0111\u00e2u. Kh\u00f4ng v\u1ea5n \u0111\u1ec1 g\u00ec, Tell Me c\u00f3 th\u1ec3 gi\u00fap!<\/p>\n

Ch\u1ec9 c\u1ea7n nh\u1ea5p v\u00e0o h\u1ed9p c\u00f3 nh\u00e3n H\u00e3y cho t\u00f4i bi\u1ebft b\u1ea1n mu\u1ed1n l\u00e0m g\u00ec (Ask me) v\u00e0 b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm m\u1ed9t n\u00fat, menu, ch\u1ee9c n\u0103ng, b\u1ea5t c\u1ee9 \u0111i\u1ec1u g\u00ec b\u1ea1n mu\u1ed1n. Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang t\u00f4i \u0111\u00e3 t\u00ecm ki\u1ebfm “Freeze Panes” \u0111\u1ec3 t\u00ecm n\u00fat cho c\u00e1c c\u1ed9t v\u00e0 h\u00e0ng \u0111\u00f3ng b\u0103ng. B\u1ea1n s\u1ebd t\u00ecm ki\u1ebfm c\u00e1i g\u00ec?<\/p>\n

\"\"<\/p>\n

\n

<\/a>\u0110\u1ec3 xoay ho\u1eb7c kh\u00f4ng xoay (PivotTable)<\/h2>\n

\"\"<\/p>\n

Gi\u1ea3 s\u1eed, b\u1ea1n nh\u1eadn \u0111\u01b0\u1ee3c b\u00e1o c\u00e1o c\u00f3 d\u1eef li\u1ec7u nh\u01b0ng b\u1ea1n kh\u00f4ng th\u1ec3 t\u1ea1o PivotTable do d\u1eef li\u1ec7u \u0111\u00e3 b\u1ecb xoay. C\u00e1c b\u01b0\u1edbc sau \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n b\u1ecf ch\u1ebf \u0111\u1ed9 xoay d\u1eef li\u1ec7u:<\/p>\n

    \n
  1. Ch\u1ecdn d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n, b\u1ea5m\u00a0Data\u00a0>\u00a0From Table\/Range\u00a0>\u00a0OK<\/strong>\u00a0\u0111\u1ec3 t\u1ea1o b\u1ea3ng.<\/li>\n
  2. Khi\u00a0Query Editor m\u1edf ra, nh\u1ea5n v\u00e0 gi\u1eef ph\u00edm CTRL \u0111\u1ec3 ch\u1ecdn c\u00e1c c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n b\u1ecf xoay.<\/li>\n
  3. \u0110i \u0111\u1ebfn\u00a0Transform\u00a0>\u00a0Unpivot Columns\u00a0>\u00a0Only selected columns.<\/li>\n
  4. \u0110i \u0111\u1ebfn\u00a0Home\u00a0>\u00a0Close & Load \u0111\u1ec3 \u0111\u1eb7t d\u1eef li\u1ec7u ch\u01b0a xoay v\u00e0o m\u1ed9t trang t\u00ednh m\u1edbi trong Excel.<\/li>\n<\/ol>\n

    Gi\u1edd b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o PivotTable c\u1ee7a ri\u00eang m\u00ecnh.<\/p>\n

    Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng..<\/p>\n","protected":false},"excerpt":{"rendered":"

    K\u1ef9 n\u0103ng s\u1eed d\u1ee5ng Excel m\u1ed9t c\u00e1ch th\u00e0nh th\u1ea1o v\u00e0 n\u1eafm \u0111\u01b0\u1ee3c c\u00e1c th\u1ee7 thu\u1eadt Excel s\u1ebd gi\u00fap \u00edch r\u1ea5t nhi\u1ec1u cho\u00a0b\u1ea1n. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1\u00a0th\u1ee7 thu\u1eadt Excel c\u1ef1c k\u1ef3 h\u1eefu \u00edch, gi\u00fap b\u1ea1n ng\u00e0y c\u00e0ng tr\u1edf n\u00ean chuy\u00ean nghi\u1ec7p h\u01a1n. S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Flash Fill \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n d\u1eef li\u1ec7u trong […]<\/p>\n","protected":false},"author":3,"featured_media":7498,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-7496","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tin-tuc"],"_links":{"self":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/7496","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/comments?post=7496"}],"version-history":[{"count":0,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/7496\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media\/7498"}],"wp:attachment":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media?parent=7496"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/categories?post=7496"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/tags?post=7496"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}