경영자동화 검색결과 30건
-
구매발주 통합관리 프로그램 ver 1.1 (발주부터 출고까지 재고관리를 위한) 경영자동화 > 자재·생산 | 조회 48,117구성 : 기본목록,초기재고,매입처관리,발주요청,발주서입력,구매입력,구매내역서,세금계산서,매입처별 구매현황,월별구매현황,출고입력,출고지시서,출고현황,창고별,품목현황 각 부서에서 요청하는 발주를 접수하여 매입처별로 자동통합된 발주서를 발행하고, 발주서별 구매완료된 품목은 세금계산서를 발행하거나 매입처별 또는 월별 품목현황을 확인할 수 있습니다. 등록된 자료를 바탕으로 발주요청내역서, 구매내역서, 매입처별구매현황, 품목별구매현황, 창고별/품목별재고현황 등이 자동작성되어 관리가 용이합니다.
-
생산일지, 원료수불부, 재고 통합관리 자동화 프로그램 (배합정보 - 원료 배합량 적용) New Ver 4.1.2 경영자동화 > 자재·생산 | 조회 22,632구성 : 업체관리, 제품관리, 배합정보, 원재료입고, 제품생산, 제품판매, 생산일지, 원료수불부, 원료수불대장(제품별), 제품거래내역, 거래명세서출력, 재고현황 배합정보는 제품에 대한 원재료별 배합량을 입력하여 관리합니다. 배합정보에 대한 배합방법을 상세 기록 할 수 있습니다. 배합정보를 반영한 생산, 원료수불 및 제품재고 자동관리 프로그램입니다. 원료, 제품 정보 및 입고처, 출고처 정보를 입력하시면 원료의 입고, 제품의 생산판매에서 기록되는 데이터로 원료수불내역과 제품거래내역, 월별 제품재고현황을 자동으로 관리할 수 있습니다. 반제품, 제품에 대한 배합정보를 입력하시면 저장된 데이터를 바탕으로 생산일지를 간편하게 관리할 수 있습니다. 또한 입력된 제품 거래 내역을 바탕으로 거래명세서를 출력하실 수 있습니다. (식약처 서류증빙용 프로그램)
업무자동화 검색결과 836건
표준엑셀 검색결과 94건
맞춤제작 전문가 답변 검색결과 1,573건
-
번거로움을 줄이고 신속한 업무 조건으로 업그레이드 되길 원합니다! 도와주세요!
1.업종 : 도매업
2.예산 : 협의
3.제작 요청사항
s="s1" style="font-size: 14px; -webkit-text-size-adjust: auto;">안녕하세요arch_bold'>ass="s2" style="font-size: 14px; -webkit-text-size-adjust: auto; font-family: UICTFontTextStyleBody;">. arch_bold'>ass="s1" style="font-size: 14px; -webkit-text-size-adjust: auto;">저희는arch_bold'>ass="s2" style="font-size: 14px; -webkit-text-size-adjust: auto; font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1" style="font-size: 14px; -webkit-text-size-adjust: auto;">남대문에서arch_bold'>ass="s2" style="font-size: 14px; -webkit-text-size-adjust: auto; font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1" style="font-size: 14px; -webkit-text-size-adjust: auto;">중도매를arch_bold'>ass="s2" style="font-size: 14px; -webkit-text-size-adjust: auto; font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1" style="font-size: 14px; -webkit-text-size-adjust: auto;">하고arch_bold'>ass="s2" style="font-size: 14px; -webkit-text-size-adjust: auto; font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1" style="font-size: 14px; -webkit-text-size-adjust: auto;">있는arch_bold'>ass="s2" style="font-size: 14px; -webkit-text-size-adjust: auto; font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1" style="font-size: 14px; -webkit-text-size-adjust: auto;">업체입니다arch_bold'>ass="s2" style="font-size: 14px; -webkit-text-size-adjust: auto; font-family: UICTFontTextStyleBody;">.
arch_bold'>asarch_bold'>ass="s2" style="font-size: 14px; -webkit-text-size-adjust: auto; font-family: UICTFontTextStyleBody;">
arch_bold'>ass="s2" style="font-size: 14px; -webkit-text-size-adjust: auto; font-family: UICTFontTextStyleBody;">
1)업무흐름 및 기존 업무방식
ar
ch_bold'>ass="p1" style="font-stretch: normal; font-size: 14px; line-height: normal; -webkit-text-size-adjust: auto;">arch_bold'>ass="s1">주arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">고객은arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">소매업체들이며arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">카페arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">24 arch_bold'>ass="s1">자사몰은arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">있으나arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">현재arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">활용하지arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">않고arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">있으며arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">현재arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">카톡arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">및arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">다른arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">도매사이트에서arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">고객으로부터arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">주문을arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">받고arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">있고arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">해당arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">주문은arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">엑셀로arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">일일히arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">입력하여arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">정리하고arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">있습니다arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">.arch_bold'>ass="p2" style="margin-arch_bold'>ass='search_bold'>bottom: 3px; font-stretch: normal; font-size: 23px; line-height: normal; min-height: 31.2px; -webkit-text-size-adjust: auto;">arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;">
arch_bold'>ass="p3" style="margin-arch_bold'>ass='search_bold'>bottom: 3px; font-stretch: normal; font-size: 23px; line-height: normal; font-family: "Times New Roman"; -webkit-text-size-adjust: auto;">arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">저희의arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;"> arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">엑셀arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;"> arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">주문arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;"> arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">양식은arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;"> /arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">날짜arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;">.arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">상호arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;">.arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">브랜드arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;">.arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">제품명arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;">.arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">색상arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;">.arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">사이즈arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;">.arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">수량arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;">.arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">금액arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;">.arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">일정arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;">.arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">기타사항arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;">.arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">출고일arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;">/arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">로arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;"> arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">구분되어arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;"> arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">있습니다arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;">.
arch_bold'>ass="p4" style="font-stretch: normal; font-size: 14px; line-height: normal; min-height: 19px; -webkit-text-size-adjust: auto;">arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">
arch_bold'>ass="p1" style="font-stretch: normal; font-size: 14px; line-height: normal; -webkit-text-size-adjust: auto;">arch_bold'>ass="s1">약arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> 80arch_bold'>ass="s1">개의arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">도매브랜드arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">별arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">상품을arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">취합하여arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">각각arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">거래청arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">주문을arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">넣고arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">있고arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">물건arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">입고시arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">주문잡은arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">엑셀에arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">브랜드별로arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">필터검색하여arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">입고된arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">물건을arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">arch_bold'>ass="s1">분류하며arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> “arch_bold'>ass="s1">입고arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">-arch_bold'>ass="s1">녹색arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">, arch_bold'>ass="s1">예약arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">(arch_bold'>ass="s1">미송arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">)-arch_bold'>ass="s1">노랑arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">, arch_bold'>ass="s1">품절arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">-arch_bold'>ass="s1">빨강arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">, arch_bold'>ass="s1">출고arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">-arch_bold'>ass="s1">회색arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">” arch_bold'>ass="s1">현재arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">주문arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">상태값은arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">엑셀에서arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">색깔로arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">구분하여arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">표시하고arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">있습니다arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">.
arch_bold'>ass="p4" style="font-stretch: normal; font-size: 14px; line-height: normal; min-height: 19px; -webkit-text-size-adjust: auto;">arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">
arch_bold'>ass="p3" style="margin-arch_bold'>ass='search_bold'>bottom: 3px; font-stretch: normal; font-size: 23px; line-height: normal; font-family: "Times New Roman"; -webkit-text-size-adjust: auto;">arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">물건arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;"> arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">분류arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;"> arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">후엔arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;"> arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">고객의arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;"> arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">입고목록arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;"> arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">확인을arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;"> arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">위하여arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;"> arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">카톡을arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;"> arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">통해arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;"> arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">입고arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;"> arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">표시한arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;"> arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">엑셀을arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;"> arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">이미지로arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;">arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">복사하여arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;"> arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">일일히arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;"> arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">전송해주고arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;"> arch_bold'>ass="s4" style="font-weight: arch_bold'>ass='search_bold'>bold;">있습니다arch_bold'>ass="s3" style="font-family: UICTFontTextStyleBody; font-weight: arch_bold'>ass='search_bold'>bold;">.
arch_bold'>ass="p4" style="font-stretch: normal; font-size: 14px; line-height: normal; min-height: 19px; -webkit-text-size-adjust: auto;">arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">
arch_bold'>ass="p1" style="font-stretch: normal; font-size: 14px; line-height: normal; -webkit-text-size-adjust: auto;">arch_bold'>ass="s1">현재arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">문제점
- arch_bold'>ass="ul1" style="-webkit-text-size-adjust: auto;">
- arch_bold'>ass="li1" style="margin: 0px; font-stretch: normal; font-size: 14px; line-height: normal;">arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">arch_bold'>ass="s1">여러명이arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">동시에arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">전산arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">확인arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">불가능arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">
- arch_bold'>ass="li1" style="margin: 0px; font-stretch: normal; font-size: 14px; line-height: normal;">arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">arch_bold'>ass="s1">입고arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">물건arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">분류arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">시arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">다른arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">업무를arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">하지arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">못함
- arch_bold'>ass="li1" style="margin: 0px; font-stretch: normal; font-size: 14px; line-height: normal;">arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">arch_bold'>ass="s1">입고목록arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">전송arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">업무가arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">많은arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">시간을arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">소요
- arch_bold'>ass="li1" style="margin: 0px; font-stretch: normal; font-size: 14px; line-height: normal;">arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">arch_bold'>ass="s1">송장arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">등록arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">시arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">고객arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">정보arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">주소arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">확인arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">번거로움
2)자동화하고 싶은 업무
arch_bold'>ass="p1" style="font-stretch: normal; font-size: 14px; line-height: normal; -webkit-text-size-adjust: auto;">arch_bold'>ass="s1">원하는arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">자동화arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">시스템arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">요청arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">내역 (주문관리 입출고관리 재고관리 고객관리)
- arch_bold'>ass="ul1" style="-webkit-text-size-adjust: auto;">
- arch_bold'>ass="li1" style="margin: 0px; font-stretch: normal; font-size: 14px; line-height: normal;">arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">arch_bold'>ass="s1">고객이arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">사이트로arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">주문하지arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">않아도arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">전산에arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">바로arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">직접arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">주문arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">입력arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">가능한arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">기능
- arch_bold'>ass="li1" style="margin: 0px; font-stretch: normal; font-size: 14px; line-height: normal;">arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">arch_bold'>ass="s1">브랜드arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">별arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">주문arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">확인arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">검색arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">기능
- arch_bold'>ass="li1" style="margin: 0px; font-stretch: normal; font-size: 14px; line-height: normal;">arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">arch_bold'>ass="s1">주문arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">물건arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">입고시arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">수량만arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">입력하면arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">자동으로arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">오래된arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">주문서부터arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">자동arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">입고arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">상태로arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">변경arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">(arch_bold'>ass="s1">입고arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">물건arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">분류시arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">편리함을arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">위하여arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">)
- arch_bold'>ass="li1" style="margin: 0px; font-stretch: normal; font-size: 14px; line-height: normal;">arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">arch_bold'>ass="s1">입금arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> / arch_bold'>ass="s1">미입금arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">주문서arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">관리arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> (arch_bold'>ass="s1">입금확인arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">직접처리arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">)
- arch_bold'>ass="li1" style="margin: 0px; font-stretch: normal; font-size: 14px; line-height: normal;">arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">arch_bold'>ass="s1">상품arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">단가arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> -> arch_bold'>ass="s1">세일가arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">자동arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">계산arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">입력arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">기능
- arch_bold'>ass="li1" style="margin: 0px; font-stretch: normal; font-size: 14px; line-height: normal;">arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">arch_bold'>ass="s1">상품arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">모두arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">입고시arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">배송준비arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">상태로arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">자동arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">변경
- arch_bold'>ass="li1" style="margin: 0px; font-stretch: normal; font-size: 14px; line-height: normal;">arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">arch_bold'>ass="s1">입고된arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">품목arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">일부arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">부분배송arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">요청arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">시arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">배송가능하도록
- arch_bold'>ass="li1" style="margin: 0px; font-stretch: normal; font-size: 14px; line-height: normal;">arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">arch_bold'>ass="s1">배송출고일arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">일괄등록arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> (arch_bold'>ass="s1">송장출력기능arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">)
- arch_bold'>ass="li1" style="margin: 0px; font-stretch: normal; font-size: 14px; line-height: normal;">arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">arch_bold'>ass="s1">여러arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">명arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">동시arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">접속arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">및arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">확인arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">가능arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">(arch_bold'>ass="s1">관리자arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">직원arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">구분필요arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">)
- arch_bold'>ass="li1" style="margin: 0px; font-stretch: normal; font-size: 14px; line-height: normal;">arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">arch_bold'>ass="s1">고객이arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">주문한arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">각arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">품목별arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">입고확인arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">가능하도록arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">(arch_bold'>ass="s1">일정메모arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">및arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">안내기능arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">)
- arch_bold'>ass="li1" style="margin: 0px; font-stretch: normal; font-size: 14px; line-height: normal;">arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">arch_bold'>ass="s1">모두입고시arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">배송준비중으로arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">상태arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">자동변경
arch_bold'>ass="p2" style="font-stretch: normal; font-size: 14px; line-height: normal; min-height: 19px; -webkit-text-size-adjust: auto;">arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">
arch_bold'>ass="p1" style="font-stretch: normal; font-size: 14px; line-height: normal; -webkit-text-size-adjust: auto;">arch_bold'>ass="s1">위arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">기능들을arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">어느arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">정도arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">해당arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">기능들을arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">사용하여arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">관리가arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">가능한지arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;"> arch_bold'>ass="s1">문의드립니다arch_bold'>ass="s2" style="font-family: UICTFontTextStyleBody;">.
-
엑셀 자동화 작업 의뢰 요청
ar
ch_bold'>ass="0" style="mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt">◎ 의뢰자arch_bold'>ass="0" style="mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt">- **************
arch_bold'>ass="0" style="MARGIN-LEFT: 25.6pt; TEXT-INDENT: -25.6pt; mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt">- 담당자 : ***
arch_bold'>ass="0" style="MARGIN-LEFT: 25.6pt; TEXT-INDENT: -25.6pt; mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt">- 연락처 : ***-***-****, ***-****-****
arch_bold'>ass="0" style="FONT-SIZE: 15pt; mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt">
arch_bold'>ass="0" style="mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt">◎ 주 담당 업무
arch_bold'>ass="0" style="MARGIN-LEFT: 27.8pt; TEXT-INDENT: -27.8pt; mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt">- 자치경찰단 수사과에서는 수사 사건을 전자문서(공문서) 또는 출력된 고소장, 고발장을 접수 받음.
arch_bold'>ass="0" style="MARGIN-LEFT: 25.9pt; TEXT-INDENT: -25.9pt; mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt">- 접수받은 사건을 각 직원들에게 배당을 하고 사건을 처리하는 부서 임.
arch_bold'>ass="0" style="FONT-SIZE: 15pt; mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt">
arch_bold'>ass="0" style="mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt">◎ 의뢰 목적
arch_bold'>ass="0" style="MARGIN-LEFT: 27.8pt; TEXT-INDENT: -27.8pt; mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt">- 관리자 입장에서 사건 관리하기 위함.
arch_bold'>ass="0" style="FONT-SIZE: 15pt; COLOR: #0000ff; MARGIN-LEFT: 27.8pt; TEXT-INDENT: -27.8pt; mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt">
arch_bold'>ass="0" style="mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt">◎ 의뢰 내용
arch_bold'>ass="0" style="MARGIN-LEFT: 19.1pt; TEXT-INDENT: -19.1pt; mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt">- 엑셀 작업 내용을 사건 접수와 처리 사건 데이터 입력하면 통계 및 직원별 사건 현황이 도출되는 자동화 시스템
arch_bold'>ass="0" style="FONT-SIZE: 15pt; MARGIN-LEFT: 25.9pt; TEXT-INDENT: -25.9pt; mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt">
arch_bold'>ass="0" style="mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt">◎ 현재 엑셀 작업 방식
arch_bold'>ass="0" style="MARGIN-LEFT: 24.4pt; TEXT-INDENT: -24.4pt; mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt">1) 전자문서(공문서) 또는 출력된 고발장, 고소장을 접수받으면,
arch_bold'>ass="0" style="MARGIN-LEFT: 24.7pt; TEXT-INDENT: -24.7pt; mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt">2) 2020년 일반사건 접수, 처리현황(예시)의 ‘산림환경시트’ 또는 ‘공중식품시트’에 사건 데이터를 입력함.
arch_bold'>ass="0" style="MARGIN-LEFT: 34.4pt; TEXT-INDENT: -34.4pt; mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt">※ 입력하는 데이터) 인지 종류, 접수일자, 배당일자, 담당 수사관, 위반법률, 위반자(인적사항), 위반내용, 발생지역, 위반장소, 비고
arch_bold'>ass="0" style="FONT-SIZE: 13pt; MARGIN-LEFT: 38.8pt; LETTER-SPACING: -0.2pt; TEXT-INDENT: -38.8pt; mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt">
arch_bold'>ass="0" style="MARGIN-LEFT: 27.9pt; TEXT-INDENT: -27.9pt; mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt">3) 담당 수사관이 사건 처리(기소, 불기소, 내사종결, 이송등)을 하면,
arch_bold'>ass="0" style="MARGIN-LEFT: 34.3pt; TEXT-INDENT: -34.3pt; mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt">4) 2020년 일반사건 접수, 처리현황(예시) ‘2020사건시트’에 처리 사건의 데이터를 입력하여 내역을 관리 중임.
arch_bold'>ass="0" style="MARGIN-LEFT: 38.8pt; TEXT-INDENT: -38.8pt; mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt">※ 입력하는 데이터) 지역, 구분, 사건번호, 위반법률, 위반자(성명, 피의자수, 위반유형, 지역, 장소, 피해정도, 위반목적, 수사단서, 처리결과, 접수(배당)일자, 송치일, 처리기간, 담당자, 송치번호, 수사지휘여부, 처리월
arch_bold'>ass="0" style="MARGIN-LEFT: 21.6pt; TEXT-INDENT: -21.6pt; mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt">5) 위와 같이. 사건 접수-> 사건처리내역의 데이터를 기반으로,
arch_bold'>ass="0" style="MARGIN-LEFT: 21.6pt; TEXT-INDENT: -21.6pt; mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt">6) 2020년 일반사건 접수, 처리현황(예시)의 시트별 통계 내역과 직원별 처리현황(예시)의 엑셀파일과 같이 직원별 처리, 보유유사건의 내역을 관리목적으로 확인 중임.
arch_bold'>ass="0" style="MARGIN-LEFT: 35.3pt; TEXT-INDENT: -35.3pt; mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt">※ 매월 주기적으로 데이터를 입력하더라도, 직원별 보유현황등은 입력한 데이터를 기반으로 수작업 중 임.
arch_bold'>ass="hwp_editor_arch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>barch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>arch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>arch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>oard_content" id="hwpEditorBarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>arch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>arch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>oardContent" arch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>data-jsonlen="31000" arch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>data-hjsonver="1.0">
업무단축키 검색결과 31건
-
셀 안의 문자가 #VALUE! 로 표시될 때 엑셀팁/엑셀2010/#VALUE! 셀에 #VALUE! 이 오류는 여러 가지 이유가 있습니다. 셀에 수식이 잘못 입력되었거나 배열 수식의 경우 Ctrl + Shift + Enter 키로 수식을 입력했을 경우입니다. 대표적으로 ① 셀에 지정된 셀을 참조하여 함수를 실행할 때 한 셀에 문자가 들어갈 경우 ② 셀에 지정된 셀을 참조하여 함수를 실행할 때 한 셀에 많은 숫자가 들어갈 경우 #VALUE! 로 표시됩니다.