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

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

Trang bị cho học viên đầy đủ các kiến thức từ cơ bản đến nâng cao về bảng tính Excel 365
Các kỹ năng định dạng bảng tính, sử dụng các hàm phổ biến nhất cũng như những cập nhật mới nhất của Office 365.
Cung cấp cho học viên những thủ thuật hữu ích nhằm nâng cao hiệu quả làm việc với bảng tính Excel.
Học viên thành thạo tin học văn phòng sẽ có ưu thế và nổi bật hơn trong mắt các nhà tuyển dụng.
Tự tin làm chủ phần mềm Excel 365, góp phần nâng cao hiệu suất và hiệu quả công việc
Tự tin với khối lượng kiến thức lớn để thi chứng chỉ tin học văn phòng Excel đạt điểm tốt nhất

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

Video

3h 45m giờ học

Article

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

Material

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

Exam questions

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

Nội dung khoá học

12 Chương . 49 bài giảng . 3h 45m giờ học

Mở rộng tất cả các phần

Tổng quan về office 365

0 bài giảng • 21 phút

Mô tả khoá học

❓ Có phải bạn thường xuyên phải xử lý dữ liệu, phân tích, thống kê tính toán trong Excel nhưng không rành hoặc mơ hồ về các hàm Excel?

❓ Bạn là học sinh, sinh viên đang chuẩn bị thi chứng chỉ Excel nhưng chưa thành thạo các Hàm Excel để đi thi?

❓ Bạn thấy các hàm trong Excel khó và rắc rối, học trước quên sau và muốn có một giải pháp học tin học văn phòng giúp bạn dễ nhớ hơn?

❓ Bạn đang làm quen với Excel 365 mà không biết bắt đầu từ đâu ? 

Bạn có biết:

Tin học văn phòng là một kỹ năng thiết yếu cho mọi người hiện nay và đã trở thành một tiêu chuẩn tuyển dụng ở nhiều công ty, đặc biệt những vị trí Nhân viên văn phòng, cần xử lý công việc giấy tờ, máy tính, thuyết trình.....

Trong đó Microsoft Excel là công cụ thông dụng mà hầu hết các doanh nghiệp và cá nhân đang sử dụng. Excel là một trong những kỹ năng mà bạn cần nắm vững để xử lý mọi vấn đề liên quan.  Tuy nhiên, rất nhiều người dùng chỉ sử dụng được tối đa 5% các tính năng có sẵn của nó, điều này dẫn đến hiệu quả công việc đạt được là không cao, lãng phí rất nhiều tiềm năng thật sự mà Excel có thể đem lại.

Nhận thấy nhu cầu bức thiết trên của đông đảo người học, chúng tôi đã kết hợp với giảng viên Đỗ Trung Thành đem đến cho bạn Khóa học "Thành thạo bảng tính Excel 365 từ A - Z".

Khóa học "Thành thạo bảng tính Excel 365 từ A - Z" sẽ tập trung đi sâu vào giảng dạy cách sử dụng từng nhóm Hàm Excel và ứng dụng của nó vào thực tế để xử lý, phân tích, thống kê dữ liệu một cách nhanh chóng.

Khóa học gồm 48 bài giảng với các phần học Giải các bài tập tổng hợp, giúp bạn dễ dàng nắm bắt nội dung, được hướng dẫn thực hành luôn, giúp bạn ôn luyện thi chứng chỉ Excel.

Với nội dung bài học được chia nhỏ theo từng tính năng kết hợp với phương pháp thực hành trực quan, khóa học sẽ giúp  bạn: Nắm vững các tính năng cơ bản nhất của Excel 2010 với thời gian nhanh nhất để giúp bạn vận dụng thành thạo các hàm tính cơ bản vào công việc, bảo mật file excel, đồng thời quản lí tài liệu một cách hiệu quả.

Giảng viên:

Đỗ Trung Thành Giảng viên

Giáo viên

Đỗ Trung Thành
  • 3 điểm đánh giá

  • 3 đánh giá

  • 41 học viên

  • 4 khóa học

Trình độ: Thạc sỹ Khoa học Máy tính

Có kinh nghiệm giảng dạy Tin học Văn phòng; thiết kế đồ họa; biên tập âm thanh; biên tập videos; lập trình thiết kế, xây dựng website, xây dựng phần mềm với các ngôn ngữ C# và PHP

Học viên cũng mua

EXG02 - Thủ thuật Excel cập nhật hàng tuần cho dân văn phòng
107 bài giảng
4.68
73,476
199,000 đ
499,000 đ
EXG02 - Thủ thuật Excel cập nhật hàng tuần cho dân văn phòng
EXG01: Tuyệt đỉnh Excel | Khóa học Excel online từ cơ bản đến nâng cao
207 bài giảng
4.82
43,806
499,000 đ
799,000 đ
EXG01: Tuyệt đỉnh Excel | Khóa học Excel online từ cơ bản đến nâng cao

Hỏi đáp khóa học

0 thảo luận

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

52 thảo luận

Hồ Kim Hằng

Hồ Kim Hằng

Các bài giảng đều ngắn gọn và dễ hiểu nhưng lại không có bài tập để học viên thực hành. Nhờ thầy hỗ trợ ạ.

Trợ Giảng Gitiho

Trợ Giảng Gitiho

Dạ vâng Anh/Chị vui lòng truy cập vào chương 6 và tải tài liệu ở mục 49 này ạ.

Lê Thị Mỹ Phúc

Lê Thị Mỹ Phúc

Trợ Giảng Gitiho

Trợ Giảng Gitiho

Dạ vâng Gitiho xin giải  đáp thắc mắc của Anh/Chị như sau ạ. Đối với việc bằng kí tự thì Anh/Chị nên bỏ vào ngoặc. Ví dụ

left(B2,1)="D" ạ. Và ở cuối là ADM đang thiếu 1 dấu " ạ

Đỗ Anh Tuấn

Đỗ Anh Tuấn

Bài giảng chưa có nội dung để hiển thị lúc này! Ad ơi?

Trợ Giảng Gitiho

Trợ Giảng Gitiho

Dạ vâng Gitiho xin ghi nhận đóng góp của Anh/Chị và liên lạc với giảng viên để kiểm tra ạ!

Đỗ Anh Tuấn

Đỗ Anh Tuấn

Thiếu bài 22?

Trợ Giảng Gitiho

Trợ Giảng Gitiho

Dạ vâng Gitiho ghi nhận thông tin và liên lạc với giảng viên để kiểm tra ạ!

Lê Thị Mỹ Phúc

Lê Thị Mỹ Phúc

Trợ Giảng Gitiho

Trợ Giảng Gitiho

Dạ Anh/Chị upfile để Gitiho có thể sớm trả lời thắc mắc của Anh/Chị ạ!

{"id":343185,"crm_contact_id":599343,"name":"L\u00ea Th\u1ecb M\u1ef9 Ph\u00fac","email":"lephuc2808@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2023-07-17 14:10:00","confirmation_code":"44bf49030abb0e4ed0b1ecc0db51218c","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-07-14T02:42:10.000000Z","updated_at":"2023-07-17T07:10:00.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"C\u00d4NG TY TNHH TH\u1ee6Y S\u1ea2N AUSTRALIS VI\u1ec6T NAM -\u00a0T\u1ed5 d\u00e2n ph\u1ed1 5, \u0110\u00f4ng H\u00f2a, Ph\u01b0\u1eddng Ninh H\u1ea3i, Th\u1ecb x\u00e3 Ninh Ho\u00e0, T\u1ec9nh Kh\u00e1nh H\u00f2a,","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0973842262","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":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_343\/le-phuc.png","link_profile":"https:\/\/gitiho.com\/u\/343185-le-thi-my-phuc","vip_account":null,"roles":[]}

Lê Thị Mỹ Phúc

mình ko upfile dc, help

{"id":340417,"crm_contact_id":null,"name":"Tr\u1ee3 Gi\u1ea3ng Gitiho","email":"namnn.gitiho@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"624b981d8e74794f030f85b7fea07011","confirmed":0,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-07-03T06:37:27.000000Z","updated_at":"2024-03-27T02:09:09.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1688439444.png","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"102549768268220581564","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":67,"email_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1688439444.png","link_profile":"https:\/\/gitiho.com\/u\/340417-tro-giang-gitiho","vip_account":null,"roles":[{"id":26,"biz_business_id":0,"name":"Tr\u1ee3 gi\u1ea3ng","display_name":"Tr\u1ee3 gi\u1ea3ng","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":340417,"role_id":26,"model_type":"App\\Models\\User"}}]}

Trợ Giảng Gitiho

Dạ vậy chị có thể up lên drive và gửi link cho Gitiho ạ.

{"id":340417,"crm_contact_id":null,"name":"Tr\u1ee3 Gi\u1ea3ng Gitiho","email":"namnn.gitiho@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"624b981d8e74794f030f85b7fea07011","confirmed":0,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-07-03T06:37:27.000000Z","updated_at":"2024-03-27T02:09:09.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1688439444.png","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"102549768268220581564","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":67,"email_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1688439444.png","link_profile":"https:\/\/gitiho.com\/u\/340417-tro-giang-gitiho","vip_account":null,"roles":[{"id":26,"biz_business_id":0,"name":"Tr\u1ee3 gi\u1ea3ng","display_name":"Tr\u1ee3 gi\u1ea3ng","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":340417,"role_id":26,"model_type":"App\\Models\\User"}}]}

Trợ Giảng Gitiho

{"id":340417,"crm_contact_id":null,"name":"Tr\u1ee3 Gi\u1ea3ng Gitiho","email":"namnn.gitiho@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"624b981d8e74794f030f85b7fea07011","confirmed":0,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-07-03T06:37:27.000000Z","updated_at":"2024-03-27T02:09:09.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1688439444.png","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"102549768268220581564","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":67,"email_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1688439444.png","link_profile":"https:\/\/gitiho.com\/u\/340417-tro-giang-gitiho","vip_account":null,"roles":[{"id":26,"biz_business_id":0,"name":"Tr\u1ee3 gi\u1ea3ng","display_name":"Tr\u1ee3 gi\u1ea3ng","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":340417,"role_id":26,"model_type":"App\\Models\\User"}}]}

Trợ Giảng Gitiho

Dạ vâng Anh/Chị cho Gitiho quyền truy cập ạ :<

{"id":343185,"crm_contact_id":599343,"name":"L\u00ea Th\u1ecb M\u1ef9 Ph\u00fac","email":"lephuc2808@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2023-07-17 14:10:00","confirmation_code":"44bf49030abb0e4ed0b1ecc0db51218c","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-07-14T02:42:10.000000Z","updated_at":"2023-07-17T07:10:00.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"C\u00d4NG TY TNHH TH\u1ee6Y S\u1ea2N AUSTRALIS VI\u1ec6T NAM -\u00a0T\u1ed5 d\u00e2n ph\u1ed1 5, \u0110\u00f4ng H\u00f2a, Ph\u01b0\u1eddng Ninh H\u1ea3i, Th\u1ecb x\u00e3 Ninh Ho\u00e0, T\u1ec9nh Kh\u00e1nh H\u00f2a,","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0973842262","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":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_343\/le-phuc.png","link_profile":"https:\/\/gitiho.com\/u\/343185-le-thi-my-phuc","vip_account":null,"roles":[]}

Lê Thị Mỹ Phúc

G-853303

{"id":340417,"crm_contact_id":null,"name":"Tr\u1ee3 Gi\u1ea3ng Gitiho","email":"namnn.gitiho@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"624b981d8e74794f030f85b7fea07011","confirmed":0,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-07-03T06:37:27.000000Z","updated_at":"2024-03-27T02:09:09.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1688439444.png","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"102549768268220581564","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":67,"email_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1688439444.png","link_profile":"https:\/\/gitiho.com\/u\/340417-tro-giang-gitiho","vip_account":null,"roles":[{"id":26,"biz_business_id":0,"name":"Tr\u1ee3 gi\u1ea3ng","display_name":"Tr\u1ee3 gi\u1ea3ng","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":340417,"role_id":26,"model_type":"App\\Models\\User"}}]}

Trợ Giảng Gitiho

À là chị cấp quyền truy cập của Excel ấy ạ

{"id":340417,"crm_contact_id":null,"name":"Tr\u1ee3 Gi\u1ea3ng Gitiho","email":"namnn.gitiho@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"624b981d8e74794f030f85b7fea07011","confirmed":0,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-07-03T06:37:27.000000Z","updated_at":"2024-03-27T02:09:09.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1688439444.png","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"102549768268220581564","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":67,"email_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1688439444.png","link_profile":"https:\/\/gitiho.com\/u\/340417-tro-giang-gitiho","vip_account":null,"roles":[{"id":26,"biz_business_id":0,"name":"Tr\u1ee3 gi\u1ea3ng","display_name":"Tr\u1ee3 gi\u1ea3ng","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":340417,"role_id":26,"model_type":"App\\Models\\User"}}]}

Trợ Giảng Gitiho

 

Để cấp quyền truy cập. Chị làm như sau ạ

Bước 2: Chọn như hình ạ

{"id":343185,"crm_contact_id":599343,"name":"L\u00ea Th\u1ecb M\u1ef9 Ph\u00fac","email":"lephuc2808@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2023-07-17 14:10:00","confirmation_code":"44bf49030abb0e4ed0b1ecc0db51218c","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-07-14T02:42:10.000000Z","updated_at":"2023-07-17T07:10:00.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"C\u00d4NG TY TNHH TH\u1ee6Y S\u1ea2N AUSTRALIS VI\u1ec6T NAM -\u00a0T\u1ed5 d\u00e2n ph\u1ed1 5, \u0110\u00f4ng H\u00f2a, Ph\u01b0\u1eddng Ninh H\u1ea3i, Th\u1ecb x\u00e3 Ninh Ho\u00e0, T\u1ec9nh Kh\u00e1nh H\u00f2a,","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0973842262","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":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_343\/le-phuc.png","link_profile":"https:\/\/gitiho.com\/u\/343185-le-thi-my-phuc","vip_account":null,"roles":[]}

Lê Thị Mỹ Phúc

thầy có thể cho địa chỉ mail mình share ko, mình ko rành cấp quyền exel

{"id":340417,"crm_contact_id":null,"name":"Tr\u1ee3 Gi\u1ea3ng Gitiho","email":"namnn.gitiho@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"624b981d8e74794f030f85b7fea07011","confirmed":0,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-07-03T06:37:27.000000Z","updated_at":"2024-03-27T02:09:09.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1688439444.png","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"102549768268220581564","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":67,"email_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1688439444.png","link_profile":"https:\/\/gitiho.com\/u\/340417-tro-giang-gitiho","vip_account":null,"roles":[{"id":26,"biz_business_id":0,"name":"Tr\u1ee3 gi\u1ea3ng","display_name":"Tr\u1ee3 gi\u1ea3ng","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":340417,"role_id":26,"model_type":"App\\Models\\User"}}]}

Trợ Giảng Gitiho

Dạ vậy Gitiho gửi chị ạ: namnn.gitiho@gmail.com

{"id":343185,"crm_contact_id":599343,"name":"L\u00ea Th\u1ecb M\u1ef9 Ph\u00fac","email":"lephuc2808@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2023-07-17 14:10:00","confirmation_code":"44bf49030abb0e4ed0b1ecc0db51218c","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-07-14T02:42:10.000000Z","updated_at":"2023-07-17T07:10:00.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"C\u00d4NG TY TNHH TH\u1ee6Y S\u1ea2N AUSTRALIS VI\u1ec6T NAM -\u00a0T\u1ed5 d\u00e2n ph\u1ed1 5, \u0110\u00f4ng H\u00f2a, Ph\u01b0\u1eddng Ninh H\u1ea3i, Th\u1ecb x\u00e3 Ninh Ho\u00e0, T\u1ec9nh Kh\u00e1nh H\u00f2a,","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0973842262","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":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_343\/le-phuc.png","link_profile":"https:\/\/gitiho.com\/u\/343185-le-thi-my-phuc","vip_account":null,"roles":[]}

Lê Thị Mỹ Phúc

mình gửi rồi nhé

{"id":340417,"crm_contact_id":null,"name":"Tr\u1ee3 Gi\u1ea3ng Gitiho","email":"namnn.gitiho@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"624b981d8e74794f030f85b7fea07011","confirmed":0,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-07-03T06:37:27.000000Z","updated_at":"2024-03-27T02:09:09.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1688439444.png","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"102549768268220581564","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":67,"email_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1688439444.png","link_profile":"https:\/\/gitiho.com\/u\/340417-tro-giang-gitiho","vip_account":null,"roles":[{"id":26,"biz_business_id":0,"name":"Tr\u1ee3 gi\u1ea3ng","display_name":"Tr\u1ee3 gi\u1ea3ng","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":340417,"role_id":26,"model_type":"App\\Models\\User"}}]}

Trợ Giảng Gitiho

Dạ vâng Gitiho xin giải đáp thắc mắc của Chị như sau ạ. 

Như chị thấy ở trong bảng cũ thì đã có 1 số khu vực bị ẩn đi (Ở đây đó là dòng 7 8 10 11)

Khi xóa ẩn khu vực này sẽ được là

Mặc dù là ẩn đi những khi chị dùng hàm Sum từ E4 đến E11 như hình thì vô tình là vẫn lựa chọn các giá trị ở ô E7 E 8 E10 E11. Và các ô này có giá trị là N/A nên khi sử dụng hàm Sum thì kết quả sẽ lỗi như thế ạ

 

{"id":343185,"crm_contact_id":599343,"name":"L\u00ea Th\u1ecb M\u1ef9 Ph\u00fac","email":"lephuc2808@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2023-07-17 14:10:00","confirmation_code":"44bf49030abb0e4ed0b1ecc0db51218c","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-07-14T02:42:10.000000Z","updated_at":"2023-07-17T07:10:00.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"C\u00d4NG TY TNHH TH\u1ee6Y S\u1ea2N AUSTRALIS VI\u1ec6T NAM -\u00a0T\u1ed5 d\u00e2n ph\u1ed1 5, \u0110\u00f4ng H\u00f2a, Ph\u01b0\u1eddng Ninh H\u1ea3i, Th\u1ecb x\u00e3 Ninh Ho\u00e0, T\u1ec9nh Kh\u00e1nh H\u00f2a,","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0973842262","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":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_343\/le-phuc.png","link_profile":"https:\/\/gitiho.com\/u\/343185-le-thi-my-phuc","vip_account":null,"roles":[]}

Lê Thị Mỹ Phúc

ah, cảm ơn ạ

{"id":340417,"crm_contact_id":null,"name":"Tr\u1ee3 Gi\u1ea3ng Gitiho","email":"namnn.gitiho@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"624b981d8e74794f030f85b7fea07011","confirmed":0,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-07-03T06:37:27.000000Z","updated_at":"2024-03-27T02:09:09.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1688439444.png","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"102549768268220581564","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":67,"email_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1688439444.png","link_profile":"https:\/\/gitiho.com\/u\/340417-tro-giang-gitiho","vip_account":null,"roles":[{"id":26,"biz_business_id":0,"name":"Tr\u1ee3 gi\u1ea3ng","display_name":"Tr\u1ee3 gi\u1ea3ng","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":340417,"role_id":26,"model_type":"App\\Models\\User"}}]}

Trợ Giảng Gitiho

Dạ vâng ạ. Chúc chị học tốt cùng Gitiho ạ

{"id":343185,"crm_contact_id":599343,"name":"L\u00ea Th\u1ecb M\u1ef9 Ph\u00fac","email":"lephuc2808@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2023-07-17 14:10:00","confirmation_code":"44bf49030abb0e4ed0b1ecc0db51218c","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-07-14T02:42:10.000000Z","updated_at":"2023-07-17T07:10:00.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"C\u00d4NG TY TNHH TH\u1ee6Y S\u1ea2N AUSTRALIS VI\u1ec6T NAM -\u00a0T\u1ed5 d\u00e2n ph\u1ed1 5, \u0110\u00f4ng H\u00f2a, Ph\u01b0\u1eddng Ninh H\u1ea3i, Th\u1ecb x\u00e3 Ninh Ho\u00e0, T\u1ec9nh Kh\u00e1nh H\u00f2a,","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0973842262","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":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_343\/le-phuc.png","link_profile":"https:\/\/gitiho.com\/u\/343185-le-thi-my-phuc","vip_account":null,"roles":[]}

Lê Thị Mỹ Phúc

{"id":343185,"crm_contact_id":599343,"name":"L\u00ea Th\u1ecb M\u1ef9 Ph\u00fac","email":"lephuc2808@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2023-07-17 14:10:00","confirmation_code":"44bf49030abb0e4ed0b1ecc0db51218c","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-07-14T02:42:10.000000Z","updated_at":"2023-07-17T07:10:00.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"C\u00d4NG TY TNHH TH\u1ee6Y S\u1ea2N AUSTRALIS VI\u1ec6T NAM -\u00a0T\u1ed5 d\u00e2n ph\u1ed1 5, \u0110\u00f4ng H\u00f2a, Ph\u01b0\u1eddng Ninh H\u1ea3i, Th\u1ecb x\u00e3 Ninh Ho\u00e0, T\u1ec9nh Kh\u00e1nh H\u00f2a,","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0973842262","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":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_343\/le-phuc.png","link_profile":"https:\/\/gitiho.com\/u\/343185-le-thi-my-phuc","vip_account":null,"roles":[]}

Lê Thị Mỹ Phúc

em có thêm câu hỏi cho bài tập ở trên, Dùng hàm gì để  tìm ra được giá trị Lê và Cam cho nhân viên B, nếu dùng hàm Vlookup thì chỉ tìm ra 1 giá trị đầu tiền phải ko ạ

{"id":343185,"crm_contact_id":599343,"name":"L\u00ea Th\u1ecb M\u1ef9 Ph\u00fac","email":"lephuc2808@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2023-07-17 14:10:00","confirmation_code":"44bf49030abb0e4ed0b1ecc0db51218c","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-07-14T02:42:10.000000Z","updated_at":"2023-07-17T07:10:00.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"C\u00d4NG TY TNHH TH\u1ee6Y S\u1ea2N AUSTRALIS VI\u1ec6T NAM -\u00a0T\u1ed5 d\u00e2n ph\u1ed1 5, \u0110\u00f4ng H\u00f2a, Ph\u01b0\u1eddng Ninh H\u1ea3i, Th\u1ecb x\u00e3 Ninh Ho\u00e0, T\u1ec9nh Kh\u00e1nh H\u00f2a,","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0973842262","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":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_343\/le-phuc.png","link_profile":"https:\/\/gitiho.com\/u\/343185-le-thi-my-phuc","vip_account":null,"roles":[]}

Lê Thị Mỹ Phúc

thầy ơi trả lời giúp em câu trên ạ
{"id":340417,"crm_contact_id":null,"name":"Tr\u1ee3 Gi\u1ea3ng Gitiho","email":"namnn.gitiho@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"624b981d8e74794f030f85b7fea07011","confirmed":0,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-07-03T06:37:27.000000Z","updated_at":"2024-03-27T02:09:09.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1688439444.png","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"102549768268220581564","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":67,"email_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1688439444.png","link_profile":"https:\/\/gitiho.com\/u\/340417-tro-giang-gitiho","vip_account":null,"roles":[{"id":26,"biz_business_id":0,"name":"Tr\u1ee3 gi\u1ea3ng","display_name":"Tr\u1ee3 gi\u1ea3ng","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":340417,"role_id":26,"model_type":"App\\Models\\User"}}]}

Trợ Giảng Gitiho

Dạ vâng đúng rồi ạ. Đối với trường hợp này thì anh/chị nên sử dụng Filter để lọc nhanh hơn ạ.

{"id":343185,"crm_contact_id":599343,"name":"L\u00ea Th\u1ecb M\u1ef9 Ph\u00fac","email":"lephuc2808@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2023-07-17 14:10:00","confirmation_code":"44bf49030abb0e4ed0b1ecc0db51218c","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-07-14T02:42:10.000000Z","updated_at":"2023-07-17T07:10:00.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"C\u00d4NG TY TNHH TH\u1ee6Y S\u1ea2N AUSTRALIS VI\u1ec6T NAM -\u00a0T\u1ed5 d\u00e2n ph\u1ed1 5, \u0110\u00f4ng H\u00f2a, Ph\u01b0\u1eddng Ninh H\u1ea3i, Th\u1ecb x\u00e3 Ninh Ho\u00e0, T\u1ec9nh Kh\u00e1nh H\u00f2a,","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0973842262","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":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_343\/le-phuc.png","link_profile":"https:\/\/gitiho.com\/u\/343185-le-thi-my-phuc","vip_account":null,"roles":[]}

Lê Thị Mỹ Phúc

ngoài ra còn cách tính nào để áp dụng ko, do trong thực tế em gặp trường hợp phải đưa dữ liệu qua bảng khác phải dùng công thức

{"id":340417,"crm_contact_id":null,"name":"Tr\u1ee3 Gi\u1ea3ng Gitiho","email":"namnn.gitiho@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"624b981d8e74794f030f85b7fea07011","confirmed":0,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-07-03T06:37:27.000000Z","updated_at":"2024-03-27T02:09:09.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1688439444.png","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"102549768268220581564","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":67,"email_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1688439444.png","link_profile":"https:\/\/gitiho.com\/u\/340417-tro-giang-gitiho","vip_account":null,"roles":[{"id":26,"biz_business_id":0,"name":"Tr\u1ee3 gi\u1ea3ng","display_name":"Tr\u1ee3 gi\u1ea3ng","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":340417,"role_id":26,"model_type":"App\\Models\\User"}}]}

Trợ Giảng Gitiho

Dạ vâng chị còn có thể sử dụng hàm sau ạ:

=TEXTJOIN(", ", TRUE, IF(B3:B6="nhân viên B", D3:D6, ""))

Tuy nhiên khi điền hàm vào xong, chị cần nhấn tổ hợp phím “Ctrl + Shift + Enter”do đây là hàm mảng.

{"id":343185,"crm_contact_id":599343,"name":"L\u00ea Th\u1ecb M\u1ef9 Ph\u00fac","email":"lephuc2808@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2023-07-17 14:10:00","confirmation_code":"44bf49030abb0e4ed0b1ecc0db51218c","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-07-14T02:42:10.000000Z","updated_at":"2023-07-17T07:10:00.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"C\u00d4NG TY TNHH TH\u1ee6Y S\u1ea2N AUSTRALIS VI\u1ec6T NAM -\u00a0T\u1ed5 d\u00e2n ph\u1ed1 5, \u0110\u00f4ng H\u00f2a, Ph\u01b0\u1eddng Ninh H\u1ea3i, Th\u1ecb x\u00e3 Ninh Ho\u00e0, T\u1ec9nh Kh\u00e1nh H\u00f2a,","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0973842262","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":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_343\/le-phuc.png","link_profile":"https:\/\/gitiho.com\/u\/343185-le-thi-my-phuc","vip_account":null,"roles":[]}

Lê Thị Mỹ Phúc

{"id":343185,"crm_contact_id":599343,"name":"L\u00ea Th\u1ecb M\u1ef9 Ph\u00fac","email":"lephuc2808@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2023-07-17 14:10:00","confirmation_code":"44bf49030abb0e4ed0b1ecc0db51218c","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-07-14T02:42:10.000000Z","updated_at":"2023-07-17T07:10:00.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"C\u00d4NG TY TNHH TH\u1ee6Y S\u1ea2N AUSTRALIS VI\u1ec6T NAM -\u00a0T\u1ed5 d\u00e2n ph\u1ed1 5, \u0110\u00f4ng H\u00f2a, Ph\u01b0\u1eddng Ninh H\u1ea3i, Th\u1ecb x\u00e3 Ninh Ho\u00e0, T\u1ec9nh Kh\u00e1nh H\u00f2a,","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0973842262","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":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_343\/le-phuc.png","link_profile":"https:\/\/gitiho.com\/u\/343185-le-thi-my-phuc","vip_account":null,"roles":[]}

Lê Thị Mỹ Phúc

trong máy em ko có hàm textjoin, có cài thêm được ko vậy ạ

{"id":340417,"crm_contact_id":null,"name":"Tr\u1ee3 Gi\u1ea3ng Gitiho","email":"namnn.gitiho@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"624b981d8e74794f030f85b7fea07011","confirmed":0,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-07-03T06:37:27.000000Z","updated_at":"2024-03-27T02:09:09.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1688439444.png","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"102549768268220581564","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":67,"email_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1688439444.png","link_profile":"https:\/\/gitiho.com\/u\/340417-tro-giang-gitiho","vip_account":null,"roles":[{"id":26,"biz_business_id":0,"name":"Tr\u1ee3 gi\u1ea3ng","display_name":"Tr\u1ee3 gi\u1ea3ng","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":340417,"role_id":26,"model_type":"App\\Models\\User"}}]}

Trợ Giảng Gitiho

Dạ vâng Gitiho xin giải đáp thắc mắc của Anh/Chị là như thế thì anh/chị có 2 cách.

Cách 1: Thay đổi phiên bản khác của Office.

Cách 2: Dùng VBA → Đây là cách mở VBA ạ: https://gitiho.com/blog/huong-dan-mo-vba-trong-excel-va-tim-hieu-cac-cua-so-lam-viec-trong-vba-7166.html.

Sau đấy anh/chị điền mã sau (nhớ xóa những phần cũ và copy và paste y chang đoạn này nhé)

Function MyTextJoin(delimiter As String, ignoreEmpty As Boolean, ParamArray args()) As String
   Dim result As String
   Dim i As Integer
   Dim cellValue As Variant
   
   For Each arg In args
       If Not IsArray(arg) Then
           If Not ignoreEmpty Or arg <> "" Then
               If result = "" Then
                   result = arg
               Else
                   result = result & delimiter & arg
               End If
           End If
       Else
           For Each cellValue In arg
               If Not ignoreEmpty Or cellValue <> "" Then
                   If result = "" Then
                       result = cellValue
                   Else
                       result = result & delimiter & cellValue
                   End If
               End If
           Next cellValue
       End If
   Next arg
   
   MyTextJoin = result
End Function
 

→ Anh/Chị sử dùng hàm “MyTextJoin như trên” → =MyTextJoin(", ",TRUE,IF(B3:B6="nhân viên B",D3:D6,""))

Và Anh/Chị nhớ sử dụng tổ hợp phím Ctril + Shift + Enter nhé ạ!

399,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
Giấy phép mạng xã hội số: 588, cấp bởi Bộ Thông tin và Truyền thông
/