{"id":228599,"date":"2023-07-19T16:40:44","date_gmt":"2023-07-19T09:40:44","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=228599"},"modified":"2023-07-19T16:40:44","modified_gmt":"2023-07-19T09:40:44","slug":"huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn 5 c\u00e1ch l\u1ecdc trong excel d\u1ec5 d\u00e0ng d\u00e2n v\u0103n ph\u00f2ng kh\u00f4ng th\u1ec3 b\u1ecf qua"},"content":{"rendered":"

Excel l\u00e0 m\u1ed9t trong nh\u1eefng ph\u1ea7n m\u1ec1m tin h\u1ecdc v\u0103n ph\u00f2ng h\u1eefu \u00edch ph\u1ed5 bi\u1ebfn nh\u1ea5t hi\u1ec7n nay n\u1eb1m trong b\u1ed9 Microsoft Office. Trong b\u00e0i vi\u1ebft n\u00e0y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n 5 c\u00e1ch l\u1ecdc trong excel d\u1ec5 d\u00e0ng v\u00e0 nhanh nh\u1ea5t.\u00a0<\/b><\/span><\/p>\n

B\u00ean c\u1ea1nh Words hay Power Point, ph\u1ea7n m\u1ec1m Excel c\u0169ng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ea5t ph\u1ed5 bi\u1ebfn khi ng\u01b0\u1eddi d\u00f9ng c\u1ea7n x\u1eed l\u00fd c\u00e1c d\u1eef li\u1ec7u cho m\u1ee5c \u0111\u00edch th\u1ed1ng k\u00ea. V\u1edbi r\u1ea5t nhi\u1ec1u h\u00e0m, c\u00f4ng c\u1ee5 ti\u1ec7n l\u1ee3i, Excel c\u00f3 th\u1ec3 gi\u00fap ng\u01b0\u1eddi d\u00f9ng nhanh ch\u00f3ng s\u1eafp x\u1ebfp v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u s\u1ed1, ch\u1eef m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t. Trong b\u00e0i vi\u1ebft n\u00e0y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n 5 c\u00e1ch l\u1ecdc trong excel \u0111\u01a1n gi\u1ea3n. B\u1ea1n c\u0169ng s\u1ebd bi\u1ebft c\u00e1ch t\u1ea1o ho\u1eb7c x\u00f3a b\u1ed9 l\u1ecdc sau khi \u0111\u00e3 l\u00e0m vi\u1ec7c xong v\u1edbi tr\u01b0\u1eddng d\u1eef li\u1ec7u c\u1ea7n x\u1eed l\u00fd.<\/span><\/p>\n

B\u1ed9 l\u1ecdc trong excel l\u00e0 g\u00ec?<\/b><\/span><\/h2>\n

N\u1ebfu b\u1ea1n th\u01b0\u1eddng xuy\u00ean x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ea1ng b\u1ea3ng th\u00ec ch\u1eafc ch\u1eafn kh\u00f4ng c\u00f2n xa l\u1ea1 v\u1edbi c\u00f4ng c\u1ee5 l\u1ecdc. B\u1ed9 l\u1ecdc, hay Auto Filter, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng khi ng\u01b0\u1eddi d\u00f9ng mu\u1ed1n t\u1eadp h\u1ee3p v\u00e0 hi\u1ec3n th\u1ecb nh\u1eefng th\u00f4ng tin c\u00f3 c\u00f9ng chung m\u1ed9t \u0111\u1eb7c \u0111i\u1ec3m n\u00e0o \u0111\u00f3. B\u1ed9 l\u1ecdc gi\u00fap ng\u01b0\u1eddi l\u00e0m d\u1ec5 theo d\u00f5i nh\u1eefng tr\u01b0\u1eddng d\u1eef li\u1ec7u c\u1ea7n x\u1eed l\u00fd v\u00e0 \u1ea9n nh\u1eefng d\u1eef li\u1ec7u kh\u00e1c \u0111i. C\u00f4ng c\u1ee5 n\u00e0y c\u00f3 r\u1ea5t nhi\u1ec1u l\u1ee3i \u00edch v\u1edbi ng\u01b0\u1eddi th\u01b0\u1eddng xuy\u00ean l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c con s\u1ed1 th\u1ed1ng k\u00ea.<\/span><\/p>\n

\"cach-loc-<\/picture><\/p>\n

T\u1ea1i sao n\u00ean d\u00f9ng b\u1ed9 l\u1ecdc trong excel?<\/b><\/span><\/h2>\n

B\u1ed9 l\u1ecdc trong Excel gi\u00fap \u00edch r\u1ea5t nhi\u1ec1u cho vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u v\u00e0 th\u00f4ng tin. Ng\u01b0\u1eddi l\u00e0m c\u00f3 th\u1ec3 s\u1eafp x\u1ebfp th\u00f4ng tin theo k\u00ed t\u1ef1 t\u1eeb A \u0111\u1ebfn Z ho\u1eb7c ng\u01b0\u1ee3c l\u1ea1i. Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 s\u1eafp x\u1ebfp theo m\u00e0u s\u1eafc, ch\u1eef s\u1ed1, ho\u1eb7c ng\u00e0y th\u00e1ng n\u0103m t\u00f9y theo nhu c\u1ea7u. \u0110\u1eb7c bi\u1ec7t, khi s\u1eed d\u1ee5ng b\u1ed9 l\u1ecdc trong excel, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda c\u00e1c d\u1eef li\u1ec7u b\u00ecnh th\u01b0\u1eddng sau khi l\u1ecdc. Sau khi ch\u1ec9nh s\u1eeda xong, b\u1ea1n ch\u1ec9 c\u1ea7n t\u1eaft b\u1ed9 l\u1ecdc l\u00e0 d\u1eef li\u1ec7u l\u1ea1i hi\u1ec3n th\u1ecb theo th\u1ee9 t\u1ef1 ban \u0111\u1ea7u m\u00e0 kh\u00f4ng c\u1ea7n s\u1eafp x\u1ebfp l\u1ea1i.<\/span><\/p>\n

C\u00e1ch th\u00eam b\u1ed9 l\u1ecdc trong excel<\/b><\/span><\/h2>\n

C\u00e1ch th\u00eam b\u1ed9 l\u1ecdc trong excel c\u0169ng kh\u00f4ng qu\u00e1 ph\u1ee9c t\u1ea1p. B\u1ea1n c\u1ea7n \u0111\u1ea3m b\u1ea3o c\u00e1c ti\u00eau \u0111\u1ec1 c\u1ee7a chu\u1ed7i d\u1eef li\u1ec7u n\u1eb1m tr\u00ean c\u00f9ng m\u1ed9t h\u00e0ng. Sau \u0111\u00f3 b\u1ea1n c\u00f3 th\u1ec3 thao t\u00e1c theo m\u1ed9t trong c\u00e1c c\u00e1ch sau \u0111\u00e2y.<\/span><\/p>\n

\"cach-loc-<\/picture>
B\u1eadt b\u1ed9 l\u1ecdc trong excel<\/figcaption><\/figure>\n

V\u1edbi tab Home, b\u1ea1n ch\u1ecdn v\u00e0o nh\u00f3m Editing, sau \u0111\u00f3 s\u1ebd th\u1ea5y ph\u1ea7n hi\u1ec3n th\u1ecb tr\u1ecf xu\u1ed1ng c\u00f3 c\u00e1c t\u00f9y ch\u1ecdn “Sort A to Z”, “Sort Z to A” \u0111\u1ec1 xu\u1ea5t s\u1eb5n. Tuy nhi\u00ean b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn nh\u1ea5p v\u00e0o Filter \u0111\u1ec3 b\u1eaft \u0111\u1ea7u t\u1ea1o b\u1ed9 l\u1ecdc ph\u00f9 h\u1ee3p.<\/span><\/p>\n

V\u1edbi tab Data, b\u1ea1n c\u00f3 th\u1ec3 nh\u00ecn th\u1ea5y c\u00f4ng c\u1ee5 Filter ngay trong nh\u00f3m Sort & Filter. Ch\u1ec9 c\u1ea7n nh\u1ea5p chu\u1ed9t m\u1ed9t l\u1ea7n l\u00e0 c\u00f3 th\u1ec3 b\u1eaft \u0111\u1ea7u s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 l\u1ecdc. Ngo\u00e0i ra, n\u1ebfu b\u1ea1n l\u00e0 mu\u1ed1n s\u1eed d\u1ee5ng c\u00e1c ph\u00edm t\u1eaft \u0111\u1ec3 gi\u1ea3m th\u1eddi gian thao t\u00e1c chu\u1ed9t th\u00ec h\u00e3y l\u01b0u \u00fd c\u00e1ch b\u1eadt\/ t\u1eaft b\u1ed9 l\u1ecdc \u0111\u00f3 l\u00e0 t\u1ed5 h\u1ee3p ph\u00edm: Ctrl + Shift + L. Sau khi b\u1eadt \u0111\u01b0\u1ee3c c\u00f4ng c\u1ee5 l\u1ecdc, b\u1ea1n s\u1ebd nh\u00ecn th\u1ea5y tr\u00ean thanh ti\u00eau \u0111\u1ec1 c\u00f3 c\u00e1c m\u0169i t\u00ean h\u01b0\u1edbng xu\u1ed1ng nh\u01b0 h\u00ecnh \u1ea3nh tr\u00ean \u0111\u00e2y. Khi \u0111\u00f3 b\u1ea1n c\u00f3 th\u1ec3 b\u1eaft \u0111\u1ea7u x\u1eed l\u00fd d\u1eef li\u1ec7u v\u1edbi b\u1ed9 l\u1ecdc excel.<\/span><\/p>\n

5 c\u00e1ch l\u1ecdc trong excel \u0111\u01a1n gi\u1ea3n<\/b><\/span><\/h2>\n

V\u1ec1 c\u01a1 b\u1ea3n, b\u1ea1n c\u00f3 th\u1ec3 hi\u1ec3u b\u1ed9 l\u1ecdc \u0111\u01b0\u1eddng d\u00f9ng \u0111\u1ec3 t\u1ea1m th\u1eddi \u1ea9n \u0111i nh\u1eefng d\u1eef li\u1ec7u kh\u00f4ng c\u1ea7n d\u00f9ng v\u00e0 hi\u1ec3n th\u1ecb nh\u1eefng d\u1eef li\u1ec7u c\u1ea7n l\u00e0m vi\u1ec7c. Th\u1ebf n\u00ean, t\u00f9y theo m\u1ee5c \u0111\u00edch kh\u00e1c nhau th\u00ec ng\u01b0\u1eddi d\u00f9ng s\u1ebd ch\u1ecdn c\u00e1c b\u1ed9 l\u1ecdc kh\u00e1c nhau. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 5 c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u ph\u1ed5 bi\u1ebfn nh\u1ea5t cho ng\u01b0\u1eddi d\u00f9ng khi thao t\u00e1c v\u1edbi excel.<\/span><\/p>\n

C\u00e1ch l\u1ecdc trong excel theo d\u1eef li\u1ec7u k\u00fd t\u1ef1<\/b><\/span><\/h3>\n

\u0110\u00e2y l\u00e0 d\u1ea1ng l\u1ecdc nh\u1eefng \u00f4 c\u00f3 n\u1ed9i dung b\u00ean trong d\u1ea1ng ch\u1eef ho\u1eb7c s\u1ed1. Sau khi th\u00eam b\u1ed9 l\u1ecdc v\u00e0o c\u1ed9t c\u00f3 ch\u1ee9a k\u00fd t\u1ef1 c\u1ea7n \u0111\u1ec3 thao t\u00e1c, b\u1ea1n ch\u1ec9 c\u1ea7n click v\u00e0o m\u0169i t\u00ean th\u00ec b\u1ed9 l\u1ecdc k\u00fd t\u1ef1 s\u1ebd xu\u1ea5t hi\u1ec7n m\u1ed9t b\u1ea3ng \u0111\u01b0\u1ee3c ph\u00e2n chia s\u1eb5n. Trong \u0111\u00f3 s\u1ebd bao g\u1ed3m ph\u00e2n lo\u1ea1i nh\u1eefng k\u00fd t\u1ef1 b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng b\u1ed9 l\u1ecdc t\u1ef1 \u0111\u1ed9ng. V\u00ed d\u1ee5 trong h\u00ecnh \u1ea3nh d\u01b0\u1edbi \u0111\u00e2y, m\u00ecnh s\u1ebd thao t\u00e1c \u0111\u1ec3 l\u1ecdc nh\u1eefng ng\u01b0\u1eddi c\u00f3 t\u00ean Nam b\u1eb1ng c\u00f4ng c\u1ee5 l\u1ecdc c\u1ee7a excel. T\u1ea5t nhi\u00ean, \u0111\u00e2y c\u0169ng l\u00e0 c\u00e1ch l\u1ecdc trong excel 2003<\/b> ph\u1ed5 bi\u1ebfn \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi s\u1eed d\u1ee5ng.<\/span><\/p>\n

c\u00e1ch<\/p>\n

Thao t\u00e1c ch\u1ec9 c\u1ea7n ch\u1ecdn v\u00e0o ph\u1ea7n m\u0169i t\u00ean, \u0111\u1ec3 b\u1ea3ng ch\u1ecdn hi\u1ec3n th\u1ecb xu\u1ed1ng, v\u00e0 nh\u1ea5p chu\u1ed9t tick v\u00e0o nh\u1eefng b\u1ed9 l\u1ecdc mu\u1ed1n d\u00f9ng.<\/span><\/p>\n

L\u1ecdc c\u00e1c \u00f4 tr\u1ed1ng kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u<\/b><\/span><\/h3>\n

\u0110\u00e2y c\u0169ng l\u00e0 m\u1ed9t trong nh\u1eefng nhu c\u1ea7u c\u1ee7a nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng khi s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 l\u1ecdc c\u1ee7a excel. \u0110\u00f4i khi, danh s\u00e1ch d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n s\u1ebd c\u00f3 nh\u1eefng \u00f4 b\u1ecb b\u1ecf tr\u1ed1ng, kh\u00f4ng c\u00f3 n\u1ed9i dung v\u1ec1 k\u00fd t\u1ef1 hay s\u1ed1 g\u00ec b\u00ean trong. Nh\u1eefng \u00f4 tr\u1ed1ng n\u00e0y n\u1eb1m xen l\u1eabn trong nh\u1eefng \u00f4 c\u00f3 ch\u1ee9a n\u1ed9i dung. Ch\u00fang ta kh\u00f4ng th\u1ec3 x\u00f3a l\u1ea7n l\u01b0\u1ee3t t\u1eebng \u00f4 v\u00ec vi\u1ec7c l\u00e0m n\u00e0y ch\u1eafc ch\u1eafn s\u1ebd r\u1ea5t m\u1ea5t th\u1eddi gian. Ch\u01b0a k\u1ec3 n\u1ebfu danh s\u00e1ch d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n l\u00ean \u0111\u1ebfn con s\u1ed1 1000 h\u00e0ng ch\u1eb3ng h\u1ea1n. \u0110\u00e2y ch\u00ednh l\u00e0 l\u00fac c\u1ea7n b\u1ed9 l\u1ecdc \u0111\u1ec3 b\u1ecf qua c\u00e1c \u00f4 tr\u1ed1ng.<\/span><\/p>\n

\"L\u1ecdc<\/picture><\/p>\n

\u0110\u1ec3 thao t\u00e1c, b\u1ea1n h\u00e3y ch\u1ecdn v\u00e0o m\u0169i t\u00ean c\u1ee7a b\u1ed9 l\u1ecdc t\u1ef1 \u0111\u1ed9ng. Sau khi t\u1ea5t c\u1ea3 c\u00e1c b\u1ed9 l\u1ecdc \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb, b\u1ea1n h\u00e3y ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4, v\u00e0 b\u1ecf tick kh\u1ecfi \u00f4 Blanks. \u0110\u00e2y l\u00e0 b\u1ed9 l\u1ecdc d\u00e0nh cho c\u00e1c \u00f4 tr\u1ed1ng v\u00e0 th\u01b0\u1eddng n\u1eb1m \u1edf cu\u1ed1i danh s\u00e1ch c\u1ee7a h\u1ed9p Show All. Nh\u01b0 v\u1eady, nh\u1eefng \u00f4 kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u s\u1ebd b\u1ecb b\u1ecf qua v\u00e0 ch\u1ec9 c\u00f2n hi\u1ec3n th\u1ecb c\u00e1c \u00f4 c\u00f3 d\u1eef li\u1ec7u. Ng\u01b0\u1ee3c l\u1ea1i, n\u1ebfu b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb c\u00e1c \u00f4 tr\u1ed1ng th\u00ec h\u00e3y thao t\u00e1c tick v\u00e0o \u00f4 blanks v\u00e0 b\u1ecf ch\u1ecdn c\u00e1c \u00f4 c\u00f2n l\u1ea1i nh\u00e9.<\/span><\/p>\n

L\u1ecdc ng\u00e0y th\u00e1ng n\u0103m trong excel<\/b><\/span><\/h3>\n

M\u1ed9t trong nh\u1eefng c\u00e1ch kh\u00e1c c\u0169ng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ea5t ph\u1ed5 bi\u1ebfn \u0111\u00f3 l\u00e0 b\u1ed9 l\u1ecdc Ng\u00e0y Th\u00e1ng N\u0103m. Th\u00f4ng th\u01b0\u1eddng, b\u1ed9 l\u1ecdc n\u00e0y c\u00f3 th\u1ec3 d\u00f9ng khi b\u1ea1n c\u1ea7n th\u1ed1ng k\u00ea danh s\u00e1ch nh\u1eadp h\u00e0ng, ho\u1eb7c b\u1ea3ng ch\u1ea5m c\u00f4ng cho nh\u00e2n s\u1ef1 theo t\u1eebng ng\u00e0y. Ngo\u00e0i ra, b\u1ed9 l\u1ecdc n\u00e0y c\u00f2n cho ng\u01b0\u1eddi d\u00f9ng ch\u1ecdn hi\u1ec3n th\u1ecb c\u00e1c d\u1eef li\u1ec7u theo tu\u1ea7n ho\u1eb7c th\u00e1ng. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb t\u1ea5t c\u1ea3 c\u00e1c th\u00f4ng tin trong 15 ng\u00e0y \u0111\u1ea7u ti\u00ean c\u1ee7a th\u00e1ng 7, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp c\u00e1c th\u00f4ng tin v\u00e0o b\u1ea3ng nh\u01b0 sau:<\/span><\/p>\n

L\u1ecdc s\u1ed1 trong excel<\/b><\/span><\/h3>\n

T\u01b0\u01a1ng t\u1ef1 nh\u01b0 b\u1ed9 l\u1ecdc k\u00fd t\u1ef1, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 l\u1ecdc c\u00e1c \u00f4 ch\u1ee9a s\u1ed1 theo c\u00e1c c\u00e1ch kh\u00e1c nhau. M\u1ed9t v\u00e0i thao t\u00e1c ph\u1ed5 bi\u1ebfn th\u01b0\u1eddng th\u1ea5y khi x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1 bao g\u1ed3m: l\u1ecdc c\u00e1c s\u1ed1 b\u1eb1ng ho\u1eb7c l\u1edbn h\u01a1n m\u1ed9t s\u1ed1 n\u00e0o \u0111\u00f3, l\u1ecdc s\u1ed1 l\u1edbn h\u01a1n ho\u1eb7c nh\u1ecf h\u01a1n ho\u1eb7c n\u1eb1m trong m\u1ed9t kho\u1ea3ng gi\u1eefa hai s\u1ed1. Ngo\u00e0i ra, trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 c\u00f3 nhu c\u1ea7u l\u1ecdc 10 s\u1ed1 \u0111\u1ea7u ti\u00ean ho\u1eb7c 10 s\u1ed1 cu\u1ed1i c\u00f9ng trong tr\u01b0\u1eddng d\u1eef li\u1ec7u. B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 ch\u1ecdn b\u1ed9 l\u1ecdc nh\u1eefng \u00f4 ch\u1ee9a s\u1ed1 nh\u1ecf ho\u1eb7c l\u1edbn h\u01a1n gi\u00e1 tr\u1ecb trung b\u00ecnh.<\/span><\/p>\n

\"cach-loc-trong<\/picture>
L\u1ecdc s\u1ed1 trong excel<\/figcaption><\/figure>\n

\u0110\u1ec3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng b\u1ed9 l\u1ecdc s\u1ed1 trong excel, b\u1ea1n c\u0169ng thao t\u00e1c t\u01b0\u01a1ng t\u1ef1 t\u1ea1o ra m\u0169i t\u00ean l\u1ecdc tr\u00ean \u00f4 ti\u00eau \u0111\u1ec1 c\u1ee7a c\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb. Sau \u0111\u00f3 ch\u1ecdn v\u00e0o m\u0169i t\u00ean tr\u1ecf xu\u1ed1ng \u0111\u1ec3 hi\u1ec3n th\u1ecb b\u1ea3ng c\u00e1c b\u1ed9 l\u1ecdc. B\u1ea1n ch\u1ecdn v\u00e0o b\u1ed9 l\u1ecdc s\u1ed1 v\u00e0 ch\u1ecdn m\u1ed9t \u0111i\u1ec1u ki\u1ec7n ph\u00f9 h\u1ee3p v\u1edbi nhu c\u1ea7u l\u1ecdc. Khi \u0111\u00f3, b\u1ed9 l\u1ecdc s\u1ebd t\u1ef1 \u0111\u1ed9ng hi\u1ec3n th\u1ecb nh\u1eefng \u00f4 c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb s\u1ed1 ph\u00f9 h\u1ee3p v\u00e0 \u1ea5n ok. B\u1ea1n c\u00f3 th\u1ec3 quan s\u00e1t m\u1eabu v\u00ed d\u1ee5 t\u1eeb h\u00ecnh \u1ea3nh tr\u00ean \u0111\u00e2y. Theo b\u1ed9 l\u1ecdc s\u1ed1, excel \u0111\u00e3 l\u1ecdc ra nh\u1eefng b\u1ea1n h\u1ecdc sinh c\u00f3 chi\u1ec1u cao trong kho\u1ea3ng t\u1eeb 130cm \u0111\u1ebfn 160cm \u0111\u1ec3 hi\u1ec3n th\u1ecb.<\/span><\/p>\n

C\u00e1ch l\u1ecdc trong excel v\u1edbi d\u1eef li\u1ec7u theo m\u00e0u<\/b><\/span><\/h3>\n

Th\u00f4ng th\u01b0\u1eddng, c\u00e1c lo\u1ea1i trang t\u00ednh ch\u1ee9a d\u1eef li\u1ec7u hi\u1ec7n nay \u0111\u1ec1u \u0111\u1ec3 hi\u1ec3n th\u1ecb m\u00e0u tr\u1eafng. Tuy nhi\u00ean \u0111\u00f4i l\u00fac b\u1ea1n c\u0169ng s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c c\u00e1c trang t\u00ednh c\u00f3 \u00f4 d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c b\u00f4i m\u00e0u \u0111\u1ec3 ph\u00e2n lo\u1ea1i. Ho\u1eb7c n\u1ebfu b\u1ea1n mu\u1ed1n b\u00f4i m\u00e0u c\u00e1c \u00f4 d\u1eef li\u1ec7u \u0111\u1ec3 cho b\u1ea3ng tr\u00f4ng b\u1eaft m\u1eaft h\u01a1n th\u00ec v\u1eabn c\u00f3 th\u1ec3 d\u00f9ng b\u1ed9 l\u1ecdc. Khi \u0111\u00f3, b\u1ea1n c\u0169ng thao t\u00e1c t\u1ea1o b\u1ed9 l\u1ecdc t\u01b0\u01a1ng t\u1ef1 nh\u01b0 c\u00e1c c\u00e1ch tr\u00ean \u0111\u1ec3 t\u1ea1o ra m\u0169i t\u00ean tr\u00ean ph\u1ea7n ti\u00eau \u0111\u1ec1 c\u1ee7a \u00f4 d\u1eef li\u1ec7u. T\u00f9y theo t\u1eebng \u0111\u1ecbnh d\u1ea1ng trong \u00f4 d\u1eef li\u1ec7u, b\u1ea1n c\u00f3 th\u1ec3 l\u1ecdc theo m\u00e0u ph\u00f4ng ch\u1eef, m\u00e0u c\u1ed9t ho\u1eb7c theo bi\u1ec3u t\u01b0\u1ee3ng c\u1ee7a \u00f4.<\/span><\/p>\n

\"cach-loc-trong-excel-5\"<\/picture>
L\u1ecdc theo m\u00e0u<\/figcaption><\/figure>\n

V\u00ed d\u1ee5 trong b\u1ea3ng tr\u00ean, d\u1eef li\u1ec7u \u0111ang \u0111\u01b0\u1ee3c b\u00f4i 3 lo\u1ea1i \u0111\u00f3 l\u00e0 xanh d\u01b0\u01a1ng, v\u00e0ng v\u00e0 cam. N\u1ebfu b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng b\u1ed9 l\u1ecdc m\u00e0u, h\u00e3y ch\u1ecdn v\u00e0o m\u0169i t\u00ean \u0111\u1ec3 hi\u1ec3n th\u1ecb b\u1ea3ng. Sau \u0111\u00f3, b\u1ea1n ch\u1ecdn v\u00e0o filter by color – l\u1ecdc theo m\u00e0u v\u00e0 ch\u1ecdn m\u00e0u t\u01b0\u01a1ng \u1ee9ng. Trong tr\u01b0\u1eddng h\u1ee3p tr\u00ean, c\u00e1c \u00f4 c\u00f3 m\u00e0u v\u00e0ng s\u1ebd \u0111\u01b0\u1ee3c l\u1ecdc v\u00e0 hi\u1ec3n th\u1ecb \u0111\u1ec3 s\u1eed d\u1ee5ng. C\u00e1c \u00f4 ch\u1ee9a m\u00e0u kh\u00e1c s\u1ebd t\u1ea1m th\u1eddi \u0111\u01b0\u1ee3c \u1ea9n \u0111i tr\u00ean b\u1ea3ng.<\/span><\/p>\n

Sao ch\u00e9p d\u1eef li\u1ec7u sau khi l\u1ecdc trong excel<\/b><\/span><\/h2>\n

Nh\u01b0 m\u00ecnh \u0111\u00e3 nh\u1eafc \u0111\u1ebfn \u1edf tr\u00ean, d\u1eef li\u1ec7u sau khi \u0111\u01b0\u1ee3c l\u1ecdc s\u1ebd hi\u1ec3n th\u1ecb tr\u00ean b\u1ea3ng th\u1ed1ng k\u00ea \u0111\u1ec3 ng\u01b0\u1eddi l\u00e0m c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng thao t\u00e1c. C\u00e1c d\u1eef li\u1ec7u kh\u00e1c s\u1ebd \u0111\u01b0\u1ee3c \u1ea9n \u0111i ch\u1ee9 kh\u00f4ng b\u1ecb x\u00f3a. B\u1ea1n c\u00f3 th\u1ec3 copy d\u1eef li\u1ec7u sau khi l\u1ecdc v\u00e0 chuy\u1ec3n \u0111\u1ebfn m\u1ed9t trang t\u00ednh kh\u00e1c s\u1eed d\u1ee5ng v\u1edbi thao t\u00e1c \u0111\u01a1n gi\u1ea3n:<\/span><\/p>\n

\u0110\u1ea7u ti\u00ean, b\u1ea1n ch\u1ecdn c\u00e1c \u00f4 ch\u1ee9a d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c l\u1ecdc v\u00e0 \u1ea5n Ctrl + A \u0111\u1ec3 ch\u1ecdn to\u00e0n b\u1ed9 d\u1eef li\u1ec7u. Sau \u0111\u00f3 b\u1ea1n ch\u1ecdn Ctrl + C \u0111\u1ec3 sao ch\u00e9p, chuy\u1ec3n \u0111\u1ebfn trang t\u00ednh m\u1edbi, ch\u1ecdn \u00f4 tr\u00ean c\u00f9ng b\u00ean tr\u00e1i v\u00e0 \u1ea5n Ctrl + V. Nh\u01b0 v\u1eady, to\u00e0n b\u1ed9 d\u1eef li\u1ec7u sau l\u1ecdc \u0111\u00e3 \u0111\u01b0\u1ee3c d\u00e1n l\u00ean m\u1ed9t b\u1ea3ng m\u1edbi. Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n kh\u00f4ng mu\u1ed1n copy ph\u1ea7n ti\u00eau \u0111\u1ec1, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn \u00f4 \u0111\u1ea7u ti\u00ean ch\u1ee9a d\u1eef li\u1ec7u v\u00e0 \u1ea5n t\u1ed5 h\u1ee3p ph\u00edm Ctrl + Shift + End. Nh\u01b0 v\u1eady, excel s\u1ebd t\u1ef1 \u0111\u1ed9ng ch\u1ecdn \u0111\u1ebfn \u00f4 d\u1eef li\u1ec7u cu\u1ed1i c\u00f9ng v\u00e0 tr\u1eeb l\u1ea1i ti\u00eau \u0111\u1ec1 c\u1ee7a c\u00e1c c\u1ed9t, c\u00e1c h\u00e0ng.<\/span><\/p>\n

C\u00e1ch x\u00f3a b\u1ed9 l\u1ecdc trong excel<\/b><\/span><\/h2>\n

B\u1ed9 l\u1ecdc Auto Filter \u0111\u01b0\u1ee3c d\u00f9ng khi b\u1ea1n c\u1ea7n x\u1eed l\u00fd th\u00f4ng tin v\u1edbi m\u1ed9t nh\u00f3m d\u1eef li\u1ec7u trong m\u1ed9t b\u1ea3ng th\u1ed1ng k\u00ea l\u1edbn. V\u00ec v\u1eady, sau khi s\u1eed d\u1ee5ng b\u1ed9 l\u1ecdc, b\u1ea1n v\u1eabn c\u00f3 th\u1ec3 x\u00f3a n\u00f3 \u0111i kh\u1ecfi b\u1ea3ng. \u0110\u1ec3 x\u00f3a b\u1ed9 l\u1ecdc kh\u1ecfi c\u00e1c c\u1ed9t, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n theo c\u00e1c thao t\u00e1c sau \u0111\u00e2y. B\u1ea1n ch\u1ecdn v\u00e0o ph\u00edm b\u1ed9 l\u1ecdc tr\u00ean ti\u00eau \u0111\u1ec1 c\u1ee7a c\u1ed9t mu\u1ed1n x\u00f3a \u0111\u1ec3 b\u1ea3ng hi\u1ec3n th\u1ecb th\u00f4ng tin tr\u1ecf xu\u1ed1ng. Sau \u0111\u00f3 b\u1ea1n ch\u1ecdn v\u00e0o ph\u1ea7n Clear Filter From < t\u00ean c\u1ed9t> v\u00e0 b\u1ed9 l\u1ecdc s\u1ebd \u0111\u01b0\u1ee3c lo\u1ea1i b\u1ecf kh\u1ecfi b\u1ea3ng d\u1eef li\u1ec7u.<\/span><\/p>\n

\"Cach-loc-<\/picture>
C\u00e1ch x\u00f3a b\u1ed9 l\u1ecdc trong excel<\/figcaption><\/figure>\n

Ngo\u00e0i ra b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 x\u00f3a t\u1ea5t c\u1ea3 b\u1ed9 l\u1ecdc \u0111\u00e3 t\u1ea1o tr\u00ean c\u00e1c c\u1ed9t trong trang t\u00ednh. B\u1ea1n c\u00f3 th\u1ec3 thao t\u00e1c nh\u01b0 sau, ch\u1ecdn tab Data, ch\u1ecdn nh\u00f3m Sort & Filter sau \u0111\u00f3 ch\u1ecdn Clear. Ho\u1eb7c c\u00e1ch th\u1ee9 2 b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 ch\u1ecdn v\u00e0o tab Home, ch\u1ecdn nh\u00f3m Editing v\u00e0 ch\u1ecdn Clear trong Sort & Filter. Sau khi b\u1ed9 l\u1ecdc \u0111\u01b0\u1ee3c x\u00f3a, b\u1ea3ng d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n s\u1ebd c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng cho c\u00e1c m\u1ee5c \u0111\u00edch in \u1ea5n. B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 t\u1ea1o l\u1ea1i b\u1ed9 l\u1ecdc trong excel cho b\u1ea3ng d\u1eef li\u1ec7u b\u1ea5t c\u1ee9 l\u00fac n\u00e0o.<\/span><\/p>\n

T\u1ea1m K\u1ebft<\/b><\/span><\/h2>\n

C\u00f4ng c\u1ee5 b\u1ed9 l\u1ecdc trong Excel r\u1ea5t h\u1eefu \u00edch cho nh\u1eefng ng\u01b0\u1eddi th\u01b0\u1eddng xuy\u00ean ph\u1ea3i l\u00e0m c\u00f4ng vi\u1ec7c v\u1edbi b\u1ea3ng d\u1eef li\u1ec7u v\u00e0 c\u00e1c con s\u1ed1 th\u1ed1ng k\u00ea. Tr\u00ean \u0111\u00e2y l\u00e0 5 c\u00e1ch l\u1ecdc trong excel<\/b> \u0111\u01a1n gi\u1ea3n cho b\u1ea1n tham kh\u1ea3o. B\u00ean c\u1ea1nh \u0111\u00f3, c\u00f2n r\u1ea5t nhi\u1ec1u th\u00f4ng tin h\u1eefu \u00edch v\u1ec1 c\u00e1c th\u1ee7 thu\u1eadt Excel<\/a>, Words<\/a> hay c\u00e1c c\u00f4ng c\u1ee5 thu\u1ed9c b\u1ed9 Microsoft Office gi\u00fap b\u1ea1n x\u1eed l\u00fd c\u00e1c c\u00f4ng vi\u1ec7c d\u1ec5 d\u00e0ng h\u01a1n. Trang tin t\u1ee9c Ho\u00e0ng H\u00e0 Mobile c\u0169ng c\u1eadp nh\u1eadt r\u1ea5t nhi\u1ec1u n\u1ed9i dung v\u1ec1 xu h\u01b0\u1edbng c\u00f4ng ngh\u1ec7 m\u1edbi. H\u00e3y theo d\u00f5i Ho\u00e0ng H\u00e0 Mobile<\/span><\/a>\u00a0\u0111\u1ec3 c\u00f3 th\u00eam nhi\u1ec1u th\u1ee7 thu\u1eadt, m\u1eb9o hay v\u1ec1 th\u1ebf gi\u1edbi c\u00f4ng ngh\u1ec7 nh\u00e9!<\/span><\/p>\n

\u00a0<\/span><\/p>\n

\u00a0<\/span><\/p>\n

\u00a0<\/span><\/p>\n

\u00a0<\/span><\/p>\n

\u00a0<\/span><\/p>\n

\u00a0<\/span><\/p>\n

\u00a0<\/span><\/p>\n

\u00a0<\/span><\/p>\n

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

Excel l\u00e0 m\u1ed9t trong nh\u1eefng ph\u1ea7n m\u1ec1m tin h\u1ecdc v\u0103n ph\u00f2ng h\u1eefu \u00edch ph\u1ed5 bi\u1ebfn nh\u1ea5t hi\u1ec7n nay n\u1eb1m trong b\u1ed9 Microsoft Office. Trong b\u00e0i vi\u1ebft n\u00e0y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n 5 c\u00e1ch l\u1ecdc trong excel d\u1ec5 d\u00e0ng v\u00e0 nhanh nh\u1ea5t.\u00a0 B\u00ean c\u1ea1nh Words hay Power Point, ph\u1ea7n m\u1ec1m Excel c\u0169ng \u0111\u01b0\u1ee3c […]<\/p>\n","protected":false},"author":38,"featured_media":229486,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16,412],"tags":[],"class_list":["post-228599","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat","category-thu-thuat-may-tinh"],"yoast_head":"\n5 c\u00e1ch l\u1ecdc trong excel \u0111\u01a1n gi\u1ea3n cho d\u00e2n v\u0103n ph\u00f2ng<\/title>\n<meta name=\"description\" content=\"Trong b\u00e0i vi\u1ebft n\u00e0y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n 5 c\u00e1ch l\u1ecdc trong excel d\u1ec5 d\u00e0ng \u0111\u1ec3 b\u1eaft \u0111\u1ea7u x\u1eed l\u00fd c\u00e1c s\u1ed1 li\u1ec7u th\u1ed1ng k\u00ea.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u01b0\u1edbng d\u1eabn 5 c\u00e1ch l\u1ecdc trong excel d\u1ec5 d\u00e0ng d\u00e2n v\u0103n ph\u00f2ng kh\u00f4ng th\u1ec3 b\u1ecf qua\" \/>\n<meta property=\"og:description\" content=\"Trong b\u00e0i vi\u1ebft n\u00e0y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n 5 c\u00e1ch l\u1ecdc trong excel d\u1ec5 d\u00e0ng \u0111\u1ec3 b\u1eaft \u0111\u1ea7u x\u1eed l\u00fd c\u00e1c s\u1ed1 li\u1ec7u th\u1ed1ng k\u00ea.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-19T09:40:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/5-cach-loc-du-lieu-don-gian-trong.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Joey\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Joey\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"13 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/\"},\"author\":{\"name\":\"Joey\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/23a0a1f55f54384c83c9ad7cd89d333a\"},\"headline\":\"H\u01b0\u1edbng d\u1eabn 5 c\u00e1ch l\u1ecdc trong excel d\u1ec5 d\u00e0ng d\u00e2n v\u0103n ph\u00f2ng kh\u00f4ng th\u1ec3 b\u1ecf qua\",\"datePublished\":\"2023-07-19T09:40:44+00:00\",\"dateModified\":\"2023-07-19T09:40:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/\"},\"wordCount\":3129,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/5-cach-loc-du-lieu-don-gian-trong.png\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\",\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/\",\"name\":\"5 c\u00e1ch l\u1ecdc trong excel \u0111\u01a1n gi\u1ea3n cho d\u00e2n v\u0103n ph\u00f2ng\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/5-cach-loc-du-lieu-don-gian-trong.png\",\"datePublished\":\"2023-07-19T09:40:44+00:00\",\"dateModified\":\"2023-07-19T09:40:44+00:00\",\"description\":\"Trong b\u00e0i vi\u1ebft n\u00e0y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n 5 c\u00e1ch l\u1ecdc trong excel d\u1ec5 d\u00e0ng \u0111\u1ec3 b\u1eaft \u0111\u1ea7u x\u1eed l\u00fd c\u00e1c s\u1ed1 li\u1ec7u th\u1ed1ng k\u00ea.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/5-cach-loc-du-lieu-don-gian-trong.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/5-cach-loc-du-lieu-don-gian-trong.png\",\"width\":1200,\"height\":628},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Th\u1ee7 thu\u1eadt\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"H\u01b0\u1edbng d\u1eabn 5 c\u00e1ch l\u1ecdc trong excel d\u1ec5 d\u00e0ng d\u00e2n v\u0103n ph\u00f2ng kh\u00f4ng th\u1ec3 b\u1ecf qua\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/23a0a1f55f54384c83c9ad7cd89d333a\",\"name\":\"Joey\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1a804ad0ed5426056f2e33c50c5aa21a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1a804ad0ed5426056f2e33c50c5aa21a?s=96&d=mm&r=g\",\"caption\":\"Joey\"},\"description\":\"V\u1edbi h\u01a1n 4 n\u0103m g\u1eafn b\u00f3 c\u00f9ng l\u0129nh v\u1ef1c b\u00e1o ch\u00ed c\u00f4ng ngh\u1ec7, t\u00f4i kh\u00f4ng ch\u1ec9 vi\u1ebft b\u1eb1ng kinh nghi\u1ec7m m\u00e0 c\u00f2n b\u1eb1ng ni\u1ec1m \u0111am m\u00ea v\u1edbi nh\u1eefng thay \u0111\u1ed5i kh\u00f4ng ng\u1eebng c\u1ee7a l\u0129nh v\u1ef1c n\u00e0y. T\u00f4i mong mu\u1ed1n truy\u1ec1n t\u1ea3i s\u1ef1 h\u1ea5p d\u1eabn \u0111\u00f3 qua t\u1eebng b\u00e0i vi\u1ebft. V\u1edbi t\u00f4i, c\u00f4ng ngh\u1ec7 kh\u00f4ng ch\u1ec9 l\u00e0 th\u00f4ng tin, m\u00e0 c\u00f2n l\u00e0 c\u00e2u chuy\u1ec7n v\u1ec1 t\u01b0\u01a1ng lai.\",\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"],\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/minh-chau\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"5 c\u00e1ch l\u1ecdc trong excel \u0111\u01a1n gi\u1ea3n cho d\u00e2n v\u0103n ph\u00f2ng","description":"Trong b\u00e0i vi\u1ebft n\u00e0y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n 5 c\u00e1ch l\u1ecdc trong excel d\u1ec5 d\u00e0ng \u0111\u1ec3 b\u1eaft \u0111\u1ea7u x\u1eed l\u00fd c\u00e1c s\u1ed1 li\u1ec7u th\u1ed1ng k\u00ea.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u01b0\u1edbng d\u1eabn 5 c\u00e1ch l\u1ecdc trong excel d\u1ec5 d\u00e0ng d\u00e2n v\u0103n ph\u00f2ng kh\u00f4ng th\u1ec3 b\u1ecf qua","og_description":"Trong b\u00e0i vi\u1ebft n\u00e0y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n 5 c\u00e1ch l\u1ecdc trong excel d\u1ec5 d\u00e0ng \u0111\u1ec3 b\u1eaft \u0111\u1ea7u x\u1eed l\u00fd c\u00e1c s\u1ed1 li\u1ec7u th\u1ed1ng k\u00ea.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_author":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-07-19T09:40:44+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/5-cach-loc-du-lieu-don-gian-trong.png","type":"image\/png"}],"author":"Joey","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Joey","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"13 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/"},"author":{"name":"Joey","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/23a0a1f55f54384c83c9ad7cd89d333a"},"headline":"H\u01b0\u1edbng d\u1eabn 5 c\u00e1ch l\u1ecdc trong excel d\u1ec5 d\u00e0ng d\u00e2n v\u0103n ph\u00f2ng kh\u00f4ng th\u1ec3 b\u1ecf qua","datePublished":"2023-07-19T09:40:44+00:00","dateModified":"2023-07-19T09:40:44+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/"},"wordCount":3129,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/5-cach-loc-du-lieu-don-gian-trong.png","articleSection":["Excel","Th\u1ee7 thu\u1eadt","Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/","name":"5 c\u00e1ch l\u1ecdc trong excel \u0111\u01a1n gi\u1ea3n cho d\u00e2n v\u0103n ph\u00f2ng","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/5-cach-loc-du-lieu-don-gian-trong.png","datePublished":"2023-07-19T09:40:44+00:00","dateModified":"2023-07-19T09:40:44+00:00","description":"Trong b\u00e0i vi\u1ebft n\u00e0y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n 5 c\u00e1ch l\u1ecdc trong excel d\u1ec5 d\u00e0ng \u0111\u1ec3 b\u1eaft \u0111\u1ea7u x\u1eed l\u00fd c\u00e1c s\u1ed1 li\u1ec7u th\u1ed1ng k\u00ea.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/5-cach-loc-du-lieu-don-gian-trong.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/5-cach-loc-du-lieu-don-gian-trong.png","width":1200,"height":628},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"Th\u1ee7 thu\u1eadt","item":"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/"},{"@type":"ListItem","position":3,"name":"H\u01b0\u1edbng d\u1eabn 5 c\u00e1ch l\u1ecdc trong excel d\u1ec5 d\u00e0ng d\u00e2n v\u0103n ph\u00f2ng kh\u00f4ng th\u1ec3 b\u1ecf qua"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/23a0a1f55f54384c83c9ad7cd89d333a","name":"Joey","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1a804ad0ed5426056f2e33c50c5aa21a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1a804ad0ed5426056f2e33c50c5aa21a?s=96&d=mm&r=g","caption":"Joey"},"description":"V\u1edbi h\u01a1n 4 n\u0103m g\u1eafn b\u00f3 c\u00f9ng l\u0129nh v\u1ef1c b\u00e1o ch\u00ed c\u00f4ng ngh\u1ec7, t\u00f4i kh\u00f4ng ch\u1ec9 vi\u1ebft b\u1eb1ng kinh nghi\u1ec7m m\u00e0 c\u00f2n b\u1eb1ng ni\u1ec1m \u0111am m\u00ea v\u1edbi nh\u1eefng thay \u0111\u1ed5i kh\u00f4ng ng\u1eebng c\u1ee7a l\u0129nh v\u1ef1c n\u00e0y. T\u00f4i mong mu\u1ed1n truy\u1ec1n t\u1ea3i s\u1ef1 h\u1ea5p d\u1eabn \u0111\u00f3 qua t\u1eebng b\u00e0i vi\u1ebft. V\u1edbi t\u00f4i, c\u00f4ng ngh\u1ec7 kh\u00f4ng ch\u1ec9 l\u00e0 th\u00f4ng tin, m\u00e0 c\u00f2n l\u00e0 c\u00e2u chuy\u1ec7n v\u1ec1 t\u01b0\u01a1ng lai.","sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"],"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/minh-chau\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/228599","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/38"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=228599"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/228599\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/229486"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=228599"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=228599"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=228599"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}