{"id":3474,"date":"2020-01-15T15:00:33","date_gmt":"2020-01-15T06:00:33","guid":{"rendered":"http:\/\/juno-e.com\/excel-free\/?page_id=3474"},"modified":"2020-01-18T10:47:09","modified_gmt":"2020-01-18T01:47:09","slug":"%e3%82%a8%e3%82%af%e3%82%bb%e3%83%ab%e7%99%ba%e6%b3%a8%e6%9b%b8%e3%83%86%e3%83%b3%e3%83%97%e3%83%ac%e3%83%bc%e3%83%88%e3%81%ae%e7%84%a1%e6%96%99%e3%83%80%e3%82%a6%e3%83%b3%e3%83%ad%e3%83%bc%e3%83%89","status":"publish","type":"page","link":"https:\/\/juno-e.com\/excel-free\/?page_id=3474","title":{"rendered":"\u30a8\u30af\u30bb\u30eb\u767a\u6ce8\u66f8\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u306e\u7121\u6599\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/juno-e.com\/excel-free\/wp-content\/uploads\/2020\/01\/excel-hattcyusyo.jpg\" alt=\"\u30a8\u30af\u30bb\u30eb\u306e\u767a\u6ce8\u66f8\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\" width=\"686\" height=\"434\" class=\"alignnone size-full wp-image-3475\" \/><\/p>\n<p>\u5546\u54c1\u306e\u767a\u6ce8\u3092\u4f9d\u983c\u3059\u308b\u969b\u306b\u5229\u7528\u3059\u308b<br \/>\n\u767a\u6ce8\u66f8\u3092\u30de\u30a4\u30af\u30ed\u30bd\u30d5\u30c8\u306e\u30a8\u30af\u30bb\u30eb\u3067\u4f5c\u308a\u307e\u3057\u305f\u3002<\/p>\n<p>\u7121\u6599\u3067\u4f7f\u3048\u308b\u30a8\u30af\u30bb\u30eb\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3067\u3059\u3002<\/p>\n<p>\u3053\u306e\u767a\u6ce8\u66f8\u306f<br \/>\n\u76f8\u624b\u65b9\u306e\u4f1a\u793e\u540d\u3068<br \/>\n\u6d88\u8cbb\u7a0e\u3092\u542b\u3081\u305f\u5408\u8a08\u91d1\u984d\u3092<br \/>\n\u4e0a\u90e8\u306b\u8868\u793a\u3059\u308b\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>\u305d\u306e\u4ed6<\/p>\n<p>\u30fb\u4ef6\u540d\u30fb\u7d0d\u671f\u30fb\u652f\u6255\u3044\u65b9\u6cd5\u30fb\u304a\u5c4a\u3051\u5148\u306e\u8a18\u8f09\u6b04<\/p>\n<p>\u53f3\u7aef\u306b\u306f<br \/>\n\u30fb\u767a\u6ce8\u65e5\u30fb\u767a\u6ce8\u756a\u53f7<br \/>\n\u30fb\u90f5\u4fbf\u756a\u53f7\u30fb\u4f4f\u6240<br \/>\n\u30fb\u4f1a\u793e\u540d\u30fb\u96fb\u8a71\u756a\u53f7\u30fbFAX\u756a\u53f7\u30fb\u62c5\u5f53\u8005\u540d<br \/>\n\u3000\u306a\u3069\u8a18\u8f09\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>\u9805\u76ee\u306f<br \/>\n\u30fb\u5546\u54c1\u756a\u53f7\u30fb\u5546\u54c1\u540d\u30fb\u5358\u4fa1\u30fb\u91d1\u984d\u3067\u3059\u3002<\/p>\n<p>\u4e0b\u90e8\u306b\u306f<br \/>\n\u30fb\u5c0f\u8a08\u30fb\u6d88\u8cbb\u7a0e\u30fb\u5408\u8a08\u91d1\u984d\u3092\u8868\u793a\u3057\u307e\u3059\u3002<\/p>\n<p>\u5c0f\u8a08\u306fF45\u306e\u30bb\u30eb\u306b<br \/>\nSUM\u95a2\u6570\u3067\u8868\u793a\u3059\u308b\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<br \/>\n\u300c=SUM(F14:F44)\u300d<\/p>\n<p>\u6d88\u8cbb\u7a0e\u306f\u5c0f\u8a08\u306b\u5bfe\u3057\u306610%\u306e\u52a0\u7b97\u306b\u8a2d\u5b9a\u3057\u3066\u3044\u307e\u3059\u3002<br \/>\n\u300cF45*0.1\u300d\u306e\u5f0f\u3067\u3059\u3002<br \/>\n8%\u306b\u3059\u308b\u306a\u3089\u300cF45*0.08\u300d\u306b\u5909\u3048\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u5408\u8a08\u3082SUM\u95a2\u6570\u3067\u5c0f\u8a08+\u6d88\u8cbb\u7a0e<br \/>\n\u300c=SUM(F45:F46)<\/p>\n<p>\u5404\u5546\u54c1\u3054\u3068\u306e\u91d1\u984d\u306fF\u306e\u5217\u306b\u5358\u4fa1\u00d7\u6570\u91cf\u3067<br \/>\n14\u884c\u306b\u306f\u300cD14*E14\u300d\u306e\u5f0f\u3092\u5165\u308c\u3066\u307e\u3059\u3002<br \/>\n14\u884c\uff5e44\u884c\u307e\u3067\u5f0f\u304c\u5165\u3063\u3066\u3044\u308b\u306e\u3067<br \/>\n\u9593\u9055\u3048\u3066\u6d88\u3055\u306a\u3044\u3088\u3046\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u5f0f\u306f<br \/>\n\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<\/p>\n<p><a href=\".\/dun\/excel-hattcyusyo.zip\">\u30a8\u30af\u30bb\u30eb\u767a\u6ce8\u66f8\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u306e\u7121\u6599\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u306f\u3053\u3061\u3089<\/a><\/p>\n<p>\u30a8\u30af\u30bb\u30eb2016(Office365)\u3067\u4f5c\u6210\u3057\u3066\u3044\u307e\u3059\u3002<br \/>\n\u305d\u306e\u305f\u3081<br \/>\n\u3053\u308c\u3067\u4fdd\u5b58\u3057\u305f.xlsx\u306e\u30d5\u30a1\u30a4\u30eb\u3068<br \/>\n\u65e7\u30a8\u30af\u30bb\u30eb\u3067\u958b\u3051\u308b\u3088\u3046\u306b.xls\u30d5\u30a1\u30a4\u30eb\u3092<br \/>\nzip\u30d5\u30a1\u30a4\u30eb\u5727\u7e2e\u3057\u3066\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>\u6700\u65b0\u306e\u30a6\u30a3\u30f3\u30c9\u30a6\u30ba\u3067\u3042\u308c\u3070\u53f3\u30af\u30ea\u30c3\u30af\u30e1\u30cb\u30e5\u30fc\u306e<br \/>\n\u5c55\u958b\u3060\u3051\u3067\u89e3\u51cd\u3067\u304d\u307e\u3059\u3002<br \/>\nxls\u30d5\u30a1\u30a4\u30eb\u306b\u3064\u3044\u3066\u306f\u65e7\u30d0\u30fc\u30b8\u30e7\u30f3\u306e\u30a8\u30af\u30bb\u30eb\u3067\u306e<br \/>\n\u78ba\u8a8d\u306f\u3067\u304d\u3066\u3044\u307e\u305b\u3093\u3002<br \/>\n\u95a2\u6570\u3060\u3051\u3067<br \/>\nVBA\u306a\u3069\u306f\u4f7f\u3063\u3066\u306a\u3044\u306e\u3067\u5927\u4e08\u592b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<hr>\n<p>\u30fb<a href=\"?page_id=3466\">\u70b9\u691c\u30c1\u30a7\u30c3\u30af\u30ea\u30b9\u30c8\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8<\/a><\/p>\n<p>\u30fb<a href=\"?page_id=3442\">\u9818\u53ce\u66f8\u30b7\u30f3\u30d7\u30eb\u7248\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8<\/a><\/p>\n<p>\u30fb<a href=\"?page_id=3401\">\u5de5\u7a0b\u8868(\u81ea\u52d5\u30d0\u30fc\u8868\u793a)\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8<\/a> <\/p>\n<p>\u30fb<a href=\"?page_id=3167\">\u5e74\u9593\u30ab\u30ec\u30f3\u30c0\u30fc\u81ea\u52d5\u4f5c\u6210\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8<\/a> <\/p>\n<p>\u30fb<a href=\"?page_id=3391\">2020\u5e74\u306e\u30ab\u30ec\u30f3\u30c0\u30fc(\u884c\u4e8b\u5165\u529b\u7528)\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8<\/a> <\/p>\n<p>\u30fb<a href=\"?page_id=3354\">\u51fa\u52e4\u7ba1\u7406\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8<\/a> <\/p>\n<p>\u30fb<a href=\"?page_id=3179\">\u751f\u7523\u30b9\u30d4\u30fc\u30c9\u306e\u8a08\u7b97\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8<\/a> <\/p>\n<p>\u30fb<a href=\"?page_id=514\">2D\u30af\u30fc\u30eb\u306a\u30ab\u30ec\u30f3\u30c0\u30fc \u30c6\u30f3\u30d7\u30ec\u30fc\u30c8<\/a> <\/p>\n<p>\u30fb<a href=\"?page_id=511\">3D\u304a\u3057\u3083\u308c\u30ab\u30ec\u30f3\u30c0\u30fc \u30c6\u30f3\u30d7\u30ec\u30fc\u30c8<\/a><\/p>\n<p>\u30fb<a href=\"?page_id=524\">FAX\u9001\u4ed8\u72b6 \u30c6\u30f3\u30d7\u30ec\u30fc\u30c8<\/a><\/p>\n<p>\u30fb<a href=\"?page_id=596\">\u5c65\u6b74\u66f8 \u30c6\u30f3\u30d7\u30ec\u30fc\u30c8<\/a><\/p>\n<p>\u30fb<a href=\"?page_id=530\">\u652f\u6255\u8abf\u66f8 \u30c6\u30f3\u30d7\u30ec\u30fc\u30c8<\/a><\/p>\n<p>\u30fb<a href=\"?page_id=520\">\u6708\u9593\u30ab\u30ec\u30f3\u30c0\u30fc \u30c6\u30f3\u30d7\u30ec\u30fc\u30c8<\/a><\/p>\n<p>\u30fb<a href=\"?page_id=527\">\u30e9\u30d9\u30eb\u5370\u5237\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8<\/a><\/p>\n<p>\u30fb<a href=\"?page_id=505\">\u4f1d\u8a00\u30e1\u30e2\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8<\/a><\/p>\n<p>\u30fb<a href=\"?page_id=508\">\u4fbf\u7b8b\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8<\/a><\/p>\n<p>\u30fb<a href=\"?page_id=501\">\u539f\u7a3f\u7528\u7d19\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8<\/a><\/p>\n<p>\u30fb<a href=\"?page_id=517\">\u5c01\u7b52\u5370\u5237\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8<\/a><\/p>\n<p>\u30fb<a href=\"?page_id=498\">\u65b9\u773c\u7d19\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5546\u54c1\u306e\u767a\u6ce8\u3092\u4f9d\u983c\u3059\u308b\u969b\u306b\u5229\u7528\u3059\u308b \u767a\u6ce8\u66f8\u3092\u30de\u30a4\u30af\u30ed [&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":3475,"parent":0,"menu_order":117,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[3,11],"class_list":["post-3474","page","type-page","status-publish","has-post-thumbnail","hentry","category-3","category-11"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/juno-e.com\/excel-free\/index.php?rest_route=\/wp\/v2\/pages\/3474"}],"collection":[{"href":"https:\/\/juno-e.com\/excel-free\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/juno-e.com\/excel-free\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/juno-e.com\/excel-free\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/juno-e.com\/excel-free\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3474"}],"version-history":[{"count":2,"href":"https:\/\/juno-e.com\/excel-free\/index.php?rest_route=\/wp\/v2\/pages\/3474\/revisions"}],"predecessor-version":[{"id":3492,"href":"https:\/\/juno-e.com\/excel-free\/index.php?rest_route=\/wp\/v2\/pages\/3474\/revisions\/3492"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/juno-e.com\/excel-free\/index.php?rest_route=\/wp\/v2\/media\/3475"}],"wp:attachment":[{"href":"https:\/\/juno-e.com\/excel-free\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3474"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/juno-e.com\/excel-free\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3474"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}