Top doanh nghiệp đã đăng ký cho nhân viên

Bạn sẽ học được gì?

Hiểu được các quy tắc Trực quan hóa dữ liệu
Nắm được Khi nào thì sử dụng Biểu đồ nào để trực quan
Thành thạo các kỹ thuật vẽ Biểu đồ từ cơ bản đến nâng cao
Thành thạo tất cả các dạng Biểu đồ
Học kỹ thuật tự động hóa với Biểu đồ bằng Slicer, Option Button, Check box ...
Thực hành các Case Study xây dựng Dashboard, Báo cáo Quản trị để ứng dụng trong Công việc

Khoá học này sẽ có:

Video

7h 39m giờ học

Article

0 bài viết chuyên môn

Material

16 tài liệu đính kèm

Exam questions

0 đề thi ghi nhớ kiến thức

Nội dung khoá học

8 Chương . 57 bài giảng . 7h 39m giờ học

1

Bắt đầu

2

Mở đầu về Trực quan hóa dữ liệu với đồ thị, biểu đồ trong Excel

2 bài học thử
3

Tổng quan về biểu đồ và cách tạo biểu đồ trong Excel

2 bài học thử
4

Master các dạng biểu đồ cơ bản

2 bài học thử
5

Các kỹ thuật nâng cao với Biểu đồ, Đồ thị trong Excel

1 bài học thử
6

Kỹ thuật tạo biểu đồ động

1 bài học thử
7

Case Study - Xây dựng Báo cáo Quản trị Doanh số, Khách hàng, Lợi nhuận tổng hợp

8

Bonus - Một số kiến thức mở rộng (Từ khóa học Xây dựng BCQT)

1 bài học thử

Mô tả khoá học

Khi nói tới trực quan, mọi người thường không nói về Excel. Nhưng sự thật là, Excel là một trong những công cụ trực quan hóa dữ liệu cực kỳ mạnh mẽ và linh hoạt trong công việc. Nếu bạn đã từng làm một Biểu đồ, đồ thị Excel nhưng chưa đẹp, chưa thể hiện được insight bạn muốn truyền đạt, thì khóa học này sẽ rất phù hợp với bạn. 

Khóa học này cung cấp cho bạn kiến thức toàn diện về các công cụ và kỹ thuật trực quan hóa dữ liệu trên Excel. Bạn sẽ được học cách sử dụng từng loại biểu đồ Excel, các kỹ thuật nâng cao để tự động, tương tác với biểu đồ, từ đó tạo ra các báo cáo hữu ích cho công việc.

Giảng viên:

G-LEARNING Giảng viên

Trường đào tạo & phát triển kỹ năng ứng dụng tin học văn phòng

G-LEARNING
  • 4.6 điểm đánh giá

  • 436 đánh giá

  • 224,396 học viên

  • 83 khóa học

Đánh giá của học viên

4.9 điểm đánh giá . 10 lượt đánh giá

Thuy Tran

Thuy Tran

09:52 13/03/2022

rat huu ich va day du cac noi dung va cach lam tung buoc moi ...........................................................................................................................................
Lê Đặng Ngọc

Lê Đặng Ngọc

06:12 05/01/2022

Khóa học tốt phù hợp cho dân văn phòng, chúc gitiho va team ngày càng phát triển hơn và có nhiều khóa học hay hơn nữa nhé. Xin cám ơn Gitiho nhiều đã hỗ trợ học viên nhiệt tình. Thường xuyên có nhiều chương trình khuyến mại hấp dẫn
Trương Hoàng Nam

Trương Hoàng Nam

06:17 19/08/2021

Bài Giảng Chi Tiết và có ứng dụng cho người báo cáo. Hiểu được nên sử dụng loại Biểu đồ nào, và tính chất của nó. Giúp cho người học dễ nắm bắt và ứng dụng thực tế( lần đầu comm mà ko biết đủ 200 ký tự chưa ? :)))))))))))))))

Thảo luận về bài học

237 thảo luận

Bùi Thị Nam Ninh

Bùi Thị Nam Ninh 10 Mar 2022

Hướng dẫn cách lấy nguồn ảnh có khoảng trong suốt ở giữa ạ.

Dương Mạnh Quân

Dương Mạnh Quân [Chuyên gia] 11 Mar 2022

Bạn có thể lên google tìm kiếm với từ khóa:

transparent icon

Sau đó tìm trong phần hình ảnh.

Sẽ có rất nhiều mẫu ảnh icon trong suốt nền để bạn chèn vào trong excel. Bạn tải sẵn 1 số mẫu icon mà bạn thích vào máy tính, có thể tạo theo bộ sưu tập để dùng dần.

{"id":232032,"crm_contact_id":404042,"name":"Th\u00e0nh Tr\u1ea7n H\u1ed3 Xu\u00e2n","email":"tranhoxuanthanh2803@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2022-07-05 21:34:54","confirmation_code":"4d064c0d2498d0a2322495bb17f14f2b","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-07-04T02:09:04.000000Z","updated_at":"2022-12-07T03:57:06.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1657031855.jpg","gender":0,"birthday":"1994-04-25 00:00:00","position":null,"achievement":null,"full_name":"Tr\u1ea7n H\u1ed3 Xu\u00e2n Th\u00e0nh","address":"175\/2B T\u00e2n Th\u1edbi 3, T\u00e2n Hi\u1ec7p, H\u00f3c M\u00f4n, TP. H\u1ed3 Ch\u00ed Minh","status_text":"","user_type":"","social_facebook":"https:\/\/www.facebook.com\/tenby.thanh\/","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0904181712","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":105928,"google_id":"109177298723828091412","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1657031855.jpg","link_profile":"https:\/\/gitiho.com\/u\/232032-thanh-tran-ho-xuan","business_employers":[],"vip_account":{"id":1604,"user_id":232032,"vip_account_id":1,"sale_price":279000,"discount":50,"time_start":"2022-08-24 09:04:08","time_end":"2023-08-24 09:04:08","created_at":"2022-08-24T02:04:08.000000Z","updated_at":"2022-08-24T02:04:08.000000Z"},"roles":[]}

Thành Trần Hồ Xuân 22 Nov 2022

Chào Thầy,
Em có lấy hình (transparent icon) trên GG nhưng khi add vào Excel thì nó vẫn không trong suốt như bài giảng (file đính kèm)
Thầy chia sẻ Dấu Hiệu để nhận biết hình nào có thể sử dụng được vs ạ.
Em cảm ơn!

{"id":66,"crm_contact_id":127658,"name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","email":"duongquan211287@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2018-11-06 21:53:37","confirmation_code":"d79b40591d95db0a31320b960a8a115c","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2017-05-10T03:17:27.000000Z","updated_at":"2022-12-07T01:19:23.000000Z","deleted_at":null,"unit_name":"Gitiho.com","grade":0,"avatar_disk":"public","avatar_path":"users\/1657593507.jpg","gender":0,"birthday":"1987-12-20 07:00:00","position":"Chuy\u00ean gia excel","achievement":null,"full_name":"D\u01b0\u01a1ng Qu\u00e2n","address":"Gitiho.com","status_text":"<p>Gi\u1ea3ng vi\u00ean: D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n<\/p><p>- N\u01a1i c\u00f4ng t\u00e1c hi\u1ec7n t\u1ea1i: Chuy\u00ean gia gi\u00e1o d\u1ee5c t\u1ea1i Gitiho.com<\/p><p><span style=\"color: rgb(0, 0, 0);\">- T\u1eebng l\u00e0m k\u1ebf to\u00e1n qu\u1ea3n tr\u1ecb t\u1ea1i c\u00f4ng ty TNHH DTK'Vina, tr\u1ef1c thu\u1ed9c t\u1eadp&nbsp;\u0111o\u00e0n DEAHO, H\u00e0n Qu\u1ed1c.<\/span><br><\/p><p>- H\u01a1n 7 n\u0103m kinh nghi\u1ec7m l\u00e0m vi\u1ec7c v\u1edbi&nbsp;excel trong l\u0129nh v\u1ef1c k\u1ebf to\u00e1n, t\u00e0i ch\u00ednh<\/p><p>- X\u00e2y d\u1ef1ng nhi\u1ec1u ph\u1ea7n m\u1ec1m&nbsp;excel trong c\u00e1c l\u0129nh v\u1ef1c: K\u1ebf to\u00e1n kho, k\u1ebf to\u00e1n c\u00f4ng n\u1ee3, k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng... trong nhi\u1ec1u lo\u1ea1i h\u00ecnh doanh nghi\u1ec7p kh\u00e1c nhau.<\/p><p>- X\u00e2y d\u1ef1ng ph\u1ea7n m\u1ec1m&nbsp;excel trong l\u0129nh v\u1ef1c t\u00e0i ch\u00ednh: l\u1eadp ph\u01b0\u01a1ng&nbsp;\u00e1n kinh doanh, qu\u1ea3n tr\u1ecb d\u00f2ng ti\u1ec1n trong doanh nghi\u1ec7p...<\/p><p>- T\u01b0 v\u1ea5n gi\u1ea3i ph\u00e1p ho\u00e0n thi\u1ec7n quy tr\u00ecnh qu\u1ea3n l\u00fd doanh nghi\u1ec7p,&nbsp;\u00e1p d\u1ee5ng ph\u1ea7n m\u1ec1m&nbsp;excel n\u00e2ng cao hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c.<\/p><p><br><\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0977705162","become_teacher":0,"primary_wallet":53859770,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"103589301897268320461","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1291,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_number":"2022\/GITIHO-DUONGQUAN","contract_date":"2019-12-31T17:00:00.000000Z","contract_delegate":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_address":"24 ng\u00e1ch 9 ng\u00f5 162A T\u00f4n \u0110\u1ee9c Th\u1eafng, \u0110\u1ed1ng \u0110a, H\u00e0 N\u1ed9i","contract_account_number":"19033577541015","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1657593507.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/66-duong-manh-quan","business_employers":[{"id":33,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":9.96,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":8,"model_type":"App\\Models\\User"}},{"id":15,"name":"BlogManager","display_name":"BlogManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":15,"model_type":"App\\Models\\User"}},{"id":17,"name":"partnerAffiliate","display_name":"partnerAffiliate","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":17,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":19,"model_type":"App\\Models\\User"}}]}

Dương Mạnh Quân [Chuyên gia] 22 Nov 2022

Hình ảnh trong suốt thường là file dạng PNG.

Bạn để ý loại file khi tải về. File JPG hay JPEG sẽ không có nền trong suốt mà là dạng caro chìm như trên.

Phạm Ninh Giang

Phạm Ninh Giang 07 Oct 2022

Chào Gitiho,

Mình có 1 file Excel cần tính tổng của 2 điều kiện: Ví dụ 1 máy chủ tên a,b,c,d với tên 1 sự kiện trùng nhau. Giờ muốn tính tổng của 2 dự kiện cộng lại thì làm như thế nào?

Dương Mạnh Quân

Dương Mạnh Quân [Chuyên gia] 10 Oct 2022

Bạn vui lòng gửi kèm mình hình ảnh file hoặc gửi link file nhé, vì nội dung này cần xem cụ thể trên file mới rõ được.

Còn công thức sử dụng là hàm SUMIFS, quan trọng là cách dùng thế nào phụ thuộc theo nội dung của file.

Ngô Thị Tình

Ngô Thị Tình 14 Sep 2022

Ngô Thị Tình

Ngô Thị Tình 14 Sep 2022

Làm sao tôi có thể làm được biểu đồ tổng hợp như thế này?

 

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-07T02:19:46.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1823,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.52,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 14 Sep 2022

Bạn đọc bài viết này nhé

https://gitiho.com/blog/cach-ve-do-thi-excel-dang-bieu-do-hon-hop-cho-bao-cao.html

Nguyen thi nga

Nguyen thi nga 14 Aug 2022

Ví dụ, biểu đồ cần thể hiện số lượng của 4 cột và % của cột J/cột I;  % của cột K/cột I ; % của cột L/cột I thì làm như thế nào ạ? 

Dương Mạnh Quân

Dương Mạnh Quân [Chuyên gia] 15 Aug 2022

Bạn có thể làm 2 cách:

  • Cách 1: dùng biểu đồ cột kết hợp line (combo). Bạn tạo thêm cột tính tỉ lệ %, sau đó vẽ giá trị Sum of ở dạng cột, giá trị % ở dạng line.
  • Cách 2: bạn có thể tách biệt ra nhiều loại biểu đồ. Bởi vì 1 biểu đồ thể hiện quá nhiều thông tin sẽ không tốt, khó đọc. Biểu đồ % bạn có thể vẽ dạng Stacked Column/Bar.
Trinh Ngọc Hân

Trinh Ngọc Hân 22 May 2021

Animating Changes Over Time

Dynamic Dashboard; Dynamic Series Selection; Custom Pacing Chart; Gauge Chart;Array Percentage Grid

Mình không thấy có bài giảng cho các biểu đồ trên ạ

Nhờ Thầy hướng dẫn cách vẽ các biểu đồ trên a

Cám ơn Thầy



Dương Mạnh Quân

Dương Mạnh Quân [Chuyên gia] 24 May 2021

1. Dynamic Dashboard là biểu đồ tạo ra từ dạng Pivot table, pivot chart có sử dụng Slicer làm bộ lọc giúp biểu đồ động, thay đổi ngay lập tức theo slicer.

Bạn có thể xem ở đây:

https://www.youtube.com/watch?v=eSCTI

2. Dynamic Series selection là dạng biểu đồ mà dữ liệu có thể thay đổi tùy ý. Thường gắn với 1 lựa chọn trong List / Checkbox / Option button... với 1 lựa chọn sẽ làm thay đổi bộ dữ liệu vẽ biểu đồ => biểu đồ tự thay đổi theo dữ liệu mới.

Bạn có thể dùng các hàm tính toán theo điều kiện để giúp kết quả tính toán phụ thuộc theo lựa chọn này (hàm IF, hàm SUMIFS, COUNTIFS...)

Các dạng biểu đồ khác mình sẽ tìm hiểu thêm và giải thích sau cho bạn nhé.

{"id":114522,"crm_contact_id":145226,"name":"Trinh Ng\u1ecdc H\u00e2n","email":"tngochan2010@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2020-12-16 20:40:06","confirmation_code":"b1d3cd0a169fa8e647951657db8ba7e7","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2020-12-15T06:55:03.000000Z","updated_at":"2021-10-25T03:04:00.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Trinh Ng\u1ecdc H\u00e2n","address":"156\u00a0Nguy\u1ec5n L\u01b0\u01a1ng B\u1eb1ng, T\u00e2n Ph\u00fa, Qu\u1eadn 7, Th\u00e0nh ph\u1ed1 H\u1ed3 Ch\u00ed Minh","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0914983158","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":65865,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/homeless.png","link_profile":"https:\/\/gitiho.com\/u\/114522-trinh-ngoc-han","business_employers":[],"vip_account":null,"roles":[]}

Trinh Ngọc Hân 24 May 2021

Da, cám ơn Thầy. Vì em thấy trong file excel các kỹ thuật vẽ biểu đồ nâng cao có các sheet data của các biểu đồ : Dynamic Dashboard; Dynamic Series Selection; Custom Pacing Chart; Gauge Chart;Array Percentage Grid nên nếu mình có bài giảng cho các sheet này thì tốt quá a. 

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-07T02:19:46.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1823,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.52,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 24 May 2021

Cảm ơn bạn đã đưa ra ý kiến, gitiho sẽ bổ xung phần này sớm nhất.

{"id":158,"crm_contact_id":739,"name":"thevinhhv2509@gmail.com","email":"thevinhhv2509@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2018-05-11 14:26:44","confirmation_code":"9ebedb73e2e24cdffec2d930bf345431","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2017-05-10T05:01:57.000000Z","updated_at":"2022-12-05T10:41:42.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"nh\u00e0 s\u1ed1 28, \u0110\u01b0\u1eddng 411, t\u1ed5 6, \u1ea5p 3 x\u00e3 Ph\u01b0\u1edbc V\u0129nh A,, huy\u1ec7n C\u1ee7 Chi, TPHCM","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":402987,"google_id":"106505575452936722187","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":2,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/user.png","link_profile":"https:\/\/gitiho.com\/u\/158-thevinhhv2509-at-gmailcom","business_employers":[],"vip_account":null,"roles":[]}

thevinhhv2509@gmail.com 05 Jun 2021

Chương 6 video hơi mờ không rõ và không có tài liệu thực hành ?

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-07T02:19:46.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1823,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.52,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 05 Jun 2021

Chào bạn phần tài liệu nằm ở phần đầu mỗi chương nhé.

{"id":226805,"crm_contact_id":393482,"name":"Tr\u1ea7n Ho\u00e0ng B\u1ea3o Tr\u00e2n","email":"thbt1510@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2022-06-03 15:23:11","confirmation_code":"73ac78a8fb9da7d7681a31cc16fb6700","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-06-03T04:16:08.000000Z","updated_at":"2022-08-01T10:54:11.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"ck","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0902252096","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":20678,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/pastor.png","link_profile":"https:\/\/gitiho.com\/u\/226805-tran-hoang-bao-tran","business_employers":[],"vip_account":null,"roles":[]}

Trần Hoàng Bảo Trân 01 Aug 2022

Chào Thầy,

Bây giờ đã sau 1 năm , mà các bài giảng trong tài liệu vẫn chưa được bổ sung . Có tài liệu mà không có bài giảng thì học viên cũng mù tịt luôn . Do đó, nhờ Trung tâm bổ sung sớm giúp các bài giảng còn thiếu trong C.5, nhìn vào thì có vẻ đây cũng là các biểu đồ cũng rất hay : Animating Changes Over Time, Dynamic Series Selection,Custom Pacing Chart,Gauge Chart, Array Percentage Grid . Cám ơn trung tâm rất nhiều và sẽ th.gia các khóa học hay khác của Trung tâm. Thanks.

Đỗ Phong Linh

Đỗ Phong Linh 07 Nov 2021

làm thế nào vẽ biểu đồ dạng cột sắp xếp theo thứ tự tăng/giảm dần ạ. mình cảm ơn

Tuấn Ba

Tuấn Ba [Chuyên gia] 08 Nov 2021

Chào bạn bạn làm như sau nhé

https://vi.extendoffice.com/documents...


{"id":187247,"crm_contact_id":320403,"name":"L\u00ea Hu\u1ebf","email":"lthue456@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2021-12-25 13:21:25","confirmation_code":"ef055b940cabd5ee4b9168d29ac1f300","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-12-05T10:58:42.000000Z","updated_at":"2022-07-13T08:22:47.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":"L\u00ea Hu\u1ebf","address":"HN","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0904562456","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":29745,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/man.png","link_profile":"https:\/\/gitiho.com\/u\/187247-le-hue","business_employers":[],"vip_account":null,"roles":[]}

Lê Huế 11 Jul 2022

Mình cần tải file ex của bài học tải ở đâu hướng dẫn giúp mình nhé

 

{"id":66,"crm_contact_id":127658,"name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","email":"duongquan211287@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2018-11-06 21:53:37","confirmation_code":"d79b40591d95db0a31320b960a8a115c","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2017-05-10T03:17:27.000000Z","updated_at":"2022-12-07T01:19:23.000000Z","deleted_at":null,"unit_name":"Gitiho.com","grade":0,"avatar_disk":"public","avatar_path":"users\/1657593507.jpg","gender":0,"birthday":"1987-12-20 07:00:00","position":"Chuy\u00ean gia excel","achievement":null,"full_name":"D\u01b0\u01a1ng Qu\u00e2n","address":"Gitiho.com","status_text":"<p>Gi\u1ea3ng vi\u00ean: D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n<\/p><p>- N\u01a1i c\u00f4ng t\u00e1c hi\u1ec7n t\u1ea1i: Chuy\u00ean gia gi\u00e1o d\u1ee5c t\u1ea1i Gitiho.com<\/p><p><span style=\"color: rgb(0, 0, 0);\">- T\u1eebng l\u00e0m k\u1ebf to\u00e1n qu\u1ea3n tr\u1ecb t\u1ea1i c\u00f4ng ty TNHH DTK'Vina, tr\u1ef1c thu\u1ed9c t\u1eadp&nbsp;\u0111o\u00e0n DEAHO, H\u00e0n Qu\u1ed1c.<\/span><br><\/p><p>- H\u01a1n 7 n\u0103m kinh nghi\u1ec7m l\u00e0m vi\u1ec7c v\u1edbi&nbsp;excel trong l\u0129nh v\u1ef1c k\u1ebf to\u00e1n, t\u00e0i ch\u00ednh<\/p><p>- X\u00e2y d\u1ef1ng nhi\u1ec1u ph\u1ea7n m\u1ec1m&nbsp;excel trong c\u00e1c l\u0129nh v\u1ef1c: K\u1ebf to\u00e1n kho, k\u1ebf to\u00e1n c\u00f4ng n\u1ee3, k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng... trong nhi\u1ec1u lo\u1ea1i h\u00ecnh doanh nghi\u1ec7p kh\u00e1c nhau.<\/p><p>- X\u00e2y d\u1ef1ng ph\u1ea7n m\u1ec1m&nbsp;excel trong l\u0129nh v\u1ef1c t\u00e0i ch\u00ednh: l\u1eadp ph\u01b0\u01a1ng&nbsp;\u00e1n kinh doanh, qu\u1ea3n tr\u1ecb d\u00f2ng ti\u1ec1n trong doanh nghi\u1ec7p...<\/p><p>- T\u01b0 v\u1ea5n gi\u1ea3i ph\u00e1p ho\u00e0n thi\u1ec7n quy tr\u00ecnh qu\u1ea3n l\u00fd doanh nghi\u1ec7p,&nbsp;\u00e1p d\u1ee5ng ph\u1ea7n m\u1ec1m&nbsp;excel n\u00e2ng cao hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c.<\/p><p><br><\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0977705162","become_teacher":0,"primary_wallet":53859770,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"103589301897268320461","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1291,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_number":"2022\/GITIHO-DUONGQUAN","contract_date":"2019-12-31T17:00:00.000000Z","contract_delegate":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_address":"24 ng\u00e1ch 9 ng\u00f5 162A T\u00f4n \u0110\u1ee9c Th\u1eafng, \u0110\u1ed1ng \u0110a, H\u00e0 N\u1ed9i","contract_account_number":"19033577541015","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1657593507.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/66-duong-manh-quan","business_employers":[{"id":33,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":9.96,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":8,"model_type":"App\\Models\\User"}},{"id":15,"name":"BlogManager","display_name":"BlogManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":15,"model_type":"App\\Models\\User"}},{"id":17,"name":"partnerAffiliate","display_name":"partnerAffiliate","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":17,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":19,"model_type":"App\\Models\\User"}}]}

Dương Mạnh Quân [Chuyên gia] 12 Jul 2022

Ở đầu chương có mục tài liệu thực hành kèm theo đó bạn, bạn tải ở đây nhé.

Đinh Kiên

Đinh Kiên 04 Jun 2021

Chèn icon sest vào ô text box?

Mình đang định chèn icon vào ô text bõ mà ko hiện, nhờ chuyên gia xem giúp. Xin cảm ơn

file Kim

Tuấn Ba

Tuấn Ba [Chuyên gia] 04 Jun 2021

Chào bạn, bạn muốn thế này đúng không?


{"id":58399,"crm_contact_id":23515,"name":"\u0110inh Ki\u00ean","email":"kien@ymail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"ab436882dc9e53b1af653cdbb22b80d4","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-05-25T07:12:12.000000Z","updated_at":"2022-07-03T14:58:51.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"\u0110inh Ki\u00ean","address":"H\u00e0 N\u1ed9i","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0989189089","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":117354,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":2,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/butcher.png","link_profile":"https:\/\/gitiho.com\/u\/58399-dinh-kien","business_employers":[],"vip_account":{"id":337,"user_id":58399,"vip_account_id":1,"sale_price":0,"discount":50,"time_start":"2022-01-13 13:46:01","time_end":"2023-01-13 13:46:01","created_at":"2022-01-13T06:46:01.000000Z","updated_at":"2022-01-13T06:46:01.000000Z"},"roles":[]}

Đinh Kiên 04 Jun 2021

mình muốn chèn cả mũi tên tăng giảm vào ô text box

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-07T02:19:46.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1823,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.52,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 04 Jun 2021

Chào bạn bạn có hình ảnh nào tưởng trưng không?


{"id":58399,"crm_contact_id":23515,"name":"\u0110inh Ki\u00ean","email":"kien@ymail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"ab436882dc9e53b1af653cdbb22b80d4","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-05-25T07:12:12.000000Z","updated_at":"2022-07-03T14:58:51.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"\u0110inh Ki\u00ean","address":"H\u00e0 N\u1ed9i","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0989189089","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":117354,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":2,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/butcher.png","link_profile":"https:\/\/gitiho.com\/u\/58399-dinh-kien","business_employers":[],"vip_account":{"id":337,"user_id":58399,"vip_account_id":1,"sale_price":0,"discount":50,"time_start":"2022-01-13 13:46:01","time_end":"2023-01-13 13:46:01","created_at":"2022-01-13T06:46:01.000000Z","updated_at":"2022-01-13T06:46:01.000000Z"},"roles":[]}

Đinh Kiên 04 Jun 2021

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-07T02:19:46.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1823,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.52,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 04 Jun 2021

Chào bạn phải cái hình thế này không vậy?


{"id":58399,"crm_contact_id":23515,"name":"\u0110inh Ki\u00ean","email":"kien@ymail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"ab436882dc9e53b1af653cdbb22b80d4","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-05-25T07:12:12.000000Z","updated_at":"2022-07-03T14:58:51.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"\u0110inh Ki\u00ean","address":"H\u00e0 N\u1ed9i","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0989189089","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":117354,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":2,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/butcher.png","link_profile":"https:\/\/gitiho.com\/u\/58399-dinh-kien","business_employers":[],"vip_account":{"id":337,"user_id":58399,"vip_account_id":1,"sale_price":0,"discount":50,"time_start":"2022-01-13 13:46:01","time_end":"2023-01-13 13:46:01","created_at":"2022-01-13T06:46:01.000000Z","updated_at":"2022-01-13T06:46:01.000000Z"},"roles":[]}

Đinh Kiên 04 Jun 2021

đúng rồi, vấn đề là mình muốn chèn nó vào Dashboad bằng text box như trong bài giảng mà k đc
{"id":187247,"crm_contact_id":320403,"name":"L\u00ea Hu\u1ebf","email":"lthue456@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2021-12-25 13:21:25","confirmation_code":"ef055b940cabd5ee4b9168d29ac1f300","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-12-05T10:58:42.000000Z","updated_at":"2022-07-13T08:22:47.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":"L\u00ea Hu\u1ebf","address":"HN","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0904562456","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":29745,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/man.png","link_profile":"https:\/\/gitiho.com\/u\/187247-le-hue","business_employers":[],"vip_account":null,"roles":[]}

Lê Huế 11 Jul 2022

file tài liệu chương 6 có mật khẩu thì phải. Mình ko thực hành trong file đc

 

{"id":66,"crm_contact_id":127658,"name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","email":"duongquan211287@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2018-11-06 21:53:37","confirmation_code":"d79b40591d95db0a31320b960a8a115c","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2017-05-10T03:17:27.000000Z","updated_at":"2022-12-07T01:19:23.000000Z","deleted_at":null,"unit_name":"Gitiho.com","grade":0,"avatar_disk":"public","avatar_path":"users\/1657593507.jpg","gender":0,"birthday":"1987-12-20 07:00:00","position":"Chuy\u00ean gia excel","achievement":null,"full_name":"D\u01b0\u01a1ng Qu\u00e2n","address":"Gitiho.com","status_text":"<p>Gi\u1ea3ng vi\u00ean: D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n<\/p><p>- N\u01a1i c\u00f4ng t\u00e1c hi\u1ec7n t\u1ea1i: Chuy\u00ean gia gi\u00e1o d\u1ee5c t\u1ea1i Gitiho.com<\/p><p><span style=\"color: rgb(0, 0, 0);\">- T\u1eebng l\u00e0m k\u1ebf to\u00e1n qu\u1ea3n tr\u1ecb t\u1ea1i c\u00f4ng ty TNHH DTK'Vina, tr\u1ef1c thu\u1ed9c t\u1eadp&nbsp;\u0111o\u00e0n DEAHO, H\u00e0n Qu\u1ed1c.<\/span><br><\/p><p>- H\u01a1n 7 n\u0103m kinh nghi\u1ec7m l\u00e0m vi\u1ec7c v\u1edbi&nbsp;excel trong l\u0129nh v\u1ef1c k\u1ebf to\u00e1n, t\u00e0i ch\u00ednh<\/p><p>- X\u00e2y d\u1ef1ng nhi\u1ec1u ph\u1ea7n m\u1ec1m&nbsp;excel trong c\u00e1c l\u0129nh v\u1ef1c: K\u1ebf to\u00e1n kho, k\u1ebf to\u00e1n c\u00f4ng n\u1ee3, k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng... trong nhi\u1ec1u lo\u1ea1i h\u00ecnh doanh nghi\u1ec7p kh\u00e1c nhau.<\/p><p>- X\u00e2y d\u1ef1ng ph\u1ea7n m\u1ec1m&nbsp;excel trong l\u0129nh v\u1ef1c t\u00e0i ch\u00ednh: l\u1eadp ph\u01b0\u01a1ng&nbsp;\u00e1n kinh doanh, qu\u1ea3n tr\u1ecb d\u00f2ng ti\u1ec1n trong doanh nghi\u1ec7p...<\/p><p>- T\u01b0 v\u1ea5n gi\u1ea3i ph\u00e1p ho\u00e0n thi\u1ec7n quy tr\u00ecnh qu\u1ea3n l\u00fd doanh nghi\u1ec7p,&nbsp;\u00e1p d\u1ee5ng ph\u1ea7n m\u1ec1m&nbsp;excel n\u00e2ng cao hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c.<\/p><p><br><\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0977705162","become_teacher":0,"primary_wallet":53859770,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"103589301897268320461","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1291,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_number":"2022\/GITIHO-DUONGQUAN","contract_date":"2019-12-31T17:00:00.000000Z","contract_delegate":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_address":"24 ng\u00e1ch 9 ng\u00f5 162A T\u00f4n \u0110\u1ee9c Th\u1eafng, \u0110\u1ed1ng \u0110a, H\u00e0 N\u1ed9i","contract_account_number":"19033577541015","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1657593507.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/66-duong-manh-quan","business_employers":[{"id":33,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":9.96,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":8,"model_type":"App\\Models\\User"}},{"id":15,"name":"BlogManager","display_name":"BlogManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":15,"model_type":"App\\Models\\User"}},{"id":17,"name":"partnerAffiliate","display_name":"partnerAffiliate","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":17,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":19,"model_type":"App\\Models\\User"}}]}

Dương Mạnh Quân [Chuyên gia] 12 Jul 2022

Conditional formatting chỉ áp dụng với bảng thường thôi bạn nhé, không áp dụng được vào textbox. Bạn có thể tạo hình mũi tên này bằng cách Insert > Symbol, sau đó đổi màu mũi tên theo ý muốn

{"id":58399,"crm_contact_id":23515,"name":"\u0110inh Ki\u00ean","email":"kien@ymail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"ab436882dc9e53b1af653cdbb22b80d4","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-05-25T07:12:12.000000Z","updated_at":"2022-07-03T14:58:51.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"\u0110inh Ki\u00ean","address":"H\u00e0 N\u1ed9i","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0989189089","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":117354,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":2,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/butcher.png","link_profile":"https:\/\/gitiho.com\/u\/58399-dinh-kien","business_employers":[],"vip_account":{"id":337,"user_id":58399,"vip_account_id":1,"sale_price":0,"discount":50,"time_start":"2022-01-13 13:46:01","time_end":"2023-01-13 13:46:01","created_at":"2022-01-13T06:46:01.000000Z","updated_at":"2022-01-13T06:46:01.000000Z"},"roles":[]}

Đinh Kiên 12 Jul 2022

Cảm ơn, nhưng phản hội chậm quá, câu này mình hỏi cả năm nay và đã tìm được cách giải quyết lâu rồi.

Nguyễn Anh Duy

Nguyễn Anh Duy 24 Jun 2022

nhân đôi biểu đồ nhấn Cltr+D nhưng không có tác dụng, nhờ giảng viên hướng dẫn thêm, cám ơn

Nguyễn Hồng Quân

Nguyễn Hồng Quân 01 Jul 2022

Nếu ko Ctrl D được thì bạn thử Ctrl C + Ctrl V thông thường thôi nha, và bạn thử trên phần mềm khác xemd dược không, vì Ctrl D trên Excel quy định là phím tắt của Duplicate, nếu ko được thì do bàn phím hoặc do phiên bản Excel, thì bạn cần cài lại bản Excel chuẩn đó

{"id":187247,"crm_contact_id":320403,"name":"L\u00ea Hu\u1ebf","email":"lthue456@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2021-12-25 13:21:25","confirmation_code":"ef055b940cabd5ee4b9168d29ac1f300","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-12-05T10:58:42.000000Z","updated_at":"2022-07-13T08:22:47.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":"L\u00ea Hu\u1ebf","address":"HN","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0904562456","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":29745,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/man.png","link_profile":"https:\/\/gitiho.com\/u\/187247-le-hue","business_employers":[],"vip_account":null,"roles":[]}

Lê Huế 11 Jul 2022

Hướng dẫn giúp mình cách đổi.

Thứ tự vòng 1 là Dt, 2 Cp, 3 Gap 

Lê Huế

Lê Huế 07 Jul 2022

Mình muốn xin file hướng dẫn Word hoặc PDF mục 15.5 chương 3 được ko bạn?


Dương Mạnh Quân

Dương Mạnh Quân [Chuyên gia] 07 Jul 2022

Phần này hiện chưa có dạng file word bạn nhé.

{"id":187247,"crm_contact_id":320403,"name":"L\u00ea Hu\u1ebf","email":"lthue456@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2021-12-25 13:21:25","confirmation_code":"ef055b940cabd5ee4b9168d29ac1f300","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-12-05T10:58:42.000000Z","updated_at":"2022-07-13T08:22:47.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":"L\u00ea Hu\u1ebf","address":"HN","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0904562456","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":29745,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/man.png","link_profile":"https:\/\/gitiho.com\/u\/187247-le-hue","business_employers":[],"vip_account":null,"roles":[]}

Lê Huế 08 Jul 2022

Vậy có tóm tắ giúp một số điểm nhấn vì mình xem video ghi lại mất nhiều tg quá. Phải xem đi, xem lại để ghi chép mà máy tính của mình các thanh công cụ hỗ trợ vẽ tên và vị tri nó lại ko giống bài học thì phải. Khó học quá

Mục 15.5 thì nhiều nội dung

Lê Huế

Lê Huế 30 Jun 2022


Hiển thị ở mục này bạn ạ



Tuấn Ba

Tuấn Ba [Chuyên gia] 30 Jun 2022

Chào bạn bạn thay đổi phiên bản office là xong nhé, bạn cài lên office 2016 trở lên là ok

{"id":187247,"crm_contact_id":320403,"name":"L\u00ea Hu\u1ebf","email":"lthue456@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2021-12-25 13:21:25","confirmation_code":"ef055b940cabd5ee4b9168d29ac1f300","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-12-05T10:58:42.000000Z","updated_at":"2022-07-13T08:22:47.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":"L\u00ea Hu\u1ebf","address":"HN","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0904562456","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":29745,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/man.png","link_profile":"https:\/\/gitiho.com\/u\/187247-le-hue","business_employers":[],"vip_account":null,"roles":[]}

Lê Huế 30 Jun 2022

Máy mình đang offce 2016 rồi mà

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-07T02:19:46.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1823,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.52,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 30 Jun 2022

Bạn đang mở office 2010 bạn mở office 2016 lên rùi chọn file và thử laik

Lê Huế

Lê Huế 30 Jun 2022


Lê Huế

Lê Huế 30 Jun 2022

Hướng dẫn giúp mình tìm mục này trên biểu đồ của mình nhé

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-07T02:19:46.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1823,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.52,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 30 Jun 2022

Bạn đang sử dụng office phiên bản nào nhỉ?

{"id":187247,"crm_contact_id":320403,"name":"L\u00ea Hu\u1ebf","email":"lthue456@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2021-12-25 13:21:25","confirmation_code":"ef055b940cabd5ee4b9168d29ac1f300","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-12-05T10:58:42.000000Z","updated_at":"2022-07-13T08:22:47.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":"L\u00ea Hu\u1ebf","address":"HN","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0904562456","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":29745,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/man.png","link_profile":"https:\/\/gitiho.com\/u\/187247-le-hue","business_employers":[],"vip_account":null,"roles":[]}

Lê Huế 30 Jun 2022

office 2010 thì phải
{"id":187247,"crm_contact_id":320403,"name":"L\u00ea Hu\u1ebf","email":"lthue456@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2021-12-25 13:21:25","confirmation_code":"ef055b940cabd5ee4b9168d29ac1f300","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-12-05T10:58:42.000000Z","updated_at":"2022-07-13T08:22:47.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":"L\u00ea Hu\u1ebf","address":"HN","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0904562456","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":29745,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/man.png","link_profile":"https:\/\/gitiho.com\/u\/187247-le-hue","business_employers":[],"vip_account":null,"roles":[]}

Lê Huế 30 Jun 2022

Win10 office 16 bạn ạ
{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-07T02:19:46.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1823,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.52,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 30 Jun 2022

bạn chụp ảnh giúp gitiho nhé vì office 2016 có đầy đủ tính năng bạn nhé.

Trần Thanh Sơn

Trần Thanh Sơn 21 May 2022

Trong Pivot table có cách nào lấy tỉ lệ giữa 2 trường ko ? sau đó vẽ biểu đồ là số liệu chạy theo Slicer, tks

Dương Mạnh Quân

Dương Mạnh Quân [Chuyên gia] 22 May 2022

Bạn có thể tạo Calculated Fields (trong thẻ PivotTable > Fields, Items, Set > Calculated Fields). Trong mục này bạn có thể tạo 1 field mới được tính từ các field khác, như lấy 2 field chia cho nhau.

Gia Hoàng Vũ

Gia Hoàng Vũ 20 May 2022

Dạ cho em hỏi em phút 5:27 thì làm sao để mình có thể thêm nhanh 1 Pivot Table ạ.

Dương Mạnh Quân

Dương Mạnh Quân [Chuyên gia] 20 May 2022

Đây là thao tác tạo 1 pivot khác thôi bạn nhé. Do video làm tắt bước này chứ không có cách nào đặc biệt đâu. Thao tác tạo pivot cũng khá đơn giản nên bạn có thể thao tác nhanh được nếu làm quen tay.

Gia Hoàng Vũ

Gia Hoàng Vũ 19 May 2022

Dạ cho em hỏi nếu dữ liệu của mình bị như thế này.

Hình 1:


Thì mình nhấn tổ hợp phím nào để ra được như thế này ạ.

Hình 2:

Tuấn Ba

Tuấn Ba [Chuyên gia] 19 May 2022

Chào bạn bạn bôi đen vùng rồi kích đúp vào ngăn cách giữa hai ô là được

Gia Hoàng Vũ

Gia Hoàng Vũ 16 May 2022

Dạ cho em hỏi phím tắt nào để hiện bảng này ạ.


Dương Mạnh Quân

Dương Mạnh Quân [Chuyên gia] 16 May 2022

Đây là cửa sổ paste special. Bạn có thể dùng tổ hợp phím tắt là Alt + E + S

{"id":213657,"crm_contact_id":368954,"name":"Gia Ho\u00e0ng V\u0169","email":"vugiahoang2000.study@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2022-04-10 15:48:31","confirmation_code":"2ebd91cb342de7c4c5520a9942ee22f2","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-04-06T07:29:45.000000Z","updated_at":"2022-11-04T04:31:26.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1649583344.jpg","gender":0,"birthday":"2000-07-24 00:00:00","position":null,"achievement":null,"full_name":"V\u0169 Gia Ho\u00e0ng","address":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0981189270","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":42149,"google_id":"107978339148287619700","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":5,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1649583344.jpg","link_profile":"https:\/\/gitiho.com\/u\/213657-gia-hoang-vu","business_employers":[],"vip_account":null,"roles":[]}

Gia Hoàng Vũ 17 May 2022

Dạ em cảm ơn ạ.

EXG07: Trực quan Báo cáo, Dữ liệu với Biểu đồ, Đồ thị bằng Excel (Excel Data Visualization)
4.9

(10 đánh giá)

1,151 học viên
499,000đ
@ 2020 - Bản quyền của Công ty cổ phần công nghệ giáo dục Gitiho Việt Nam
Giấy chứng nhận Đăng ký doanh nghiệp số: 0109077145, cấp bởi Sở kế hoạch và đầu tư TP. Hà Nội
/