{"id":3130,"date":"2023-11-13T11:16:22","date_gmt":"2023-11-13T11:16:22","guid":{"rendered":"https:\/\/exceladvisor.org\/ja\/%e9%9b%bb%e5%8a%9b%e8%a6%81%e6%b1%82\/"},"modified":"2023-12-07T04:46:32","modified_gmt":"2023-12-07T04:46:32","slug":"%e9%9b%bb%e5%8a%9b%e8%a6%81%e6%b1%82","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/ja\/%e9%9b%bb%e5%8a%9b%e8%a6%81%e6%b1%82\/","title":{"rendered":"Excel power \u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u200c \u30af\u30a8\u30ea (\u53d6\u5f97\u3068\u5909\u63db)"},"content":{"rendered":"<div class=\"excel-\" id=\"excel-3904804385\"><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> <p>\u3042\u306a\u305f\u304c\u30c7\u30fc\u30bf\u3092\u983b\u7e41\u306b\u6271\u3046\u4eba\u3067\u3042\u308c\u3070\u3001\u8ab0\u3067\u3082 (<a href=\"https:\/\/exceladvisor.org\/ja\/\u4f1a\u8a08\u58eb\u5411\u3051\u306e\u30a8\u30af\u30bb\u30eb\/\">\u4f1a\u8a08\u58eb<\/a>\u3001\u4eba\u4e8b\u3001\u30c7\u30fc\u30bf \u30a2\u30ca\u30ea\u30b9\u30c8\u306a\u3069)\u3001PowerQuery \u304c\u5f37\u529b\u306a\u30c4\u30fc\u30eb\u306b\u306a\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002<\/p><p>\u672c\u984c\u306b\u5165\u308a\u307e\u3059\u304c\u3001Power Query \u306f\u3001\u5b66\u7fd2\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b<a href=\"https:\/\/exceladvisor.org\/ja\/\u30a8\u30af\u30bb\u30eb\u30b9\u30ad\u30eb\/\">\u9ad8\u5ea6\u306a Excel \u30b9\u30ad\u30eb<\/a>\u306e 1 \u3064\u3067\u3059\u3002\u3053\u306e\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3067\u306f\u3001PowerQuery \u3092\u8a73\u3057\u304f\u8abf\u3079\u3001PowerQuery \u3092\u4f7f\u7528\u3057\u3066\u30c7\u30fc\u30bf\u3092\u5909\u63db\u3059\u308b\u65b9\u6cd5\u3092\u5b66\u7fd2\u3057\u307e\u3059\u3002<\/p><p>\u59cb\u3081\u307e\u3057\u3087\u3046\u3002<\/p><h2 class=\"wp-block-heading\"> Excel\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3068\u306f\u4f55\u3067\u3059\u304b<\/h2><p>Power Query \u306f\u3001ETL \u306b\u4f7f\u7528\u3067\u304d\u308b Excel \u30a2\u30c9\u30a4\u30f3\u3067\u3059\u3002\u3064\u307e\u308a\u3001\u3055\u307e\u3056\u307e\u306a\u30bd\u30fc\u30b9\u304b\u3089<strong>\u30c7\u30fc\u30bf\u3092\u62bd\u51fa\u3057<\/strong>\u3001<strong>\u5909\u63db\u3057\u3066<\/strong>\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b<strong>\u8aad\u307f\u8fbc\u3080\u3053\u3068<\/strong>\u304c\u3067\u304d\u307e\u3059\u3002 POWER QUERY \u306f\u3001\u30c7\u30fc\u30bf\u3092\u5909\u63db\u3059\u308b\u305f\u3081\u306e\u3059\u3079\u3066\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u5099\u3048\u3066\u3044\u308b\u305f\u3081\u3001\u30c7\u30fc\u30bf \u30af\u30ea\u30fc\u30cb\u30f3\u30b0 \u30de\u30b7\u30f3\u3067\u3042\u308b\u3068\u8a00\u3048\u307e\u3059\u3002\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u3067\u3042\u3089\u3086\u308b\u30b9\u30c6\u30c3\u30d7\u3092\u8a18\u9332\u3057\u307e\u3059\u3002<\/p><h2 class=\"wp-block-heading\"> Power Query \u3092\u4f7f\u7528\u3059\u308b\u7406\u7531 (\u5229\u70b9)?<\/h2><p>\u3053\u306e\u8cea\u554f\u3092\u5ff5\u982d\u306b\u7f6e\u3044\u3066\u3044\u308b\u5834\u5408\u306f\u3001\u6b21\u306e\u3088\u3046\u306a\u79c1\u306e\u7b54\u3048\u304c\u3042\u308a\u307e\u3059\u3002<\/p><ul><li><strong>\u3055\u307e\u3056\u307e\u306a\u30c7\u30fc\u30bf \u30bd\u30fc\u30b9<\/strong>: <a href=\"https:\/\/exceladvisor.org\/ja\/xlsx\u304b\u3089csv\u3078\u306e\u5909\u63db\/\">CSV<\/a> \u3001TXT\u3001JSON \u306a\u3069\u306e\u3055\u307e\u3056\u307e\u306a\u30c7\u30fc\u30bf \u30bd\u30fc\u30b9\u304b\u3089\u5f37\u529b\u306a\u30af\u30a8\u30ea \u30a8\u30c7\u30a3\u30bf\u30fc\u306b\u30c7\u30fc\u30bf\u3092\u30ed\u30fc\u30c9\u3067\u304d\u307e\u3059\u3002<\/li><li>\u30c7\u30fc\u30bf\u3092\u7c21\u5358\u306b\u5909\u63db: \u901a\u5e38\u3001\u30c7\u30fc\u30bf\u5909\u63db\u306b\u306f\u6570\u5f0f\u3084\u30d4\u30dc\u30c3\u30c8 \u30c6\u30fc\u30d6\u30eb\u3092\u4f7f\u7528\u3057\u307e\u3059\u304c\u3001POWER QUERY \u3092\u4f7f\u7528\u3059\u308b\u3068\u3001\u6570\u56de\u30af\u30ea\u30c3\u30af\u3059\u308b\u3060\u3051\u3067\u591a\u304f\u306e\u4f5c\u696d\u3092\u884c\u3046\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/li><li>\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u3067\u3059\u3002\u30af\u30a8\u30ea\u3092\u4e00\u5ea6\u4f5c\u6210\u3059\u308b\u3068\u3001\u30c7\u30fc\u30bf\u306b\u5909\u66f4\u304c\u3042\u308b\u305f\u3073\u306b\u30af\u30a8\u30ea\u3092\u66f4\u65b0\u3067\u304d\u3001\u66f4\u65b0\u3057\u305f\u65b0\u3057\u3044\u30c7\u30fc\u30bf\u304c\u5909\u63db\u3055\u308c\u307e\u3059\u3002<\/li><\/ul><p>\u4f8b\u3092\u5171\u6709\u3057\u307e\u3057\u3087\u3046:<\/p><p> 100 \u90fd\u5e02\u306e\u30c7\u30fc\u30bf\u3092\u542b\u3080 100 \u500b\u306e Excel \u30d5\u30a1\u30a4\u30eb\u304c\u3042\u308a\u3001\u4e0a\u53f8\u304c\u305d\u308c\u3089 100 \u500b\u306e\u30d5\u30a1\u30a4\u30eb\u306e\u3059\u3079\u3066\u306e\u30c7\u30fc\u30bf\u3092\u542b\u3080\u30ec\u30dd\u30fc\u30c8\u3092\u4f5c\u6210\u3059\u308b\u3088\u3046\u306b\u8981\u6c42\u3057\u3066\u3044\u308b\u3068\u60f3\u50cf\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u5404\u30d5\u30a1\u30a4\u30eb\u3092\u624b\u52d5\u3067\u958b\u304d\u3001\u3053\u308c\u3089\u306e\u30d5\u30a1\u30a4\u30eb\u304b\u3089\u30c7\u30fc\u30bf\u3092\u30b3\u30d4\u30fc\u3057\u3066\u8cbc\u308a\u4ed8\u3051\u308b\u3053\u3068\u306b\u3057\u305f\u5834\u5408\u3001\u305d\u308c\u306b\u306f\u5c11\u306a\u304f\u3068\u3082 1 \u6642\u9593\u306f\u304b\u304b\u308a\u307e\u3059\u3002<\/p><p>\u3057\u304b\u3057\u3001Power Query \u3092\u4f7f\u7528\u3059\u308b\u3068\u3001\u6570\u5206\u3067\u305d\u308c\u3092\u884c\u3046\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u8208\u596e\u3057\u3066\u3044\u307e\u3059\u304b\uff1f\u826f\u3044\u3002<\/p><p>\u3053\u306e\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u306e\u5f8c\u534a\u3067\u306f\u3001\u591a\u304f\u306e\u4f8b\u3092\u4f7f\u7528\u3057\u3066 Power Query \u306e\u4f7f\u7528\u65b9\u6cd5\u3092\u5b66\u7fd2\u3057\u307e\u3059\u304c\u3001\u6700\u521d\u306b\u305d\u306e\u6982\u5ff5\u3092\u7406\u89e3\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p><h2 class=\"wp-block-heading\">\u96fb\u529b\u9700\u8981\u306e\u6982\u5ff5<\/h2><p>\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3092\u5b66\u3076\u306b\u306f\u3001\u6b21\u306e 3 \u3064\u306e\u30b9\u30c6\u30c3\u30d7\u3067\u6a5f\u80fd\u3059\u308b\u305d\u306e\u6982\u5ff5\u3092\u7406\u89e3\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p><h3 class=\"wp-block-heading has-text-align-left\"> 1. \u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308b<\/h3><p>Power Query \u3092\u4f7f\u7528\u3059\u308b\u3068\u3001Web\u3001CSV\u3001\u30c6\u30ad\u30b9\u30c8 \u30d5\u30a1\u30a4\u30eb\u30011 \u3064\u306e\u30d5\u30a9\u30eb\u30c0\u30fc\u304b\u3089\u306e\u8907\u6570\u306e\u30d6\u30c3\u30af\u306a\u3069\u3001\u3055\u307e\u3056\u307e\u306a\u30bd\u30fc\u30b9\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u305f\u308a\u3001\u30c7\u30fc\u30bf\u3092\u4fdd\u5b58\u3067\u304d\u308b\u305d\u306e\u4ed6\u306e\u591a\u304f\u306e\u30bd\u30fc\u30b9\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u305f\u308a\u3067\u304d\u307e\u3059\u3002<\/p><h3 class=\"wp-block-heading\"> 2. \u30c7\u30fc\u30bf\u3092\u5909\u63db\u3059\u308b<\/h3><p>\u30c7\u30fc\u30bf\u3092\u30d1\u30ef\u30fc \u30af\u30a8\u30ea\u306b\u53d6\u308a\u8fbc\u3093\u3060\u5f8c\u306f\u3001\u30c7\u30fc\u30bf\u3092\u5909\u63db\u3057\u3066\u30af\u30ea\u30fc\u30f3\u30a2\u30c3\u30d7\u3059\u308b\u305f\u3081\u306b\u4f7f\u7528\u3067\u304d\u308b\u30aa\u30d7\u30b7\u30e7\u30f3\u304c\u591a\u6570\u3042\u308a\u307e\u3059\u3002\u5b9f\u884c\u3059\u308b\u3059\u3079\u3066\u306e\u30b9\u30c6\u30c3\u30d7 (\u30b9\u30c6\u30c3\u30d7\u3054\u3068\u306b\u9806\u756a\u306b) \u306b\u5bfe\u3059\u308b\u30af\u30a8\u30ea\u304c\u4f5c\u6210\u3055\u308c\u307e\u3059\u3002<\/p><h3 class=\"wp-block-heading\"> 3. \u30c7\u30fc\u30bf\u306e\u30ed\u30fc\u30c9<\/h3><p>\u30a2\u30c9\u30d0\u30f3\u30b9\u30c8 \u30af\u30a8\u30ea \u30a8\u30c7\u30a3\u30bf\u30fc\u304b\u3089\u3001\u5909\u63db\u3055\u308c\u305f\u30c7\u30fc\u30bf\u3092\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u306b\u8aad\u307f\u8fbc\u3093\u3060\u308a\u3001\u30d4\u30dc\u30c3\u30c8\u30c6\u30fc\u30d6\u30eb\u3084\u30d4\u30dc\u30c3\u30c8\u30b0\u30e9\u30d5\u3092\u76f4\u63a5\u4f5c\u6210\u3057\u305f\u308a\u3001\u30c7\u30fc\u30bf\u306e\u307f\u306e\u63a5\u7d9a\u3092\u4f5c\u6210\u3057\u305f\u308a\u3067\u304d\u307e\u3059\u3002<\/p><h2 class=\"wp-block-heading\"> Power Query \u306f\u3069\u3053\u306b\u3042\u308a\u307e\u3059\u304b (\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u65b9\u6cd5)?<\/h2><p>\u4ee5\u4e0b\u3067\u306f\u3001\u3055\u307e\u3056\u307e\u306a\u30d0\u30fc\u30b8\u30e7\u30f3\u306e Microsoft Excel \u306b Power Query Access \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u65b9\u6cd5\u3092\u793a\u3057\u307e\u3059\u3002<\/p><h3 class=\"wp-block-heading\">\u30a8\u30af\u30bb\u30eb2007<\/h3><p> Excel 2007 \u3092\u4f7f\u7528\u3057\u3066\u3044\u308b\u5834\u5408\u306f\u3001\u7533\u3057\u8a33\u3042\u308a\u307e\u305b\u3093\u304c\u3001\u3053\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3067\u306f<strong>PQ \u304c\u5229\u7528\u3067\u304d\u306a\u3044<\/strong>\u305f\u3081\u3001 <code>latest version<\/code>\u306e Excel (Excel for Office 365\u3001Excel 2019\u3001Excel 2016\u3001Excel 2013\u3001Excel 2010) \u306b\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47480\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/requete-de-puissance-excel-2007.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u30a8\u30af\u30bb\u30eb-2007\" width=\"502\" height=\"161\"><\/figure><\/div><h3 class=\"wp-block-heading\"> Excel 2010 \u304a\u3088\u3073 Excel 2013<\/h3><p> 2010 \u304a\u3088\u3073 2013 \u306e\u5834\u5408\u306f<a href=\"https:\/\/www.microsoft.com\/en-in\/download\/details.aspx?id=39379\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" this link  (opens in a new tab)\"><strong>\u3001\u3053\u306e\u30ea\u30f3\u30af<\/strong><\/a>\u304b\u3089\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3067\u304d\u308b<strong>\u30a2\u30c9\u30a4\u30f3\u3092\u500b\u5225\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059<\/strong>\u3002\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u3068\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b Excel \u30ea\u30dc\u30f3\u306b\u65b0\u3057\u3044\u30bf\u30d6\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47487\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/requete-de-puissance-excel-2013-2010.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u30a8\u30af\u30bb\u30eb-2013-2010\" width=\"594\" height=\"110\"><\/figure><\/div><ul><li>\u307e\u305a\u306f\u3001\u3053\u3061\u3089\uff08Microsoft\u516c\u5f0f\u30b5\u30a4\u30c8\uff09\u304b\u3089\u30a2\u30c9\u30a4\u30f3\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u307e\u3059\u3002<\/li><li>\u30d5\u30a1\u30a4\u30eb\u304c\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3055\u308c\u305f\u3089\u3001\u305d\u308c\u3092\u958b\u3044\u3066\u6307\u793a\u306b\u5f93\u3044\u307e\u3059\u3002<\/li><li>\u305d\u306e\u5f8c\u3001Excel \u30ea\u30dc\u30f3\u306b [Power Query] \u30bf\u30d6\u304c\u81ea\u52d5\u7684\u306b\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/li><\/ul><p>\u4f55\u3089\u304b\u306e\u7406\u7531\u3067\u3053\u306e\u300cPOWER QUERY\u300d\u30bf\u30d6\u304c\u8868\u793a\u3055\u308c\u306a\u3044\u5834\u5408\u3067\u3082\u3001\u5fc3\u914d\u3059\u308b\u5fc5\u8981\u306f\u3042\u308a\u307e\u305b\u3093\u3002 COM \u30a2\u30c9\u30a4\u30f3 \u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u4f7f\u7528\u3057\u3066\u8ffd\u52a0\u3067\u304d\u307e\u3059\u3002<\/p><ul><li> [\u30d5\u30a1\u30a4\u30eb] \u30bf\u30d6 \u279c [\u30aa\u30d7\u30b7\u30e7\u30f3] \u279c [\u30a2\u30c9\u30a4\u30f3] \u306b\u79fb\u52d5\u3057\u307e\u3059\u3002 <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47299\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-complements-com-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"com-\u88dc\u6570-1\" width=\"277\" height=\"84\"><\/figure><\/div><ul><li> \u300c\u30a2\u30c9\u30a4\u30f3\u300d\u30aa\u30d7\u30b7\u30e7\u30f3\u3067\u300cCOM \u30a2\u30c9\u30a4\u30f3\u300d\u3092\u9078\u629e\u3057\u3001\u300cGO\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li><li>\u305d\u306e\u5f8c\u3001\u300cMicrosoft Power Query for Excel\u300d\u30dc\u30c3\u30af\u30b9\u306b\u30c1\u30a7\u30c3\u30af\u3092\u5165\u308c\u307e\u3059\u3002 <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47300\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-coche-microsoft-power-query-pour-excel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30c6\u30a3\u30c3\u30af\u30de\u30fc\u30af-microsoft-power-query-for-excel-1\" width=\"208\" height=\"112\"><\/figure><\/div><ul><li>\u6700\u5f8c\u306b\u3001\u300cOK\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li><\/ul><h3 class=\"wp-block-heading\"> Excel 2016\u30012019\u3001Office 365<\/h3><p> Excel 2016\u3001Excel 2019 \u3092\u4f7f\u7528\u3057\u3066\u3044\u308b\u5834\u5408\u3001\u307e\u305f\u306f OFFICE 365 \u30b5\u30d6\u30b9\u30af\u30ea\u30d7\u30b7\u30e7\u30f3\u3092\u6240\u6709\u3057\u3066\u3044\u308b\u5834\u5408\u306f\u3001\u300cGET &amp; TRANSFORM\u300d\u3068\u3044\u3046\u540d\u524d\u306e\u30b0\u30eb\u30fc\u30d7\u3068\u3057\u3066<strong>[\u30c7\u30fc\u30bf] \u30bf\u30d6\u306b\u3059\u3067\u306b\u5b58\u5728\u3057\u307e\u3059<\/strong>(\u3053\u306e\u540d\u524d\u306f\u6c17\u306b\u5165\u3063\u3066\u3044\u307e\u3059\u306d)\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47301\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-obtenir-et-transformer-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u53d6\u5f97\u3068\u5909\u63db-1\" width=\"576\" height=\"183\"><\/figure><\/div><h3 class=\"wp-block-heading\">\u30a8\u30af\u30bb\u30eb\u30fb\u30de\u30c3\u30af<\/h3><p>Mac \u3067 Excel \u3092\u4f7f\u7528\u3057\u3066\u3044\u308b\u5834\u5408\u3001\u6b8b\u5ff5\u306a\u304c\u3089\u3001\u3053\u308c\u7528\u306e\u30d1\u30ef\u30fc \u30af\u30a8\u30ea \u30a2\u30c9\u30a4\u30f3\u306f\u306a\u304f\u3001<strong>\u65e2\u5b58\u306e\u30af\u30a8\u30ea\u3092\u66f4\u65b0\u3059\u308b\u3053\u3068\u3057\u304b\u3067\u304d\u305a<\/strong>\u3001\u65b0\u3057\u3044\u30af\u30a8\u30ea\u3092\u4f5c\u6210\u3057\u305f\u308a\u3001\u30af\u30a8\u30ea\u3092\u7de8\u96c6\u3057\u305f\u308a\u3059\u308b\u3053\u3068\u3055\u3048\u3067\u304d\u307e\u305b\u3093 ( <a href=\"https:\/\/blog-insider.office.com\/2019\/05\/30\/you-asked-for-it-a-journey-to-power-query-in-excel-for-mac-starts-now\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>\u30ea\u30f3\u30af<\/strong><\/a>)\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47481\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/requete-de-puissance-excel-mac.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u30a8\u30af\u30bb\u30eb\u30de\u30c3\u30af\" width=\"570\" height=\"114\"><\/figure><\/div><h2 class=\"wp-block-heading\">\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u30a8\u30c7\u30a3\u30bf<\/h2><p>Power Query \u306b\u306f\u72ec\u81ea\u306e\u30a8\u30c7\u30a3\u30bf\u30fc\u304c\u3042\u308a\u3001\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u3001\u30af\u30a8\u30ea\u3092\u4f5c\u6210\u3059\u308b\u3059\u3079\u3066\u306e\u624b\u9806\u3092\u5b9f\u884c\u3057\u3066\u3001\u305d\u308c\u3092\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u8aad\u307f\u8fbc\u3080\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002 Power Query \u30a8\u30c7\u30a3\u30bf\u30fc\u3092\u958b\u304f\u306b\u306f\u3001[\u30c7\u30fc\u30bf] \u30bf\u30d6\u306b\u79fb\u52d5\u3057\u3001[\u53d6\u5f97\u3068\u5909\u63db] \u279c [\u30c7\u30fc\u30bf\u306e\u53d6\u5f97] \u279c [Power Query \u30a8\u30c7\u30a3\u30bf\u30fc\u306e\u8d77\u52d5] \u306b\u79fb\u52d5\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47302\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-lancer-lediteur-de-requete-puissant-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u8d77\u52d5\u96fb\u6e90\u30af\u30a8\u30ea\u30a8\u30c7\u30a3\u30bf-1\" width=\"343\" height=\"467\"><\/figure><\/div><p>\u4ee5\u4e0b\u306f\u3001\u30a8\u30c7\u30a3\u30bf\u3092\u958b\u3044\u305f\u3068\u304d\u306b\u8868\u793a\u3055\u308c\u308b\u6700\u521d\u306e\u30d7\u30ec\u30d3\u30e5\u30fc\u3067\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47303\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-premier-regard-de-lediteur.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u7de8\u96c6\u8005\u306e\u521d\u898b\" width=\"601\" height=\"321\"><\/figure><\/div><p>\u305d\u308c\u3067\u306f\u3001\u5404\u30bb\u30af\u30b7\u30e7\u30f3\u3092\u8a73\u3057\u304f\u898b\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p><h3 class=\"wp-block-heading\"> 1.\u30ea\u30dc\u30f3<\/h3><p>\u5229\u7528\u53ef\u80fd\u306a\u3059\u3079\u3066\u306e\u30bf\u30d6\u3092\u898b\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p><ul><li><strong>\u30d5\u30a1\u30a4\u30eb:<\/strong> [\u30d5\u30a1\u30a4\u30eb] \u30bf\u30d6\u304b\u3089\u3001\u30c7\u30fc\u30bf\u3092\u30ed\u30fc\u30c9\u3057\u3001\u30a8\u30c7\u30a3\u30bf\u30fc\u3092\u524a\u9664\u3057\u3001\u30af\u30a8\u30ea \u30d1\u30e9\u30e1\u30fc\u30bf\u30fc\u3092\u958b\u304f\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/li><li><strong>\u30db\u30fc\u30e0<\/strong>: [\u30db\u30fc\u30e0] \u30bf\u30d6\u306b\u306f\u3001\u5217\u3084\u884c\u306e\u524a\u9664\u3001\u79fb\u52d5\u306a\u3069\u3001\u30ed\u30fc\u30c9\u3055\u308c\u305f\u30c7\u30fc\u30bf\u3092\u7ba1\u7406\u3059\u308b\u305f\u3081\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u304c\u3042\u308a\u307e\u3059\u3002<\/li><li><strong>\u5909\u63db<\/strong>: \u3053\u306e\u30bf\u30d6\u306b\u306f\u3001\u5217\u306e\u7d50\u5408\u3001\u8ee2\u7f6e\u306a\u3069\u3001\u30c7\u30fc\u30bf\u306e\u5909\u63db\u3068\u30af\u30ea\u30fc\u30f3\u30a2\u30c3\u30d7\u306b\u5fc5\u8981\u306a\u3059\u3079\u3066\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u304c\u542b\u307e\u308c\u3066\u3044\u307e\u3059\u3002<\/li><li><strong>\u5217\u306e\u8ffd\u52a0<\/strong>: \u3053\u3053\u3067\u306f\u3001\u9ad8\u5ea6\u306a\u30a8\u30c7\u30a3\u30bf\u30fc\u306b\u3042\u308b\u30c7\u30fc\u30bf\u306b\u65b0\u3057\u3044\u5217\u3092\u8ffd\u52a0\u3059\u308b\u30aa\u30d7\u30b7\u30e7\u30f3\u304c\u3042\u308a\u307e\u3059\u3002<\/li><li><strong>\u30d3\u30e5\u30fc<\/strong>: \u3053\u306e\u30bf\u30d6\u304b\u3089\u3001\u30a2\u30c9\u30d0\u30f3\u30b9\u30c8 \u30af\u30a8\u30ea \u30a8\u30c7\u30a3\u30bf\u30fc \u30d3\u30e5\u30fc\u3068\u30ed\u30fc\u30c9\u3055\u308c\u305f\u30c7\u30fc\u30bf\u3092\u5909\u66f4\u3067\u304d\u307e\u3059\u3002<\/li><\/ul><h3 class=\"wp-block-heading\"> 2. \u9069\u7528\u3055\u308c\u308b\u624b\u9806<\/h3><p>\u30a8\u30c7\u30a3\u30bf\u30fc\u306e\u53f3\u5074\u306b\u306f\u3001\u30af\u30a8\u30ea\u540d\u3068\u30b7\u30fc\u30b1\u30f3\u30b9\u306b\u9069\u7528\u3055\u308c\u308b\u3059\u3079\u3066\u306e\u30b9\u30c6\u30c3\u30d7\u3092\u542b\u3080\u30af\u30a8\u30ea\u8a2d\u5b9a\u30da\u30a4\u30f3\u304c\u3042\u308a\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47304\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-volet-de-parametrage-des-requetes-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u9069\u7528\u3055\u308c\u305f\u30b9\u30c6\u30c3\u30d7\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u306e\u30ea\u30b9\u30c8\" width=\"238\" height=\"290\"><\/figure><\/div><p>\u30b9\u30c6\u30c3\u30d7\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u540d\u524d\u5909\u66f4\u3001\u524a\u9664\u3001\u7de8\u96c6\u3001\u4e0a\u4e0b\u3078\u306e\u79fb\u52d5\u306a\u3069\u3092\u5b9f\u884c\u3067\u304d\u308b\u30aa\u30d7\u30b7\u30e7\u30f3\u306e\u30ea\u30b9\u30c8\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u30b9\u30c6\u30c3\u30d7\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u30a8\u30c7\u30a3\u30bf\u30fc\u306b\u3088\u3063\u3066\u305d\u306e\u30b9\u30c6\u30c3\u30d7\u3067\u884c\u308f\u308c\u305f\u5909\u63db\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47305\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-etapes-appliquees-liste-doptions.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u9069\u7528\u3055\u308c\u305f\u30b9\u30c6\u30c3\u30d7\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u306e\u30ea\u30b9\u30c8\" width=\"247\" height=\"342\"><\/figure><\/div><p>\u5408\u8a08 5 \u3064\u306e\u30b9\u30c6\u30c3\u30d7\u3059\u3079\u3066\u3092\u9069\u7528\u3057\u305f\u4ee5\u4e0b\u3092\u898b\u3066\u304f\u3060\u3055\u3044\u30024 \u756a\u76ee\u306e\u30b9\u30c6\u30c3\u30d7\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u5217\u540d\u304c\u5909\u66f4\u3055\u308c\u3066\u3044\u306a\u3044\u30b9\u30c6\u30c3\u30d7 4 \u306e\u5909\u63db\u306b\u79fb\u52d5\u3057\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47306\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-au-total-cinq-etapes-appliquees.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u5408\u8a08 5 \u3064\u306e\u30b9\u30c6\u30c3\u30d7\u3092\u9069\u7528\" width=\"661\" height=\"226\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 3. \u8cea\u554f<\/h3><p>\u5de6\u5074\u306e\u30af\u30a8\u30ea \u30da\u30a4\u30f3\u306b\u306f\u3001\u30ef\u30fc\u30af\u30d6\u30c3\u30af\u5185\u306b\u73fe\u5728\u5b58\u5728\u3059\u308b\u3059\u3079\u3066\u306e\u30af\u30a8\u30ea\u304c\u30ea\u30b9\u30c8\u3055\u308c\u307e\u3059\u3002\u57fa\u672c\u7684\u306b\u3001\u3059\u3079\u3066\u306e\u30af\u30a8\u30ea\u3092\u7ba1\u7406\u3067\u304d\u308b\u5834\u6240\u3067\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47307\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-le-volet-des-requetes.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30af\u30a8\u30ea\u30da\u30a4\u30f3\" width=\"178\" height=\"288\"><\/figure><\/div><p>\u30af\u30a8\u30ea\u540d\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u4f7f\u7528\u3067\u304d\u308b\u3059\u3079\u3066\u306e\u30aa\u30d7\u30b7\u30e7\u30f3 (\u30b3\u30d4\u30fc\u3001\u524a\u9664\u3001\u8907\u88fd\u306a\u3069) \u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47308\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-clic-droit-sur-un-nom-de-requete.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30af\u30a8\u30ea\u540d\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\" width=\"254\" height=\"349\"><\/figure><\/div><p>\u30af\u30a8\u30ea \u30da\u30a4\u30f3\u306e\u7a7a\u306e\u30b9\u30da\u30fc\u30b9\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3001\u30c7\u30fc\u30bf \u30bd\u30fc\u30b9\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u9078\u629e\u3059\u308b\u3060\u3051\u3067\u3001\u65b0\u3057\u3044\u30af\u30a8\u30ea\u3092\u4f5c\u6210\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47309\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-espace-vide-dans-le-volet-des-requetes.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30af\u30a8\u30ea\u30da\u30a4\u30f3\u306e\u7a7a\u306e\u30b9\u30da\u30fc\u30b9\" width=\"361\" height=\"381\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 4. \u6570\u5f0f\u30d0\u30fc<\/h3><p>\u5148\u307b\u3069\u3082\u8ff0\u3079\u305f\u3088\u3046\u306b\u3001\u30a8\u30c7\u30a3\u30bf\u30fc\u3067\u30b9\u30c6\u30c3\u30d7\u3092\u9069\u7528\u3059\u308b\u305f\u3073\u306b\u3001\u305d\u306e\u30b9\u30c6\u30c3\u30d7\u306e M \u30b3\u30fc\u30c9\u304c\u751f\u6210\u3055\u308c\u3001\u3053\u306e\u30b3\u30fc\u30c9\u304c\u6570\u5f0f\u30d0\u30fc\u306b\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u6570\u5f0f\u30d0\u30fc\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3060\u3051\u3067\u30b3\u30fc\u30c9\u3092\u7de8\u96c6\u3067\u304d\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47310\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/12-barre-de-formule.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u6570\u5f0f\u30d0\u30fc\" width=\"423\" height=\"33\"><\/figure><\/div><p> M \u30b3\u30fc\u30c9\u306e\u4f7f\u7528\u65b9\u6cd5\u3092\u5b66\u7fd2\u3057\u305f\u3089\u3001\u30b3\u30fc\u30c9\u3092\u8a18\u8ff0\u3057\u3066\u300cFX\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3060\u3051\u3067\u30ab\u30b9\u30bf\u30e0 \u30b9\u30c6\u30c3\u30d7\u3092\u5165\u529b\u3059\u308b\u3060\u3051\u3067\u30b9\u30c6\u30c3\u30d7\u3092\u4f5c\u6210\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47311\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/13-bouton-FX.png\" sizes=\"auto, \" srcset=\"\" alt=\"FX\u30dc\u30bf\u30f3\" width=\"168\" height=\"94\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 5. \u30c7\u30fc\u30bf\u306e\u6982\u8981<\/h3><p>\u30c7\u30fc\u30bf \u30d7\u30ec\u30d3\u30e5\u30fc\u9818\u57df\u306f Excel \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u3088\u3046\u306b\u898b\u3048\u307e\u3059\u304c\u3001\u30bb\u30eb\u3084\u30c7\u30fc\u30bf\u3092\u76f4\u63a5\u7de8\u96c6\u3067\u304d\u308b\u901a\u5e38\u306e\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3068\u306f\u5c11\u3057\u7570\u306a\u308a\u307e\u3059\u3002\u30a8\u30c7\u30a3\u30bf\u30fc\u306b\u30c7\u30fc\u30bf\u3092\u30ed\u30fc\u30c9\u3059\u308b\u3068 (\u3053\u308c\u306b\u3064\u3044\u3066\u306f\u5f8c\u307b\u3069\u8aac\u660e\u3057\u307e\u3059)\u3001\u3059\u3079\u3066\u306e\u5217\u304c\u5217\u540d\u3092\u542b\u3080\u30d8\u30c3\u30c0\u30fc\u3068\u3068\u3082\u306b\u8868\u793a\u3055\u308c\u3001\u6b21\u306b\u30c7\u30fc\u30bf\u304c\u542b\u307e\u308c\u308b\u884c\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47312\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/14-la-zone-de-previsualisation-des-donnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30c7\u30fc\u30bf\u30d7\u30ec\u30d3\u30e5\u30fc\u30a8\u30ea\u30a2\" width=\"189\" height=\"268\"><\/figure><\/div><p>\u5404\u5217\u306e\u4e0a\u90e8\u306b\u3001\u5217\u306e\u30c7\u30fc\u30bf\u306e\u30c7\u30fc\u30bf\u578b\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u30a8\u30c7\u30a3\u30bf\u30fc\u306b\u30c7\u30fc\u30bf\u3092\u30ed\u30fc\u30c9\u3059\u308b\u3068\u3001\u30a2\u30c9\u30d0\u30f3\u30b9\u30c8 \u30af\u30a8\u30ea\u306f\u5404\u5217\u306b\u6b63\u3057\u3044\u30c7\u30fc\u30bf\u578b\u3092 (\u307b\u307c\u6bce\u56de) \u81ea\u52d5\u7684\u306b\u9069\u7528\u3057\u307e\u3059\u3002<\/p><p>\u5217\u30d8\u30c3\u30c0\u30fc\u306e\u5de6\u4e0a\u306b\u3042\u308b\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u3001\u5217\u306b\u9069\u7528\u3055\u308c\u308b\u30c7\u30fc\u30bf\u578b\u3092\u5909\u66f4\u3067\u304d\u307e\u3059\u3002\u3053\u308c\u306b\u306f\u3001\u63cf\u753b\u3067\u304d\u308b\u3059\u3079\u3066\u306e\u30c7\u30fc\u30bf\u578b\u306e\u30ea\u30b9\u30c8\u304c\u542b\u307e\u308c\u3066\u3044\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47314\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/15-bouton-en-haut-a-gauche-sur-len-tete-de-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u5217\u30d8\u30c3\u30c0\u30fc\u306e\u5de6\u4e0a\u306b\u3042\u308b\u30dc\u30bf\u30f3\" width=\"369\" height=\"376\"><\/figure><\/div><p>\u5217\u30d8\u30c3\u30c0\u30fc\u306e\u5de6\u5074\u306b\u306f\u3001\u5217\u306e\u5024\u3092\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u3059\u308b\u305f\u3081\u306b\u4f7f\u7528\u3067\u304d\u308b\u30d5\u30a3\u30eb\u30bf \u30dc\u30bf\u30f3\u304c\u3042\u308a\u307e\u3059\u3002<strong>\u6ce8:<\/strong>\u5217\u306e\u5024\u3092\u30d5\u30a3\u30eb\u30bf\u30fc\u3059\u308b\u3068\u3001\u9ad8\u5ea6\u306a\u30af\u30a8\u30ea\u306f\u305d\u308c\u3092 1 \u3064\u306e\u30b9\u30c6\u30c3\u30d7\u3068\u3057\u3066\u307f\u306a\u3057\u3001[\u9069\u7528\u3055\u308c\u305f\u30b9\u30c6\u30c3\u30d7] \u306b\u30ea\u30b9\u30c8\u3057\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47316\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/16-le-cote-gauche-de-len-tete-de-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u5217\u306e\u5de6\u5074\u306e\u30d8\u30c3\u30c0\u30fc\" width=\"390\" height=\"329\"><\/figure><\/div><p>\u5217\u30d8\u30c3\u30c0\u30fc\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u30c7\u30fc\u30bf\u3092\u5909\u63db\u3057\u3001\u9069\u7528\u3055\u308c\u305f\u30d7\u30ed\u30bb\u30b9\u306e\u30b9\u30c6\u30c3\u30d7\u3068\u3057\u3066\u4fdd\u5b58\u3055\u308c\u3066\u3044\u308b\u30aa\u30d7\u30b7\u30e7\u30f3\u3068 PQ \u306e 1 \u3064\u3092\u4f7f\u7528\u3059\u308b\u305f\u3081\u306b\u4f7f\u7528\u3067\u304d\u308b\u30aa\u30d7\u30b7\u30e7\u30f3\u306e\u30ea\u30b9\u30c8\u3092\u542b\u3080\u30e1\u30cb\u30e5\u30fc\u304c\u3042\u308b\u3053\u3068\u304c\u308f\u304b\u308a\u307e\u3059\u3002\u306a\u3044\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47319\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/17-clic-droit-sur-len-tete-de-la-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u5217\u30d8\u30c3\u30c0\u30fc\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\" width=\"368\" height=\"505\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Power Query \u306e\u30c7\u30fc\u30bf \u30bd\u30fc\u30b9<\/h2><p>Power Query \u306e\u6700\u3082\u512a\u308c\u305f\u70b9\u306f\u3001\u8907\u6570\u306e\u30bd\u30fc\u30b9\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u3001\u305d\u306e\u30c7\u30fc\u30bf\u3092\u5909\u63db\u3057\u3066\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u8aad\u307f\u8fbc\u3080\u3053\u3068\u304c\u3067\u304d\u308b\u3053\u3068\u3067\u3059\u3002 \u300cGET &amp; TRANSFORM\u300d\u3067<strong>\u300cGet Data\u300d<\/strong>\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u30a8\u30c7\u30a3\u30bf\u30fc\u306b\u30ed\u30fc\u30c9\u3067\u304d\u308b\u30c7\u30fc\u30bf \u30bd\u30fc\u30b9\u306e\u5b8c\u5168\u306a\u30ea\u30b9\u30c8\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47320\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/18-la-possibilite-dobtenir-des-donnees-a-partir-de-plusieurs-sources.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u8907\u6570\u306e\u30bd\u30fc\u30b9\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308b\u30aa\u30d7\u30b7\u30e7\u30f3\" width=\"272\" height=\"491\"><\/figure><\/div><p>\u6b21\u306b\u3001\u30c7\u30fc\u30bf \u30bd\u30fc\u30b9\u306e\u3044\u304f\u3064\u304b\u3092\u898b\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p><ul><li><strong>\u30c6\u30fc\u30d6\u30eb\/\u7bc4\u56f2\u304b\u3089<\/strong>: \u3053\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u4f7f\u7528\u3059\u308b\u3068\u3001\u30a2\u30af\u30c6\u30a3\u30d6\u306a\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u304b\u3089\u76f4\u63a5\u30a2\u30c9\u30d0\u30f3\u30b9\u30c8 \u30af\u30a8\u30ea \u30a8\u30c7\u30a3\u30bf\u30fc\u306b\u30c7\u30fc\u30bf\u3092\u30ed\u30fc\u30c9\u3067\u304d\u307e\u3059\u3002<\/li><li><strong>\u30ef\u30fc\u30af\u30d6\u30c3\u30af\u304b\u3089<\/strong>: \u30b3\u30f3\u30d4\u30e5\u30fc\u30bf\u30fc\u4e0a\u306b\u3042\u308b\u5225\u306e\u30ef\u30fc\u30af\u30d6\u30c3\u30af\u304b\u3089\u3002\u958b\u304f\u30c0\u30a4\u30a2\u30ed\u30b0 \u30dc\u30c3\u30af\u30b9\u3092\u4f7f\u7528\u3057\u3066\u3053\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u898b\u3064\u3051\u308b\u3060\u3051\u3067\u3001\u3053\u306e\u30d5\u30a1\u30a4\u30eb\u304b\u3089\u30c7\u30fc\u30bf\u304c\u81ea\u52d5\u7684\u306b\u53d6\u5f97\u3055\u308c\u307e\u3059\u3002<\/li><li><strong>\u30c6\u30ad\u30b9\u30c8\/CSV \u304b\u3089<\/strong>: \u30c6\u30ad\u30b9\u30c8 \u30d5\u30a1\u30a4\u30eb\u307e\u305f\u306f\u30ab\u30f3\u30de\u533a\u5207\u308a\u30d5\u30a1\u30a4\u30eb\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u30ed\u30fc\u30c9\u3067\u304d\u307e\u3059\u3002<\/li><li> <strong>From Folder<\/strong> : \u30d5\u30a9\u30eb\u30c0\u30fc\u304b\u3089\u3059\u3079\u3066\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u53d6\u5f97\u3057\u3001\u5f37\u529b\u306a\u30af\u30a8\u30ea \u30a8\u30c7\u30a3\u30bf\u30fc\u3067\u30c7\u30fc\u30bf\u3092\u30b5\u30dd\u30fc\u30c8\u3057\u307e\u3059\u3002 (\u3053\u3061\u3089\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044: 1 \u3064\u306e\u30d5\u30a9\u30eb\u30c0\u30fc\u304b\u3089 Excel \u30d5\u30a1\u30a4\u30eb\u3092\u7d50\u5408\u3059\u308b)\u3002<\/li><li> <strong>Web \u304b\u3089<\/strong>: \u3053\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u4f7f\u7528\u3059\u308b\u3068\u3001Web \u30a2\u30c9\u30ec\u30b9\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002Web \u4e0a\u306b\u4fdd\u5b58\u3055\u308c\u3066\u3044\u308b\u30d5\u30a1\u30a4\u30eb\u304c\u3042\u308b\u304b\u3001\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b Web \u30da\u30fc\u30b8\u304c\u3042\u308b\u3068\u60f3\u50cf\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/li><\/ul><h2 class=\"wp-block-heading\"> Power Query \u30a8\u30c7\u30a3\u30bf\u30fc\u306b\u30c7\u30fc\u30bf\u3092\u8aad\u307f\u8fbc\u3080\u65b9\u6cd5<\/h2><p>\u6b21\u306b\u3001\u5f37\u529b\u306a\u30af\u30a8\u30ea \u30a8\u30c7\u30a3\u30bf\u30fc\u306b\u30c7\u30fc\u30bf\u3092\u8aad\u307f\u8fbc\u3080\u65b9\u6cd5\u3092\u5b66\u3073\u307e\u3057\u3087\u3046\u3002\u3053\u3053\u306b\u306f\u751f\u5f92\u306e\u540d\u524d\u3068\u305d\u306e\u5f97\u70b9\u306e\u30ea\u30b9\u30c8\u304c\u3042\u308a\u307e\u3059 ( <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/donnees-des-etudiants.xlsx\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"LINK (opens in a new tab)\"><strong>\u30ea\u30f3\u30af<\/strong><\/a>)\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47321\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/19-apprendre-a-charger-des-donnees-dans-lediteur-de-requete-puissant.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u5f37\u529b\u306a\u30af\u30a8\u30ea \u30a8\u30c7\u30a3\u30bf\u30fc\u306b\u30c7\u30fc\u30bf\u3092\u30ed\u30fc\u30c9\u3059\u308b\u65b9\u6cd5\u3092\u5b66\u3076\" width=\"329\" height=\"323\"><\/figure><\/div><p>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u30c7\u30fc\u30bf\u3092\u76f4\u63a5\u30ed\u30fc\u30c9\u3059\u308b\u305f\u3081\u3001\u6700\u521d\u306b\u30d5\u30a1\u30a4\u30eb\u3092\u958b\u3044\u3066\u304b\u3089\u3001\u6b21\u306e\u624b\u9806\u306b\u5f93\u3046\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p><ul><li>\u307e\u305a\u3001Excel \u30c6\u30fc\u30d6\u30eb\u3092\u30c7\u30fc\u30bf\u306b\u9069\u7528\u3057\u307e\u3059 (\u9069\u7528\u3057\u306a\u3044\u5834\u5408\u3067\u3082\u3001\u30c7\u30fc\u30bf\u3092 PQ \u30a8\u30c7\u30a3\u30bf\u30fc\u306b\u30ed\u30fc\u30c9\u3059\u308b\u524d\u306b Excel \u304c\u81ea\u52d5\u7684\u306b\u9069\u7528\u3057\u307e\u3059)\u3002<\/li><li>\u6b21\u306b\u3001\u30c6\u30fc\u30d6\u30eb\u5185\u306e\u30bb\u30eb\u3092\u9078\u629e\u3057\u3001\u300c\u30c6\u30fc\u30d6\u30eb\/\u7bc4\u56f2\u304b\u3089\u300d(\u300c\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u3068\u5909\u63db\u300d\u30bf\u30d6)\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002 <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47322\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/20-cliquez-sur-la-plage-de-la-table-de-depart.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30c6\u30fc\u30d6\u30eb\u7bc4\u56f2\u3092\u30af\u30ea\u30c3\u30af\" width=\"329\" height=\"172\"><\/figure><\/div><ul><li>\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001Excel \u306f Excel \u30c6\u30fc\u30d6\u30eb\u3092\u9069\u7528\u3059\u308b\u30c7\u30fc\u30bf\u7bc4\u56f2\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002 <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47323\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/21-la-plage-de-donnees-pour-appliquer-un-tableau-excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel \u30c6\u30fc\u30d6\u30eb\u3092\u9069\u7528\u3059\u308b\u30c7\u30fc\u30bf\u7bc4\u56f2\" width=\"284\" height=\"167\"><\/figure><\/div><ul><li>\u3053\u306e\u6642\u70b9\u3067 Power Query \u30a8\u30c7\u30a3\u30bf\u30fc\u306b\u30c7\u30fc\u30bf\u304c\u3042\u308a\u3001\u6b21\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002 <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47324\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/22-les-donnees-dans-lediteur-de-requete-puissant.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u5f37\u529b\u306a\u30af\u30a8\u30ea\u30a8\u30c7\u30a3\u30bf\u30fc\u306e\u30c7\u30fc\u30bf\" width=\"678\" height=\"365\"><\/figure><\/div><ul><li>\u3053\u3053\u3067\u898b\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059:<ul><li>\u6570\u5f0f\u30d0\u30fc\u3067\u306f\u3001PQ \u306f\u30a8\u30c7\u30a3\u30bf\u30fc\u306b\u30ed\u30fc\u30c9\u3057\u305f\u3070\u304b\u308a\u306e\u30c6\u30fc\u30d6\u30eb\u306e M \u30b3\u30fc\u30c9\u3092\u751f\u6210\u3057\u307e\u3057\u305f\u3002<\/li><li>\u30a8\u30c7\u30a3\u30bf\u30fc\u306e\u5de6\u5074\u306b\u306f\u30af\u30a8\u30ea \u30da\u30a4\u30f3\u304c\u3042\u308a\u3001\u305d\u3053\u306b\u30af\u30a8\u30ea\u306e\u30ea\u30b9\u30c8\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/li><li>\u53f3\u5074\u306e\u30af\u30a8\u30ea\u8a2d\u5b9a\u306b\u306f\u3001\u300c\u9069\u7528\u3055\u308c\u305f\u30b9\u30c6\u30c3\u30d7\u300d\u3068\u3044\u3046\u30bb\u30af\u30b7\u30e7\u30f3\u304c\u3042\u308a\u3001\u3059\u3079\u3066\u306e\u30b9\u30c6\u30c3\u30d7\u304c\u30ea\u30b9\u30c8\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u6ce8: \u300c\u30bf\u30a4\u30d7\u306e\u5909\u66f4\u300d\u3092\u4f55\u3082\u884c\u3063\u3066\u3044\u306a\u3044\u3068\u601d\u308f\u308c\u307e\u3059\u304c\u3001\u300c\u30bf\u30a4\u30d7\u306e\u5909\u66f4\u300d\u3068\u3044\u3046\u30b9\u30c6\u30c3\u30d7\u304c\u3042\u308a\u307e\u3059\u3002 <strong>POWER QUERY \u306e\u30a4\u30f3\u30c6\u30ea\u30b8\u30a7\u30f3\u30b9\u306b\u3064\u3044\u3066<\/strong>\u8aac\u660e\u3057\u307e\u3059\u3002\u30a8\u30c7\u30a3\u30bf\u30fc\u306b\u30c7\u30fc\u30bf\u3092\u30ed\u30fc\u30c9\u3059\u308b\u3068\u3001\u3059\u3079\u3066\u306e\u5217\u306b\u6b63\u3057\u3044\u30c7\u30fc\u30bf\u578b\u304c\u81ea\u52d5\u7684\u306b\u30c1\u30a7\u30c3\u30af\u3055\u308c\u3001\u9069\u7528\u3055\u308c\u307e\u3059\u3002 <\/li><\/ul><\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47325\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/23-barres-de-formule-pq.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u5f0f-\u30d0\u30fc-pq\" width=\"802\" height=\"373\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Power Query \u306e\u4f8b (\u30d2\u30f3\u30c8\u3068\u30b3\u30c4)<\/h2><p>\u901a\u5e38 Excel \u306e\u95a2\u6570\u5f0f\u3092\u4f7f\u7528\u3057\u3066\u884c\u3046\u57fa\u672c\u7684\u306a\u30bf\u30b9\u30af\u306e\u3044\u304f\u3064\u304b\u3092\u5b9f\u884c\u3059\u308b\u65b9\u6cd5\u3092\u5b66\u3076\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u304c\u3001PowerQuery \u3092\u4f7f\u7528\u3059\u308b\u3068\u3001\u6570\u56de\u30af\u30ea\u30c3\u30af\u3059\u308b\u3060\u3051\u3067\u5b9f\u884c\u3067\u304d\u307e\u3059\u3002 <\/p><div id=\"ub-content-toggle-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle\" data-mobilecollapse=\"false\" data-desktopcollapse=\"true\"><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-0-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 1. \u5024\u3092\u7f6e\u304d\u63db\u3048\u308b<\/h3><\/div><div id=\"ub-content-toggle-panel-0-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p>\u5024\u306e\u30ea\u30b9\u30c8\u304c\u3042\u308a\u30011 \u3064\u4ee5\u4e0a\u306e\u5024\u3092\u5225\u306e\u5024\u306b\u7f6e\u304d\u63db\u3048\u305f\u3044\u3068\u8003\u3048\u3066\u3044\u307e\u3059\u3002 <strong>Power Query<\/strong>\u3092\u4f7f\u7528\u3059\u308b\u3068\u3001\u30af\u30a8\u30ea\u3092\u4f5c\u6210\u3057\u3066\u3053\u308c\u3089\u306e\u5024\u3092\u3059\u3050\u306b\u7f6e\u304d\u63db\u3048\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p><p>\u4ee5\u4e0b\u306e\u30ea\u30b9\u30c8\u3067\u3001\u79c1\u306e\u540d\u524d\u300cPuneet\u300d\u3092\u300cPunit\u300d\u306b\u7f6e\u304d\u63db\u3048\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47329\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/24-liste-de-valeurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u5024\u306e\u30ea\u30b9\u30c8\" width=\"133\" height=\"299\"><\/figure><\/div><ul><li>\u307e\u305a\u3001\u9ad8\u5ea6\u306a\u30af\u30a8\u30ea \u30a8\u30c7\u30a3\u30bf\u30fc\u3067\u30ea\u30b9\u30c8\u3092\u7de8\u96c6\u3057\u307e\u3059\u3002<\/li><li>\u305d\u306e\u5f8c\u3001Power Query \u30a8\u30c7\u30a3\u30bf\u30fc\u3067 [\u5909\u63db] \u30bf\u30d6\u306b\u79fb\u52d5\u3057\u3001[\u5024\u306e\u7f6e\u63db] \u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002 <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47330\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/25-onglet-de-transformation.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u5909\u63db\u30bf\u30d6\" width=\"479\" height=\"135\"><\/figure><\/div><ul><li> \u300c\u691c\u7d22\u3059\u308b\u5024\u300d\u306b\u300cPuneet\u300d\u3068\u5165\u529b\u3057\u3001\u300c\u7f6e\u63db\u5f8c\u306e\u6587\u5b57\u5217\u300d\u306b\u300cPunit\u300d\u3068\u5165\u529b\u3057\u3066\u3001\u300cOK\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002 <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47331\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/26-valeur-a-trouver.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u898b\u3064\u3051\u308b\u4fa1\u5024\" width=\"350\" height=\"183\"><\/figure><\/div><ul><li> \u300cOK\u300d\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u3059\u3079\u3066\u306e\u5024\u304c\u65b0\u3057\u3044\u5024\u306b\u7f6e\u304d\u63db\u3048\u3089\u308c\u3001\u300c\u9589\u3058\u3066\u30ed\u30fc\u30c9\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u30c7\u30fc\u30bf\u3092\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u30ed\u30fc\u30c9\u3057\u307e\u3059\u3002 <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47332\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/27-fermer-et-charger.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u9589\u3058\u3066\u30ed\u30fc\u30c9\u3059\u308b\" width=\"213\" height=\"376\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-1-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 2. \u30c7\u30fc\u30bf\u306e\u4e26\u3079\u66ff\u3048<\/h3><\/div><div id=\"ub-content-toggle-panel-1-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p>\u901a\u5e38\u306e\u4e26\u3079\u66ff\u3048\u3068\u540c\u69d8\u306b\u3001PowerQuery \u3092\u4f7f\u7528\u3057\u3066\u30c7\u30fc\u30bf\u3092\u4e26\u3079\u66ff\u3048\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u3053\u3053\u3067\u306f\u3001\u4e0a\u306e\u4f8b\u3067\u4f7f\u7528\u3057\u305f\u3082\u306e\u3068\u540c\u3058\u540d\u524d\u306e\u30ea\u30b9\u30c8\u3092\u4f7f\u7528\u3057\u3066\u3044\u307e\u3059\u3002<\/p><ul><li>\u307e\u305a\u3001\u5f37\u529b\u306a\u30af\u30a8\u30ea \u30a8\u30c7\u30a3\u30bf\u30fc\u306b\u30c7\u30fc\u30bf\u3092\u30ed\u30fc\u30c9\u3057\u307e\u3059\u3002<\/li><li> \u300c\u30db\u30fc\u30e0\u300d\u30bf\u30d6\u306b\u306f\u30012 \u3064\u306e\u4e26\u3079\u66ff\u3048\u30dc\u30bf\u30f3 (\u6607\u9806\u3068\u964d\u9806) \u304c\u3042\u308a\u307e\u3059\u3002<\/li><li>\u3053\u308c\u3089\u306e\u30dc\u30bf\u30f3\u306e\u3044\u305a\u308c\u304b\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u4e26\u3079\u66ff\u3048\u307e\u3059\u3002 <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47333\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/28-deux-boutons-de-tri.png\" sizes=\"auto, \" srcset=\"\" alt=\"2 \u3064\u306e\u4e26\u3079\u66ff\u3048\u30dc\u30bf\u30f3\" width=\"487\" height=\"135\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-2-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 3. \u5217\u306e\u524a\u9664<\/h3><\/div><div id=\"ub-content-toggle-panel-2-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p>\u3069\u3053\u304b\u306b\u30c7\u30fc\u30bf\u304c\u3042\u308a\u3001\u305d\u3053\u304b\u3089\u3044\u304f\u3064\u304b\u306e\u5217\u3092\u524a\u9664\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u3068\u3057\u307e\u3059\u3002\u91cd\u8981\u306a\u306e\u306f\u3001\u65b0\u3057\u3044\u30c7\u30fc\u30bf\u3092\u8ffd\u52a0\u3059\u308b\u305f\u3073\u306b\u3053\u308c\u3089\u306e\u5217\u3092\u524a\u9664\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u3068\u3044\u3046\u3053\u3068\u3067\u3059\u3088\u306d\u3002\u305f\u3060\u3057\u3001power query \u3092\u4f7f\u7528\u3059\u308b\u3068\u305d\u308c\u3092\u89e3\u6c7a\u3067\u304d\u307e\u3059\u3002<\/p><ul><li><span style=\"font-size: inherit; background-color: initial;\">\u524a\u9664\u3059\u308b\u5217\u3092 1 \u3064\u307e\u305f\u306f\u8907\u6570\u9078\u629e\u3057\u307e\u3059\u3002<\/span> <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47334\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/29-donnees-ouvertes-dans-lediteur-de-requete-puissant.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u5f37\u529b\u306a\u30af\u30a8\u30ea\u30a8\u30c7\u30a3\u30bf\u3067\u30c7\u30fc\u30bf\u3092\u958b\u304f\" width=\"495\" height=\"248\"><\/figure><\/div><ul><li>\u6b21\u306b\u3001\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u300c\u524a\u9664\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002 <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47335\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/30-supprimer.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u64a4\u56de\u3059\u308b\" width=\"281\" height=\"228\"><\/figure><\/div><p><strong>\u30af\u30a4\u30c3\u30af\u30d2\u30f3\u30c8:<\/strong> \u300c\u4ed6\u306e\u5217\u3092\u524a\u9664\u300d\u30aa\u30d7\u30b7\u30e7\u30f3\u3082\u3042\u308a\u3001\u9078\u629e\u3055\u308c\u3066\u3044\u306a\u3044\u5217\u3092\u3059\u3079\u3066\u524a\u9664\u3067\u304d\u307e\u3059\u3002 <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-3-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 4. \u5217\u3092\u5206\u5272\u3059\u308b<\/h3><\/div><div id=\"ub-content-toggle-panel-3-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p>\u30c6\u30ad\u30b9\u30c8\u3092\u5217\u306b\u5909\u63db\u3059\u308b\u30aa\u30d7\u30b7\u30e7\u30f3\u3068\u540c\u69d8\u306b\u3001\u30d1\u30ef\u30fc \u30af\u30a8\u30ea\u306b\u306f\u300c\u5217\u306e\u5206\u5272\u300d\u304c\u3042\u308a\u307e\u3059\u3002\u305d\u308c\u304c\u3069\u306e\u3088\u3046\u306b\u6a5f\u80fd\u3059\u308b\u304b\u3092\u8aac\u660e\u3057\u307e\u3057\u3087\u3046\u3002<\/p><ul><li><span style=\"font-size: inherit; background-color: initial;\">\u5217\u3092\u9078\u629e\u3057\u3001\u300c\u30db\u30fc\u30e0\u300d\u30bf\u30d6 \u279c \u5909\u63db \u279c \u5217\u306e\u5206\u5272 \u279c \u533a\u5207\u308a\u6587\u5b57\u3067\u306e\u9806\u306b\u79fb\u52d5\u3057\u307e\u3059\u3002<\/span> <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47337\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/31-colonnes-divisees.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u5206\u5272\u5217\" width=\"578\" height=\"140\"><\/figure><\/div><ul><li>\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3\u30ea\u30b9\u30c8\u304b\u3089\u30ab\u30b9\u30bf\u30e0\u3092\u9078\u629e\u3057\u3001\u300c-\u300d\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/li><li>\u3053\u3053\u3067\u306f\u3001\u5217\u3092\u5206\u5272\u3059\u308b\u305f\u3081\u306e 3 \u3064\u306e\u7570\u306a\u308b\u30aa\u30d7\u30b7\u30e7\u30f3\u304c\u3042\u308a\u307e\u3059\u3002<ul><li>\u5de6\u7aef\u306e\u533a\u5207\u308a\u6587\u5b57<\/li><li>\u53f3\u7aef\u306e\u533a\u5207\u308a\u6587\u5b57<\/li><li>\u533a\u5207\u308a\u6587\u5b57\u304c\u51fa\u73fe\u3059\u308b\u305f\u3073\u306b<\/li><\/ul><\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47338\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/32-trois-options-differentes-pour-diviser-une-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u5217\u3092\u5206\u5272\u3059\u308b\u305f\u3081\u306e 3 \u3064\u306e\u7570\u306a\u308b\u30aa\u30d7\u30b7\u30e7\u30f3\" width=\"371\" height=\"252\"><\/figure><\/div><p>\u30bb\u30eb\u306b\u533a\u5207\u308a\u6587\u5b57\u304c 1 \u3064\u3057\u304b\u306a\u3044\u5834\u5408\u306f\u30013 \u3064\u3059\u3079\u3066\u304c\u540c\u3058\u3088\u3046\u306b\u6a5f\u80fd\u3057\u307e\u3059\u304c\u3001\u8907\u6570\u306e\u533a\u5207\u308a\u6587\u5b57\u304c\u3042\u308b\u5834\u5408\u306f\u3001\u305d\u308c\u306b\u5fdc\u3058\u3066\u9078\u629e\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47339\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/33-delimiteur-dans-une-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30bb\u30eb\u5185\u306e\u533a\u5207\u308a\" width=\"361\" height=\"290\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-4-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 5. \u5217\u306e\u540d\u524d\u3092\u5909\u66f4\u3059\u308b<\/h3><\/div><div id=\"ub-content-toggle-panel-4-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p>\u5217\u306e\u540d\u524d\u3092\u5909\u66f4\u3059\u308b\u306b\u306f\u3001\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u300c\u540d\u524d\u306e\u5909\u66f4\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47340\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/34-renommer-une-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u5217\u306e\u540d\u524d\u3092\u5909\u66f4\u3059\u308b\" width=\"272\" height=\"121\"><\/figure><\/div><p><strong>\u30af\u30a4\u30c3\u30af \u30d2\u30f3\u30c8<\/strong>: \u5217\u306e\u540d\u524d\u3092\u5909\u66f4\u3059\u308b\u30af\u30a8\u30ea\u304c\u3042\u308a\u3001\u4ed6\u306e\u4eba\u304c\u8aa4\u3063\u3066\u305d\u306e\u540d\u524d\u3092\u5909\u66f4\u3057\u305f\u3068\u3057\u307e\u3059\u3002\u30ef\u30f3\u30af\u30ea\u30c3\u30af\u3067\u3053\u306e\u540d\u524d\u3092\u5fa9\u5143\u3067\u304d\u307e\u3059\u3002 <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-5-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 6. \u5217\u3092\u8907\u88fd\u3059\u308b<\/h3><\/div><div id=\"ub-content-toggle-panel-5-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Power Query \u306b\u306f\u3001\u91cd\u8907\u3057\u305f\u5217\u3092\u4f5c\u6210\u3059\u308b\u7c21\u5358\u306a\u30aa\u30d7\u30b7\u30e7\u30f3\u304c\u3042\u308a\u307e\u3059\u3002\u8907\u88fd\u5217\u3092\u4f5c\u6210\u3057\u305f\u3044\u5217\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3001\u300c\u5217\u306e\u8907\u88fd\u300d\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3060\u3051\u3067\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47341\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/35-creer-une-colonne-en-double.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u91cd\u8907\u5217\u306e\u4f5c\u6210\" width=\"280\" height=\"200\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-6-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 7. \u5217\u307e\u305f\u306f\u884c\u3092\u5165\u308c\u66ff\u3048\u308b<\/h3><\/div><div id=\"ub-content-toggle-panel-6-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p>\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3067\u306f\u3001\u8ee2\u7f6e\u306f\u7c21\u5358\u3067\u3059\u3002\u306f\u3044\u3001\u30ef\u30f3\u30af\u30ea\u30c3\u30af\u3059\u308b\u3060\u3051\u3067\u3059\u3002<\/p><ul><li>\u30c7\u30fc\u30bf\u3092\u30a2\u30c9\u30d0\u30f3\u30b9\u30c8 \u30af\u30a8\u30ea \u30a8\u30c7\u30a3\u30bf\u30fc\u306b\u30ed\u30fc\u30c9\u3057\u305f\u3089\u3001\u5fc5\u8981\u306a\u306e\u306f\u5217\u307e\u305f\u306f\u884c\u3092\u9078\u629e\u3059\u308b\u3053\u3068\u3060\u3051\u3067\u3059\u3002<\/li><li> [\u5909\u63db] \u30bf\u30d6 \u279c \u30c6\u30fc\u30d6\u30eb \u279c \u8ee2\u7f6e\u306e\u9806\u306b\u79fb\u52d5\u3057\u307e\u3059\u3002 <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47346\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/38-colonne-ou-ligne-de-transposition.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u5217\u307e\u305f\u306f\u884c\u306e\u8ee2\u7f6e\" width=\"341\" height=\"143\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-7-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 8. \u30a8\u30e9\u30fc\u306e\u7f6e\u63db\/\u524a\u9664<\/h3><\/div><div id=\"ub-content-toggle-panel-7-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p>\u901a\u5e38\u3001Excel \u3067\u30a8\u30e9\u30fc\u3092\u7f6e\u63db\u307e\u305f\u306f\u524a\u9664\u3059\u308b\u306b\u306f\u3001\u691c\u7d22\u3068\u7f6e\u63db\u30aa\u30d7\u30b7\u30e7\u30f3\u307e\u305f\u306f VBA \u30b3\u30fc\u30c9\u3092\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002\u3057\u304b\u3057\u3001PowerQuery \u3067\u306f\u305d\u308c\u304c\u306f\u308b\u304b\u306b\u7c21\u5358\u3067\u3059\u3002\u30a8\u30e9\u30fc\u306e\u3042\u308b\u4ee5\u4e0b\u306e\u5217\u3092\u78ba\u8a8d\u3057\u3001\u524a\u9664\u3057\u3066\u7f6e\u304d\u63db\u3048\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47347\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/39-remplacement-ou-suppression-des-erreurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30a8\u30e9\u30fc\u306e\u7f6e\u63db\u307e\u305f\u306f\u524a\u9664\" width=\"201\" height=\"282\"><\/figure><\/div><p>\u5217\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u4e21\u65b9\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p><ul><li>\u30a8\u30e9\u30fc\u3092\u7f6e\u63db\u3059\u308b<\/li><li>\u30a8\u30e9\u30fc\u3092\u524a\u9664\u3059\u308b<\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47348\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/40-remplacer-les-erreurs-supprimer-les-erreurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u7f6e\u63db\u30a8\u30e9\u30fc-\u524a\u9664\u30a8\u30e9\u30fc\" width=\"242\" height=\"262\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-8-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 9. \u30c7\u30fc\u30bf\u578b\u306e\u5909\u66f4<\/h3><\/div><div id=\"ub-content-toggle-panel-8-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p>\u5217\u306b\u30c7\u30fc\u30bf\u304c\u3042\u308a\u307e\u3059\u304c\u3001\u305d\u306e\u5f62\u5f0f\u304c\u6b63\u3057\u304f\u3042\u308a\u307e\u305b\u3093\u3002\u3057\u305f\u304c\u3063\u3066\u3001\u305d\u306e\u5f62\u5f0f\u3092\u5909\u66f4\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u305f\u3073\u306b\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47349\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/41-changer-le-type-de-donnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30c7\u30fc\u30bf\u578b\u3092\u5909\u66f4\u3059\u308b\" width=\"212\" height=\"240\"><\/figure><\/div><ul><li>\u307e\u305a\u3001\u5f37\u529b\u306a\u30af\u30a8\u30ea \u30a8\u30c7\u30a3\u30bf\u30fc\u3067\u30c7\u30fc\u30bf\u3092\u7de8\u96c6\u3057\u307e\u3059\u3002<\/li><li>\u305d\u306e\u5f8c\u3001\u5217\u3092\u9078\u629e\u3057\u3001\u300c\u5909\u63db\u300d\u30bf\u30d6\u306b\u79fb\u52d5\u3057\u307e\u3059\u3002<\/li><li>\u3053\u3053\u3067\u3001\u30c7\u30fc\u30bf\u30bf\u30a4\u30d7\u304b\u3089\u30bf\u30a4\u30d7\u3068\u3057\u3066\u300c\u65e5\u4ed8\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002 <\/li><\/ul><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-9-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 10. \u4f8b\u304b\u3089\u5217\u3092\u8ffd\u52a0\u3059\u308b<\/h3><\/div><div id=\"ub-content-toggle-panel-9-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p>\u9ad8\u5ea6\u306a\u30af\u30a8\u30ea\u306b\u306f\u3001\u5b9f\u969b\u306b\u306f\u73fe\u5728\u306e\u5217\u306b\u95a2\u9023\u3059\u308b\u4f8b\u3067\u306f\u306a\u3044\u4f8b\u306e\u5217\u3092\u8ffd\u52a0\u3059\u308b\u30aa\u30d7\u30b7\u30e7\u30f3\u304c\u3042\u308a\u307e\u3059\u3002<\/p><p>\u4f8b\u3092\u6319\u3052\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p><p>\u65e5\u4ed8\u5217\u304b\u3089\u66dc\u65e5\u306e\u540d\u524d\u304c\u5fc5\u8981\u3060\u3068\u60f3\u50cf\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u6570\u5f0f\u3084\u305d\u306e\u4ed6\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u4f7f\u7528\u3059\u308b\u4ee3\u308f\u308a\u306b\u3001\u300c\u4f8b\u304b\u3089\u5217\u3092\u8ffd\u52a0\u300d\u3092\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002<\/p><p>\u305d\u306e\u65b9\u6cd5\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p><ul><li><span style=\"font-size: inherit; background-color: initial;\">\u5217\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3001\u300c\u4f8b\u304b\u3089\u5217\u3092\u8ffd\u52a0\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/span> <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47350\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/42-ajouter-une-colonne-a-partir-dexemples.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u4f8b\u304b\u3089\u5217\u3092\u8ffd\u52a0\" width=\"271\" height=\"196\"><\/figure><\/div><ul><li>\u3053\u3053\u3067\u306f\u7a7a\u306e\u5217\u304c\u5f97\u3089\u308c\u307e\u3059\u3002\u5217\u306e\u6700\u521d\u306e\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u3001\u633f\u5165\u3067\u304d\u308b\u5024\u306e\u30ea\u30b9\u30c8\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002 <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47351\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/43-colonne-vide.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u7a7a\u306e\u5217\" width=\"253\" height=\"198\"><\/figure><\/div><ul><li> \u300c\u65e5\u4ed8\u304b\u3089\u306e\u66dc\u65e5\u540d\u300d\u3092\u9078\u629e\u3057\u3001\u300cOK\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002 <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47352\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/44-nom-du-jour-de-la-semaine-a-partir-de-la-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u66dc\u65e5\u65e5\u4ed8\u540d\" width=\"479\" height=\"286\"><\/figure><\/div><p><strong>\u30d6\u30fc\u30e0\uff01<\/strong>\u65b0\u3057\u3044\u30b3\u30e9\u30e0\u306f\u3053\u3053\u306b\u3042\u308a\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47353\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/45-nouvelle-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u65b0\u3057\u3044\u5217\" width=\"385\" height=\"257\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-10-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 11. \u30dc\u30c3\u30af\u30b9\u3092\u5909\u66f4\u3059\u308b<\/h3><\/div><div id=\"ub-content-toggle-panel-10-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> PowerQuery \u3067\u30c6\u30ad\u30b9\u30c8\u306e\u5927\u6587\u5b57\u3068\u5c0f\u6587\u5b57\u3092\u5909\u66f4\u3059\u308b\u306b\u306f\u3001\u6b21\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u304c\u3042\u308a\u307e\u3059\u3002<\/p><ul><li>\u5c0f\u3055\u3044<\/li><li>\u5927\u6587\u5b57<\/li><li>\u5404\u5358\u8a9e\u3092\u5927\u6587\u5b57\u306b\u3057\u307e\u3059<\/li><\/ul><p>\u3053\u308c\u3092\u884c\u3046\u306b\u306f\u3001\u5217\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3001\u4e0a\u8a18\u306e 3 \u3064\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u306e\u3044\u305a\u308c\u304b\u3092\u9078\u629e\u3057\u307e\u3059\u3002\u307e\u305f\u306f\u3001[\u5909\u63db] \u30bf\u30d6 \u279c [\u30c6\u30ad\u30b9\u30c8\u5217] \u279c [\u5f62\u5f0f] \u306b\u79fb\u52d5\u3057\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47354\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/46-cas-de-changement.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u5909\u5316\u306e\u5834\u5408\" width=\"241\" height=\"255\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-11-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 12. \u30c8\u30ea\u30df\u30f3\u30b0\u3057\u3066\u304d\u308c\u3044\u306b\u3059\u308b<\/h3><\/div><div id=\"ub-content-toggle-panel-11-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p>\u30c7\u30fc\u30bf\u3092\u6d88\u53bb\u3057\u305f\u308a\u3001\u4e0d\u8981\u306a\u30b9\u30da\u30fc\u30b9\u3092\u524a\u9664\u3057\u305f\u308a\u3059\u308b\u306b\u306f\u3001PowerQuery \u306e TRIM \u304a\u3088\u3073 CLEAN \u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002\u624b\u9806\u306f\u7c21\u5358\u3067\u3059\u3002<\/p><ul><li>\u5217\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3059\u308b\u304b\u3001\u8907\u6570\u306e\u5217\u304c\u3042\u308b\u5834\u5408\u306f\u3059\u3079\u3066\u306e\u5217\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/li><li> [\u5909\u63db] \u30bf\u30d6 \u279c [\u30c6\u30ad\u30b9\u30c8\u5217] \u279c [\u5f62\u5f0f] \u306b\u79fb\u52d5\u3057\u307e\u3059\u3002<ol><li> TRIM: \u30bb\u30eb\u306e\u5148\u982d\u3068\u672b\u5c3e\u304b\u3089\u7a7a\u767d\u3092\u524a\u9664\u3057\u307e\u3059\u3002<\/li><li> CLEAN: \u30bb\u30eb\u304b\u3089\u975e\u5370\u5237\u6587\u5b57\u3092\u524a\u9664\u3057\u307e\u3059\u3002 <\/li><\/ol><\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47355\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/47-tailler-et-nettoyer.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30c8\u30ea\u30df\u30f3\u30b0\u3057\u3066\u6383\u9664\u3059\u308b\" width=\"268\" height=\"275\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-12-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 13. \u30d7\u30ec\u30d5\u30a3\u30c3\u30af\u30b9\/\u30b5\u30d5\u30a3\u30c3\u30af\u30b9\u3092\u8ffd\u52a0\u3059\u308b<\/h3><\/div><div id=\"ub-content-toggle-panel-12-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p>\u3057\u305f\u304c\u3063\u3066\u3001\u5024\u306e\u30ea\u30b9\u30c8\u304c\u3042\u308a\u3001\u3053\u306e\u30ea\u30b9\u30c8\u304b\u3089\u5404\u30bb\u30eb\u306b\u63a5\u982d\u8f9e\/\u63a5\u5c3e\u8f9e\u3092\u8ffd\u52a0\u3057\u305f\u3044\u3068\u3057\u307e\u3059\u3002 Excel \u3067\u306f\u9023\u7d50\u65b9\u6cd5\u3092\u4f7f\u7528\u3067\u304d\u307e\u3059\u304c\u3001PowerQuery \u3067\u306f\u4e21\u65b9\u306b\u4f7f\u7528\u3067\u304d\u308b\u7c21\u5358\u306a\u30aa\u30d7\u30b7\u30e7\u30f3\u304c\u3042\u308a\u307e\u3059\u3002<\/p><ul><li>\u307e\u305a\u3001\u30d7\u30ec\u30d5\u30a3\u30c3\u30af\u30b9\/\u30b5\u30d5\u30a3\u30c3\u30af\u30b9\u3092\u8ffd\u52a0\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u5217\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/li><li>\u6b21\u306b\u3001 [\u5909\u63db] \u30bf\u30d6 \u279c \u30c6\u30ad\u30b9\u30c8\u5217 \u279c \u5f62\u5f0f \u279c \u63a5\u982d\u8f9e\u306e\u8ffd\u52a0\/\u63a5\u5c3e\u8f9e\u306e\u8ffd\u52a0 \u306b\u79fb\u52d5\u3057\u307e\u3059\u3002 <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47356\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/47-tailler-et-nettoyer-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30ab\u30c3\u30c8\u30a2\u30f3\u30c9\u30af\u30ea\u30fc\u30f3-1\" width=\"252\" height=\"259\"><\/figure><\/div><ul><li>\u3044\u305a\u308c\u304b\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u30c6\u30ad\u30b9\u30c8\u3092\u5165\u529b\u3059\u308b\u305f\u3081\u306e\u30c0\u30a4\u30a2\u30ed\u30b0 \u30dc\u30c3\u30af\u30b9\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002 <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47357\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/49-boite-de-dialogue-pour-saisir-du-texte.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30c6\u30ad\u30b9\u30c8\u3092\u5165\u529b\u3059\u308b\u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\" width=\"309\" height=\"130\"><\/figure><\/div><ul><li>\u305d\u3057\u3066\u3001\u30c6\u30ad\u30b9\u30c8\u3092\u5165\u529b\u3057\u305f\u3089\u3001\u300cOK\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002 <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47358\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/50-entrer-le-texte-cliquer-sur-ok.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30c6\u30ad\u30b9\u30c8\u3092\u5165\u529b-\u30af\u30ea\u30c3\u30af-OK\" width=\"182\" height=\"305\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-13-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 14. \u5024\u306e\u62bd\u51fa<\/h3><\/div><div id=\"ub-content-toggle-panel-13-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p>\u3042\u306a\u305f\u304c\u6570\u5f0f\u30de\u30cb\u30a2\u306a\u3089\u3001\u30bb\u30eb\u304b\u3089\u30c6\u30ad\u30b9\u30c8\u3084\u6570\u5024\u3092\u62bd\u51fa\u3059\u308b\u306b\u306f\u3055\u307e\u3056\u307e\u306a\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u5fc5\u8981\u304c\u3042\u308b\u3068\u3044\u3046\u3053\u3068\u306b\u540c\u610f\u3057\u3066\u3044\u305f\u3060\u3051\u308b\u3068\u601d\u3044\u307e\u3059\u3002\u3057\u304b\u3057\u3001PowerQuery \u306f\u3053\u308c\u3089\u306e\u554f\u984c\u306e\u591a\u304f\u3092\u89e3\u6c7a\u3057\u307e\u3057\u305f\u3002\u30bb\u30eb\u304b\u3089\u5024\u3092\u62bd\u51fa\u3059\u308b\u306b\u306f 7 \u3064\u306e\u65b9\u6cd5\u304c\u3042\u308a\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47359\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/51-valeurs-dextraction.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u5024\u3092\u62bd\u51fa\u3059\u308b\" width=\"247\" height=\"246\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-14-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 15. \u65e5\u4ed8\u307e\u305f\u306f\u6642\u523b\u306e\u307f<\/h3><\/div><div id=\"ub-content-toggle-panel-14-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p>\u65e5\u4ed8\u3068\u6642\u523b\u306e\u4e21\u65b9\u304c 1 \u3064\u306e\u30bb\u30eb\u306b\u542b\u307e\u308c\u3066\u3044\u308b\u306b\u3082\u304b\u304b\u308f\u3089\u305a\u3001\u3069\u3061\u3089\u304b\u4e00\u65b9\u304c\u5fc5\u8981\u306b\u306a\u308b\u3053\u3068\u304c\u3088\u304f\u3042\u308a\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47360\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/52-uniquement-la-date-ou-lheure.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u65e5\u4ed8\u307e\u305f\u306f\u6642\u523b\u306e\u307f\" width=\"180\" height=\"298\"><\/figure><\/div><ul><li>\u65e5\u4ed8\u3068\u6642\u523b\u3092\u7d44\u307f\u5408\u308f\u305b\u305f\u5217\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/li><li>\u3042\u306a\u305f\u304c\u671b\u3080\u306a\u3089\uff1a<ul><li><strong>\u65e5\u4ed8<\/strong>: \u53f3\u30af\u30ea\u30c3\u30af \u279c \u5909\u63db \u279c \u65e5\u4ed8\u306e\u307f\u3002<\/li><li><strong>\u6642\u9593<\/strong>: \u53f3\u30af\u30ea\u30c3\u30af \u279c \u5909\u63db \u279c \u6642\u9593\u306e\u307f\u3002 <\/li><\/ul><\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47361\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/53-si-vous-voulez-la-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30c7\u30fc\u30c8\u3057\u305f\u3044\u306a\u3089\" width=\"248\" height=\"173\"><\/figure><\/div><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47362\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/54-si-tu-veux-du-temps.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u6642\u9593\u304c\u6b32\u3057\u3044\u306a\u3089\" width=\"244\" height=\"168\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-15-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 16. \u65e5\u4ed8\u3068\u6642\u523b\u3092\u7d50\u5408\u3059\u308b<\/h3><\/div><div id=\"ub-content-toggle-panel-15-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p>\u3053\u308c\u3067\u3001\u65e5\u4ed8\u3068\u6642\u523b\u3092\u533a\u5207\u308b\u65b9\u6cd5\u304c\u308f\u304b\u308a\u307e\u3057\u305f\u3002\u3057\u304b\u3057\u6b21\u306b\u3001\u305d\u308c\u3089\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u65b9\u6cd5\u3092\u77e5\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47363\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/55-combiner-date-et-heure.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u65e5\u4ed8\u3068\u6642\u523b\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\" width=\"408\" height=\"256\"><\/figure><\/div><ul><li>\u307e\u305a\u3001\u65e5\u4ed8\u5217\u3092\u9078\u629e\u3057\u3001\u300c\u65e5\u4ed8\u306e\u307f\u300d\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li><li>\u305d\u306e\u5f8c\u3001\u4e21\u65b9\u306e\u5217 (\u65e5\u4ed8\u3068\u6642\u523b) \u3092\u9078\u629e\u3057\u3001[\u5909\u63db] \u30bf\u30d6\u306b\u79fb\u52d5\u3057\u3001[\u65e5\u4ed8\u3068\u6642\u523b\u306e\u5217] \u30b0\u30eb\u30fc\u30d7\u304b\u3089 [\u65e5\u4ed8] \u306b\u79fb\u52d5\u3057\u3001[\u65e5\u4ed8\u3068\u6642\u523b\u3092\u7d50\u5408] \u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002 <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47364\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/56-combiner-date-et-heure.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u65e5\u4ed8\u3068\u6642\u523b\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\" width=\"264\" height=\"352\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-16-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 17. \u56db\u6368\u4e94\u5165\u3055\u308c\u305f\u6570\u5b57<\/h3><\/div><div id=\"ub-content-toggle-panel-16-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p>\u6570\u5024\u3092\u56db\u6368\u4e94\u5165\u3059\u308b\u305f\u3081\u306b\u4f7f\u7528\u3067\u304d\u308b\u30aa\u30d7\u30b7\u30e7\u30f3\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p><ul><li>\u5207\u308a\u6368\u3066: \u6570\u5024\u3092\u5207\u308a\u6368\u3066\u308b\u3053\u3068\u3002<\/li><li>\u56db\u6368\u4e94\u5165: \u6570\u5024\u3092\u56db\u6368\u4e94\u5165\u3057\u307e\u3059\u3002<\/li><li>\u56db\u6368\u4e94\u5165: \u5c0f\u6570\u70b9\u4ee5\u4e0b\u306e\u6841\u3092\u3069\u3053\u307e\u3067\u56db\u6368\u4e94\u5165\u3067\u304d\u308b\u304b\u3092\u9078\u629e\u3067\u304d\u307e\u3059\u3002 <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47365\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/57-chiffres-arrondis.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u56db\u6368\u4e94\u5165\u3055\u308c\u305f\u6570\u5b57\" width=\"235\" height=\"175\"><\/figure><\/div><p>\u624b\u9806\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p><ul><li><span style=\"font-size: inherit; background-color: initial;\">\u5217\u3092\u9078\u629e\u3057\u3001\u53f3\u30af\u30ea\u30c3\u30af \u279c \u5909\u5f62 \u279c \u4e38\u3081 \u3092\u9078\u629e\u3057\u307e\u3059<\/span>\u3002<ol><li>\u5207\u308a\u6368\u3066: \u6570\u5024\u3092\u5207\u308a\u6368\u3066\u308b\u3053\u3068\u3002<\/li><li>\u56db\u6368\u4e94\u5165: \u6570\u5024\u3092\u56db\u6368\u4e94\u5165\u3057\u307e\u3059\u3002<\/li><li>\u56db\u6368\u4e94\u5165: \u5c0f\u6570\u70b9\u4ee5\u4e0b\u306e\u6841\u3092\u3069\u3053\u307e\u3067\u56db\u6368\u4e94\u5165\u3067\u304d\u308b\u304b\u3092\u9078\u629e\u3067\u304d\u307e\u3059\u3002<\/li><\/ol><\/li><\/ul><p><strong>\u6ce8:<\/strong> \u300c#3 \u56db\u6368\u4e94\u5165\u300d\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u9078\u629e\u3057\u305f\u5834\u5408\u306f\u3001\u56db\u6368\u4e94\u5165\u3059\u308b\u5c0f\u6570\u70b9\u4ee5\u4e0b\u306e\u6841\u6570\u3092\u5165\u529b\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002 <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-17-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 18. \u8a08\u7b97<\/h3><\/div><div id=\"ub-content-toggle-panel-17-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p>\u8a08\u7b97\u3092\u5b9f\u884c\u3059\u308b\u305f\u3081\u306b\u4f7f\u7528\u3067\u304d\u308b\u30aa\u30d7\u30b7\u30e7\u30f3\u304c\u3042\u308a\u307e\u3059 (\u591a\u6570\u3042\u308a\u307e\u3059)\u3002\u3053\u308c\u3089\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u306f\u3059\u3079\u3066\u3001[\u5909\u63db] \u30bf\u30d6 ([\u6570\u5024\u5217] \u30b0\u30eb\u30fc\u30d7\u5185) \u306b\u3042\u308a\u307e\u3059\u3002<\/p><ul><li>\u57fa\u672c<\/li><li>\u7d71\u8a08<\/li><li>\u79d1\u5b66\u8005<\/li><li>\u4e09\u89d2\u6cd5<\/li><li>\u30e9\u30a6\u30f3\u30c9<\/li><li>\u60c5\u5831<\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47366\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/58-calculs.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u8a08\u7b97\" width=\"274\" height=\"131\"><\/figure><\/div><p>\u3053\u308c\u3089\u306e\u8a08\u7b97\u3092\u5b9f\u884c\u3059\u308b\u306b\u306f\u3001\u5217\u3092\u9078\u629e\u3057\u3066\u304b\u3089\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u9078\u629e\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002 <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-18-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 19. \u30b0\u30eb\u30fc\u30d7\u5316<\/h3><\/div><div id=\"ub-content-toggle-panel-18-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p>\u5927\u898f\u6a21\u306a\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u304c\u3042\u308a\u3001\u8981\u7d04\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3057\u305f\u3044\u3068\u3057\u307e\u3059\u3002\u884c\u3046\u5fc5\u8981\u304c\u3042\u308b\u306e\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47367\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/59-grouper-par.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30b0\u30eb\u30fc\u30d7\u3054\u3068\u306b\" width=\"390\" height=\"294\"><\/figure><\/div><ul><li> [\u5909\u63db] \u30bf\u30d6\u3067 [\u30b0\u30eb\u30fc\u30d7\u5316] \u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u30c0\u30a4\u30a2\u30ed\u30b0 \u30dc\u30c3\u30af\u30b9\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002 <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47368\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/60-groupes-par-bouton.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30dc\u30bf\u30f3\u3054\u3068\u306b\u30b0\u30eb\u30fc\u30d7\u5316\" width=\"241\" height=\"142\"><\/figure><\/div><ul><li>\u3053\u306e\u30c0\u30a4\u30a2\u30ed\u30b0 \u30dc\u30c3\u30af\u30b9\u304b\u3089\u3001\u30b0\u30eb\u30fc\u30d7\u5316\u3059\u308b\u5217\u3092\u9078\u629e\u3057\u3001\u540d\u524d\u3092\u8ffd\u52a0\u3057\u3066\u3001\u64cd\u4f5c\u3068\u5024\u304c\u542b\u307e\u308c\u308b\u5217\u3092\u9078\u629e\u3057\u307e\u3059\u3002 <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47369\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/61-boite-de-dialogue-selectionner-la-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30c0\u30a4\u30a2\u30ed\u30b0\u9078\u629e\u5217\" width=\"461\" height=\"180\"><\/figure><\/div><ul><li>\u6700\u5f8c\u306b\u3001\u300cOK\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002 <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47370\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/62-a-la-fin-cliquez-sur-ok.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u6700\u5f8c\u306b\u300cOK\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\" width=\"268\" height=\"311\"><\/figure><\/div><p><strong>\u6ce8:<\/strong> \u300c\u30b0\u30eb\u30fc\u30d7\u5316\u300d\u30aa\u30d7\u30b7\u30e7\u30f3\u306b\u306f\u3001\u30de\u30eb\u30c1\u30ec\u30d9\u30eb\u306e\u30b0\u30eb\u30fc\u30d7 \u30c6\u30fc\u30d6\u30eb\u306e\u4f5c\u6210\u306b\u4f7f\u7528\u3067\u304d\u308b\u8a73\u7d30\u30aa\u30d7\u30b7\u30e7\u30f3\u3082\u3042\u308a\u307e\u3059\u3002 <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-19-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 20. \u8ca0\u306e\u5024\u3092\u524a\u9664\u3059\u308b<\/h3><\/div><div id=\"ub-content-toggle-panel-19-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p>\u79c1\u306e\u30d6\u30ed\u30b0\u6295\u7a3f\u306e 1 \u3064\u3067\u3001<a href=\"https:\/\/exceladvisor.org\/ja\/\u8ca0\u306e\u6570\u3092\u6b63\u306e\u6570\u306b\u5909\u66f4\u3059\u308b\/\">\u8ca0\u306e\u7b26\u53f7\u3092\u524a\u9664\u3059\u308b<\/a>7 \u3064\u306e\u65b9\u6cd5\u3092\u30ea\u30b9\u30c8\u3057\u307e\u3057\u305f\u3002\u30d1\u30ef\u30fc \u30af\u30a8\u30ea\u3082\u305d\u306e 1 \u3064\u3067\u3059\u3002\u5217\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u300c\u5909\u63db\u300d\u30aa\u30d7\u30b7\u30e7\u30f3\u306b\u79fb\u52d5\u3057\u3001\u300c\u7d76\u5bfe\u5024\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47371\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/63-supprimer-les-valeurs-negatives.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u8ca0\u306e\u5024\u3092\u524a\u9664\u3059\u308b\" width=\"447\" height=\"241\"><\/figure><\/div><p>\u3053\u308c\u306b\u3088\u308a\u3001\u5024\u304b\u3089\u3059\u3079\u3066\u306e\u8ca0\u306e\u7b26\u53f7\u304c\u5373\u5ea7\u306b\u524a\u9664\u3055\u308c\u307e\u3059\u3002 <\/p><\/div><\/div><\/div><div class=\"gb-container gb-container-ce6d6657\"><div class=\"gb-container gb-container-1fa1aae1\"><h3 class=\"gb-headline gb-headline-dbd5c92a gb-headline-text\">\u4ed6\u306e\u4f8b<\/h3><ol><li><a href=\"https:\/\/exceladvisor.org\/ja\/\u691c\u7d22v2\/\">Excel \u306e Power Query \u3067 VLOOKUP \u3092\u5b9f\u884c\u3059\u308b<\/a><\/li><li>Power Query \u3092\u4f7f\u7528\u3057\u3066\u30c7\u30fc\u30bf \u30d4\u30dc\u30c3\u30c8\u3092\u524a\u9664\u3059\u308b<\/li><li><a href=\"https:\/\/exceladvisor.org\/ja\/if-\u5ba3\u8a00\/\">Power Query \u306e IF \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8<\/a><\/li><li><a href=\"https:\/\/exceladvisor.org\/ja\/\u9396\/\">Power Query \u3092\u4f7f\u7528\u3057\u3066\u5024 (\u30c6\u30ad\u30b9\u30c8\u3068\u6570\u5024) \u3092\u9023\u7d50\u3059\u308b<\/a><\/li><li><a href=\"https:\/\/exceladvisor.org\/ja\/\u65e5\u4ed8\u306e\u9055\u3044\/\">Power Query \u3092\u4f7f\u7528\u3057\u3066\u65e5\u4ed8\u306e\u5dee\u3092\u8a08\u7b97\u3059\u308b<\/a><\/li><\/ol><\/div><\/div><h2 class=\"wp-block-heading\">\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u30c7\u30fc\u30bf\u3092\u30ed\u30fc\u30c9\u3059\u308b\u65b9\u6cd5<\/h2><p>\u30c7\u30fc\u30bf\u3092\u5909\u63db\u3057\u305f\u3089\u3001\u305d\u308c\u3092\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u30ed\u30fc\u30c9\u3057\u3066\u3001\u3055\u3089\u306a\u308b\u5206\u6790\u306b\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002\u30db\u30fc\u30e0 \u30bf\u30d6\u306b\u306f\u300c\u9589\u3058\u3066\u30ed\u30fc\u30c9\u300d\u3068\u3044\u3046\u30dc\u30bf\u30f3\u304c\u3042\u308a\u307e\u3059\u3002\u3053\u308c\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u8ffd\u52a0\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u63d0\u4f9b\u3059\u308b\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3 \u30ea\u30b9\u30c8\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p><ul><li>\u9589\u3058\u3066\u30ed\u30fc\u30c9\u3059\u308b<\/li><li>\u9589\u3058\u3066\u8aad\u307f\u8fbc\u3080<\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47372\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/64-fermer-et-charger-a.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30af\u30ed\u30fc\u30ba\u30a2\u30f3\u30c9\u30ed\u30fc\u30c9\" width=\"199\" height=\"224\"><\/figure><\/div><ul><li>\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u6b21\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002 <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47373\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/65-options-dimportation-de-donnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30c7\u30fc\u30bf\u30a4\u30f3\u30dd\u30fc\u30c8\u30aa\u30d7\u30b7\u30e7\u30f3\" width=\"276\" height=\"277\"><\/figure><\/div><ul><li>\u3053\u306e\u30c7\u30fc\u30bf\u3092\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u8868\u793a\u3059\u308b\u65b9\u6cd5\u3092\u9078\u629e\u3057\u307e\u3059\u3002<ul><li>\u7d75\u753b<\/li><li>\u30d4\u30dc\u30c3\u30c8\u30c6\u30fc\u30d6\u30eb\u30ec\u30dd\u30fc\u30c8:<\/li><li>\u30c6\u30fc\u30d6\u30eb\u30d4\u30dc\u30c3\u30c8<\/li><li>\u63a5\u7d9a\u3092 1 \u3064\u3060\u3051\u4f5c\u6210\u3059\u308b<\/li><li>\u30c7\u30fc\u30bf\u3092\u3069\u3053\u306b\u7f6e\u304d\u307e\u3059\u304b?<ul><li>\u65e2\u5b58\u306e\u30ef\u30fc\u30af\u30b7\u30fc\u30c8<\/li><li>\u65b0\u3057\u3044\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u3002<\/li><\/ul><\/li><li>\u3053\u306e\u30c7\u30fc\u30bf\u3092\u30c7\u30fc\u30bf \u30e2\u30c7\u30eb\u306b\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/li><\/ul><\/li><li>\u30c6\u30fc\u30d6\u30eb \u30aa\u30d7\u30b7\u30e7\u30f3\u3068\u65b0\u3057\u3044\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u3092\u9078\u629e\u3057\u3001\u30c7\u30fc\u30bf \u30e2\u30c7\u30eb\u306e\u30c1\u30a7\u30c3\u30af\u3092\u5916\u3057\u305f\u307e\u307e\u306b\u3057\u3066 [OK] \u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3060\u3051\u3067\u3059\u3002 <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47374\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/66-options-dimportation-de-donnees-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30c7\u30fc\u30bf\u30a4\u30f3\u30dd\u30fc\u30c8\u30aa\u30d7\u30b7\u30e7\u30f3-2\" width=\"298\" height=\"300\"><\/figure><\/div><ul><li> \u300cOK\u300d\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u30c7\u30fc\u30bf\u3092\u542b\u3080\u65b0\u3057\u3044\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u304c\u8ffd\u52a0\u3055\u308c\u307e\u3059\u3002 <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47375\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/67-nouvelle-feuille-de-calcul-avec-les-donnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30c7\u30fc\u30bf\u3092\u542b\u3080\u65b0\u3057\u3044\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\" width=\"333\" height=\"254\"><\/figure><\/div><p>\u3055\u3089\u306b\u5b66\u3076\u3079\u304d\u4f8b<\/p><h2 class=\"wp-block-heading\">\u30af\u30a8\u30ea\u3092\u81ea\u52d5\u7684\u306b\u66f4\u65b0\u3059\u308b<\/h2><p>\u3053\u3053\u3067\u5f15\u7528\u3057\u305f\u3059\u3079\u3066\u306e\u4f8b\u306e\u4e2d\u3067\u3001\u3053\u308c\u304c\u6700\u3082\u91cd\u8981\u3067\u3059\u3002\u30af\u30a8\u30ea\u3092\u4f5c\u6210\u3059\u308b\u3068\u3001\u30af\u30a8\u30ea\u3092\u81ea\u52d5\u7684\u306b\u66f4\u65b0\u3067\u304d\u307e\u3059 (\u30bf\u30a4\u30de\u30fc\u3092\u8a2d\u5b9a\u3067\u304d\u307e\u3059)\u3002<\/p><p>\u624b\u9806\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p><ul><li> [\u30c7\u30fc\u30bf] \u30bf\u30d6\u3067 [\u30af\u30a8\u30ea\u3068\u63a5\u7d9a] \u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u30a6\u30a3\u30f3\u30c9\u30a6\u306e\u53f3\u5074\u306b [\u30af\u30a8\u30ea\u3068\u63a5\u7d9a] \u30da\u30a4\u30f3\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002 <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47377\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/68-requetes-et-connexions.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30ea\u30af\u30a8\u30b9\u30c8\u3068\u63a5\u7d9a\" width=\"285\" height=\"211\"><\/figure><\/div><ul><li>\u6b21\u306b\u3001\u30af\u30a8\u30ea\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u300c\u66f4\u65b0\u9593\u9694\u300d\u306b\u30c1\u30a7\u30c3\u30af\u3092\u5165\u308c\u3001\u5206\u3092\u5165\u529b\u3057\u307e\u3059\u3002 <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47378\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/69-clic-droit-sur-la-coche-de-la-requete.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30af\u30a8\u30ea\u306e\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\" width=\"471\" height=\"300\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Power Query \u3067\u6570\u5f0f\u3068\u95a2\u6570\u3092\u4f7f\u7528\u3059\u308b\u65b9\u6cd5<\/h2><p>Excel \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u95a2\u6570\u3084\u6570\u5f0f\u3092\u4f7f\u7528\u3067\u304d\u308b\u306e\u3068\u540c\u3058\u3088\u3046\u306b\u3001\u30a2\u30c9\u30d0\u30f3\u30b9\u30c8 \u30af\u30a8\u30ea\u306b\u306f\u4f7f\u7528\u3067\u304d\u308b\u95a2\u6570\u306e\u72ec\u81ea\u306e\u30ea\u30b9\u30c8\u304c\u3042\u308a\u307e\u3059\u3002 <a href=\"https:\/\/exceladvisor.org\/ja\/\u95a2\u6570\u5f0f\/\">PowerQuery \u306e\u95a2\u6570\u3068\u6570\u5f0f<\/a>\u306e\u57fa\u672c\u306f Excel \u306e\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u95a2\u6570\u3068\u540c\u3058\u3067\u3059\u3002<\/p><p> PQ \u3067\u306f\u3001\u95a2\u6570\u307e\u305f\u306f\u6570\u5f0f\u3092\u8ffd\u52a0\u3059\u308b\u306b\u306f\u3001\u65b0\u3057\u3044\u30ab\u30b9\u30bf\u30e0\u5217\u3092\u8ffd\u52a0\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p><p>\u4f8b\u3092\u898b\u3066\u307f\u307e\u3057\u3087\u3046: \u4ee5\u4e0b\u306e\u30c7\u30fc\u30bf (\u3059\u3067\u306b PQ \u30a8\u30c7\u30a3\u30bf\u30fc\u306b\u3042\u308b) \u306b\u306f\u3001\u59d3\u540d (<strong><a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/score-des-eleves.xlsx\">\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9 \u30ea\u30f3\u30af<\/a>)<\/strong>\u304c\u3042\u308a\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47379\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/70-donnees-deja-dans-lediteur-pq-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30c7\u30fc\u30bf\u306f\u3059\u3067\u306b pq-editor-1 \u306b\u3042\u308a\u307e\u3059\" width=\"454\" height=\"302\"><\/figure><\/div><p> 2 \u3064\u306e\u540d\u524d\u3092\u7d50\u5408\u3057\u3001\u30d5\u30eb\u30cd\u30fc\u30e0\u306e\u5217\u3092\u4f5c\u6210\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u3068\u60f3\u50cf\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u3053\u306e\u5834\u5408\u3001\u7c21\u5358\u306a\u6570\u5f0f\u3092\u5165\u529b\u3057\u3066 2 \u3064\u306e\u5217\u306e\u540d\u524d\u3092\u9023\u7d50\u3067\u304d\u307e\u3059\u3002<\/p><ul><li>\u307e\u305a\u3001\u300c\u5217\u306e\u8ffd\u52a0\u300d\u30bf\u30d6\u306b\u79fb\u52d5\u3057\u3001 <strong>\u300c\u30ab\u30b9\u30bf\u30e0\u5217\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/strong> <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47380\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/71-ajouter-un-onglet-de-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u5217\u30bf\u30d6\u3092\u8ffd\u52a0\" width=\"499\" height=\"180\"><\/figure><\/div><ul><li>\u6b21\u306b\u3001\u30ab\u30b9\u30bf\u30e0\u5217\u30c0\u30a4\u30a2\u30ed\u30b0 \u30dc\u30c3\u30af\u30b9\u3067\u3001\u65b0\u3057\u3044\u5217\u306e<strong>\u540d\u524d\u300c\u30d5\u30eb\u30cd\u30fc\u30e0\u300d\u307e\u305f\u306f\u65b0\u3057\u3044\u5217\u306b\u4ed8\u3051\u305f\u3044\u4efb\u610f\u306e\u540d\u524d\u3092\u5165\u529b\u3057\u307e\u3059<\/strong>\u3002 <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47381\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/72-colonne-personnalisee.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30ab\u30b9\u30bf\u30e0\u5217\" width=\"526\" height=\"330\"><\/figure><\/div><ul><li style=\"list-style-type: none;\"><ul><li>\u30ab\u30b9\u30bf\u30e0\u5217\u306e\u5f0f\u306b\u306f\u3001\u5f0f\u3092\u5165\u529b\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<strong>\u3057\u305f\u304c\u3063\u3066\u3001\u4ee5\u4e0b\u306e\u5f0f\u3092\u5165\u529b\u3057\u307e\u3059<\/strong>\u3002 <\/li><\/ul><\/li><\/ul><pre> [First Name]&amp;\" \"&amp;[Last Name] <\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47382\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/73-formule-de-colonne-personnalisee.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30ab\u30b9\u30bf\u30e0\u5217\u306e\u5f0f\" width=\"529\" height=\"332\"><\/figure><\/div><ul><li> \u300c\u30ab\u30b9\u30bf\u30e0\u5217\u306e\u5f0f\u300d\u306b\u5f0f\u3092\u5165\u529b\u3059\u308b\u3068\u3001PQ \u306f\u5165\u529b\u3057\u305f\u5f0f\u3092\u30c1\u30a7\u30c3\u30af\u3057\u3001\u300c\u69cb\u6587\u30a8\u30e9\u30fc\u306f\u691c\u51fa\u3055\u308c\u307e\u305b\u3093\u3067\u3057\u305f\u300d\u3068\u3044\u3046\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u8868\u793a\u3057\u307e\u3059\u3002\u30a8\u30e9\u30fc\u304c\u3042\u308b\u5834\u5408\u306f\u3001\u30a8\u30e9\u30fc\u306e\u7a2e\u985e\u306b\u57fa\u3065\u3044\u3066\u30e1\u30c3\u30bb\u30fc\u30b8 \u30a8\u30e9\u30fc\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/li><li>\u6570\u5f0f\u3092\u5165\u529b\u3057\u3001\u30a8\u30e9\u30fc\u304c\u306a\u3051\u308c\u3070\u3001\u305d\u306e\u307e\u307e\u300cOK\u300d\u3092\u62bc\u3057\u307e\u3059\u3002<\/li><li>\u30c7\u30fc\u30bf\u306e\u6700\u5f8c\u306b\u30012 \u3064\u306e\u5217 (\u540d\u3068\u59d3) \u306e\u5024\u3092\u542b\u3080\u65b0\u3057\u3044\u5217\u304c\u3067\u304d\u307e\u3057\u305f\u3002 <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47383\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/74-nouvelle-colonne-a-la-fin-des-donnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30c7\u30fc\u30bf\u306e\u6700\u5f8c\u306b\u3042\u308b\u65b0\u3057\u3044\u5217\" width=\"593\" height=\"208\"><\/figure><\/div><h3 class=\"wp-block-heading\"> Power Query \u3067\u95a2\u6570\u3092\u4f7f\u7528\u3059\u308b\u65b9\u6cd5<\/h3><p>\u540c\u69d8\u306b\u3001\u30ab\u30b9\u30bf\u30e0\u5217\u3092\u8ffd\u52a0\u3059\u308b\u3068\u304d\u306b\u95a2\u6570\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002Power Query \u306b\u306f\u3001\u4f7f\u7528\u3067\u304d\u308b\u95a2\u6570\u306e\u81a8\u5927\u306a\u30ea\u30b9\u30c8\u304c\u3042\u308a\u307e\u3059\u3002<\/p><p>\u7c21\u5358\u3067\u30b7\u30f3\u30d7\u30eb\u306a\u4f8b\u3067\u95a2\u6570\u306e\u4f7f\u7528\u65b9\u6cd5\u3092\u7406\u89e3\u3057\u307e\u3057\u3087\u3046\u3002\u4e0a\u8a18\u306e\u4f8b\u3092\u7d9a\u3051\u3066\u3001\u540d\u3068\u59d3\u3092\u7d44\u307f\u5408\u308f\u305b\u305f\u65b0\u3057\u3044\u5217\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47384\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/75-utiliser-la-fonction-lors-de-lajout-dune-colonne-personnalisee.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30ab\u30b9\u30bf\u30e0\u5217\u3092\u8ffd\u52a0\u3059\u308b\u5834\u5408\u306e\u95a2\u6570\u306e\u4f7f\u7528\" width=\"434\" height=\"274\"><\/figure><\/div><p>\u305f\u3060\u3057\u3001\u3053\u306e\u5217\u306b\u3042\u308b\u30d5\u30eb\u30cd\u30fc\u30e0\u306e\u30c6\u30ad\u30b9\u30c8\u3092\u5927\u6587\u5b57\u306b\u5909\u63db\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u4f7f\u7528\u3067\u304d\u308b\u95a2\u6570\u306f<strong>\u300c <a href=\"https:\/\/docs.microsoft.com\/en-us\/powerquery-m\/text-upper\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Text.Upper (opens in a new tab)\">Text.Upper<\/a> \u300d<\/strong>\u3067\u3059\u3002\u540d\u524d\u304c\u793a\u3059\u3088\u3046\u306b\u3001\u30c6\u30ad\u30b9\u30c8\u3092\u5927\u6587\u5b57\u306e\u30c6\u30ad\u30b9\u30c8\u306b\u5909\u63db\u3057\u307e\u3059\u3002<\/p><ul><li>\u307e\u305a\u3001\u300c\u5217\u306e\u8ffd\u52a0\u300d\u30bf\u30d6\u306b\u79fb\u52d5\u3057\u3001\u30ab\u30b9\u30bf\u30e0\u5217\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002 <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47385\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/76-cliquez-sur-la-colonne-personnalisee.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30ab\u30b9\u30bf\u30e0\u5217\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\" width=\"391\" height=\"196\"><\/figure><\/div><ul><li style=\"list-style-type: none;\"><ul><li>\u3053\u3053\u3067\u3001\u30ab\u30b9\u30bf\u30e0\u5217\u30c0\u30a4\u30a2\u30ed\u30b0 \u30dc\u30c3\u30af\u30b9\u3067\u3001\u30ab\u30b9\u30bf\u30e0\u5217\u306e\u5f0f\u30dc\u30c3\u30af\u30b9\u306b\u5217\u540d\u3068\u4ee5\u4e0b\u306e\u5f0f\u3092\u5165\u529b\u3057\u307e\u3059\u3002 <\/li><\/ul><\/li><\/ul><pre class=\"wp-block-preformatted\"> Text.Upper([Full Name]) <\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47386\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/77-boite-de-dialogue-de-colonne-personnalisee.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30ab\u30b9\u30bf\u30e0\u5217\u30c0\u30a4\u30a2\u30ed\u30b0\" width=\"553\" height=\"347\"><\/figure><\/div><ul><li> [OK] \u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u3059\u3079\u3066\u306e\u540d\u524d\u304c\u5927\u6587\u5b57\u3067\u65b0\u3057\u3044\u5217\u304c\u4f5c\u6210\u3055\u308c\u307e\u3059\u3002<\/li><li>\u6b21\u306b\u3001\u53e4\u3044\u5217\u3092\u524a\u9664\u3057\u3001\u65b0\u3057\u3044\u5217\u306e\u540d\u524d\u3092\u5909\u66f4\u3057\u307e\u3059\u3002\u3057\u305f\u304c\u3063\u3066\u3001\u6700\u521d\u306e\u5217\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u300c\u524a\u9664\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002 <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47387\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/78-nouvelle-colonne-avec-tous-les-noms-en-majuscule.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u3059\u3079\u3066\u306e\u540d\u524d\u3092\u5927\u6587\u5b57\u306b\u3057\u305f\u65b0\u3057\u3044\u5217\" width=\"390\" height=\"133\"><\/figure><\/div><ul><li>\u6700\u5f8c\u306b\u3001\u65b0\u3057\u3044\u5217\u306e\u540d\u524d\u3092\u300c\u30d5\u30eb\u30cd\u30fc\u30e0\u300d\u306b\u5909\u66f4\u3057\u307e\u3059\u3002<\/li><\/ul><p>\u65b0\u3057\u3044\u5217\u3092\u8ffd\u52a0\u3059\u308b\u3068\u304d\u306b\u30d1\u30ef\u30fc \u30af\u30a8\u30ea\u3067\u4f7f\u7528\u3067\u304d\u308b\u95a2\u6570\u306f\u5408\u8a08 700 \u3042\u308a\u307e\u3059\u3002\u3053\u308c\u3089\u306e\u95a2\u6570\u306b\u3064\u3044\u3066<a href=\"https:\/\/docs.microsoft.com\/en-us\/powerquery-m\/power-query-m-function-reference\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"complete list provided by Microsoft (opens in a new tab)\">Microsoft \u304c\u63d0\u4f9b\u3059\u308b\u5b8c\u5168\u306a\u30ea\u30b9\u30c8\u306f<\/a>\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002\u30c1\u30a7\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p><h2 class=\"wp-block-heading\"> PQ \u3067\u30af\u30a8\u30ea\u3092\u5909\u66f4\u3059\u308b\u65b9\u6cd5<\/h2><p>\u30ef\u30fc\u30af\u30d6\u30c3\u30af\u306b\u65e2\u306b\u5b58\u5728\u3059\u308b\u30af\u30a8\u30ea\u306b\u5909\u66f4\u3092\u52a0\u3048\u305f\u3044\u5834\u5408\u306f\u3001\u5358\u306b\u30af\u30a8\u30ea\u3092\u7de8\u96c6\u3057\u3066\u304b\u3089\u5909\u66f4\u3092\u52a0\u3048\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002 [\u30c7\u30fc\u30bf] \u30bf\u30d6\u306b\u306f\u3001 <strong>[\u30af\u30a8\u30ea\u3068\u63a5\u7d9a] \u3068\u3044\u3046\u540d\u524d\u306e\u30dc\u30bf\u30f3\u304c\u3042\u308a\u307e\u3059\u3002<\/strong> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47388\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/79-bouton-nomme-requetes-et-connexions.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30dc\u30bf\u30f3\u3068\u3044\u3046\u540d\u524d\u306e\u30ea\u30af\u30a8\u30b9\u30c8\u3068\u63a5\u7d9a\" width=\"512\" height=\"162\"><\/figure><\/div><p>\u3053\u306e\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u53f3\u5074\u306b\u30da\u30a4\u30f3\u304c\u958b\u304d\u3001\u73fe\u5728\u306e\u30ef\u30fc\u30af\u30d6\u30c3\u30af\u306b\u3042\u308b\u3059\u3079\u3066\u306e\u30af\u30a8\u30ea\u304c\u30ea\u30b9\u30c8\u3055\u308c\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47389\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/80-repertorie-toutes-les-requetes-effectuees.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u5b9f\u884c\u3055\u308c\u305f\u3059\u3079\u3066\u306e\u30af\u30a8\u30ea\u306e\u30ea\u30b9\u30c8\" width=\"324\" height=\"302\"><\/figure><\/div><p>\u30af\u30a8\u30ea\u540d\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u7de8\u96c6\u3092\u9078\u629e\u3059\u308b\u3068\u3001\u5f37\u529b\u306a\u30af\u30a8\u30ea \u30a8\u30c7\u30a3\u30bf\u30fc\u3067\u30af\u30a8\u30ea\u3092\u53d6\u5f97\u3057\u3066\u7de8\u96c6\u3067\u304d\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47390\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/81-faites-un-clic-droit-sur-le-nom-de-la-requete-et-selectionnez-modifier.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30af\u30a8\u30ea\u540d\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u7de8\u96c6\u3092\u9078\u629e\u3057\u307e\u3059\" width=\"368\" height=\"213\"><\/figure><\/div><p>\u30af\u30a8\u30ea\u3092\u7de8\u96c6\u3059\u308b\u3068\u3001\u4ee5\u524d\u306b\u5b9f\u884c\u3057\u305f\u3059\u3079\u3066\u306e\u30b9\u30c6\u30c3\u30d7\u304c\u300c\u9069\u7528\u3055\u308c\u305f\u30b9\u30c6\u30c3\u30d7\u300d\u306b\u30ea\u30b9\u30c8\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002\u3053\u308c\u3092\u7de8\u96c6\u3057\u305f\u308a\u3001\u65b0\u3057\u3044\u30b9\u30c6\u30c3\u30d7\u3092\u5b9f\u884c\u3057\u305f\u308a\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47391\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/82-etapes-appliquees-que-vous-pouvez-egalement-modifier.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u7de8\u96c6\u3082\u3067\u304d\u308b\u9069\u7528\u3055\u308c\u305f\u30b9\u30c6\u30c3\u30d7\" width=\"259\" height=\"180\"><\/figure><\/div><p>\u7de8\u96c6\u304c\u5b8c\u4e86\u3057\u305f\u3089\u3001[\u9589\u3058\u3066\u30ed\u30fc\u30c9] \u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3060\u3051\u3067\u3059\u3002<\/p><h2 class=\"wp-block-heading\">\u63a5\u7d9a\u306e\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3068\u30a4\u30f3\u30dd\u30fc\u30c8<\/h2><p>\u30af\u30a8\u30ea\u306b\u4f7f\u7528\u3057\u305f\u63a5\u7d9a\u304c\u3042\u308a\u3001\u305d\u306e\u63a5\u7d9a\u3092\u4ed6\u306e\u4eba\u3068\u5171\u6709\u3057\u305f\u3044\u5834\u5408\u306f\u3001\u305d\u306e\u63a5\u7d9a\u3092 odc \u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3067\u304d\u307e\u3059\u3002<\/p><p>\u30af\u30a8\u30ea\u30c6\u30fc\u30d6\u30eb\u306b\u306f<strong>\u300c\u63a5\u7d9a\u306e\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u300d\u3068\u3044\u3046\u30dc\u30bf\u30f3<\/strong>\u304c\u3042\u308a\u3001\u3053\u308c\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u305d\u306e\u30af\u30a8\u30ea\u306e\u63a5\u7d9a\u3092\u30b7\u30b9\u30c6\u30e0\u306b\u4fdd\u5b58\u3067\u304d\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47392\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/83-connexion-dexportation.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u63a5\u7d9a\" width=\"216\" height=\"143\"><\/figure><\/div><p>\u307e\u305f\u3001\u4ed6\u306e\u4eba\u304c\u5171\u6709\u3057\u3066\u3044\u308b\u63a5\u7d9a\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u5834\u5408\u306f\u3001[\u30c7\u30fc\u30bf] \u30bf\u30d6\u306b\u79fb\u52d5\u3057\u3001[\u53d6\u5f97\u3068\u5909\u63db] \u3067<strong>[\u65e2\u5b58\u306e\u63a5\u7d9a] \u3092\u30af\u30ea\u30c3\u30af\u3059\u308b<\/strong>\u3060\u3051\u3067\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47393\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/84-importer-une-connexion-obtenir-une-transformation.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30a4\u30f3\u30dd\u30fc\u30c8\u63a5\u7d9a\u53d6\u5f97\u5909\u63db\" width=\"400\" height=\"133\"><\/figure><\/div><p>\u6b21\u306b\u3001[\u3055\u3089\u306b\u53c2\u7167] \u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u3001\u5171\u6709\u3055\u308c\u305f\u63a5\u7d9a\u30d5\u30a1\u30a4\u30eb\u3092\u898b\u3064\u3051\u3066\u30ef\u30fc\u30af\u30d6\u30c3\u30af\u306b\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47394\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/85-bouton-parcourir-pour-plus.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u53c2\u7167\u30dc\u30bf\u30f3\u3067\u8a73\u7d30\u3092\u78ba\u8a8d\u3067\u304d\u307e\u3059\" width=\"465\" height=\"238\"><\/figure><\/div><h2 class=\"wp-block-heading\"> PowerQuery\u8a00\u8a9e\uff08M\u30b3\u30fc\u30c9\uff09<\/h2><p>\u524d\u306b\u8ff0\u3079\u305f\u3088\u3046\u306b\u3001PowerQuery \u3067\u5b9f\u884c\u3057\u305f\u5404\u30b9\u30c6\u30c3\u30d7\u3054\u3068\u306b\u3001 <strong>M \u30b3\u30fc\u30c9<\/strong>\u3068\u547c\u3070\u308c\u308b\u30b3\u30fc\u30c9\u304c (\u30d0\u30c3\u30af\u30a8\u30f3\u30c9\u3067) \u751f\u6210\u3055\u308c\u307e\u3059\u3002 \u300c\u30db\u30fc\u30e0\u300d\u30bf\u30d6\u306b\u306f\u3001\u30b3\u30fc\u30c9\u3092\u8868\u793a\u3059\u308b\u305f\u3081\u306b\u4f7f\u7528\u3067\u304d\u308b\u300c<strong>\u8a73\u7d30\u30a8\u30c7\u30a3\u30bf\u30fc\u300d<\/strong>\u3068\u3044\u3046\u30dc\u30bf\u30f3\u304c\u3042\u308a\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47395\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/86-editeur-avance.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u9ad8\u5ea6\u306a\u30a8\u30c7\u30a3\u30bf\u30fc\" width=\"265\" height=\"176\"><\/figure><\/div><p>\u9ad8\u5ea6\u306a\u30a8\u30c7\u30a3\u30bf\u30fc\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u30b3\u30fc\u30c9 \u30a8\u30c7\u30a3\u30bf\u30fc\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u3053\u306e\u30b3\u30fc\u30c9\u306f\u6b21\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47396\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/87-lediteur-de-code.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30b3\u30fc\u30c9\u30a8\u30c7\u30a3\u30bf\" width=\"578\" height=\"390\"><\/figure><\/div><p> <strong>M \u306f\u5927\u6587\u5b57\u3068\u5c0f\u6587\u5b57\u3092\u533a\u5225\u3059\u308b\u8a00\u8a9e\u3067\u3042\u308a<\/strong>\u3001\u4ed6\u306e\u3059\u3079\u3066\u306e\u8a00\u8a9e\u3068\u540c\u69d8\u306b\u5909\u6570\u3068\u5f0f\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002\u30b3\u30fc\u30c9\u306e\u57fa\u672c\u69cb\u9020\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u308a\u3001\u30b3\u30fc\u30c9\u306f LET \u5f0f\u3067\u59cb\u307e\u308a\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47397\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/88-structure-de-base-du-code.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u57fa\u672c\u30b3\u30fc\u30c9\u69cb\u9020\" width=\"539\" height=\"364\"><\/figure><\/div><p>\u3053\u306e\u30b3\u30fc\u30c9\u306b\u306f 2 \u3064\u306e\u5909\u6570\u3068\u305d\u308c\u3089\u306b\u8a2d\u5b9a\u3055\u308c\u305f\u5024\u304c\u3042\u308a\u307e\u3059\u3002\u6700\u7d42\u7684\u306b\u3001\u5024\u3092\u53d6\u5f97\u3059\u308b\u306b\u306f IN \u5f0f\u304c\u4f7f\u7528\u3055\u308c\u307e\u3057\u305f\u3002\u3053\u3053\u3067\u300cOK\u300d\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u5909\u6570\u300cVariablename\u300d\u306b\u5272\u308a\u5f53\u3066\u3089\u308c\u305f\u5024\u304c\u7d50\u679c\u3068\u3057\u3066\u8fd4\u3055\u308c\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47398\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/89-nom-de-variable.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u5909\u6570\u540d\" width=\"444\" height=\"199\"><\/figure><\/div><p> <a href=\"https:\/\/docs.microsoft.com\/en-us\/powerquery-m\/quick-tour-of-the-power-query-m-formula-language\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Power Query Language. (opens in a new tab)\">Power Query \u8a00\u8a9e\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u306e\u30ea\u30bd\u30fc\u30b9\u3092\u3054\u89a7\u304f\u3060\u3055\u3044\u3002<\/a> <\/p><p class=\"has-text-color has-background has-very-dark-gray-color has-very-light-gray-background-color\" style=\"font-size: 26px;\"><strong>\u6700\u5f8c\u306b<\/strong><\/p><div class=\"schema-faq wp-block-yoast-faq-block\"><div id=\"faq-question-1583515972468\" class=\"schema-faq-section\"> <strong class=\"schema-faq-question\">Excel PowerQuery \u3068\u306f\u4f55\u3067\u3059\u304b?<\/strong><p class=\"schema-faq-answer\"> Power Query \u306f\u3001\u8907\u6570\u306e\u30bd\u30fc\u30b9\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u3001\u305d\u306e\u30c7\u30fc\u30bf\u3092\u30af\u30ea\u30fc\u30f3\u30a2\u30c3\u30d7\u3057\u3066\u5909\u63db\u3057\u3001\u3055\u3089\u306b\u5206\u6790\u306b\u4f7f\u7528\u3059\u308b\u305f\u3081\u306b\u4f7f\u7528\u3067\u304d\u308b\u30c7\u30fc\u30bf\u5909\u63db\u30a8\u30f3\u30b8\u30f3\u3067\u3059\u3002<\/p><\/div><\/div><p> POWER QUERY \u3092\u907f\u3051\u308b\u3053\u3068\u306f\u3067\u304d\u307e\u305b\u3093\u3002\u305d\u3046\u8003\u3048\u308b\u3068\u3001 Excel \u95a2\u6570\u3084 VBA \u30b3\u30fc\u30c9\u3067\u884c\u3046\u591a\u304f\u306e\u4f5c\u696d\u306f\u3001\u3053\u308c\u3092\u4f7f\u7528\u3057\u3066\u81ea\u52d5\u5316\u3067\u304d\u307e\u3059\u3002\u3053\u306e\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3092\u8aad\u3093\u3067\u3001\u3082\u3063\u3068\u4f7f\u3044\u305f\u304f\u306a\u308b\u306f\u305a\u3067\u3059\u3002<\/p>","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-3130","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>Excel \u3067\u306e Power Query \u2013 \u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb + \u4f8b (\u53d6\u5f97\u3068\u5909\u63db)<\/title>\n<meta name=\"description\" content=\"Power Query \u3092\u4f7f\u7528\u3059\u308b\u3068\u3001\u8907\u6570\u306e\u30bd\u30fc\u30b9\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u3066\u5909\u63db\u3067\u304d\u307e\u3059\u3002\u3053\u306e\u30ac\u30a4\u30c9\u306f\u5b8c\u5168\u306a\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3067\u3059\u3002\" \/>\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\/ja\/\u96fb\u529b\u8981\u6c42\/\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel \u3067\u306e Power Query \u2013 \u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb + \u4f8b (\u53d6\u5f97\u3068\u5909\u63db)\" \/>\n<meta property=\"og:description\" content=\"Power Query \u3092\u4f7f\u7528\u3059\u308b\u3068\u3001\u8907\u6570\u306e\u30bd\u30fc\u30b9\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u3066\u5909\u63db\u3067\u304d\u307e\u3059\u3002\u3053\u306e\u30ac\u30a4\u30c9\u306f\u5b8c\u5168\u306a\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3067\u3059\u3002\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/ja\/\u96fb\u529b\u8981\u6c42\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-07T04:46:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/requete-de-puissance-excel-2007.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data1\" content=\"1\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/ja\/%e9%9b%bb%e5%8a%9b%e8%a6%81%e6%b1%82\/\",\"url\":\"https:\/\/exceladvisor.org\/ja\/%e9%9b%bb%e5%8a%9b%e8%a6%81%e6%b1%82\/\",\"name\":\"Excel \u3067\u306e Power Query \u2013 \u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb + \u4f8b (\u53d6\u5f97\u3068\u5909\u63db)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/ja\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/ja\/%e9%9b%bb%e5%8a%9b%e8%a6%81%e6%b1%82\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/ja\/%e9%9b%bb%e5%8a%9b%e8%a6%81%e6%b1%82\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/requete-de-puissance-excel-2007.png\",\"datePublished\":\"2023-11-13T11:16:22+00:00\",\"dateModified\":\"2023-12-07T04:46:32+00:00\",\"description\":\"Power Query \u3092\u4f7f\u7528\u3059\u308b\u3068\u3001\u8907\u6570\u306e\u30bd\u30fc\u30b9\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u3066\u5909\u63db\u3067\u304d\u307e\u3059\u3002\u3053\u306e\u30ac\u30a4\u30c9\u306f\u5b8c\u5168\u306a\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3067\u3059\u3002\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/ja\/%e9%9b%bb%e5%8a%9b%e8%a6%81%e6%b1%82\/#breadcrumb\"},\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/ja\/%e9%9b%bb%e5%8a%9b%e8%a6%81%e6%b1%82\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/exceladvisor.org\/ja\/%e9%9b%bb%e5%8a%9b%e8%a6%81%e6%b1%82\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/requete-de-puissance-excel-2007.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/requete-de-puissance-excel-2007.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/ja\/%e9%9b%bb%e5%8a%9b%e8%a6%81%e6%b1%82\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u5bb6\",\"item\":\"https:\/\/exceladvisor.org\/ja\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel power \u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u200c \u30af\u30a8\u30ea (\u53d6\u5f97\u3068\u5909\u63db)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/ja\/#website\",\"url\":\"https:\/\/exceladvisor.org\/ja\/\",\"name\":\"Excel Advisor\",\"description\":\"\u30c7\u30fc\u30bf\u3092\u652f\u914d\u3059\u308b\u305f\u3081\u306e\u7a76\u6975\u306e\u30ac\u30a4\u30c9!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/ja\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/ja\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ja\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/ja\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/ja\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/exceladvisor.org\/ja\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/ja\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/ja\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/ja\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel \u3067\u306e Power Query \u2013 \u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb + \u4f8b (\u53d6\u5f97\u3068\u5909\u63db)","description":"Power Query \u3092\u4f7f\u7528\u3059\u308b\u3068\u3001\u8907\u6570\u306e\u30bd\u30fc\u30b9\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u3066\u5909\u63db\u3067\u304d\u307e\u3059\u3002\u3053\u306e\u30ac\u30a4\u30c9\u306f\u5b8c\u5168\u306a\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3067\u3059\u3002","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\/ja\/\u96fb\u529b\u8981\u6c42\/","og_locale":"ja_JP","og_type":"article","og_title":"Excel \u3067\u306e Power Query \u2013 \u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb + \u4f8b (\u53d6\u5f97\u3068\u5909\u63db)","og_description":"Power Query \u3092\u4f7f\u7528\u3059\u308b\u3068\u3001\u8907\u6570\u306e\u30bd\u30fc\u30b9\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u3066\u5909\u63db\u3067\u304d\u307e\u3059\u3002\u3053\u306e\u30ac\u30a4\u30c9\u306f\u5b8c\u5168\u306a\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3067\u3059\u3002","og_url":"https:\/\/exceladvisor.org\/ja\/\u96fb\u529b\u8981\u6c42\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-07T04:46:32+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/requete-de-puissance-excel-2007.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"1\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/ja\/%e9%9b%bb%e5%8a%9b%e8%a6%81%e6%b1%82\/","url":"https:\/\/exceladvisor.org\/ja\/%e9%9b%bb%e5%8a%9b%e8%a6%81%e6%b1%82\/","name":"Excel \u3067\u306e Power Query \u2013 \u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb + \u4f8b (\u53d6\u5f97\u3068\u5909\u63db)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/ja\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/ja\/%e9%9b%bb%e5%8a%9b%e8%a6%81%e6%b1%82\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/ja\/%e9%9b%bb%e5%8a%9b%e8%a6%81%e6%b1%82\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/requete-de-puissance-excel-2007.png","datePublished":"2023-11-13T11:16:22+00:00","dateModified":"2023-12-07T04:46:32+00:00","description":"Power Query \u3092\u4f7f\u7528\u3059\u308b\u3068\u3001\u8907\u6570\u306e\u30bd\u30fc\u30b9\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u3066\u5909\u63db\u3067\u304d\u307e\u3059\u3002\u3053\u306e\u30ac\u30a4\u30c9\u306f\u5b8c\u5168\u306a\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3067\u3059\u3002","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/ja\/%e9%9b%bb%e5%8a%9b%e8%a6%81%e6%b1%82\/#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/ja\/%e9%9b%bb%e5%8a%9b%e8%a6%81%e6%b1%82\/"]}]},{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/exceladvisor.org\/ja\/%e9%9b%bb%e5%8a%9b%e8%a6%81%e6%b1%82\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/requete-de-puissance-excel-2007.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/requete-de-puissance-excel-2007.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/ja\/%e9%9b%bb%e5%8a%9b%e8%a6%81%e6%b1%82\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u5bb6","item":"https:\/\/exceladvisor.org\/ja\/"},{"@type":"ListItem","position":2,"name":"Excel power \u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u200c \u30af\u30a8\u30ea (\u53d6\u5f97\u3068\u5909\u63db)"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/ja\/#website","url":"https:\/\/exceladvisor.org\/ja\/","name":"Excel Advisor","description":"\u30c7\u30fc\u30bf\u3092\u652f\u914d\u3059\u308b\u305f\u3081\u306e\u7a76\u6975\u306e\u30ac\u30a4\u30c9!","publisher":{"@id":"https:\/\/exceladvisor.org\/ja\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/ja\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ja"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/ja\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/ja\/","logo":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/exceladvisor.org\/ja\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/ja\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/ja\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/ja\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/ja\/wp-json\/wp\/v2\/pages\/3130","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/ja\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/ja\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/ja\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/ja\/wp-json\/wp\/v2\/comments?post=3130"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/ja\/wp-json\/wp\/v2\/pages\/3130\/revisions"}],"predecessor-version":[{"id":3712,"href":"https:\/\/exceladvisor.org\/ja\/wp-json\/wp\/v2\/pages\/3130\/revisions\/3712"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/ja\/wp-json\/wp\/v2\/media?parent=3130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}