{"id":224229,"date":"2023-06-27T10:41:23","date_gmt":"2023-06-27T03:41:23","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=224229"},"modified":"2023-06-27T10:41:23","modified_gmt":"2023-06-27T03:41:23","slug":"hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\/","title":{"rendered":"H\u1ecdc Excel c\u01a1 b\u1ea3n t\u1eeb A-Z c\u1ef1c chi ti\u1ebft, d\u1ec5 hi\u1ec3u d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi"},"content":{"rendered":"

Microsoft Excel \u0111\u01b0\u1ee3c bi\u1ebft \u0111\u1ebfn l\u00e0 m\u1ed9t ph\u1ea7n m\u1ec1m h\u1ed7 tr\u1ee3 x\u1eed l\u00fd s\u1ed1 li\u1ec7u, ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u00e0 th\u1eadm ch\u00ed l\u00e0 c\u1ea3 l\u1eadp tr\u00ecnh \u0111\u01b0\u1ee3c ph\u00e1t tri\u1ec3n b\u1edfi Microsoft. Trong b\u00e0i vi\u1ebft n\u00e0y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd gi\u00fap b\u1ea1n t\u1ef1 h\u1ecdc Excel c\u01a1 b\u1ea3n<\/strong> hi\u1ec7u qu\u1ea3 nh\u1edd h\u01b0\u1edbng d\u1eabn t\u1eebng b\u01b0\u1edbc t\u1eeb giai \u0111o\u1ea1n ban \u0111\u1ea7u.<\/p>\n

S\u01a1 l\u01b0\u1ee3c v\u1ec1 ph\u1ea7n m\u1ec1m Microsoft Excel<\/h2>\n

Khi s\u1eed d\u1ee5ng Excel, b\u1ea1n c\u00f3 th\u1ec3 l\u01b0u tr\u1eef d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch c\u00f3 h\u1ec7 th\u1ed1ng trong c\u00e1c \u00f4, d\u00f2ng v\u00e0 c\u1ed9t. \u0110\u1ed3ng th\u1eddi, ph\u1ea7n m\u1ec1m n\u00e0y c\u00f2n cung c\u1ea5p m\u1ed9t lo\u1ea1t c\u00e1c c\u00f4ng c\u1ee5 cho vi\u1ec7c t\u00ednh to\u00e1n, x\u1eed l\u00fd v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u, bao g\u1ed3m c\u1ea3 h\u00e0m, c\u00f4ng th\u1ee9c v\u00e0 c\u00e1c lo\u1ea1i bi\u1ec3u \u0111\u1ed3.<\/p>\n

\"hoc-excel-co-ban-so-luoc-ve-excel\"<\/picture><\/p>\n

M\u1ed9t s\u1ed1 ch\u1ee9c n\u0103ng ch\u00ednh c\u1ee7a Excel<\/h3>\n

C\u00e1c ch\u1ee9c n\u0103ng ch\u00ednh c\u1ee7a Excel bao g\u1ed3m: qu\u1ea3n l\u00fd d\u1eef li\u1ec7u, t\u1ea1o bi\u1ec3u \u0111\u1ed3, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c v\u00e0 h\u00e0m, l\u1eadp tr\u00ecnh VBA, ph\u00e2n t\u00edch d\u1eef li\u1ec7u (v\u1edbi Pivot Tables v\u00e0 Power Pivot) v\u00e0 nhi\u1ec1u h\u01a1n n\u1eefa. B\u1eb1ng c\u00e1ch h\u1ecdc Excel c\u01a1 b\u1ea3n<\/strong>, b\u1ea1n s\u1ebd n\u1eafm b\u1eaft \u0111\u01b0\u1ee3c nh\u1eefng k\u1ef9 n\u0103ng c\u1ea7n thi\u1ebft \u0111\u1ec3 s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3 nh\u1eefng ch\u1ee9c n\u0103ng n\u00e0y.<\/p>\n

S\u1ef1 c\u1ea7n thi\u1ebft c\u1ee7a vi\u1ec7c h\u1ecdc Excel<\/h3>\n

Trong th\u1eddi \u0111\u1ea1i s\u1ed1 h\u00f3a ng\u00e0y c\u00e0ng ph\u00e1t tri\u1ec3n nh\u01b0 hi\u1ec7n nay th\u00ec vi\u1ec7c bi\u1ebft s\u1eed d\u1ee5ng Excel l\u00e0 m\u1ed9t l\u1ee3i th\u1ebf l\u1edbn. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng Excel trong nhi\u1ec1u l\u0129nh v\u1ef1c kh\u00e1c nhau, t\u1eeb kinh doanh, gi\u00e1o d\u1ee5c, khoa h\u1ecdc, th\u1ed1ng k\u00ea, ng\u00e2n h\u00e0ng v\u00e0 c\u1ea3 nh\u1eefng c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y. B\u1edfi v\u1eady, vi\u1ec7c h\u1ecdc Excel c\u01a1 b\u1ea3n cho ng\u01b0\u1eddi \u0111i l\u00e0m<\/strong>\u00a0kh\u00f4ng ch\u1ec9 gi\u00fap b\u1ea1n n\u00e2ng cao k\u1ef9 n\u0103ng c\u00f4ng vi\u1ec7c m\u00e0 c\u00f2n gi\u00fap b\u1ea1n \u0111\u1ea1t \u0111\u01b0\u1ee3c nhi\u1ec1u m\u1ee5c ti\u00eau kh\u00e1c trong cu\u1ed9c s\u1ed1ng.<\/p>\n

B\u1eaft \u0111\u1ea7u v\u1edbi h\u1ecdc Excel c\u01a1 b\u1ea3n<\/h2>\n

H\u00e3y b\u1eaft \u0111\u1ea7u h\u00e0nh tr\u00ecnh h\u1ecdc Excel c\u1ee7a b\u1ea1n b\u1eb1ng vi\u1ec7c t\u00ecm hi\u1ec3u c\u00e1ch c\u00e0i \u0111\u1eb7t, m\u1edf Excel v\u00e0 l\u00e0m quen v\u1edbi giao di\u1ec7n c\u1ee7a n\u00f3.<\/p>\n

C\u00e0i \u0111\u1eb7t v\u00e0 m\u1edf Excel<\/h3>\n

Tr\u01b0\u1edbc khi b\u1eaft \u0111\u1ea7u s\u1eed d\u1ee5ng Excel, b\u1ea1n c\u1ea7n ph\u1ea3i \u0111\u1ea3m b\u1ea3o m\u00ecnh \u0111\u00e3 c\u00e0i \u0111\u1eb7t b\u1ed9 Microsoft Office<\/a><\/strong> l\u00ean m\u00e1y t\u00ednh c\u00e1 nh\u00e2n. B\u1ed9 n\u00e0y bao g\u1ed3m Excel c\u00f9ng v\u1edbi c\u00e1c \u1ee9ng d\u1ee5ng kh\u00e1c nh\u01b0 Word, PowerPoint, Outlook v\u00e0 nhi\u1ec1u h\u01a1n n\u1eefa.<\/p>\n

B\u1ea1n c\u00f3 th\u1ec3 mua b\u1ea3n quy\u1ec1n t\u1eeb trang web ch\u00ednh th\u1ee9c c\u1ee7a Microsoft ho\u1eb7c s\u1eed d\u1ee5ng phi\u00ean b\u1ea3n mi\u1ec5n ph\u00ed tr\u1ef1c tuy\u1ebfn Excel Online. Sau khi c\u00e0i \u0111\u1eb7t, h\u00e3y m\u1edf \u1ee9ng d\u1ee5ng Excel l\u00ean v\u00e0 b\u1eaft \u0111\u1ea7u th\u1ef1c h\u00e0nh. N\u1ebfu ch\u01b0a bi\u1ebft c\u00e1ch t\u1ea3i v\u00e0 c\u00e0i \u0111\u1eb7t c\u00e1c phi\u00ean b\u1ea3n Excel, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o b\u00e0i vi\u1ebft li\u00ean quan t\u1ea1i trang tin nhanh<\/a><\/strong> c\u1ee7a Ho\u00e0ng H\u00e0 Mobile.<\/p>\n

Gi\u1edbi thi\u1ec7u v\u1ec1 c\u00e1c th\u00e0nh ph\u1ea7n c\u00f3 trong giao di\u1ec7n Excel<\/h3>\n

\"hoc-excel-co-ban-giao-dien-chinh\"<\/picture><\/p>\n

Ribbon<\/strong>: Ribbon l\u00e0 thanh c\u00f4ng c\u1ee5 ch\u00ednh c\u1ee7a Excel, n\u1eb1m ngang \u1edf \u0111\u1ea7u c\u1eeda s\u1ed5. N\u00f3 ch\u1ee9a c\u00e1c tab nh\u01b0 Home, Insert, Page Layout, Formulas v\u00e0 nhi\u1ec1u h\u01a1n n\u1eefa. M\u1ed7i tab l\u1ea1i ch\u1ee9a c\u00e1c nh\u00f3m l\u1ec7nh li\u00ean quan, qua \u0111\u00f3 h\u1ed7 tr\u1ee3 b\u1ea1n truy c\u1eadp nhanh v\u00e0o c\u00e1c c\u00f4ng c\u1ee5 v\u00e0 ch\u1ee9c n\u0103ng m\u00e0 Excel cung c\u1ea5p.<\/p>\n

Trang t\u00ednh<\/strong>: Khi m\u1edf m\u1ed9t workbook m\u1edbi trong Excel, b\u1ea1n s\u1ebd th\u1ea5y m\u1ed9t trang t\u00ednh. M\u1ed7i trang t\u00ednh g\u1ed3m h\u00e0ng ngh\u00ecn d\u00f2ng (\u0111\u01b0\u1ee3c \u0111\u00e1nh s\u1ed1 t\u1eeb 1 tr\u1edf \u0111i) v\u00e0 c\u1ed9t (\u0111\u01b0\u1ee3c \u0111\u00e1nh ch\u1eef t\u1eeb A tr\u1edf \u0111i). Trang t\u00ednh l\u00e0 n\u01a1i b\u1ea1n nh\u1eadp v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u.<\/p>\n

\u00d4, d\u00f2ng, v\u00e0 c\u1ed9t<\/strong>: \u00d4 l\u00e0 \u0111\u01a1n v\u1ecb c\u01a1 b\u1ea3n nh\u1ea5t c\u1ee7a trang t\u00ednh, n\u1eb1m \u1edf giao \u0111i\u1ec3m gi\u1eefa d\u00f2ng v\u00e0 c\u1ed9t. Theo \u0111\u00f3, \u00f4 c\u00f3 th\u1ec3 ch\u1ee9a d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1, v\u0103n b\u1ea3n, c\u00f4ng th\u1ee9c ho\u1eb7c h\u00e0m. \u0110\u1ed3ng th\u1eddi, d\u00f2ng v\u00e0 c\u1ed9t gi\u00fap b\u1ea1n t\u1ed5 ch\u1ee9c v\u00e0 qu\u1ea3n l\u00fd d\u1eef li\u1ec7u trong trang t\u00ednh.<\/p>\n

T\u1ea1o v\u00e0 l\u01b0u m\u1ed9t workbook m\u1edbi<\/h3>\n

\"hoc-excel-co-ban-tao-workbook\"<\/picture><\/p>\n

\u0110\u1ec3 t\u1ea1o m\u1ed9t workbook m\u1edbi, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5p v\u00e0o “File” tr\u00ean Ribbon, sau \u0111\u00f3 ch\u1ecdn “New” v\u00e0 nh\u1ea5p v\u00e0o “Blank Workbook”. Workbook m\u1edbi s\u1ebd m\u1edf ra v\u1edbi m\u1ed9t trang t\u00ednh tr\u1ed1ng.<\/p>\n

\u0110\u1ec3 l\u01b0u workbook, b\u1ea1n nh\u1ea5p v\u00e0o “File”, ch\u1ecdn “Save As”, ch\u1ecdn v\u1ecb tr\u00ed l\u01b0u tr\u00ean m\u00e1y t\u00ednh c\u1ee7a b\u1ea1n, \u0111\u1eb7t t\u00ean cho workbook v\u00e0 nh\u1ea5p v\u00e0o “Save”. \u0110\u1ea3m b\u1ea3o b\u1ea1n l\u01b0u workbook th\u01b0\u1eddng xuy\u00ean khi h\u1ecdc excel c\u01a1 b\u1ea3n \u0111\u1ec3 kh\u00f4ng m\u1ea5t d\u1eef li\u1ec7u.<\/p>\n

B\u1eb1ng c\u00e1ch h\u1ecdc v\u00e0 th\u1ef1c h\u00e0nh c\u00e1c b\u01b0\u1edbc tr\u00ean, b\u1ea1n s\u1ebd n\u1eafm b\u1eaft \u0111\u01b0\u1ee3c nh\u1eefng ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n \u0111\u1ea7u ti\u00ean trong h\u00e0nh tr\u00ecnh h\u1ecdc Excel c\u01a1 b\u1ea3n<\/strong> c\u1ee7a m\u00ecnh.<\/p>\n

L\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u trong Excel<\/h2>\n

Sau khi b\u1ea1n \u0111\u00e3 h\u1ecdc c\u00e1ch m\u1edf v\u00e0 t\u1ea1o m\u1ed9t workbook m\u1edbi, h\u00e3y b\u1eaft \u0111\u1ea7u l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u trong Excel.<\/p>\n

Nh\u1eadp v\u00e0 ch\u1ec9nh s\u1eeda d\u1eef li\u1ec7u<\/h3>\n

\u0110\u1ec3 nh\u1eadp d\u1eef li\u1ec7u, h\u00e3y nh\u1ea5p v\u00e0o \u00f4 b\u1ea1n mu\u1ed1n nh\u1eadp v\u00e0 b\u1eaft \u0111\u1ea7u g\u00f5. B\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp v\u0103n b\u1ea3n, s\u1ed1, ng\u00e0y, gi\u1edd, v\u00e0 th\u1eadm ch\u00ed c\u00f4ng th\u1ee9c. \u0110\u1ec3 ch\u1ec9nh s\u1eeda d\u1eef li\u1ec7u \u0111\u00e3 nh\u1eadp, h\u00e3y nh\u1ea5p v\u00e0o \u00f4 ch\u1ee9a d\u1eef li\u1ec7u \u0111\u00f3 v\u00e0 b\u1eaft \u0111\u1ea7u ch\u1ec9nh s\u1eeda ngay trong \u00f4 ho\u1eb7c trong thanh c\u00f4ng c\u1ee5 \u1edf tr\u00ean.<\/p>\n

\"hoc-excel-co-ban-nhap-va-chinh-sua-du-lieu\"<\/picture><\/p>\n

S\u1eafp x\u1ebfp v\u00e0 l\u1ecdc d\u1eef li\u1ec7u<\/h3>\n

Excel cung c\u1ea5p c\u00e1c c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd \u0111\u1ec3 s\u1eafp x\u1ebfp v\u00e0 l\u1ecdc d\u1eef li\u1ec7u. \u0110\u1ec3 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u, h\u00e3y ch\u1ecdn c\u1ed9t b\u1ea1n mu\u1ed1n s\u1eafp x\u1ebfp, nh\u1ea5p v\u00e0o “Sort & Filter” trong tab “Home” tr\u00ean Ribbon, v\u00e0 ch\u1ecdn c\u00e1ch b\u1ea1n mu\u1ed1n s\u1eafp x\u1ebfp (A to Z, Z to A, ho\u1eb7c Custom Sort). \u0110\u1ec3 l\u1ecdc d\u1eef li\u1ec7u, h\u00e3y nh\u1ea5p v\u00e0o “Filter” trong “Sort & Filter”, v\u00e0 ch\u1ecdn \u0111i\u1ec1u ki\u1ec7n l\u1ecdc b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng.<\/p>\n

\"hoc-excel-co-ban-sap-xep-va-loc-du-lieu\"<\/picture><\/p>\n

C\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c v\u00e0 h\u00e0m khi h\u1ecdc Exel c\u01a1 b\u1ea3n<\/h3>\n

C\u00f3 th\u1ec3 nh\u1eadn th\u1ea5y, c\u00f4ng th\u1ee9c v\u00e0 h\u00e0m l\u00e0 tr\u00e1i tim c\u1ee7a Excel h\u1ed7 tr\u1ee3 ng\u01b0\u1eddi d\u00f9ng t\u00ednh to\u00e1n v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3. \u0110\u1ec3 s\u1eed d\u1ee5ng ch\u00fang, b\u1ea1n b\u1eaft \u0111\u1ea7u b\u1eb1ng d\u1ea5u b\u1eb1ng (=), sau \u0111\u00f3 nh\u1eadp t\u00ean h\u00e0m (nh\u01b0 SUM, AVERAGE, VLOOKUP) ho\u1eb7c c\u00f4ng th\u1ee9c b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng. \u0110\u1eebng qu\u00ean \u0111\u00f3ng ngo\u1eb7c sau khi nh\u1eadp c\u00e1c tham s\u1ed1 cho h\u00e0m.<\/p>\n

\"hoc-excel-co-ban-cac-ham\"<\/picture><\/p>\n

C\u00e1c ki\u1ec3u d\u1eef li\u1ec7u trong Excel<\/h3>\n

Trong qu\u00e1 tr\u00ecnh h\u1ecdc Excel c\u01a1 b\u1ea3n<\/strong>, b\u1ea1n s\u1ebd nhanh ch\u00f3ng nh\u1eadn ra r\u1eb1ng vi\u1ec7c hi\u1ec3u c\u00e1c ki\u1ec3u d\u1eef li\u1ec7u trong Excel kh\u00f4ng ch\u1ec9 gi\u00fap c\u00f4ng vi\u1ec7c tr\u1edf n\u00ean d\u1ec5 d\u00e0ng h\u01a1n m\u00e0 c\u00f2n \u0111\u00f3ng vai tr\u00f2 quan tr\u1ecdng trong vi\u1ec7c \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c c\u1ee7a d\u1eef li\u1ec7u. Excel cung c\u1ea5p nhi\u1ec1u ki\u1ec3u d\u1eef li\u1ec7u kh\u00e1c nhau \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m vi\u1ec7c m\u1ed9t c\u00e1ch linh ho\u1ea1t v\u1edbi d\u1eef li\u1ec7u.<\/p>\n

Ki\u1ec3u d\u1eef li\u1ec7u chu\u1ed7i<\/strong> trong Excel ch\u1ee9a c\u00e1c k\u00fd t\u1ef1 v\u0103n b\u1ea3n bao g\u1ed3m ch\u1eef c\u00e1i t\u1eeb A – Z, s\u1ed1 v\u00e0 c\u00e1c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t. D\u00f9 ch\u1ec9 c\u00f3 m\u1ed9t k\u00fd t\u1ef1 s\u1ed1 trong chu\u1ed7i, Excel c\u0169ng coi \u0111\u00f3 l\u00e0 ki\u1ec3u d\u1eef li\u1ec7u chu\u1ed7i, gi\u00fap b\u1ea1n gi\u1eef nguy\u00ean \u0111\u1ecbnh d\u1ea1ng c\u1ee7a d\u1eef li\u1ec7u.<\/p>\n

Ki\u1ec3u d\u1eef li\u1ec7u s\u1ed1<\/strong> bao g\u1ed3m c\u00e1c s\u1ed1 nguy\u00ean v\u00e0 s\u1ed1 th\u1eadp ph\u00e2n, d\u01b0\u01a1ng ho\u1eb7c \u00e2m. \u0110\u00e2y l\u00e0 ki\u1ec3u d\u1eef li\u1ec7u r\u1ea5t ph\u1ed5 bi\u1ebfn khi b\u1ea1n c\u1ea7n th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh to\u00e1n h\u1ecdc.<\/p>\n

Ki\u1ec3u d\u1eef li\u1ec7u th\u1eddi gian<\/strong> cho ph\u00e9p b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi ng\u00e0y, th\u00e1ng, n\u0103m v\u00e0 th\u1eddi gian trong ng\u00e0y. Excel t\u1ef1 \u0111\u1ed9ng nh\u1eadn d\u1ea1ng v\u00e0 chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian khi b\u1ea1n nh\u1eadp, gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng s\u1eafp x\u1ebfp v\u00e0 t\u00ednh to\u00e1n th\u1eddi gian.<\/p>\n

Ki\u1ec3u d\u1eef li\u1ec7u Boolean<\/strong> tr\u1ea3 v\u1ec1 hai gi\u00e1 tr\u1ecb: True (\u0111\u00fang) v\u00e0 False (sai), th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong c\u00e1c ph\u00e9p so s\u00e1nh v\u00e0 \u0111i\u1ec1u ki\u1ec7n.<\/p>\n

Cu\u1ed1i c\u00f9ng, ki\u1ec3u d\u1eef li\u1ec7u c\u00f4ng th\u1ee9c<\/strong> l\u00e0 lo\u1ea1i d\u1eef li\u1ec7u linh ho\u1ea1t gi\u00fap b\u1ea1n t\u1eadn d\u1ee5ng t\u1ed1i \u0111a kh\u1ea3 n\u0103ng t\u00ednh to\u00e1n c\u1ee7a Excel. Bao g\u1ed3m c\u00e1c to\u00e1n t\u1eed nh\u01b0 c\u1ed9ng, tr\u1eeb, nh\u00e2n, chia, ho\u1eb7c s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c v\u00e0 h\u00e0m c\u00f3 s\u1eb5n trong Excel nh\u01b0 SUM, AVERAGE, VLOOKUP v\u00e0 nhi\u1ec1u h\u01a1n n\u1eefa.<\/p>\n

\u0110\u1ecbnh d\u1ea1ng v\u00e0 t\u00f9y ch\u1ec9nh trong Excel<\/h2>\n

Khi \u0111\u00e3 ho\u00e0n th\u00e0nh qu\u00e1 tr\u00ecnh nh\u1eadp v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u, b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng v\u00e0 t\u00f9y ch\u1ec9nh workbook c\u1ee7a m\u00ecnh \u0111\u1ec3 d\u1ec5 nh\u00ecn h\u01a1n. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng v\u00e0 t\u00f9y ch\u1ec9nh m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng khi h\u1ecdc Excel c\u01a1 b\u1ea3n<\/strong>.<\/p>\n

\u0110\u1ecbnh d\u1ea1ng \u00f4 v\u00e0 d\u1eef li\u1ec7u khi h\u1ecdc Excel c\u01a1 b\u1ea3n<\/h3>\n

\u0110\u1ec3 \u0111\u1ecbnh d\u1ea1ng \u00f4, ch\u1ecdn c\u00e1c \u00f4 b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng, sau \u0111\u00f3 ch\u1ecdn c\u00e1c l\u1ef1a ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng mong mu\u1ed1n t\u1eeb tab “Home” tr\u00ean Ribbon. B\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i ki\u1ec3u ch\u1eef, k\u00edch th\u01b0\u1edbc, m\u00e0u s\u1eafc v\u00e0 nhi\u1ec1u thu\u1ed9c t\u00ednh kh\u00e1c c\u1ee7a \u00f4 v\u00e0 d\u1eef li\u1ec7u.<\/p>\n

\"hoc-excel-co-ban-dinh-dang-o\"<\/picture><\/p>\n

S\u1eed d\u1ee5ng c\u00e1c \u0111\u1ed3 th\u1ecb c\u00f3 s\u1eb5n trong Excel<\/h3>\n

Excel cung c\u1ea5p nhi\u1ec1u lo\u1ea1i \u0111\u1ed3 th\u1ecb kh\u00e1c nhau \u0111\u1ec3 ng\u01b0\u1eddi d\u00f9ng tr\u1ef1c quan h\u00f3a d\u1eef li\u1ec7u. \u0110\u1ec3 t\u1ea1o m\u1ed9t \u0111\u1ed3 th\u1ecb, ch\u1ecdn d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n tr\u1ef1c quan, nh\u1ea5p v\u00e0o “Insert” tr\u00ean Ribbon, v\u00e0 ch\u1ecdn lo\u1ea1i \u0111\u1ed3 th\u1ecb b\u1ea1n mu\u1ed1n t\u1ea1o.<\/p>\n

\"hoc-excel-co-ban-do-thi\"<\/picture><\/p>\n

T\u1ea1o v\u00e0 qu\u1ea3n l\u00fd b\u1ea3ng trong Excel<\/h3>\n

\u0110\u1ec3 t\u1ea1o m\u1ed9t b\u1ea3ng, ch\u1ecdn d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n chuy\u1ec3n th\u00e0nh b\u1ea3ng, nh\u1ea5p v\u00e0o “Insert” v\u00e0 sau \u0111\u00f3 ch\u1ecdn “Table”. B\u1ea3ng trong Excel gi\u00fap b\u1ea1n qu\u1ea3n l\u00fd v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3.<\/p>\n

\"hoc-excel-co-ban-tao-bang\"<\/picture><\/p>\n

C\u00e1c ch\u1ee9c n\u0103ng n\u00e2ng cao c\u1ee7a Excel<\/h2>\n

H\u1ecdc excel c\u01a1 b\u1ea3n<\/strong> l\u00e0 b\u01b0\u1edbc \u0111\u1ea7u nh\u01b0ng \u0111\u1ec3 tr\u1edf th\u00e0nh ng\u01b0\u1eddi s\u1eed d\u1ee5ng chuy\u00ean nghi\u1ec7p th\u00ec b\u1ea1n c\u1ea7n ph\u1ea3i n\u1eafm v\u1eefng c\u00e1c ch\u1ee9c n\u0103ng n\u00e2ng cao.<\/p>\n

Pivot Table<\/h3>\n

Pivot Table l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd cho ph\u00e9p b\u1ea1n ph\u00e2n t\u00edch v\u00e0 t\u00f3m t\u1eaft d\u1eef li\u1ec7u l\u1edbn m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng. \u0110\u1ec3 t\u1ea1o m\u1ed9t Pivot Table, h\u00e3y ch\u1ecdn d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n, nh\u1ea5p v\u00e0o “Insert” v\u00e0 sau \u0111\u00f3 ch\u1ecdn “PivotTable”. B\u1ea1n s\u1ebd c\u00f3 th\u1ec3 ch\u1ecdn c\u00e1c tr\u01b0\u1eddng d\u1eef li\u1ec7u \u0111\u1ec3 t\u1ed5ng h\u1ee3p v\u00e0 Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng t\u1ea1o ra b\u1ea3ng t\u1ed5ng h\u1ee3p cho b\u1ea1n.<\/p>\n

\"hoc-excel-co-ban-pivot-table\"<\/picture><\/p>\n

VLOOKUP v\u00e0 HLOOKUP<\/h3>\n

VLOOKUP (Vertical Lookup) v\u00e0 HLOOKUP (Horizontal Lookup) l\u00e0 hai h\u00e0m t\u00ecm ki\u1ebfm m\u1ea1nh m\u1ebd gi\u00fap b\u1ea1n t\u00ecm ki\u1ebfm v\u00e0 tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u l\u1edbn. VLOOKUP t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u theo c\u1ed9t, trong khi HLOOKUP t\u00ecm ki\u1ebfm theo h\u00e0ng. C\u1ea3 hai h\u00e0m \u0111\u1ec1u y\u00eau c\u1ea7u b\u1ea1n cung c\u1ea5p gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm, v\u1ecb tr\u00ed c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u, v\u00e0 c\u1ed9t (ho\u1eb7c h\u00e0ng) b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u.<\/p>\n

\"hoc-excel-co-ban-ham-vlookup-va-hlookup\"<\/picture><\/p>\n

Conditional Formatting<\/h3>\n

Conditional Formatting cho ph\u00e9p b\u1ea1n \u0111\u1ecbnh d\u1ea1ng \u00f4 d\u1ef1a tr\u00ean \u0111i\u1ec1u ki\u1ec7n b\u1ea1n \u0111\u1eb7t ra. \u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng nh\u1eadn bi\u1ebft xu h\u01b0\u1edbng, m\u1eabu, v\u00e0 ngo\u1ea1i l\u1ec7 trong d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh. \u0110\u1ec3 s\u1eed d\u1ee5ng Conditional Formatting, ch\u1ecdn c\u00e1c \u00f4 b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng, nh\u1ea5p v\u00e0o “Conditional Formatting” trong tab “Home” tr\u00ean Ribbon, v\u00e0 \u0111\u1eb7t \u0111i\u1ec1u ki\u1ec7n c\u1ee7a b\u1ea1n.<\/p>\n

\"hoc-excel-co-ban-conditional-formatting\"<\/picture><\/p>\n

M\u1eb9o v\u00e0 th\u1ee7 thu\u1eadt khi s\u1eed d\u1ee5ng Excel<\/h2>\n

Gi\u1ed1ng nh\u01b0 \u0111a s\u1ed1 c\u00e1c ph\u1ea7n m\u1ec1m kh\u00e1c \u0111\u1ebfn t\u1eeb Microsoft, Excel c\u0169ng c\u00f3 r\u1ea5t nhi\u1ec1u m\u1eb9o v\u00e0 th\u1ee7 thu\u1eadt \u0111\u1ec3 gi\u00fap ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3 h\u01a1n. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 m\u1eb9o v\u00e0 th\u1ee7 thu\u1eadt gi\u00fap b\u1ea1n s\u1eed d\u1ee5ng ph\u1ea7n m\u1ec1m n\u00e0y hi\u1ec7u qu\u1ea3, ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c h\u01a1n.<\/p>\n

\"hoc-excel-co-ban-meo-va-thu-thuat\"<\/picture><\/p>\n

C\u00e1ch t\u0103ng t\u1ed1c \u0111\u1ed9 l\u00e0m vi\u1ec7c trong Excel<\/h3>\n

M\u1ed9t trong nh\u1eefng c\u00e1ch t\u0103ng t\u1ed1c \u0111\u1ed9 l\u00e0m vi\u1ec7c trong Excel l\u00e0 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c v\u00e0 h\u00e0m t\u1ef1 \u0111\u1ed9ng. H\u00e3y nh\u1edb r\u1eb1ng b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng Fill Handle (g\u00f3c d\u01b0\u1edbi c\u00f9ng b\u00ean ph\u1ea3i c\u1ee7a \u00f4) \u0111\u1ec3 k\u00e9o c\u00e1c c\u00f4ng th\u1ee9c v\u00e0 h\u00e0m xu\u1ed1ng c\u00e1c \u00f4 kh\u00e1c m\u00e0 kh\u00f4ng c\u1ea7n nh\u1eadp l\u1ea1i.<\/p>\n

C\u00e1c ph\u00edm t\u1eaft th\u00f4ng d\u1ee5ng trong Excel<\/h3>\n

Ph\u00edm t\u1eaft c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian khi l\u00e0m vi\u1ec7c trong Excel. M\u1ed9t s\u1ed1 ph\u00edm t\u1eaft th\u00f4ng d\u1ee5ng bao g\u1ed3m Ctrl+C \u0111\u1ec3 sao ch\u00e9p, Ctrl+V \u0111\u1ec3 d\u00e1n v\u00e0 Ctrl+Z \u0111\u1ec3 ho\u00e0n t\u00e1c h\u00e0nh \u0111\u1ed9ng g\u1ea7n nh\u1ea5t. Ngo\u00e0i ra c\u00f2n c\u00f3 r\u1ea5t nhi\u1ec1u ph\u00edm t\u1eaft kh\u00e1c m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m vi\u1ec7c v\u1edbi Excel hi\u1ec7u qu\u1ea3 h\u01a1n.<\/p>\n

C\u00e1ch x\u1eed l\u00fd l\u1ed7i trong Excel<\/h3>\n

Khi l\u00e0m vi\u1ec7c v\u1edbi Excel, b\u1ea1n c\u00f3 th\u1ec3 g\u1eb7p ph\u1ea3i m\u1ed9t s\u1ed1 l\u1ed7i, nh\u01b0 #VALUE!, #REF!, v\u00e0 #NAME?. M\u1ed7i l\u1ed7i n\u00e0y \u0111\u1ec1u c\u00f3 m\u1ed9t nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch gi\u1ea3i quy\u1ebft ri\u00eang. V\u00ed d\u1ee5, l\u1ed7i #VALUE! th\u01b0\u1eddng xu\u1ea5t hi\u1ec7n khi m\u1ed9t c\u00f4ng th\u1ee9c kh\u00f4ng th\u1ec3 gi\u1ea3i quy\u1ebft d\u1eef li\u1ec7u b\u1ea1n \u0111\u00e3 nh\u1eadp, trong khi l\u1ed7i #REF! xu\u1ea5t hi\u1ec7n khi m\u1ed9t tham chi\u1ebfu kh\u00f4ng h\u1ee3p l\u1ec7. \u0110\u1ec3 gi\u1ea3i quy\u1ebft nh\u1eefng l\u1ed7i n\u00e0y, h\u00e3y \u0111\u1ea3m b\u1ea3o r\u1eb1ng d\u1eef li\u1ec7u v\u00e0 tham chi\u1ebfu c\u1ee7a b\u1ea1n \u0111\u00fang.<\/p>\n

V\u1edbi nh\u1eefng ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n tr\u00ean, Ho\u00e0ng H\u00e0 Mobile tin r\u1eb1ng b\u1ea1n \u0111\u00e3 s\u1eb5n s\u00e0ng \u0111\u1ec3 b\u1eaft \u0111\u1ea7u h\u1ecdc Excel c\u01a1 b\u1ea3n<\/strong> m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3. Hi v\u1ecdng r\u1eb1ng b\u1ea1n \u0111\u00e3 c\u00f3 c\u00e1i nh\u00ecn s\u01a1 l\u01b0\u1ee3c h\u01a1n v\u1ec1 c\u00f4ng c\u1ee5 ph\u1ed5 bi\u1ebfn n\u00e0y, n\u1ebfu c\u00f3 b\u1ea5t k\u00ec th\u1eafc m\u1eafc n\u00e0o li\u00ean quan \u0111\u1ebfn qu\u00e1 tr\u00ecnh t\u1ef1 h\u1ecdc Excel th\u00ec h\u00e3y li\u00ean h\u1ec7 v\u1edbi ch\u00fang t\u00f4i \u0111\u1ec3 \u0111\u01b0\u1ee3c gi\u1ea3i \u0111\u00e1p s\u1edbm nh\u1ea5t.<\/p>\n","protected":false},"excerpt":{"rendered":"

Microsoft Excel \u0111\u01b0\u1ee3c bi\u1ebft \u0111\u1ebfn l\u00e0 m\u1ed9t ph\u1ea7n m\u1ec1m h\u1ed7 tr\u1ee3 x\u1eed l\u00fd s\u1ed1 li\u1ec7u, ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u00e0 th\u1eadm ch\u00ed l\u00e0 c\u1ea3 l\u1eadp tr\u00ecnh \u0111\u01b0\u1ee3c ph\u00e1t tri\u1ec3n b\u1edfi Microsoft. Trong b\u00e0i vi\u1ebft n\u00e0y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd gi\u00fap b\u1ea1n t\u1ef1 h\u1ecdc Excel c\u01a1 b\u1ea3n hi\u1ec7u qu\u1ea3 nh\u1edd h\u01b0\u1edbng d\u1eabn t\u1eebng b\u01b0\u1edbc t\u1eeb giai […]<\/p>\n","protected":false},"author":68,"featured_media":224231,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16,412],"tags":[],"class_list":["post-224229","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat","category-thu-thuat-may-tinh"],"yoast_head":"\nH\u1ecdc Excel c\u01a1 b\u1ea3n t\u1eeb A-Z c\u1ef1c chi ti\u1ebft, d\u1ec5 hi\u1ec3u d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi<\/title>\n<meta name=\"description\" content=\"H\u01b0\u1edbng d\u1eabn h\u1ecdc Excel c\u01a1 b\u1ea3n th\u00f4ng qua c\u00e1c ki\u1ebfn th\u1ee9c n\u1ec1n t\u1ea3ng, h\u00ecnh minh h\u1ecda r\u00f5 n\u00e9t v\u00e0 ch\u00fa th\u00edch gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng ti\u1ebfp c\u1eadn.\" \/>\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\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u1ecdc Excel c\u01a1 b\u1ea3n t\u1eeb A-Z c\u1ef1c chi ti\u1ebft, d\u1ec5 hi\u1ec3u d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi\" \/>\n<meta property=\"og:description\" content=\"H\u01b0\u1edbng d\u1eabn h\u1ecdc Excel c\u01a1 b\u1ea3n th\u00f4ng qua c\u00e1c ki\u1ebfn th\u1ee9c n\u1ec1n t\u1ea3ng, h\u00ecnh minh h\u1ecda r\u00f5 n\u00e9t v\u00e0 ch\u00fa th\u00edch gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng ti\u1ebfp c\u1eadn.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\/\" \/>\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:published_time\" content=\"2023-06-27T03:41:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/hoc-excel-co-ban-thump.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Th\u1ebf To\u00e0n\" \/>\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=\"Th\u1ebf To\u00e0n\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 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\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\/\"},\"author\":{\"name\":\"Th\u1ebf To\u00e0n\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/aa8601726ba1dd8424c8b81a0c429630\"},\"headline\":\"H\u1ecdc Excel c\u01a1 b\u1ea3n t\u1eeb A-Z c\u1ef1c chi ti\u1ebft, d\u1ec5 hi\u1ec3u d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi\",\"datePublished\":\"2023-06-27T03:41:23+00:00\",\"dateModified\":\"2023-06-27T03:41:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\/\"},\"wordCount\":3163,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/hoc-excel-co-ban-thump.jpg\",\"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\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\/\",\"name\":\"H\u1ecdc Excel c\u01a1 b\u1ea3n t\u1eeb A-Z c\u1ef1c chi ti\u1ebft, d\u1ec5 hi\u1ec3u d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/hoc-excel-co-ban-thump.jpg\",\"datePublished\":\"2023-06-27T03:41:23+00:00\",\"dateModified\":\"2023-06-27T03:41:23+00:00\",\"description\":\"H\u01b0\u1edbng d\u1eabn h\u1ecdc Excel c\u01a1 b\u1ea3n th\u00f4ng qua c\u00e1c ki\u1ebfn th\u1ee9c n\u1ec1n t\u1ea3ng, h\u00ecnh minh h\u1ecda r\u00f5 n\u00e9t v\u00e0 ch\u00fa th\u00edch gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng ti\u1ebfp c\u1eadn.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/hoc-excel-co-ban-thump.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/hoc-excel-co-ban-thump.jpg\",\"width\":1280,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\/#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\u1ecdc Excel c\u01a1 b\u1ea3n t\u1eeb A-Z c\u1ef1c chi ti\u1ebft, d\u1ec5 hi\u1ec3u d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi\"}]},{\"@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\/aa8601726ba1dd8424c8b81a0c429630\",\"name\":\"Th\u1ebf To\u00e0n\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2785518f30b7c0977ff32902ead6f71e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2785518f30b7c0977ff32902ead6f71e?s=96&d=mm&r=g\",\"caption\":\"Th\u1ebf To\u00e0n\"},\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/the-toan\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u1ecdc Excel c\u01a1 b\u1ea3n t\u1eeb A-Z c\u1ef1c chi ti\u1ebft, d\u1ec5 hi\u1ec3u d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi","description":"H\u01b0\u1edbng d\u1eabn h\u1ecdc Excel c\u01a1 b\u1ea3n th\u00f4ng qua c\u00e1c ki\u1ebfn th\u1ee9c n\u1ec1n t\u1ea3ng, h\u00ecnh minh h\u1ecda r\u00f5 n\u00e9t v\u00e0 ch\u00fa th\u00edch gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng ti\u1ebfp c\u1eadn.","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\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u1ecdc Excel c\u01a1 b\u1ea3n t\u1eeb A-Z c\u1ef1c chi ti\u1ebft, d\u1ec5 hi\u1ec3u d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi","og_description":"H\u01b0\u1edbng d\u1eabn h\u1ecdc Excel c\u01a1 b\u1ea3n th\u00f4ng qua c\u00e1c ki\u1ebfn th\u1ee9c n\u1ec1n t\u1ea3ng, h\u00ecnh minh h\u1ecda r\u00f5 n\u00e9t v\u00e0 ch\u00fa th\u00edch gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng ti\u1ebfp c\u1eadn.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-06-27T03:41:23+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/hoc-excel-co-ban-thump.jpg","type":"image\/jpeg"}],"author":"Th\u1ebf To\u00e0n","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Th\u1ebf To\u00e0n","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"14 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\/"},"author":{"name":"Th\u1ebf To\u00e0n","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/aa8601726ba1dd8424c8b81a0c429630"},"headline":"H\u1ecdc Excel c\u01a1 b\u1ea3n t\u1eeb A-Z c\u1ef1c chi ti\u1ebft, d\u1ec5 hi\u1ec3u d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi","datePublished":"2023-06-27T03:41:23+00:00","dateModified":"2023-06-27T03:41:23+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\/"},"wordCount":3163,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/hoc-excel-co-ban-thump.jpg","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\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\/","name":"H\u1ecdc Excel c\u01a1 b\u1ea3n t\u1eeb A-Z c\u1ef1c chi ti\u1ebft, d\u1ec5 hi\u1ec3u d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/hoc-excel-co-ban-thump.jpg","datePublished":"2023-06-27T03:41:23+00:00","dateModified":"2023-06-27T03:41:23+00:00","description":"H\u01b0\u1edbng d\u1eabn h\u1ecdc Excel c\u01a1 b\u1ea3n th\u00f4ng qua c\u00e1c ki\u1ebfn th\u1ee9c n\u1ec1n t\u1ea3ng, h\u00ecnh minh h\u1ecda r\u00f5 n\u00e9t v\u00e0 ch\u00fa th\u00edch gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng ti\u1ebfp c\u1eadn.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/hoc-excel-co-ban-thump.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/hoc-excel-co-ban-thump.jpg","width":1280,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\/#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\u1ecdc Excel c\u01a1 b\u1ea3n t\u1eeb A-Z c\u1ef1c chi ti\u1ebft, d\u1ec5 hi\u1ec3u d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi"}]},{"@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\/aa8601726ba1dd8424c8b81a0c429630","name":"Th\u1ebf To\u00e0n","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2785518f30b7c0977ff32902ead6f71e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2785518f30b7c0977ff32902ead6f71e?s=96&d=mm&r=g","caption":"Th\u1ebf To\u00e0n"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/the-toan\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/224229","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\/68"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=224229"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/224229\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/224231"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=224229"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=224229"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=224229"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}