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

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

Nắm được phương pháp và cách tổ chức, cấu trúc một bảng dữ liệu đúng cách
Sử dụng các công cụ, các hàm trong Excel để quản lý, xử lý dữ liệu
Biết cách xây dựng các dạng báo cáo tổng hợp, báo cáo chi tiết nhiều điều kiện
Biết cách vẽ biểu đồ, kỹ thuật vẽ biểu đồ động
Xây dựng tư duy tổ chức dữ liệu
Phát triển kỹ năng báo cáo, tăng tính thẩm mỹ trong báo cáo

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

Video

6h 42m giờ học

Article

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

Material

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

Exam questions

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

Nội dung khoá học

9 Chương . 58 bài giảng . 6h 42m giờ học

1

Hỗ trợ học viên

2

Kỹ năng tổ chức, quản lý dữ liệu trên Excel

2 bài học thử
3

Kỹ năng lập báo cáo tổng hợp

4

Kỹ năng lập báo cáo chi tiết

1 bài học thử
5

Kỹ năng lập báo cáo với Pivot Table

6

Kỹ năng báo cáo bằng biểu đồ trên Excel

1 bài học thử
7

Luyện tập kỹ năng tổ chức dữ liệu và lập báo cáo - Bài tập 3

1 bài học thử
8

Bài tập về nhà

9

Bài kiểm tra

Mô tả khoá học

"Học excel nhưng không biết cách làm báo cáo" chính là vấn đề mà rất nhiều người gặp phải. Bởi khi học Excel cơ bản, bạn thường chỉ học cách sử dụng Excel, nhưng lại không biết được quy trình để tạo ra 1 bản báo cáo. Những vấn đề thường gặp phải là:

- Tổ chức dữ liệu không khoa học, hợp lý dẫn tới khó khăn khi phải tổng hợp dữ liệu.

- Yêu cầu báo cáo phức tạp, nhiều biến động, nhiều điều kiện... không biết phương pháp để làm ra kết quả đúng yêu cầu.

- Không biết cách bố cục, tổ chức 1 bảng báo cáo sao cho khoa học, đẹp mắt.

- Không biết cách kết hợp giữa báo cáo bằng bảng biểu, biểu đồ.

- Mất quá nhiều thời gian để làm báo cáo, ảnh hưởng tới những công việc khác.

...

Nhằm giúp bạn giải quyết tất cả những vấn đề trên, Gitiho.com xin giới thiệu khóa học "Kỹ năng tổ chức, quản lý dữ liệu và lập báo cáo trên Excel". Với phương pháp học  tập mới lạ, công cụ học tập hữu ích, hệ thống bài tập đầy đủ, đa dạng, kết hợp bài kiểm tra đánh giá cuối khóa học, bạn hoàn toàn có thể yên tâm về chất lượng cũng như hiệu quả đầu ra của khóa học này.

Giảng viên:

Dương Mạnh Quân Giảng viên

Chuyên gia excel

Dương Mạnh Quân
  • 4 điểm đánh giá

  • 114 đánh giá

  • 10,086 học viên

  • 12 khóa học

Giảng viên: Dương Mạnh Quân

- Nơi công tác hiện tại: Chuyên gia giáo dục tại Gitiho.com

- Từng làm kế toán quản trị tại công ty TNHH DTK'Vina, trực thuộc tập đoàn DEAHO, Hàn Quốc.

- Hơn 7 năm kinh nghiệm làm việc với excel trong lĩnh vực kế toán, tài chính

- Xây dựng nhiều phần mềm excel trong các lĩnh vực: Kế toán kho, kế toán công nợ, kế toán tiền lương... trong nhiều loại hình doanh nghiệp khác nhau.

- Xây dựng phần mềm excel trong lĩnh vực tài chính: lập phương án kinh doanh, quản trị dòng tiền trong doanh nghiệp...

- Tư vấn giải pháp hoàn thiện quy trình quản lý doanh nghiệp, áp dụng phần mềm excel nâng cao hiệu suất làm việc.


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

4.79 điểm đánh giá . 34 lượt đánh giá

Ngô Trần Nhật Huy

Ngô Trần Nhật Huy

01:33 16/11/2019

ok
Nguyễn Dương Hoàng Hải

Nguyễn Dương Hoàng Hải

07:04 11/11/2019

.
Nguyễn Việt Toàn

Nguyễn Việt Toàn

04:13 11/11/2019

Good

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

793 thảo luận

Huỳnh Thị Thu Thảo

Huỳnh Thị Thu Thảo 09 Apr 2022

Thầy cho e hỏi, khoá học này có phù hợp với việc tổng hợp KPI không ạ? E học gần hết rồi nhưng vẫn chưa biết cách làm sao để tổng hợp số liệu từ nhiều nguồn vào báo cáo nhanh và chính xác. Khi dữ liệu thay đổi e phải sửa tay các mục liên quan, có khoá học nào giúp e k cần sửa tay như vậy không ạ
Tuấn Ba

Tuấn Ba [Chuyên gia] 12 Apr 2022

Chào bạn phần bạn dùng để tổng hợp có cấu trúc giống nhau không nhỉ?

{"id":46273,"crm_contact_id":15059,"name":"Hu\u1ef3nh Th\u1ecb Thu Th\u1ea3o","email":"utthao4885@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2019-03-06 21:02:00","confirmation_code":"4abd83aeafd0433b1326bbf4ae6d7e70","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-03-03T03:16:04.000000Z","updated_at":"2022-11-22T04:43:35.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1631189056.jpg","gender":1,"birthday":"1985-08-04 00:00:00","position":null,"achievement":null,"full_name":"Hu\u1ef3nh Th\u1ecb Thu Th\u1ea3o","address":"S\u1ed1 47 \u0111\u01b0\u1eddng 16\/4, Phan Rang Th\u00e1p Ch\u00e0m,Ninh Thu\u1eadn","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0977151090","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":128746,"google_id":"100861072390579561643","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\/caches\/ua_small\/users\/1631189056.jpg","link_profile":"https:\/\/gitiho.com\/u\/46273-huynh-thi-thu-thao","business_employers":[],"vip_account":{"id":1115,"user_id":46273,"vip_account_id":1,"sale_price":279000,"discount":50,"time_start":"2022-04-21 21:11:53","time_end":"2023-04-21 21:11:53","created_at":"2022-04-21T14:11:53.000000Z","updated_at":"2022-04-21T14:11:53.000000Z"},"roles":[]}

Huỳnh Thị Thu Thảo 12 Apr 2022

Dạ không ạ. Mỗi chỉ tiêu phải tổng hợp từ các file khác nhau

{"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] 12 Apr 2022

Ý mình nói là các file đó chỉ khác nhau tên file và số liệu còn cấu trúc giống hệt nhau đúng không?

{"id":46273,"crm_contact_id":15059,"name":"Hu\u1ef3nh Th\u1ecb Thu Th\u1ea3o","email":"utthao4885@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2019-03-06 21:02:00","confirmation_code":"4abd83aeafd0433b1326bbf4ae6d7e70","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-03-03T03:16:04.000000Z","updated_at":"2022-11-22T04:43:35.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1631189056.jpg","gender":1,"birthday":"1985-08-04 00:00:00","position":null,"achievement":null,"full_name":"Hu\u1ef3nh Th\u1ecb Thu Th\u1ea3o","address":"S\u1ed1 47 \u0111\u01b0\u1eddng 16\/4, Phan Rang Th\u00e1p Ch\u00e0m,Ninh Thu\u1eadn","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0977151090","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":128746,"google_id":"100861072390579561643","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\/caches\/ua_small\/users\/1631189056.jpg","link_profile":"https:\/\/gitiho.com\/u\/46273-huynh-thi-thu-thao","business_employers":[],"vip_account":{"id":1115,"user_id":46273,"vip_account_id":1,"sale_price":279000,"discount":50,"time_start":"2022-04-21 21:11:53","time_end":"2023-04-21 21:11:53","created_at":"2022-04-21T14:11:53.000000Z","updated_at":"2022-04-21T14:11:53.000000Z"},"roles":[]}

Huỳnh Thị Thu Thảo 12 Apr 2022

dạ không ạ, cấu trúc khác nhau
{"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] 12 Apr 2022

Chào bạn với cấu trúc khác nhau phải quy chuẩn về 1 cấu trúc mới làm được bạn nhé.

{"id":46273,"crm_contact_id":15059,"name":"Hu\u1ef3nh Th\u1ecb Thu Th\u1ea3o","email":"utthao4885@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2019-03-06 21:02:00","confirmation_code":"4abd83aeafd0433b1326bbf4ae6d7e70","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-03-03T03:16:04.000000Z","updated_at":"2022-11-22T04:43:35.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1631189056.jpg","gender":1,"birthday":"1985-08-04 00:00:00","position":null,"achievement":null,"full_name":"Hu\u1ef3nh Th\u1ecb Thu Th\u1ea3o","address":"S\u1ed1 47 \u0111\u01b0\u1eddng 16\/4, Phan Rang Th\u00e1p Ch\u00e0m,Ninh Thu\u1eadn","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0977151090","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":128746,"google_id":"100861072390579561643","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\/caches\/ua_small\/users\/1631189056.jpg","link_profile":"https:\/\/gitiho.com\/u\/46273-huynh-thi-thu-thao","business_employers":[],"vip_account":{"id":1115,"user_id":46273,"vip_account_id":1,"sale_price":279000,"discount":50,"time_start":"2022-04-21 21:11:53","time_end":"2023-04-21 21:11:53","created_at":"2022-04-21T14:11:53.000000Z","updated_at":"2022-04-21T14:11:53.000000Z"},"roles":[]}

Huỳnh Thị Thu Thảo 13 Apr 2022

dạ em cảm ơn ạ
Nguyễn Thị Ánh Nguyệt 

Nguyễn Thị Ánh Nguyệt  07 Apr 2020

mìh làm theo đúng hướng dẫn của bài giảng và công thực nhưng lại ra value nhờ thầy chỉ giúp
Tuấn Ba

Tuấn Ba [Chuyên gia] 07 Apr 2020

Chào bạn bạn vui lòng chụp ảnh lỗi lên.
{"id":53126,"crm_contact_id":74807,"name":"Trang Anh","email":"nguyenthinoansuong@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2019-04-20 16:41:44","confirmation_code":"b2e35db96585f1fb6380b17f0d79245b","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-04-17T03:05:15.000000Z","updated_at":"2022-07-12T14:15:32.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1626188637.jpg","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Nguy\u1ec5n th\u1ecb n\u01a1","address":"2450 qu\u1ed1c l\u1ed9 l1a, ph\u01b0\u1eddng trung m\u1ef9 t\u00e2y, qu\u1eadn 12, 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":"0937810364","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":21806,"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":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\/1626188637.jpg","link_profile":"https:\/\/gitiho.com\/u\/53126-trang-anh","business_employers":[],"vip_account":null,"roles":[]}

Trang Anh 07 Aug 2021

Mình cũng bị như trên, nhập xong cũng hiện value

{"id":53126,"crm_contact_id":74807,"name":"Trang Anh","email":"nguyenthinoansuong@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2019-04-20 16:41:44","confirmation_code":"b2e35db96585f1fb6380b17f0d79245b","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-04-17T03:05:15.000000Z","updated_at":"2022-07-12T14:15:32.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1626188637.jpg","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Nguy\u1ec5n th\u1ecb n\u01a1","address":"2450 qu\u1ed1c l\u1ed9 l1a, ph\u01b0\u1eddng trung m\u1ef9 t\u00e2y, qu\u1eadn 12, 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":"0937810364","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":21806,"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":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\/1626188637.jpg","link_profile":"https:\/\/gitiho.com\/u\/53126-trang-anh","business_employers":[],"vip_account":null,"roles":[]}

Trang Anh 07 Aug 2021

Nhờ Thầy kiểm tra và chỉ giúp ạ
{"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] 09 Aug 2021

Chào bạn hàm đó bạn copy vào name và datavalication sẽ không bị lỗi do máy bạn không phải office 365 nên sẽ có lỗi này

Mai Ngọc Cương

Mai Ngọc Cương 02 Jun 2021


Mai Ngọc Cương

Mai Ngọc Cương 02 Jun 2021

THẦY GIÚP E VỚI Ạ. eM CẢM Ơ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] 02 Jun 2021

Chào bạn vậy giấ trị máy kia dùng để làm gì vậy?

{"id":77429,"crm_contact_id":26045,"name":"Mai Ng\u1ecdc C\u01b0\u01a1ng","email":"ngoccuongnicol@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2019-10-25 11:56:57","confirmation_code":"f8df7a6b1f17a532ff41251d2766c577","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-24T03:03:38.000000Z","updated_at":"2022-11-02T10:57:24.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Mai Ng\u1ecdc C\u01b0\u01a1ng","address":"Cty TNHH Mai V\u0103n \u0110\u00e1ng: \u0110\u01b0\u1eddng Ph\u1ea1m Ng\u0169 L\u00e3o, KCN H\u00f2a X\u00e1, Tp Nam \u0110\u1ecbnh, Nam \u0110\u1ecbnh","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0943600139","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":28132,"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":21,"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\/dad.png","link_profile":"https:\/\/gitiho.com\/u\/77429-mai-ngoc-cuong","business_employers":[],"vip_account":null,"roles":[]}

Mai Ngọc Cương 02 Jun 2021

dẤU x LÀ E BỐ TRÍ Ở MÁY, NÉU CÓ CHỮ X THÌ KẾT QUẢ ĐÓ ĐƯỢC TÍNH CHO MÁY ĐÓ Ạ

{"id":77429,"crm_contact_id":26045,"name":"Mai Ng\u1ecdc C\u01b0\u01a1ng","email":"ngoccuongnicol@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2019-10-25 11:56:57","confirmation_code":"f8df7a6b1f17a532ff41251d2766c577","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-24T03:03:38.000000Z","updated_at":"2022-11-02T10:57:24.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Mai Ng\u1ecdc C\u01b0\u01a1ng","address":"Cty TNHH Mai V\u0103n \u0110\u00e1ng: \u0110\u01b0\u1eddng Ph\u1ea1m Ng\u0169 L\u00e3o, KCN H\u00f2a X\u00e1, Tp Nam \u0110\u1ecbnh, Nam \u0110\u1ecbnh","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0943600139","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":28132,"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":21,"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\/dad.png","link_profile":"https:\/\/gitiho.com\/u\/77429-mai-ngoc-cuong","business_employers":[],"vip_account":null,"roles":[]}

Mai Ngọc Cương 02 Jun 2021

GIẢ SỬ CÓ NHIỀU MÁY, THÌ E KHÔNG DÙNG LIST MÁY ĐỂ CHỌN, NÓ LÂU (DÙNG 1 CỘT MÁY, SAU ĐÓ CHỌN MÁY THÌ TÌM MỎI MẮT LẮ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] 02 Jun 2021

Chào bạn vậy cột phụ kia của bạn có ý nghĩa gì vậy?

{"id":77429,"crm_contact_id":26045,"name":"Mai Ng\u1ecdc C\u01b0\u01a1ng","email":"ngoccuongnicol@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2019-10-25 11:56:57","confirmation_code":"f8df7a6b1f17a532ff41251d2766c577","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-24T03:03:38.000000Z","updated_at":"2022-11-02T10:57:24.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Mai Ng\u1ecdc C\u01b0\u01a1ng","address":"Cty TNHH Mai V\u0103n \u0110\u00e1ng: \u0110\u01b0\u1eddng Ph\u1ea1m Ng\u0169 L\u00e3o, KCN H\u00f2a X\u00e1, Tp Nam \u0110\u1ecbnh, Nam \u0110\u1ecbnh","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0943600139","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":28132,"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":21,"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\/dad.png","link_profile":"https:\/\/gitiho.com\/u\/77429-mai-ngoc-cuong","business_employers":[],"vip_account":null,"roles":[]}

Mai Ngọc Cương 02 Jun 2021

DẠ, E ĐANG KHÔNG TÍNH TỔNG ĐƯỢC NÊN E DÙNG CỘT PHỤ ĐẤY Ạ

{"id":77429,"crm_contact_id":26045,"name":"Mai Ng\u1ecdc C\u01b0\u01a1ng","email":"ngoccuongnicol@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2019-10-25 11:56:57","confirmation_code":"f8df7a6b1f17a532ff41251d2766c577","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-24T03:03:38.000000Z","updated_at":"2022-11-02T10:57:24.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Mai Ng\u1ecdc C\u01b0\u01a1ng","address":"Cty TNHH Mai V\u0103n \u0110\u00e1ng: \u0110\u01b0\u1eddng Ph\u1ea1m Ng\u0169 L\u00e3o, KCN H\u00f2a X\u00e1, Tp Nam \u0110\u1ecbnh, Nam \u0110\u1ecbnh","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0943600139","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":28132,"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":21,"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\/dad.png","link_profile":"https:\/\/gitiho.com\/u\/77429-mai-ngoc-cuong","business_employers":[],"vip_account":null,"roles":[]}

Mai Ngọc Cương 02 Jun 2021

E CÓ THỂ DÙNG HÀM GÌ MÀ HÀM NƯ NÀO ĐỂ E RA LUÔN SỐ 210 VẬY Ạ
{"id":77429,"crm_contact_id":26045,"name":"Mai Ng\u1ecdc C\u01b0\u01a1ng","email":"ngoccuongnicol@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2019-10-25 11:56:57","confirmation_code":"f8df7a6b1f17a532ff41251d2766c577","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-24T03:03:38.000000Z","updated_at":"2022-11-02T10:57:24.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Mai Ng\u1ecdc C\u01b0\u01a1ng","address":"Cty TNHH Mai V\u0103n \u0110\u00e1ng: \u0110\u01b0\u1eddng Ph\u1ea1m Ng\u0169 L\u00e3o, KCN H\u00f2a X\u00e1, Tp Nam \u0110\u1ecbnh, Nam \u0110\u1ecbnh","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0943600139","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":28132,"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":21,"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\/dad.png","link_profile":"https:\/\/gitiho.com\/u\/77429-mai-ngoc-cuong","business_employers":[],"vip_account":null,"roles":[]}

Mai Ngọc Cương 02 Jun 2021

vÀ KHI ẨN 1 DÒNG KHI SORT THÌ TỔNG NÓ CŨNG PHẢI THAY ĐỔI THEO Ạ
{"id":77429,"crm_contact_id":26045,"name":"Mai Ng\u1ecdc C\u01b0\u01a1ng","email":"ngoccuongnicol@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2019-10-25 11:56:57","confirmation_code":"f8df7a6b1f17a532ff41251d2766c577","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-24T03:03:38.000000Z","updated_at":"2022-11-02T10:57:24.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Mai Ng\u1ecdc C\u01b0\u01a1ng","address":"Cty TNHH Mai V\u0103n \u0110\u00e1ng: \u0110\u01b0\u1eddng Ph\u1ea1m Ng\u0169 L\u00e3o, KCN H\u00f2a X\u00e1, Tp Nam \u0110\u1ecbnh, Nam \u0110\u1ecbnh","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0943600139","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":28132,"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":21,"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\/dad.png","link_profile":"https:\/\/gitiho.com\/u\/77429-mai-ngoc-cuong","business_employers":[],"vip_account":null,"roles":[]}

Mai Ngọc Cương 02 Jun 2021

VÀ NẾU CÓ DẤU "X" THÌ TÍNH TỔNG CHO MÁ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] 02 Jun 2021

Chào bạn bạn dùng công thức sau nhé

=SUMPRODUCT(B1:B5,C1:C5,D1:D5)
{"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] 02 Jun 2021

Hoặc bạn đọc bài viết sau nhé

https://gitiho.com/blog/huong-dan-chi...

{"id":77429,"crm_contact_id":26045,"name":"Mai Ng\u1ecdc C\u01b0\u01a1ng","email":"ngoccuongnicol@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2019-10-25 11:56:57","confirmation_code":"f8df7a6b1f17a532ff41251d2766c577","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-24T03:03:38.000000Z","updated_at":"2022-11-02T10:57:24.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Mai Ng\u1ecdc C\u01b0\u01a1ng","address":"Cty TNHH Mai V\u0103n \u0110\u00e1ng: \u0110\u01b0\u1eddng Ph\u1ea1m Ng\u0169 L\u00e3o, KCN H\u00f2a X\u00e1, Tp Nam \u0110\u1ecbnh, Nam \u0110\u1ecbnh","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0943600139","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":28132,"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":21,"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\/dad.png","link_profile":"https:\/\/gitiho.com\/u\/77429-mai-ngoc-cuong","business_employers":[],"vip_account":null,"roles":[]}

Mai Ngọc Cương 02 Jun 2021

Vâng e cảm ơn, nhưng dùng sumproduct thì khi ẩn dòng nó vẫn tính giá trị dòng ẩn, e đang không biết kết hợp với subtotal hay if như nào

{"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] 02 Jun 2021

Chào bạn không được bạn nhé. vì sumproduct tính cả dòng ẩn, bạn muốn tối ưu có thể dùng code vba

{"id":77429,"crm_contact_id":26045,"name":"Mai Ng\u1ecdc C\u01b0\u01a1ng","email":"ngoccuongnicol@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2019-10-25 11:56:57","confirmation_code":"f8df7a6b1f17a532ff41251d2766c577","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-24T03:03:38.000000Z","updated_at":"2022-11-02T10:57:24.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Mai Ng\u1ecdc C\u01b0\u01a1ng","address":"Cty TNHH Mai V\u0103n \u0110\u00e1ng: \u0110\u01b0\u1eddng Ph\u1ea1m Ng\u0169 L\u00e3o, KCN H\u00f2a X\u00e1, Tp Nam \u0110\u1ecbnh, Nam \u0110\u1ecbnh","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0943600139","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":28132,"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":21,"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\/dad.png","link_profile":"https:\/\/gitiho.com\/u\/77429-mai-ngoc-cuong","business_employers":[],"vip_account":null,"roles":[]}

Mai Ngọc Cương 02 Jun 2021


{"id":77429,"crm_contact_id":26045,"name":"Mai Ng\u1ecdc C\u01b0\u01a1ng","email":"ngoccuongnicol@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2019-10-25 11:56:57","confirmation_code":"f8df7a6b1f17a532ff41251d2766c577","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-24T03:03:38.000000Z","updated_at":"2022-11-02T10:57:24.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Mai Ng\u1ecdc C\u01b0\u01a1ng","address":"Cty TNHH Mai V\u0103n \u0110\u00e1ng: \u0110\u01b0\u1eddng Ph\u1ea1m Ng\u0169 L\u00e3o, KCN H\u00f2a X\u00e1, Tp Nam \u0110\u1ecbnh, Nam \u0110\u1ecbnh","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0943600139","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":28132,"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":21,"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\/dad.png","link_profile":"https:\/\/gitiho.com\/u\/77429-mai-ngoc-cuong","business_employers":[],"vip_account":null,"roles":[]}

Mai Ngọc Cương 02 Jun 2021

Nhiều ký tự quá, giờ phải làm thế nào ạ

{"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] 02 Jun 2021

Chào bạn bạn xem điều kiện để cắt công thức đó ra nhé.

Nguyễn Thị Ánh Huyền

Nguyễn Thị Ánh Huyền 29 May 2021

em xin hỏi một câu không liên quan đến excel nhờ thầy giải đáp hộ ạ. có cách nào xóa lịch sử tìm kiếm mail trên outlook không ạ?

Tuấn Ba

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

Choà bạn bạn làm theo bài này của microsoft nhé:

https://support.microsoft.com/vi-vn/o...

Mai Ngọc Cương

Mai Ngọc Cương 14 May 2021

Vlookup, hay index + match

E có 1 bảng 2 cột: 1 cột là số: từ 0, 1,...,9 và 1 cột là chữ từ a,b,c,...

1 ô điều kiện nhập số: 8560. E dùng hàm =right(8560,1) = 0. Lúc này số 0 là định dạng text

E đổi cột số trong bảng thành định dạng text nhưng khi dùng hàm vlookup hay index+match mà vẫn không tìm được ở cột tương ứng. Mong thầy giúp đỡ. Em cảm ơn!

Tuấn Ba

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

Chào bạn, bạn có thể đẩy file lên giúp gitiho được không?

{"id":77429,"crm_contact_id":26045,"name":"Mai Ng\u1ecdc C\u01b0\u01a1ng","email":"ngoccuongnicol@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2019-10-25 11:56:57","confirmation_code":"f8df7a6b1f17a532ff41251d2766c577","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-24T03:03:38.000000Z","updated_at":"2022-11-02T10:57:24.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Mai Ng\u1ecdc C\u01b0\u01a1ng","address":"Cty TNHH Mai V\u0103n \u0110\u00e1ng: \u0110\u01b0\u1eddng Ph\u1ea1m Ng\u0169 L\u00e3o, KCN H\u00f2a X\u00e1, Tp Nam \u0110\u1ecbnh, Nam \u0110\u1ecbnh","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0943600139","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":28132,"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":21,"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\/dad.png","link_profile":"https:\/\/gitiho.com\/u\/77429-mai-ngoc-cuong","business_employers":[],"vip_account":null,"roles":[]}

Mai Ngọc Cương 14 May 2021

EM KHÔNG THẤY CHỖ NÀO UP FILE Ạ

{"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 May 2021

Chào bạn, bạn đẩy file lên google drive và cho gitiho xin link'

{"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 May 2021

Chào bạn công thức như sau:

=INDEX($C$4:$C$13,MATCH(VALUE(RIGHT(F2,1)),B4:B13,0))

=VLOOKUP(VALUE(RIGHT(F2,1)),CHOOSE({1,2},B4:B13,C4:C13),2,0)

{"id":77429,"crm_contact_id":26045,"name":"Mai Ng\u1ecdc C\u01b0\u01a1ng","email":"ngoccuongnicol@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2019-10-25 11:56:57","confirmation_code":"f8df7a6b1f17a532ff41251d2766c577","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-24T03:03:38.000000Z","updated_at":"2022-11-02T10:57:24.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Mai Ng\u1ecdc C\u01b0\u01a1ng","address":"Cty TNHH Mai V\u0103n \u0110\u00e1ng: \u0110\u01b0\u1eddng Ph\u1ea1m Ng\u0169 L\u00e3o, KCN H\u00f2a X\u00e1, Tp Nam \u0110\u1ecbnh, Nam \u0110\u1ecbnh","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0943600139","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":28132,"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":21,"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\/dad.png","link_profile":"https:\/\/gitiho.com\/u\/77429-mai-ngoc-cuong","business_employers":[],"vip_account":null,"roles":[]}

Mai Ngọc Cương 14 May 2021

Em đã làm được, Em cảm ơ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] 14 May 2021

Chúc bạn học tốt cùng gitiho, cảm ơn bạn

Phạm Thị Hạnh

Phạm Thị Hạnh 08 Apr 2020

chào thầy, thầy cho tôi hỏi :tôi muốn tìm giá trị ở 1 cột trong bảng ex thỏa mãn 2 điều kiện thì dùng hàm gì ạ.
Dương Mạnh Quân

Dương Mạnh Quân [Giảng viên] 08 Apr 2020

bạn dùng hàm countifs nhé.
=COUNTIFS(Cột 1, điều kiện 1, Cột 2, điều kiện 2)
nếu kết quả ra >0 thì có xuất hiện, còn =0 là không có
{"id":77429,"crm_contact_id":26045,"name":"Mai Ng\u1ecdc C\u01b0\u01a1ng","email":"ngoccuongnicol@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2019-10-25 11:56:57","confirmation_code":"f8df7a6b1f17a532ff41251d2766c577","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-24T03:03:38.000000Z","updated_at":"2022-11-02T10:57:24.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Mai Ng\u1ecdc C\u01b0\u01a1ng","address":"Cty TNHH Mai V\u0103n \u0110\u00e1ng: \u0110\u01b0\u1eddng Ph\u1ea1m Ng\u0169 L\u00e3o, KCN H\u00f2a X\u00e1, Tp Nam \u0110\u1ecbnh, Nam \u0110\u1ecbnh","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0943600139","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":28132,"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":21,"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\/dad.png","link_profile":"https:\/\/gitiho.com\/u\/77429-mai-ngoc-cuong","business_employers":[],"vip_account":null,"roles":[]}

Mai Ngọc Cương 14 May 2021

Em nghĩ tìm thì phải dùng Vlook up hay index + match. nếu muốn 2 điều kiện thì kết hợp IF. CUONTIF là hàm đế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] 14 May 2021

Chào bạn nếu bạn tìm kiếm nhiều điều kiện thì dùng index+match

Liêu Bửu Phụng

Liêu Bửu Phụng 24 Oct 2020

Dù đã bật Macro như hướng dẫn vẫn ko mở vào được ạ
Tuấn Ba

Tuấn Ba [Chuyên gia] 26 Oct 2020

Chào bạn bạn có ultraview không gửi cho mình vào giờ hành chính mình vào xem lại cho

Liêu Bửu Phụng

Liêu Bửu Phụng 24 Oct 2020


Tuấn Ba

Tuấn Ba [Chuyên gia] 26 Oct 2020

Chào bạn bạn xem bài này nhé:

https://gitiho.com/blog/cach-kich-hoa...

Kích hoạt macro vĩnh viễn ở một vị trí đáng tin cậy

Mai Ngọc Cương

Mai Ngọc Cương 28 Aug 2020

Thầy cho e hỏi, e làm báo cáo Pivot Table thì bên kết quả không có dấu tách phần nghìn, e lại phải định dạng lại. Có cách nào để nó xuất hiện luôn không ạ, e đang để dấu phẩy là phân tách hàng nghìn
Tuấn Ba

Tuấn Ba [Chuyên gia] 28 Aug 2020

Chào bạn cái đó bạn bắt buộc phải định dạng lại nhé.

{"id":77429,"crm_contact_id":26045,"name":"Mai Ng\u1ecdc C\u01b0\u01a1ng","email":"ngoccuongnicol@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2019-10-25 11:56:57","confirmation_code":"f8df7a6b1f17a532ff41251d2766c577","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-24T03:03:38.000000Z","updated_at":"2022-11-02T10:57:24.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Mai Ng\u1ecdc C\u01b0\u01a1ng","address":"Cty TNHH Mai V\u0103n \u0110\u00e1ng: \u0110\u01b0\u1eddng Ph\u1ea1m Ng\u0169 L\u00e3o, KCN H\u00f2a X\u00e1, Tp Nam \u0110\u1ecbnh, Nam \u0110\u1ecbnh","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0943600139","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":28132,"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":21,"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\/dad.png","link_profile":"https:\/\/gitiho.com\/u\/77429-mai-ngoc-cuong","business_employers":[],"vip_account":null,"roles":[]}

Mai Ngọc Cương 28 Aug 2020

dạ vâng

Nguyễn Tuân

Nguyễn Tuân 30 Jul 2020

Chào thầy, e có 1 file tổng hợp dữ liệu lấy từ trên website về. ( dữ liệu lấy trong 48 thời điểm 30 phút 1 lần) tuy nhiên có những thời điểm bị mất không cho ra dữ liệu. Và e đang phải thực hiện thủ công bằng cách so sánh với 1 dữ liệu đủ 48 thời điểm. Thầy có cách nào xử lý nhanh không? https://imgur.com/a/lHTlmPf
Dương Mạnh Quân

Dương Mạnh Quân [Giảng viên] 03 Aug 2020

Nội dung này hiện vượt ngoài phạm vi của khóa học này bạn nhé. Bạn có thể tham khảo Power BI để giải quyết vấn đề này sẽ tốt hơn.
{"id":95424,"crm_contact_id":31,"name":"Nguy\u1ec5n Tu\u00e2n","email":"tuankeu18990@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2020-07-03 10:35:00","confirmation_code":"53212707b1aa792add9af321712a337a","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2020-07-03T03:26:18.000000Z","updated_at":"2021-10-25T22:57:03.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Nguy\u1ec5n Tu\u00e2n","address":"ck","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0915976363","become_teacher":0,"primary_wallet":0,"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":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\/doctor.png","link_profile":"https:\/\/gitiho.com\/u\/95424-nguyen-tuan","business_employers":[],"vip_account":null,"roles":[]}

Nguyễn Tuân 04 Aug 2020

Cảm ơn
Phạm Anh Tuấn

Phạm Anh Tuấn 01 Jul 2020

Làm thế nào để lọc danh sác nhân viên theo bộ phận vậy? Thầy hướng dẫn giúp
Tuấn Ba

Tuấn Ba [Chuyên gia] 02 Jul 2020

Chào bạn bạn có thể cho mình xem file đính kèm hoặc là đính kèm, bạn xem file bên dưới:
https://blog.gitiho.com/cach-loai-bo-...
Mai Ngọc Cương

Mai Ngọc Cương 01 Jul 2020

E ĐÃ ĐỂ NGÀY THÁNG ĐÚNG ĐỊNH DẠNG, NHƯNG KHÔNG XUẤT HIỆN TRƯỜNG DỮ LIỆU THÁNG, GROUP KHÔNG ĐƯỢC Ạ. MONG THẦY HƯỚNG DẪN Ạ. E CẢM ƠN
Dương Mạnh Quân

Dương Mạnh Quân [Giảng viên] 01 Jul 2020

Nếu Pivot Table không tự động tạo trường Tháng thì bạn có thể làm bằng cách:
1. Tạo thêm 1 cột Tháng trong bảng dữ liệu, dùng hàm MONTH để xác định số tháng từ cột Ngày.
2. Refresh lại bảng Pivot
Khi đó sẽ xuất hiện trường Tháng
{"id":77429,"crm_contact_id":26045,"name":"Mai Ng\u1ecdc C\u01b0\u01a1ng","email":"ngoccuongnicol@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2019-10-25 11:56:57","confirmation_code":"f8df7a6b1f17a532ff41251d2766c577","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-24T03:03:38.000000Z","updated_at":"2022-11-02T10:57:24.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Mai Ng\u1ecdc C\u01b0\u01a1ng","address":"Cty TNHH Mai V\u0103n \u0110\u00e1ng: \u0110\u01b0\u1eddng Ph\u1ea1m Ng\u0169 L\u00e3o, KCN H\u00f2a X\u00e1, Tp Nam \u0110\u1ecbnh, Nam \u0110\u1ecbnh","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0943600139","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":28132,"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":21,"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\/dad.png","link_profile":"https:\/\/gitiho.com\/u\/77429-mai-ngoc-cuong","business_employers":[],"vip_account":null,"roles":[]}

Mai Ngọc Cương 01 Jul 2020

Bảng dữ liệu của e có nhiều công thức tìm kiếm, nếu e thêm cột sẽ sửa rất lâu, vậy có cách nào để xuất hiện lại trường tháng mà không thêm cột rồi dùng hàm month k ạ
Phạm Anh Tuấn

Phạm Anh Tuấn 24 Jun 2020

Tại sao trong bảng dự liệu tại cột số tiền mình vẫn để các công thức (ko copy paste value) thì Advance Filter lại không lọc được vậy thầy?
Tuấn Ba

Tuấn Ba [Chuyên gia] 24 Jun 2020

Chào bạn bạn kiểm tra lại tên tiêu đề xem có chuẩn không nhé.
Mai Ngọc Cương

Mai Ngọc Cương 17 Jun 2020

thầy cho e hỏi chút ạ, khi e dùng hàm index và match để tìm giá trị, khi không có thì xuất hiện N/A, lúc e tính tổng sẽ không được. Thầy hướng dẫn cho e được không ạ. Em cảm ơn
Dương Mạnh Quân

Dương Mạnh Quân [Giảng viên] 17 Jun 2020

để tránh lỗi NA bạn có thể kết hợp hàm bẫy lỗi:
https://blog.gitiho.com/cach-su-dung-...
Nếu gặp lỗi NA bạn đưa về giá trị số 0 thì sẽ tính toán được.
{"id":77429,"crm_contact_id":26045,"name":"Mai Ng\u1ecdc C\u01b0\u01a1ng","email":"ngoccuongnicol@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2019-10-25 11:56:57","confirmation_code":"f8df7a6b1f17a532ff41251d2766c577","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-24T03:03:38.000000Z","updated_at":"2022-11-02T10:57:24.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Mai Ng\u1ecdc C\u01b0\u01a1ng","address":"Cty TNHH Mai V\u0103n \u0110\u00e1ng: \u0110\u01b0\u1eddng Ph\u1ea1m Ng\u0169 L\u00e3o, KCN H\u00f2a X\u00e1, Tp Nam \u0110\u1ecbnh, Nam \u0110\u1ecbnh","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0943600139","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":28132,"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":21,"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\/dad.png","link_profile":"https:\/\/gitiho.com\/u\/77429-mai-ngoc-cuong","business_employers":[],"vip_account":null,"roles":[]}

Mai Ngọc Cương 18 Jun 2020

EM LÀM ĐƯỢC RỒI, E CẢM ƠN. EM DÙNG "IFNA"
Nguyễn Thị Duyên

Nguyễn Thị Duyên 08 Mar 2020

Thầy ơi, Ấn Ctrl D ra được Chi nhánh và Nhân viên nhưng ngày tiến chứ ko ra hết Tháng cho cả 4 chi nhánh được thầy?
Tuấn Ba

Tuấn Ba [Chuyên gia] 08 Mar 2020

Chào bạn, vậy bạn cố định nội dung như thế nào?
{"id":92128,"crm_contact_id":16818,"name":"Ph\u1ea1m Anh Tu\u1ea5n","email":"anhtuan.udc@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2020-05-23 11:25:40","confirmation_code":"38d84ed0580331f7188cfdccfecb5864","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2020-05-21T12:55:41.000000Z","updated_at":"2022-12-04T05:23:10.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Ph\u1ea1m Anh Tu\u1ea5n","address":"S\u1ed1 4 , Nguy\u1ec5n Thi\u1ec7n Thu\u1eadt, Ph\u01b0\u1eddng 26, B\u00ecnh Th\u1ea1nh, TP HCM ,S\u1ed1 4 , Nguy\u1ec5n Thi\u1ec7n Thu\u1eadt, Ph\u01b0\u1eddng 26, B\u00ecnh Th\u1ea1nh, TP HCM\u00a0","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0908818083","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":81300,"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\/dad.png","link_profile":"https:\/\/gitiho.com\/u\/92128-pham-anh-tuan","business_employers":[],"vip_account":null,"roles":[]}

Phạm Anh Tuấn 16 Jun 2020

Tại sao mình cũng bị trường hợp như vậy? Thầy hướng dẫn giúp
{"id":92128,"crm_contact_id":16818,"name":"Ph\u1ea1m Anh Tu\u1ea5n","email":"anhtuan.udc@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2020-05-23 11:25:40","confirmation_code":"38d84ed0580331f7188cfdccfecb5864","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2020-05-21T12:55:41.000000Z","updated_at":"2022-12-04T05:23:10.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Ph\u1ea1m Anh Tu\u1ea5n","address":"S\u1ed1 4 , Nguy\u1ec5n Thi\u1ec7n Thu\u1eadt, Ph\u01b0\u1eddng 26, B\u00ecnh Th\u1ea1nh, TP HCM ,S\u1ed1 4 , Nguy\u1ec5n Thi\u1ec7n Thu\u1eadt, Ph\u01b0\u1eddng 26, B\u00ecnh Th\u1ea1nh, TP HCM\u00a0","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0908818083","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":81300,"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\/dad.png","link_profile":"https:\/\/gitiho.com\/u\/92128-pham-anh-tuan","business_employers":[],"vip_account":null,"roles":[]}

Phạm Anh Tuấn 16 Jun 2020

ah mình hiểu rồi, thay vì chọn C17=C2+1 thì minh lại chọn C17=C16 +1
{"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] 17 Jun 2020

Cảm ơn bạn đã tin tưởng và đồng hành cùng gitiho
EXG03 - Kỹ năng báo cáo - Tư duy tổ chức dữ liệu trên Excel
4.79

(34 đánh giá)

1,402 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
/