{"id":39361,"date":"2026-09-08T15:13:55","date_gmt":"2026-09-08T06:13:55","guid":{"rendered":"https:\/\/www.wakukichi.com\/?p=39361"},"modified":"2026-09-08T15:13:55","modified_gmt":"2026-09-08T06:13:55","slug":"excel%e3%82%af%e3%82%a8%e3%83%aa%e4%bd%bf%e3%81%84%e6%96%b9%e3%81%ae%e3%82%84%e3%82%8a%e6%96%b9%ef%bd%9c%e3%83%87%e3%83%bc%e3%82%bf%e3%82%92%e5%ae%88%e3%82%8b%e6%ba%96%e5%82%99%e3%81%a8%e7%a2%ba","status":"publish","type":"post","link":"https:\/\/www.wakukichi.com\/?p=39361","title":{"rendered":"Excel\u30af\u30a8\u30ea\u4f7f\u3044\u65b9\u306e\u3084\u308a\u65b9\uff5c\u30c7\u30fc\u30bf\u3092\u5b88\u308b\u6e96\u5099\u3068\u78ba\u8a8d\u30dd\u30a4\u30f3\u30c8"},"content":{"rendered":"

Excel\u306ePower Query\u306f\u3001\u30c7\u30fc\u30bf\u3092\u53d6\u308a\u8fbc\u307f\u3001\u5217\u306e\u6574\u7406\u306a\u3069\u306e\u624b\u9806\u3092\u8a18\u9332\u3057\u3066\u66f4\u65b0\u6642\u306b\u7e70\u308a\u8fd4\u3059\u6a5f\u80fd\u3067\u3059\u3002\u6bce\u56de\u540c\u3058\u5f62\u306b\u6574\u3048\u308b\u8868\u306b\u5411\u3044\u3066\u3044\u307e\u3059\u3002\u5143\u30c7\u30fc\u30bf\u3092\u76f4\u63a5\u66f8\u304d\u63db\u3048\u308b\u306e\u3067\u306f\u306a\u304f\u3001\u53d6\u308a\u8fbc\u3093\u3060\u7d50\u679c\u3092\u52a0\u5de5\u3057\u307e\u3059\u3002<\/p>\n

\u30ef\u30af\u3061\u3083\u3093\uff1a\u300c\u6bce\u6708\u3001\u540c\u3058\u5217\u3092\u6d88\u3057\u3066\u9806\u756a\u3092\u4e26\u3079\u76f4\u3057\u3066\u3044\u308b\u3088\u300d<\/span><\/div>\n
\u30c1\u30e3\u30d4\u5409\uff1a\u300c\u540c\u3058\u624b\u9806\u306a\u3089Power Query\u306b\u8a18\u9332\u3067\u304d\u308b\u304b\u8a66\u3057\u3066\u307f\u3088\u3046\u300d<\/span><\/div>\n

Excel\u30af\u30a8\u30ea\u4f7f\u3044\u65b9\uff1a\u4f5c\u696d\u524d\u306e\u78ba\u8a8d<\/h2>\n

\u5229\u7528\u74b0\u5883\u3067Power Query\u304c\u4f7f\u3048\u308b\u304b\u3001\u5143\u30c7\u30fc\u30bf\u304c\u3069\u3053\u306b\u3042\u308b\u304b\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002\u6b8b\u3059\u5217\u3068\u5fc5\u8981\u306a\u30c7\u30fc\u30bf\u578b\u3092\u6c7a\u3081\u3001\u7df4\u7fd2\u7528\u306e\u8cc7\u6599\u3092\u7528\u610f\u3057\u307e\u3059\u3002<\/p>\n

\u64cd\u4f5c\u624b\u9806<\/h2>\n

\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u304b\u3089\u5bfe\u8c61\u3092\u8aad\u307f\u8fbc\u307f\u3001\u30a8\u30c7\u30a3\u30bf\u30fc\u3067\u4e0d\u8981\u5217\u306e\u6574\u7406\u3084\u578b\u306e\u6307\u5b9a\u3092\u884c\u3044\u307e\u3059\u3002\u8ffd\u52a0\u3055\u308c\u305f\u30b9\u30c6\u30c3\u30d7\u3092\u78ba\u8a8d\u3057\u3066\u304b\u3089\u3001\u7d50\u679c\u3092\u30b7\u30fc\u30c8\u306a\u3069\u3078\u8aad\u307f\u8fbc\u307f\u307e\u3059\u3002<\/p>\n

\u76ee\u7684\u5225\u306e\u8a2d\u5b9a<\/h2>\n

\u8868\u3068\u3057\u3066\u4f7f\u3046\u306e\u304b\u3001\u30c7\u30fc\u30bf\u30e2\u30c7\u30eb\u3078\u8aad\u307f\u8fbc\u3080\u306e\u304b\u3067\u51fa\u529b\u5148\u3092\u9078\u3073\u307e\u3059\u3002\u65e5\u4ed8\u3084\u6570\u5024\u306e\u578b\u306f\u898b\u305f\u76ee\u3060\u3051\u3067\u6c7a\u3081\u305a\u3001\u5143\u306e\u5024\u306e\u610f\u5473\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n

\u3046\u307e\u304f\u3044\u304b\u306a\u3044\u3068\u304d<\/h2>\n

\u66f4\u65b0\u306b\u5931\u6557\u3059\u308b\u5834\u5408\u306f\u3001\u5143\u30d5\u30a1\u30a4\u30eb\u306e\u5834\u6240\u3084\u5217\u540d\u304c\u5909\u308f\u3063\u3066\u3044\u306a\u3044\u304b\u3092\u898b\u307e\u3059\u3002\u3069\u306e\u30b9\u30c6\u30c3\u30d7\u304b\u3089\u30a8\u30e9\u30fc\u306b\u306a\u308b\u304b\u3092\u78ba\u8a8d\u3057\u3001\u5f8c\u308d\u306e\u64cd\u4f5c\u3092\u307e\u3068\u3081\u3066\u524a\u9664\u3057\u306a\u3044\u3067\u304f\u3060\u3055\u3044\u3002<\/p>\n

\u5b8c\u4e86\u5f8c\u306e\u78ba\u8a8d\uff5c\u30d0\u30fc\u30b8\u30e7\u30f3\u78ba\u8a8d<\/h2>\n

\u7df4\u7fd2\u7528\u30c7\u30fc\u30bf\u3092\u5909\u66f4\u3057\u3066\u66f4\u65b0\u3057\u3001\u4ef6\u6570\u3084\u5024\u304c\u610f\u56f3\u3057\u305f\u7d50\u679c\u306b\u306a\u308b\u304b\u3092\u6bd4\u3079\u307e\u3059\u3002\u51fa\u529b\u8868\u3092\u624b\u3067\u76f4\u3059\u3060\u3051\u3067\u306f\u6b21\u56de\u66f4\u65b0\u3067\u623b\u308b\u5834\u5408\u304c\u3042\u308b\u305f\u3081\u3001\u5fc5\u8981\u306a\u6574\u5f62\u306f\u624b\u9806\u5074\u3067\u7ba1\u7406\u3057\u307e\u3059\u3002<\/p>\n

\u30ef\u30af\u3061\u3083\u3093\uff1a\u300c\u6765\u6708\u306e\u81ea\u5206\u306b\u3001\u624b\u9806\u3092\u66f8\u3044\u305f\u5f15\u304d\u7d99\u304e\u30e1\u30e2\u3092\u6e21\u3059\u611f\u3058\uff1f\u300d<\/span><\/div>\n
\u30c1\u30e3\u30d4\u5409\uff1a\u300c\u5143\u306e\u5217\u69cb\u6210\u304c\u5909\u308f\u3063\u305f\u3068\u304d\u306f\u3001\u305d\u306e\u624b\u9806\u3082\u898b\u76f4\u305d\u3046\u306d\u300d<\/span><\/div>\n

\u95a2\u9023\u8a18\u4e8b<\/h2>\n

Excel\u5370\u52371\u679a\u306b\u53ce\u3081\u308b\u306e\u3084\u308a\u65b9\uff5c\u30c7\u30fc\u30bf\u3092\u5b88\u308b\u6e96\u5099\u3068\u78ba\u8a8d\u30dd\u30a4\u30f3\u30c8<\/a><\/p>\n

\u30ef\u30fc\u30c9\u30a8\u30af\u30bb\u30eb\u4f7f\u3044\u65b9\u306f\u3069\u3046\u64cd\u4f5c\u3059\u308b\uff1f\u76ee\u7684\u5225\u306e\u624b\u9806\u3068\u3064\u307e\u305a\u304d\u5bfe\u7b56<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Excel\u306ePower Query\u306f\u3001\u30c7\u30fc\u30bf\u3092\u53d6\u308a\u8fbc\u307f\u3001\u5217\u306e\u6574\u7406\u306a\u3069\u306e\u624b\u9806\u3092\u8a18\u9332\u3057\u3066\u66f4\u65b0\u6642\u306b\u7e70\u308a\u8fd4\u3059\u6a5f\u80fd\u3067\u3059\u3002\u6bce\u56de\u540c\u3058\u5f62\u306b\u6574\u3048\u308b\u8868\u306b\u5411\u3044\u3066\u3044\u307e\u3059\u3002\u5143\u30c7\u30fc\u30bf\u3092\u76f4\u63a5\u66f8\u304d\u63db\u3048\u308b\u306e\u3067\u306f\u306a\u304f\u3001\u53d6\u308a\u8fbc\u3093\u3060\u7d50\u679c\u3092\u52a0 … <\/p>\n","protected":false},"author":1,"featured_media":39362,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","columnck":"","stmeta_robots":"","st_titlewords":"","st_title_extra":"","st_keywords":"","st_description":"","st_display_ad_mark":"","st_display_ad_mark_hide":"","textcopyck":"","st_copyright":"","st_copyurl":"","eyecatch_set":"","st_youtube_url":"","st_youtube_eyecatch":"","headerwidget_set":"","updatewidget_set":"","kanrenwidget_set":"","ikkatuwidget_set":"","koukoku_set":"","auto_adsense_koukoku_set":"","st_redirect":"","st_redirect_url_as_canonical":"","st_redirect_pvm_do_not_track":"","post_data_updatewidget_set":"","st_post_header_under_bg":"","st_twitter_tag":"","affinger_note":"","rankdisplayck":"","st_head_code":"","st_footer_code":"","st_post_header_under_code":""},"categories":[47],"tags":[],"class_list":["post-39361","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-wakuchan-zatsugaku"],"_links":{"self":[{"href":"https:\/\/www.wakukichi.com\/index.php?rest_route=\/wp\/v2\/posts\/39361","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wakukichi.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wakukichi.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wakukichi.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wakukichi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=39361"}],"version-history":[{"count":1,"href":"https:\/\/www.wakukichi.com\/index.php?rest_route=\/wp\/v2\/posts\/39361\/revisions"}],"predecessor-version":[{"id":39372,"href":"https:\/\/www.wakukichi.com\/index.php?rest_route=\/wp\/v2\/posts\/39361\/revisions\/39372"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wakukichi.com\/index.php?rest_route=\/wp\/v2\/media\/39362"}],"wp:attachment":[{"href":"https:\/\/www.wakukichi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=39361"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wakukichi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=39361"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wakukichi.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=39361"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}