{"id":283,"date":"2012-07-10T15:21:30","date_gmt":"2012-07-10T06:21:30","guid":{"rendered":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/?p=283"},"modified":"2026-03-12T14:54:09","modified_gmt":"2026-03-12T05:54:09","slug":"post-207","status":"publish","type":"post","link":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/2012\/07\/post-207.html","title":{"rendered":"\uff08\uff12\uff11\uff11\uff09Excel\u3067\u6587\u66f8\u4f5c\u6210\uff01\u7b2c3\u56de\u3000\u5951\u7d04\u66f4\u65b0\u6848\u5185\u66f8\u7de8\u266a"},"content":{"rendered":"

\"newcom_cafecs4.jpg\"<\/p>\n

\u3053\u3093\u306b\u3061\u306f\uff01\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u753b\u50cf\uff1aHoshino.com<\/a><\/div>\n

\"ka_034.jpg\"<\/p>\n

\u30e2\u30ab\u3067\u3059\u3002<\/div>\n
<\/div>\n
\u6691\u3044\uff01\uff01\uff01\u306e\u3082\u4eca\u65e5\u307e\u3067\u3002<\/div>\n
\u660e\u65e5\u306f\u96e8\u306e\u4e88\u5831\u3067\u3059\u3002<\/div>\n
<\/div>\n
\u65e5\u5c04\u3057\u304c\u5f37\u3044\u306e\u3067\u9854\u304c\u30d2\u30ea\u30d2\u30ea\u3059\u308b\u3053\u306e\u9803\u3002<\/div>\n
\u65e5\u713c\u3051\u6b62\u3081\u3067\u30d0\u30c3\u30c1\u30ea\u3000\u30ab\u30d0\u30fc\u3057\u3066\u3044\u308b\u306e\u3067\u3059\u304c\u3001<\/div>\n
\u304a\u808c\u304c\u5f31\u3044\u306e\u304b\u3057\u3089\uff3e\uff3e\uff1b<\/div>\n
<\/div>\n
\u307f\u306a\u3055\u3093\u306f\u5927\u4e08\u592b\u3067\u3059\u304b\uff1f<\/div>\n
\u3059\u3066\u304d\u306a\u6edd\u306e\u753b\u50cf\u3067\u3001\u3061\u3087\u3063\u3068\u6dbc\u3057\u304f\u306a\u308a\u307e\u3057\u305f\u304b\uff1f<\/div>\n
<\/div>\n
\u68ee\u306b\u884c\u304d\u305f\u3044\u306a\u3041\uff5e\uff5e\uff5e\uff3e\uff3e<\/div>\n
<\/div>\n
<\/div>\n
\u2605\u2605\u2605\u2605\u2605\u2605\u2605\u30ce\u30ce\u30ce<\/div>\n
\u3055\u3066\u3001Exce\uff4c\u306e\u304a\u8a71\u3002<\/div>\n
<\/div>\n

\u6587\u66f8\u3092Excel\u3067\u4f5c\u308d\u3046\uff01\u7b2c3\u56de\u3000\u5951\u7d04\u66f4\u65b0\u6848\u5185\u66f8\u7de8\u266a<\/span><\/h2>\n
<\/div>\n
\u4eca\u56de\u306f\u3001\u5951\u7d04\u3092\u66f4\u65b0\u3059\u308b\u3068\u304d\u306e\u6848\u5185\u66f8\u3092\u30a8\u30af\u30bb\u30eb\u3067\u4f5c\u3063\u305f\u5834\u5408\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/div>\n
\u968f\u6240\u3067\u30a8\u30af\u30bb\u30eb\u306f\u30d1\u30ef\u30fc\u3092\u767a\u63ee\u3057\u3066\u304f\u308c\u3066\u3044\u307e\u3059\u3002<\/div>\n
<\/div>\n
\u4e0b\u56f3\u306e\u69d8\u306a\u300c\u30b5\u30dd\u30fc\u30c8\u5951\u7d04\u66f4\u65b0\u306e\u3054\u6848\u5185\u300d\u3002\u203b\u56f3\u3092\u30af\u30ea\u30c3\u30af\u3067\u62e1\u5927\u3057\u307e\u3059\u3002<\/div>\n
Excel\u306e\u67a0\u7dda\u3092\u6d88\u3057\u3066\u3042\u308b\u306e\u3067\u3001\u307e\u308b\u3067Word\u306e\u3088\u3046\uff3e\uff3e<\/div>\n
\"sapo1.JPG\"<\/a><\/span><\/div>\n
<\/div>\n
\u3053\u306e\u6587\u66f8\u306e\u4e2d\u3067\u95a2\u6570\u5f0f\u304c\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u308b\u306e\u304c\u3001\u8d64\u67a0\u306e\u30bb\u30eb\u3067\u3059\u3002<\/div>\n
\u4e00\u3064\u4e00\u3064\u3069\u3093\u306a\u95a2\u6570\u5f0f\u304b\u3054\u8aac\u660e\u3057\u3066\u3044\u304d\u307e\u3059\u306d\u3002\u203b\u56f3\u3092\u30af\u30ea\u30c3\u30af\u3067\u62e1\u5927\u3057\u307e\u3059\u3002<\/div>\n
\"sapo2.JPG\"<\/a><\/span><\/div>\n
<\/div>\n
\uff08\uff11\uff09\u4f1a\u793e\u540d\u306e\u30bb\u30eb\u306b\u30bb\u30c3\u30c8\u3055\u308c\u3066\u3044\u308b\u95a2\u6570\u5f0f\u306f<\/div>\n
\u300c\u3000=VLOOKUP($K$3,\u304a\u5ba2\u69d8\u30ea\u30b9\u30c8,2,FALSE)<\/b>\u3000<\/span>\u300d<\/div>\n
\u6848\u5185\u66f8\u306e\u96a3\u306b\u304a\u5ba2\u69d8\u30ea\u30b9\u30c8\u304c\u3042\u3063\u3066\u3001\u30bb\u30ebK\uff13<\/b>\u306b\u5165\u529b\u3057\u305f\u756a\u53f7\u306b\u8a72\u5f53\u3059\u308b\u300c\u4f1a\u793e\u540d\u300d\u304c\u81ea\u52d5\u7684\u306b\u8868\u793a\u3055\u308c\u308b\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/div>\n
\"sapo3.JPG\"<\/a><\/span><\/div>\n
<\/div>\n
\uff08\uff12\uff09\u3000\uff08\uff11\uff09\u306e\u4f1a\u793e\u540d\u3068\u540c\u69d8\u306b\u90e8\u7f72\u540d\u3001\u62c5\u5f53\u8005\u540d\u3082\u56f3\u306e\u69d8\u306b\u3001\u95a2\u6570\u5f0f\u3092\u8a2d\u5b9a\u3057\u3001<\/div>\n
\u30bb\u30ebK3\u306b\u5165\u3063\u305f\u756a\u53f7\u306b\u5fdc\u3058\u3066\u53f3\u306e\u30ea\u30b9\u30c8\u304b\u3089\u53c2\u7167\u3001\u8868\u793a\u3057\u3066\u3044\u307e\u3059\u3002<\/div>\n
\"sapo5.JPG\"<\/a><\/span><\/div>\n
<\/div>\n
\uff08\uff13\uff09\u300c\u55b6\u696d\u62c5\u5f53\u300d\u3068\u6587\u7ae0\u4e2d\u306e\u300c\u30b5\u30dd\u30fc\u30c8\u671f\u9650\uff082012\u5e747\u6708\u672b\uff09\u300d\u300c\u66f4\u65b0\u3059\u308b\u30b5\u30dd\u30fc\u30c8\u671f\u9593\u300d\u3082\u95a2\u6570\u3067\uff01<\/div>\n
<\/div>\n
\u2460\u300c\u55b6\u696d\u62c5\u5f53\u300d<\/div>\n
\u300c\u3000=VLOOKUP($K$3,\u304a\u5ba2\u69d8\u30ea\u30b9\u30c8,5,FALSE)<\/b><\/span>\u3000<\/span>\u300d<\/div>\n
\u203b\u53f3\u8868\u304c\u300c\u304a\u5ba2\u69d8\u30ea\u30b9\u30c8\u300d\u540d\u524d\u3092\u5b9a\u7fa9<\/div>\n
\u53f3\u8868\u306e5\u5217\u76ee\uff08\u55b6\u696d\u62c5\u5f53\uff09\u3092\u53c2\u7167\u3057\u3066\u3044\u307e\u3059\u3002K3\u306b\u300c\uff11\u300d\u3068\u5165\u529b\u3055\u308c\u305f\u306e\u3067\u300c\uff11\u300d\u306e\u9867\u5ba2\u306e\u5de6\u304b\u30895\u5217\u76ee\u3092\u53c2\u7167\u3057\u3066\u3044\u307e\u3059\u3002<\/div>\n
\"sapo6.JPG\"<\/a><\/span><\/div>\n
<\/div>\n
\u2461\u300c\u30b5\u30dd\u30fc\u30c8\u671f\u9650\uff082012\u5e747\u6708\u672b\uff09\u300d<\/div>\n
a.\u300c\u3000=VLOOKUP($K$3,\u304a\u5ba2\u69d8\u30ea\u30b9\u30c8,6,FALSE)<\/b><\/span>\u3000<\/span>\u300d<\/div>\n
\u4e0a\u56f3\u306e\u53f3\u5074\u306e\u8868\u30016\u5217\u76ee\u3092\u53c2\u7167\u3002K3\u306b\u5165\u529b\u3055\u308c\u305f\u756a\u53f7\u306b\u5fdc\u3058\u3066\u8a72\u5f53\u3059\u308b\u30bb\u30eb\u3092\u53c2\u7167\u3057\u3066\u3044\u307e\u3059\u3002<\/div>\n
<\/div>\n
b.\u3055\u3089\u306b\u3001\u8868\u793a\u5f62\u5f0f\u3092\u300c7\u6708\u672b\u300d\u3068\u8868\u793a\u3059\u308b\u3088\u3046\u8a2d\u5b9a\u3057\u3001\u6587\u5b57\u306e\u8272\u3092\u8d64\u8272\u306b\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/div>\n
\u300c\u30db\u30fc\u30e0\u300d\uff0d\u300c\u66f8\u5f0f\u300d\uff0d\u300c\u30bb\u30eb\u306e\u66f8\u5f0f\u8a2d\u5b9a\u300d\u3092\u958b\u304d\u307e\u3059\u3002<\/div>\n
\"sapo7.JPG\"<\/a><\/div>\n
<\/div>\n
c.\u300c\u8868\u793a\u5f62\u5f0f\u300d\uff0d\u300c\u30e6\u30fc\u30b6\u5b9a\u7fa9\u300d\u3067\u3001\u7a2e\u985e\u30dc\u30c3\u30af\u30b9\u306b\u300c\u3000yyyy”\u5e74”m”\u6708\u672b”\u3000\u300d<\/b>\u3068\u5165\u529b\u3057\u3066<\/span><\/span><\/div>\n
OK<\/b>\u3092\u62bc\u3057\u307e\u3059\u3002<\/span><\/span>\u30d5\u30a9\u30f3\u30c8\u306e\u8272\u3092\u8d64\u8272\u306b\u3057\u307e\u3059\u3002<\/span><\/span><\/div>\n
\"sapo8.JPG\"<\/a><\/span><\/div>\n
<\/div>\n
\u2462\u300c\u66f4\u65b0\u3059\u308b\u30b5\u30dd\u30fc\u30c8\u671f\u9593\u300d<\/div>\n
a.\u3000\u30b5\u30dd\u30fc\u30c8\u958b\u59cb\u65e5<\/b>\u306f\u3001\u53f3\u56f3\u306e\u300c\u65b0\u30b5\u30dd\u30fc\u30c8\u671f\u9593\uff08\uff17\u5217\u76ee\uff09\u300d\u3092\u53c2\u7167\u3059\u308b\u6b21\u306e\u95a2\u6570\u5f0f\u304c\u5165\u3063\u3066\u3044\u307e\u3059\u3002\u300c\u3000=VLOOKUP($K$3,\u304a\u5ba2\u69d8\u30ea\u30b9\u30c8,7,FALSE)<\/b><\/span>\u3000\u300d<\/div>\n
<\/div>\n
b.\u3000\u30b5\u30dd\u30fc\u30c8\u7d42\u4e86\u65e5<\/b>\u306f\u3001\u30b5\u30dd\u30fc\u30c8\u958b\u59cb\u65e5\u304b\u3089\uff11\u5e74\u5f8c\u306e\u65e5\u4ed8\u3092\u6c42\u3081\u308b\u6b21\u306e\u95a2\u6570\u5f0f\u304c\u5165\u3063\u3066\u3044\u307e\u3059\u3002<\/div>\n
\u300c\u3000=DATE(YEAR(C26)+1,MONTH(C26),DAY(C26)-1)<\/b>\u3000<\/span>\u300d<\/div>\n
<\/div>\n
\"sapo9.JPG\"<\/a><\/span><\/div>\n
<\/div>\n
\u3068\u3001\u3044\u3046\u304b\u3093\u3058\u3067\u3001Excel\u3092\u4f7f\u3046\u3068\u3001<\/div>\n
\u5951\u7d04\u66f4\u65b0\u306e\u6848\u5185\u66f8\u306e\u3088\u3046\u306a\u6587\u66f8\u3082\u3001\u95a2\u6570\u3067\u30c7\u30fc\u30bf\u3092\u53c2\u7167\u3057\u306a\u304c\u3089\u4f5c\u6210\u304c\u3067\u304d\u3001<\/div>\n
\u65e9\u304f\u3066\u3001\u6b63\u78ba\u306a\u6587\u66f8\u304c\u4f5c\u6210\u3067\u304d\u307e\u3059\u3088\u306d\u3002<\/div>\n
<\/div>\n
\u305c\u3072\u3001\u3054\u6d3b\u7528\u304f\u3060\u3055\u3044\u3002<\/div>\n
\n
\u2606\u2606\u2606\u30fb\u30fb\u30fb\u2606\u2606\u2606\u30fb\u30fb\u30fb\u2606\u2606\u2606\u30fb\u30fb\u30fb\u2606\u2606\u2606\u30fb\u30fb\u30fb\u2606\u2606\u2606\u30fb\u30fb\u30fb\u2606\u2606\u2606\u30fb\u30fb\u30fb\u2606\u2606\u2606\u30fb\u30fb\u30fb\u2606\u2606 \u524d\u306e\u8a18\u4e8b<\/a> \u2606\u2606<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\u3053\u3093\u306b\u3061\u306f\uff01\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u753b\u50cf\uff1aHoshino.com \u30e2\u30ab\u3067\u3059\u3002 \u6691\u3044\uff01\uff01\uff01\u306e\u3082\u4eca\u65e5\u307e\u3067\u3002 \u660e\u65e5\u306f\u96e8\u306e\u4e88\u5831\u3067\u3059\u3002 \u65e5\u5c04\u3057\u304c\u5f37\u3044\u306e\u3067\u9854\u304c\u30d2\u30ea\u30d2\u30ea\u3059\u308b\u3053\u306e\u9803\u3002 \u65e5\u713c\u3051\u6b62\u3081\u3067\u30d0\u30c3\u30c1\u30ea\u3000\u30ab\u30d0\u30fc\u3057\u3066 […]<\/p>\n","protected":false},"author":2,"featured_media":2533,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[4],"tags":[],"class_list":["post-283","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-4"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-content\/uploads\/2025\/07\/newcom_cafecs4-thumb-100x121-26.jpg","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/posts\/283","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/comments?post=283"}],"version-history":[{"count":1,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/posts\/283\/revisions"}],"predecessor-version":[{"id":3248,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/posts\/283\/revisions\/3248"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/media\/2533"}],"wp:attachment":[{"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/media?parent=283"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/categories?post=283"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/tags?post=283"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}