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

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

Ứng dụng thành thạo 150 hàm Excel, Pivot Table, kỹ thuật lọc, định dạng dữ liệu, vẽ biểu đồ chuyên nghiệp...vào công việc
Hình thành và phát triển tư duy tổ chức, xử lý dữ liệu khoa học
Rèn luyện kỹ năng báo cáo theo các công việc cụ thể để sử dụng Excel thành thạo, đáp ứng tiêu chuẩn về kỹ năng Excel của các doanh nghiệp, tập đoàn
Tự xây dựng hệ thống báo cáo động, hệ thống quản trị chuyên nghiệp để đo lường hiệu quả công việc

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

Video

0h 00m giờ học

Article

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

Material

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

Exam questions

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

Nội dung khoá học

0 Chương . 1 bài giảng . 0h 00m giờ học

Mô tả khoá học

Bạn thích đọc sách và cần tìm hiểu Excel để phục vụ cho công việc nhưng vẫn chưa biết bắt đầu từ đâu? Đây chính là cuốn sách dành cho bạn: Bắt đầu nhẹ nhàng với  Khai phá 10 kỹ thuật ứng dụng Excel mà đại học không dạy bạn. Sách với những ví dụ cụ thể áp dụng ngay, cuốn sách đem lại cho người học sự bắt đầu nhẹ nhàng với việc khai phá kỹ thuât ứng dụng Excel trong công việc. Sách sẽ được cập nhật hàng tháng với những ví dụ cụ thể áp dụng vào công việc. Hãy đăng ký nhận sách ngay hôm nay.

Giảng viên:

G-LEARNING Giảng viên

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

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

  • 436 đánh giá

  • 224,369 học viên

  • 83 khóa học

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

4.5 điểm đánh giá . 2 lượt đánh giá

Phạm thị yến

Phạm thị yến

02:29 12/01/2022

khóa học rất hữu dụng, mình biết thêm được nhiều kiến thức mà ở trường học không có chỉ cho mình, rất là tuyệt với, sẽ đồng hành cũng gitiho dài dài để hoàn thiện bản thân hơn nữa, cảm ơn gitiho nhiều.
Hoa Lư

Hoa Lư

12:07 16/07/2021

Tải bộ sách excel thôi về học vì mình không đăng kí khóa học này mà được tặng khi mua khóa học PPG01 - tuyệt powerwpoint chinh phục mọi ánh nhìn, nhưng sách có đầy đủ tất cả những gì mình cần học trong đó. Super - danke

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

335 thảo luận

Hoàng Bá Duy

Hoàng Bá Duy 07 Dec 2022

Em chào thầy. Em có 1 list danh sách họ tên và cột số CMND. Dùng hàm gì để đánh tên mà nó ra luôn cả cột CMND ạ.

 

Tuấn Ba

Tuấn Ba [Chuyên gia] 07 Dec 2022

Chào bạn với office 365 thì có hàm fiter còn office khác thì bạn phải dùng vba nhé.

Tuấn Anh

Tuấn Anh 05 Nov 2022

cô ơi cho e hỏi làm sao để mở được file ạ. e tải về được nhưng ko xem được bài giảng
Tuấn Ba

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

File này dạng pdf bạn mở sẽ ra file pdf nhé chỉ là nội dung file thôi không có video

{"id":247327,"crm_contact_id":431659,"name":"Tu\u1ea5n Anh","email":"tuan2104198989@gmail.com","status":1,"refresh_login":0,"password_reset":0,"last_update_password":null,"confirmation_code":"ae552e9672f4c8642c227d9b5e010a0b","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-09-18T15:17:19.000000Z","updated_at":"2022-11-16T22:39:20.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1665931147.jpg","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":16214,"google_id":"110343297936428623205","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1665931147.jpg","link_profile":"https:\/\/gitiho.com\/u\/247327-tuan-anh","business_employers":[],"vip_account":null,"roles":[]}

Tuấn Anh 08 Nov 2022

e cảm ơn thầy ạ
{"id":36914,"crm_contact_id":91357,"name":"Tr\u1ea7n Th\u1ecb Tuy\u1ebft Nhung","email":"trannhungdl16@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"dd48172266de362f40830b0c619042ac","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2018-12-20T13:56:19.000000Z","updated_at":"2022-11-30T13:24:54.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":1,"birthday":"1986-10-16 00:00:00","position":null,"achievement":null,"full_name":"Tr\u1ea7n Th\u1ecb Tuy\u1ebft Nhung","address":"V\u0129nh L\u1ed9c a, B\u00ecnh Ch\u00e1nh, TP HCM","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0978082217","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":17868,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/woman\/chinese.png","link_profile":"https:\/\/gitiho.com\/u\/36914-tran-thi-tuyet-nhung","business_employers":[],"vip_account":null,"roles":[]}

Trần Thị Tuyết Nhung 01 Dec 2022

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

Tuấn Ba [Chuyên gia] 02 Dec 2022

Chào bạn phần này không có bài giảng bạn nhé chỉ có file pdf

Dương Nga Hằng

Dương Nga Hằng 29 Nov 2022

Em chào thầy. e có thấy format cell trong đó có phần accouting hoặc phần currency VND auto đứng trước số. vậy có cách nào để VND đứng sau số tiền ko ạ 

Trợ giảng Gitiho (Huyền Trang)

Trợ giảng Gitiho (Huyền Trang) 30 Nov 2022

Chào bạn! Để thêm VND vào bên phải số tiền bạn làm như sau:

Bước 1: Bôi đen cột số tiền mà các bạn muốn chèn

Bước 2: vào hộp thoại Home -> Number

Bước 3: Xuất hiện bảng Format cells -> chọn thẻ Number -> chọn Custom -> tại ô Type nhập: #,### “VNĐ”  -> Ok

 


Kết quả là cột số tiền đã có thêm chữ “ VNĐ”

Chúc bạn học vui vẻ cùng Gitiho !

 

Lâm Thị Thanh Tuyền

Lâm Thị Thanh Tuyền 19 Nov 2022

em đang có 1 yêu cầu: gỏ số tiền bằng số tự động ra số tiền bằng chữ . rất mong thầy/cô hướng dẫn
Tuấn Ba

Tuấn Ba [Chuyên gia] 21 Nov 2022

Phần này bạn cài addins vào là được nhé

https://luutruhoadon.com.vn/Tool/Addins/ExTool.zip

TVND(o cần chuyển)

{"id":260180,"crm_contact_id":464392,"name":"L\u00e2m Th\u1ecb Thanh Tuy\u1ec1n","email":"tuyenvcblongan62@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2022-11-06 19:43:19","confirmation_code":"55aad3c2b6816a3521026ac17c3e066e","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-11-06T12:34:21.000000Z","updated_at":"2022-11-10T15:28:30.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":"387 \u1ea5p 4, x\u00e3 B\u00ecnh T\u00e2m, Tp t\u00e2n an, t\u1ec9nh long an","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0938393837","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":19807,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/woman\/designer (1).png","link_profile":"https:\/\/gitiho.com\/u\/260180-lam-thi-thanh-tuyen","business_employers":[],"vip_account":null,"roles":[]}

Lâm Thị Thanh Tuyền 25 Nov 2022

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

Tuấn Ba [Chuyên gia] 28 Nov 2022

Chào bạn bạn có thể sử dụng macro trong vba được không?

Hạnh Bùi

Hạnh Bùi 03 Nov 2022

mình muốn convert PDF qua ửok thì bên mình có hỗ trợ phần này ko ạ? Thanks.
Tuấn Ba

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

Chào bạn bạn cài máy in ảo rồi in dạng pdf là xong nhé.

{"id":258517,"crm_contact_id":435233,"name":"H\u1ea1nh B\u00f9i","email":"angkhangvo1306@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"dffc1c2538fb2bbed9bc5eaabfd85f9e","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-10-30T10:36:32.000000Z","updated_at":"2022-11-20T01:15:14.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":1,"birthday":"1982-06-13 00:00:00","position":null,"achievement":null,"full_name":null,"address":"H\u1ebbm 167 L\u00ea th\u00e1nh t\u00f4ng, H\u1ed9i An, T\u1ec9nh Qu\u1ea3ng Nam","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0919771761","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":14940,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":1,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/woman\/editor.png","link_profile":"https:\/\/gitiho.com\/u\/258517-hanh-bui","business_employers":[],"vip_account":null,"roles":[]}

Hạnh Bùi 09 Nov 2022

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

Tuấn Ba [Chuyên gia] 10 Nov 2022

Chào bạn bạn phải dùng phần mềm chuyên dụng như ABByy để chuyển bạn nhé.

Hà Văn Lượng

Hà Văn Lượng 26 Oct 2022

không mở tài liệu được ah
Tuấn Ba

Tuấn Ba [Chuyên gia] 27 Oct 2022

Bạn chụp ảnh lỗi giúp gitiho nhé.

Hồng thị Ái Mỹ

Hồng thị Ái Mỹ 12 Oct 2022

Xin thầy chỉ cách mở file tuyệt đỉnh Excel

Dương Mạnh Quân

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

Bạn tải file về rồi mở như file pdf thông thường thôi. Nếu không xem được thì bạn cần tải thêm phần mềm đọc file PDF. Bạn có thể search google về các phần mềm đọc file PDF, có rất nhiều.

Thái Thị Thanh Nga

Thái Thị Thanh Nga 07 Oct 2022

Mình chỉ tải được file tài liệu PDF nhưng không thấy video giảng. Không biết có lỗi gì không thầy nhỉ

 

Dương Mạnh Quân

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

Bạn để ý sản phẩm này là ebook chứ không phải khóa học. Bạn xem lại trong mục Khóa học của tôi xem lại các khóa học bạn đang tham gia nhé.

{"id":232305,"crm_contact_id":390713,"name":"Th\u00e1i Th\u1ecb Thanh Nga","email":"tnga8626@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2022-07-06 10:03:07","confirmation_code":"b66f2a2a655bca32686523d159724685","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-07-05T12:01:24.000000Z","updated_at":"2022-10-17T06:45:59.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":"P 2142 vp5 b\u00e1n \u0111\u1ea3o Linh \u0110\u00e0m, Ho\u00e0ng Li\u1ec7t, Ho\u00e0ng Mai, H\u00e0 N\u1ed9i","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0966428626","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":25760,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/woman\/designer (1).png","link_profile":"https:\/\/gitiho.com\/u\/232305-thai-thi-thanh-nga","business_employers":[],"vip_account":null,"roles":[]}

Thái Thị Thanh Nga 07 Oct 2022

Cám ơn thầy giáo
Phạm Văn Tới

Phạm Văn Tới 05 Oct 2022

sao không thể mở được tài liệu ạ
Tuấn Ba

Tuấn Ba [Chuyên gia] 05 Oct 2022

Bạn download mở dưới dạng pdf là được nhé.

HOÀNG THỊ BÍCH KIM

HOÀNG THỊ BÍCH KIM 22 Sep 2022

Cho em hỏi Hàm công thức tính số ngày công có sử dụng phép năm,phép việc riêng,phép tang ,phép cưới. Lấy ngày công 26 làm chuẩn. Mong thầy phản hồi ạ
Tuấn Ba

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

NETWORKDAYS.INTL(L3,M3,"0000001",Data_Letet)

Trong đó L3 và M3 là ngày bắt đầu và ngày kết thúc

Data_Letet là những ngày nghỉ trong năm

 

{"id":247976,"crm_contact_id":432873,"name":"HO\u00c0NG TH\u1eca B\u00cdCH KIM","email":"bichkim1505@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"98e07afa86fd1e74e6e512135820dc35","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-09-21T06:46:15.000000Z","updated_at":"2022-10-11T08:50:42.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":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0975000259","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":14970,"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":2,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/barista.png","link_profile":"https:\/\/gitiho.com\/u\/247976-hoang-thi-bich-kim","business_employers":[],"vip_account":null,"roles":[]}

HOÀNG THỊ BÍCH KIM 22 Sep 2022

em dùng hàm COUNTIF để tính nhưng chưa chính xác lắm,phép bệnh và phép việc riêng,nửa ngày công là trừ tiền,ngoài ra các phép khác là không trừ tiền. Phiền thầy xem công thức giùm em ạ . Em cảm ơn. 27 ngày nhưng chỉ chốt 26 ngày công làm chuẩn ạ
{"id":247976,"crm_contact_id":432873,"name":"HO\u00c0NG TH\u1eca B\u00cdCH KIM","email":"bichkim1505@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"98e07afa86fd1e74e6e512135820dc35","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-09-21T06:46:15.000000Z","updated_at":"2022-10-11T08:50:42.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":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0975000259","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":14970,"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":2,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/barista.png","link_profile":"https:\/\/gitiho.com\/u\/247976-hoang-thi-bich-kim","business_employers":[],"vip_account":null,"roles":[]}

HOÀNG THỊ BÍCH KIM 22 Sep 2022

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

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

Bạn đẩy file lên nhé.

{"id":247976,"crm_contact_id":432873,"name":"HO\u00c0NG TH\u1eca B\u00cdCH KIM","email":"bichkim1505@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"98e07afa86fd1e74e6e512135820dc35","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-09-21T06:46:15.000000Z","updated_at":"2022-10-11T08:50:42.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":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0975000259","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":14970,"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":2,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/barista.png","link_profile":"https:\/\/gitiho.com\/u\/247976-hoang-thi-bich-kim","business_employers":[],"vip_account":null,"roles":[]}

HOÀNG THỊ BÍCH KIM 26 Sep 2022

Nhờ thầy kiểm tra giùm em
{"id":247976,"crm_contact_id":432873,"name":"HO\u00c0NG TH\u1eca B\u00cdCH KIM","email":"bichkim1505@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"98e07afa86fd1e74e6e512135820dc35","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-09-21T06:46:15.000000Z","updated_at":"2022-10-11T08:50:42.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":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0975000259","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":14970,"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":2,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/barista.png","link_profile":"https:\/\/gitiho.com\/u\/247976-hoang-thi-bich-kim","business_employers":[],"vip_account":null,"roles":[]}

HOÀNG THỊ BÍCH KIM 26 Sep 2022

Nhờ thầy kiểm tra giùm em ,em cảm ơn.
{"id":247976,"crm_contact_id":432873,"name":"HO\u00c0NG TH\u1eca B\u00cdCH KIM","email":"bichkim1505@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"98e07afa86fd1e74e6e512135820dc35","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-09-21T06:46:15.000000Z","updated_at":"2022-10-11T08:50:42.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":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0975000259","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":14970,"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":2,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/barista.png","link_profile":"https:\/\/gitiho.com\/u\/247976-hoang-thi-bich-kim","business_employers":[],"vip_account":null,"roles":[]}

HOÀNG THỊ BÍCH KIM 26 Sep 2022

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

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

Không có file bạn nhé.

{"id":247976,"crm_contact_id":432873,"name":"HO\u00c0NG TH\u1eca B\u00cdCH KIM","email":"bichkim1505@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"98e07afa86fd1e74e6e512135820dc35","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-09-21T06:46:15.000000Z","updated_at":"2022-10-11T08:50:42.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":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0975000259","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":14970,"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":2,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/barista.png","link_profile":"https:\/\/gitiho.com\/u\/247976-hoang-thi-bich-kim","business_employers":[],"vip_account":null,"roles":[]}

HOÀNG THỊ BÍCH KIM 28 Sep 2022

Dạ thầy
Phạm Lê Đông Nghi

Phạm Lê Đông Nghi 28 Sep 2022

Cho em hỏi khi em copy danh sách từ file Excel này sang file Excel có hiện lỗi "That command cannot be used on multiple selections" là lỗi gì ạ? Mong hỗ trợ, xin cảm ơn.

Tuấn Ba

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

Bạn có thể mô tả rõ hơn lỗi được không?

Trịnh Minh Hà

Trịnh Minh Hà 21 Sep 2022

Ví dụ:

0904578867 KH TRỐN TRÁNH KHAI BÁO 

Mẹ kh : 0978546354 trao đổi nhờ mẹ kh bảo kh ll lại để hỗ trợ thanh toán mgl.

Tuấn Ba

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

{"id":93870,"crm_contact_id":21911,"name":"Tr\u1ecbnh Minh H\u00e0","email":"minhhatrinh7@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2020-06-11 17:23:01","confirmation_code":"9ce2f986734e07ca45411370b87504d7","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2020-06-11T01:35:50.000000Z","updated_at":"2022-11-14T13:32:41.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":1,"birthday":null,"position":null,"achievement":null,"full_name":"Tr\u1ecbnh Minh H\u00e0","address":"To\u00e0 17T2 ph\u1ed1 C\u01b0\u01a1ng Ki\u00ean, Trung V\u0103n, Nam T\u1eeb Li\u00eam, H\u00e0 N\u1ed9i","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0936751402","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":139430,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/woman\/woman.png","link_profile":"https:\/\/gitiho.com\/u\/93870-trinh-minh-ha","business_employers":[],"vip_account":null,"roles":[]}

Trịnh Minh Hà 21 Sep 2022

em cảm ơn ?
Lê Diễm Lệ Trinh

Lê Diễm Lệ Trinh 13 Sep 2022

Tại sao cấu trúc DATE(YEAR, MONTH, DAY) ra giá trị sai không giống như bài giảng?

VD: NGÀY KHỞI ĐẦU 05/09/2022, CỘNG THÊM 2 NĂM, 9 THÁNG, 0 NGÀY

KẾT QUẢ NGÀY KẾT THÚC: 05/07/1907

Tuấn Ba

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

Bạn phải chia ra như sau nhé

DATE(YEAR +2, MONTH+9, DAY)

{"id":239866,"crm_contact_id":418345,"name":"L\u00ea Di\u1ec5m L\u1ec7 Trinh","email":"trinhldl.sgo@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"be45a5c6d241ea83e4690c7e7efbf798","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-08-11T02:28:43.000000Z","updated_at":"2022-09-17T15:27:25.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":"54\/33\/24 l\u00ea v\u0103n l\u01b0\u01a1ng, p. T\u00e2n h\u01b0ng,q7,hcm","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0968851789","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":18977,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/woman\/dancer.png","link_profile":"https:\/\/gitiho.com\/u\/239866-le-diem-le-trinh","business_employers":[],"vip_account":null,"roles":[]}

Lê Diễm Lệ Trinh 13 Sep 2022

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

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

Đây bạn nhé.

Lê Văn Lợi

Lê Văn Lợi 26 Aug 2022

Phần ebook Tuyệt đỉnh Excel chỉ có phần tài liệu tự học thôi phải không ạ?

Tuấn Ba

Tuấn Ba [Chuyên gia] 29 Aug 2022

Chào bạn phần này chỉ là pdf thôi không có video bạn nhé.

Lâm Tình Thương

Lâm Tình Thương 14 Aug 2022

Dương Mạnh Quân

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

Phần mềm excel trên máy tính macbook khác với excel của microsoft bạn nhé, nên có thể không sử dụng được tính năng này.

{"id":240378,"crm_contact_id":419195,"name":"L\u00e2m T\u00ecnh Th\u01b0\u01a1ng","email":"ducbinh9120@gmail.com","status":1,"refresh_login":0,"password_reset":0,"last_update_password":null,"confirmation_code":"a83687d99c0a1c5a0fce4b1e149d77bd","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-08-13T11:10:56.000000Z","updated_at":"2022-10-31T11:19:33.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":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":13850,"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":1,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/woman\/editor.png","link_profile":"https:\/\/gitiho.com\/u\/240378-lam-tinh-thuong","business_employers":[],"vip_account":null,"roles":[]}

Lâm Tình Thương 17 Aug 2022

bạn ơi mình muốn bạn hỗ trợ tạo file quản lý công việc và nhân viên

Ebook Tuyệt đỉnh Excel - Khai phá 10 kỹ thuật ứng dụng Excel mà đại học không dạy bạn
4.5

(2 đánh giá)

60,612 học viên
69,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
/