{"id":16,"date":"2023-11-22T02:18:52","date_gmt":"2023-11-22T02:18:52","guid":{"rendered":"https:\/\/exceladvisor.org\/ko\/%ec%9e%ac%ea%b3%a0-%ea%b4%80%eb%a6%ac-%ed%85%9c%ed%94%8c%eb%a6%bf-excel-vba-%ec%82%ac%ec%9a%a9%ec%9e%90-%ec%96%91%ec%8b%9d\/"},"modified":"2023-12-11T07:00:05","modified_gmt":"2023-12-11T07:00:05","slug":"%ec%9e%ac%ea%b3%a0-%ea%b4%80%eb%a6%ac-%ed%85%9c%ed%94%8c%eb%a6%bf-excel-vba-%ec%82%ac%ec%9a%a9%ec%9e%90-%ec%96%91%ec%8b%9d","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/ko\/%ec%9e%ac%ea%b3%a0-%ea%b4%80%eb%a6%ac-%ed%85%9c%ed%94%8c%eb%a6%bf-excel-vba-%ec%82%ac%ec%9a%a9%ec%9e%90-%ec%96%91%ec%8b%9d\/","title":{"rendered":"Excel \uc7ac\uace0 \uad00\ub9ac \ud15c\ud50c\ub9bf"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2817160430\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <div id=\"ub_table-of-contents-98e96f40-85ee-4a0c-9256-7dcb769dedfa\" class=\"ub_table-of-contents\" data-showtext=\"show\" data-hidetext=\"hide\" data-scrolltype=\"auto\" data-initiallyhideonmobile=\"false\" data-initiallyshow=\"true\"><div class=\"ub_table-of-contents-extra-container\"><div class=\"ub_table-of-contents-container ub_table-of-contents-2-column \"><p> \ub54c\ub85c\ub294 \uc77c\ubc18 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0\uc11c \uc7ac\uace0\ub098 \uc7ac\uace0\ub97c \ucd94\uc801\ud558\ub294 \uac83\uc774 \ub9e4\uc6b0 \uc5b4\ub835\uc2b5\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \uc7ac\uace0\ub97c \ud6a8\uacfc\uc801\uc73c\ub85c \ucd94\uc801\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub418\ub294 \ud15c\ud50c\ub9bf\uc774 \ud544\uc694\ud569\ub2c8\ub2e4.<\/p><\/div><\/div><\/div><p> \ub530\ub77c\uc11c \uc7ac\uace0\ub97c \uc27d\uac8c \ucd94\uc801\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub418\ub294 Excel \uc7ac\uace0 \uad00\ub9ac \ud15c\ud50c\ub9bf\uc744 \ucc3e\uace0 \uc788\ub2e4\uba74 \uc81c\ub300\ub85c \ucc3e\uc544\uc624\uc168\uc2b5\ub2c8\ub2e4. \uadc0\ud558\uc758 \uc7ac\uace0\ub97c \uc27d\uac8c \ucd94\uc801\ud560 \uc218 \uc788\ub294 \ub180\ub77c\uc6b4 \ud15c\ud50c\ub9bf\uc774 \uc5ec\uae30\uc5d0 \uc788\ub2e4\ub294 \uac83\uc744 \uc54c\ub824\ub4dc\ub9ac\uac8c \ub418\uc5b4 \uc601\uad11\uc785\ub2c8\ub2e4.<\/p><p> \uc774\uac83\uc740 \ub9ce\uc740 \uc2dc\uac04\uc744 \uc808\uc57d\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub418\ub294 \uc790\ub3d9\ud654\ub41c \ud15c\ud50c\ub9bf\uc785\ub2c8\ub2e4. \ubaa8\ub4e0 \uc218\uc2dd\uacfc \ub370\uc774\ud130\uc2dc\ud2b8\uac00 \uc774\ubbf8 \uc774\ub7ec\ud55c \ubc29\uc2dd\uc73c\ub85c \uad6c\uc131\ub418\uc5b4 \uc788\uc73c\ubbc0\ub85c \uc544\ubb34 \uc791\uc5c5\ub3c4 \uc218\ud589\ud560 \ud544\uc694\uac00 \uc5c6\uc2b5\ub2c8\ub2e4. \uac04\ub2e8\ud558\uace0 \ube60\ub974\uba70 \uc0ac\uc6a9\ud558\uae30 \uc26c\uc6b0\uba70 \uc5ec\ub7ec\ubd84\uc774 \uc88b\uc544\ud558\uc2e4 \uac83\uc774\ub77c\uace0 \ud655\uc2e0\ud569\ub2c8\ub2e4.<\/p><h2 id=\"0-dashboard\" class=\"wp-block-heading\"> \uacc4\uae30\ubc18<\/h2><p> \uc5ec\uae30\uc11c \ubaa8\ub4e0 \uc911\uc694\ud55c \uc815\ubcf4\ub294 \ud558\ub098\uc758 \uc2dc\ud2b8\uc5d0 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \uacc4\uc18d\ud574\uc11c \uc5c5\ub370\uc774\ud2b8\ud558\ub294 \uac83\uc5d0 \ub300\ud574 \uac71\uc815\ud560 \ud544\uc694\uac00 \uc5c6\uc2b5\ub2c8\ub2e4. <\/p><figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-de-gestion-des-stocks-excel-pret-a-lemploi-a-telecharger-gratuitement-avec-tableau-de-bord-pour-des-informations-1.png\" sizes=\"\" srcset=\"\" alt=\"\ud1b5\ucc30\ub825\uc744 \uc704\ud55c \ub300\uc2dc\ubcf4\ub4dc\uc640 \ud568\uaed8 \ubb34\ub8cc\ub85c \ub2e4\uc6b4\ub85c\ub4dc\ud560 \uc218 \uc788\ub294 \uc989\uc2dc \uc0ac\uc6a9 \uac00\ub2a5\ud55c Excel \uc7ac\uace0 \uad00\ub9ac \ud15c\ud50c\ub9bf\"><\/figure><p> \uc774 \uc815\ubcf4\ub294 \uc0c8 \ub370\uc774\ud130\ub97c \ucd94\uac00\ud560 \ub54c \uc2e4\uc2dc\uac04\uc73c\ub85c \uc5c5\ub370\uc774\ud2b8\ub429\ub2c8\ub2e4. \uc774 \ub300\uc2dc\ubcf4\ub4dc\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc911\uc694\ud55c \uc815\ubcf4\ub97c \ucd94\uc801\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4.<\/p><h3 id=\"1-current-stock\" class=\"wp-block-heading\"> \ud604\uc7ac \uc7ac\uace0<\/h3><p> \uc774 \uc218\uce58\ub294 \ub0a0\uc9dc \uae30\uc900 \ud604\uc7ac \uc7ac\uace0 \ub2e8\uc704\uc5d0 \ud574\ub2f9\ud569\ub2c8\ub2e4. \uc7ac\uace0\uac00 \uc788\uac70\ub098 \uc5c6\ub294 \uc7ac\uace0\uc5d0 \ub300\ud574 \uadc0\ud558\uac00 \uc785\ub825\ud55c \ubaa8\ub4e0 \uc815\ubcf4\uac00 \uc5c5\ub370\uc774\ud2b8\ub429\ub2c8\ub2e4. \uc785\uace0\ub41c \uc7ac\uace0\uc5d0\uc11c \uc7ac\uace0 \uc18c\uc9c4\uc744 \ucc28\uac10\ud558\uc5ec \uacc4\uc0b0\ud569\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/consultez-le-stock-actuel-a-partir-du-tableau-de-bord-dans-ce-modele-de-gestion-des-stocks-Excel-1.png\" sizes=\"\" srcset=\"\" alt=\"\uc774 \uc7ac\uace0 \uad00\ub9ac Excel \ud15c\ud50c\ub9bf\uc758 \ub300\uc2dc\ubcf4\ub4dc\uc5d0\uc11c \ud604\uc7ac \uc7ac\uace0\ub97c \ud655\uc778\ud558\uc138\uc694.\"><\/figure><\/div><h3 id=\"2-stock-value\" class=\"wp-block-heading\"> \uc8fc\uc2dd \uc2dc\uc7a5 \uac00\uce58<\/h3><p> \uc7ac\uace0\uae08\uc561\uc740 \ud604\uc7ac \uc7ac\uace0\uc5d0\uc11c \ud488\uc808\ub41c \uc7ac\uace0\ub97c \ucc28\uac10\ud55c \uae08\uc561\uc785\ub2c8\ub2e4. \uac01 \uc81c\ud488\uc758 \ub2e8\uac00\ub97c \uc774\uc6a9\ud558\uc5ec \uacc4\uc0b0\ub429\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/valeur-des-stocks-dans-le-modele-de-gestion-des-stocks-Excel-1-e1484286493428-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel \uc7ac\uace0 \uad00\ub9ac \ud15c\ud50c\ub9bf\uc758 \uc7ac\uace0 \uac00\uce58\"><\/figure><\/div><h3 id=\"3-stock-in\" class=\"wp-block-heading\"> \uc7ac\uace0<\/h3><p> \uc7ac\uace0\ub294 \uc774\ubc88 \ub2ec\uc758 \uc7ac\uace0 \ub370\uc774\ud130\uc5d0 \uc785\ub825\ud55c \ub2e8\uc704\uc785\ub2c8\ub2e4. Pro \ubc84\uc804\uc744 \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0 \ub4dc\ub86d\ub2e4\uc6b4 \ubaa9\ub85d\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc774\uc804 \ub2ec\uc758 \uc7ac\uace0 \uc218\ub7c9\uc744 \ud655\uc778\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/stocker-dans-le-modele-de-gestion-des-stocks-excel-1.png\" sizes=\"\" srcset=\"\" alt=\"\uc7ac\uace0 \uad00\ub9ac \ud15c\ud50c\ub9bf \uc5d1\uc140\uc5d0 \uc800\uc7a5\"><\/figure><\/div><h3 id=\"4-stock-in-return-pro\" class=\"wp-block-heading\"> \uc7ac\uace0 \ubc18\ud488 [\ud504\ub85c]<\/h3><p> \uc774 \uc139\uc158\uc5d0\ub294 \uadc0\ud558\uac00 \uacf5\uae09\uc5c5\uccb4\uc5d0 \ubc18\ud488\ud55c \uc7ac\uace0 \ub2e8\uc704\uac00 \ud45c\uc2dc\ub429\ub2c8\ub2e4. \ud504\ub85c \ubc84\uc804\uc5d0\uc11c\ub294 \uacf5\uae09\uc790\ubcc4\ub85c \ucd94\uc801\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/suivre-le-stock-dans-un-modele-de-gestion-des-stocks-Excel-pret-a-lemploi-1.png\" sizes=\"\" srcset=\"\" alt=\"\uc989\uc2dc \uc0ac\uc6a9 \uac00\ub2a5\ud55c Excel \uc7ac\uace0 \uad00\ub9ac \ud15c\ud50c\ub9bf\uc73c\ub85c \uc7ac\uace0\ub97c \ucd94\uc801\ud558\uc138\uc694.\"><\/figure><\/div><h3 id=\"5-stock-out\" class=\"wp-block-heading\"> \ud488\uc808<\/h3><p> \ud488\uc808\uc740 \uc774\ubc88 \ub2ec \ud488\uc808 \ub370\uc774\ud130\uc5d0 \uc785\ub825\ud55c \ub2e8\uc704\uc785\ub2c8\ub2e4. \ub4dc\ub86d\ub2e4\uc6b4 \uba54\ub274\ub97c \uc0ac\uc6a9\ud558\uba74 \ub2e4\ub978 \ub2ec\ub3c4 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/rupture-de-stock-dans-le-modele-de-gestion-des-stocks-excel-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel \uc7ac\uace0 \uad00\ub9ac \ud15c\ud50c\ub9bf\uc758 \uc7ac\uace0 \ubd80\uc871\"><\/figure><\/div><h3 id=\"6-stock-out-return-pro\" class=\"wp-block-heading\"> \ud488\uc808 \ubc18\ud488 [\ud504\ub85c]<\/h3><p> \uc774 \uc139\uc158\uc5d0\ub294 \uace0\uac1d\uc774 \ubc18\ud488\ud55c \ud488\uc808 \uc81c\ud488\uc774 \ud45c\uc2dc\ub429\ub2c8\ub2e4. \ud504\ub85c \ubc84\uc804\uc5d0\uc11c\ub294 \ud074\ub77c\uc774\uc5b8\ud2b8\ub97c \uae30\ubc18\uc73c\ub85c \ucd94\uc801\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/suivre-les-ruptures-de-stock-dans-le-modele-de-gestion-des-stocks-Excel-pret-a-lemploi-e1484308043169.png\" sizes=\"\" srcset=\"\" alt=\"\uc989\uc2dc \uc0ac\uc6a9 \uac00\ub2a5\ud55c Excel \uc7ac\uace0 \uad00\ub9ac \ud15c\ud50c\ub9bf\uc73c\ub85c \uc7ac\uace0 \ubd80\uc871\uc744 \ucd94\uc801\ud558\uc138\uc694.\"><\/figure><\/div><h3 id=\"7-category-wise-stock\" class=\"wp-block-heading\"> \uce74\ud14c\uace0\ub9ac \ud604\uba85\ud55c \uc8fc\uc2dd<\/h3><p> \ud604\uc7ac \uc7ac\uace0 \uac00\uce58\ub294 \uac01 \uc81c\ud488 \uce74\ud14c\uace0\ub9ac\uc5d0 \ub300\ud55c \uac83\uc785\ub2c8\ub2e4. \uc81c\ud488 \uc2dc\ud2b8\uc5d0\uc11c \uac01 \uc81c\ud488\uc758 \uce74\ud14c\uace0\ub9ac\ub97c \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/stock-actuel-par-categorie-dans-le-modele-de-gestion-des-stocks-excel-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel \uc7ac\uace0 \uad00\ub9ac \ud15c\ud50c\ub9bf\uc758 \uce74\ud14c\uace0\ub9ac\ubcc4 \ud604\uc7ac \uc7ac\uace0\"><\/figure><\/div><h3 id=\"8-product-wise-stock-and-reorder-level\" class=\"wp-block-heading\"> \ud604\uba85\ud55c \uc81c\ud488 \uc7ac\uace0 \ubc0f \uc7ac\uc8fc\ubb38 \uc218\uc900<\/h3><p> \ub300\uc2dc\ubcf4\ub4dc\uc758 \uc774 \ubd80\ubd84\uc5d0\ub294 \uc81c\ud488\uc758 \ud604\uc7ac \uc7ac\uace0\uc640 \uac00\uaca9\uc774 \ud45c\uc2dc\ub429\ub2c8\ub2e4. \ub610\ud55c \uc81c\ud488\uc758 \uc7ac\uc785\uace0 \uc218\uc900\ub3c4 \uc54c\ub824\uc90d\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \uc7ac\uace0 \uc218\uc900\uc774 \uc7ac\uc8fc\ubb38 \uc218\uc900\ubcf4\ub2e4 \ub0ae\uc744 \uacbd\uc6b0 \uacbd\uace0 \uba54\uc2dc\uc9c0\ub97c \ubc1b\uac8c \ub429\ub2c8\ub2e4. \ub2e4\uc591\ud55c \uc81c\ud488\uc744 \uc120\ud0dd\ud560 \uc218 \uc788\ub294 \ub4dc\ub86d\ub2e4\uc6b4 \ubaa9\ub85d\uc774 \uc788\uc2b5\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/etat-de-reapprovisionnement-au-niveau-du-produit-dans-le-modele-de-gestion-des-stocks-excel.png\" sizes=\"\" srcset=\"\" alt=\"Excel \uc7ac\uace0 \uad00\ub9ac \ud15c\ud50c\ub9bf\uc758 \uc81c\ud488 \uc218\uc900 \ubcf4\ucda9 \uc0c1\ud0dc\"><\/figure><\/div><h2 id=\"9-user-forms\" class=\"wp-block-heading\"> \uc0ac\uc6a9\uc790 \uc591\uc2dd<\/h2><p> \uc774\ub7ec\ud55c \uc0ac\uc6a9\uc790 \uc591\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \uc785\ub825\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ucd5c\uc18c\ud55c\uc758 \ub370\uc774\ud130\ub9cc \uc785\ub825\ud558\uba74 \ub418\ub3c4\ub85d \uc0ac\uc6a9\uc790 \uc591\uc2dd\uc744 \uc774\ub807\uac8c \uad00\ub9ac\ud588\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uc0ac\uc6a9\uc790 \uc591\uc2dd\uc73c\ub85c \ucea1\ucc98\ud560 \uc218 \uc788\ub294 \ub0b4\uc6a9\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p><h3 id=\"10-new-product\" class=\"wp-block-heading\"> \uc0c8\ub85c\uc6b4 \uc81c\ud488<\/h3><p> \uc774 \uc0ac\uc6a9\uc790 \uc591\uc2dd\uc744 \uc0ac\uc6a9\ud558\uba74 \uc0c8 \uc81c\ud488\uc744 \ub9cc\ub4e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uac00\uc7a5 \uc88b\uc740 \uc810\uc740 \ub9c8\uc2a4\ud130 \uc81c\ud488\uc758 \ub370\uc774\ud130\ub97c \uc0ac\uc6a9\ud558\uc5ec \ucd5c\uc18c\ud55c\uc758 \ub370\uc774\ud130\ub85c \ub2e4\ub978 \uc0ac\uc6a9\uc790 \uc591\uc2dd\uc744 \ucc44\uc6b4\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/entrer-un-nouveau-produit-dans-le-formulaire-utilisateur-dans-le-modele-de-gestion-des-stocks-Excel-1.png\" sizes=\"\" srcset=\"\" alt=\"\" width=\"-36\" height=\"-18\"><\/figure><\/div><h3 id=\"11-stock-in\" class=\"wp-block-heading\"> \uc7ac\uace0<\/h3><p> \uc0c8\ub85c\uc6b4 \uc8fc\uc2dd\uc774 \uc788\uc744 \ub54c\ub9c8\ub2e4 \uc774 \uc0ac\uc6a9\uc790 \uc591\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud574\ub2f9 \uc8fc\uc2dd\uc744 \uc785\ub825\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uc0ac\uc6a9\uc790 \uc591\uc2dd\uc5d0\uc11c\ub294 \uc81c\ud488 \uc774\ub984(\ub4dc\ub86d\ub2e4\uc6b4 \ubaa9\ub85d \uc0ac\uc6a9), \uacf5\uae09\uc5c5\uccb4 \uc774\ub984 \ubc0f \uc218\ub7c9\uc744 \uc785\ub825\ud558\uae30\ub9cc \ud558\uba74 \ub429\ub2c8\ub2e4. \uc81c\ud488 \uc2dc\ud2b8\uc5d0\uc11c \ub098\uba38\uc9c0 \ub370\uc774\ud130\ub97c \uac00\uc838\uc635\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/entrer-le-stock-dans-le-modele-de-gestion-des-stocks-Excel.png\" sizes=\"\" srcset=\"\" alt=\"Excel \uc7ac\uace0 \uad00\ub9ac \ud15c\ud50c\ub9bf\uc5d0 \uc7ac\uace0 \uc785\ub825\" width=\"-15\" height=\"-9\"><\/figure><\/div><h3 id=\"12-stock-out\" class=\"wp-block-heading\"> \ud488\uc808<\/h3><p> \ud488\uc808 \ub370\uc774\ud130\ub97c \uc785\ub825\ud558\ub824\uba74 \uc774 \uc0ac\uc6a9\uc790 \uc591\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc138\uc694. \uc81c\ud488\uba85, \uace0\uac1d\uba85, \uc218\ub7c9\ub9cc \uc785\ub825\ud558\uc2dc\uba74 \ub429\ub2c8\ub2e4. \ub098\uba38\uc9c0 \ub370\uc774\ud130\ub294 \uc81c\ud488 \uc2dc\ud2b8\uc5d0\uc11c \ucea1\ucc98\ub429\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/saisir-la-rupture-de-stock-dans-le-modele-de-gestion-des-stocks-Excel.png\" sizes=\"\" srcset=\"\" alt=\"Excel \uc7ac\uace0 \uad00\ub9ac \ud15c\ud50c\ub9bf\uc5d0 \ud488\uc808 \uc785\ub825\"><\/figure><\/div><h2 id=\"14-data-sheets\" class=\"wp-block-heading\"> \ub370\uc774\ud130\uc2dc\ud2b8<\/h2><p> \uc0ac\uc6a9\uc790 \uc591\uc2dd\uc5d0\uc11c \ubaa8\ub4e0 \ub370\uc774\ud130\uac00 \ucea1\ucc98\ub418\ub294 \ub370\uc774\ud130\uc2dc\ud2b8\uc5d0 \uc561\uc138\uc2a4\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc0ac\uc6a9\uc790 \uc591\uc2dd\uc758 \uac01 \ud56d\ubaa9\uc5d0\ub294 \uc774\ub97c \ucc38\uc870\ud558\ub294 \ub370 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc77c\ub828 \ubc88\ud638\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p><h3 id=\"15-product-master\" class=\"wp-block-heading\"> \uc81c\ud488 \ub9c8\uc2a4\ud130<\/h3><p> \uc81c\ud488 \ub9c8\uc2a4\ud130\ub294 \uc774 \ud15c\ud50c\ub9bf\uc758 \uac00\uc7a5 \uc911\uc694\ud55c \uc2dc\ud2b8\uc785\ub2c8\ub2e4. \ubaa8\ub4e0 \uc81c\ud488\uc774 \uc5ec\uae30\uc5d0 \uc138\ubd80\uc815\ubcf4\uc640 \ud568\uaed8 \ub098\uc5f4\ub429\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/stock-dans-la-feuille-dans-le-modele-de-gestion-des-stocks-excel-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel \uc7ac\uace0 \uad00\ub9ac \ud15c\ud50c\ub9bf\uc758 \uc2dc\ud2b8 \uc7ac\uace0\"><\/figure><\/div><h3 id=\"16-stock-in-sheet\" class=\"wp-block-heading\"> \uc8fc\uc2dd \uc2dc\ud2b8<\/h3><p> \uc8fc\uc2dd \uc2dc\ud2b8\uc5d0\ub294 \ubaa8\ub4e0 \uc8fc\uc2dd \ub370\uc774\ud130\uac00 \ud3ec\ud568\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \uac01 \ud56d\ubaa9\uc740 \uace0\uc720\ud55c \uc77c\ub828 \ubc88\ud638\ub85c \ucea1\ucc98\ub418\uba70 \uc774 \uc77c\ub828 \ubc88\ud638\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud2b9\uc815 \ud56d\ubaa9\uc744 \ucc38\uc870\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \ud504\ub85c \ubc84\uc804\uc744 \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0 \uc7ac\uace0 \uc218\uc775\ub960\ub3c4 \uc774 \uc2dc\ud2b8\uc5d0 \ucea1\ucc98\ub429\ub2c8\ub2e4.<\/p><h3 id=\"17-stock-out-sheet\" class=\"wp-block-heading\"> \ud488\uc808 \uc2dc\ud2b8<\/h3><p> \ub9c8\ucc2c\uac00\uc9c0\ub85c \ud488\uc808 \uc2dc\ud2b8\uc5d0\ub294 \ud488\uc808 \ub370\uc774\ud130\uac00 \ubaa8\ub450 \ud3ec\ud568\ub429\ub2c8\ub2e4. \ud488\uc808 \uc0ac\uc6a9\uc790 \uc591\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc774 \uc2dc\ud2b8\uc5d0 \ub370\uc774\ud130\ub97c \uc785\ub825\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uc591\uc2dd\uc758 \ud56d\ubaa9\ub3c4 \uace0\uc720 \uc77c\ub828\ubc88\ud638\ub85c \ucea1\ucc98\ub429\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \ud504\ub85c \ubc84\uc804\uc744 \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0 \ud488\uc808 \ubc18\ud488\ub3c4 \uc774 \uc2dc\ud2b8\uc5d0 \ud45c\uc2dc\ub429\ub2c8\ub2e4.<\/p><h2 id=\"20-reports\" class=\"wp-block-heading\"> \ubcf4\uace0\uc11c<\/h2><p> \uc774 \ubaa8\ub378\uc5d0\uc11c\ub294 \ubaa8\ub4e0 \uc8fc\uc694 \uc815\ubcf4\uac00 \ub300\uc2dc\ubcf4\ub4dc\uc5d0 \ud45c\uc2dc\ub429\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \ub2e4\uc74c \ubcf4\uace0\uc11c\ub3c4 \ucd94\ucd9c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p><h3 id=\"21-stock-report\" class=\"wp-block-heading\"> \uc7ac\uace0 \ubcf4\uace0\uc11c<\/h3><p> \uc774 \uc7ac\uace0 \ubcf4\uace0\uc11c\ub294 \uc81c\ud488 \uc2dc\ud2b8\uc5d0\uc11c \uc0dd\uc131\ub429\ub2c8\ub2e4. \ud604\uc7ac \uc8fc\uc2dd\uc5d0 \ub300\ud55c \uc804\uccb4 \uc694\uc57d\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/rapport-de-stock-dans-le-modele-de-gestion-des-stocks-excel-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel \uc7ac\uace0 \uad00\ub9ac \ud15c\ud50c\ub9bf\uc758 \uc7ac\uace0 \ubcf4\uace0\uc11c\"><\/figure><\/div><h2 id=\"25-instructions\" class=\"wp-block-heading\"> \uc9c0\uce68<\/h2><p> \uc774 \ud15c\ud50c\ub9bf\uc740 \uc0ac\uc6a9\uc790 \uce5c\ud654\uc801\uc774\uace0 \uc0ac\uc6a9\ud558\uae30 \uc27d\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c\uc740 \uc774 \ud15c\ud50c\ub9bf\uc744 \ud6a8\uacfc\uc801\uc73c\ub85c \uc0ac\uc6a9\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub418\ub294 \uba87 \uac00\uc9c0 \uc9c0\uce68\uc785\ub2c8\ub2e4.<\/p><h3 id=\"26-menu-button\" class=\"wp-block-heading\"> \uba54\ub274 \ubc84\ud2bc<\/h3><p> \uc774 \ud15c\ud50c\ub9bf\uc5d0\ub294 \ubaa8\ub4e0 \uc635\uc158 \ubc84\ud2bc\uc774 \ud3ec\ud568\ub41c \ub3d9\uc801 \uba54\ub274 \ud45c\uc2dc\uc904\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uba54\ub274 \ubc84\ud2bc\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc5b8\uc81c\ub4e0\uc9c0 \ubd88\ub7ec\uc62c \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/bouton-de-menu-dans-le-modele-de-gestion-des-stocks-excel-1.png\" sizes=\"\" srcset=\"\" alt=\"\uc7ac\uace0 \uad00\ub9ac \uc5d1\uc140 \ud15c\ud50c\ub9bf\uc758 \uba54\ub274 \ubc84\ud2bc\"><\/figure><\/div><p> \uc774 \uba54\ub274 \ud45c\uc2dc\uc904\uc5d0\uc11c \ubaa8\ub4e0 \ub370\uc774\ud130\uc2dc\ud2b8\uc640 \uc0ac\uc6a9\uc790 \uc591\uc2dd\uc5d0 \uc561\uc138\uc2a4\ud558\uace0 \ubcf4\uace0\uc11c\ub97c \uc0dd\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub300\uc2dc\ubcf4\ub4dc\uc5d0 \uc561\uc138\uc2a4\ud558\ub824\uba74 \uba54\ub274 \ud45c\uc2dc\uc904 \uc0c1\ub2e8\uc5d0 \uc788\ub294 \ub4a4\ub85c \ubc84\ud2bc\uc744 \uc0ac\uc6a9\ud558\uc138\uc694. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/bouton-de-fermeture-de-menu-pour-le-modele-de-gestion-des-stocks-excel-1.png\" sizes=\"\" srcset=\"\" alt=\"\uc7ac\uace0 \uad00\ub9ac \uc5d1\uc140 \ud15c\ud50c\ub9bf\uc758 \uba54\ub274 \ub2eb\uae30 \ubc84\ud2bc\"><\/figure><\/div><h3 id=\"27-entering-data\" class=\"wp-block-heading\"> \ub370\uc774\ud130 \uc785\ub825<\/h3><p> \uc55e\uc11c \uc5b8\uae09\ud588\ub4ef\uc774 \ub370\uc774\ud130\ub97c \ucea1\ucc98\ud558\ub294 \uc0ac\uc6a9\uc790 \uc591\uc2dd\uc774 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c \uac01 \uc0ac\uc6a9\uc790 \uc591\uc2dd\uc758 \ub370\uc774\ud130\ub294 \ubcc4\ub3c4\uc758 \ub370\uc774\ud130 \uc2dc\ud2b8\uc5d0 \uc785\ub825\ub429\ub2c8\ub2e4. \uc0ac\uc6a9\uc790 \uc591\uc2dd\uc5d0 \ub370\uc774\ud130\ub97c \uc785\ub825\ud55c \ud6c4 Enter \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uc5ec \ud56d\ubaa9\uc744 \uc800\uc7a5\ud569\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/entrer-le-bouton-dans-le-modele-de-gestion-des-stocks-excel-dans-excel-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel\uc758 \uc7ac\uace0 \uad00\ub9ac \ud15c\ud50c\ub9bf\uc5d0 \ubc84\ud2bc \uc785\ub825\"><\/figure><\/div><h2 id=\"28-dont\" class=\"wp-block-heading\"> \ud558\uc9c0 \ub9c8\uc138\uc694<\/h2><ul><li> <strong><mark class=\"has-inline-color\" style=\"background-color: #ff5757; color: #ffffff;\">\uc6cc\ud06c\uc2dc\ud2b8\uc758 \uc774\ub984\uc744 \ubcc0\uacbd\ud569\ub2c8\ub2e4.<\/mark><\/strong><\/li><li> <strong><mark class=\"has-inline-color has-base-3-color\" style=\"background-color: #ff5757;\">\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\ub97c \uc0ad\uc81c\ud558\uc138\uc694.<\/mark><\/strong><\/li><li> <strong><mark class=\"has-inline-color has-base-3-color\" style=\"background-color: #ff5757;\">\uc0ac\uc6a9\uc790 \uc591\uc2dd\uc5d0\uc11c \uc140, \ud589 \ub610\ub294 \uc5f4\uc744 \ucd94\uac00\ud558\uac70\ub098 \uc81c\uac70\ud569\ub2c8\ub2e4.<\/mark><\/strong><\/li><\/ul><h2 id=\"29-things-you-can-try\" class=\"wp-block-heading\"> \uc2dc\ub3c4\ud574 \ubcfc \uc218 \uc788\ub294 \uac83\ub4e4<\/h2><ul><li> \uae30\uc220 \uc2dc\ud2b8\uc5d0\uc11c \ud53c\ubc97 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4(\ud504\ub85c \ubc84\uc804\uc5d0\uc11c \uc0ac\uc6a9 \uac00\ub2a5).<\/li><li> \ub300\uc2dc\ubcf4\ub4dc\ub97c \uc778\uc1c4\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li><li> \uc774 \ud15c\ud50c\ub9bf\uc744 \uc0ac\uc6a9\ud558\uae30 \uc804\uc5d0 \ub9e4\ud06c\ub85c\ub97c \ud65c\uc131\ud654\ud574\uc57c \ud569\ub2c8\ub2e4.<\/li><\/ul><h2 id=\"30-download-your-template\" class=\"wp-block-heading\"> \ubaa8\ub378 \ub2e4\uc6b4\ub85c\ub4dc<\/h2><ul><li> &gt; <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/modele-de-gestion-des-inventaires-Excel.zip\">\uc5ec\uae30\uc5d0\uc11c \ub2e4\uc6b4\ub85c\ub4dc\ud558\uc138\uc694<\/a><\/li><\/ul>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-16","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 \uc5d1\uc140 \uc7ac\uace0\uad00\ub9ac \ud15c\ud50c\ub9bf (100% \ubb34\ub8cc)<\/title>\n<meta name=\"description\" content=\"\uc7ac\uace0\ub97c \uc27d\uac8c \ucd94\uc801\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub418\ub294 \uc7ac\uace0 \uad00\ub9ac Excel \ud15c\ud50c\ub9bf\uc744 \ucc3e\uace0 \uc788\ub2e4\uba74 \uc62c\ubc14\ub978 \uc704\uce58\uc5d0 \uc624\uc168\uc2b5\ub2c8\ub2e4.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/ko\/\uc7ac\uace0-\uad00\ub9ac-\ud15c\ud50c\ub9bf-excel-vba-\uc0ac\uc6a9\uc790-\uc591\uc2dd\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 \uc5d1\uc140 \uc7ac\uace0\uad00\ub9ac \ud15c\ud50c\ub9bf (100% \ubb34\ub8cc)\" \/>\n<meta property=\"og:description\" content=\"\uc7ac\uace0\ub97c \uc27d\uac8c \ucd94\uc801\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub418\ub294 \uc7ac\uace0 \uad00\ub9ac Excel \ud15c\ud50c\ub9bf\uc744 \ucc3e\uace0 \uc788\ub2e4\uba74 \uc62c\ubc14\ub978 \uc704\uce58\uc5d0 \uc624\uc168\uc2b5\ub2c8\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/ko\/\uc7ac\uace0-\uad00\ub9ac-\ud15c\ud50c\ub9bf-excel-vba-\uc0ac\uc6a9\uc790-\uc591\uc2dd\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-11T07:00:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-de-gestion-des-stocks-excel-pret-a-lemploi-a-telecharger-gratuitement-avec-tableau-de-bord-pour-des-informations-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/%ec%9e%ac%ea%b3%a0-%ea%b4%80%eb%a6%ac-%ed%85%9c%ed%94%8c%eb%a6%bf-excel-vba-%ec%82%ac%ec%9a%a9%ec%9e%90-%ec%96%91%ec%8b%9d\/\",\"url\":\"https:\/\/exceladvisor.org\/ko\/%ec%9e%ac%ea%b3%a0-%ea%b4%80%eb%a6%ac-%ed%85%9c%ed%94%8c%eb%a6%bf-excel-vba-%ec%82%ac%ec%9a%a9%ec%9e%90-%ec%96%91%ec%8b%9d\/\",\"name\":\"\u25b7 \uc5d1\uc140 \uc7ac\uace0\uad00\ub9ac \ud15c\ud50c\ub9bf (100% \ubb34\ub8cc)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/%ec%9e%ac%ea%b3%a0-%ea%b4%80%eb%a6%ac-%ed%85%9c%ed%94%8c%eb%a6%bf-excel-vba-%ec%82%ac%ec%9a%a9%ec%9e%90-%ec%96%91%ec%8b%9d\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/%ec%9e%ac%ea%b3%a0-%ea%b4%80%eb%a6%ac-%ed%85%9c%ed%94%8c%eb%a6%bf-excel-vba-%ec%82%ac%ec%9a%a9%ec%9e%90-%ec%96%91%ec%8b%9d\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-de-gestion-des-stocks-excel-pret-a-lemploi-a-telecharger-gratuitement-avec-tableau-de-bord-pour-des-informations-1.png\",\"datePublished\":\"2023-11-22T02:18:52+00:00\",\"dateModified\":\"2023-12-11T07:00:05+00:00\",\"description\":\"\uc7ac\uace0\ub97c \uc27d\uac8c \ucd94\uc801\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub418\ub294 \uc7ac\uace0 \uad00\ub9ac Excel \ud15c\ud50c\ub9bf\uc744 \ucc3e\uace0 \uc788\ub2e4\uba74 \uc62c\ubc14\ub978 \uc704\uce58\uc5d0 \uc624\uc168\uc2b5\ub2c8\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/%ec%9e%ac%ea%b3%a0-%ea%b4%80%eb%a6%ac-%ed%85%9c%ed%94%8c%eb%a6%bf-excel-vba-%ec%82%ac%ec%9a%a9%ec%9e%90-%ec%96%91%ec%8b%9d\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/ko\/%ec%9e%ac%ea%b3%a0-%ea%b4%80%eb%a6%ac-%ed%85%9c%ed%94%8c%eb%a6%bf-excel-vba-%ec%82%ac%ec%9a%a9%ec%9e%90-%ec%96%91%ec%8b%9d\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/%ec%9e%ac%ea%b3%a0-%ea%b4%80%eb%a6%ac-%ed%85%9c%ed%94%8c%eb%a6%bf-excel-vba-%ec%82%ac%ec%9a%a9%ec%9e%90-%ec%96%91%ec%8b%9d\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-de-gestion-des-stocks-excel-pret-a-lemploi-a-telecharger-gratuitement-avec-tableau-de-bord-pour-des-informations-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-de-gestion-des-stocks-excel-pret-a-lemploi-a-telecharger-gratuitement-avec-tableau-de-bord-pour-des-informations-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/%ec%9e%ac%ea%b3%a0-%ea%b4%80%eb%a6%ac-%ed%85%9c%ed%94%8c%eb%a6%bf-excel-vba-%ec%82%ac%ec%9a%a9%ec%9e%90-%ec%96%91%ec%8b%9d\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\uc9d1\",\"item\":\"https:\/\/exceladvisor.org\/ko\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel \uc7ac\uace0 \uad00\ub9ac \ud15c\ud50c\ub9bf\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/#website\",\"url\":\"https:\/\/exceladvisor.org\/ko\/\",\"name\":\"Excel Advisor\",\"description\":\"\ub370\uc774\ud130 \uc9c0\ubc30\ub825\uc744 \uc704\ud55c \uac00\uc774\ub4dc!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/ko\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/ko\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/ko\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/ko\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 \uc5d1\uc140 \uc7ac\uace0\uad00\ub9ac \ud15c\ud50c\ub9bf (100% \ubb34\ub8cc)","description":"\uc7ac\uace0\ub97c \uc27d\uac8c \ucd94\uc801\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub418\ub294 \uc7ac\uace0 \uad00\ub9ac Excel \ud15c\ud50c\ub9bf\uc744 \ucc3e\uace0 \uc788\ub2e4\uba74 \uc62c\ubc14\ub978 \uc704\uce58\uc5d0 \uc624\uc168\uc2b5\ub2c8\ub2e4.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/ko\/\uc7ac\uace0-\uad00\ub9ac-\ud15c\ud50c\ub9bf-excel-vba-\uc0ac\uc6a9\uc790-\uc591\uc2dd\/","og_locale":"ko_KR","og_type":"article","og_title":"\u25b7 \uc5d1\uc140 \uc7ac\uace0\uad00\ub9ac \ud15c\ud50c\ub9bf (100% \ubb34\ub8cc)","og_description":"\uc7ac\uace0\ub97c \uc27d\uac8c \ucd94\uc801\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub418\ub294 \uc7ac\uace0 \uad00\ub9ac Excel \ud15c\ud50c\ub9bf\uc744 \ucc3e\uace0 \uc788\ub2e4\uba74 \uc62c\ubc14\ub978 \uc704\uce58\uc5d0 \uc624\uc168\uc2b5\ub2c8\ub2e4.","og_url":"https:\/\/exceladvisor.org\/ko\/\uc7ac\uace0-\uad00\ub9ac-\ud15c\ud50c\ub9bf-excel-vba-\uc0ac\uc6a9\uc790-\uc591\uc2dd\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-11T07:00:05+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-de-gestion-des-stocks-excel-pret-a-lemploi-a-telecharger-gratuitement-avec-tableau-de-bord-pour-des-informations-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/ko\/%ec%9e%ac%ea%b3%a0-%ea%b4%80%eb%a6%ac-%ed%85%9c%ed%94%8c%eb%a6%bf-excel-vba-%ec%82%ac%ec%9a%a9%ec%9e%90-%ec%96%91%ec%8b%9d\/","url":"https:\/\/exceladvisor.org\/ko\/%ec%9e%ac%ea%b3%a0-%ea%b4%80%eb%a6%ac-%ed%85%9c%ed%94%8c%eb%a6%bf-excel-vba-%ec%82%ac%ec%9a%a9%ec%9e%90-%ec%96%91%ec%8b%9d\/","name":"\u25b7 \uc5d1\uc140 \uc7ac\uace0\uad00\ub9ac \ud15c\ud50c\ub9bf (100% \ubb34\ub8cc)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/ko\/%ec%9e%ac%ea%b3%a0-%ea%b4%80%eb%a6%ac-%ed%85%9c%ed%94%8c%eb%a6%bf-excel-vba-%ec%82%ac%ec%9a%a9%ec%9e%90-%ec%96%91%ec%8b%9d\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/ko\/%ec%9e%ac%ea%b3%a0-%ea%b4%80%eb%a6%ac-%ed%85%9c%ed%94%8c%eb%a6%bf-excel-vba-%ec%82%ac%ec%9a%a9%ec%9e%90-%ec%96%91%ec%8b%9d\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-de-gestion-des-stocks-excel-pret-a-lemploi-a-telecharger-gratuitement-avec-tableau-de-bord-pour-des-informations-1.png","datePublished":"2023-11-22T02:18:52+00:00","dateModified":"2023-12-11T07:00:05+00:00","description":"\uc7ac\uace0\ub97c \uc27d\uac8c \ucd94\uc801\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub418\ub294 \uc7ac\uace0 \uad00\ub9ac Excel \ud15c\ud50c\ub9bf\uc744 \ucc3e\uace0 \uc788\ub2e4\uba74 \uc62c\ubc14\ub978 \uc704\uce58\uc5d0 \uc624\uc168\uc2b5\ub2c8\ub2e4.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/ko\/%ec%9e%ac%ea%b3%a0-%ea%b4%80%eb%a6%ac-%ed%85%9c%ed%94%8c%eb%a6%bf-excel-vba-%ec%82%ac%ec%9a%a9%ec%9e%90-%ec%96%91%ec%8b%9d\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/ko\/%ec%9e%ac%ea%b3%a0-%ea%b4%80%eb%a6%ac-%ed%85%9c%ed%94%8c%eb%a6%bf-excel-vba-%ec%82%ac%ec%9a%a9%ec%9e%90-%ec%96%91%ec%8b%9d\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/exceladvisor.org\/ko\/%ec%9e%ac%ea%b3%a0-%ea%b4%80%eb%a6%ac-%ed%85%9c%ed%94%8c%eb%a6%bf-excel-vba-%ec%82%ac%ec%9a%a9%ec%9e%90-%ec%96%91%ec%8b%9d\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-de-gestion-des-stocks-excel-pret-a-lemploi-a-telecharger-gratuitement-avec-tableau-de-bord-pour-des-informations-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-de-gestion-des-stocks-excel-pret-a-lemploi-a-telecharger-gratuitement-avec-tableau-de-bord-pour-des-informations-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/ko\/%ec%9e%ac%ea%b3%a0-%ea%b4%80%eb%a6%ac-%ed%85%9c%ed%94%8c%eb%a6%bf-excel-vba-%ec%82%ac%ec%9a%a9%ec%9e%90-%ec%96%91%ec%8b%9d\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\uc9d1","item":"https:\/\/exceladvisor.org\/ko\/"},{"@type":"ListItem","position":2,"name":"Excel \uc7ac\uace0 \uad00\ub9ac \ud15c\ud50c\ub9bf"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/ko\/#website","url":"https:\/\/exceladvisor.org\/ko\/","name":"Excel Advisor","description":"\ub370\uc774\ud130 \uc9c0\ubc30\ub825\uc744 \uc704\ud55c \uac00\uc774\ub4dc!","publisher":{"@id":"https:\/\/exceladvisor.org\/ko\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/ko\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/ko\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/ko\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/exceladvisor.org\/ko\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/ko\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/ko\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/ko\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/pages\/16","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/comments?post=16"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/pages\/16\/revisions"}],"predecessor-version":[{"id":810,"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/pages\/16\/revisions\/810"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/media?parent=16"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}