{"id":183,"date":"2023-11-13T11:16:22","date_gmt":"2023-11-13T11:16:22","guid":{"rendered":"https:\/\/exceladvisor.org\/ko\/%ec%a0%84%ec%9b%90-%ec%9a%94%ec%b2%ad\/"},"modified":"2023-12-11T06:59:39","modified_gmt":"2023-12-11T06:59:39","slug":"%ec%a0%84%ec%9b%90-%ec%9a%94%ec%b2%ad","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/ko\/%ec%a0%84%ec%9b%90-%ec%9a%94%ec%b2%ad\/","title":{"rendered":"Excel \uace0\uae09 \uc790\uc2b5\uc11c\u200c \ucffc\ub9ac(\uac00\uc838\uc624\uae30 \ubc0f \ubcc0\ud658)"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-4232688728\"><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>\ub370\uc774\ud130 \uc791\uc5c5\uc744 \ub9ce\uc774 \ud558\ub294 \uc0ac\ub78c\uc774\ub77c\uba74 \ub204\uad6c\ub098( \ud68c\uacc4\uc0ac , HR, \ub370\uc774\ud130 \ubd84\uc11d\uac00 \ub4f1) \ub420 \uc218 \uc788\uc73c\uba70 PowerQuery\ub294 \uac15\ub825\ud55c \ub3c4\uad6c\uac00 \ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p><p> \ubcf8\ub860\uc73c\ub85c \ub4e4\uc5b4\uac00\uaca0\uc2b5\ub2c8\ub2e4. \ud30c\uc6cc \ucffc\ub9ac\ub294 \ubc30\uc6cc\uc57c \ud560 \uace0\uae09 Excel \uae30\uc220 \uc911 \ud558\ub098\uc774\uba70, \uc774 \uc790\uc2b5\uc11c\uc5d0\uc11c\ub294 PowerQuery\ub97c \uc790\uc138\ud788 \uc0b4\ud3b4\ubcf4\uace0 \uc774\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uc744 \ubc30\uc6c1\ub2c8\ub2e4.<\/p><p> \uc2dc\uc791\ud558\uc790.<\/p><h2 class=\"wp-block-heading\"> Excel \ud30c\uc6cc \ucffc\ub9ac\ub780?<\/h2><p> \ud30c\uc6cc \ucffc\ub9ac\ub294 ETL\uc5d0 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 Excel \ucd94\uac00 \uae30\ub2a5\uc785\ub2c8\ub2e4. \uc989, \ub2e4\uc591\ud55c \uc18c\uc2a4\uc5d0\uc11c <strong>\ub370\uc774\ud130\ub97c \ucd94\ucd9c<\/strong> \ud558\uace0 <strong>\ubcc0\ud658<\/strong> <strong>\ud55c \ub2e4\uc74c \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0 \ub85c\ub4dc<\/strong> \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. POWER QUERY\ub294 \ub370\uc774\ud130\ub97c \ubcc0\ud658\ud560 \uc218 \uc788\ub294 \ubaa8\ub4e0 \uc635\uc158\uc744 \uac16\ucd94\uace0 \uc788\uae30 \ub54c\ubb38\uc5d0 \ub370\uc774\ud130 \uc815\ub9ac \uae30\uacc4\ub77c\uace0 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\uac83\uc740 \uc2e4\uc2dc\uac04\uc774\uba70 \ub2f9\uc2e0\uc774 \ucde8\ud558\ub294 \ubaa8\ub4e0 \ub2e8\uacc4\ub97c \uae30\ub85d\ud569\ub2c8\ub2e4.<\/p><h2 class=\"wp-block-heading\"> \ud30c\uc6cc \ucffc\ub9ac(\ud61c\ud0dd)\ub97c \uc0ac\uc6a9\ud574\uc57c \ud558\ub294 \uc774\uc720\ub294 \ubb34\uc5c7\uc778\uac00\uc694?<\/h2><p> \uc774 \uc9c8\ubb38\uc744 \uc5fc\ub450\uc5d0 \ub450\uc168\ub2e4\uba74 \uc81c \ub2f5\ubcc0\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p><ul><li> <strong>\ub2e4\uc591\ud55c \ub370\uc774\ud130 \uc18c\uc2a4<\/strong> : CSV , TXT, JSON \ub4f1\uacfc \uac19\uc740 \ub2e4\uc591\ud55c \ub370\uc774\ud130 \uc18c\uc2a4\uc5d0\uc11c \uac15\ub825\ud55c \ucffc\ub9ac \ud3b8\uc9d1\uae30\ub85c \ub370\uc774\ud130\ub97c \ub85c\ub4dc\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li><li> \uc190\uc26c\uc6b4 \ub370\uc774\ud130 \ubcc0\ud658: \uc77c\ubc18\uc801\uc73c\ub85c \ub370\uc774\ud130 \ubcc0\ud658\uc744 \uc704\ud574 \uc218\uc2dd\uacfc \ud53c\ubc97 \ud14c\uc774\ube14\uc744 \uc0ac\uc6a9\ud558\uc9c0\ub9cc, POWER QUERY\ub97c \uc0ac\uc6a9\ud558\uba74 \ub2e8 \uba87 \ubc88\uc758 \ud074\ub9ad\ub9cc\uc73c\ub85c \ub9ce\uc740 \uc791\uc5c5\uc744 \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li><li> \uc2e4\uc2dc\uac04\uc785\ub2c8\ub2e4. \ucffc\ub9ac\ub97c \ud55c \ubc88 \uc791\uc131\ud558\uba74 \ub370\uc774\ud130\uac00 \ubcc0\uacbd\ub420 \ub54c\ub9c8\ub2e4 \uc0c8\ub85c \uace0\uce60 \uc218 \uc788\uc73c\uba70 \uc5c5\ub370\uc774\ud2b8\ud55c \uc0c8 \ub370\uc774\ud130\uac00 \ubcc0\ud658\ub429\ub2c8\ub2e4.<\/li><\/ul><p> \uc608\ub97c \ub4e4\uc5b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4:<\/p><p> 100\uac1c \ub3c4\uc2dc\uc758 \ub370\uc774\ud130\uac00 \ud3ec\ud568\ub41c 100\uac1c\uc758 Excel \ud30c\uc77c\uc774 \uc788\uace0 \uc774\uc81c \uc0c1\uc0ac\uac00 \ud574\ub2f9 100\uac1c \ud30c\uc77c\uc758 \ubaa8\ub4e0 \ub370\uc774\ud130\uac00 \ud3ec\ud568\ub41c \ubcf4\uace0\uc11c\ub97c \uc791\uc131\ud558\ub77c\uace0 \ud55c\ub2e4\uace0 \uac00\uc815\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc88b\uc2b5\ub2c8\ub2e4. \uac01 \ud30c\uc77c\uc744 \uc218\ub3d9\uc73c\ub85c \uc5f4\uace0 \ud574\ub2f9 \ud30c\uc77c\uc758 \ub370\uc774\ud130\ub97c \ubcf5\uc0ac\ud558\uc5ec \ubd99\uc5ec\ub123\uae30\ub85c \uacb0\uc815\ud588\ub2e4\uba74 \ucd5c\uc18c \ud55c \uc2dc\uac04\uc740 \uc18c\uc694\ub429\ub2c8\ub2e4.<\/p><p> \ud558\uc9c0\ub9cc \ud30c\uc6cc \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\uba74 \uba87 \ubd84 \uc548\uc5d0 \uc644\ub8cc\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uae30\ubd84\uc774 \ub4e4\ub728\ub098\uc694? \uc88b\uc740.<\/p><p> \uc774 \uc790\uc2b5\uc11c\uc758 \ub4b7\ubd80\ubd84\uc5d0\uc11c\ub294 \ub2e4\uc591\ud55c \uc608\uc81c\ub97c \ud1b5\ud574 \ud30c\uc6cc \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \ubc30\uc6b0\uac8c \ub418\uc9c0\ub9cc \uba3c\uc800 \ud574\ub2f9 \uac1c\ub150\uc744 \uc774\ud574\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p><h2 class=\"wp-block-heading\"> \uc804\ub825 \uc218\uc694\uc758 \uac1c\ub150<\/h2><p> \ud30c\uc6cc \ucffc\ub9ac\ub97c \ubc30\uc6b0\ub824\uba74 \ub2e4\uc74c 3\ub2e8\uacc4\ub85c \uc791\ub3d9\ud558\ub294 \uac1c\ub150\uc744 \uc774\ud574\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p><h3 class=\"wp-block-heading has-text-align-left\"> 1. \ub370\uc774\ud130 \uac00\uc838\uc624\uae30<\/h3><p> \ud30c\uc6cc \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\uba74 \uc6f9, CSV, \ud14d\uc2a4\ud2b8 \ud30c\uc77c, \ud55c \ud3f4\ub354\uc758 \uc5ec\ub7ec \ud1b5\ud569 \ubb38\uc11c \ubc0f \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud560 \uc218 \uc788\ub294 \uae30\ud0c0 \uc5ec\ub7ec \uc6d0\ubcf8\uacfc \uac19\uc740 \ub2e4\uc591\ud55c \uc6d0\ubcf8\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc62c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p><h3 class=\"wp-block-heading\"> 2. \ub370\uc774\ud130 \ubcc0\ud658<\/h3><p> \ub370\uc774\ud130\ub97c \ud30c\uc6cc \ucffc\ub9ac\ub85c \uac00\uc838\uc628 \ud6c4\uc5d0\ub294 \ub370\uc774\ud130\ub97c \ubcc0\ud658\ud558\uace0 \uc815\ub9ac\ud558\ub294 \ub370 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ub2e4\uc591\ud55c \uc635\uc158\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uc218\ud589\ud558\ub294 \ubaa8\ub4e0 \ub2e8\uacc4\uc5d0 \ub300\ud55c \ucffc\ub9ac\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4(\ud55c \ub2e8\uacc4\uc529 \uc21c\ucc28\uc801\uc73c\ub85c).<\/p><h3 class=\"wp-block-heading\"> 3. \ub370\uc774\ud130 \ub85c\ub4dc<\/h3><p> \uace0\uae09 \ucffc\ub9ac \ud3b8\uc9d1\uae30\uc5d0\uc11c \ubcc0\ud658\ub41c \ub370\uc774\ud130\ub97c \uc6cc\ud06c\uc2dc\ud2b8\uc5d0 \ub85c\ub4dc\ud558\uac70\ub098 \ud53c\ubc97 \ud14c\uc774\ube14 \ub610\ub294 \ud53c\ubc97 \ucc28\ud2b8\ub97c \uc9c1\uc811 \ub9cc\ub4e4\uac70\ub098 \ub370\uc774\ud130 \uc804\uc6a9 \uc5f0\uacb0\uc744 \ub9cc\ub4e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p><h2 class=\"wp-block-heading\"> \ud30c\uc6cc \ucffc\ub9ac(\uc124\uce58 \ubc29\ubc95)\ub294 \uc5b4\ub514\uc5d0 \uc788\ub098\uc694?<\/h2><p> \uc544\ub798\uc5d0\uc11c\ub294 \ub2e4\uc591\ud55c \ubc84\uc804\uc758 Microsoft Excel\uc5d0 \ud30c\uc6cc \ucffc\ub9ac \uc561\uc138\uc2a4\ub97c \uc124\uce58\ud558\ub294 \ubc29\ubc95\uc744 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4.<\/p><h3 class=\"wp-block-heading\"> \uc5d1\uc140 2007<\/h3><p> \uc5d1\uc140 2007\uc744 \uc0ac\uc6a9\ud558\uace0 \uacc4\uc2dc\ub2e4\uba74 \uc774\ubc88 \ubc84\uc804\uc5d0\uc11c\ub294 <strong>PQ\ub97c \uc774\uc6a9\ud558\uc2e4 \uc218 \uc5c6\ub294 \uc810\uc774<\/strong> \uc544\uc27d\uae30 \ub54c\ubb38\uc5d0 <code>latest version<\/code> \uc758 \uc5d1\uc140(Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010)\ub85c \uc5c5\uadf8\ub808\uc774\ub4dc \ud558\uc154\uc57c \ud569\ub2c8\ub2e4. <\/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=\"\ud30c\uc6cc \ucffc\ub9ac-excel-2007\" width=\"502\" height=\"161\"><\/figure><\/div><h3 class=\"wp-block-heading\"> \uc5d1\uc140 2010\uacfc \uc5d1\uc140 2013<\/h3><p> 2010 \ubc0f 2013\uc758 \uacbd\uc6b0 <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>\uc774 \ub9c1\ud06c<\/strong><\/a> \uc5d0\uc11c \ub2e4\uc6b4\ub85c\ub4dc\ud560 \uc218 \uc788\ub294 <strong>\ucd94\uac00 \uae30\ub2a5\uc744 \ubcc4\ub3c4\ub85c \uc124\uce58\ud574\uc57c \ud558\uba70<\/strong> , \uc77c\ub2e8 \uc124\uce58\ud558\uba74 \uc544\ub798\uc640 \uac19\uc774 Excel \ub9ac\ubcf8\uc5d0 \uc0c8 \ud0ed\uc774 \ud45c\uc2dc\ub429\ub2c8\ub2e4. <\/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=\"\uc804\uc6d0 \ucffc\ub9ac-excel-2013-2010\" width=\"594\" height=\"110\"><\/figure><\/div><ul><li> \uc6b0\uc120 \uc5ec\uae30(Microsoft \uacf5\uc2dd \ud648\ud398\uc774\uc9c0)\uc5d0\uc11c \uc560\ub4dc\uc778\uc744 \ub2e4\uc6b4\ub85c\ub4dc\ud558\uc138\uc694.<\/li><li> \ud30c\uc77c\uc774 \ub2e4\uc6b4\ub85c\ub4dc\ub418\uba74 \ud30c\uc77c\uc744 \uc5f4\uace0 \uc9c0\uce68\uc744 \ub530\ub974\uc2ed\uc2dc\uc624.<\/li><li> \uadf8 \ud6c4\uc5d0\ub294 Excel \ub9ac\ubcf8\uc5d0 &#8220;\ud30c\uc6cc \ucffc\ub9ac&#8221; \ud0ed\uc774 \uc790\ub3d9\uc73c\ub85c \ud45c\uc2dc\ub429\ub2c8\ub2e4.<\/li><\/ul><p> \ud639\uc2dc \uc774 &#8220;POWER QUERY&#8221; \ud0ed\uc774 \ub098\ud0c0\ub098\uc9c0 \uc54a\ub354\ub77c\ub3c4 \uac71\uc815\ud560 \ud544\uc694\uac00 \uc5c6\uc2b5\ub2c8\ub2e4. COM \ucd94\uac00 \uae30\ub2a5 \uc635\uc158\uc744 \uc0ac\uc6a9\ud558\uc5ec \ucd94\uac00\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p><ul><li> \ud30c\uc77c \ud0ed \u279c \uc635\uc158 \u279c \ucd94\uac00 \uae30\ub2a5\uc73c\ub85c \uc774\ub3d9\ud569\ub2c8\ub2e4. <\/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-\ubcf4\uc644-1\" width=\"277\" height=\"84\"><\/figure><\/div><ul><li> &#8220;\ucd94\uac00 \uae30\ub2a5&#8221; \uc635\uc158\uc5d0\uc11c &#8220;COM \ucd94\uac00 \uae30\ub2a5&#8221;\uc744 \uc120\ud0dd\ud558\uace0 \uc774\ub3d9\uc744 \ud074\ub9ad\ud558\uc138\uc694.<\/li><li> \uadf8\ub7f0 \ub2e4\uc74c \u201cMicrosoft Excel\uc6a9 \ud30c\uc6cc \ucffc\ub9ac\u201d \uc0c1\uc790\ub97c \uc120\ud0dd\ud558\uc138\uc694. <\/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=\"\ud2f1-\ub9c8\ud06c-microsoft-power-query-for-excel-1\" width=\"208\" height=\"112\"><\/figure><\/div><ul><li> \ub9c8\uc9c0\ub9c9\uc5d0 \ud655\uc778\uc744 \ud074\ub9ad\ud558\uc138\uc694.<\/li><\/ul><h3 class=\"wp-block-heading\"> \uc5d1\uc140 2016, 2019, \uc624\ud53c\uc2a4 365<\/h3><p> Excel 2016, Excel 2019\ub97c \uc0ac\uc6a9 \uc911\uc774\uac70\ub098 OFFICE 365 \uad6c\ub3c5\uc774 \uc788\ub294 <strong>\uacbd\uc6b0 \uc774\ubbf8 \ub370\uc774\ud130 \ud0ed\uc5d0 &#8220;GET &amp; TRANSFORM&#8221;\uc774\ub77c\ub294 \uadf8\ub8f9\uc73c\ub85c \ud45c\uc2dc\ub429\ub2c8\ub2e4<\/strong> (\uc774\ub984\uc774 \ub9c8\uc74c\uc5d0 \ub4dc\uc2dc\ub098\uc694?). <\/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=\"\uac00\uc838\uc624\uae30 \ubc0f \ubcc0\ud658-1\" width=\"576\" height=\"183\"><\/figure><\/div><h3 class=\"wp-block-heading\"> \uc5d1\uc140 \ub9e5<\/h3><p> Mac\uc5d0\uc11c Excel\uc744 \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0 \uc774\uc5d0 \ub300\ud55c \ud30c\uc6cc \ucffc\ub9ac \ucd94\uac00 \uae30\ub2a5\uc774 \uc5c6\uc73c\uba70 <strong>\uae30\uc874 \ucffc\ub9ac\ub97c \uc0c8\ub85c \uace0\uce60 \uc218\ub9cc<\/strong> \uc788\uace0 \uc0c8 \ucffc\ub9ac\ub97c \ub9cc\ub4e4\uac70\ub098 \ucffc\ub9ac\ub97c \ud3b8\uc9d1\ud560 \uc218\ub3c4 \uc5c6\uc2b5\ub2c8\ub2e4( <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>\ub9c1\ud06c<\/strong><\/a> ). <\/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=\"\ud30c\uc6cc \ucffc\ub9ac \uc5d1\uc140 \ub9e5\" width=\"570\" height=\"114\"><\/figure><\/div><h2 class=\"wp-block-heading\"> \ud30c\uc6cc \ucffc\ub9ac \ud3b8\uc9d1\uae30<\/h2><p> \ud30c\uc6cc \ucffc\ub9ac\uc5d0\ub294 \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\uace0 \ucffc\ub9ac\ub97c \ub9cc\ub4dc\ub294 \ubaa8\ub4e0 \ub2e8\uacc4\ub97c \uc218\ud589\ud55c \ub2e4\uc74c \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0 \ub85c\ub4dc\ud560 \uc218 \uc788\ub294 \uc790\uccb4 \ud3b8\uc9d1\uae30\uac00 \uc788\uc2b5\ub2c8\ub2e4. \ud30c\uc6cc \ucffc\ub9ac \ud3b8\uc9d1\uae30\ub97c \uc5f4\ub824\uba74 \ub370\uc774\ud130 \ud0ed\uc73c\ub85c \uc774\ub3d9\ud558\uc5ec \uac00\uc838\uc624\uae30 \ubc0f \ubcc0\ud658 \u279c \ub370\uc774\ud130 \uac00\uc838\uc624\uae30 \u279c \ud30c\uc6cc \ucffc\ub9ac \ud3b8\uc9d1\uae30 \uc2e4\ud589\uc73c\ub85c \uc774\ub3d9\ud574\uc57c \ud569\ub2c8\ub2e4. <\/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=\"\uc2e4\ud589-\uc804\uc6d0-\ucffc\ub9ac-\ud3b8\uc9d1\uae30-1\" width=\"343\" height=\"467\"><\/figure><\/div><p> \ub2e4\uc74c\uc740 \ud3b8\uc9d1\uae30\ub97c \uc5f4 \ub54c \ud45c\uc2dc\ub418\ub294 \uccab \ubc88\uc9f8 \ubbf8\ub9ac\ubcf4\uae30\uc785\ub2c8\ub2e4. <\/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=\"\ud3b8\uc9d1\uc790\uc758 \uccab\uc778\uc0c1\" width=\"601\" height=\"321\"><\/figure><\/div><p> \uc774\uc81c \uac01 \uc139\uc158\uc744 \uc790\uc138\ud788 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p><h3 class=\"wp-block-heading\"> 1. \ub9ac\ubcf8<\/h3><p> \uc0ac\uc6a9 \uac00\ub2a5\ud55c \ubaa8\ub4e0 \ud0ed\uc744 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p><ul><li> <strong>\ud30c\uc77c:<\/strong> \ud30c\uc77c \ud0ed\uc5d0\uc11c \ub370\uc774\ud130\ub97c \ub85c\ub4dc\ud558\uace0, \ud3b8\uc9d1\uae30\ub97c \uc81c\uac70\ud558\uace0, \ucffc\ub9ac \ub9e4\uac1c\ubcc0\uc218\ub97c \uc5f4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li><li> <strong>\ud648<\/strong> : \ud648 \ud0ed\uc5d0\ub294 \uc5f4\uacfc \ud589 \uc0ad\uc81c, \uc774\ub3d9 \ub4f1 \ub85c\ub4dc\ub41c \ub370\uc774\ud130\ub97c \uad00\ub9ac\ud558\ub294 \uc635\uc158\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/li><li> <strong>\ubcc0\ud658<\/strong> : \uc774 \ud0ed\uc5d0\ub294 \uc5f4 \ubcd1\ud569, \uc804\uce58 \ub4f1\uacfc \uac19\uc774 \ub370\uc774\ud130\ub97c \ubcc0\ud658\ud558\uace0 \uc815\ub9ac\ud558\ub294 \ub370 \ud544\uc694\ud55c \ubaa8\ub4e0 \uc635\uc158\uc774 \ud3ec\ud568\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.<\/li><li> <strong>\uc5f4 \ucd94\uac00<\/strong> : \uace0\uae09 \ud3b8\uc9d1\uae30\uc5d0 \uc788\ub294 \ub370\uc774\ud130\uc5d0 \uc0c8 \uc5f4\uc744 \ucd94\uac00\ud560 \uc218 \uc788\ub294 \uc635\uc158\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/li><li> <strong>\ubcf4\uae30<\/strong> : \uc774 \ud0ed\uc5d0\uc11c\ub294 \uace0\uae09 \ucffc\ub9ac \ud3b8\uc9d1\uae30 \ubcf4\uae30\uc640 \ub85c\ub4dc\ub41c \ub370\uc774\ud130\ub97c \ubcc0\uacbd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li><\/ul><h3 class=\"wp-block-heading\"> 2. \uc801\uc6a9 \ub2e8\uacc4<\/h3><p> \ud3b8\uc9d1\uae30 \uc624\ub978\ucabd\uc5d0\ub294 \ucffc\ub9ac \uc774\ub984\uacfc \uc21c\uc11c\ub300\ub85c \uc801\uc6a9\ub418\ub294 \ubaa8\ub4e0 \ub2e8\uacc4\uac00 \ud3ec\ud568\ub41c \ucffc\ub9ac \uc124\uc815 \ucc3d\uc774 \uc788\uc2b5\ub2c8\ub2e4. <\/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=\"\uc801\uc6a9\ub41c \ub2e8\uacc4 \uc635\uc158 \ubaa9\ub85d\" width=\"238\" height=\"290\"><\/figure><\/div><p> \ub2e8\uacc4\ub97c \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd \ubc84\ud2bc\uc73c\ub85c \ud074\ub9ad\ud558\uba74 \uc774\ub984 \ubc14\uafb8\uae30, \uc0ad\uc81c, \ud3b8\uc9d1, \uc704 \ub610\ub294 \uc544\ub798\ub85c \uc774\ub3d9 \ub4f1\uc744 \uc218\ud589\ud560 \uc218 \uc788\ub294 \uc635\uc158 \ubaa9\ub85d\uc774 \ud45c\uc2dc\ub429\ub2c8\ub2e4. \ub2e8\uacc4\ub97c \ud074\ub9ad\ud558\uba74 \ud3b8\uc9d1\uae30\uac00 \ud574\ub2f9 \ub2e8\uacc4\uc5d0\uc11c \uc218\ud589\ub41c \ubcc0\ud658\uc73c\ub85c \uc774\ub3d9\ud569\ub2c8\ub2e4. <\/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=\"\uc801\uc6a9\ub41c \ub2e8\uacc4 \uc635\uc158 \ubaa9\ub85d\" width=\"247\" height=\"342\"><\/figure><\/div><p> \uc544\ub798\uc5d0\uc11c \ucd1d 5\ub2e8\uacc4\ub97c \ubaa8\ub450 \uc801\uc6a9\ud55c \uc704\uce58\ub97c \uc0b4\ud3b4\ubcf4\uc138\uc694. 4\ub2e8\uacc4\ub97c \ud074\ub9ad\ud558\uba74 \uc5f4 \uc774\ub984\uc774 \ubcc0\uacbd\ub418\uc9c0 \uc54a\uc740 4\ub2e8\uacc4\uc758 \ubcc0\ud658\uc73c\ub85c \uc774\ub3d9\ub429\ub2c8\ub2e4. <\/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=\"\ucd1d 5\ub2e8\uacc4 \uc801\uc6a9\" width=\"661\" height=\"226\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 3. \uc9c8\ubb38<\/h3><p> \uc67c\ucabd\uc758 \ucffc\ub9ac \ucc3d\uc5d0\ub294 \ud604\uc7ac \ud1b5\ud569 \ubb38\uc11c\uc5d0 \uc788\ub294 \ubaa8\ub4e0 \ucffc\ub9ac\uac00 \ub098\uc5f4\ub429\ub2c8\ub2e4. \uae30\ubcf8\uc801\uc73c\ub85c \ubaa8\ub4e0 \ucffc\ub9ac\ub97c \uad00\ub9ac\ud560 \uc218 \uc788\ub294 \uacf3\uc785\ub2c8\ub2e4. <\/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=\"\ucffc\ub9ac \ucc3d\" width=\"178\" height=\"288\"><\/figure><\/div><p> \ucffc\ub9ac \uc774\ub984\uc744 \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd \ubc84\ud2bc\uc73c\ub85c \ud074\ub9ad\ud558\uba74 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ubaa8\ub4e0 \uc635\uc158(\ubcf5\uc0ac, \uc0ad\uc81c, \ubcf5\uc81c \ub4f1)\uc774 \ud45c\uc2dc\ub429\ub2c8\ub2e4. <\/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=\"\ucffc\ub9ac \uc774\ub984\uc744 \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd \ubc84\ud2bc\uc73c\ub85c \ud074\ub9ad\ud558\uc138\uc694.\" width=\"254\" height=\"349\"><\/figure><\/div><p> \ucffc\ub9ac \ucc3d\uc758 \ube48 \uacf5\uac04\uc744 \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd \ubc84\ud2bc\uc73c\ub85c \ud074\ub9ad\ud55c \ub2e4\uc74c \ub370\uc774\ud130 \uc6d0\ubcf8 \uc635\uc158\uc744 \uc120\ud0dd\ud558\uc5ec \uc0c8 \ucffc\ub9ac\ub97c \ub9cc\ub4e4 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. <\/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=\"\ucffc\ub9ac \ucc3d\uc758 \ube48 \uacf5\uac04\" width=\"361\" height=\"381\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 4. \uc218\uc2dd \uc785\ub825\uc904<\/h3><p> \uc55e\uc11c \ub9d0\ud588\ub4ef\uc774 \ud3b8\uc9d1\uae30\uc5d0\uc11c \ub2e8\uacc4\ub97c \uc801\uc6a9\ud560 \ub54c\ub9c8\ub2e4 \ud574\ub2f9 \ub2e8\uacc4\uc5d0 \ub300\ud55c M \ucf54\ub4dc\uac00 \uc0dd\uc131\ub418\uace0 \uc218\uc2dd \uc785\ub825\uc904\uc5d0\uc11c \uc774 \ucf54\ub4dc\ub97c \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc218\uc2dd \uc785\ub825\uc904\uc744 \ud074\ub9ad\ud558\uba74 \ucf54\ub4dc\ub97c \ud3b8\uc9d1\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/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=\"\uc218\uc2dd \uc785\ub825\uc904\" width=\"423\" height=\"33\"><\/figure><\/div><p> M \ucf54\ub4dc \uc0ac\uc6a9 \ubc29\ubc95\uc744 \uc775\ud78c \ud6c4\uc5d0\ub294 \ucf54\ub4dc\ub97c \uc791\uc131\ud558\uace0 \uac04\ub2e8\ud788 &#8220;FX&#8221; \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uc5ec \uc0ac\uc6a9\uc790 \uc815\uc758 \ub2e8\uacc4\ub97c \uc785\ub825\ud558\uc5ec \ub2e8\uacc4\ub97c \uc0dd\uc131\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. <\/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 \ubc84\ud2bc\" width=\"168\" height=\"94\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 5. \ub370\uc774\ud130 \uac1c\uc694<\/h3><p> \ub370\uc774\ud130 \ubbf8\ub9ac\ubcf4\uae30 \uc601\uc5ed\uc740 \uc5d1\uc140 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc640 \ube44\uc2b7\ud574 \ubcf4\uc774\uc9c0\ub9cc, \uc140\uc774\ub098 \ub370\uc774\ud130\ub97c \uc9c1\uc811 \ud3b8\uc9d1\ud560 \uc218 \uc788\ub294 \uc77c\ubc18 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc640\ub294 \uc57d\uac04 \ub2e4\ub985\ub2c8\ub2e4. \ud3b8\uc9d1\uae30\uc5d0 \ub370\uc774\ud130\ub97c \ub85c\ub4dc\ud558\uba74(\uc7a0\uc2dc \ud6c4\uc5d0 \ud574\ub2f9 \uc791\uc5c5\uc744 \uc218\ud589\ud558\uaca0\uc2b5\ub2c8\ub2e4) \uc5f4 \uc774\ub984\uc774 \ud3ec\ud568\ub41c \ud5e4\ub354\uac00 \uc788\ub294 \ubaa8\ub4e0 \uc5f4\uc774 \ud45c\uc2dc\ub418\uace0 \ub370\uc774\ud130\uac00 \ud3ec\ud568\ub41c \ud589\uc774 \ud45c\uc2dc\ub429\ub2c8\ub2e4. <\/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=\"\ub370\uc774\ud130 \ubbf8\ub9ac\ubcf4\uae30 \uc601\uc5ed\" width=\"189\" height=\"268\"><\/figure><\/div><p> \uac01 \uc5f4\uc758 \uc0c1\ub2e8\uc5d0\uc11c \ud574\ub2f9 \uc5f4\uc758 \ub370\uc774\ud130 \uc720\ud615\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud3b8\uc9d1\uae30\uc5d0 \ub370\uc774\ud130\ub97c \ub85c\ub4dc\ud558\uba74 \uace0\uae09 \ucffc\ub9ac\uac00 \uc790\ub3d9\uc73c\ub85c \uac01 \uc5f4\uc5d0 \uc62c\ubc14\ub978 \ub370\uc774\ud130 \uc720\ud615\uc744(\uac70\uc758 \ud56d\uc0c1) \uc801\uc6a9\ud569\ub2c8\ub2e4.<\/p><p> \uceec\ub7fc \ud5e4\ub354 \uc88c\uce21 \uc0c1\ub2e8\uc758 \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uba74 \ud574\ub2f9 \uceec\ub7fc\uc5d0 \uc801\uc6a9\ub418\ub294 \ub370\uc774\ud130 \uc720\ud615\uc744 \ubcc0\uacbd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc5ec\uae30\uc5d0\ub294 \uadf8\ub9b4 \uc218 \uc788\ub294 \ubaa8\ub4e0 \ub370\uc774\ud130 \uc720\ud615\uc758 \ubaa9\ub85d\uc774 \ud3ec\ud568\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. <\/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=\"\uc5f4 \uba38\ub9ac\uae00 \uc67c\ucabd \uc0c1\ub2e8\uc758 \ubc84\ud2bc\" width=\"369\" height=\"376\"><\/figure><\/div><p> \uc5f4 \ud5e4\ub354 \uc67c\ucabd\uc5d0\ub294 \uc5f4 \uac12\uc744 \ud544\ud130\ub9c1\ud558\ub294 \ub370 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ud544\ud130 \ubc84\ud2bc\uc774 \uc788\uc2b5\ub2c8\ub2e4. <strong>\ucc38\uace0:<\/strong> \uc5f4\uc758 \uac12\uc744 \ud544\ud130\ub9c1\ud558\uba74 \uace0\uae09 \ucffc\ub9ac\ub294 \uc774\ub97c \ub2e8\uc77c \ub2e8\uacc4\ub85c \uac04\uc8fc\ud558\uc5ec \uc801\uc6a9\ub41c \ub2e8\uacc4\uc5d0 \ub098\uc5f4\ud569\ub2c8\ub2e4. <\/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=\"\uc5f4\uc758 \uc67c\ucabd \ud5e4\ub354\" width=\"390\" height=\"329\"><\/figure><\/div><p> \uc5f4 \ud5e4\ub354\ub97c \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd \ubc84\ud2bc\uc73c\ub85c \ud074\ub9ad\ud558\uba74 \ub370\uc774\ud130\ub97c \ubcc0\ud658\ud558\ub294 \ub370 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc635\uc158 \ubaa9\ub85d\uc774 \ud3ec\ud568\ub41c \uba54\ub274\uac00 \uc788\uace0 \uc801\uc6a9\ub41c \ud504\ub85c\uc138\uc2a4\uc758 \ub2e8\uacc4\ub85c \uc800\uc7a5\ub418\ub294 \uc635\uc158 \ubc0f PQ \uc911 \ud558\ub098\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uac83\uc744 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc544\ub2c8\ub2e4. <\/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=\"\uc5f4 \ud5e4\ub354\ub97c \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd \ubc84\ud2bc\uc73c\ub85c \ud074\ub9ad\" width=\"368\" height=\"505\"><\/figure><\/div><h2 class=\"wp-block-heading\"> \ud30c\uc6cc \ucffc\ub9ac\uc6a9 \ub370\uc774\ud130 \uc6d0\ubcf8<\/h2><p> \ud30c\uc6cc \ucffc\ub9ac\uc758 \uac00\uc7a5 \uc88b\uc740 \uc810\uc740 \uc5ec\ub7ec \uc6d0\ubcf8\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc640 \ud574\ub2f9 \ub370\uc774\ud130\ub97c \ubcc0\ud658\ud55c \ub2e4\uc74c \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0 \ub85c\ub4dc\ud560 \uc218 \uc788\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. GET &amp; TRANSFORM\uc5d0\uc11c <strong>\ub370\uc774\ud130 \uac00\uc838\uc624\uae30\ub97c<\/strong> \ud074\ub9ad\ud558\uba74 \ud3b8\uc9d1\uae30\uc5d0 \ub85c\ub4dc\ud560 \uc218 \uc788\ub294 \ub370\uc774\ud130 \uc18c\uc2a4\uc758 \uc804\uccb4 \ubaa9\ub85d\uc744 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/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=\"\uc5ec\ub7ec \uc18c\uc2a4\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\ub294 \uc635\uc158\" width=\"272\" height=\"491\"><\/figure><\/div><p> \uc774\uc81c \uc77c\ubd80 \ub370\uc774\ud130 \uc18c\uc2a4\ub97c \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p><ul><li> <strong>\ud14c\uc774\ube14\/\ubc94\uc704\uc5d0\uc11c<\/strong> : \uc774 \uc635\uc158\uc744 \uc0ac\uc6a9\ud558\uba74 \ud65c\uc131 \uc6cc\ud06c\uc2dc\ud2b8\uc5d0\uc11c \uc9c1\uc811 \uace0\uae09 \ucffc\ub9ac \ud3b8\uc9d1\uae30\ub85c \ub370\uc774\ud130\ub97c \ub85c\ub4dc\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li><li> <strong>\ud1b5\ud569 \ubb38\uc11c\uc5d0\uc11c<\/strong> : \ucef4\ud4e8\ud130\uc5d0 \uc788\ub294 \ub2e4\ub978 \ud1b5\ud569 \ubb38\uc11c\uc5d0\uc11c. \uc5f4\ub9b0 \ub300\ud654 \uc0c1\uc790\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc774 \ud30c\uc77c\uc744 \ucc3e\uc73c\uba74 \uc790\ub3d9\uc73c\ub85c \uc774 \ud30c\uc77c\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc635\ub2c8\ub2e4.<\/li><li> <strong>\ud14d\uc2a4\ud2b8\/CSV\uc5d0\uc11c<\/strong> : \ud14d\uc2a4\ud2b8 \ud30c\uc77c \ub610\ub294 \uc27c\ud45c\ub85c \uad6c\ubd84\ub41c \ud30c\uc77c\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc628 \ub2e4\uc74c \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0 \ub85c\ub4dc\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li><li> <strong>\ud3f4\ub354\uc5d0\uc11c<\/strong> : \ud3f4\ub354\uc758 \ubaa8\ub4e0 \ud30c\uc77c\uc744 \uac00\uc838\uc624\uace0 \uac15\ub825\ud55c \ucffc\ub9ac \ud3b8\uc9d1\uae30\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uc9c0\uc6d0\ud569\ub2c8\ub2e4. (\ucc38\uc870: \ud55c \ud3f4\ub354\uc758 Excel \ud30c\uc77c \uacb0\ud569)<\/li><li> <strong>\uc6f9\uc5d0\uc11c<\/strong> : \uc774 \uc635\uc158\uc744 \uc0ac\uc6a9\ud558\uba74 \uc6f9 \uc8fc\uc18c\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc635\ub2c8\ub2e4. \uc6f9\uc5d0 \uc800\uc7a5\ub41c \ud30c\uc77c\uc774 \uc788\uac70\ub098 \ub370\uc774\ud130\ub97c \uac00\uc838\uc640\uc57c \ud558\ub294 \uc6f9 \ud398\uc774\uc9c0\uac00 \uc788\ub2e4\uace0 \uac00\uc815\ud574 \ubcf4\uc138\uc694.<\/li><\/ul><h2 class=\"wp-block-heading\"> Power Query \ud3b8\uc9d1\uae30\uc5d0 \ub370\uc774\ud130\ub97c \ub85c\ub4dc\ud558\ub294 \ubc29\ubc95<\/h2><p> \uc774\uc81c \uac15\ub825\ud55c \ucffc\ub9ac \ud3b8\uc9d1\uae30\uc5d0 \ub370\uc774\ud130\ub97c \ub85c\ub4dc\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc5ec\uae30\uc5d0\ub294 \ud559\uc0dd \uc774\ub984\uacfc \uc810\uc218 \ubaa9\ub85d\uc774 \uc788\uc2b5\ub2c8\ub2e4( <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>\ub9c1\ud06c<\/strong><\/a> ). <\/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=\"\uac15\ub825\ud55c \ucffc\ub9ac \ud3b8\uc9d1\uae30\uc5d0 \ub370\uc774\ud130\ub97c \ub85c\ub4dc\ud558\ub294 \ubc29\ubc95 \uc54c\uc544\ubcf4\uae30\" width=\"329\" height=\"323\"><\/figure><\/div><p> \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0\uc11c \uc9c1\uc811 \ub370\uc774\ud130\ub97c \ub85c\ub4dc\ud558\ubbc0\ub85c \uba3c\uc800 \ud30c\uc77c\uc744 \uc5f0 \ud6c4 \uc544\ub798 \ub2e8\uacc4\ub97c \ub530\ub77c\uc57c \ud569\ub2c8\ub2e4.<\/p><ul><li> \uba3c\uc800 Excel \ud45c\ub97c \ub370\uc774\ud130\uc5d0 \uc801\uc6a9\ud569\ub2c8\ub2e4(\uadf8\ub807\uc9c0 \uc54a\uc740 \uacbd\uc6b0\uc5d0\ub3c4 PQ \ud3b8\uc9d1\uae30\uc5d0 \ub370\uc774\ud130\ub97c \ub85c\ub4dc\ud558\uae30 \uc804\uc5d0 Excel\uc5d0\uc11c \ud574\ub2f9 \uc791\uc5c5\uc744 \uc218\ud589\ud569\ub2c8\ub2e4).<\/li><li> \uc774\uc81c \ud14c\uc774\ube14\uc5d0\uc11c \uc140\uc744 \uc120\ud0dd\ud558\uace0 &#8220;\ud14c\uc774\ube14\/\ubc94\uc704\uc5d0\uc11c&#8221;(\ub370\uc774\ud130 \uac00\uc838\uc624\uae30 \ubc0f \ubcc0\ud658 \ud0ed)\ub97c \ud074\ub9ad\ud569\ub2c8\ub2e4. <\/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=\"\ud14c\uc774\ube14 \ubc94\uc704\ub97c \ud074\ub9ad\ud558\uc138\uc694\" width=\"329\" height=\"172\"><\/figure><\/div><ul><li> \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uba74 \uc5d1\uc140\uc5d0\uc11c \ub370\uc774\ud130 \ubc94\uc704\ub97c \ud655\uc778\ud558\uc5ec \uc5d1\uc140 \ud45c\ub97c \uc801\uc6a9\ud569\ub2c8\ub2e4. <\/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 \ud14c\uc774\ube14\uc744 \uc801\uc6a9\ud560 \ub370\uc774\ud130 \ubc94\uc704\" width=\"284\" height=\"167\"><\/figure><\/div><ul><li> \uc774 \uc2dc\uc810\uc5d0\uc11c Power Query \ud3b8\uc9d1\uae30\uc5d0 \ub370\uc774\ud130\uac00 \uc788\uc73c\uba70 \uc774\ub294 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. <\/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=\"\uac15\ub825\ud55c \ucffc\ub9ac \ud3b8\uc9d1\uae30\uc758 \ub370\uc774\ud130\" width=\"678\" height=\"365\"><\/figure><\/div><ul><li> \uc5ec\uae30\uc5d0\uc11c \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4:<ul><li> \uc218\uc2dd \uc785\ub825\uc904\uc5d0\uc11c PQ\ub294 \ubc29\uae08 \ud3b8\uc9d1\uae30\uc5d0 \ub85c\ub4dc\ud55c \ud14c\uc774\ube14\uc5d0 \ub300\ud55c M \ucf54\ub4dc\ub97c \uc0dd\uc131\ud588\uc2b5\ub2c8\ub2e4.<\/li><li> \ud3b8\uc9d1\uae30 \uc67c\ucabd\uc5d0\ub294 \ucffc\ub9ac \ubaa9\ub85d\uc774 \uc788\ub294 \ucffc\ub9ac \ucc3d\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/li><li> \uc624\ub978\ucabd\uc758 \ucffc\ub9ac \uc124\uc815\uc5d0\ub294 \ubaa8\ub4e0 \ub2e8\uacc4\uac00 \ub098\uc5f4\ub41c &#8220;\uc801\uc6a9\ub41c \ub2e8\uacc4&#8221;\ub77c\ub294 \uc139\uc158\uc774 \uc788\uc2b5\ub2c8\ub2e4. \ucc38\uace0: &#8220;Modified Type&#8221;\uc744 \ud558\ub098\ub3c4 \ud558\uc9c0 \uc54a\uc558\ub2e4\uace0 \uc0dd\uac01\ud558\uc154\uc57c \ud558\ub294\ub370, \uac70\uae30\uc5d0 &#8220;Modified Type&#8221;\uc774\ub77c\ub294 \ub2e8\uacc4\uac00 \uc788\uc2b5\ub2c8\ub2e4. \ud3b8\uc9d1\uae30\uc5d0 \ub370\uc774\ud130\ub97c \ub85c\ub4dc\ud558\uba74 <strong>POWER QUERY\uc758 \uc778\ud154\ub9ac\uc804\uc2a4\uc5d0 \ub300\ud574<\/strong> \uc54c\ub824\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4. \ud3b8\uc9d1\uae30\ub294 \ubaa8\ub4e0 \uc5f4\uc5d0 \ub300\ud574 \uc62c\ubc14\ub978 \ub370\uc774\ud130 \uc720\ud615\uc744 \uc790\ub3d9\uc73c\ub85c \ud655\uc778\ud558\uace0 \uc801\uc6a9\ud569\ub2c8\ub2e4. <\/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=\"\uacf5\uc2dd-\ubc14-pq\" width=\"802\" height=\"373\"><\/figure><\/div><h2 class=\"wp-block-heading\"> \ud30c\uc6cc \ucffc\ub9ac \uc608(\ud301 \ubc0f \uc694\ub839)<\/h2><p> Excel\uc5d0\uc11c \ud568\uc218 \uc218\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc77c\ubc18\uc801\uc73c\ub85c \uc218\ud589\ud558\ub294 \uba87 \uac00\uc9c0 \uae30\ubcf8 \uc791\uc5c5\uc744 \uc218\ud589\ud558\ub294 \ubc29\ubc95\uc744 \ubc30\uc6b8 \uc218 \uc788\uc9c0\ub9cc PowerQuery\ub97c \uc0ac\uc6a9\ud558\uba74 \uba87 \ubc88\uc758 \ud074\ub9ad\ub9cc\uc73c\ub85c \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/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. \uac12 \ubc14\uafb8\uae30 <\/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> \uac12 \ubaa9\ub85d\uc774 \uc788\uace0 \ud558\ub098 \uc774\uc0c1\uc758 \uac12\uc744 \ub2e4\ub978 \uac12\uc73c\ub85c \ubc14\uafb8\uace0 \uc2f6\uc2b5\ub2c8\ub2e4. \uae00\uc384, <strong>\ud30c\uc6cc \ucffc\ub9ac<\/strong> \uc758 \ub3c4\uc6c0\uc73c\ub85c \ucffc\ub9ac\ub97c \ub9cc\ub4e4\uace0 \uc774\ub7ec\ud55c \uac12\uc744 \uc989\uc2dc \ubc14\uafc0 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p><p> \uc544\ub798 \ubaa9\ub85d\uc5d0\uc11c \ub0b4 \uc774\ub984 &#8220;Puneet&#8221;\uc744 &#8220;Punit&#8221;\uc73c\ub85c \ubc14\uafd4\uc57c \ud569\ub2c8\ub2e4. <\/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=\"\uac12 \ubaa9\ub85d\" width=\"133\" height=\"299\"><\/figure><\/div><ul><li> \uba3c\uc800 \uace0\uae09 \ucffc\ub9ac \ud3b8\uc9d1\uae30\uc5d0\uc11c \ubaa9\ub85d\uc744 \ud3b8\uc9d1\ud569\ub2c8\ub2e4.<\/li><li> \uadf8\ub7f0 \ub2e4\uc74c \ud30c\uc6cc \ucffc\ub9ac \ud3b8\uc9d1\uae30\uc5d0\uc11c \u201c\ubcc0\ud658 \ud0ed\u201d\uc73c\ub85c \uc774\ub3d9\ud558\uc5ec \u201c\uac12 \ubc14\uafb8\uae30\u201d\ub97c \ud074\ub9ad\ud569\ub2c8\ub2e4. <\/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=\"\ubcc0\ud658 \ud0ed\" width=\"479\" height=\"135\"><\/figure><\/div><ul><li> \uc774\uc81c &#8220;\ucc3e\uc744 \uac12&#8221;\uc5d0 &#8220;Puneet&#8221;\uc744 \uc785\ub825\ud558\uace0 &#8220;\ubc14\uafb8\uae30&#8221;\uc5d0 &#8220;Punit&#8221;\uc744 \uc785\ub825\ud55c \ud6c4 \ud655\uc778\uc744 \ud074\ub9ad\ud569\ub2c8\ub2e4. <\/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=\"\ucc3e\uc544\uc57c \ud560 \uac00\uce58\" width=\"350\" height=\"183\"><\/figure><\/div><ul><li> \ud655\uc778\uc744 \ud074\ub9ad\ud558\uba74 \ubaa8\ub4e0 \uac12\uc774 \uc0c8 \uac12\uc73c\ub85c \ub300\uccb4\ub418\uba70 \uc774\uc81c &#8220;\ub2eb\uae30 \ubc0f \ub85c\ub4dc&#8221;\ub97c \ud074\ub9ad\ud558\uc5ec \ub370\uc774\ud130\ub97c \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0 \ub85c\ub4dc\ud569\ub2c8\ub2e4. <\/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=\"\ub2eb\uace0 \ub85c\ub4dc\ud558\uc138\uc694\" 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. \ub370\uc774\ud130 \uc815\ub82c <\/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> \uc77c\ubc18 \uc815\ub82c\uacfc \ub9c8\ucc2c\uac00\uc9c0\ub85c PowerQuery\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \uc815\ub82c\ud560 \uc218 \uc788\uc73c\uba70 \uc704 \uc608\uc81c\uc5d0\uc11c \uc0ac\uc6a9\ud55c \uac83\uacfc \ub3d9\uc77c\ud55c \uc774\ub984 \ubaa9\ub85d\uc744 \uc0ac\uc6a9\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p><ul><li> \uba3c\uc800 \uac15\ub825\ud55c \ucffc\ub9ac \ud3b8\uc9d1\uae30\uc5d0 \ub370\uc774\ud130\ub97c \ub85c\ub4dc\ud569\ub2c8\ub2e4.<\/li><li> \ud648 \ud0ed\uc5d0\ub294 \ub450 \uac1c\uc758 \uc815\ub82c \ubc84\ud2bc(\uc624\ub984\ucc28\uc21c \ubc0f \ub0b4\ub9bc\ucc28\uc21c)\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/li><li> \uc815\ub82c\ud558\ub824\uba74 \ub2e4\uc74c \ubc84\ud2bc \uc911 \ud558\ub098\ub97c \ud074\ub9ad\ud558\uc138\uc694. <\/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=\"\ub450 \uac00\uc9c0 \uc815\ub82c \ubc84\ud2bc\" 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. \uc5f4 \uc0ad\uc81c <\/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> \uc5b4\ub518\uac00\uc5d0 \ub370\uc774\ud130\uac00 \uc788\uace0 \uac70\uae30\uc5d0\uc11c \uc77c\ubd80 \uc5f4\uc744 \uc81c\uac70\ud574\uc57c \ud55c\ub2e4\uace0 \uac00\uc815\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc694\uc810\uc740 \uc0c8 \ub370\uc774\ud130\ub97c \ucd94\uac00\ud560 \ub54c\ub9c8\ub2e4 \uc774 \uc5f4\uc744 \uc0ad\uc81c\ud574\uc57c \ud55c\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. \uadf8\ub807\uc8e0? \ud558\uc9c0\ub9cc \ud30c\uc6cc \ucffc\ub9ac\uac00 \uc774\ub97c \ucc98\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p><ul><li> <span style=\"font-size: inherit; background-color: initial;\">\uc0ad\uc81c\ud558\ub824\ub294 \uc5f4\uc744 \ud558\ub098 \uc774\uc0c1 \uc120\ud0dd\ud558\uc138\uc694.<\/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=\"\uac15\ub825\ud55c \ucffc\ub9ac \ud3b8\uc9d1\uae30\uc758 \ub370\uc774\ud130 \uc5f4\uae30\" width=\"495\" height=\"248\"><\/figure><\/div><ul><li> \uc774\uc81c \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uace0 &#8220;\uc0ad\uc81c&#8221;\ub97c \uc120\ud0dd\ud558\uc2ed\uc2dc\uc624. <\/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=\"\ucca0\ud68c\ud558\ub2e4\" width=\"281\" height=\"228\"><\/figure><\/div><p> <strong>\ube60\ub978 \ud301:<\/strong> \uc120\ud0dd\ub418\uc9c0 \uc54a\uc740 \ubaa8\ub4e0 \uc5f4\uc744 \uc0ad\uc81c\ud560 \uc218 \uc788\ub294 &#8220;\ub2e4\ub978 \uc5f4 \uc81c\uac70&#8221; \uc635\uc158\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. <\/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. \uc5f4 \ubd84\ud560 <\/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> \ud14d\uc2a4\ud2b8\ub97c \uc5f4\ub85c \uc635\uc158\uacfc \ub9c8\ucc2c\uac00\uc9c0\ub85c \ud30c\uc6cc \ucffc\ub9ac\uc5d0 &#8220;\uc5f4 \ubd84\ud560&#8221;\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uc5b4\ub5bb\uac8c \uc791\ub3d9\ud558\ub294\uc9c0 \uc54c\ub824\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.<\/p><ul><li> <span style=\"font-size: inherit; background-color: initial;\">\uc5f4\uc744 \uc120\ud0dd\ud558\uace0 \ud648 \ud0ed \u279c \ubcc0\ud658 \u279c \uc5f4 \ubd84\ud560 \u279c \uad6c\ubd84 \uae30\ud638 \uae30\uc900\uc73c\ub85c \uc774\ub3d9\ud558\uc138\uc694.<\/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=\"\uc5f4 \ubd84\ud560\" width=\"578\" height=\"140\"><\/figure><\/div><ul><li> \ub4dc\ub86d\ub2e4\uc6b4 \ubaa9\ub85d\uc5d0\uc11c \uc0ac\uc6a9\uc790 \uc815\uc758\ub97c \uc120\ud0dd\ud558\uace0 &#8220;-&#8220;\ub97c \uc785\ub825\ud569\ub2c8\ub2e4.<\/li><li> \uc774\uc81c \uc5ec\uae30\uc5d0\ub294 \uc5f4 \ubd84\ud560\uc5d0 \ub300\ud55c \uc138 \uac00\uc9c0 \uc635\uc158\uc774 \uc788\uc2b5\ub2c8\ub2e4.<ul><li> \uac00\uc7a5 \uc67c\ucabd \uad6c\ubd84 \uae30\ud638<\/li><li> \ub9e8 \uc624\ub978\ucabd \uad6c\ubd84 \uae30\ud638<\/li><li> \uad6c\ubd84 \uae30\ud638\uac00 \ub098\ud0c0\ub0a0 \ub54c\ub9c8\ub2e4 <\/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=\"\uc5f4 \ub098\ub204\uae30\ub97c \uc704\ud55c \uc138 \uac00\uc9c0 \ub2e4\ub978 \uc635\uc158\" width=\"371\" height=\"252\"><\/figure><\/div><p> \uc140\uc5d0 \uad6c\ubd84 \uae30\ud638\uac00 \ud558\ub098\ub9cc \uc788\ub294 \uacbd\uc6b0 \uc138 \uac00\uc9c0 \ubaa8\ub450 \ub3d9\uc77c\ud558\uac8c \uc791\ub3d9\ud558\uc9c0\ub9cc \uad6c\ubd84 \uae30\ud638\uac00 \ub450 \uac1c \uc774\uc0c1\uc778 \uacbd\uc6b0 \uadf8\uc5d0 \ub530\ub77c \uc120\ud0dd\ud574\uc57c \ud569\ub2c8\ub2e4. <\/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=\"\uc140 \ub0b4 \uad6c\ubd84\" 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. \uc5f4 \uc774\ub984 \ubc14\uafb8\uae30 <\/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> \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd \ubc84\ud2bc\uc744 \ud074\ub9ad\ud55c \ub2e4\uc74c &#8220;\uc774\ub984 \ubc14\uafb8\uae30&#8221;\ub97c \ud074\ub9ad\ud558\uba74 \uc5f4 \uc774\ub984\uc744 \ubc14\uafc0 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/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=\"\uc5f4 \uc774\ub984 \ubc14\uafb8\uae30\" width=\"272\" height=\"121\"><\/figure><\/div><p> <strong>\ube60\ub978 \ud301<\/strong> : \uc5f4 \uc774\ub984\uc744 \ubc14\uafb8\ub294 \ucffc\ub9ac\uac00 \uc788\uace0 \ub2e4\ub978 \uc0ac\ub78c\uc774 \uc2e4\uc218\ub85c \uc774\ub984\uc744 \ubc14\uafbc\ub2e4\uace0 \uac00\uc815\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \ud55c \ubc88\uc758 \ud074\ub9ad\uc73c\ub85c \uc774 \uc774\ub984\uc744 \ubcf5\uc6d0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/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. \uc911\ubcf5 \uc5f4 <\/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> \ud30c\uc6cc \ucffc\ub9ac\uc5d0\ub294 \uc911\ubcf5 \uc5f4\uc744 \ub9cc\ub4dc\ub294 \uac04\ub2e8\ud55c \uc635\uc158\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uc911\ubcf5 \uc5f4\uc744 \uc0dd\uc131\ud558\ub824\ub294 \uc5f4\uc744 \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd \ubc84\ud2bc\uc73c\ub85c \ud074\ub9ad\ud55c \ub2e4\uc74c &#8220;\uc5f4 \ubcf5\uc81c&#8221;\ub97c \ud074\ub9ad\ud558\uae30\ub9cc \ud558\uba74 \ub429\ub2c8\ub2e4. <\/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=\"\uc911\ubcf5 \uc5f4 \uc0dd\uc131\" 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. \uc5f4\uc774\ub098 \ud589 \ubc14\uafb8\uae30 <\/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> \ud30c\uc6cc \ucffc\ub9ac\uc5d0\uc11c \uc804\uce58(transposition)\ub294 \uc5b4\ub9b0\uc774 \ub180\uc774\uc785\ub2c8\ub2e4. \uc608, \ud074\ub9ad \ud55c \ubc88\uc774\uba74 \ub429\ub2c8\ub2e4.<\/p><ul><li> \uace0\uae09 \ucffc\ub9ac \ud3b8\uc9d1\uae30\uc5d0 \ub370\uc774\ud130\ub97c \ub85c\ub4dc\ud55c \ud6c4 \uc5f4\uc774\ub098 \ud589\uc744 \uc120\ud0dd\ud558\uae30\ub9cc \ud558\uba74 \ub429\ub2c8\ub2e4.<\/li><li> \ubcc0\ud658 \ud0ed \u279c \ud45c \u279c \uc804\uce58\ub85c \uc774\ub3d9\ud569\ub2c8\ub2e4. <\/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=\"\uc5f4 \ub610\ub294 \ud589 \uc804\uce58\" 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. \uc624\ub958 \uad50\uccb4\/\uc81c\uac70 <\/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> \uc77c\ubc18\uc801\uc73c\ub85c Excel\uc5d0\uc11c \uc624\ub958\ub97c \ubc14\uafb8\uac70\ub098 \uc81c\uac70\ud558\ub824\uba74 \ucc3e\uae30 \ubc0f \ubc14\uafb8\uae30 \uc635\uc158\uc774\ub098 VBA \ucf54\ub4dc\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc PowerQuery\uc5d0\uc11c\ub294 \ud6e8\uc52c \uc27d\uc2b5\ub2c8\ub2e4. \uc544\ub798 \uc5f4\uc5d0\uc11c \uc624\ub958\uac00 \uc788\ub294 \ubd80\ubd84\uc744 \uc0b4\ud3b4\ubcf4\uace0 \uc81c\uac70\ud558\uace0 \uad50\uccb4\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/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=\"\uad50\uccb4 \ub610\ub294 \uc81c\uac70 \uc624\ub958\" width=\"201\" height=\"282\"><\/figure><\/div><p> \uc5f4\uc744 \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd \ubc84\ud2bc\uc73c\ub85c \ud074\ub9ad\ud558\uba74 \ub450 \uac00\uc9c0 \uc635\uc158\uc774 \ubaa8\ub450 \ud45c\uc2dc\ub429\ub2c8\ub2e4.<\/p><ul><li> \uc624\ub958 \uad50\uccb4<\/li><li> \uc624\ub958 \uc81c\uac70 <\/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=\"\uad50\uccb4 \uc624\ub958 \uc81c\uac70 \uc624\ub958\" 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. \ub370\uc774\ud130 \uc720\ud615 \ubcc0\uacbd <\/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> \uc5f4\uc5d0 \ub370\uc774\ud130\uac00 \uc788\uc9c0\ub9cc \uc62c\ubc14\ub978 \ud615\uc2dd\uc774 \uc544\ub2d9\ub2c8\ub2e4. \ub530\ub77c\uc11c \ud615\uc2dd\uc744 \ubcc0\uacbd\ud574\uc57c \ud560 \ub54c\ub9c8\ub2e4. <\/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=\"\ub370\uc774\ud130 \uc720\ud615 \ubcc0\uacbd\" width=\"212\" height=\"240\"><\/figure><\/div><ul><li> \uba3c\uc800 \uac15\ub825\ud55c \ucffc\ub9ac \ud3b8\uc9d1\uae30\uc5d0\uc11c \ub370\uc774\ud130\ub97c \ud3b8\uc9d1\ud569\ub2c8\ub2e4.<\/li><li> \uadf8\ub7f0 \ub2e4\uc74c \uc5f4\uc744 \uc120\ud0dd\ud558\uace0 \ubcc0\ud658 \ud0ed\uc73c\ub85c \uc774\ub3d9\ud569\ub2c8\ub2e4.<\/li><li> \uc774\uc81c \ub370\uc774\ud130 \uc720\ud615\uc5d0\uc11c \uc720\ud615\uc73c\ub85c &#8220;\ub0a0\uc9dc&#8221;\ub97c \uc120\ud0dd\ud558\uc2ed\uc2dc\uc624. <\/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. \uc608\uc81c\uc5d0\uc11c \uc5f4 \ucd94\uac00 <\/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> \uace0\uae09 \ucffc\ub9ac\uc5d0\ub294 \ud604\uc7ac \uceec\ub7fc\uacfc \uad00\ub828\ub41c \uc2e4\uc81c \uc608\uc2dc\uac00 \uc544\ub2cc \uc608\uc2dc \uceec\ub7fc\uc744 \ucd94\uac00\ud558\ub294 \uc635\uc158\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/p><p> \uc608\ub97c \ub4e4\uc5b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p><p> \ub0a0\uc9dc \uc5f4\uc758 \uc694\uc77c \uc774\ub984\uc774 \ud544\uc694\ud558\ub2e4\uace0 \uac00\uc815\ud574 \ubcf4\uc138\uc694. \uc218\uc2dd\uc774\ub098 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ub2e4\ub978 \uc635\uc158\uc744 \uc0ac\uc6a9\ud558\ub294 \ub300\uc2e0 &#8220;\uc608\uc81c\uc5d0\uc11c \uc5f4 \ucd94\uac00&#8221;\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p><p> \uc218\ud589 \ubc29\ubc95\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p><ul><li> <span style=\"font-size: inherit; background-color: initial;\">\uc5f4\uc744 \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd \ubc84\ud2bc\uc73c\ub85c \ud074\ub9ad\ud558\uace0 &#8220;\uc608\uc81c\uc5d0\uc11c \uc5f4 \ucd94\uac00&#8221;\ub97c \ud074\ub9ad\ud569\ub2c8\ub2e4.<\/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=\"\uc608\uc81c\uc5d0\uc11c \uc5f4 \ucd94\uac00\" width=\"271\" height=\"196\"><\/figure><\/div><ul><li> \uc5ec\uae30\uc11c\ub294 \ube48 \uc5f4\uc744 \uc5bb\uac8c \ub429\ub2c8\ub2e4. \uc0bd\uc785\ud560 \uc218 \uc788\ub294 \uac12 \ubaa9\ub85d\uc744 \ubcf4\ub824\uba74 \uc5f4\uc758 \uccab \ubc88\uc9f8 \uc140\uc744 \ud074\ub9ad\ud558\uc138\uc694. <\/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=\"\ube48 \uc5f4\" width=\"253\" height=\"198\"><\/figure><\/div><ul><li> &#8220;\ub0a0\uc9dc\ubd80\ud130 \uc694\uc77c \uc774\ub984&#8221;\uc744 \uc120\ud0dd\ud558\uace0 \ud655\uc778\uc744 \ud074\ub9ad\ud569\ub2c8\ub2e4. <\/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=\"\uc694\uc77c-\ub0a0\uc9dc-\uc774\ub984\" width=\"479\" height=\"286\"><\/figure><\/div><p> <strong>\ud314!<\/strong> \uc0c8 \uce7c\ub7fc\uc774 \uc5ec\uae30\uc5d0 \uc788\uc2b5\ub2c8\ub2e4. <\/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=\"\uc0c8 \uc5f4\" 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. \uccb4\uc778\uc9c0 \ubc15\uc2a4 <\/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\uc5d0\uc11c \ud14d\uc2a4\ud2b8 \ub300\uc18c\ubb38\uc790\ub97c \ubcc0\uacbd\ud558\uae30 \uc704\ud55c \ub2e4\uc74c \uc635\uc158\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/p><ul><li> \ub9e4\uc6b0 \uc791\uc740<\/li><li> \ub300\ubb38\uc790<\/li><li> \uac01 \ub2e8\uc5b4\ub97c \ub300\ubb38\uc790\ub85c \ud45c\uae30\ud558\uc138\uc694<\/li><\/ul><p> \uc5f4\uc744 \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd \ubc84\ud2bc\uc73c\ub85c \ud074\ub9ad\ud558\uace0 \uc704\uc758 \uc138 \uac00\uc9c0 \uc635\uc158 \uc911 \ud558\ub098\ub97c \uc120\ud0dd\ud558\uba74 \ub429\ub2c8\ub2e4. \ub610\ub294 \ubcc0\ud658 \ud0ed \u279c \ud14d\uc2a4\ud2b8 \uc5f4 \u279c \ud615\uc2dd\uc73c\ub85c \uc774\ub3d9\ud558\uc138\uc694. <\/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=\"\ubcc0\ud654\uc758 \uacbd\uc6b0\" 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. \uc190\uc9c8\ud558\uace0 \uccad\uc18c\ud558\uc138\uc694 <\/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> \ub370\uc774\ud130\ub97c \uc9c0\uc6b0\uac70\ub098 \uc6d0\ud558\uc9c0 \uc54a\ub294 \uacf5\ubc31\uc744 \uc81c\uac70\ud558\ub824\uba74 PowerQuery\uc5d0\uc11c TRIM \ubc0f CLEAN \uc635\uc158\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub2e8\uacc4\ub294 \uac04\ub2e8\ud569\ub2c8\ub2e4.<\/p><ul><li> \uc5f4\uc744 \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd \ubc84\ud2bc\uc73c\ub85c \ud074\ub9ad\ud558\uac70\ub098 \uc5f4\uc774 \uc5ec\ub7ec \uac1c\uc778 \uacbd\uc6b0 \ubaa8\ub4e0 \uc5f4\uc744 \uc120\ud0dd\ud569\ub2c8\ub2e4.<\/li><li> \ubcc0\ud658 \ud0ed \u279c \ud14d\uc2a4\ud2b8 \uc5f4 \u279c \ud615\uc2dd\uc73c\ub85c \uc774\ub3d9\ud569\ub2c8\ub2e4.<ol><li> TRIM: \uc140\uc758 \ub05d\uacfc \uc2dc\uc791 \ubd80\ubd84\uc5d0\uc11c \uacf5\ubc31\uc744 \uc81c\uac70\ud569\ub2c8\ub2e4.<\/li><li> CLEAN: \uc140\uc5d0\uc11c \uc778\uc1c4\ub418\uc9c0 \uc54a\ub294 \ubb38\uc790\ub97c \uc81c\uac70\ud569\ub2c8\ub2e4. <\/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=\"\uc190\uc9c8\ud558\uace0 \uccad\uc18c\ud558\ub2e4\" 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. \uc811\ub450\uc0ac\/\uc811\ubbf8\uc0ac \ucd94\uac00 <\/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> \ub530\ub77c\uc11c \uac12 \ubaa9\ub85d\uc774 \uc788\uace0 \uc774 \ubaa9\ub85d\uc5d0\uc11c \uac01 \uc140\uc5d0 \uc811\ub450\uc0ac\/\uc811\ubbf8\uc0ac\ub97c \ucd94\uac00\ud558\ub824\uace0 \ud569\ub2c8\ub2e4. Excel\uc5d0\uc11c\ub294 \uc5f0\uacb0 \ubc29\ubc95\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc9c0\ub9cc PowerQuery\uc5d0\ub294 \ub450 \uac00\uc9c0 \ubaa8\ub450\uc5d0 \ub300\ud574 \uc0ac\uc6a9\ud558\uae30 \uc26c\uc6b4 \uc635\uc158\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/p><ul><li> \uba3c\uc800 \uc811\ub450\uc0ac\/\uc811\ubbf8\uc0ac\ub97c \ucd94\uac00\ud574\uc57c \ud558\ub294 \uc5f4\uc744 \uc120\ud0dd\ud569\ub2c8\ub2e4.<\/li><li> \uadf8\ub7f0 \ub2e4\uc74c \ubcc0\ud658 \ud0ed \u279c \ud14d\uc2a4\ud2b8 \uc5f4 \u279c \ud615\uc2dd \u279c \uc811\ub450\uc0ac \ucd94\uac00\/\uc811\ubbf8\uc0ac \ucd94\uac00\ub85c \uc774\ub3d9\ud569\ub2c8\ub2e4. <\/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=\"\ucef7 \uc564 \ud074\ub9b0-1\" width=\"252\" height=\"259\"><\/figure><\/div><ul><li> \uc635\uc158 \uc911 \ud558\ub098\ub97c \ud074\ub9ad\ud558\uba74 \ud14d\uc2a4\ud2b8\ub97c \uc785\ub825\ud560 \uc218 \uc788\ub294 \ub300\ud654 \uc0c1\uc790\uac00 \ub098\ud0c0\ub0a9\ub2c8\ub2e4. <\/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=\"\ud14d\uc2a4\ud2b8\ub97c \uc785\ub825\ud558\ub294 \ub300\ud654 \uc0c1\uc790\" width=\"309\" height=\"130\"><\/figure><\/div><ul><li> \uadf8\ub9ac\uace0 \ud14d\uc2a4\ud2b8\ub97c \uc785\ub825\ud558\uc2e0 \ud6c4 \ud655\uc778\uc744 \ub20c\ub7ec\uc8fc\uc138\uc694. <\/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=\"\ud14d\uc2a4\ud2b8 \uc785\ub825-\ud074\ub9ad-\ud655\uc778\" 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. \uac12 \ucd94\ucd9c <\/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> \ub2f9\uc2e0\uc774 \uc218\uc2dd \ub9e4\ub2c8\uc544\ub77c\uba74 \uc140\uc5d0\uc11c \ud14d\uc2a4\ud2b8\ub098 \uc22b\uc790\ub97c \ucd94\ucd9c\ud558\ub824\uba74 \ub2e4\uc591\ud55c \uae30\ub2a5\uc744 \uacb0\ud569\ud574\uc57c \ud55c\ub2e4\ub294 \ub0b4 \ub9d0\uc5d0 \ub3d9\uc758\ud560 \uac83\uc785\ub2c8\ub2e4. \uadf8\ub7ec\ub098 PowerQuery\ub294 \uc774\ub7ec\ud55c \ubb38\uc81c \uc911 \ub9ce\uc740 \ubd80\ubd84\uc744 \ud574\uacb0\ud588\uc2b5\ub2c8\ub2e4. \uc140\uc5d0\uc11c \uac12\uc744 \ucd94\ucd9c\ud558\ub294 \ubc29\ubc95\uc5d0\ub294 7\uac00\uc9c0\uac00 \uc788\uc2b5\ub2c8\ub2e4. <\/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=\"\uac12 \ucd94\ucd9c\" 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. \ub0a0\uc9dc\ub098 \uc2dc\uac04\ub9cc <\/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> \ub0a0\uc9dc\uc640 \uc2dc\uac04\uc774 \ud558\ub098\uc758 \uc140\uc5d0 \ubaa8\ub450 \uc788\uc9c0\ub9cc \ub458 \uc911 \ud558\ub098\uac00 \ud544\uc694\ud55c \uacbd\uc6b0\uac00 \uc885\uc885 \uc788\uc2b5\ub2c8\ub2e4. <\/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=\"\ub0a0\uc9dc \ub610\ub294 \uc2dc\uac04\ub9cc\" width=\"180\" height=\"298\"><\/figure><\/div><ul><li> \ub0a0\uc9dc\uc640 \uc2dc\uac04\uc774 \uacb0\ud569\ub41c \uc5f4\uc744 \uc120\ud0dd\ud569\ub2c8\ub2e4.<\/li><li> \ub124\uac00 \uc6d0\ud55c\ub2e4\uba74:<ul><li> <strong>\ub0a0\uc9dc<\/strong> : \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd \ubc84\ud2bc \ud074\ub9ad \u279c \ubcc0\ud658 \u279c \ub0a0\uc9dc\ub9cc \uc120\ud0dd\ud569\ub2c8\ub2e4.<\/li><li> <strong>\uc2dc\uac04<\/strong> : \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd \ubc84\ud2bc \ud074\ub9ad \u279c \ubcc0\ud658 \u279c \uc2dc\uac04\ub9cc \uc120\ud0dd\ud569\ub2c8\ub2e4. <\/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=\"\ub370\uc774\ud2b8\ud558\uace0 \uc2f6\ub2e4\uba74\" 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=\"\uc2dc\uac04\uc744 \uc6d0\ud55c\ub2e4\uba74\" 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. \ub0a0\uc9dc\uc640 \uc2dc\uac04 \uacb0\ud569 <\/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> \uc774\uc81c \ub0a0\uc9dc\uc640 \uc2dc\uac04\uc744 \uad6c\ubd84\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uc558\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \ub2e4\uc74c\uc5d0\ub294 \uadf8\uac83\ub4e4\uc744 \uacb0\ud569\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uc544\uc57c \ud569\ub2c8\ub2e4. <\/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=\"\ub0a0\uc9dc\uc640 \uc2dc\uac04 \uacb0\ud569\" width=\"408\" height=\"256\"><\/figure><\/div><ul><li> \uba3c\uc800 \ub0a0\uc9dc \uc5f4\uc744 \uc120\ud0dd\ud558\uace0 &#8220;\ub0a0\uc9dc\ub9cc&#8221; \uc635\uc158\uc744 \ud074\ub9ad\ud558\uc138\uc694.<\/li><li> \uadf8\ub7f0 \ub2e4\uc74c \ub450 \uc5f4(\ub0a0\uc9dc \ubc0f \uc2dc\uac04)\uc744 \ubaa8\ub450 \uc120\ud0dd\ud558\uace0 \ubcc0\ud658 \ud0ed\uc73c\ub85c \uc774\ub3d9\ud55c \ub2e4\uc74c &#8220;\ub0a0\uc9dc \ubc0f \uc2dc\uac04 \uc5f4&#8221; \uadf8\ub8f9\uc5d0\uc11c \ub0a0\uc9dc\ub85c \uc774\ub3d9\ud558\uc5ec &#8220;\ub0a0\uc9dc \ubc0f \uc2dc\uac04 \uacb0\ud569&#8221;\uc744 \ud074\ub9ad\ud569\ub2c8\ub2e4. <\/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=\"\ub0a0\uc9dc\uc640 \uc2dc\uac04 \uacb0\ud569\" 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. \ubc18\uc62c\ub9bc\ub41c \uc22b\uc790 <\/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> \ub2e4\uc74c\uc740 \uc22b\uc790 \ubc18\uc62c\ub9bc\uc5d0 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc635\uc158\uc785\ub2c8\ub2e4.<\/p><ul><li> \ubc18\uc62c\ub9bc: \uc22b\uc790\ub97c \ubc18\uc62c\ub9bc\ud569\ub2c8\ub2e4.<\/li><li> Round: \uc22b\uc790\ub97c \ubc18\uc62c\ub9bc\ud569\ub2c8\ub2e4.<\/li><li> \ubc18\uc62c\ub9bc: \uc18c\uc218\uc810 \uc774\ud558 \uc790\ub9bf\uc218\ub97c \uc5b4\ub290 \uc815\ub3c4\uae4c\uc9c0 \ubc18\uc62c\ub9bc\ud560 \uc218 \uc788\ub294\uc9c0 \uc120\ud0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/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=\"\ubc18\uc62c\ub9bc\ub41c \uc22b\uc790\" width=\"235\" height=\"175\"><\/figure><\/div><p> \ub2e8\uacc4\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p><ul><li> <span style=\"font-size: inherit; background-color: initial;\">\uc5f4\uc744 \uc120\ud0dd\ud558\uace0 \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uace0 \u279c \ubcc0\ud658 \u279c \ub77c\uc6b4\ub4dc\ub97c \ud074\ub9ad\ud569\ub2c8\ub2e4<\/span> .<ol><li> \ubc18\uc62c\ub9bc: \uc22b\uc790\ub97c \ubc18\uc62c\ub9bc\ud569\ub2c8\ub2e4.<\/li><li> Round: \uc22b\uc790\ub97c \ubc18\uc62c\ub9bc\ud569\ub2c8\ub2e4.<\/li><li> \ubc18\uc62c\ub9bc: \uc18c\uc218\uc810 \uc774\ud558 \uc790\ub9bf\uc218\ub97c \uc5b4\ub290 \uc815\ub3c4\uae4c\uc9c0 \ubc18\uc62c\ub9bc\ud560 \uc218 \uc788\ub294\uc9c0 \uc120\ud0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li><\/ol><\/li><\/ul><p> <strong>\ucc38\uace0:<\/strong> &#8220;#3 \ubc18\uc62c\ub9bc&#8221; \uc635\uc158\uc744 \uc120\ud0dd\ud55c \uacbd\uc6b0 \ubc18\uc62c\ub9bc\ud560 \uc18c\uc218 \uc790\ub9bf\uc218\ub97c \uc785\ub825\ud574\uc57c \ud569\ub2c8\ub2e4. <\/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. \uacc4\uc0b0 <\/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> \uacc4\uc0b0\uc744 \uc218\ud589\ud558\ub294 \ub370 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc635\uc158\uc774 \ub9ce\uc774 \uc788\uc2b5\ub2c8\ub2e4. \ubcc0\ud658 \ud0ed(\uc22b\uc790 \uc5f4 \uadf8\ub8f9)\uc5d0\uc11c \uc774\ub7ec\ud55c \uc635\uc158\uc744 \ubaa8\ub450 \ucc3e\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p><ul><li> \uae30\ucd08\uc801\uc778<\/li><li> \ud1b5\uacc4<\/li><li> \uacfc\ud559\uc790<\/li><li> \uc0bc\uac01\ubc95<\/li><li> \ub465\uadfc<\/li><li> \uc815\ubcf4 <\/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=\"\uacc4\uc0b0\" width=\"274\" height=\"131\"><\/figure><\/div><p> \uc774\ub7ec\ud55c \uacc4\uc0b0\uc744 \uc218\ud589\ud558\ub824\uba74 \uc5f4\uc744 \uc120\ud0dd\ud55c \ub2e4\uc74c \uc635\uc158\uc744 \uc120\ud0dd\ud574\uc57c \ud569\ub2c8\ub2e4. <\/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. \uadf8\ub8f9\ud654 \uae30\uc900 <\/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> \ub300\uaddc\ubaa8 \ub370\uc774\ud130 \uc138\ud2b8\uac00 \uc788\uace0 \uc694\uc57d \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud55c\ub2e4\uace0 \uac00\uc815\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc218\ud589\ud574\uc57c \ud560 \uc791\uc5c5\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. <\/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=\"\uadf8\ub8f9\ubcc4\" width=\"390\" height=\"294\"><\/figure><\/div><ul><li> \ubcc0\ud658 \ud0ed\uc5d0\uc11c &#8216;\uadf8\ub8f9\ud654 \uae30\uc900&#8217; \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uba74 \ub300\ud654 \uc0c1\uc790\uac00 \ub098\ud0c0\ub0a9\ub2c8\ub2e4. <\/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=\"\ubc84\ud2bc\ubcc4\ub85c \uadf8\ub8f9\ud654\" width=\"241\" height=\"142\"><\/figure><\/div><ul><li> \uc774\uc81c \uc774 \ub300\ud654 \uc0c1\uc790\uc5d0\uc11c \uadf8\ub8f9\ud654\ud558\ub824\ub294 \uc5f4\uc744 \uc120\ud0dd\ud558\uace0 \uc774\ub984\uc744 \ucd94\uac00\ud55c \ud6c4 \uc791\uc5c5\uacfc \uac12\uc774 \uc788\ub294 \uc5f4\uc744 \uc120\ud0dd\ud569\ub2c8\ub2e4. <\/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=\"\ub300\ud654 \uc0c1\uc790 \uc120\ud0dd \uc5f4\" width=\"461\" height=\"180\"><\/figure><\/div><ul><li> \ub9c8\uc9c0\ub9c9\uc5d0 \ud655\uc778\uc744 \ud074\ub9ad\ud558\uc138\uc694. <\/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=\"\ub9c8\uc9c0\ub9c9 \ud074\ub9ad-\ud655\uc778\" width=\"268\" height=\"311\"><\/figure><\/div><p> <strong>\ucc38\uace0:<\/strong> &#8220;\uadf8\ub8f9\ud654 \uae30\uc900&#8221; \uc635\uc158\uc5d0\ub294 \ub2e4\uc911 \ub808\ubca8 \uadf8\ub8f9 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\ub294 \ub370 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uace0\uae09 \uc635\uc158\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. <\/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. \uc74c\uc218 \uac12 \uc81c\uac70 <\/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> \ub0b4 \ube14\ub85c\uadf8 \uac8c\uc2dc\ubb3c \uc911 \ud558\ub098\uc5d0\uc11c \ubd80\uc815\uc801\uc778 \uae30\ud638\ub97c \uc81c\uac70\ud558\ub294 7\uac00\uc9c0 \ubc29\ubc95\uc744 \ub098\uc5f4\ud588\ub294\ub370 \ud30c\uc6cc \ucffc\ub9ac\uac00 \uadf8 \uc911 \ud558\ub098\uc785\ub2c8\ub2e4. \uc5f4\uc744 \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd \ubc84\ud2bc\uc73c\ub85c \ud074\ub9ad\ud558\uace0 \ubcc0\ud658 \uc635\uc158\uc73c\ub85c \uc774\ub3d9\ud55c \ub2e4\uc74c &#8220;\uc808\ub300\uac12&#8221;\uc744 \ud074\ub9ad\ud569\ub2c8\ub2e4. <\/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=\"\uc74c\uc218 \uac12 \uc81c\uac70\" width=\"447\" height=\"241\"><\/figure><\/div><p> \uadf8\ub7ec\uba74 \uac12\uc5d0\uc11c \ubaa8\ub4e0 \uc74c\uc218 \ubd80\ud638\uac00 \uc989\uc2dc \uc81c\uac70\ub429\ub2c8\ub2e4. <\/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\"> \ub354 \ub9ce\uc740 \uc608\uc2dc<\/h3><ol><li> Excel\uc758 \ud30c\uc6cc \ucffc\ub9ac\uc5d0\uc11c VLOOKUP \uc218\ud589<\/li><li> \ud30c\uc6cc \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130 \ud53c\ubc97 \uc81c\uac70<\/li><li> \ud30c\uc6cc \ucffc\ub9ac\uc758 IF \ubb38<\/li><li> \ud30c\uc6cc \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\uc5ec \uac12(\ud14d\uc2a4\ud2b8 \ubc0f \uc22b\uc790) \uc5f0\uacb0<\/li><li> \ud30c\uc6cc \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub0a0\uc9dc \ucc28\uc774 \uacc4\uc0b0<\/li><\/ol><\/div><\/div><h2 class=\"wp-block-heading\"> \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0 \ub370\uc774\ud130\ub97c \ub85c\ub4dc\ud558\ub294 \ubc29\ubc95<\/h2><p> \ub370\uc774\ud130\ub97c \ubcc0\ud658\ud55c \ud6c4\uc5d0\ub294 \uc774\ub97c \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0 \ub85c\ub4dc\ud558\uc5ec \ucd94\uac00 \ubd84\uc11d\uc5d0 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud648 \ud0ed\uc5d0\ub294 &#8220;\ub2eb\uae30 \ubc0f \ub85c\ub4dc&#8221;\ub77c\ub294 \ubc84\ud2bc\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uba74 \ucd94\uac00 \uc635\uc158\uc744 \uc81c\uacf5\ud558\ub294 \ub4dc\ub86d\ub2e4\uc6b4 \ubaa9\ub85d\uc774 \ud45c\uc2dc\ub429\ub2c8\ub2e4.<\/p><ul><li> \ub2eb\uace0 \ub85c\ub4dc\ud558\uae30<\/li><li> \ub2eb\uace0 \ub85c\ub4dc\ud558\uc138\uc694. <\/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=\"\ub2eb\uae30 \ubc0f \ub85c\ub4dc\" width=\"199\" height=\"224\"><\/figure><\/div><ul><li> \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uba74 \ub2e4\uc74c \uc635\uc158\uc774 \ud45c\uc2dc\ub429\ub2c8\ub2e4. <\/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=\"\ub370\uc774\ud130 \uac00\uc838\uc624\uae30 \uc635\uc158\" width=\"276\" height=\"277\"><\/figure><\/div><ul><li> \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0 \uc774 \ub370\uc774\ud130\ub97c \ud45c\uc2dc\ud560 \ubc29\ubc95\uc744 \uc120\ud0dd\ud558\uc138\uc694.<ul><li> \uadf8\ub9bc<\/li><li> \ud53c\ubc97 \ud14c\uc774\ube14 \ubcf4\uace0\uc11c:<\/li><li> \ud14c\uc774\ube14 \ud53c\ubc97<\/li><li> \ud558\ub098\uc758 \uc5f0\uacb0\ub9cc \uc0dd\uc131<\/li><li> \ub370\uc774\ud130\ub97c \uc5b4\ub514\uc5d0 \uc800\uc7a5\ud558\uc2dc\uaca0\uc2b5\ub2c8\uae4c?<ul><li> \uae30\uc874 \uc6cc\ud06c\uc2dc\ud2b8<\/li><li> \uc0c8 \uc6cc\ud06c\uc2dc\ud2b8.<\/li><\/ul><\/li><li> \uc774 \ub370\uc774\ud130\ub97c \ub370\uc774\ud130 \ubaa8\ub378\uc5d0 \ucd94\uac00\ud569\ub2c8\ub2e4.<\/li><\/ul><\/li><li> \ud14c\uc774\ube14 \uc635\uc158\uacfc \uc0c8 \uc6cc\ud06c\uc2dc\ud2b8\ub97c \uc120\ud0dd\ud558\uace0 \ub370\uc774\ud130 \ubaa8\ub378\uc744 \uc120\ud0dd \ucde8\uc18c\ud55c \uc0c1\ud0dc\ub85c \ub450\uace0 \ud655\uc778\uc744 \ud074\ub9ad\ud558\uc138\uc694. <\/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=\"\ub370\uc774\ud130 \uac00\uc838\uc624\uae30 \uc635\uc158-2\" width=\"298\" height=\"300\"><\/figure><\/div><ul><li> \ud655\uc778\uc744 \ud074\ub9ad\ud558\ub294 \uc21c\uac04 \ub370\uc774\ud130\uac00 \ud3ec\ud568\ub41c \uc0c8 \uc6cc\ud06c\uc2dc\ud2b8\uac00 \ucd94\uac00\ub429\ub2c8\ub2e4. <\/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=\"\ub370\uc774\ud130\uac00 \ud3ec\ud568\ub41c \uc0c8 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\" width=\"333\" height=\"254\"><\/figure><\/div><p> \ub354 \ub9ce\uc740 \ud559\uc2b5 \uc608\uc2dc<\/p><h2 class=\"wp-block-heading\"> \ucffc\ub9ac \uc790\ub3d9 \uc0c8\ub85c \uace0\uce68<\/h2><p> \ub0b4\uac00 \uc5ec\uae30\uc5d0 \uc778\uc6a9\ud55c \ubaa8\ub4e0 \uc608 \uc911\uc5d0\uc11c \uc774\uac83\uc774 \uac00\uc7a5 \uc911\uc694\ud569\ub2c8\ub2e4. \ucffc\ub9ac\ub97c \uc0dd\uc131\ud558\uba74 \uc790\ub3d9\uc73c\ub85c \uc0c8\ub85c \uace0\uce60 \uc218 \uc788\uc2b5\ub2c8\ub2e4(\ud0c0\uc774\uba38 \uc124\uc815 \uac00\ub2a5).<\/p><p> \ub2e8\uacc4\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p><ul><li> \ub370\uc774\ud130 \ud0ed\uc5d0\uc11c \u201c\ucffc\ub9ac \ubc0f \uc5f0\uacb0\u201d\uc744 \ud074\ub9ad\ud558\uba74 \ucc3d \uc624\ub978\ucabd\uc5d0 \ucffc\ub9ac \ubc0f \uc5f0\uacb0 \ucc3d\uc774 \ud45c\uc2dc\ub429\ub2c8\ub2e4. <\/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=\"\uc694\uccad \ubc0f \uc5f0\uacb0\" width=\"285\" height=\"211\"><\/figure><\/div><ul><li> \uc774\uc81c \ucffc\ub9ac\ub97c \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd \ubc84\ud2bc\uc73c\ub85c \ud074\ub9ad\ud558\uace0 &#8220;\uc0c8\ub85c \uace0\uce68 \uac04\uaca9&#8221;\uc744 \uc120\ud0dd\ud55c \ub2e4\uc74c \ubd84\uc744 \uc785\ub825\ud558\uc138\uc694. <\/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=\"\ucffc\ub9ac \ud655\uc778 \ud45c\uc2dc\ub97c \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd \ubc84\ud2bc\uc73c\ub85c \ud074\ub9ad\ud558\uc138\uc694.\" width=\"471\" height=\"300\"><\/figure><\/div><h2 class=\"wp-block-heading\"> \ud30c\uc6cc \ucffc\ub9ac\uc5d0\uc11c \uc218\uc2dd \ubc0f \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95<\/h2><p> Excel \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0\uc11c \ud568\uc218\uc640 \uc218\uc2dd\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uac83\ucc98\ub7fc \uace0\uae09 \ucffc\ub9ac\uc5d0\ub294 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc790\uccb4 \ud568\uc218 \ubaa9\ub85d\uc774 \uc788\uc2b5\ub2c8\ub2e4. PowerQuery\uc758 \ud568\uc218 \ubc0f \uc218\uc2dd \uc5d0 \ub300\ud55c \uae30\ubcf8 \uc0ac\ud56d\uc740 Excel\uc758 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8 \ud568\uc218\uc640 \ub3d9\uc77c\ud569\ub2c8\ub2e4.<\/p><p> PQ\uc5d0\uc11c \ud568\uc218\ub098 \uc218\uc2dd\uc744 \ucd94\uac00\ud558\ub824\uba74 \uc0c8 \uc0ac\uc6a9\uc790 \uc815\uc758 \uc5f4\uc744 \ucd94\uac00\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p><p> \uc608\ub97c \ub4e4\uc5b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc544\ub798 \ub370\uc774\ud130(\uc774\ubbf8 PQ \ud3b8\uc9d1\uae30\uc5d0 \uc788\uc74c)\uc5d0\ub294 \uc131\uacfc \uc774\ub984( <strong><a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/score-des-eleves.xlsx\">DOWNLOAD LINK<\/a> )<\/strong> \uc774 \uc788\uc2b5\ub2c8\ub2e4. <\/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=\"\ub370\uc774\ud130-\uc774\ubbf8-pq-editor-1\" width=\"454\" height=\"302\"><\/figure><\/div><p> \ub450 \uc774\ub984\uc744 \ubcd1\ud569\ud558\uace0 \uc804\uccb4 \uc774\ub984\uc5d0 \ub300\ud55c \uc5f4\uc744 \ub9cc\ub4e4\uc5b4\uc57c \ud55c\ub2e4\uace0 \uac00\uc815\ud574 \ubcf4\uc138\uc694. \uc774 \uacbd\uc6b0 \uac04\ub2e8\ud55c \uc218\uc2dd\uc744 \uc785\ub825\ud558\uc5ec \ub450 \uc5f4\uc758 \uc774\ub984\uc744 \uc5f0\uacb0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p><ul><li> \uba3c\uc800 \uc5f4 \ucd94\uac00 \ud0ed\uc73c\ub85c \uc774\ub3d9\ud558\uc5ec <strong>\u201c\uc0ac\uc6a9\uc790 \uc9c0\uc815 \uc5f4\u201d\uc744 \ud074\ub9ad\ud558\uc138\uc694.<\/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=\"\uc5f4 \ud0ed \ucd94\uac00\" width=\"499\" height=\"180\"><\/figure><\/div><ul><li> \uc774\uc81c \uc0ac\uc6a9\uc790 \uc815\uc758 \uc5f4 \ub300\ud654 \uc0c1\uc790\uc5d0\uc11c \uc0c8 \uc5f4\uc758 <strong>\uc774\ub984\uc778 &#8220;\uc804\uccb4 \uc774\ub984&#8221;\uc744 \uc785\ub825\ud558\uac70\ub098<\/strong> \uc0c8 \uc5f4\uc758 \uc774\ub984\uc744 \uc9c0\uc815\ud558\uace0 \uc2f6\uc740 \uc774\ub984\uc744 \uc785\ub825\ud558\uc138\uc694. <\/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=\"\ub9de\ucda4 \uc5f4\" width=\"526\" height=\"330\"><\/figure><\/div><ul><li style=\"list-style-type: none;\"><ul><li> \ub9de\ucda4 \uc5f4 \uc218\uc2dd\uc5d0\ub294 \uc218\uc2dd\uc744 \uc785\ub825\ud574\uc57c \ud558\ub294 \uacf3\uc774 \uc788\uc2b5\ub2c8\ub2e4. <strong>\ub530\ub77c\uc11c \uc544\ub798 \uc218\uc2dd\uc744 \uc785\ub825\ud558\uc138\uc694<\/strong> . <\/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=\"\ub9de\ucda4 \uc5f4 \uc218\uc2dd\" width=\"529\" height=\"332\"><\/figure><\/div><ul><li> &#8220;\uc0ac\uc6a9\uc790 \uc815\uc758 \uc5f4 \uc218\uc2dd&#8221;\uc5d0 \uc218\uc2dd\uc744 \uc785\ub825\ud558\uba74 PQ\ub294 \uc785\ub825\ud55c \uc218\uc2dd\uc744 \ud655\uc778\ud558\uace0 &#8220;\uad6c\ubb38 \uc624\ub958\uac00 \uac10\uc9c0\ub418\uc9c0 \uc54a\uc558\uc2b5\ub2c8\ub2e4&#8221;\ub77c\ub294 \uba54\uc2dc\uc9c0\ub97c \ud45c\uc2dc\ud558\uba70, \uc624\ub958\uac00 \uc788\ub294 \uacbd\uc6b0 \uc624\ub958 \uc720\ud615\uc5d0 \ub530\ub77c \uc624\ub958 \uba54\uc2dc\uc9c0\ub97c \ud45c\uc2dc\ud569\ub2c8\ub2e4.<\/li><li> \uc218\uc2dd\uc744 \uc785\ub825\ud588\uace0 \uc624\ub958\uac00 \uc5c6\uc73c\uba74 \ud655\uc778\uc744 \ub204\ub974\uc138\uc694.<\/li><li> \uc774\uc81c \ub370\uc774\ud130 \ub05d\uc5d0 \ub450 \uc5f4(\uc774\ub984\uacfc \uc131)\uc758 \uac12\uc774 \ud3ec\ud568\ub41c \uc0c8 \uc5f4\uc774 \uc0dd\uacbc\uc2b5\ub2c8\ub2e4. <\/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=\"\ub370\uc774\ud130 \ub05d\uc758 \uc0c8 \uc5f4\" width=\"593\" height=\"208\"><\/figure><\/div><h3 class=\"wp-block-heading\"> \ud30c\uc6cc \ucffc\ub9ac\uc5d0\uc11c \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95<\/h3><p> \ub9c8\ucc2c\uac00\uc9c0\ub85c \uc0ac\uc6a9\uc790 \uc9c0\uc815 \uc5f4\uc744 \ucd94\uac00\ud558\ub294 \ub3d9\uc548 \ud568\uc218\ub97c \uc0ac\uc6a9\ud560 \uc218\ub3c4 \uc788\uc73c\uba70 \ud30c\uc6cc \ucffc\ub9ac\uc5d0\ub294 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ub2e4\uc591\ud55c \ud568\uc218 \ubaa9\ub85d\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/p><p> \uc27d\uace0 \uac04\ub2e8\ud55c \uc608\ub97c \ud1b5\ud574 \ud568\uc218\uc758 \uc0ac\uc6a9\ubc95\uc744 \uc774\ud574\ud574\ubcf4\uc790. \uc774\ub984\uacfc \uc131\uc744 \uacb0\ud569\ud55c \uc0c8 \uc5f4\uc744 \ucd94\uac00\ud55c \uc704\uc758 \uc608\ub97c \uacc4\uc18d \uc9c4\ud589\ud569\ub2c8\ub2e4. <\/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=\"\uc0ac\uc6a9\uc790 \uc815\uc758 \uc5f4\uc744 \ucd94\uac00\ud560 \ub54c \uae30\ub2a5 \uc0ac\uc6a9\" width=\"434\" height=\"274\"><\/figure><\/div><p> \ud558\uc9c0\ub9cc \uc774\uc81c \uc774 \uc5f4\uc5d0 \uc788\ub294 \uc804\uccb4 \uc774\ub984 \ud14d\uc2a4\ud2b8\ub97c \ub300\ubb38\uc790\ub85c \ubcc0\ud658\ud574\uc57c \ud569\ub2c8\ub2e4. \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uae30\ub2a5\uc740 <strong>\u201c <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> \u201d<\/strong> \uc785\ub2c8\ub2e4. \uc774\ub984\uc5d0\uc11c \uc54c \uc218 \uc788\ub4ef\uc774 \ud14d\uc2a4\ud2b8\ub97c \ub300\ubb38\uc790 \ud14d\uc2a4\ud2b8\ub85c \ubcc0\ud658\ud569\ub2c8\ub2e4.<\/p><ul><li> \uba3c\uc800 \uc5f4 \ucd94\uac00 \ud0ed\uc73c\ub85c \uc774\ub3d9\ud558\uc5ec \ub9de\ucda4 \uc5f4\uc744 \ud074\ub9ad\ud558\uc138\uc694. <\/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=\"\ub9de\ucda4 \uc5f4\uc744 \ud074\ub9ad\ud558\uc138\uc694.\" width=\"391\" height=\"196\"><\/figure><\/div><ul><li style=\"list-style-type: none;\"><ul><li> \uc774\uc81c \uc0ac\uc6a9\uc790 \uc815\uc758 \uc5f4 \ub300\ud654 \uc0c1\uc790\uc5d0\uc11c \uc0ac\uc6a9\uc790 \uc815\uc758 \uc5f4 \uc218\uc2dd \uc0c1\uc790\uc5d0 \uc544\ub798\uc758 \uc5f4 \uc774\ub984\uacfc \uc218\uc2dd\uc744 \uc785\ub825\ud569\ub2c8\ub2e4. <\/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=\"\uc0ac\uc6a9\uc790 \uc815\uc758 \uc5f4 \ub300\ud654 \uc0c1\uc790\" width=\"553\" height=\"347\"><\/figure><\/div><ul><li> \ud655\uc778\uc744 \ud074\ub9ad\ud558\uba74 \ubaa8\ub4e0 \uc774\ub984\uc774 \ub300\ubb38\uc790\ub85c \ub41c \uc0c8 \uc5f4\uc774 \uc0dd\uc131\ub429\ub2c8\ub2e4.<\/li><li> \ub2e4\uc74c\uc740 \uc774\uc804 \uc5f4\uc744 \uc0ad\uc81c\ud558\uace0 \uc0c8 \uc5f4\uc758 \uc774\ub984\uc744 \ubc14\uafb8\ub294 \uac83\uc785\ub2c8\ub2e4. \ub530\ub77c\uc11c \uccab \ubc88\uc9f8 \uc5f4\uc744 \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd \ubc84\ud2bc\uc73c\ub85c \ud074\ub9ad\ud558\uace0 \uc0ad\uc81c\ub97c \uc120\ud0dd\ud558\uc2ed\uc2dc\uc624. <\/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=\"\ubaa8\ub4e0 \uc774\ub984\uc774 \ub300\ubb38\uc790\ub85c \ub41c \uc0c8 \uc5f4\" width=\"390\" height=\"133\"><\/figure><\/div><ul><li> \ub9c8\uc9c0\ub9c9\uc73c\ub85c \uc0c8 \uc5f4\uc758 \uc774\ub984\uc744 &#8220;\uc804\uccb4 \uc774\ub984&#8221;\uc73c\ub85c \ubc14\uafc9\ub2c8\ub2e4.<\/li><\/ul><p> \uc0c8 \uc5f4\uc744 \ucd94\uac00\ud558\ub294 \ub3d9\uc548 \ud30c\uc6cc \ucffc\ub9ac\uc5d0 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ud568\uc218\ub294 \ucd1d 700\uac1c\uc774\uba70, <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\uc5d0\uc11c \uc774\ub7ec\ud55c \ud568\uc218\uc5d0 \ub300\ud574 \uc81c\uacf5\ud558\ub294 \uc804\uccb4 \ubaa9\ub85d\uc740<\/a> \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. \ud655\uc778\ud574 \ubcf4\uc138\uc694.<\/p><h2 class=\"wp-block-heading\"> PQ\uc5d0\uc11c \ucffc\ub9ac\ub97c \uc218\uc815\ud558\ub294 \ubc29\ubc95<\/h2><p> \ud1b5\ud569 \ubb38\uc11c\uc5d0 \uc774\ubbf8 \uc788\ub294 \ucffc\ub9ac\ub97c \ubcc0\uacbd\ud558\ub824\uba74 \ud574\ub2f9 \ucffc\ub9ac\ub97c \ud3b8\uc9d1\ud55c \ub2e4\uc74c \ubcc0\uacbd\ud558\uba74 \ub429\ub2c8\ub2e4. \ub370\uc774\ud130 \ud0ed\uc5d0\ub294 <strong>\ucffc\ub9ac \ubc0f \uc5f0\uacb0\uc774\ub77c\ub294 \ubc84\ud2bc\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/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=\"\ubc84\ud2bc \uc774\ub984 \uc694\uccad \ubc0f \uc5f0\uacb0\" width=\"512\" height=\"162\"><\/figure><\/div><p> \uc774 \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uba74 \ud604\uc7ac \ud1b5\ud569 \ubb38\uc11c\uc5d0 \uc788\ub294 \ubaa8\ub4e0 \ucffc\ub9ac\ub97c \ub098\uc5f4\ud558\ub294 \ucc3d\uc774 \uc624\ub978\ucabd\uc5d0 \uc5f4\ub9bd\ub2c8\ub2e4. <\/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=\"\ubaa8\ub4e0 \ucffc\ub9ac \uc218\ud589 \ubaa9\ub85d\" width=\"324\" height=\"302\"><\/figure><\/div><p> \ucffc\ub9ac \uc774\ub984\uc744 \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd \ubc84\ud2bc\uc73c\ub85c \ud074\ub9ad\ud558\uace0 \ud3b8\uc9d1\uc744 \uc120\ud0dd\ud558\uba74 \uac15\ub825\ud55c \ucffc\ub9ac \ud3b8\uc9d1\uae30\uc5d0\uc11c \ud3b8\uc9d1\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/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=\"\ucffc\ub9ac \uc774\ub984\uc744 \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd \ubc84\ud2bc\uc73c\ub85c \ud074\ub9ad\ud558\uace0 \ud3b8\uc9d1\uc744 \uc120\ud0dd\ud558\uc138\uc694.\" width=\"368\" height=\"213\"><\/figure><\/div><p> \ucffc\ub9ac\ub97c \ud3b8\uc9d1\ud558\uba74 \uc774\uc804\uc5d0 \uc218\ud589\ud55c \ubaa8\ub4e0 \ub2e8\uacc4\uac00 &#8220;\uc801\uc6a9\ub41c \ub2e8\uacc4&#8221;\uc5d0 \ub098\uc5f4\ub418\uc5b4 \uc788\uc74c\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc73c\uba70, \uc774\ub97c \ud3b8\uc9d1\ud558\uac70\ub098 \uc0c8 \ub2e8\uacc4\ub97c \uc218\ud589\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. <\/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=\"\ud3b8\uc9d1\ud560 \uc218\ub3c4 \uc788\ub294 \uc801\uc6a9 \ub2e8\uacc4\" width=\"259\" height=\"180\"><\/figure><\/div><p> \ud3b8\uc9d1\uc774 \uc644\ub8cc\ub418\uba74 &#8220;\ub2eb\uae30 \ubc0f \ub85c\ub4dc&#8221; \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uae30\ub9cc \ud558\uba74 \ub429\ub2c8\ub2e4.<\/p><h2 class=\"wp-block-heading\"> \uc5f0\uacb0 \ub0b4\ubcf4\ub0b4\uae30 \ubc0f \uac00\uc838\uc624\uae30<\/h2><p> \ucffc\ub9ac\uc5d0 \uc0ac\uc6a9\ud55c \uc5f0\uacb0\uc774 \uc788\uace0 \uc774\uc81c \ud574\ub2f9 \uc5f0\uacb0\uc744 \ub2e4\ub978 \uc0ac\ub78c\uacfc \uacf5\uc720\ud558\ub824\ub294 \uacbd\uc6b0 \ud574\ub2f9 \uc5f0\uacb0\uc744 odc \ud30c\uc77c\ub85c \ub0b4\ubcf4\ub0bc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p><p> \ucffc\ub9ac \ud14c\uc774\ube14\uc5d0\ub294 <strong>&#8220;\uc5f0\uacb0 \ub0b4\ubcf4\ub0b4\uae30&#8221;\ub77c\ub294 \ubc84\ud2bc\uc774<\/strong> \uc788\uc73c\uba70 \uc774\ub97c \ud074\ub9ad\ud558\uba74 \ud574\ub2f9 \ucffc\ub9ac\uc758 \uc5f0\uacb0\uc744 \uc2dc\uc2a4\ud15c\uc5d0 \uc800\uc7a5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/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=\"\uc218\ucd9c \uc5f0\uacb0\" width=\"216\" height=\"143\"><\/figure><\/div><p> \ub2e4\ub978 \uc0ac\ub78c\uc774 \uacf5\uc720\ud558\ub294 \uc5f0\uacb0\uc744 \uac00\uc838\uc624\ub824\uba74 \ub370\uc774\ud130 \ud0ed\uc73c\ub85c \uc774\ub3d9\ud558\uc5ec \uac00\uc838\uc624\uae30 \ubc0f \ubcc0\ud658\uc5d0\uc11c <strong>\uae30\uc874 \uc5f0\uacb0\uc744 \ud074\ub9ad\ud558\uba74<\/strong> \ub429\ub2c8\ub2e4. <\/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=\"\uac00\uc838\uc624\uae30 \uc5f0\uacb0 \uac00\uc838\uc624\uae30 \ubcc0\ud658\" width=\"400\" height=\"133\"><\/figure><\/div><p> \uadf8\ub7f0 \ub2e4\uc74c \uacf5\uc720\ub41c \uc5f0\uacb0 \ud30c\uc77c\uc744 \ucc3e\uc544 \ud1b5\ud569 \ubb38\uc11c\ub85c \uac00\uc838\uc62c \uc218 \uc788\ub294 &#8220;\ub354 \ucc3e\uc544\ubcf4\uae30&#8221; \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uc138\uc694. <\/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=\"\uc790\uc138\ud788 \uc54c\uc544\ubcf4\ub824\uba74 \ucc3e\uc544\ubcf4\uae30 \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uc138\uc694.\" width=\"465\" height=\"238\"><\/figure><\/div><h2 class=\"wp-block-heading\"> PowerQuery \uc5b8\uc5b4(M \ucf54\ub4dc)<\/h2><p> \uc55e\uc11c \uc5b8\uae09\ud588\ub4ef\uc774 PowerQuery\uc5d0\uc11c \uc218\ud589\ud55c \uac01 \ub2e8\uacc4\uc5d0 \ub300\ud574 <strong>M Code<\/strong> \ub77c\ub294 \ucf54\ub4dc(\ubc31\uc5d4\ub4dc\uc5d0\uc11c)\uac00 \uc0dd\uc131\ub429\ub2c8\ub2e4. \ud648 \ud0ed\uc5d0\ub294 \ucf54\ub4dc\ub97c \ubcf4\ub294 \ub370 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 &#8221; <strong>\uace0\uae09 \ud3b8\uc9d1\uae30&#8221;<\/strong> \ub77c\ub294 \ubc84\ud2bc\uc774 \uc788\uc2b5\ub2c8\ub2e4. <\/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=\"\uace0\uae09 \ud3b8\uc9d1\uae30\" width=\"265\" height=\"176\"><\/figure><\/div><p> \uace0\uae09 \ud3b8\uc9d1\uae30\ub97c \ud074\ub9ad\ud558\uba74 \ucf54\ub4dc \ud3b8\uc9d1\uae30\uac00 \ud45c\uc2dc\ub418\uba70 \uc774 \ucf54\ub4dc\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. <\/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=\"\ucf54\ub4dc \ud3b8\uc9d1\uae30\" width=\"578\" height=\"390\"><\/figure><\/div><p> <strong>M\uc740 \ub300\uc18c\ubb38\uc790\ub97c \uad6c\ubd84\ud558\ub294 \uc5b8\uc5b4<\/strong> \uc774\uba70 \ub2e4\ub978 \ubaa8\ub4e0 \uc5b8\uc5b4\uc640 \ub9c8\ucc2c\uac00\uc9c0\ub85c \ubcc0\uc218\uc640 \ud45c\ud604\uc2dd\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \ucf54\ub4dc\uc758 \uae30\ubcf8 \uad6c\uc870\ub294 \ucf54\ub4dc\uac00 LET \ud45c\ud604\uc2dd\uc73c\ub85c \uc2dc\uc791\ud558\ub294 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. <\/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=\"\uae30\ubcf8 \ucf54\ub4dc \uad6c\uc870\" width=\"539\" height=\"364\"><\/figure><\/div><p> \uc774 \ucf54\ub4dc\uc5d0\ub294 \ub450 \uac1c\uc758 \ubcc0\uc218\uc640 \uadf8\uc5d0 \uc124\uc815\ub41c \uac12\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uacb0\uad6d \uac12\uc744 \uc5bb\uae30 \uc704\ud574 IN \ud45c\ud604\uc2dd\uc774 \uc0ac\uc6a9\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc774\uc81c \ud655\uc778\uc744 \ud074\ub9ad\ud558\uba74 \uacb0\uacfc\uc5d0 &#8220;Variablename&#8221; \ubcc0\uc218\uc5d0 \ud560\ub2f9\ub41c \uac12\uc774 \ubc18\ud658\ub429\ub2c8\ub2e4. <\/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=\"\ubcc0\uc218 \uc774\ub984\" 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)\">\ud30c\uc6cc \ucffc\ub9ac \uc5b8\uc5b4\uc5d0 \ub300\ud574 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\ub824\uba74 \uc774 \ub9ac\uc18c\uc2a4\ub97c \ud655\uc778\ud558\uc138\uc694.<\/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>\ub9c8\uc9c0\ub9c9\uc5d0<\/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\">\uc5d1\uc140 \ud30c\uc6cc\ucffc\ub9ac\ub780 \ubb34\uc5c7\uc778\uac00\uc694?<\/strong><p class=\"schema-faq-answer\"> \ud30c\uc6cc \ucffc\ub9ac\ub294 \uc5ec\ub7ec \uc6d0\ubcf8\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc640 \ud574\ub2f9 \ub370\uc774\ud130\ub97c \uc815\ub9ac \ubc0f \ubcc0\ud658\ud55c \ub2e4\uc74c \ubd84\uc11d\uc5d0 \ucd94\uac00\ub85c \uc0ac\uc6a9\ud558\ub294 \ub370 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ub370\uc774\ud130 \ubcc0\ud658 \uc5d4\uc9c4\uc785\ub2c8\ub2e4.<\/p><\/div><\/div><p> POWER QUERY\ub97c \ud53c\ud560 \uc5ec\uc720\uac00 \uc5c6\uc2b5\ub2c8\ub2e4. \uadf8\ub807\uac8c \uc0dd\uac01\ud558\uc2e0\ub2e4\uba74 Excel \ud568\uc218 \ub098 VBA \ucf54\ub4dc\ub85c \uc218\ud589\ud558\ub294 \ub9ce\uc740 \uc791\uc5c5\uc744 \uc774\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc790\ub3d9\ud654\ud560 \uc218 \uc788\uc73c\uba70, \uc774 \ud29c\ud1a0\ub9ac\uc5bc\uc774 \uc5ec\ub7ec\ubd84\uc774 \uc774\ub97c \ub354\uc6b1 \ub354 \uc0ac\uc6a9\ud558\ub3c4\ub85d \uc601\uac10\uc744 \uc904 \uac83\uc774\ub77c\uace0 \ud655\uc2e0\ud569\ub2c8\ub2e4.<\/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-183","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\uc758 \ud30c\uc6cc \ucffc\ub9ac \u2013 \uc790\uc2b5\uc11c + \uc608\uc81c(\uac00\uc838\uc624\uae30 \ubc0f \ubcc0\ud658)<\/title>\n<meta name=\"description\" content=\"\ud30c\uc6cc \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\uba74 \uc5ec\ub7ec \uc6d0\ubcf8\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc628 \ub2e4\uc74c \ubcc0\ud658\ud560 \uc218 \uc788\uc73c\uba70 \uc774 \uac00\uc774\ub4dc\ub294 \uc804\uccb4 \uc790\uc2b5\uc11c\uc785\ub2c8\ub2e4.\" \/>\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\/ko\/\uc804\uc6d0-\uc694\uccad\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel\uc758 \ud30c\uc6cc \ucffc\ub9ac \u2013 \uc790\uc2b5\uc11c + \uc608\uc81c(\uac00\uc838\uc624\uae30 \ubc0f \ubcc0\ud658)\" \/>\n<meta property=\"og:description\" content=\"\ud30c\uc6cc \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\uba74 \uc5ec\ub7ec \uc6d0\ubcf8\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc628 \ub2e4\uc74c \ubcc0\ud658\ud560 \uc218 \uc788\uc73c\uba70 \uc774 \uac00\uc774\ub4dc\ub294 \uc804\uccb4 \uc790\uc2b5\uc11c\uc785\ub2c8\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/ko\/\uc804\uc6d0-\uc694\uccad\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-11T06:59:39+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=\"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04\" \/>\n\t<meta name=\"twitter:data1\" content=\"1\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/%ec%a0%84%ec%9b%90-%ec%9a%94%ec%b2%ad\/\",\"url\":\"https:\/\/exceladvisor.org\/ko\/%ec%a0%84%ec%9b%90-%ec%9a%94%ec%b2%ad\/\",\"name\":\"Excel\uc758 \ud30c\uc6cc \ucffc\ub9ac \u2013 \uc790\uc2b5\uc11c + \uc608\uc81c(\uac00\uc838\uc624\uae30 \ubc0f \ubcc0\ud658)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/%ec%a0%84%ec%9b%90-%ec%9a%94%ec%b2%ad\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/%ec%a0%84%ec%9b%90-%ec%9a%94%ec%b2%ad\/#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-11T06:59:39+00:00\",\"description\":\"\ud30c\uc6cc \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\uba74 \uc5ec\ub7ec \uc6d0\ubcf8\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc628 \ub2e4\uc74c \ubcc0\ud658\ud560 \uc218 \uc788\uc73c\uba70 \uc774 \uac00\uc774\ub4dc\ub294 \uc804\uccb4 \uc790\uc2b5\uc11c\uc785\ub2c8\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/%ec%a0%84%ec%9b%90-%ec%9a%94%ec%b2%ad\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/ko\/%ec%a0%84%ec%9b%90-%ec%9a%94%ec%b2%ad\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/%ec%a0%84%ec%9b%90-%ec%9a%94%ec%b2%ad\/#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\/ko\/%ec%a0%84%ec%9b%90-%ec%9a%94%ec%b2%ad\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\uc9d1\",\"item\":\"https:\/\/exceladvisor.org\/ko\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel \uace0\uae09 \uc790\uc2b5\uc11c\u200c \ucffc\ub9ac(\uac00\uc838\uc624\uae30 \ubc0f \ubcc0\ud658)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/#website\",\"url\":\"https:\/\/exceladvisor.org\/ko\/\",\"name\":\"Excel Advisor\",\"description\":\"\ub370\uc774\ud130 \uc9c0\ubc30\ub825\uc744 \uc704\ud55c \uac00\uc774\ub4dc!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/ko\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/ko\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/ko\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/ko\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel\uc758 \ud30c\uc6cc \ucffc\ub9ac \u2013 \uc790\uc2b5\uc11c + \uc608\uc81c(\uac00\uc838\uc624\uae30 \ubc0f \ubcc0\ud658)","description":"\ud30c\uc6cc \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\uba74 \uc5ec\ub7ec \uc6d0\ubcf8\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc628 \ub2e4\uc74c \ubcc0\ud658\ud560 \uc218 \uc788\uc73c\uba70 \uc774 \uac00\uc774\ub4dc\ub294 \uc804\uccb4 \uc790\uc2b5\uc11c\uc785\ub2c8\ub2e4.","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\/ko\/\uc804\uc6d0-\uc694\uccad\/","og_locale":"ko_KR","og_type":"article","og_title":"Excel\uc758 \ud30c\uc6cc \ucffc\ub9ac \u2013 \uc790\uc2b5\uc11c + \uc608\uc81c(\uac00\uc838\uc624\uae30 \ubc0f \ubcc0\ud658)","og_description":"\ud30c\uc6cc \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\uba74 \uc5ec\ub7ec \uc6d0\ubcf8\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc628 \ub2e4\uc74c \ubcc0\ud658\ud560 \uc218 \uc788\uc73c\uba70 \uc774 \uac00\uc774\ub4dc\ub294 \uc804\uccb4 \uc790\uc2b5\uc11c\uc785\ub2c8\ub2e4.","og_url":"https:\/\/exceladvisor.org\/ko\/\uc804\uc6d0-\uc694\uccad\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-11T06:59:39+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":{"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04":"1\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/ko\/%ec%a0%84%ec%9b%90-%ec%9a%94%ec%b2%ad\/","url":"https:\/\/exceladvisor.org\/ko\/%ec%a0%84%ec%9b%90-%ec%9a%94%ec%b2%ad\/","name":"Excel\uc758 \ud30c\uc6cc \ucffc\ub9ac \u2013 \uc790\uc2b5\uc11c + \uc608\uc81c(\uac00\uc838\uc624\uae30 \ubc0f \ubcc0\ud658)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/ko\/%ec%a0%84%ec%9b%90-%ec%9a%94%ec%b2%ad\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/ko\/%ec%a0%84%ec%9b%90-%ec%9a%94%ec%b2%ad\/#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-11T06:59:39+00:00","description":"\ud30c\uc6cc \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\uba74 \uc5ec\ub7ec \uc6d0\ubcf8\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc628 \ub2e4\uc74c \ubcc0\ud658\ud560 \uc218 \uc788\uc73c\uba70 \uc774 \uac00\uc774\ub4dc\ub294 \uc804\uccb4 \uc790\uc2b5\uc11c\uc785\ub2c8\ub2e4.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/ko\/%ec%a0%84%ec%9b%90-%ec%9a%94%ec%b2%ad\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/ko\/%ec%a0%84%ec%9b%90-%ec%9a%94%ec%b2%ad\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/exceladvisor.org\/ko\/%ec%a0%84%ec%9b%90-%ec%9a%94%ec%b2%ad\/#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\/ko\/%ec%a0%84%ec%9b%90-%ec%9a%94%ec%b2%ad\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\uc9d1","item":"https:\/\/exceladvisor.org\/ko\/"},{"@type":"ListItem","position":2,"name":"Excel \uace0\uae09 \uc790\uc2b5\uc11c\u200c \ucffc\ub9ac(\uac00\uc838\uc624\uae30 \ubc0f \ubcc0\ud658)"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/ko\/#website","url":"https:\/\/exceladvisor.org\/ko\/","name":"Excel Advisor","description":"\ub370\uc774\ud130 \uc9c0\ubc30\ub825\uc744 \uc704\ud55c \uac00\uc774\ub4dc!","publisher":{"@id":"https:\/\/exceladvisor.org\/ko\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/ko\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/ko\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/ko\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/exceladvisor.org\/ko\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/ko\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/ko\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/ko\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/pages\/183","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/comments?post=183"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/pages\/183\/revisions"}],"predecessor-version":[{"id":773,"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/pages\/183\/revisions\/773"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/media?parent=183"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}