• PRO

    Thông tin tài khoản
  • Cài đặt Cài đặt tài khoản
  • Lịch nhắc nhở Thiết lập lịch nhắc nhở
  • Quản lý tài chính Quản lý tài chính
  • Tra cứu chứng nhận
  • Gitiho Loyalty
  • Tất cả khóa học Tất cả Khóa học
  • Tất cả Blog Tất cả Blog
  • Tất cả Hỏi đáp

    • 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

    • 1. Click vào đây để tải về toàn bộ cuốn sách '' Khai phá 10 kỹ thuật ứng dụng Excel mà đại học không dạy bạn''

    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

    Bạn xem video này nhé

    https://www.youtube.com/watch?v=lSKxoRgYnJc&t=520s

     
    {"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đ
    Top

    Hỗ trợ khách hàng

    VỀ GITIHO

    hợp tác và liên kết

    Tải App Gitiho

    Kết nối với chúng tôi

    Địa chỉ văn phòng: Phòng 206, tầng 2, Tòa nhà Tây Hà, KĐT mới Phùng Khoang, Phường Trung Văn, Quận Nam Từ Liêm, Thành phố Hà Nội, Việt Nam
    @ 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
    /