{"id":8035,"date":"2024-12-21T19:32:16","date_gmt":"2024-12-21T19:32:16","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-lap-bao-cao-tinh-hinh-su-dung-hoa-don-bc26-ac-su-dung-add-ins-hocexcel-online\/"},"modified":"2024-12-21T19:32:16","modified_gmt":"2024-12-21T19:32:16","slug":"huong-dan-lap-bao-cao-tinh-hinh-su-dung-hoa-don-bc26-ac-su-dung-add-ins-hocexcel-online","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-lap-bao-cao-tinh-hinh-su-dung-hoa-don-bc26-ac-su-dung-add-ins-hocexcel-online\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn l\u1eadp b\u00e1o c\u00e1o t\u00ecnh h\u00ecnh s\u1eed d\u1ee5ng h\u00f3a \u0111\u01a1n BC26\/AC S\u1eed d\u1ee5ng Add ins HocExcel Online"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p><em><span style=\"font-size: 14pt\">H\u00f4m nay <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-lap-bao-cao-tinh-hinh-su-dung-hoa-don-bc26ac-phan-2.html\"><strong>l\u1eadp b\u00e1o c\u00e1o t\u00ecnh h\u00ecnh s\u1eed d\u1ee5ng h\u00f3a \u0111\u01a1n BC26\/AC<\/strong><\/a> S\u1eed d\u1ee5ng Add ins HocExcel Online<\/span><\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-676717bf43f1e\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-lap-bao-cao-tinh-hinh-su-dung-hoa-don-bc26ac-phan-2.html#Muc_dich\" title=\"M\u1ee5c \u0111\u00edch\">M\u1ee5c \u0111\u00edch<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-lap-bao-cao-tinh-hinh-su-dung-hoa-don-bc26ac-phan-2.html#Thuc_hien\" title=\"Th\u1ef1c hi\u1ec7n\">Th\u1ef1c hi\u1ec7n<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Muc_dich\"><\/span>M\u1ee5c \u0111\u00edch<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nh\u01b0 b\u00e0i vi\u1ebft tr\u01b0\u1edbc v\u1ec1 h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-lam-bao-cao-tinh-hinh-su-dung-hoa-don-bc26ac.html\">H\u01b0\u1edbng d\u1eabn l\u1eadp b\u00e1o c\u00e1o t\u00ecnh t\u00ecnh h\u00ecnh s\u1eed d\u1ee5ng h\u00f3a \u0111\u01a1n<\/a>\u00a0h\u00f4m nay HocExcel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n s\u1eed d\u1ee5ng Add ins HocExcel Online \u0111\u1ec3 l\u00e0m th\u1ef1c hi\u1ec7n vi\u1ec7c l\u1ea5y h\u00f3a \u0111\u01a1n x\u00f3a b\u1ecf<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Thuc_hien\"><\/span>Th\u1ef1c hi\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c Add ins HocExcel Online c\u00e1c b\u1ea1n c\u1ea7n c\u00e0i \u0111\u1eb7t Add ins HocExcel Online n\u1ebfu b\u1ea1n n\u00e0o ch\u01b0a c\u00f3 xem <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cai-dat-add-ins-hocexcelonline.html\">t\u1ea1i \u0111\u00e2y<\/a><\/p>\n<p>\u0110\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c c\u00e1c b\u1ea1n ph\u1ea3i c\u00f3 \u0111\u01b0\u1ee3c 2 c\u1ed9t. 1 c\u1ed9t ch\u1ee9a h\u00f3a \u0111\u01a1n \u0111\u00e3 s\u1eed d\u1ee5ng v\u00e0 m\u1ed9t c\u1ed9t l\u00e0 to\u00e0n b\u1ed9 h\u00f3a \u0111\u01a1n s\u1eed d\u1ee5ng trong qu\u00fd.<\/p>\n<p>Sau khi c\u00e1c b\u1ea1n c\u00f3 \u0111\u01b0\u1ee3c s\u1ed1 l\u01b0\u1ee3ng h\u00f3a \u0111\u01a1n xu\u1ea5t ra v\u00e0 c\u1ed9t t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng h\u00f3a \u0111\u01a1n nh\u01b0 h\u00ecnh.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29739\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/hoadon.png\" alt=\"H\u01b0\u1edbng d\u1eabn l\u1eadp b\u00e1o c\u00e1o t\u00ecnh h\u00ecnh s\u1eed d\u1ee5ng h\u00f3a \u0111\u01a1n BC26\/AC S\u1eed d\u1ee5ng Add ins HocExcel Online\" width=\"400\" height=\"915\" title=\"hoadon\"><\/p>\n<p>B1: Ti\u1ebfn h\u00e0nh \u0111\u1eb7t t\u00ean cho v\u00f9ng d\u1eef li\u1ec7u c\u1ed9t A nh\u1eefng h\u00f3a \u0111\u01a1n \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng th\u1ef1c t\u1ebfn \u0111\u1eb7t t\u00ean l\u00e0 \u201csudung\u201d v\u00e0 c\u1ed9t B t\u1ed5ng s\u1ed1 h\u00f3a \u0111\u01a1n bao g\u1ed3m c\u1ea3 h\u00f3a \u0111\u01a1n x\u00f3a b\u1ecf trong qu\u00fd \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean l\u00e0 \u201ctongso\u201d nh\u01b0 trong h\u00ecnh.<\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-725.gif\" title=\"ex101_92019-nho-725\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-333.gif\" title=\"vba101_92019-nho-333\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-725.gif\" title=\"ex101_92019-nho-725\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29740\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/name.png\" alt=\"H\u01b0\u1edbng d\u1eabn l\u1eadp b\u00e1o c\u00e1o t\u00ecnh h\u00ecnh s\u1eed d\u1ee5ng h\u00f3a \u0111\u01a1n BC26\/AC S\u1eed d\u1ee5ng Add ins HocExcel Online\" width=\"570\" height=\"450\" title=\"name\"><\/p>\n<p>T\u1ea1i \u00f4 C1 ta vi\u1ebft c\u00f4ng th\u1ee9c sau:<\/p>\n<blockquote>\n<p>select Tongsohoadon from tongso where Tongsohoadon not in (select hoadonsudung from sudung)<\/p>\n<\/blockquote>\n<p>C\u00f4ng th\u1ee9c tr\u00ean l\u1ea5y to\u00e0n b\u1ed9 h\u00f3a \u0111\u01a1n c\u00f3 trong Tongsohoadon m\u00e0 kh\u00f4ng c\u00f3 trong hoadonsudung ngh\u0129a l\u00e0 l\u1ea5y to\u00e0n b\u1ed9 h\u00f3a \u0111\u01a1n x\u00f3a b\u1ecf c\u1ee7a doanh nghi\u1ec7p trong th\u1eddi gian l\u00e0 th\u00e1ng hay qu\u00fd.<\/p>\n<p>Ti\u1ebfp theo ta s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c \u201cHeosql\u201d trong Add ins HocExecel Online \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00f4ng th\u1ee9c tr\u00ean.<\/p>\n<blockquote>\n<p>=Heosql($C$1,\u201dTen = BC\u201d)<\/p>\n<\/blockquote>\n<p>H\u00e0m Heosql tr\u1ea3 ra to\u00e0n b\u1ed9 h\u00f3a \u0111\u01a1n b\u1ecf tr\u1ed1n v\u00e0 \u0111\u1eb7t t\u00ean v\u00f9ng \u0111\u00f3 l\u00e0 BC(\u0111\u00e2y l\u00e0 d\u1eef li\u1ec7u \u0111\u1ed9ng)<\/p>\n<p>\u1ea4n Enter l\u00e0 ta \u0111\u00e3 c\u00f3 k\u1ebft qu\u1ea3 c\u1ee7a to\u00e0n b\u1ed9 h\u00f3a \u0111\u01a1n x\u00f3a b\u1ecf nh\u01b0 trong h\u00ecnh<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29744 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2019-08-30_134832.png\" alt=\"H\u01b0\u1edbng d\u1eabn l\u1eadp b\u00e1o c\u00e1o t\u00ecnh h\u00ecnh s\u1eed d\u1ee5ng h\u00f3a \u0111\u01a1n BC26\/AC S\u1eed d\u1ee5ng Add ins HocExcel Online 3\" width=\"1293\" height=\"934\" title=\"2019-08-30_134832\"><\/p>\n<p>Gi\u1edd \u0111\u00e3 c\u00f3 h\u00f3a \u0111\u01a1n x\u00f3a b\u1ecf \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean l\u00e0 BC nh\u01b0ng ch\u01b0a \u0111\u00fang chu\u1ea9n \u0111\u1ecbnh d\u1ea1ng c\u1ee7a HTKK n\u00ean ta c\u1ea7n s\u1eed d\u1ee5ng th\u00eam h\u00e0m \u201cHeotextjoin\u201d Trong Add ins HocExcel Online ho\u1eb7c c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng nh\u01b0 b\u00e0i vi\u1ebft<\/p>\n<p>T\u1ea1i \u00f4 D3 ta nh\u1eadp c\u00f4ng th\u1ee9c sau.<\/p>\n<blockquote>\n<p>=Heotextjoin(bc,\u201d;\u201d)<\/p>\n<\/blockquote>\n<p>H\u00e0m Heotextjoin n\u1ed1i l\u1ea1i theo m\u1ed9t \u0111i\u1ec1u ki\u1ec7n n\u00e0o \u0111\u00f3 \u1edf \u0111\u00e2y n\u1ed1i theo d\u1ea5u \u201c;\u201d \u0111\u00fang chu\u1ea9n \u0111\u1ecbnh d\u1ea1ng HTKK<\/p>\n<p>K\u1ebft qu\u1ea3 s\u1ebd \u0111\u01b0\u1ee3c nh\u01b0 h\u00ecnh sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29746 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/kq.png\" alt=\"H\u01b0\u1edbng d\u1eabn l\u1eadp b\u00e1o c\u00e1o t\u00ecnh h\u00ecnh s\u1eed d\u1ee5ng h\u00f3a \u0111\u01a1n BC26\/AC S\u1eed d\u1ee5ng Add ins HocExcel Online 4\" width=\"1587\" height=\"934\" title=\"kq\"><\/p>\n<p>Sau khi \u0111\u00e3 c\u00f3 \u0111\u1ecbnh d\u1ea1ng chu\u1ea9n c\u1ee7a HTKK ta ch\u1ec9 vi\u1ec7c copy v\u00e0o ch\u1ec9 ti\u00eau 15 l\u00e0 \u0111\u00e3 c\u00f3 m\u1ed9t b\u00e1o c\u00e1o t\u00ecnh h\u00ecnh s\u1eed d\u1ee5ng h\u00f3a \u0111\u01a1n l\u00e0 \u0111\u00e3 \u0111\u01b0\u1ee3c to\u00e0n b\u1ed9 h\u00f3a \u0111\u01a1n x\u00f3a b\u1ecf trong kho\u1ea3ng th\u1eddi gian l\u00e0 qu\u00fd, th\u00e1ng.<\/p>\n<p>Th\u1eadt \u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o!<\/p>\n<p>Ch\u1ec9 c\u1ea7n v\u00e0i b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n nh\u01b0 tr\u00ean HocExcel Online \u0111\u00e3 h\u01b0\u1edbng d\u1eabn c\u00e1c ban t\u1ea1o ra b\u00e1o c\u00e1o t\u00ecnh h\u00ecnh s\u1eed d\u1ee5ng h\u00f3a \u0111\u01a1n khi s\u1eed d\u1ee5ng Add ins HocExcel Online.<\/p>\n<p>H\u00e3y Theo d\u00f5i HocExcel Online \u0111\u1ec3 c\u00f3 nh\u1eefng b\u00e0i vi\u1ebft b\u1ed5 \u00edch v\u1ec1 Excel v\u00e0 th\u1ee7 thu\u1eadt nh\u00e9<\/p>\n<hr>\n<p>B\u00e0i vi\u1ebft li\u00ean quan.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-lam-bao-cao-tinh-hinh-su-dung-hoa-don-bc26ac.html\">H\u01b0\u1edbng d\u1eabn l\u00e0m b\u00e1o c\u00e1o t\u00ecnh h\u00ecnh s\u1eed d\u1ee5ng h\u00f3a \u0111\u01a1n BC26\/AC<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-lap-nhat-ky-chung-bang-ham-heosql.html\">H\u01b0\u1edbng d\u1eabn l\u1eadp s\u1ed5 Nh\u1eadt k\u00fd chung b\u1eb1ng H\u00e0m \u201cHeoSQL\u201d<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-ham-heongaychu-de-doc.html\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m \u201cHeongaychu\u201d chuy\u1ec3n ng\u00e0y th\u00e1ng sang \u0111\u1ecbnh d\u1ea1ng ch\u1eef<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cai-dat-add-ins-hocexcelonline-xuat-hien-cung-voi-excel.html\">C\u00e0i \u0111\u1eb7t Add ins xu\u1ea5t hi\u1ec7n c\u00f9ng Excel<\/a><\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-725.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8036,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8035","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8035","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=8035"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8035\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8036"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8035"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8035"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8035"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}