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

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

Những thủ thuật nhanh gọn sẽ giúp bạn tiết kiệm thời gian tới 200%
Làm việc hiệu quả hơn với Excel, nâng cao hiệu suất, chất lượng công việc

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

Video

7h 18m giờ học

Article

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

Material

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

Exam questions

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

Nội dung khoá học

9 Chương . 107 bài giảng . 7h 18m giờ học

1

Hướng dẫn chung

2

Cách sử dụng các công cụ trong Excel

2 bài học thử
3

Các kỹ thuật định dạng, xử lý dữ liệu

2 bài học thử
4

Các thủ thuật liên quan tới hàm, công thức

2 bài học thử
5

Hàm, công thức tính toán theo thời gian

6

Các hàm và công thức nâng cao

2 bài học thử
7

Những thiết lập chế độ làm việc trên Excel

8

Các đối tượng trong Excel: Hình khối, Biểu đồ

1 bài học thử
9

Một số thủ thuật hữu ích khác

1 bài học thử

Mô tả khoá học

Kỹ năng ứng dụng Excel thành thạo là điều kiện bắt buộc mà bất kỳ nhân viên văn phòng nào cũng phải có, tuy nhiên điều đó vẫn chưa đủ để bạn có thể giải quyết công việc theo một cách thông minh và nhanh chóng để giúp bạn toả sáng nơi công sở. Nắm bắt được vấn đề đó, Gitiho giới thiệu bộ series thủ thuật Excel cập nhật hàng tuần cực kỳ hữu ích, giúp các bạn làm việc trở nên thông minh và chuyên nghiệp trong mắt bạn bè và đồng nghiệp.

Các video bài giảng được xây dựng theo từng chủ đề cụ thể, chú trọng tối đa tới tính ứng dụng cao, bộ video thủ thuật phù hợp với mọi đối tượng muốn toả sáng bằng những thủ thuật Excel thông minh và bất ngờ trong công việc

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.7 điểm đánh giá

  • 491 đánh giá

  • 231,399 học viên

  • 90 khóa học

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

4.62 điểm đánh giá . 66 lượt đánh giá

Bùi Thị Lan

Bùi Thị Lan

01:16 03/12/2022

Cảm ơn gitiho đã cung cấp khóa học tuyệt vời này. Xem video, mình thấy vô cùng hữu ích. Chúc gitiho ngày càng phát triển ạ! Mình hy vọng sẽ được gitiho giới thiệu và tư vấn các khoá học mà gitiho thấy hữu ích cho dân kế toán ạ.
Hoàng Quang Nam

Hoàng Quang Nam

08:50 23/01/2023

Đầu xuân năm mới em xin gửi lời cảm ơn tới thầy giáo đã dạy cho em hiểu được nhiều kiến thức về Excel. Em vô cùng biết ơn thầy. Em chúc thầy giáo năm mới AN KHANG THỊNH VƯỢNG.
Lâm Phượng Chi

Lâm Phượng Chi

10:22 12/01/2023

Đã từng mua khóa học tại website khác nhưng học buồn ngủ vì dạy quá nhiều về lý thuyết từ chuyên ngành, học không nổi, còn giáo án ở Gitiho thì phù hợp ứng dụng thực tế, có bài tập làm xuyên suốt khóa, kèm đáp án. Thầy có tốc độ dạy vừa phải giọng đọc truyền tải tốt. Đây là khóa học nên mua với các bạn cần bắt đầu tìm hiểu lại từ con số 0 excel.

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

6,392 thảo luận

Trần Linh

Trần Linh 18 Jan 2023

Cho mình hỏi excel này này bộ office 2019 đúng k ạ?
Tuấn Ba

Tuấn Ba [Chuyên gia] 19 Jan 2023

Chào bạn bộ này đang là office 365 nhưng office 2019 dùng được bạn nhé

Đặng Thị Thuý An

Đặng Thị Thuý An 14 Jan 2023

có ai bị như e k
Tuấn Ba

Tuấn Ba [Chuyên gia] 14 Jan 2023

Bạn vui lòng mô tả rõ hơn giúp gitiho dc ko?

Tuấn Anh

Tuấn Anh 12 Jan 2023

e cảm ơn thầy ạ
Dương Mạnh Quân

Dương Mạnh Quân [Chuyên gia] 12 Jan 2023

Chúc bạn học tốt cùng Gitiho!

Tuấn Anh

Tuấn Anh 12 Jan 2023

thầy ạ e làm theo công thức mà ko được ạ, xin được thầy chỉ giúp e ạ
Tuấn Ba

Tuấn Ba [Chuyên gia] 12 Jan 2023

Bạn vui lòng gửi file lên giúp gitiho nhé.

Tuấn Anh

Tuấn Anh 12 Jan 2023

thầy ch
Tuấn Ba

Tuấn Ba [Chuyên gia] 12 Jan 2023

Bạn đang muốn nói gì với gitiho vậy?

Võ Thị Thanh Thảo

Võ Thị Thanh Thảo 11 Jan 2023

mình cần tổng hợp nhiều file excel thành 1 file 

Tuấn Ba

Tuấn Ba [Chuyên gia] 12 Jan 2023

bạn muốn tổng hợp lương cuối năm phải không?

Lưu Gia Khánh Hân

Lưu Gia Khánh Hân 08 Jan 2023

Em nhập hàm như này và đã thử thay dấu phẩy thành chấm phẩy cũng không được ạ

Tuấn Ba

Tuấn Ba [Chuyên gia] 08 Jan 2023

Chào bạn phần này là do phân cách công thức của bạn thôi nhé, bạn làm theo bài sau hoặc là đổi dấu , thành ; trong công thức nhé

https://gitiho.com/blog/cach-doi-dau-phay-sang-dau-cham-phay-trong-cong-thuc-excel.html

{"id":277683,"crm_contact_id":491223,"name":"L\u01b0u Gia Kh\u00e1nh H\u00e2n","email":"luukhanhhan650@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"8eb4d6ea4e0653bc6e9a4e0acd7fa505","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-01-06T01:42:25.000000Z","updated_at":"2023-01-07T01:33: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":"19\/21 Nguy\u1ec5n C\u00f4ng Tr\u1ee9, Ph\u01b0\u1eddng 4, Tp Tuy H\u00f2a, T\u1ec9nh Ph\u00fa Y\u00ean","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0704858650","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":12844,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"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\/images\/avatar\/folder_278\/luu-han.png","link_profile":"https:\/\/gitiho.com\/u\/277683-luu-gia-khanh-han","business_employers":[],"vip_account":null,"roles":[]}

Lưu Gia Khánh Hân 08 Jan 2023

dạ em đã đọc nhưng mà em vẫn không biết làm sao ạ em đã thử nhưng mà nó đều bị hiện như thế ạ 

 

{"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":"2023-01-27T13:53:20.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":1010070,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"118095757772556445137","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":1927,"email_invalid":0,"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>","bizUser":"","avgCompleted":31.87}],"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":"Qu\u1ea3n l\u00fd n\u1ed9i dung","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-12-21T08:27:44.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 09 Jan 2023

Bạn liên hệ cskh vào giờ hành chính để ultraview hỗ trợ nhé

{"id":82548,"crm_contact_id":29934,"name":"CSKH Gitiho Vi\u1ec7t Nam","email":"hotro@gitiho.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2020-02-12 17:12:54","confirmation_code":"ccae872502b90d64fa68a5773858a513","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2020-01-30T15:32:47.000000Z","updated_at":"2022-12-23T03:35:39.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1652762083.png","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"CSKH Gitiho Vi\u1ec7t Nam","address":"Gitiho Vi\u1ec7t Nam","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0774116285","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":8000,"google_id":"109213028097135238411","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":18,"email_invalid":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\/1652762083.png","link_profile":"https:\/\/gitiho.com\/u\/82548-cskh-gitiho-viet-nam","business_employers":[{"id":2713,"biz_business_id":79,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":0},{"id":2715,"biz_business_id":12,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":0},{"id":2716,"biz_business_id":61,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":0}],"vip_account":null,"roles":[{"id":10,"name":"CourseManager","display_name":"CourseManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":82548,"role_id":10,"model_type":"App\\Models\\User"}},{"id":11,"name":"Sale","display_name":"Sale","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":82548,"role_id":11,"model_type":"App\\Models\\User"}},{"id":12,"name":"SaleManager","display_name":"SaleManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":82548,"role_id":12,"model_type":"App\\Models\\User"}},{"id":14,"name":"UserManager","display_name":"UserManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":82548,"role_id":14,"model_type":"App\\Models\\User"}},{"id":17,"name":"partnerAffiliate","display_name":"partnerAffiliate","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":82548,"role_id":17,"model_type":"App\\Models\\User"}},{"id":27,"name":"Customer service","display_name":"Customer service","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":82548,"role_id":27,"model_type":"App\\Models\\User"}}]}

CSKH Gitiho Việt Nam 10 Jan 2023

Trường hợp này của chị Khánh Hân đã được hỗ trợ qua ultraview nhé ạ
Chúc chị học tập hiệu quả 

Nguyên Hồng

Nguyên Hồng 27 Nov 2022

Chào các thầy ạ, em đang gặp khó khăn như sau:

Công việc yêu cầu: Tính số lượng hàng tồn kho về theo ngày, ví dụ: Ngày 1 về 100 pcs, ngày 2 về 50 pcs thì tổng lượng hàng tồn kho tính tới ngày 2 sẽ là 150pcs.

Do trong thực tế có đến hàng ngàn nguyên liệu và ngày về phức tạp nên em không thể nào dùng tính tay cho từng mã được ạ.

Em có để file theo link này, mong thầy cùng các bạn hỗ trợ ạ.

https://docs.google.com/spreadsheets/d/1n-cJQ39_C2IiN98g7noF1nB_308lakjm/edit?usp=sharing&ouid=112472537632532011530&rtpof=true&sd=true

Dương Mạnh Quân

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

Trong khóa học exg01, phần hướng dẫn báo cáo tổng hợp, mình có hướng dẫn phần sử dụng hàm sumifs trong lập báo cáo Nhập-xuất-tồn kho. Bạn có thể tham khảo cách làm này

{"id":203733,"crm_contact_id":349602,"name":"Phung ly","email":"phungly@forevernetco.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2022-02-16 13:51:52","confirmation_code":"d15e881e4d79eb5f6b66c081a272c542","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-02-16T06:46:34.000000Z","updated_at":"2022-02-16T06:54:48.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":"Di an binh duong","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0769855955","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":14370,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"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\/images\/avatar\/folder_204\/phung-ly.png","link_profile":"https:\/\/gitiho.com\/u\/203733-phung-ly","business_employers":[],"vip_account":null,"roles":[]}

Phung ly 10 Jan 2023

llllmmlppplr tr éwqooioppoppppppplpp
Văn Công Khanh

Văn Công Khanh 06 Jan 2023

có cách nào để chứa kết quả vào mảng bằng công thức không

Tuấn Ba

Tuấn Ba [Chuyên gia] 07 Jan 2023

Chào bạn, bạn có thể mô tả rõ hơn không nhỉ?

{"id":187314,"crm_contact_id":318718,"name":"V\u0103n C\u00f4ng Khanh","email":"khanhvc2003@yahoo.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"a4a1a193e92748b4bf3cc736a51828c9","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-12-06T01:40:41.000000Z","updated_at":"2022-04-08T05:53:31.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":42399,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"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\/images\/avatar\/folder_187\/van-khanh.png","link_profile":"https:\/\/gitiho.com\/u\/187314-van-cong-khanh","business_employers":[],"vip_account":null,"roles":[]}

Văn Công Khanh 07 Jan 2023

ví dụ căn cứ số hợp đồng để lấy tên nhân viên, như ví dụ trên tại ô H6, muốn sử dụng DGET chổ criteria phải là hàng 1 là tiêu đề, hàng 2 là điểu kiện, tuy nhiên em muốn dùng kỹ thuật nào đó để chuyển ô g2 làm tiêu đề và h2 làm dòng điện, nhưng có biết làm kép trong công thức DGET tại H6 là thế nào

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2023-01-27T13:53:20.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":1010070,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"118095757772556445137","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":1927,"email_invalid":0,"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>","bizUser":"","avgCompleted":31.87}],"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":"Qu\u1ea3n l\u00fd n\u1ed9i dung","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-12-21T08:27:44.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] 08 Jan 2023

Bạn đẩy file excel lên giúp gitiho nhé.

Văn Công Khanh

Văn Công Khanh 03 Jan 2023

Dương Mạnh Quân

Dương Mạnh Quân [Chuyên gia] 05 Jan 2023

Không thực hiện được bạn nhé, vì không có căn cứ xác định phần kế hoạch và phần thực hiện (do ô chỉ chứa số mà không có cột mã nhân viên bên cạnh).

Cách giải quyết thì cần có 1 cột phụ bên trái (hoặc phải), trong cột phụ này chứa tên nhân viên. 1 cột phụ nữa (cột Loại) thể hiện chữ Kế hoạch, thực hiện theo đúng dòng.

Khi đó để đưa kết quả sang bảng bên phải thì dùng hàm SUMIFS theo điều kiện nhân viên và loại

Phạm Ngọc Xinh

Phạm Ngọc Xinh 05 Jan 2023

Mình chưa tìm được thanh công cụ có Cell Styes

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

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

Chào bạn! bạn làm như sau giúp mình nhé:

  1. Chọn ô tính hoặc vùng tính muốn đặt Styles.
  2. Vào thẻ Home. Tại nhóm Styles, click vào Cell Styles.
  3. Trong danh sách, chọn Styles theo ý muốn để thêm vào.
  4. Chúc bạn học tập vui vẻ cùng Gitiho nhé!
Hoàng Thanh Long

Hoàng Thanh Long 03 Jan 2023

Thầy có thể hướng dẫn cách làm lịch tháng.

bắt đầu từ ngày đầu của tháng - ngày cuối tháng của tháng.  Thứ của tháng cũng chạy theo, 

Hoàng Thanh Long

Hoàng Thanh Long 03 Jan 2023

số ngày trên 1 dòng; số thứ trên 1 dòng

 

{"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":"2023-01-27T13:53:20.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":1010070,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"118095757772556445137","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":1927,"email_invalid":0,"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>","bizUser":"","avgCompleted":31.87}],"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":"Qu\u1ea3n l\u00fd n\u1ed9i dung","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-12-21T08:27:44.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] 03 Jan 2023

Chào bạn bạn đang muốn hỏi để làm bảng chấm công phải không?

Anh Nguyen

Anh Nguyen 19 May 2022

mình muốn tạo nút refresh trong sheet pivot này thì làm ntn ah?
Tuấn Ba

Tuấn Ba [Chuyên gia] 19 May 2022

chào bạn bạn kích vào pivot chuột phải chọn refresh là được nhé.

{"id":215420,"crm_contact_id":372035,"name":"Anh Nguyen","email":"anh.estimator@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"3784669af31ee88bf59ba63e5fbd5e4d","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-04-13T03:05:46.000000Z","updated_at":"2022-07-20T23:54:36.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":"2\/5 Alma Street Maidstone","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0401760512","become_teacher":0,"primary_wallet":0,"secondary_wallet":1000,"wallet_type":"","wallet_payment":"","loyalty_point":20257,"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_invalid":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\/images\/avatar\/folder_215\/anh-nguyen.png","link_profile":"https:\/\/gitiho.com\/u\/215420-anh-nguyen","business_employers":[],"vip_account":{"id":1239,"user_id":215420,"vip_account_id":1,"sale_price":299000,"discount":50,"time_start":"2022-05-18 09:26:19","time_end":"2023-05-18 09:26:19","created_at":"2022-05-18T02:26:19.000000Z","updated_at":"2022-05-18T02:26:19.000000Z"},"roles":[]}

Anh Nguyen 20 May 2022

Hi thầy,
{"id":215420,"crm_contact_id":372035,"name":"Anh Nguyen","email":"anh.estimator@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"3784669af31ee88bf59ba63e5fbd5e4d","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-04-13T03:05:46.000000Z","updated_at":"2022-07-20T23:54:36.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":"2\/5 Alma Street Maidstone","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0401760512","become_teacher":0,"primary_wallet":0,"secondary_wallet":1000,"wallet_type":"","wallet_payment":"","loyalty_point":20257,"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_invalid":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\/images\/avatar\/folder_215\/anh-nguyen.png","link_profile":"https:\/\/gitiho.com\/u\/215420-anh-nguyen","business_employers":[],"vip_account":{"id":1239,"user_id":215420,"vip_account_id":1,"sale_price":299000,"discount":50,"time_start":"2022-05-18 09:26:19","time_end":"2023-05-18 09:26:19","created_at":"2022-05-18T02:26:19.000000Z","updated_at":"2022-05-18T02:26:19.000000Z"},"roles":[]}

Anh Nguyen 20 May 2022

Hi thầy, nếu như em muốn tạo nút refresh này ngay trên sheet thì được ko 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":"2023-01-27T13:53:20.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":1010070,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"118095757772556445137","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":1927,"email_invalid":0,"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>","bizUser":"","avgCompleted":31.87}],"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":"Qu\u1ea3n l\u00fd n\u1ed9i dung","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-12-21T08:27:44.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] 20 May 2022

chào bạn với excel thường không được bạn phải dùng vba nhé,.

{"id":66,"crm_contact_id":127658,"name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","email":"duongquan211287@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2018-11-06 21:53:37","confirmation_code":"d79b40591d95db0a31320b960a8a115c","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2017-05-10T03:17:27.000000Z","updated_at":"2023-01-27T16:58:28.000000Z","deleted_at":null,"unit_name":"Gitiho.com","grade":0,"avatar_disk":"public","avatar_path":"users\/1657593507.jpg","gender":0,"birthday":"1987-12-20 07:00:00","position":"Chuy\u00ean gia excel","achievement":null,"full_name":"D\u01b0\u01a1ng Qu\u00e2n","address":"Gitiho.com","status_text":"<p>Gi\u1ea3ng vi\u00ean: D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n<\/p><p>- N\u01a1i c\u00f4ng t\u00e1c hi\u1ec7n t\u1ea1i: Chuy\u00ean gia gi\u00e1o d\u1ee5c t\u1ea1i Gitiho.com<\/p><p><span style=\"color: rgb(0, 0, 0);\">- T\u1eebng l\u00e0m k\u1ebf to\u00e1n qu\u1ea3n tr\u1ecb t\u1ea1i c\u00f4ng ty TNHH DTK'Vina, tr\u1ef1c thu\u1ed9c t\u1eadp&nbsp;\u0111o\u00e0n DEAHO, H\u00e0n Qu\u1ed1c.<\/span><br><\/p><p>- H\u01a1n 7 n\u0103m kinh nghi\u1ec7m l\u00e0m vi\u1ec7c v\u1edbi&nbsp;excel trong l\u0129nh v\u1ef1c k\u1ebf to\u00e1n, t\u00e0i ch\u00ednh<\/p><p>- X\u00e2y d\u1ef1ng nhi\u1ec1u ph\u1ea7n m\u1ec1m&nbsp;excel trong c\u00e1c l\u0129nh v\u1ef1c: K\u1ebf to\u00e1n kho, k\u1ebf to\u00e1n c\u00f4ng n\u1ee3, k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng... trong nhi\u1ec1u lo\u1ea1i h\u00ecnh doanh nghi\u1ec7p kh\u00e1c nhau.<\/p><p>- X\u00e2y d\u1ef1ng ph\u1ea7n m\u1ec1m&nbsp;excel trong l\u0129nh v\u1ef1c t\u00e0i ch\u00ednh: l\u1eadp ph\u01b0\u01a1ng&nbsp;\u00e1n kinh doanh, qu\u1ea3n tr\u1ecb d\u00f2ng ti\u1ec1n trong doanh nghi\u1ec7p...<\/p><p>- T\u01b0 v\u1ea5n gi\u1ea3i ph\u00e1p ho\u00e0n thi\u1ec7n quy tr\u00ecnh qu\u1ea3n l\u00fd doanh nghi\u1ec7p,&nbsp;\u00e1p d\u1ee5ng ph\u1ea7n m\u1ec1m&nbsp;excel n\u00e2ng cao hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c.<\/p><p><br><\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0977705162","become_teacher":0,"primary_wallet":54153591,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"103589301897268320461","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":1441,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_number":"2022\/GITIHO-DUONGQUAN","contract_date":"2019-12-31T17:00:00.000000Z","contract_delegate":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_address":"24 ng\u00e1ch 9 ng\u00f5 162A T\u00f4n \u0110\u1ee9c Th\u1eafng, \u0110\u1ed1ng \u0110a, H\u00e0 N\u1ed9i","contract_account_number":"19033577541015","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1657593507.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/66-duong-manh-quan","business_employers":[{"id":33,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":8.83}],"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":66,"role_id":8,"model_type":"App\\Models\\User"}},{"id":15,"name":"BlogManager","display_name":"BlogManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":15,"model_type":"App\\Models\\User"}},{"id":17,"name":"partnerAffiliate","display_name":"partnerAffiliate","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":17,"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":66,"role_id":19,"model_type":"App\\Models\\User"}}]}

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

Bạn có thể dùng VBA để tạo nút này trên sheet. Nhưng theo mình nghĩ là không nên, vì nó đã có sẵn trên thanh công cụ rồi. Nếu muốn thì bạn có thể record macro cho thao tác nhấn refresh, sau đó assign macro vào 1 nút bấm dạng shape hoặc button.

{"id":223012,"crm_contact_id":385809,"name":"Ph\u1ea1m Th\u1ecb H\u1ed3ng Y\u1ebfn","email":"yenhong212@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2022-05-16 13:56:16","confirmation_code":"83a198dd412a48ec199bef9b729de15f","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-05-16T06:52:12.000000Z","updated_at":"2022-11-04T09:15: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":"S\u1ed1 10,\u0110\u01b0\u1eddng 596,T\u1ed5 2,\u1ea4p \u0110\u1ed3n,X\u00e3 Trung L\u1eadp H\u1ea1,Huy\u1ec7n C\u1ee7 Chu,TP.HCM","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0986480203","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":78948,"google_id":"101582912149228161914","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_invalid":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\/images\/avatar\/folder_223\/pham-yen.png","link_profile":"https:\/\/gitiho.com\/u\/223012-pham-thi-hong-yen","business_employers":[],"vip_account":null,"roles":[]}

Phạm Thị Hồng Yến 02 Jun 2022

cho e hỏi Pivot Tables Analyze -> Insert Slice nó ẩn làm cách nào để hiện lê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":"2023-01-27T13:53:20.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":1010070,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"118095757772556445137","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":1927,"email_invalid":0,"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>","bizUser":"","avgCompleted":31.87}],"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":"Qu\u1ea3n l\u00fd n\u1ed9i dung","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-12-21T08:27:44.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

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

Chào bạn bạn tạo pivot table thì sẽ có Slice hiện lên nhé.

{"id":247712,"crm_contact_id":432442,"name":"nguyen thi hanh nguyen","email":"nghiepvu2014@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"e56ce110142585b3a84a867ff255bef1","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-09-20T07:00:55.000000Z","updated_at":"2023-01-15T08:21:11.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":66865,"google_id":"104886777454129406869","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"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\/images\/avatar\/folder_248\/nguyen-nguyen.png","link_profile":"https:\/\/gitiho.com\/u\/247712-nguyen-thi-hanh-nguyen","business_employers":[],"vip_account":{"id":2455,"user_id":247712,"vip_account_id":1,"sale_price":279000,"discount":50,"time_start":"2022-11-05 17:44:43","time_end":"2023-11-05 17:44:43","created_at":"2022-11-05T10:44:43.000000Z","updated_at":"2022-11-05T10:44:43.000000Z"},"roles":[]}

nguyen thi hanh nguyen 31 Dec 2022

Em tạo pivot table rồi mà slicer vẫn mờ thì làm sao ạ, 

{"id":66,"crm_contact_id":127658,"name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","email":"duongquan211287@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2018-11-06 21:53:37","confirmation_code":"d79b40591d95db0a31320b960a8a115c","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2017-05-10T03:17:27.000000Z","updated_at":"2023-01-27T16:58:28.000000Z","deleted_at":null,"unit_name":"Gitiho.com","grade":0,"avatar_disk":"public","avatar_path":"users\/1657593507.jpg","gender":0,"birthday":"1987-12-20 07:00:00","position":"Chuy\u00ean gia excel","achievement":null,"full_name":"D\u01b0\u01a1ng Qu\u00e2n","address":"Gitiho.com","status_text":"<p>Gi\u1ea3ng vi\u00ean: D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n<\/p><p>- N\u01a1i c\u00f4ng t\u00e1c hi\u1ec7n t\u1ea1i: Chuy\u00ean gia gi\u00e1o d\u1ee5c t\u1ea1i Gitiho.com<\/p><p><span style=\"color: rgb(0, 0, 0);\">- T\u1eebng l\u00e0m k\u1ebf to\u00e1n qu\u1ea3n tr\u1ecb t\u1ea1i c\u00f4ng ty TNHH DTK'Vina, tr\u1ef1c thu\u1ed9c t\u1eadp&nbsp;\u0111o\u00e0n DEAHO, H\u00e0n Qu\u1ed1c.<\/span><br><\/p><p>- H\u01a1n 7 n\u0103m kinh nghi\u1ec7m l\u00e0m vi\u1ec7c v\u1edbi&nbsp;excel trong l\u0129nh v\u1ef1c k\u1ebf to\u00e1n, t\u00e0i ch\u00ednh<\/p><p>- X\u00e2y d\u1ef1ng nhi\u1ec1u ph\u1ea7n m\u1ec1m&nbsp;excel trong c\u00e1c l\u0129nh v\u1ef1c: K\u1ebf to\u00e1n kho, k\u1ebf to\u00e1n c\u00f4ng n\u1ee3, k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng... trong nhi\u1ec1u lo\u1ea1i h\u00ecnh doanh nghi\u1ec7p kh\u00e1c nhau.<\/p><p>- X\u00e2y d\u1ef1ng ph\u1ea7n m\u1ec1m&nbsp;excel trong l\u0129nh v\u1ef1c t\u00e0i ch\u00ednh: l\u1eadp ph\u01b0\u01a1ng&nbsp;\u00e1n kinh doanh, qu\u1ea3n tr\u1ecb d\u00f2ng ti\u1ec1n trong doanh nghi\u1ec7p...<\/p><p>- T\u01b0 v\u1ea5n gi\u1ea3i ph\u00e1p ho\u00e0n thi\u1ec7n quy tr\u00ecnh qu\u1ea3n l\u00fd doanh nghi\u1ec7p,&nbsp;\u00e1p d\u1ee5ng ph\u1ea7n m\u1ec1m&nbsp;excel n\u00e2ng cao hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c.<\/p><p><br><\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0977705162","become_teacher":0,"primary_wallet":54153591,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"103589301897268320461","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":1441,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_number":"2022\/GITIHO-DUONGQUAN","contract_date":"2019-12-31T17:00:00.000000Z","contract_delegate":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_address":"24 ng\u00e1ch 9 ng\u00f5 162A T\u00f4n \u0110\u1ee9c Th\u1eafng, \u0110\u1ed1ng \u0110a, H\u00e0 N\u1ed9i","contract_account_number":"19033577541015","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1657593507.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/66-duong-manh-quan","business_employers":[{"id":33,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":8.83}],"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":66,"role_id":8,"model_type":"App\\Models\\User"}},{"id":15,"name":"BlogManager","display_name":"BlogManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":15,"model_type":"App\\Models\\User"}},{"id":17,"name":"partnerAffiliate","display_name":"partnerAffiliate","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":17,"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":66,"role_id":19,"model_type":"App\\Models\\User"}}]}

Dương Mạnh Quân [Chuyên gia] 03 Jan 2023

Mình không rõ nguyên nhân tại sao mục slicer lại bị mờ như vậy. Bạn thử tạo lại 1 pivot table sang 1 sheet khác xem sao.

{"id":247712,"crm_contact_id":432442,"name":"nguyen thi hanh nguyen","email":"nghiepvu2014@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"e56ce110142585b3a84a867ff255bef1","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-09-20T07:00:55.000000Z","updated_at":"2023-01-15T08:21:11.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":66865,"google_id":"104886777454129406869","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"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\/images\/avatar\/folder_248\/nguyen-nguyen.png","link_profile":"https:\/\/gitiho.com\/u\/247712-nguyen-thi-hanh-nguyen","business_employers":[],"vip_account":{"id":2455,"user_id":247712,"vip_account_id":1,"sale_price":279000,"discount":50,"time_start":"2022-11-05 17:44:43","time_end":"2023-11-05 17:44:43","created_at":"2022-11-05T10:44:43.000000Z","updated_at":"2022-11-05T10:44:43.000000Z"},"roles":[]}

nguyen thi hanh nguyen 03 Jan 2023

Mình làm theo HD của thầy nhưng vẫn k được, Gửi file thầy xem hộ. cám ơn thầy

https://docs.google.com/spreadsheets/d/1302PIv8lSqIDPMjSfEJXUar_OAaAjxyV/edit?usp=share_link&ouid=104886777454129406869&rtpof=true&sd=true

 

Tạ Thị Loan

Tạ Thị Loan 28 Dec 2022

Tuấn Ba

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

Bạn đổi dấu , thành ; nhé hoặc đọc bài viết sau

https://gitiho.com/blog/cach-chuyen-doi-dinh-dang-dau-cham-phay-trong-excel.html

{"id":273956,"crm_contact_id":489205,"name":"T\u1ea1 Th\u1ecb Loan","email":"giangloan28@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2022-12-22 13:10:44","confirmation_code":"69ba1c82e943c745aa2d136c05a342bb","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-12-22T04:46:23.000000Z","updated_at":"2022-12-28T10:00:49.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":"s\u1ed1 10 h\u1ebbm 17\/62\/135 ng\u00f5 135 c\u1ea7u c\u1ed1c, t\u00e2y m\u1ed7","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0976769283","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":15613,"google_id":"102944571267324186229","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"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\/images\/avatar\/folder_274\/ta-loan.png","link_profile":"https:\/\/gitiho.com\/u\/273956-ta-thi-loan","business_employers":[],"vip_account":null,"roles":[]}

Tạ Thị Loan 02 Jan 2023

Mình đổi các kiểu dấu vẫn ko được, và link bạn cho có vào được đâu

 

{"id":273956,"crm_contact_id":489205,"name":"T\u1ea1 Th\u1ecb Loan","email":"giangloan28@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2022-12-22 13:10:44","confirmation_code":"69ba1c82e943c745aa2d136c05a342bb","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-12-22T04:46:23.000000Z","updated_at":"2022-12-28T10:00:49.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":"s\u1ed1 10 h\u1ebbm 17\/62\/135 ng\u00f5 135 c\u1ea7u c\u1ed1c, t\u00e2y m\u1ed7","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0976769283","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":15613,"google_id":"102944571267324186229","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"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\/images\/avatar\/folder_274\/ta-loan.png","link_profile":"https:\/\/gitiho.com\/u\/273956-ta-thi-loan","business_employers":[],"vip_account":null,"roles":[]}

Tạ Thị Loan 02 Jan 2023

{"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":"2023-01-27T13:53:20.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":1010070,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"118095757772556445137","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":1927,"email_invalid":0,"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>","bizUser":"","avgCompleted":31.87}],"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":"Qu\u1ea3n l\u00fd n\u1ed9i dung","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-12-21T08:27:44.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] 03 Jan 2023

Bạn liên hệ cskh để được hỗ trợ nhé.

{"id":66,"crm_contact_id":127658,"name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","email":"duongquan211287@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2018-11-06 21:53:37","confirmation_code":"d79b40591d95db0a31320b960a8a115c","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2017-05-10T03:17:27.000000Z","updated_at":"2023-01-27T16:58:28.000000Z","deleted_at":null,"unit_name":"Gitiho.com","grade":0,"avatar_disk":"public","avatar_path":"users\/1657593507.jpg","gender":0,"birthday":"1987-12-20 07:00:00","position":"Chuy\u00ean gia excel","achievement":null,"full_name":"D\u01b0\u01a1ng Qu\u00e2n","address":"Gitiho.com","status_text":"<p>Gi\u1ea3ng vi\u00ean: D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n<\/p><p>- N\u01a1i c\u00f4ng t\u00e1c hi\u1ec7n t\u1ea1i: Chuy\u00ean gia gi\u00e1o d\u1ee5c t\u1ea1i Gitiho.com<\/p><p><span style=\"color: rgb(0, 0, 0);\">- T\u1eebng l\u00e0m k\u1ebf to\u00e1n qu\u1ea3n tr\u1ecb t\u1ea1i c\u00f4ng ty TNHH DTK'Vina, tr\u1ef1c thu\u1ed9c t\u1eadp&nbsp;\u0111o\u00e0n DEAHO, H\u00e0n Qu\u1ed1c.<\/span><br><\/p><p>- H\u01a1n 7 n\u0103m kinh nghi\u1ec7m l\u00e0m vi\u1ec7c v\u1edbi&nbsp;excel trong l\u0129nh v\u1ef1c k\u1ebf to\u00e1n, t\u00e0i ch\u00ednh<\/p><p>- X\u00e2y d\u1ef1ng nhi\u1ec1u ph\u1ea7n m\u1ec1m&nbsp;excel trong c\u00e1c l\u0129nh v\u1ef1c: K\u1ebf to\u00e1n kho, k\u1ebf to\u00e1n c\u00f4ng n\u1ee3, k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng... trong nhi\u1ec1u lo\u1ea1i h\u00ecnh doanh nghi\u1ec7p kh\u00e1c nhau.<\/p><p>- X\u00e2y d\u1ef1ng ph\u1ea7n m\u1ec1m&nbsp;excel trong l\u0129nh v\u1ef1c t\u00e0i ch\u00ednh: l\u1eadp ph\u01b0\u01a1ng&nbsp;\u00e1n kinh doanh, qu\u1ea3n tr\u1ecb d\u00f2ng ti\u1ec1n trong doanh nghi\u1ec7p...<\/p><p>- T\u01b0 v\u1ea5n gi\u1ea3i ph\u00e1p ho\u00e0n thi\u1ec7n quy tr\u00ecnh qu\u1ea3n l\u00fd doanh nghi\u1ec7p,&nbsp;\u00e1p d\u1ee5ng ph\u1ea7n m\u1ec1m&nbsp;excel n\u00e2ng cao hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c.<\/p><p><br><\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0977705162","become_teacher":0,"primary_wallet":54153591,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"103589301897268320461","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":1441,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_number":"2022\/GITIHO-DUONGQUAN","contract_date":"2019-12-31T17:00:00.000000Z","contract_delegate":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_address":"24 ng\u00e1ch 9 ng\u00f5 162A T\u00f4n \u0110\u1ee9c Th\u1eafng, \u0110\u1ed1ng \u0110a, H\u00e0 N\u1ed9i","contract_account_number":"19033577541015","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1657593507.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/66-duong-manh-quan","business_employers":[{"id":33,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":8.83}],"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":66,"role_id":8,"model_type":"App\\Models\\User"}},{"id":15,"name":"BlogManager","display_name":"BlogManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":15,"model_type":"App\\Models\\User"}},{"id":17,"name":"partnerAffiliate","display_name":"partnerAffiliate","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":17,"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":66,"role_id":19,"model_type":"App\\Models\\User"}}]}

Dương Mạnh Quân [Chuyên gia] 03 Jan 2023

Bạn đặt sai dấu chỗ “<=”&B3 rồi. Có một dấu ; ở giữa dấu “<=” với dấu &.

Sửa lại chỗ này, bỏ dấu ; đặt sai là được.

nguyen thi hanh nguyen

nguyen thi hanh nguyen 31 Dec 2022

Thầy ơi, chức năng insert slicer bị mờ thì phải làm sao ạ? cám ơn thầy

Tuấn Ba

Tuấn Ba [Chuyên gia] 03 Jan 2023

Chào bạn xem pivottable3 có dữ liệu không nhé.

EXG02 - Thủ thuật Excel cập nhật hàng tuần cho dân văn phòng
4.62

(66 đánh giá)

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