Lộ trình bài bản cấu trúc dễ học

Lộ trình bài bản
Ứng với từng vị trí, cấp bậc

Kiến thức thực tế dễ áp dụng

Kiến thức thực tiễn
Giải quyết ngay vấn đề trong công việc

Hỗ trợ nhanh chóng và chuyên sâu trong 24h

Giảng viên trực tiếp giải đáp
trong 8h làm việc

Nội dung cập nhật thường xuyên hàng tháng

Nội dung cập nhật hàng tháng
Đảm bảo phiên bản mới nhất

Khóa học này dành cho

Khóa học này dành cho

Biết cách sử dụng phần mềm Excel
Phiên bản Microsoft Office 2010 trở lên
Khóa học này dành cho
Bạn sẽ nhận được gì nếu đăng ký khóa học này

Bạn sẽ nhận được gì nếu đăng ký khóa học này

Bạn sẽ nhận được gì nếu đăng ký khóa học này

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

Nội dung khóa 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

Đánh giá mới nhất từ học viên

Thảo luận mới nhất khoá học

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ỉ?

Huỳnh Thị Thu Thảo
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-09-24T13:10:59.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":1041594,"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":1632,"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","avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/u\/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":42.13,"bizUser":""}],"vip_account":null,"roles":[{"id":3,"name":"User","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":3}},{"id":4,"name":"Teacher","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":4}},{"id":5,"name":"Student","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":5}},{"id":9,"name":"ContentManager","created_at":"2020-08-04T04:07:52.000000Z","updated_at":"2020-08-04T04:07:52.000000Z","pivot":{"user_id":74845,"role_id":9}},{"id":15,"name":"GitihoHumanResources","created_at":"2021-07-30T02:30:37.000000Z","updated_at":"2021-07-30T02:31:39.000000Z","pivot":{"user_id":74845,"role_id":15}}]}
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-05-28T06:01:33.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":95107,"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,"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":[{"id":3,"name":"User","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":46273,"role_id":3}},{"id":5,"name":"Student","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":46273,"role_id":5}}]}
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-09-24T13:10:59.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":1041594,"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":1632,"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","avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/u\/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":42.13,"bizUser":""}],"vip_account":null,"roles":[{"id":3,"name":"User","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":3}},{"id":4,"name":"Teacher","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":4}},{"id":5,"name":"Student","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":5}},{"id":9,"name":"ContentManager","created_at":"2020-08-04T04:07:52.000000Z","updated_at":"2020-08-04T04:07:52.000000Z","pivot":{"user_id":74845,"role_id":9}},{"id":15,"name":"GitihoHumanResources","created_at":"2021-07-30T02:30:37.000000Z","updated_at":"2021-07-30T02:31:39.000000Z","pivot":{"user_id":74845,"role_id":15}}]}
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-05-28T06:01:33.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":95107,"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,"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":[{"id":3,"name":"User","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":46273,"role_id":3}},{"id":5,"name":"Student","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":46273,"role_id":5}}]}
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.
Trang Anh
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,"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":[{"id":3,"name":"User","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":53126,"role_id":3}},{"id":5,"name":"Student","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":53126,"role_id":5}}]}
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-09-24T13:10:59.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":1041594,"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":1632,"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","avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/u\/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":42.13,"bizUser":""}],"vip_account":null,"roles":[{"id":3,"name":"User","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":3}},{"id":4,"name":"Teacher","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":4}},{"id":5,"name":"Student","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":5}},{"id":9,"name":"ContentManager","created_at":"2020-08-04T04:07:52.000000Z","updated_at":"2020-08-04T04:07:52.000000Z","pivot":{"user_id":74845,"role_id":9}},{"id":15,"name":"GitihoHumanResources","created_at":"2021-07-30T02:30:37.000000Z","updated_at":"2021-07-30T02:31:39.000000Z","pivot":{"user_id":74845,"role_id":15}}]}
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

Tuấn Ba
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-09-10T23:31:30.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":18,"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,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/doctor.png","link_profile":"https:\/\/gitiho.com\/u\/77429-mai-ngoc-cuong","business_employers":[],"vip_account":null,"roles":[{"id":3,"name":"User","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":77429,"role_id":3}},{"id":5,"name":"Student","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":77429,"role_id":5}}]}
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-09-10T23:31:30.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":18,"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,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/doctor.png","link_profile":"https:\/\/gitiho.com\/u\/77429-mai-ngoc-cuong","business_employers":[],"vip_account":null,"roles":[{"id":3,"name":"User","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":77429,"role_id":3}},{"id":5,"name":"Student","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":77429,"role_id":5}}]}
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-09-24T13:10:59.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":1041594,"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":1632,"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","avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/u\/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":42.13,"bizUser":""}],"vip_account":null,"roles":[{"id":3,"name":"User","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":3}},{"id":4,"name":"Teacher","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":4}},{"id":5,"name":"Student","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":5}},{"id":9,"name":"ContentManager","created_at":"2020-08-04T04:07:52.000000Z","updated_at":"2020-08-04T04:07:52.000000Z","pivot":{"user_id":74845,"role_id":9}},{"id":15,"name":"GitihoHumanResources","created_at":"2021-07-30T02:30:37.000000Z","updated_at":"2021-07-30T02:31:39.000000Z","pivot":{"user_id":74845,"role_id":15}}]}
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-09-10T23:31:30.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":18,"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,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/doctor.png","link_profile":"https:\/\/gitiho.com\/u\/77429-mai-ngoc-cuong","business_employers":[],"vip_account":null,"roles":[{"id":3,"name":"User","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":77429,"role_id":3}},{"id":5,"name":"Student","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":77429,"role_id":5}}]}
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-09-10T23:31:30.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":18,"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,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/doctor.png","link_profile":"https:\/\/gitiho.com\/u\/77429-mai-ngoc-cuong","business_employers":[],"vip_account":null,"roles":[{"id":3,"name":"User","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":77429,"role_id":3}},{"id":5,"name":"Student","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":77429,"role_id":5}}]}
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-09-10T23:31:30.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":18,"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,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/doctor.png","link_profile":"https:\/\/gitiho.com\/u\/77429-mai-ngoc-cuong","business_employers":[],"vip_account":null,"roles":[{"id":3,"name":"User","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":77429,"role_id":3}},{"id":5,"name":"Student","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":77429,"role_id":5}}]}
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-09-10T23:31:30.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":18,"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,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/doctor.png","link_profile":"https:\/\/gitiho.com\/u\/77429-mai-ngoc-cuong","business_employers":[],"vip_account":null,"roles":[{"id":3,"name":"User","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":77429,"role_id":3}},{"id":5,"name":"Student","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":77429,"role_id":5}}]}
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-09-24T13:10:59.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":1041594,"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":1632,"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","avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/u\/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":42.13,"bizUser":""}],"vip_account":null,"roles":[{"id":3,"name":"User","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":3}},{"id":4,"name":"Teacher","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":4}},{"id":5,"name":"Student","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":5}},{"id":9,"name":"ContentManager","created_at":"2020-08-04T04:07:52.000000Z","updated_at":"2020-08-04T04:07:52.000000Z","pivot":{"user_id":74845,"role_id":9}},{"id":15,"name":"GitihoHumanResources","created_at":"2021-07-30T02:30:37.000000Z","updated_at":"2021-07-30T02:31:39.000000Z","pivot":{"user_id":74845,"role_id":15}}]}
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-09-24T13:10:59.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":1041594,"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":1632,"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","avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/u\/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":42.13,"bizUser":""}],"vip_account":null,"roles":[{"id":3,"name":"User","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":3}},{"id":4,"name":"Teacher","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":4}},{"id":5,"name":"Student","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":5}},{"id":9,"name":"ContentManager","created_at":"2020-08-04T04:07:52.000000Z","updated_at":"2020-08-04T04:07:52.000000Z","pivot":{"user_id":74845,"role_id":9}},{"id":15,"name":"GitihoHumanResources","created_at":"2021-07-30T02:30:37.000000Z","updated_at":"2021-07-30T02:31:39.000000Z","pivot":{"user_id":74845,"role_id":15}}]}
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-09-10T23:31:30.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":18,"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,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/doctor.png","link_profile":"https:\/\/gitiho.com\/u\/77429-mai-ngoc-cuong","business_employers":[],"vip_account":null,"roles":[{"id":3,"name":"User","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":77429,"role_id":3}},{"id":5,"name":"Student","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":77429,"role_id":5}}]}
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-09-24T13:10:59.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":1041594,"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":1632,"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","avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/u\/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":42.13,"bizUser":""}],"vip_account":null,"roles":[{"id":3,"name":"User","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":3}},{"id":4,"name":"Teacher","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":4}},{"id":5,"name":"Student","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":5}},{"id":9,"name":"ContentManager","created_at":"2020-08-04T04:07:52.000000Z","updated_at":"2020-08-04T04:07:52.000000Z","pivot":{"user_id":74845,"role_id":9}},{"id":15,"name":"GitihoHumanResources","created_at":"2021-07-30T02:30:37.000000Z","updated_at":"2021-07-30T02:31:39.000000Z","pivot":{"user_id":74845,"role_id":15}}]}
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-09-10T23:31:30.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":18,"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,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/doctor.png","link_profile":"https:\/\/gitiho.com\/u\/77429-mai-ngoc-cuong","business_employers":[],"vip_account":null,"roles":[{"id":3,"name":"User","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":77429,"role_id":3}},{"id":5,"name":"Student","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":77429,"role_id":5}}]}
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-09-10T23:31:30.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":18,"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,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/doctor.png","link_profile":"https:\/\/gitiho.com\/u\/77429-mai-ngoc-cuong","business_employers":[],"vip_account":null,"roles":[{"id":3,"name":"User","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":77429,"role_id":3}},{"id":5,"name":"Student","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":77429,"role_id":5}}]}
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-09-24T13:10:59.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":1041594,"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":1632,"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","avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/u\/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":42.13,"bizUser":""}],"vip_account":null,"roles":[{"id":3,"name":"User","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":3}},{"id":4,"name":"Teacher","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":4}},{"id":5,"name":"Student","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":5}},{"id":9,"name":"ContentManager","created_at":"2020-08-04T04:07:52.000000Z","updated_at":"2020-08-04T04:07:52.000000Z","pivot":{"user_id":74845,"role_id":9}},{"id":15,"name":"GitihoHumanResources","created_at":"2021-07-30T02:30:37.000000Z","updated_at":"2021-07-30T02:31:39.000000Z","pivot":{"user_id":74845,"role_id":15}}]}
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?

Mai Ngọc Cương
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-09-24T13:10:59.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":1041594,"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":1632,"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","avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/u\/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":42.13,"bizUser":""}],"vip_account":null,"roles":[{"id":3,"name":"User","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":3}},{"id":4,"name":"Teacher","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":4}},{"id":5,"name":"Student","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":5}},{"id":9,"name":"ContentManager","created_at":"2020-08-04T04:07:52.000000Z","updated_at":"2020-08-04T04:07:52.000000Z","pivot":{"user_id":74845,"role_id":9}},{"id":15,"name":"GitihoHumanResources","created_at":"2021-07-30T02:30:37.000000Z","updated_at":"2021-07-30T02:31:39.000000Z","pivot":{"user_id":74845,"role_id":15}}]}
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-09-24T13:10:59.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":1041594,"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":1632,"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","avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/u\/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":42.13,"bizUser":""}],"vip_account":null,"roles":[{"id":3,"name":"User","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":3}},{"id":4,"name":"Teacher","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":4}},{"id":5,"name":"Student","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":5}},{"id":9,"name":"ContentManager","created_at":"2020-08-04T04:07:52.000000Z","updated_at":"2020-08-04T04:07:52.000000Z","pivot":{"user_id":74845,"role_id":9}},{"id":15,"name":"GitihoHumanResources","created_at":"2021-07-30T02:30:37.000000Z","updated_at":"2021-07-30T02:31:39.000000Z","pivot":{"user_id":74845,"role_id":15}}]}
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-09-10T23:31:30.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":18,"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,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/doctor.png","link_profile":"https:\/\/gitiho.com\/u\/77429-mai-ngoc-cuong","business_employers":[],"vip_account":null,"roles":[{"id":3,"name":"User","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":77429,"role_id":3}},{"id":5,"name":"Student","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":77429,"role_id":5}}]}
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-09-24T13:10:59.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":1041594,"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":1632,"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","avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/u\/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":42.13,"bizUser":""}],"vip_account":null,"roles":[{"id":3,"name":"User","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":3}},{"id":4,"name":"Teacher","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":4}},{"id":5,"name":"Student","created_at":"2017-04-18T17:16:57.000000Z","updated_at":"2017-04-18T17:16:57.000000Z","pivot":{"user_id":74845,"role_id":5}},{"id":9,"name":"ContentManager","created_at":"2020-08-04T04:07:52.000000Z","updated_at":"2020-08-04T04:07:52.000000Z","pivot":{"user_id":74845,"role_id":9}},{"id":15,"name":"GitihoHumanResources","created_at":"2021-07-30T02:30:37.000000Z","updated_at":"2021-07-30T02:31:39.000000Z","pivot":{"user_id":74845,"role_id":15}}]}
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ó
Mai Ngọc Cương
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-09-24T13:10:59.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":1041594,"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":1632,"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","avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/u\/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":42.13,"bizUser":""}],"vip_account":null}
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é.

Mai Ngọc Cương
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.
Nguyễn Tuân
Nguyễn Tuân 04 Aug 2020
Cảm ơn

Chuyên gia đồng hành cùng bạn

Dương Mạnh Quân
Giảng viên
Dương Mạnh Quân
Chuyên gia excel
Khóa học: 12    |    Học viên: 10,060
4 (114 đánh giá)

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.


Đăng ký ngay
Nhận ưu đãi lên tới 44%

Sử dụng mã giảm giá hoặc voucher của bạn

499,000đ

900,000đ
Thời gian ưu đãi chỉ còn:
  • 00 Ngày
  • 00 Giờ
  • 00 Phút
  • 00 Giây
Nguyễn Xuân Nam vừa đăng ký

Câu hỏi thường gặp

Học online có hiệu quả không?
Nội dung các chương trình học của Gitiho bám sát thực tế, có nhiều bài tập thực hành, giảng viên giải thích chi tiết rõ ràng.
Các khóa học không đơn thuần chỉ dạy sử dụng công cụ mà mục tiêu đưa ra định hướng phát triển khả năng tư duy sử dụng để học xong ứng dụng được linh hoạt vào công việc.
Trong quá trình học và vận dụng, có gì vướng mắc, bạn để lại câu hỏi trong kênh thảo luận để tương tác hỏi đáp với giảng viên, giảng viên sẽ hỗ trợ bạn ạ
Học Online tức là bạn có thể học bất cứ lúc nào bạn muốn và bạn có thể làm chủ không gian, thời gian học của mình. Bạn cũng có thể học trên điện thoại hay các thiết bị di động đó bạn.
Sau khi đăng ký, bạn sẽ được cấp 1 tài khoản học tập online trên web học tập, tài khoản này có giá trị sử dụng trọn đời.
Trong tài khoản có sẵn video, tài liệu tham khảo, bài tập thực hành dưới dạng file mềm, bạn có thể tải về để lưu trữ.
Bạn sẽ học qua các video bài giảng quay sẵn với hệ thống kiến thức chi tiết từ căn bản, giao diện học tập thuận tiện, dễ học. Giảng viên sẽ vừa giảng lý thuyết vừa thực hành chi tiết các thao tác hướng dẫn bạn.
Trong quá trình học và vận dụng, có gì vướng mắc, bạn để lại câu hỏi trong kênh thảo luận để tương tác hỏi đáp với giảng viên, giảng viên hỗ trợ nhiệt tình 24/7
Đối với mọi khóa học trên Gitiho, bạn chỉ cần thanh toán một lần và được quyền sở hữu bài học mãi mãi. Điều này đồng nghĩa với việc bạn có thể xem lại bài học bất cứ lúc nào bạn muốn.
Đăng ký cho tổ chức Đăng ký cho tổ chức

Gitiho For Leading Business - Giải pháp
chuyển đổi số Đào tạo nội bộ dành cho
Doanh nghiệp

Sẵn sàng nền tảng và nội dung đào tạo cho tất cả các vị trí, bộ phận. Ứng dụng ngay
vào doanh nghiệp chỉ với một click.

Hơn 50 doanh nghiệp đã đăng ký cho nhân sự của họ

50+ doanh nghiệp đã đăng ký cho nhân sự của họ

Nguyễn Xuân Nam vừa đăng ký
@ 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