{"id":2970,"date":"2025-10-07T12:48:12","date_gmt":"2025-10-07T03:48:12","guid":{"rendered":"https:\/\/www.flexcrm.jp\/media\/?p=2970"},"modified":"2026-08-17T12:02:27","modified_gmt":"2026-08-17T03:02:27","slug":"excel-student-management-free-sheet","status":"publish","type":"post","link":"https:\/\/www.flexcrm.jp\/media\/excel-student-management-free-sheet\/","title":{"rendered":"\u3010\u587e\u30fb\u30b5\u30ed\u30f3\u5411\u3051\u3011\u751f\u5f92\u7ba1\u7406\u30fb\u6708\u8b1d\u7ba1\u7406\u3092Excel\u3067\u59cb\u3081\u308b\u65b9\u6cd5\uff5c\u9805\u76ee\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\uff06\u4e8b\u4f8b\u4ed8\u304d"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u300c\u751f\u5f92\u306e\u6708\u8b1d\u3001\u8ab0\u304c\u6255\u3063\u3066\u8ab0\u304c\u307e\u3060\u304b\u5206\u304b\u3089\u306a\u3044\u300d\u300c\u51fa\u6b20\u306e\u96c6\u8a08\u306b\u6bce\u67081\u6642\u9593\u4ee5\u4e0a\u304b\u304b\u308b\u300d\u300c\u62c5\u5f53\u30b9\u30bf\u30c3\u30d5\u304c\u4f11\u3093\u3060\u3089\u60c5\u5831\u304c\u5168\u90e8\u6d88\u3048\u308b\u300d\u2014\u2014<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5c0f\u898f\u6a21\u306e\u587e\u3084\u7f8e\u5bb9\u30b5\u30ed\u30f3\u3001\u7fd2\u3044\u4e8b\u6559\u5ba4\u3067\u3001\u3053\u3093\u306a\u60a9\u307f\u3092\u62b1\u3048\u3066\u3044\u307e\u305b\u3093\u304b\uff1f<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u751f\u5f92\u7ba1\u7406\u3084\u6708\u8b1d\u7ba1\u7406\u306f\u3001Excel\u3067\u300c\u6b63\u3057\u3044\u9805\u76ee\u8a2d\u8a08\u300d\u3055\u3048\u3059\u308c\u3070\u3001\u7121\u6599\u3067\u4eca\u65e5\u304b\u3089\u59cb\u3081\u3089\u308c\u307e\u3059\u3002 \u672c\u8a18\u4e8b\u3067\u306f\u3001\u696d\u7a2e\u5225\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u4e8b\u4f8b\u4ed8\u304d\u3067\u3001Excel\u30b7\u30fc\u30c8\u306e\u4f5c\u308a\u65b9\u3092\u5177\u4f53\u7684\u306b\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u3055\u3089\u306b\u3001Excel\u7ba1\u7406\u304c\u9650\u754c\u3092\u8fce\u3048\u308b\u30bf\u30a4\u30df\u30f3\u30b0\u3068\u30011\u4eba\u304b\u3089\u4f7f\u3048\u308b\u9867\u5ba2\u7ba1\u7406\u30a2\u30d7\u30ea\u3078\u306e\u30b9\u30e0\u30fc\u30ba\u306a\u79fb\u884c\u65b9\u6cd5\u3082\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"812\" height=\"443\" src=\"https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/1excel-student-management-free-sheet_.png\" alt=\"\" class=\"wp-image-3758\" srcset=\"https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/1excel-student-management-free-sheet_.png 812w, https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/1excel-student-management-free-sheet_-300x164.png 300w, https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/1excel-student-management-free-sheet_-768x419.png 768w\" sizes=\"(max-width: 812px) 100vw, 812px\" \/><\/figure>\n\n\n\n<div class=\"swell-block-capbox cap_box\" data-colset=\"col2\"><div class=\"cap_box_ttl\"><span>\u3053\u306e\u8a18\u4e8b\u306e\u30dd\u30a4\u30f3\u30c8<\/span><\/div><div class=\"cap_box_content\">\n<div class=\"wp-block-columns\">\n<div class=\"wp-block-column\" style=\"flex-basis:18%\">\n<figure class=\"wp-block-image size-full is-resized is-style-rounded\"><img decoding=\"async\" width=\"135\" height=\"150\" src=\"https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/04\/h08.png\" alt=\"\" class=\"wp-image-1335\" style=\"width:102px;height:auto\"\/><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column\" style=\"flex-basis:88%\">\n<ul class=\"wp-block-list\">\n<li>Excel\u3067\u751f\u5f92\u7ba1\u7406\u30fb\u6708\u8b1d\u7ba1\u7406\u3092\u59cb\u3081\u308b\u5177\u4f53\u7684\u624b\u9806\u3068\u9805\u76ee\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8<\/li>\n\n\n\n<li>\u587e\u30fb\u7f8e\u5bb9\u30b5\u30ed\u30f3\u30fb\u6559\u5ba4\u306e\u696d\u7a2e\u5225\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u4e8b\u4f8b<\/li>\n\n\n\n<li>SUM\u30fbCOUNTIF\u30fbVLOOKUP\u306a\u3069\u5b9f\u52d9\u3067\u4f7f\u3046\u95a2\u6570\u306e\u4f7f\u3044\u65b9<\/li>\n\n\n\n<li>Excel\u304c\u7834\u7dbb\u3059\u308b\u30bf\u30a4\u30df\u30f3\u30b0\u3068\u7ba1\u7406\u30a2\u30d7\u30ea\u3078\u306e\u79fb\u884c\u5224\u65ad\u57fa\u6e96<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"687\" height=\"1024\" src=\"https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970manga-687x1024.png\" alt=\"\" class=\"wp-image-4204\" srcset=\"https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970manga-687x1024.png 687w, https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970manga-201x300.png 201w, https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970manga-768x1145.png 768w, https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970manga.png 848w\" sizes=\"(max-width: 687px) 100vw, 687px\" \/><\/figure>\n\n\n\n<dl class=\"swell-block-faq -icon-circle\" data-q=\"fill-custom\" data-a=\"fill-custom\">\n<div class=\"swell-block-faq__item\"><dt class=\"faq_q\">\u751f\u5f92\u3084\u9867\u5ba2\u7ba1\u7406\u30fb\u5165\u91d1\u7ba1\u7406\u306fExcel\u3067\u554f\u984c\u3042\u308a\u307e\u305b\u3093\u304b\uff1f<\/dt><dd class=\"faq_a\">\n<p class=\"wp-block-paragraph\">\u6559\u5ba4\u3084\u30b5\u30ed\u30f3\u306a\u3069\u306e\u751f\u5f92\u3084\u9867\u5ba2\u7ba1\u7406\u3001\u6708\u8b1d\u306a\u3069\u7ba1\u7406\u3092Excel\u3067\u884c\u3063\u3066\u3044\u308b\u65b9\u306f\u591a\u3044\u3067\u3057\u3087\u3046\u3002\u305f\u3060\u3057\u30a8\u30af\u30bb\u30eb\u7ba1\u7406\u306f\u300c\u3044\u3064\u304b\u7834\u7dbb\u3059\u308b\u300d\u524d\u63d0\u3067\u6e96\u5099\u3059\u308b\u3053\u3068\u304c\u5fc5\u8981\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u5171\u6709\u30fb\u30b9\u30de\u30db\u5165\u529b\u30fb\u30e1\u30fc\u30eb\u9023\u7d61\u307e\u3067\u5b8c\u7d50\u3057\u3088\u3046\u3068\u601d\u3048\u3070Excel\u3067\u306f\u4e0d\u53ef\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u7ba1\u7406\u30c4\u30fc\u30eb\u3092\u4f7f\u3048\u3070\u305d\u3046\u3044\u3063\u305f\u3053\u3068\u3082\u5b9f\u73fe\u3067\u304d\u307e\u3059\u3002Excel\u3067\u300c\u4f55\u3092\u7ba1\u7406\u3059\u3079\u304d\u304b\u300d\u306e\u578b\u3092\u5b66\u3073\u3001\u4e8b\u696d\u306e\u6210\u9577\u306b\u5408\u308f\u305b\u3066\u30a2\u30d7\u30ea\u306b\u5207\u308a\u66ff\u3048\u308b\u2014\u2014\u3053\u308c\u304c\u6700\u3082\u30e0\u30c0\u306e\u306a\u3044\u9032\u3081\u65b9\u3067\u3059\u3002<\/p>\n<\/dd><\/div>\n<\/dl>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>\u751f\u5f92\u7ba1\u7406\u30fb\u6708\u8b1d\u7ba1\u7406\u306b\u5fc5\u8981\u306a\u9805\u76ee\u4e00\u89a7\u3010\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3011<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"558\" src=\"https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970_01-1024x558.png\" alt=\"\" class=\"wp-image-4129\" srcset=\"https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970_01-1024x558.png 1024w, https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970_01-300x164.png 300w, https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970_01-768x419.png 768w, https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970_01.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u57fa\u672c\u60c5\u5831\uff08\u3069\u306e\u696d\u7a2e\u3067\u3082\u5171\u901a\uff09<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u307e\u305a\u3001\u696d\u7a2e\u3092\u554f\u308f\u305a\u5fc5\u305a\u5fc5\u8981\u306b\u306a\u308b\u9805\u76ee\u3092\u6574\u7406\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th><strong>\u9805\u76ee<\/strong><\/th><th><strong>\u5177\u4f53\u4f8b<\/strong><\/th><th><strong>\u5099\u8003<\/strong><\/th><\/tr><\/thead><tbody><tr><td>\u7ba1\u7406\u756a\u53f7\uff08ID\uff09<\/td><td>S001, C001<\/td><td>\u4e00\u610f\u306e\u756a\u53f7\u3002VLOOKUP\u306e\u57fa\u70b9\u306b\u306a\u308b<\/td><\/tr><tr><td>\u6c0f\u540d<\/td><td>\u5c71\u7530 \u592a\u90ce<\/td><td>\u30d5\u30ea\u30ac\u30ca\u3082\u5225\u5217\u3067\u8a2d\u3051\u308b\u3068\u691c\u7d22\u306b\u4fbf\u5229<\/td><\/tr><tr><td>\u96fb\u8a71\u756a\u53f7<\/td><td>090-XXXX-XXXX<\/td><td>\u7dca\u6025\u9023\u7d61\u7528<\/td><\/tr><tr><td>\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9<\/td><td>taro@example.com<\/td><td>\u9023\u7d61\u30fb\u304a\u77e5\u3089\u305b\u914d\u4fe1\u7528<\/td><\/tr><tr><td>\u5165\u4f1a\u65e5<\/td><td>2024\/04\/01<\/td><td>\u5728\u7c4d\u671f\u9593\u306e\u628a\u63e1\u3001\u6708\u8b1d\u767a\u751f\u65e5\u306e\u7ba1\u7406<\/td><\/tr><tr><td>\u30b3\u30fc\u30b9\/\u30e1\u30cb\u30e5\u30fc<\/td><td>\u82f1\u6570\u30b3\u30fc\u30b9 \/ \u30ab\u30c3\u30c8\uff0b\u30ab\u30e9\u30fc<\/td><td>\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3\u30ea\u30b9\u30c8\u63a8\u5968<\/td><\/tr><tr><td>\u62c5\u5f53\u8005<\/td><td>\u7530\u4e2d\u5148\u751f \/ \u30b9\u30bf\u30a4\u30ea\u30b9\u30c8A<\/td><td>\u5c5e\u4eba\u5316\u9632\u6b62\u306e\u305f\u3081\u5fc5\u305a\u8a18\u9332<\/td><\/tr><tr><td>\u5099\u8003<\/td><td>\u30a2\u30ec\u30eb\u30ae\u30fc\u60c5\u5831\u3001\u5b66\u7fd2\u4e0a\u306e\u914d\u616e<\/td><td>\u81ea\u7531\u8a18\u8ff0\u6b04<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u6708\u8b1d\u30fb\u652f\u6255\u3044\u7ba1\u7406\u306e\u9805\u76ee<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th><strong>\u9805\u76ee<\/strong><\/th><th><strong>\u5177\u4f53\u4f8b<\/strong><\/th><th><strong>\u5099\u8003<\/strong><\/th><\/tr><\/thead><tbody><tr><td>\u6708\u984d\u6599\u91d1<\/td><td>15,000\u5186<\/td><td>\u30b3\u30fc\u30b9\u5225\u306b\u81ea\u52d5\u8868\u793a\u3059\u308b\u306a\u3089VLOOKUP<\/td><\/tr><tr><td>\u652f\u6255\u3044\u65b9\u6cd5<\/td><td>\u53e3\u5ea7\u632f\u66ff \/ \u73fe\u91d1 \/ \u30ab\u30fc\u30c9<\/td><td>\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3\u63a8\u5968<\/td><\/tr><tr><td>\u5f53\u6708\u5165\u91d1\u65e5<\/td><td>2024\/07\/05<\/td><td>\u7a7a\u6b04\uff1d\u672a\u5165\u91d1\u3068\u3057\u3066\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u3067\u8272\u5206\u3051<\/td><\/tr><tr><td>\u5165\u91d1\u30b9\u30c6\u30fc\u30bf\u30b9<\/td><td>\u6e08 \/ \u672a \/ \u9045\u5ef6<\/td><td>COUNTIF\u3067\u6708\u672b\u306b\u672a\u7d0d\u8005\u3092\u81ea\u52d5\u96c6\u8a08<\/td><\/tr><tr><td>\u672a\u7d0d\u6708\u6570<\/td><td>2<\/td><td>\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u30672\u30f6\u6708\u4ee5\u4e0a\u3092\u8d64\u8868\u793a<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u51fa\u6b20\u7ba1\u7406\u306e\u9805\u76ee<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th><strong>\u9805\u76ee<\/strong><\/th><th><strong>\u5177\u4f53\u4f8b<\/strong><\/th><th><strong>\u5099\u8003<\/strong><\/th><\/tr><\/thead><tbody><tr><td>\u65e5\u4ed8<\/td><td>2024\/07\/01<\/td><td>\u65e5\u4ed8\u5f62\u5f0f\u3067\u7d71\u4e00<\/td><\/tr><tr><td>\u51fa\u6b20\u533a\u5206<\/td><td>\u51fa\u5e2d \/ \u6b20\u5e2d \/ \u9045\u523b \/ \u632f\u66ff<\/td><td>\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3\u5fc5\u9808<\/td><\/tr><tr><td>\u5099\u8003<\/td><td>\u4f53\u8abf\u4e0d\u826f\u3001\u96fb\u8eca\u9045\u5ef6<\/td><td>\u7406\u7531\u3092\u8a18\u9332<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div class=\"swell-block-capbox cap_box is-style-inner\" data-colset=\"col2\"><div class=\"cap_box_ttl\"><span><strong>\u30dd\u30a4\u30f3\u30c8<\/strong><\/span><\/div><div class=\"cap_box_content\">\n<p class=\"wp-block-paragraph\">\u6700\u521d\u304b\u3089\u5168\u9805\u76ee\u3092\u4f7f\u3046\u5fc5\u8981\u306f\u3042\u308a\u307e\u305b\u3093\u3002\u300c\u7ba1\u7406\u756a\u53f7\u30fb\u6c0f\u540d\u30fb\u30b3\u30fc\u30b9\u30fb\u6708\u8b1d\u30b9\u30c6\u30fc\u30bf\u30b9\u300d\u306e4\u9805\u76ee\u3060\u3051\u3067\u30b9\u30bf\u30fc\u30c8\u3057\u3001\u5fc5\u8981\u306b\u5fdc\u3058\u3066\u8ffd\u52a0\u3059\u308b\u306e\u304c\u30b3\u30c4\u3067\u3059\u3002<\/p>\n<\/div><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>\u3010\u696d\u7a2e\u5225\u3011\u4e8b\u4f8b\u30d1\u30bf\u30fc\u30f33\u9078<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"558\" src=\"https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970_02-1024x558.png\" alt=\"\" class=\"wp-image-4131\" srcset=\"https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970_02-1024x558.png 1024w, https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970_02-300x164.png 300w, https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970_02-768x419.png 768w, https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970_02.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u4e8b\u4f8b\u2460\u3000\u500b\u4eba\u5b66\u7fd2\u587e\uff08\u751f\u5f9220\u540d\uff09<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7ba1\u7406\u3057\u305f\u3044\u3053\u3068\uff1a<\/strong>&nbsp;\u6210\u7e3e\u63a8\u79fb\u3001\u6708\u8b1d\u5165\u91d1\u3001\u51fa\u6b20<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u30b7\u30fc\u30c8\u69cb\u6210\u4f8b\uff1a<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th><strong>\u30b7\u30fc\u30c8\u540d<\/strong><\/th><th><strong>\u5185\u5bb9<\/strong><\/th><\/tr><\/thead><tbody><tr><td>\u751f\u5f92\u30de\u30b9\u30bf\u30fc<\/td><td>\u6c0f\u540d\u30fb\u5b66\u5e74\u30fb\u4fdd\u8b77\u8005\u60c5\u5831\u30fb\u30b3\u30fc\u30b9<\/td><\/tr><tr><td>\u6210\u7e3e\u7ba1\u7406<\/td><td>\u79d1\u76ee\u5225\u30c6\u30b9\u30c8\u70b9\u6570\u30fb\u5e73\u5747\u70b9\u30fb\u63a8\u79fb<\/td><\/tr><tr><td>\u6708\u8b1d\u7ba1\u7406<\/td><td>\u6708\u5225\u5165\u91d1\u30b9\u30c6\u30fc\u30bf\u30b9\u30fb\u672a\u7d0d\u4e00\u89a7<\/td><\/tr><tr><td>\u51fa\u6b20\u8a18\u9332<\/td><td>\u65e5\u5225\u306e\u51fa\u6b20\u533a\u5206\u30fb\u6b20\u5e2d\u56de\u6570\u96c6\u8a08<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u4f7f\u3046\u95a2\u6570\uff1a<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>=AVERAGE(C2:C10)&nbsp;\u2192 \u751f\u5f92\u306e\u5e73\u5747\u70b9\u3092\u81ea\u52d5\u7b97\u51fa<\/li>\n\n\n\n<li>=IF(F2&gt;=60,&#8221;\u5408\u683c&#8221;,&#8221;\u8981\u5fa9\u7fd2&#8221;)&nbsp;\u2192 \u70b9\u6570\u306b\u5fdc\u3058\u305f\u81ea\u52d5\u5224\u5b9a<\/li>\n\n\n\n<li>=COUNTIFS(B:B,&#8221;\u5c71\u7530\u592a\u90ce&#8221;,D:D,&#8221;\u6b20\u5e2d&#8221;)&nbsp;\u2192 \u7279\u5b9a\u751f\u5f92\u306e\u6b20\u5e2d\u56de\u6570<\/li>\n<\/ul>\n\n\n\n<div class=\"swell-block-capbox cap_box is-style-inner\" data-colset=\"col2\"><div class=\"cap_box_ttl\"><span><strong>\u904b\u7528\u306e\u30b3\u30c4<\/strong><\/span><\/div><div class=\"cap_box_content\">\n<p class=\"wp-block-paragraph\">\u6708\u672b\u306b\u6708\u8b1d\u30b7\u30fc\u30c8\u306e\u300c\u672a\u300d\u3092\u30d5\u30a3\u30eb\u30bf\u30fc\u3067\u62bd\u51fa\u3057\u3001\u4fdd\u8b77\u8005\u3078\u4e00\u62ec\u9023\u7d61\u3002\u6210\u7e3e\u30b7\u30fc\u30c8\u306f\u9762\u8ac7\u524d\u306b\u30b0\u30e9\u30d5\u5316\u3057\u3066\u4fdd\u8b77\u8005\u306b\u5171\u6709\u3002<\/p>\n<\/div><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u4e8b\u4f8b\u2461\u3000\u7f8e\u5bb9\u30b5\u30ed\u30f3\uff08\u9867\u5ba230\u540d\u30fb\u30b9\u30bf\u30c3\u30d52\u540d\uff09<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7ba1\u7406\u3057\u305f\u3044\u3053\u3068\uff1a<\/strong>&nbsp;\u6765\u5e97\u5c65\u6b74\u3001\u58f2\u4e0a\u3001\u6b21\u56de\u4e88\u7d04\u3001\u9867\u5ba2\u306e\u597d\u307f<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u30b7\u30fc\u30c8\u69cb\u6210\u4f8b\uff1a<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th><strong>\u30b7\u30fc\u30c8\u540d<\/strong><\/th><th><strong>\u5185\u5bb9<\/strong><\/th><\/tr><\/thead><tbody><tr><td>\u9867\u5ba2\u30de\u30b9\u30bf\u30fc<\/td><td>\u6c0f\u540d\u30fb\u9023\u7d61\u5148\u30fb\u65bd\u8853\u5c65\u6b74\u30fb\u30a2\u30ec\u30eb\u30ae\u30fc<\/td><\/tr><tr><td>\u6765\u5e97\u8a18\u9332<\/td><td>\u65e5\u4ed8\u30fb\u30e1\u30cb\u30e5\u30fc\u30fb\u62c5\u5f53\u8005\u30fb\u58f2\u4e0a\u91d1\u984d<\/td><\/tr><tr><td>\u6708\u9593\u58f2\u4e0a<\/td><td>\u9867\u5ba2\u5225\u58f2\u4e0a\u30fb\u30e1\u30cb\u30e5\u30fc\u5225\u96c6\u8a08<\/td><\/tr><tr><td>\u6b21\u56de\u4e88\u7d04<\/td><td>\u4e88\u7d04\u65e5\u30fb\u30e1\u30cb\u30e5\u30fc\u30fb\u30ea\u30de\u30a4\u30f3\u30c9\u8981\u5426<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u4f7f\u3046\u95a2\u6570\uff1a<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>=SUMIFS(\u58f2\u4e0a\u5217, \u9867\u5ba2\u540d\u5217, &#8220;\u4f50\u85e4\u82b1\u5b50&#8221;, \u6708\u5217, &#8220;7\u6708&#8221;)&nbsp;\u2192 \u9867\u5ba2\u5225\u6708\u9593\u58f2\u4e0a<\/li>\n\n\n\n<li>=COUNTIF(\u30e1\u30cb\u30e5\u30fc\u5217,&#8221;\u30ab\u30e9\u30fc&#8221;)&nbsp;\u2192 \u30e1\u30cb\u30e5\u30fc\u5225\u65bd\u8853\u56de\u6570<\/li>\n\n\n\n<li>=VLOOKUP(A2,\u9867\u5ba2\u30de\u30b9\u30bf\u30fc!A:E,5,FALSE)&nbsp;\u2192 ID\u304b\u3089\u9867\u5ba2\u60c5\u5831\u3092\u81ea\u52d5\u8868\u793a<\/li>\n<\/ul>\n\n\n\n<div class=\"swell-block-capbox cap_box is-style-inner\" data-colset=\"col2\"><div class=\"cap_box_ttl\"><span><strong>\u904b\u7528\u306e\u30b3\u30c4<\/strong><\/span><\/div><div class=\"cap_box_content\">\n<p class=\"wp-block-paragraph\">\u524d\u56de\u6765\u5e97\u304b\u308960\u65e5\u4ee5\u4e0a\u7a7a\u3044\u305f\u9867\u5ba2\u3092\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u3067\u30cf\u30a4\u30e9\u30a4\u30c8\u3057\u3001\u518d\u6765\u5e97\u4fc3\u9032\u306eDM\u30ea\u30b9\u30c8\u306b\u6d3b\u7528\u3002<\/p>\n<\/div><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u4e8b\u4f8b\u2462\u3000\u30d4\u30a2\u30ce\u6559\u5ba4\uff08\u751f\u5f9215\u540d\u30fb\u6708\u8b1d\u5236\uff0b\u767a\u8868\u4f1a\u8cbb\uff09<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7ba1\u7406\u3057\u305f\u3044\u3053\u3068\uff1a<\/strong>&nbsp;\u30ec\u30c3\u30b9\u30f3\u51fa\u6b20\u3001\u6708\u8b1d\uff0b\u767a\u8868\u4f1a\u8cbb\u306e\u5165\u91d1\u3001\u9032\u5ea6\u8a18\u9332<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u30b7\u30fc\u30c8\u69cb\u6210\u4f8b\uff1a<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th><strong>\u30b7\u30fc\u30c8\u540d<\/strong><\/th><th><strong>\u5185\u5bb9<\/strong><\/th><\/tr><\/thead><tbody><tr><td>\u751f\u5f92\u30de\u30b9\u30bf\u30fc<\/td><td>\u6c0f\u540d\u30fb\u5b66\u5e74\u30fb\u4fdd\u8b77\u8005\u9023\u7d61\u5148\u30fb\u66dc\u65e5<\/td><\/tr><tr><td>\u30ec\u30c3\u30b9\u30f3\u8a18\u9332<\/td><td>\u65e5\u4ed8\u30fb\u51fa\u6b20\u30fb\u9032\u5ea6\uff08\u6559\u672c\u30da\u30fc\u30b8\u7b49\uff09<\/td><\/tr><tr><td>\u6708\u8b1d\u7ba1\u7406<\/td><td>\u6708\u984d\uff0b\u767a\u8868\u4f1a\u8cbb\u30fb\u5165\u91d1\u30b9\u30c6\u30fc\u30bf\u30b9<\/td><\/tr><tr><td>\u5e74\u9593\u30ab\u30ec\u30f3\u30c0\u30fc<\/td><td>\u4f11\u8b1b\u65e5\u30fb\u767a\u8868\u4f1a\u65e5\u7a0b\u30fb\u632f\u66ff\u7ba1\u7406<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u4f7f\u3046\u95a2\u6570\uff1a<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>=COUNTIFS(\u751f\u5f92\u540d\u5217,&#8221;\u7530\u4e2d\u6b21\u90ce&#8221;,\u51fa\u6b20\u5217,&#8221;\u6b20\u5e2d&#8221;)&nbsp;\u2192 \u6b20\u5e2d\u56de\u6570<\/li>\n\n\n\n<li>=IF(\u5165\u91d1\u65e5\u30bb\u30eb=&#8221;&#8221;,&#8221;\u672a\u7d0d&#8221;,&#8221;\u6e08&#8221;)&nbsp;\u2192 \u5165\u91d1\u6709\u7121\u3092\u81ea\u52d5\u5224\u5b9a<\/li>\n\n\n\n<li>=DATEDIF(\u524d\u56de\u30ec\u30c3\u30b9\u30f3\u65e5,TODAY(),&#8221;D&#8221;)&nbsp;\u2192 \u524d\u56de\u304b\u3089\u306e\u7d4c\u904e\u65e5\u6570<\/li>\n<\/ul>\n\n\n\n<div class=\"swell-block-capbox cap_box is-style-inner\" data-colset=\"col2\"><div class=\"cap_box_ttl\"><span><strong>\u904b\u7528\u306e\u30b3\u30c4<\/strong><\/span><\/div><div class=\"cap_box_content\">\n<p class=\"wp-block-paragraph\">&nbsp;\u6708\u521d\u306b\u6708\u8b1d\u30b7\u30fc\u30c8\u306e\u5165\u91d1\u30b9\u30c6\u30fc\u30bf\u30b9\u3092\u5168\u54e1\u300c\u672a\u300d\u306b\u30ea\u30bb\u30c3\u30c8\u3057\u3001\u5165\u91d1\u78ba\u8a8d\u306e\u305f\u3073\u306b\u300c\u6e08\u300d\u306b\u5909\u66f4\u3002\u6708\u672b\u306b\u672a\u7d0d\u8005\u3060\u3051\u30d5\u30a3\u30eb\u30bf\u30fc\u3067\u4e00\u89a7\u5316\u3002<\/p>\n<\/div><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Excel\u3067\u4f7f\u3046\u95a2\u65705\u9078\uff08\u5b9f\u8df5\u7684\u306a\u4f7f\u3044\u65b9\uff09<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"558\" src=\"https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970_03-1024x558.png\" alt=\"\" class=\"wp-image-4132\" srcset=\"https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970_03-1024x558.png 1024w, https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970_03-300x164.png 300w, https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970_03-768x419.png 768w, https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970_03.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u2460 SUM \u2014 \u5408\u8a08\u3092\u51fa\u3059<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">=SUM(D2:D20)&nbsp;\u2192 \u6708\u9593\u58f2\u4e0a\u5408\u8a08\u3001\u6708\u8b1d\u5408\u8a08\u984d\u306e\u8a08\u7b97\u306b\u4f7f\u7528<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u2461 AVERAGE \u2014 \u5e73\u5747\u3092\u51fa\u3059<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">=AVERAGE(C2:C10)&nbsp;\u2192 \u30c6\u30b9\u30c8\u5e73\u5747\u70b9\u30011\u56de\u3042\u305f\u308a\u306e\u65bd\u8853\u5358\u4fa1\u306e\u7b97\u51fa\u306b\u4f7f\u7528<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u2462 IF \u2014 \u6761\u4ef6\u5206\u5c90\u3067\u81ea\u52d5\u5224\u5b9a<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">=IF(E2=&#8221;&#8221;,&#8221;\u672a\u7d0d&#8221;,&#8221;\u5165\u91d1\u6e08&#8221;)&nbsp;\u2192 \u30bb\u30eb\u304c\u7a7a\u6b04\u306a\u3089\u300c\u672a\u7d0d\u300d\u3001\u5165\u529b\u304c\u3042\u308c\u3070\u300c\u5165\u91d1\u6e08\u300d\u3068\u8868\u793a<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u2463 COUNTIF \/ COUNTIFS \u2014 \u6761\u4ef6\u306b\u5408\u3046\u30c7\u30fc\u30bf\u3092\u6570\u3048\u308b<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">=COUNTIFS(A:A,&#8221;\u5c71\u7530\u592a\u90ce&#8221;,C:C,&#8221;\u6b20\u5e2d&#8221;)&nbsp;\u2192 \u7279\u5b9a\u306e\u751f\u5f92\u306e\u6b20\u5e2d\u56de\u6570\u3092\u81ea\u52d5\u30ab\u30a6\u30f3\u30c8<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u2464 VLOOKUP \u2014 \u5225\u30b7\u30fc\u30c8\u304b\u3089\u60c5\u5831\u3092\u5f15\u3063\u5f35\u308b<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">=VLOOKUP(A2,\u751f\u5f92\u30de\u30b9\u30bf\u30fc!A:D,4,FALSE)&nbsp;\u2192 \u7ba1\u7406\u756a\u53f7\u3092\u5165\u529b\u3059\u308b\u3060\u3051\u3067\u6c0f\u540d\u3084\u30b3\u30fc\u30b9\u3092\u81ea\u52d5\u8868\u793a\u3002\u30b7\u30fc\u30c8\u9593\u306e\u9023\u643a\u306b\u5fc5\u9808<\/p>\n\n\n\n<div class=\"swell-block-capbox cap_box is-style-inner\" data-colset=\"col2\"><div class=\"cap_box_ttl\"><span><strong>\u30b3\u30c4<\/strong><\/span><\/div><div class=\"cap_box_content\">\n<p class=\"wp-block-paragraph\">\u95a2\u6570\u306f\u4e00\u5ea6\u8a2d\u5b9a\u3059\u308c\u3070\u3001\u4ee5\u964d\u306f\u5165\u529b\u3060\u3051\u3067\u81ea\u52d5\u96c6\u8a08\u3055\u308c\u307e\u3059\u3002\u6700\u521d\u306e30\u5206\u3092\u6295\u8cc7\u3059\u308b\u3060\u3051\u3067\u3001\u6bce\u6708\u306e\u96c6\u8a08\u6642\u9593\u3092\u5927\u5e45\u306b\u77ed\u7e2e\u3067\u304d\u307e\u3059\u3002<\/p>\n<\/div><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Excel\u304c\u300c\u7834\u7dbb\u3059\u308b\u300d\u30bf\u30a4\u30df\u30f3\u30b0\u3068\u30b5\u30a4\u30f3<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"558\" src=\"https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970_04-1024x558.png\" alt=\"\" class=\"wp-image-4133\" srcset=\"https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970_04-1024x558.png 1024w, https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970_04-300x164.png 300w, https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970_04-768x419.png 768w, https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970_04.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Excel\u7ba1\u7406\u306f\u624b\u8efd\u3067\u3059\u304c\u3001\u4ee5\u4e0b\u306e\u30b5\u30a4\u30f3\u304c\u51fa\u305f\u3089\u9650\u754c\u304c\u6765\u3066\u3044\u308b\u8a3c\u62e0\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th><strong>\u7834\u7dbb\u306e\u30b5\u30a4\u30f3<\/strong><\/th><th><strong>\u4f55\u304c\u8d77\u304d\u308b\u304b<\/strong><\/th><\/tr><\/thead><tbody><tr><td>\u751f\u5f92\uff08\u9867\u5ba2\uff09\u304c30\u540d\u3092\u8d85\u3048\u305f<\/td><td>\u30b7\u30fc\u30c8\u304c\u91cd\u304f\u306a\u308a\u3001\u30b9\u30af\u30ed\u30fc\u30eb\u3068\u691c\u7d22\u306b\u6642\u9593\u304c\u304b\u304b\u308b<\/td><\/tr><tr><td>\u30b9\u30bf\u30c3\u30d5\u3068\u5171\u6709\u3057\u59cb\u3081\u305f<\/td><td>\u300c\u6700\u65b0\u7248\u306f\u3069\u308c\uff1f\u300d\u300c\u4e0a\u66f8\u304d\u3055\u308c\u305f\u300d\u554f\u984c\u304c\u983b\u767a<\/td><\/tr><tr><td>\u30b9\u30de\u30db\u304b\u3089\u78ba\u8a8d\u3057\u305f\u304f\u306a\u3063\u305f<\/td><td>Excel\u64cd\u4f5c\u304c\u30b9\u30de\u30db\u3067\u306f\u56f0\u96e3\u3002\u5916\u51fa\u5148\u3067\u4f7f\u3048\u306a\u3044<\/td><\/tr><tr><td>\u30e1\u30fc\u30eb\u9023\u7d61\u3092\u5225\u30c4\u30fc\u30eb\u3067\u884c\u3063\u3066\u3044\u308b<\/td><td>\u60c5\u5831\u304c\u5206\u6563\u3057\u3001\u300c\u8ab0\u306b\u3044\u3064\u4f55\u3092\u9001\u3063\u305f\u304b\u300d\u304c\u5206\u304b\u3089\u306a\u304f\u306a\u308b<\/td><\/tr><tr><td>\u30d5\u30a1\u30a4\u30eb\u304c\u8907\u6570\u306b\u5206\u304b\u308c\u305f<\/td><td>\u5e74\u5ea6\u3054\u3068\u306b\u30d5\u30a1\u30a4\u30eb\u304c\u5897\u3048\u3001\u904e\u53bb\u30c7\u30fc\u30bf\u306e\u53c2\u7167\u304c\u9762\u5012<\/td><\/tr><tr><td>\u95a2\u6570\u3084\u30de\u30af\u30ed\u304c\u58ca\u308c\u305f<\/td><td>\u4fee\u6b63\u3067\u304d\u308b\u4eba\u304c\u3044\u306a\u3044\u3068\u5fa9\u65e7\u4e0d\u80fd<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u3053\u308c\u3089\u306e\u30b5\u30a4\u30f3\u304c1\u3064\u3067\u3082\u5f53\u3066\u306f\u307e\u3063\u305f\u3089\u3001\u7ba1\u7406\u30a2\u30d7\u30ea\u3078\u306e\u79fb\u884c\u3092\u691c\u8a0e\u3059\u308b\u30bf\u30a4\u30df\u30f3\u30b0\u3067\u3059\u3002<\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>1\u4eba\u304b\u3089\u4f7f\u3048\u308b\u9867\u5ba2\u7ba1\u7406\u30a2\u30d7\u30ea\u3068\u3044\u3046\u9078\u629e\u80a2<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"558\" src=\"https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970_05-1024x558.png\" alt=\"\" class=\"wp-image-4136\" srcset=\"https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970_05-1024x558.png 1024w, https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970_05-300x164.png 300w, https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970_05-768x419.png 768w, https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970_05.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u7ba1\u7406\u30a2\u30d7\u30ea\u304cExcel\u3088\u308a\u4fbf\u5229\u306a\u7406\u7531<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u2460 \u3069\u3053\u306b\u3044\u3066\u3082\u5165\u529b\u30fb\u78ba\u8a8d\u30fb\u9023\u7d61\u304c\u3067\u304d\u308b<\/strong><br>\u30b9\u30de\u30db1\u53f0\u3067\u3001\u30ec\u30c3\u30b9\u30f3\u76f4\u5f8c\u306b\u51fa\u6b20\u3092\u5165\u529b\u3057\u3001\u4fdd\u8b77\u8005\u306b\u30e1\u30fc\u30eb\u9023\u7d61\u3059\u308b\u3068\u3053\u308d\u307e\u3067\u5b8c\u7d50\u3057\u307e\u3059\u3002\u6559\u5ba4\u306b\u3044\u306a\u304f\u3066\u3082\u6700\u65b0\u60c5\u5831\u304c\u624b\u5143\u306b\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u2461 \u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u3067\u60c5\u5831\u304c\u5171\u6709\u3055\u308c\u308b<\/strong><br>\u30b9\u30bf\u30c3\u30d5\u304c\u5165\u529b\u3057\u305f\u77ac\u9593\u306b\u5168\u54e1\u306b\u53cd\u6620\u3002\u300c\u30d5\u30a1\u30a4\u30eb\u306e\u6700\u65b0\u7248\u306f\u3069\u308c\uff1f\u300d\u554f\u984c\u304c\u30bc\u30ed\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u2462 \u30e1\u30fc\u30eb\u9023\u7d61\u30fb\u30ea\u30de\u30a4\u30f3\u30c9\u307e\u3067\u4e00\u5143\u5316<\/strong><br>\u672a\u7d0d\u8005\u3078\u306e\u9023\u7d61\u3001\u6b21\u56de\u4e88\u7d04\u306e\u30ea\u30de\u30a4\u30f3\u30c9\u3001\u304a\u77e5\u3089\u305b\u914d\u4fe1\u304c\u30a2\u30d7\u30ea\u5185\u3067\u5b8c\u7d50\u3002\u60c5\u5831\u306e\u5206\u6563\u304c\u8d77\u304d\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u2463 \u30c7\u30fc\u30bf\u304c\u58ca\u308c\u306a\u3044<\/strong><br>\u30af\u30e9\u30a6\u30c9\u4fdd\u5b58\u306e\u305f\u3081\u3001PC\u306e\u6545\u969c\u3084\u30d5\u30a1\u30a4\u30eb\u7834\u640d\u3067\u30c7\u30fc\u30bf\u3092\u5931\u3046\u30ea\u30b9\u30af\u304c\u3042\u308a\u307e\u305b\u3093\u3002\u81ea\u52d5\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u4ed8\u304d\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u30b3\u30b9\u30c8\u6bd4\u8f03<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th><strong>\u624b\u6bb5<\/strong><\/th><th><strong>\u6708\u984d\u8cbb\u7528<\/strong><\/th><th><strong>\u30b9\u30de\u30db\u5bfe\u5fdc<\/strong><\/th><th><strong>\u5171\u6709<\/strong><\/th><th><strong>\u30e1\u30fc\u30eb\u9023\u7d61<\/strong><\/th><\/tr><\/thead><tbody><tr><td>Excel<\/td><td>\u7121\u6599<\/td><td>\u25b3\uff08\u64cd\u4f5c\u56f0\u96e3\uff09<\/td><td>\u25b3\uff08\u4e0a\u66f8\u304d\u30ea\u30b9\u30af\uff09<\/td><td>\u00d7<\/td><\/tr><tr><td>Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8<\/td><td>\u7121\u6599<\/td><td>\u25b3<\/td><td>\u25cb<\/td><td>\u00d7<\/td><\/tr><tr><td><strong>\u9867\u5ba2\u7ba1\u7406\u30a2\u30d7\u30ea\uff08FlexCRM\u7b49\uff09<\/strong><\/td><td><strong>1,200\u5186\/\u4eba\u301c<\/strong><\/td><td><strong>\u25cb<\/strong><\/td><td><strong>\u25cb<\/strong><\/td><td><strong>\u25cb<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>FlexCRM\u304c\u5c0f\u898f\u6a21\u4e8b\u696d\u306b\u5411\u3044\u3066\u3044\u308b\u7406\u7531<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">FlexCRM\u306f\u30011\u30e6\u30fc\u30b6\u30fc\u304b\u3089\u521d\u671f\u8cbb\u7528\u30bc\u30ed\u3067\u59cb\u3081\u3089\u308c\u308b\u9867\u5ba2\u7ba1\u7406\u30c4\u30fc\u30eb\u3067\u3059\u3002<\/p>\n\n\n\n<div class=\"swell-block-capbox cap_box is-style-inner\" data-colset=\"col2\"><div class=\"cap_box_ttl\"><span><strong>\u751f\u5f92\u7ba1\u7406\u30fb\u6708\u8b1d\u7ba1\u7406\u306b\u4f7f\u3048\u308b\u7406\u7531<\/strong><\/span><\/div><div class=\"cap_box_content\">\n<ul class=\"wp-block-list\">\n<li>\u30ce\u30fc\u30b3\u30fc\u30c9\u3067\u300c\u751f\u5f92\u53f0\u5e33\u300d\u300c\u6708\u8b1d\u7ba1\u7406\u300d\u300c\u51fa\u6b20\u8a18\u9332\u300d\u30a2\u30d7\u30ea\u3092\u81ea\u5206\u3067\u4f5c\u308c\u308b<\/li>\n\n\n\n<li>PC\u304c\u82e6\u624b\u3067\u3082\u76f4\u611f\u64cd\u4f5c\u3067\u5b8c\u7d50\u3059\u308b\u8a2d\u8a08<\/li>\n\n\n\n<li>\u30b9\u30de\u30db\u304b\u3089\u51fa\u6b20\u5165\u529b\u30fb\u4fdd\u8b77\u8005\u30e1\u30fc\u30eb\u9001\u4fe1\u304c\u53ef\u80fd<\/li>\n\n\n\n<li>\u9867\u5ba2\u60c5\u5831\u3068\u65bd\u8853\u5c65\u6b74\u30fb\u30ec\u30c3\u30b9\u30f3\u8a18\u9332\u304c\u7d10\u3065\u304f\u306e\u3067\u60c5\u5831\u304c\u5206\u6563\u3057\u306a\u3044<\/li>\n\n\n\n<li>\u7121\u6599\u30d7\u30e9\u30f3\u3067\u307e\u305a\u8a66\u305b\u308b<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Excel\u3067\u7ba1\u7406\u306e\u300c\u578b\u300d\u3092\u5b66\u3093\u3060\u3089\u3001\u30a2\u30d7\u30ea\u306b\u5207\u308a\u66ff\u3048\u308b\u306e\u304c\u6700\u3082\u30b9\u30e0\u30fc\u30ba\u306a\u79fb\u884c\u30d1\u30bf\u30fc\u30f3\u3067\u3059\u3002<\/strong>&nbsp;Excel\u3067\u6574\u7406\u3057\u305f\u9805\u76ee\u3092\u305d\u306e\u307e\u307e\u30a2\u30d7\u30ea\u306b\u79fb\u884c\u3067\u304d\u308b\u305f\u3081\u3001\u6700\u521d\u304b\u3089\u30a2\u30d7\u30ea\u3092\u4f7f\u3046\u3088\u308a\u300c\u4f55\u3092\u7ba1\u7406\u3059\u3079\u304d\u304b\u300d\u304c\u660e\u78ba\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>\u307e\u3068\u3081<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"558\" src=\"https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970_06-1024x558.png\" alt=\"\" class=\"wp-image-4137\" srcset=\"https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970_06-1024x558.png 1024w, https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970_06-300x164.png 300w, https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970_06-768x419.png 768w, https:\/\/www.flexcrm.jp\/media\/wp-content\/uploads\/2025\/10\/2970_06.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Excel\u3067\u59cb\u3081\u3066\u3001\u30a2\u30d7\u30ea\u3067\u697d\u306b\u3059\u308b\u2014\u2014\u5c0f\u898f\u6a21\u7ba1\u7406\u306e\u6700\u9069\u30eb\u30fc\u30c8<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u4f5c\u308a\u65b9\u306e\u632f\u308a\u8fd4\u308a<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th><strong>\u30b9\u30c6\u30c3\u30d7<\/strong><\/th><th><strong>\u3084\u308b\u3053\u3068<\/strong><\/th><th><strong>\u6210\u679c<\/strong><\/th><\/tr><\/thead><tbody><tr><td>\u2460 \u9805\u76ee\u8a2d\u8a08<\/td><td>\u7ba1\u7406\u756a\u53f7\u30fb\u6c0f\u540d\u30fb\u30b3\u30fc\u30b9\u30fb\u6708\u8b1d\u30b9\u30c6\u30fc\u30bf\u30b9\u3092\u6c7a\u3081\u308b<\/td><td>\u7ba1\u7406\u306e\u300c\u578b\u300d\u304c\u3067\u304d\u308b<\/td><\/tr><tr><td>\u2461 \u30b7\u30fc\u30c8\u4f5c\u6210<\/td><td>\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3\u30fb\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u3092\u8a2d\u5b9a<\/td><td>\u5165\u529b\u30df\u30b9\u304c\u6e1b\u308a\u8996\u8a8d\u6027\u304c\u4e0a\u304c\u308b<\/td><\/tr><tr><td>\u2462 \u95a2\u6570\u8a2d\u5b9a<\/td><td>SUM\/COUNTIF\/VLOOKUP\u3067\u81ea\u52d5\u96c6\u8a08<\/td><td>\u6bce\u6708\u306e\u96c6\u8a08\u4f5c\u696d\u304c\u4e0d\u8981\u306b\u306a\u308b<\/td><\/tr><tr><td>\u2463 \u904b\u7528\u958b\u59cb<\/td><td>\u6708\u672b\u306b\u30d5\u30a3\u30eb\u30bf\u30fc\u3067\u672a\u7d0d\u8005\u62bd\u51fa\u2192\u9023\u7d61<\/td><td>\u6f0f\u308c\u306e\u306a\u3044\u6708\u8b1d\u7ba1\u7406\u304c\u5b9f\u73fe<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u696d\u7a2e\u5225\u306e\u30dd\u30a4\u30f3\u30c8\uff08\u304a\u3055\u3089\u3044\uff09<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th><strong>\u696d\u7a2e<\/strong><\/th><th><strong>\u7ba1\u7406\u306e\u6838<\/strong><\/th><th><strong>\u7279\u306b\u91cd\u8981\u306a\u9805\u76ee<\/strong><\/th><\/tr><\/thead><tbody><tr><td>\u5b66\u7fd2\u587e<\/td><td>\u6210\u7e3e\uff0b\u6708\u8b1d\uff0b\u51fa\u6b20<\/td><td>\u30c6\u30b9\u30c8\u70b9\u6570\u63a8\u79fb\u3001\u672a\u7d0d\u7ba1\u7406\u3001\u6b20\u5e2d\u56de\u6570<\/td><\/tr><tr><td>\u7f8e\u5bb9\u30b5\u30ed\u30f3<\/td><td>\u6765\u5e97\u5c65\u6b74\uff0b\u58f2\u4e0a\uff0b\u597d\u307f<\/td><td>\u524d\u56de\u65bd\u8853\u5185\u5bb9\u3001\u6765\u5e97\u9593\u9694\u3001\u30a2\u30ec\u30eb\u30ae\u30fc<\/td><\/tr><tr><td>\u30d4\u30a2\u30ce\u6559\u5ba4<\/td><td>\u30ec\u30c3\u30b9\u30f3\u9032\u5ea6\uff0b\u6708\u8b1d\uff0b\u632f\u66ff<\/td><td>\u6559\u672c\u30da\u30fc\u30b8\u3001\u767a\u8868\u4f1a\u8cbb\u3001\u632f\u66ff\u7ba1\u7406<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u30c4\u30fc\u30eb\u9078\u3073\u306e\u7d50\u8ad6<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th><strong>\u3042\u306a\u305f\u306e\u72b6\u6cc1<\/strong><\/th><th><strong>\u6700\u9069\u306a\u624b\u6bb5<\/strong><\/th><th><strong>\u7406\u7531<\/strong><\/th><\/tr><\/thead><tbody><tr><td>\u751f\u5f9210\u540d\u4ee5\u4e0b\u3067\u81ea\u5206\u3060\u3051\u304c\u7ba1\u7406<\/td><td><strong>Excel<\/strong><\/td><td>\u7121\u6599\u30fb\u624b\u8efd\u30fb\u500b\u4eba\u3067\u5b8c\u7d50<\/td><\/tr><tr><td>10\u540d\u8d85\u3001\u307e\u305f\u306f\u30b9\u30bf\u30c3\u30d5\u3068\u5171\u6709<\/td><td><strong>\u9867\u5ba2\u7ba1\u7406\u30a2\u30d7\u30ea<\/strong><\/td><td>\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u5171\u6709\u30fb\u30b9\u30de\u30db\u5bfe\u5fdc\u30fb\u30e1\u30fc\u30eb\u9023\u7d61\u307e\u3067\u4e00\u5143\u5316<\/td><\/tr><tr><td>Excel\u7ba1\u7406\u304c\u5d29\u58ca\u3057\u304b\u3051\u3066\u3044\u308b<\/td><td><strong>\u4eca\u3059\u3050\u30a2\u30d7\u30ea\u306b\u79fb\u884c<\/strong><\/td><td>\u30c7\u30fc\u30bf\u6d88\u5931\u306e\u524d\u306b\u79fb\u884c\u3059\u3079\u304d\u3002\u65e2\u5b58\u30c7\u30fc\u30bf\u306e\u30a4\u30f3\u30dd\u30fc\u30c8\u3082\u53ef\u80fd<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u6700\u7d42\u30e1\u30c3\u30bb\u30fc\u30b8<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Excel\u3067\u306e\u751f\u5f92\u7ba1\u7406\u30fb\u6708\u8b1d\u7ba1\u7406\u306f\u3001\u5c0f\u898f\u6a21\u4e8b\u696d\u306e\u7b2c\u4e00\u6b69\u3068\u3057\u3066\u6700\u9069\u3067\u3059\u3002\u3057\u304b\u3057\u3001<strong>Excel\u306f\u5fc5\u305a\u3069\u3053\u304b\u3067\u7834\u7dbb\u3057\u307e\u3059\u3002<\/strong>&nbsp;\u30d5\u30a1\u30a4\u30eb\u304c\u58ca\u308c\u308b\u3001\u30d0\u30fc\u30b8\u30e7\u30f3\u304c\u6df7\u4e71\u3059\u308b\u3001\u30b9\u30de\u30db\u3067\u4f7f\u3048\u306a\u3044\u2014\u2014\u3053\u3046\u3057\u305f\u554f\u984c\u306f\u751f\u5f92\u6570\u306e\u5897\u52a0\u3068\u3068\u3082\u306b\u5fc5\u305a\u8a2a\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u3060\u304b\u3089\u3053\u305d\u3001<strong>\u6700\u521d\u304b\u3089\u300c\u30a2\u30d7\u30ea\u306b\u79fb\u884c\u3059\u308b\u524d\u63d0\u300d\u3067\u9805\u76ee\u8a2d\u8a08\u3092\u3057\u3066\u304a\u304f<\/strong>\u3053\u3068\u304c\u91cd\u8981\u3067\u3059\u3002\u672c\u8a18\u4e8b\u3067\u7d39\u4ecb\u3057\u305f\u9805\u76ee\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3092\u305d\u306e\u307e\u307e\u7ba1\u7406\u30a2\u30d7\u30ea\u306b\u79fb\u884c\u3059\u308c\u3070\u3001\u30b9\u30e0\u30fc\u30ba\u306b\u6b21\u306e\u30b9\u30c6\u30fc\u30b8\u3078\u9032\u3081\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">FlexCRM\u306a\u3089\u30011\u4eba\u30fb\u7121\u6599\u304b\u3089\u8a66\u305b\u3066\u3001PC\u64cd\u4f5c\u304c\u82e6\u624b\u3067\u3082\u76f4\u611f\u7684\u306b\u4f7f\u3048\u308b\u8a2d\u8a08\u3067\u3059\u3002\u307e\u305a\u306f\u7121\u6599\u30d7\u30e9\u30f3\u3067\u300c\u6708\u8b1d\u7ba1\u7406\u30a2\u30d7\u30ea\u300d\u3092\u3072\u3068\u3064\u4f5c\u3063\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002Excel\u3068\u306e\u9055\u3044\u3092\u5b9f\u611f\u3067\u304d\u308b\u306f\u305a\u3067\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u300c\u751f\u5f92\u306e\u6708\u8b1d\u3001\u8ab0\u304c\u6255\u3063\u3066\u8ab0\u304c\u307e\u3060\u304b\u5206\u304b\u3089\u306a\u3044\u300d\u300c\u51fa\u6b20\u306e\u96c6\u8a08\u306b\u6bce\u67081\u6642\u9593\u4ee5\u4e0a\u304b\u304b\u308b\u300d\u300c\u62c5\u5f53\u30b9\u30bf\u30c3\u30d5\u304c\u4f11\u3093\u3060\u3089\u60c5\u5831\u304c\u5168\u90e8\u6d88\u3048\u308b\u300d\u2014\u2014 \u5c0f\u898f\u6a21\u306e\u587e\u3084\u7f8e\u5bb9\u30b5\u30ed\u30f3\u3001\u7fd2\u3044\u4e8b\u6559\u5ba4\u3067\u3001\u3053\u3093\u306a\u60a9\u307f\u3092\u62b1\u3048\u3066\u3044\u307e\u305b\u3093\u304b\uff1f \u751f\u5f92\u7ba1\u7406\u3084\u6708\u8b1d\u7ba1\u7406\u306f [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":3332,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"swell_btn_cv_data":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-2970","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.flexcrm.jp\/media\/wp-json\/wp\/v2\/posts\/2970","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.flexcrm.jp\/media\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.flexcrm.jp\/media\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.flexcrm.jp\/media\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.flexcrm.jp\/media\/wp-json\/wp\/v2\/comments?post=2970"}],"version-history":[{"count":26,"href":"https:\/\/www.flexcrm.jp\/media\/wp-json\/wp\/v2\/posts\/2970\/revisions"}],"predecessor-version":[{"id":4205,"href":"https:\/\/www.flexcrm.jp\/media\/wp-json\/wp\/v2\/posts\/2970\/revisions\/4205"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.flexcrm.jp\/media\/wp-json\/wp\/v2\/media\/3332"}],"wp:attachment":[{"href":"https:\/\/www.flexcrm.jp\/media\/wp-json\/wp\/v2\/media?parent=2970"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flexcrm.jp\/media\/wp-json\/wp\/v2\/categories?post=2970"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flexcrm.jp\/media\/wp-json\/wp\/v2\/tags?post=2970"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}