{"id":2119,"date":"2024-12-02T07:00:25","date_gmt":"2024-12-02T07:00:25","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/tim-hieu-ve-power-query\/"},"modified":"2024-12-02T07:00:25","modified_gmt":"2024-12-02T07:00:25","slug":"tim-hieu-ve-power-query","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/tim-hieu-ve-power-query\/","title":{"rendered":"T\u00ecm hi\u1ec3u v\u1ec1 Power Query"},"content":{"rendered":"
\n

Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online<\/strong> <\/a>s\u1ebd gi\u1edbi thi\u1ec7u b\u1ea1n nh\u1eefng th\u00f4ng tin v\u1ec1 Power Query. Power Query l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1eefu \u00edch cho c\u00e1c c\u00f4ng c\u1ee5 ph\u00e2n t\u00edch d\u1eef li\u1ec7u, x\u1eed l\u00fd v\u00e0 l\u1eadp c\u00e1c b\u00e1o c\u00e1o. V\u00ec v\u1eady, h\u00e3y c\u00f9ng H\u1ecdc Excel Online t\u00ecm hi\u1ec3u ngay v\u1ec1 Power Query nh\u00e9!<\/em><\/p>\n

\"T\u00ecm
T\u00ecm hi\u1ec3u v\u1ec1 Power Query 1<\/figcaption><\/figure>\n

B\u1eefa ti\u1ec7c \u0111\u00e3 di\u1ec5n ra s\u00f4i n\u1ed5i. T\u00f4i \u0111\u00e3 \u0111\u1ebfn mu\u1ed9n.<\/span><\/p>\n

Cu\u1ed1i c\u00f9ng khi t\u00f4i \u0111\u1ebfn n\u01a1i, thay v\u00ec th\u00f4ng th\u01b0\u1eddng \u201cB\u1ea1n g\u1ecdi c\u00e1i n\u00e0y l\u00fac m\u1ea5y gi\u1edd?\u201d, T\u00f4i nh\u1eadn \u0111\u01b0\u1ee3c c\u00e2u tr\u1ea3 l\u1eddi \u201cN\u00e0y; B\u1ea1n \u0111\u00e3 l\u00e0m \u0111\u01b0\u1ee3c, \u0111i\u1ec1u \u0111\u00f3 th\u1eadt tuy\u1ec7t v\u1eddi. Th\u1eadt tuy\u1ec7t khi b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ebfn. \u0110\u1ec3 t\u00f4i d\u1eabn b\u1ea1n \u0111i xung quanh\u201d. Kh\u00f4ng ai coi th\u01b0\u1eddng t\u00f4i v\u00ec t\u00f4i \u0111\u00e3 \u0111\u1ebfn mu\u1ed9n. H\u1ecd h\u00e0i l\u00f2ng v\u00ec t\u00f4i \u0111\u00e3 \u1edf \u0111\u00f3 v\u00e0 vui m\u1eebng k\u1ec3 cho t\u00f4i nghe v\u1ec1 m\u1ecdi th\u1ee9 s\u1ebd x\u1ea3y ra.<\/span><\/p>\n

Nghe gi\u1ed1ng nh\u01b0 m\u1ed9t b\u1eefa ti\u1ec7c tuy\u1ec7t v\u1eddi ph\u1ea3i kh\u00f4ng? B\u1ea1n c\u0169ng b\u1eaft \u0111\u1ea7u \u01b0\u1edbc r\u1eb1ng m\u00ecnh \u1edf \u0111\u00f3 ph\u1ea3i kh\u00f4ng? Tin t\u1ed1t l\u00e0\u2026 b\u1ea1n \u0111\u00e3 \u0111\u01b0\u1ee3c m\u1eddi. Tr\u00ean th\u1ef1c t\u1ebf, b\u1ea1n v\u1eeba m\u1edbi \u0111\u1ebfn.<\/span><\/p>\n

B\u1eefa ti\u1ec7c m\u00e0 t\u00f4i \u0111ang \u0111\u1ec1 c\u1eadp \u0111\u1ebfn l\u00e0 b\u1eefa ti\u1ec7c nh\u1eefng ng\u01b0\u1eddi \u0111\u00e3 bi\u1ebft v\u00e0 y\u00eau th\u00edch Power Query (ho\u1eb7c Get & Transform nh\u01b0 \u0111\u01b0\u1ee3c bi\u1ebft \u0111\u1ebfn trong Excel 2016 v\u00e0 phi\u00ean b\u1ea3n m\u1edbi h\u01a1n). T\u00f4i kh\u00f4ng th\u1ec3 nh\u1edb l\u1ea7n \u0111\u1ea7u ti\u00ean t\u00f4i nghe v\u1ec1 Power Query, nh\u01b0ng t\u00f4i nh\u1edb n\u00f3 c\u0169ng gi\u1ed1ng nh\u01b0 Power Pivot. Sau \u0111\u00f3, t\u00f4i nghe n\u00f3i r\u1eb1ng \u0111\u00f3 l\u00e0 m\u1ed9t add-in \u0111\u01b0\u1ee3c th\u00eam v\u00e0o m\u00e0 t\u00f4i ph\u1ea3i c\u00e0i \u0111\u1eb7t. Suy ngh\u0129 \u0111\u1ea7u ti\u00ean c\u1ee7a t\u00f4i l\u00e0 \u201cNghe c\u00f3 v\u1ebb qu\u00e1 n\u1ed7 l\u1ef1c; D\u00f9 sao n\u00f3 c\u0169ng s\u1ebd l\u00e0 kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb. T\u00f4i th\u1eadt s\u1ef1 kh\u00f4ng c\u1ea7n n\u00f3. T\u00f4i \u0111\u00e3 c\u00f3 VBA; T\u00f4i c\u00f3 th\u1ec3 l\u00e0m m\u1ecdi th\u1ee9 t\u00f4i c\u1ea7n trong VBA. N\u00f3 s\u1ebd ch\u1ec9 l\u00e0 m\u1ed9t s\u1ef1 l\u00e3ng ph\u00ed th\u1eddi gian.\u201d \u0110i\u1ec1u tr\u1edb tr\u00eau l\u00e0 t\u00f4i \u0111\u00e3 s\u1eed d\u1ee5ng Power Query t\u1ea1i th\u1eddi \u0111i\u1ec3m \u0111\u00f3, n\u00f3 \u0111\u00e3 gi\u00fap t\u00f4i ti\u1ebft ki\u1ec7m nhi\u1ec1u th\u1eddi gian.<\/span><\/p>\n

Qua m\u1ed9t th\u1eddi gian. T\u00f4i nh\u1eadn ra r\u1eb1ng ng\u00e0y c\u00e0ng c\u00f3 nhi\u1ec1u chuy\u00ean gia Excel n\u00f3i v\u1ec1 n\u00f3. Ken Puls, Mynda Treacy, Oz du Soleil \u0111\u1ec1u \u0111ang n\u00f3i v\u1ec1 Power Query tuy\u1ec7t v\u1eddi nh\u01b0 th\u1ebf n\u00e0o. T\u00f4i c\u00f3 ni\u1ec1m tin m\u00e3nh li\u1ec7t v\u00e0o n\u00f3. T\u00f4i t\u1ef1 ngh\u0129: \u201cT\u00f4i kh\u00f4ng l\u00e0m vi\u1ec7c trong m\u00f4i tr\u01b0\u1eddng c\u00f3 d\u1eef li\u1ec7u r\u1ed1i, t\u00f4i kh\u00f4ng d\u00e0nh h\u00e0ng gi\u1edd \u0111\u1ec3 d\u1ecdn d\u1eb9p v\u00e0 kh\u1eafc ph\u1ee5c s\u1ef1 c\u1ed1 v\u1ec1 d\u1eef li\u1ec7u. C\u1ed9ng v\u1edbi \u201cchuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u\u201d nghe c\u00f3 v\u1ebb gi\u1ed1ng nh\u01b0 \u0111i\u1ec1u g\u00ec \u0111\u00f3 t\u00f4i c\u1ea7n c\u00f3 b\u1eb1ng c\u1ea5p v\u1ec1 khoa h\u1ecdc m\u00e1y t\u00ednh.<\/span><\/p>\n

Excel 2016 \u0111\u00e3 \u0111\u01b0\u1ee3c ph\u00e1t h\u00e0nh v\u00e0 Power Query \u0111\u01b0\u1ee3c t\u00edch h\u1ee3p tr\u1ef1c ti\u1ebfp v\u00e0o Excel (m\u1eb7c d\u00f9 b\u00e2y gi\u1edd n\u00f3 \u0111\u01b0\u1ee3c bi\u1ebft \u0111\u1ebfn Get & Transform). T\u00f4i kh\u00f4ng c\u00f3 l\u00fd do g\u00ec \u0111\u1ec3 kh\u00f4ng t\u1ea3i xu\u1ed1ng ho\u1eb7c c\u00e0i \u0111\u1eb7t. T\u00f4i \u0111\u00e3 m\u1edf giao di\u1ec7n Power Query. Ph\u1ea3n \u1ee9ng t\u1ee9c th\u00ec c\u1ee7a t\u00f4i l\u00e0 \u201cKh\u00f3 qu\u00e1, kh\u00f4ng hi\u1ec3u, th\u1ea5y l\u00e3ng ph\u00ed th\u1eddi gian, t\u00f4i bi\u1ebft s\u1ebd nh\u01b0 v\u1eady.\u201d<\/span><\/p>\n

M\u1ed9t n\u0103m tr\u00f4i qua, t\u00f4i t\u00ecnh c\u1edd th\u1ea5y m\u1ed9t s\u1ed1 webinar tr\u00ean youtube. T\u00f4i b\u1eaft \u0111\u1ea7u suy suy ngh\u0129 l\u1ea1i; \u0111\u00f3 l\u00e0 Power Query h\u1ee3p l\u00fd \u0111\u1ea7u ti\u00ean m\u00e0 t\u00f4i ngh\u0129 r\u1eb1ng: \u201cPowerQuery kh\u00f4ng ch\u1ec9 d\u00e0nh cho d\u1eef li\u1ec7u r\u1ed3i m\u00e0 c\u00f2n d\u00e0nh cho t\u1ea5t c\u1ea3 c\u00e1c d\u1eef li\u1ec7u! Vi\u1ec7c chuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u c\u00f3 th\u1ec3 \u0111\u01a1n gi\u1ea3n nh\u01b0 chuy\u1ec3n m\u1ed9t b\u1ea3ng. \u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 gi\u00fap t\u00f4i ti\u1ebft ki\u1ec7m h\u00e0ng gi\u1edd \u0111\u1ed3ng h\u1ed3 v\u00e0 r\u1ea5t nhi\u1ec1u m\u00e3 VBA kh\u00f3. T\u1ea1i sao kh\u00f4ng ai n\u00f3i v\u1edbi t\u00f4i \u0111i\u1ec1u n\u00e0y tr\u01b0\u1edbc \u0111\u00f3\u2026 oh ch\u1edd \u0111\u00e3\u2026 h\u1ecd \u0111\u00e3 l\u00e0m!\u201d<\/span><\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

\u0110\u00e2y l\u00e0 c\u00e1ch cu\u1ed1i c\u00f9ng t\u00f4i \u0111\u00e3 ti\u1ebfp c\u1eadn Power Query. K\u1ec3 t\u1eeb \u0111\u00f3, m\u1ecdi ng\u01b0\u1eddi s\u1eb5n s\u00e0ng chia s\u1ebb t\u1ea5t c\u1ea3 ki\u1ebfn th\u1ee9c c\u1ee7a h\u1ecd v\u1ec1 Power Query. T\u00f4i \u0111\u00e3 nghi\u00ean c\u1ee9u v\u1ec1 Power Query v\u00e0 Powerpivot v\u00e0 b\u00e2y gi\u1edd t\u00f4i d\u1ef1a v\u00e0o c\u00e1c c\u00f4ng c\u1ee5 n\u00e0y \u0111\u1ec3 ti\u1ebft ki\u1ec7m th\u1eddi gian m\u1ed7i ng\u00e0y.<\/span><\/p>\n

Th\u1eadt kh\u00f4ng may, n\u1ebfu b\u1ea1n h\u1ecfi h\u1ea7u h\u1ebft ng\u01b0\u1eddi d\u00f9ng Excel n\u1ebfu h\u1ecd s\u1eed d\u1ee5ng Power Query, h\u1ecd s\u1ebd nh\u00ecn b\u1ea1n m\u1ed9t c\u00e1ch tr\u1ed1ng r\u1ed7ng, h\u1ecd kh\u00f4ng bi\u1ebft \u0111\u00f3 l\u00e0 g\u00ec. T\u00f4i mu\u1ed1n thay \u0111\u1ed5i \u0111i\u1ec1u \u0111\u00f3, v\u00ec v\u1eady trong m\u1ed9t v\u00e0i b\u00e0i \u0111\u0103ng t\u00f4i s\u1ebd t\u1eadp trung v\u00e0o vi\u1ec7c s\u1eed d\u1ee5ng Power Query.<\/span><\/p>\n

N\u1ebfu b\u1ea1n \u0111ang \u0111\u1ecdc \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y, th\u00ec r\u1ea5t c\u00f3 th\u1ec3 b\u1ea1n c\u0169ng v\u1eeba ti\u1ebfp c\u1eadn Power Query. T\u1ea5t c\u1ea3 nh\u1eefng g\u00ec t\u00f4i c\u00f3 th\u1ec3 n\u00f3i v\u1edbi b\u1ea1n l\u00e0: \u201cN\u00e0y, b\u1ea1n \u0111\u00e3 th\u00e0nh c\u00f4ng, \u0111i\u1ec1u \u0111\u00f3 th\u1eadt tuy\u1ec7t v\u1eddi. Th\u1eadt tuy\u1ec7t khi b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ebfn. \u0110\u1ec3 t\u00f4i h\u01b0\u1edbng d\u1eabn b\u1ea1n\u201d. \ud83d\ude42<\/span><\/p>\n

\n

Xem nhanh<\/p>\n