{"id":9522,"date":"2023-05-15T12:49:48","date_gmt":"2023-05-15T07:19:48","guid":{"rendered":"https:\/\/neonpolice.com\/?p=9522"},"modified":"2024-03-27T13:20:19","modified_gmt":"2024-03-27T07:50:19","slug":"advanced-excel-course","status":"publish","type":"post","link":"https:\/\/neonpolice.com\/kr\/advanced-excel-course\/","title":{"rendered":"\ubaa8\ub4e0 \uc0ac\ub78c\uc744 \uc704\ud55c \ucd5c\uace0\uc758 \uace0\uae09 Excel \ucf54\uc2a4"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">\uc624\ub298\ub0a0\uc758 \ub370\uc774\ud130 \uc911\uc2ec \uc138\uacc4\uc5d0\uc11c Microsoft Excel\uc5d0 \ub300\ud55c \ub2a5\uc219\ud568\uc740 \ub9e4\uc6b0 \uc911\uc694\ud569\ub2c8\ub2e4. \ub300\ubd80\ubd84\uc758 \uac1c\uc778\uc774 Excel\uc5d0 \ub300\ud55c \uae30\ubcf8\uc801\uc778 \uc774\ud574\ub294 \uc788\uc9c0\ub9cc, Excel \uae30\uc220\uc744 \ud55c \ub2e8\uacc4 \ub04c\uc5b4\uc62c\ub9ac\uba74 \uac00\ub2a5\uc131\uc758 \uc138\uacc4\uac00 \uc5f4\ub9b4 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc5ec\uae30\uc11c \uace0\uae09 Excel \uacfc\uc815\uc774 \ud544\uc694\ud569\ub2c8\ub2e4. \uace0\uae09 Excel \uacfc\uc815\uc740 \ub370\uc774\ud130 \ubd84\uc11d, \ubcf4\uace0 \ubc0f \uc758\uc0ac \uacb0\uc815\uc744 \uc704\ud574 Excel\uc758 \uc7a0\uc7ac\ub825\uc744 \ucd5c\ub300\ud55c \ud65c\uc6a9\ud558\ub294 \ub370 \ud544\uc694\ud55c \uc9c0\uc2dd\uacfc \uae30\uc220\uc744 \uac16\ucd94\ub3c4\ub85d \uc124\uacc4\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \ube44\uc988\ub2c8\uc2a4 \uc804\ubb38\uac00, \ubd84\uc11d\uac00, \ub370\uc774\ud130 \uc560\ud638\uac00 \ub610\ub294 \ud559\uc0dd\uc774\ub4e0 \uc774 \uacfc\uc815\uc740 \uacbd\uc7c1 \uc6b0\uc704\ub97c \uc81c\uacf5\ud558\uace0 \uc0dd\uc0b0\uc131\uc744 \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4. Neon Police\uac00 \ud050\ub808\uc774\ud305\ud55c \ub2e4\uc74c \uae30\uc0ac\ub97c \uc77d\uace0 \uace0\uae09 Excel \uacfc\uc815\uc5d0 \ub300\ud574 \uc54c\uc544\ubcf4\uc138\uc694. \ub610\ud55c Excel\uc5d0 \ub300\ud55c \ucd5c\uace0\uc758 \uc778\uc99d\uc5d0 \ub300\ud55c \ud1b5\ucc30\ub825\uc744 \uc5bb\uace0 \ub370\uc774\ud130 \ubd84\uc11d\uc744 \uc704\ud55c \ucd5c\uace0\uc758 Excel \uacfc\uc815\uc5d0 \ub300\ud55c \uc138\ubd80 \uc815\ubcf4\ub97c \uc5bb\uc73c\uc138\uc694.\u00a0<\/span><\/p>\n\t\t<div class=\"web-stories-list alignnone has-archive-link is-view-type-circles is-style-default is-carousel\" data-id=\"1\">\n\t\t\t<div\n\t\t\tclass=\"web-stories-list__inner-wrapper carousel-1\"\n\t\t\tstyle=\"--ws-circle-size:100px\"\n\t\t\t>\n\t\t\t\t\t\t\t\t\t<div\n\t\t\t\t\tclass=\"web-stories-list__carousel circles\"\n\t\t\t\t\tdata-id=\"carousel-1\"\n\t\t\t\t\tdata-prev=\"Previous\"\n\t\t\t\t\tdata-next=\"Next\"\n\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t<div\n\t\t\t\tclass=\"web-stories-list__story\"\n\t\t\t\tdata-wp-interactive=\"web-stories-block\"\n\t\t\t\tdata-wp-context='{\"instanceId\":1}'\t\t\t\tdata-wp-on--click=\"actions.open\"\n\t\t\t\tdata-wp-on-window--popstate=\"actions.onPopstate\"\n\t\t\t\t>\n\t\t\t\t\t\t\t<div class=\"web-stories-list__story-poster\">\n\t\t\t\t<a href=\"https:\/\/neonpolice.com\/kr\/web-stories\/your-ultimate-checklist-of-baby-essentials\/\" >\n\t\t\t\t\t<img\n\t\t\t\t\t\tsrc=\"https:\/\/neonpolice.com\/wp-content\/uploads\/2024\/01\/cropped-baby_essentials_checklist-hero-GettyImages-1413731369.webp\"\n\t\t\t\t\t\talt=\"Your Ultimate Checklist of Baby Essentials\"\n\t\t\t\t\t\twidth=\"185\"\n\t\t\t\t\t\theight=\"308\"\n\t\t\t\t\t\t\t\t\t\t\t\t\tsrcset=\"https:\/\/neonpolice.com\/wp-content\/uploads\/2024\/01\/cropped-baby_essentials_checklist-hero-GettyImages-1413731369.webp 640w, https:\/\/neonpolice.com\/wp-content\/uploads\/2024\/01\/cropped-baby_essentials_checklist-hero-GettyImages-1413731369-225x300.webp 225w, https:\/\/neonpolice.com\/wp-content\/uploads\/2024\/01\/cropped-baby_essentials_checklist-hero-GettyImages-1413731369-585x780.webp 585w, https:\/\/neonpolice.com\/wp-content\/uploads\/2024\/01\/cropped-baby_essentials_checklist-hero-GettyImages-1413731369-150x200.webp 150w\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tsizes=\"auto, (max-width: 640px) 100vw, 640px\"\n\t\t\t\t\t\t\t\t\t\t\t\tloading=\"lazy\"\n\t\t\t\t\t\tdecoding=\"async\"\n\t\t\t\t\t>\n\t\t\t\t<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<div\n\t\t\t\tclass=\"web-stories-list__story\"\n\t\t\t\tdata-wp-interactive=\"web-stories-block\"\n\t\t\t\tdata-wp-context='{\"instanceId\":1}'\t\t\t\tdata-wp-on--click=\"actions.open\"\n\t\t\t\tdata-wp-on-window--popstate=\"actions.onPopstate\"\n\t\t\t\t>\n\t\t\t\t\t\t\t<div class=\"web-stories-list__story-poster\">\n\t\t\t\t<a href=\"https:\/\/neonpolice.com\/kr\/web-stories\/youll-absolutely-love-these-moisturizers-for-dry-skin\/\" >\n\t\t\t\t\t<img\n\t\t\t\t\t\tsrc=\"https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/10\/cropped-3-23.webp\"\n\t\t\t\t\t\talt=\"YOU\u2019LL ABSOLUTELY LOVE THESE MOISTURIZERS FOR DRY SKIN\"\n\t\t\t\t\t\twidth=\"185\"\n\t\t\t\t\t\theight=\"308\"\n\t\t\t\t\t\t\t\t\t\t\t\t\tsrcset=\"https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/10\/cropped-3-23.webp 640w, https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/10\/cropped-3-23-225x300.webp 225w, https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/10\/cropped-3-23-585x780.webp 585w, https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/10\/cropped-3-23-150x200.webp 150w\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tsizes=\"auto, (max-width: 640px) 100vw, 640px\"\n\t\t\t\t\t\t\t\t\t\t\t\tloading=\"lazy\"\n\t\t\t\t\t\tdecoding=\"async\"\n\t\t\t\t\t>\n\t\t\t\t<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<div\n\t\t\t\tclass=\"web-stories-list__story\"\n\t\t\t\tdata-wp-interactive=\"web-stories-block\"\n\t\t\t\tdata-wp-context='{\"instanceId\":1}'\t\t\t\tdata-wp-on--click=\"actions.open\"\n\t\t\t\tdata-wp-on-window--popstate=\"actions.onPopstate\"\n\t\t\t\t>\n\t\t\t\t\t\t\t<div class=\"web-stories-list__story-poster\">\n\t\t\t\t<a href=\"https:\/\/neonpolice.com\/kr\/web-stories\/top-18-white-sneakers-for-women\/\" >\n\t\t\t\t\t<img\n\t\t\t\t\t\tsrc=\"https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/10\/cropped-10-2.webp\"\n\t\t\t\t\t\talt=\"WHITE SNEAKERS FOR WOMEN\"\n\t\t\t\t\t\twidth=\"185\"\n\t\t\t\t\t\theight=\"308\"\n\t\t\t\t\t\t\t\t\t\t\t\t\tsrcset=\"https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/10\/cropped-10-2.webp 640w, https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/10\/cropped-10-2-225x300.webp 225w, https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/10\/cropped-10-2-585x780.webp 585w, https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/10\/cropped-10-2-150x200.webp 150w\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tsizes=\"auto, (max-width: 640px) 100vw, 640px\"\n\t\t\t\t\t\t\t\t\t\t\t\tloading=\"lazy\"\n\t\t\t\t\t\tdecoding=\"async\"\n\t\t\t\t\t>\n\t\t\t\t<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<div\n\t\t\t\tclass=\"web-stories-list__story\"\n\t\t\t\tdata-wp-interactive=\"web-stories-block\"\n\t\t\t\tdata-wp-context='{\"instanceId\":1}'\t\t\t\tdata-wp-on--click=\"actions.open\"\n\t\t\t\tdata-wp-on-window--popstate=\"actions.onPopstate\"\n\t\t\t\t>\n\t\t\t\t\t\t\t<div class=\"web-stories-list__story-poster\">\n\t\t\t\t<a href=\"https:\/\/neonpolice.com\/kr\/web-stories\/what-clothing-brands-do-kids-like\/\" >\n\t\t\t\t\t<img\n\t\t\t\t\t\tsrc=\"https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/10\/cropped-Untitled-design-8.webp\"\n\t\t\t\t\t\talt=\"WHAT CLOTHING BRANDS DO KIDS LIKE?\"\n\t\t\t\t\t\twidth=\"185\"\n\t\t\t\t\t\theight=\"308\"\n\t\t\t\t\t\t\t\t\t\t\t\t\tsrcset=\"https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/10\/cropped-Untitled-design-8.webp 640w, https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/10\/cropped-Untitled-design-8-225x300.webp 225w, https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/10\/cropped-Untitled-design-8-585x780.webp 585w, https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/10\/cropped-Untitled-design-8-150x200.webp 150w\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tsizes=\"auto, (max-width: 640px) 100vw, 640px\"\n\t\t\t\t\t\t\t\t\t\t\t\tloading=\"lazy\"\n\t\t\t\t\t\tdecoding=\"async\"\n\t\t\t\t\t>\n\t\t\t\t<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<div\n\t\t\t\tclass=\"web-stories-list__story\"\n\t\t\t\tdata-wp-interactive=\"web-stories-block\"\n\t\t\t\tdata-wp-context='{\"instanceId\":1}'\t\t\t\tdata-wp-on--click=\"actions.open\"\n\t\t\t\tdata-wp-on-window--popstate=\"actions.onPopstate\"\n\t\t\t\t>\n\t\t\t\t\t\t\t<div class=\"web-stories-list__story-poster\">\n\t\t\t\t<a href=\"https:\/\/neonpolice.com\/kr\/web-stories\/ways-to-reuse-your-wedding-dresses\/\" >\n\t\t\t\t\t<img\n\t\t\t\t\t\tsrc=\"https:\/\/neonpolice.com\/wp-content\/uploads\/2023\/10\/cropped-wedding-dress-640x853.jpg\"\n\t\t\t\t\t\talt=\"Ways To Reuse Your Wedding Dresses\"\n\t\t\t\t\t\twidth=\"185\"\n\t\t\t\t\t\theight=\"308\"\n\t\t\t\t\t\t\t\t\t\t\t\t\tsrcset=\"https:\/\/neonpolice.com\/wp-content\/uploads\/2023\/10\/cropped-wedding-dress.jpg 640w, https:\/\/neonpolice.com\/wp-content\/uploads\/2023\/10\/cropped-wedding-dress-225x300.jpg 225w, https:\/\/neonpolice.com\/wp-content\/uploads\/2023\/10\/cropped-wedding-dress-9x12.jpg 9w, https:\/\/neonpolice.com\/wp-content\/uploads\/2023\/10\/cropped-wedding-dress-585x780.jpg 585w, https:\/\/neonpolice.com\/wp-content\/uploads\/2023\/10\/cropped-wedding-dress-150x200.jpg 150w\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tsizes=\"auto, (max-width: 640px) 100vw, 640px\"\n\t\t\t\t\t\t\t\t\t\t\t\tloading=\"lazy\"\n\t\t\t\t\t\tdecoding=\"async\"\n\t\t\t\t\t>\n\t\t\t\t<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<div tabindex=\"0\" aria-label=\"Previous\" class=\"glider-prev\"><\/div>\n\t\t\t\t\t<div tabindex=\"0\" aria-label=\"Next\" class=\"glider-next\"><\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_78 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\ubaa9\ucc28<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"\ubaa9\ucc28 \ud1a0\uae00\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">\ube44\ub140\uc7a5<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/neonpolice.com\/kr\/advanced-excel-course\/#The_list_of_the_key_learning_objectives\" >\uc8fc\uc694 \ud559\uc2b5 \ubaa9\ud45c \ubaa9\ub85d<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/neonpolice.com\/kr\/advanced-excel-course\/#1_Master_Advanced_Formulas_and_Functions\" >1. \uace0\uae09 \uacf5\uc2dd \ubc0f \ud568\uc218 \ub9c8\uc2a4\ud130<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/neonpolice.com\/kr\/advanced-excel-course\/#2_Utilize_Data_Analysis_Tools\" >2. \ub370\uc774\ud130 \ubd84\uc11d \ub3c4\uad6c \ud65c\uc6a9<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/neonpolice.com\/kr\/advanced-excel-course\/#3_Automate_Tasks_with_Macros\" >3. \ub9e4\ud06c\ub85c\ub85c \uc791\uc5c5 \uc790\ub3d9\ud654<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/neonpolice.com\/kr\/advanced-excel-course\/#4_Create_Advanced_Charts_and_Visualizations\" >4. \uace0\uae09 \ucc28\ud2b8 \ubc0f \uc2dc\uac01\ud654 \ub9cc\ub4e4\uae30<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/neonpolice.com\/kr\/advanced-excel-course\/#5_Work_with_What-If_Analysis\" >5. What-If \ubd84\uc11d\uc73c\ub85c \uc791\uc5c5<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/neonpolice.com\/kr\/advanced-excel-course\/#6_Generate_Professional_Reports\" >6. \uc804\ubb38\uac00 \ubcf4\uace0\uc11c \uc0dd\uc131<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/neonpolice.com\/kr\/advanced-excel-course\/#7_Course_Delivery\" >7. \uacfc\uc815 \uc804\ub2ec<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/neonpolice.com\/kr\/advanced-excel-course\/#Who_can_benefit_from_the_course\" >\uc774 \ucf54\uc2a4\uc758 \ud61c\ud0dd\uc744 \ub204\ub9b4 \uc218 \uc788\ub294 \uc0ac\ub78c\uc740 \ub204\uad6c\uc785\ub2c8\uae4c?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/neonpolice.com\/kr\/advanced-excel-course\/#Conclusion\" >\uacb0\ub860<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/neonpolice.com\/kr\/advanced-excel-course\/#FAQs\" >\uc790\uc8fc \ubb3b\ub294 \uc9c8\ubb38<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"The_list_of_the_key_learning_objectives\"><\/span><span style=\"font-weight: 400;\">\uc8fc\uc694 \ud559\uc2b5 \ubaa9\ud45c \ubaa9\ub85d<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">\uadf8\ub9cc\ud07c <\/span><a href=\"https:\/\/neonpolice.com\/kr\/acwb\/\" target=\"_blank\" rel=\"nofollow noopener sponsored\"><span style=\"font-weight: 400;\">\uace0\uae09 Excel \uacfc\uc815<\/span><\/a><span style=\"font-weight: 400;\"> Excel\uc758 \uace0\uae09 \uae30\ub2a5\uacfc \uae30\ub2a5\uc5d0 \ub300\ud574 \ub354 \uae4a\uc774 \ud30c\uace0\ub4e4\uc5b4 \uae30\ubcf8 \uc218\uc2dd\uacfc \ud568\uc218\ub97c \ub118\uc5b4 \uc8fc\uc81c\ub97c \ud0d0\uad6c\ud569\ub2c8\ub2e4. \ubcf5\uc7a1\ud55c \ub370\uc774\ud130 \uc138\ud2b8\ub97c \uc870\uc791\ud558\uace0 \ubd84\uc11d\ud558\uace0, \uc791\uc5c5\uc744 \uc790\ub3d9\ud654\ud558\uace0, \ud1b5\ucc30\ub825 \uc788\ub294 \uc2dc\uac01\ud654\ub97c \ub9cc\ub4e4\uace0, \uc804\ubb38\uc801\uc778 \ubcf4\uace0\uc11c\ub97c \uc0dd\uc131\ud560 \uc218 \uc788\ub294 \ub2e4\uc591\ud55c \uae30\uc220\uacfc \ub3c4\uad6c\ub97c \ub2e4\ub8f9\ub2c8\ub2e4. \uace0\uae09 Excel \uacfc\uc815\uc758 \uc8fc\uc694 \ubaa9\ud45c\ub294 \uace0\uae09 \ub370\uc774\ud130 \ubd84\uc11d \ubc0f \ubcf4\uace0\uc5d0 \ub2a5\uc219\ud574\uc9c0\ub294 \ub370 \ub3c4\uc6c0\uc744 \uc8fc\ub294 \uac83\uc785\ub2c8\ub2e4. \uacfc\uc815\uc744 \ub9c8\uce58\uba74 \ub2e4\uc74c\uc744 \uae30\ub300\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Advanced Excel \uacfc\uc815\uc758 \uc8fc\uc694 \ubaa9\ud45c\ub294 \uace0\uae09 \ub370\uc774\ud130 \ubd84\uc11d \ubc0f \ubcf4\uace0\uc5d0 \ub2a5\uc219\ud574\uc9c0\ub294 \ub370 \ub3c4\uc6c0\uc744 \uc8fc\ub294 \uac83\uc785\ub2c8\ub2e4. \uacfc\uc815\uc744 \ub9c8\uce58\uba74 \ub2e4\uc74c\uc744 \uae30\ub300\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"1_Master_Advanced_Formulas_and_Functions\"><\/span><span style=\"font-weight: 400;\">1. \uace0\uae09 \uacf5\uc2dd \ubc0f \ud568\uc218 \ub9c8\uc2a4\ud130<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">\ubcf5\uc7a1\ud55c \uacf5\uc2dd\uacfc \ud568\uc218\ub97c \ud65c\uc6a9\ud558\uc5ec \uace0\uae09 \uacc4\uc0b0\uc744 \uc218\ud589\ud558\uace0, \ub300\uaddc\ubaa8 \ub370\uc774\ud130 \uc138\ud2b8\ub97c \ucc98\ub9ac\ud558\uace0, \ubcf5\uc7a1\ud55c \ube44\uc988\ub2c8\uc2a4 \ubb38\uc81c\ub97c \ud574\uacb0\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf4\uc138\uc694. VLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS \ub4f1\uacfc \uac19\uc740 \ud568\uc218\ub97c \uc0b4\ud3b4\ubcf4\uc138\uc694.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Utilize_Data_Analysis_Tools\"><\/span><span style=\"font-weight: 400;\">2. \ub370\uc774\ud130 \ubd84\uc11d \ub3c4\uad6c \ud65c\uc6a9<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">\uac15\ub825\ud55c \uac83\uc744 \ubc1c\uacac\ud558\uc138\uc694 <\/span><a href=\"https:\/\/neonpolice.com\/kr\/acwb\/\" target=\"_blank\" rel=\"nofollow noopener sponsored\"><span style=\"font-weight: 400;\">\ub370\uc774\ud130 \ubd84\uc11d \ub3c4\uad6c<\/span><\/a><span style=\"font-weight: 400;\"> \ud53c\ubc97 \ud14c\uc774\ube14, \ud30c\uc6cc \ucffc\ub9ac, \ud30c\uc6cc \ud53c\ubc97\uacfc \uac19\uc740 \uae30\uc220\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uc228\uaca8\uc9c4 \ud328\ud134\uc744 \ubc1c\uacac\ud558\uace0, \ub370\uc774\ud130\ub97c \uc694\uc57d\ud558\uace0, \uace0\uae09 \ub370\uc774\ud130 \uc815\ub9ac\ub97c \uc218\ud589\ud558\uace0, \ub300\ud654\ud615 \ub300\uc2dc\ubcf4\ub4dc\ub97c \ub9cc\ub4ed\ub2c8\ub2e4.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_Automate_Tasks_with_Macros\"><\/span><span style=\"font-weight: 400;\">3. \ub9e4\ud06c\ub85c\ub85c \uc791\uc5c5 \uc790\ub3d9\ud654<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">\ub9e4\ud06c\ub85c\ub97c \uae30\ub85d\ud558\uace0 \uc2e4\ud589\ud558\uc5ec \ubc18\ubcf5\uc801\uc778 \uc791\uc5c5\uc744 \uc790\ub3d9\ud654\ud569\ub2c8\ub2e4. \uc6cc\ud06c\ud50c\ub85c\ub97c \uac04\uc18c\ud654\ud558\uace0, \uc0ac\uc6a9\uc790 \uc815\uc758 \uae30\ub2a5\uc744 \ub9cc\ub4e4\uace0, \uadc0\uc911\ud55c \ub370\uc774\ud130 \ucc98\ub9ac \ubc0f \ubcf4\uace0 \uc2dc\uac04\uc744 \uc808\uc57d\ud569\ub2c8\ub2e4.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_Create_Advanced_Charts_and_Visualizations\"><\/span><span style=\"font-weight: 400;\">4. \uace0\uae09 \ucc28\ud2b8 \ubc0f \uc2dc\uac01\ud654 \ub9cc\ub4e4\uae30<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">\uc2dc\uac01\uc801\uc73c\ub85c \ub9e4\ub825\uc801\uc778 \ucc28\ud2b8\uc640 \uadf8\ub798\ud504\ub97c \ub9cc\ub4dc\ub294 \ubc29\ubc95\uc744 \ubc30\uc6b0\uace0 \ub370\uc774\ud130 \ud1b5\ucc30\ub825\uc744 \ud6a8\uacfc\uc801\uc73c\ub85c \uc804\ub2ec\ud558\uc138\uc694. \ud0d0\uc0c9 <\/span><a href=\"https:\/\/neonpolice.com\/kr\/acwb\/\" target=\"_blank\" rel=\"nofollow noopener sponsored\"><span style=\"font-weight: 400;\">\uace0\uae09 \ucc28\ud2b8 \uc791\uc131 \uae30\uc220<\/span><\/a><span style=\"font-weight: 400;\">\ud3ed\ud3ec\uc218\ud615, \uc2a4\ud30c\ud06c\ub77c\uc778, \ub3d9\uc801 \ucc28\ud2b8 \ub4f1\uc744 \ud3ec\ud568\ud569\ub2c8\ub2e4.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"5_Work_with_What-If_Analysis\"><\/span><span style=\"font-weight: 400;\">5. What-If \ubd84\uc11d\uc73c\ub85c \uc791\uc5c5<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">\uc2dc\ub098\ub9ac\uc624\ub97c \ud0d0\uc0c9\ud558\uace0 what-if \ubd84\uc11d\uc744 \uc218\ud589\ud558\uc5ec \ube44\uc988\ub2c8\uc2a4 \uc2dc\ub098\ub9ac\uc624\ub97c \uc2dc\ubbac\ub808\uc774\uc158\ud558\uace0, \uc704\ud5d8\uc744 \ud3c9\uac00\ud558\uace0, \uc815\ubcf4\uc5d0 \uc785\uac01\ud55c \uacb0\uc815\uc744 \ub0b4\ub9bd\ub2c8\ub2e4. Data Tables, Goal Seek, Solver\uc640 \uac19\uc740 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uc5ec \ubcc0\uc218 \ubcc0\uacbd\uc758 \uc601\ud5a5\uc744 \ubd84\uc11d\ud569\ub2c8\ub2e4.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"6_Generate_Professional_Reports\"><\/span><span style=\"font-weight: 400;\">6. \uc804\ubb38\uac00 \ubcf4\uace0\uc11c \uc0dd\uc131<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">\uc804\ubb38\uc801\uc778 \ubcf4\uace0\uc11c\uc640 \ub300\uc2dc\ubcf4\ub4dc\ub97c \ud1b5\ud574 \ub370\uc774\ud130\ub97c \ud6a8\uacfc\uc801\uc73c\ub85c \ud45c\ud604\ud558\ub294 \uae30\uc220\uc744 \uac1c\ubc1c\ud558\uc138\uc694. \uc11c\uc2dd \uae30\uc220, \uc870\uac74\ubd80 \uc11c\uc2dd, \ub370\uc774\ud130 \uac80\uc99d \ubc0f \uc2dc\uac01\uc801\uc73c\ub85c \ub9e4\ub825\uc801\uc778 \ubcf4\uace0\uc11c\ub97c \ub9cc\ub4dc\ub294 \ubaa8\ubc94 \uc0ac\ub840\ub97c \uc54c\uc544\ubcf4\uc138\uc694.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"7_Course_Delivery\"><\/span><span style=\"font-weight: 400;\">7. \uacfc\uc815 \uc804\ub2ec<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"https:\/\/neonpolice.com\/kr\/acwb\/\" target=\"_blank\" rel=\"nofollow noopener sponsored\"><span style=\"font-weight: 400;\">\uacfc\uc815 \uc804\ub2ec<\/span><\/a><span style=\"font-weight: 400;\"> \uc81c\uacf5\ud558\ub294 \ud50c\ub7ab\ud3fc\uc774\ub098 \uae30\uad00\uc5d0 \ub530\ub77c \ub2e4\ub97c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud559\uc2b5\uc744 \uac15\ud654\ud558\uae30 \uc704\ud55c \ube44\ub514\uc624 \ud29c\ud1a0\ub9ac\uc5bc, \uc2e4\uc2b5, \ud034\uc988, \ud504\ub85c\uc81d\ud2b8\uac00 \uacb0\ud569\ub418\uc5b4 \ud3ec\ud568\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc77c\ubd80 \uacfc\uc815\uc5d0\uc11c\ub294 \ub2e4\uc6b4\ub85c\ub4dc \uac00\ub2a5\ud55c \ub9ac\uc18c\uc2a4, \uce58\ud2b8\uc2dc\ud2b8, \ucd94\uac00 \uc9c0\uce68\uc744 \uc704\ud55c \ucee4\ubba4\ub2c8\ud2f0 \ub610\ub294 \uac15\uc0ac \uc9c0\uc6d0\uc5d0 \ub300\ud55c \uc561\uc138\uc2a4\ub3c4 \uc81c\uacf5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Who_can_benefit_from_the_course\"><\/span><span style=\"font-weight: 400;\">\uc774 \ucf54\uc2a4\uc758 \ud61c\ud0dd\uc744 \ub204\ub9b4 \uc218 \uc788\ub294 \uc0ac\ub78c\uc740 \ub204\uad6c\uc785\ub2c8\uae4c?<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">\uace0\uae09 Excel \uacfc\uc815\uc740 \ub2e4\uc591\ud55c \uac1c\uc778\uc5d0\uac8c \uc801\ud569\ud569\ub2c8\ub2e4.<\/span><\/p>\n<ol>\n<li><span style=\"font-weight: 400;\">\u00a0\ube44\uc988\ub2c8\uc2a4 \uc804\ubb38\uac00: \ubd84\uc11d \uc5ed\ub7c9\uc744 \uac15\ud654\ud558\uace0, \ub370\uc774\ud130 \uad00\ub828 \uc5c5\ubb34\ub97c \uac04\uc18c\ud654\ud558\uace0, \uc758\uc0ac \uacb0\uc815\uc744 \uc9c0\uc6d0\ud558\ub294 \uc758\ubbf8 \uc788\ub294 \ud1b5\ucc30\ub825\uc744 \ucc3d\ucd9c\ud558\uc138\uc694.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">\u00a0\ubd84\uc11d\uac00: \uc778\uc218 <\/span><a href=\"https:\/\/neonpolice.com\/kr\/acwb\/\" target=\"_blank\" rel=\"nofollow noopener sponsored\"><span style=\"font-weight: 400;\">\uace0\uae09 \ub370\uc774\ud130 \ubd84\uc11d<\/span><\/a><span style=\"font-weight: 400;\"> \ubcf5\uc7a1\ud55c \ub370\uc774\ud130 \uc138\ud2b8\uc5d0\uc11c \uc2e4\ud589 \uac00\ub2a5\ud55c \ud1b5\ucc30\ub825\uc744 \ucd94\ucd9c\ud558\uace0, \uc608\uce21\uc744 \uc218\ud589\ud558\uace0, \uc2ec\uce35\uc801\uc778 \ub370\uc774\ud130 \ud0d0\uc0c9\uc744 \uc218\ud589\ud558\ub294 \uae30\uc220.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">\ub370\uc774\ud130 \ub9e4\ub2c8\uc544 \uc5ec\ub7ec\ubd84: Excel\uc758 \uace0\uae09 \uae30\ub2a5\uc5d0 \ub300\ud55c \uc774\ud574\ub97c \ub192\uc774\uace0 \ub370\uc774\ud130 \uc870\uc791, \ubd84\uc11d, \uc2dc\uac01\ud654\uc5d0 \ub300\ud55c \ubaa8\ub4e0 \uc7a0\uc7ac\ub825\uc744 \ud65c\uc6a9\ud558\uc138\uc694.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">\ud559\uc0dd: \uc778\ud134\uc2ed, \ud504\ub85c\uc81d\ud2b8 \ubc0f \ubbf8\ub798 \uacbd\ub825\uc5d0\uc11c \ub192\uc740 \uac00\uce58\ub97c \uc9c0\ub2cc \uace0\uae09 Excel \uae30\uc220\uc744 \uac1c\ubc1c\ud558\uc5ec \uacbd\uc7c1 \uc6b0\uc704\ub97c \ud655\ubcf4\ud558\uc138\uc694.<\/span><\/li>\n<\/ol>\n<hr \/>\n<h2><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span><span style=\"font-weight: 400;\">\uacb0\ub860<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">\uc2dc\uac04\uacfc \ub178\ub825\uc744 \ud22c\uc790\ud558\ub2e4 <\/span><a href=\"https:\/\/neonpolice.com\/kr\/acwb\/\" target=\"_blank\" rel=\"nofollow noopener sponsored\"><span style=\"font-weight: 400;\">\uace0\uae09 Excel \uacfc\uc815<\/span><\/a><span style=\"font-weight: 400;\"> Excel \uae30\uc220\uc744 \ud06c\uac8c \ud5a5\uc0c1\uc2dc\ud0a4\uace0 \ub370\uc774\ud130\ub97c \ubcf4\ub2e4 \ud6a8\uc728\uc801\uc774\uace0 \ud6a8\uacfc\uc801\uc73c\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub3c4\ub85d \uc9c0\uc6d0\ud569\ub2c8\ub2e4. \uace0\uae09 \ub370\uc774\ud130 \ubd84\uc11d \ubc0f \ubcf4\uace0 \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud558\uba74 \uadc0\uc911\ud55c \ud1b5\ucc30\ub825\uc744 \ubc1c\uacac\ud558\uace0 \ub370\uc774\ud130 \uc911\uc2ec\uc758 \uc758\uc0ac \uacb0\uc815\uc744 \ub0b4\ub9ac\uace0 \uc815\ubcf4\ub97c \uba85\ud655\ud558\uace0 \uac04\uacb0\ud558\uac8c \uc81c\uc2dc\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc804\ubb38 \uacbd\ub825\uc5d0\uc11c \ud0c1\uc6d4\ud55c \uc131\uacfc\ub97c \uac70\ub450\uac70\ub098 \ubd84\uc11d \uae30\uc220\uc744 \uc5c5\uadf8\ub808\uc774\ub4dc\ud558\uac70\ub098 \ub2e8\uc21c\ud788 Excel\uc758 \uace0\uae09 \uae30\ub2a5\uc5d0 \ub300\ud55c \ub354 \uae4a\uc740 \uc774\ud574\ub97c \uc5bb\ub294 \uac83\uc774 \ubaa9\ud45c\uc774\ub4e0, <a href=\"https:\/\/en.wikipedia.org\/wiki\/Microsoft_Excel\" target=\"_blank\" rel=\"noopener\">\uace0\uae09 Excel \uacfc\uc815<\/a> \uadc0\uc911\ud55c \ud22c\uc790\uc785\ub2c8\ub2e4. \ubcf5\uc7a1\ud55c \ub370\uc774\ud130 \uc138\ud2b8\ub97c \ucc98\ub9ac\ud558\uace0, \uc791\uc5c5\uc744 \uc790\ub3d9\ud654\ud558\uace0, \uc2dc\uac01\uc801\uc73c\ub85c \ub9e4\ub825\uc801\uc778 \ubcf4\uace0\uc11c\ub97c \ub9cc\ub4dc\ub294 \ub370 \ud544\uc694\ud55c \ub3c4\uad6c\uc640 \uae30\uc220\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \uace0\uae09 Excel \uae30\uc220\uc744 \uc2b5\ub4dd\ud558\uba74 \ub2e4\uc591\ud55c \uc804\ubb38 \uc5ed\ud560\uc5d0\uc11c \uc0dd\uc0b0\uc131\uacfc \ud6a8\uc728\uc131\uc744 \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubcf5\uc7a1\ud55c \ub370\uc774\ud130 \ubd84\uc11d \ud504\ub85c\uc81d\ud2b8\ub97c \uc27d\uac8c \ucc98\ub9ac\ud558\uc5ec \ub370\uc774\ud130 \uc870\uc791 \ubc0f \ubcf4\uace0\uc5d0 \ub4dc\ub294 \uc2dc\uac04\uacfc \ub178\ub825\uc744 \uc808\uc57d\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc5c5\uacc4 \uc804\ubc18\uc758 \uace0\uc6a9\uc8fc\ub294 \ub370\uc774\ud130 \uc911\uc2ec \uc758\uc0ac \uacb0\uc815\uc744 \uc704\ud574 Excel\uc758 \ud798\uc744 \ud65c\uc6a9\ud560 \uc218 \uc788\ub294 \uc804\ubb38\uac00\ub97c \uc18c\uc911\ud788 \uc5ec\uae30\uba70, \uc624\ub298\ub0a0\uc758 \uacbd\uc7c1\uc801\uc778 \uc77c\uc790\ub9ac \uc2dc\uc7a5\uc5d0\uc11c \uadc0\uc911\ud55c \uc790\uc0b0\uc774 \ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\ub610\ud55c, <\/span><a href=\"https:\/\/neonpolice.com\/kr\/acwb\/\" target=\"_blank\" rel=\"nofollow noopener sponsored\"><span style=\"font-weight: 400;\">\uace0\uae09 Excel \uacfc\uc815<\/span><\/a><span style=\"font-weight: 400;\"> \uacbd\ub825 \ubc1c\uc804\uc758 \uae30\ud68c\ub97c \uc5f4\uc5b4\uc90d\ub2c8\ub2e4. \uc870\uc9c1\uc774 \uc6b4\uc601\uc744 \uc704\ud574 \uc810\uc810 \ub354 \ub370\uc774\ud130\uc5d0 \uc758\uc874\ud568\uc5d0 \ub530\ub77c \uace0\uae09 Excel \uae30\uc220\uc744 \uac00\uc9c4 \uac1c\uc778\uc5d0 \ub300\ud55c \uc218\uc694\uac00 \ub192\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130 \ubd84\uc11d\uac00, \uc7ac\ubb34 \ubd84\uc11d\uac00, \ub9c8\ucf00\ud305 \ubd84\uc11d\uac00 \ub610\ub294 \ub370\uc774\ud130 \uc791\uc5c5\uc774 \ud3ec\ud568\ub41c \ub2e4\ub978 \uc5ed\ud560\uc774 \ub418\uace0\uc790 \ud558\ub4e0 Excel\uc744 \ub9c8\uc2a4\ud130\ud558\uba74 \uacbd\uc7c1 \uc6b0\uc704\ub97c \ud655\ubcf4\ud558\uace0 \ub3d9\ub8cc\ub4e4 \uc0ac\uc774\uc5d0\uc11c \ub450\uac01\uc744 \ub098\ud0c0\ub0b4\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4. \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 Datacamp\uc640 \uacf5\uc2dd \uc6f9\uc0ac\uc774\ud2b8\ub97c \ubc29\ubb38\ud558\uc138\uc694. <a href=\"https:\/\/neonpolice.com\/kr\/\" target=\"_blank\" rel=\"noopener\">\ub124\uc628 \uacbd\ucc30<\/a>.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"FAQs\"><\/span><span style=\"font-weight: 400;\">\uc790\uc8fc \ubb3b\ub294 \uc9c8\ubb38<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div class=\"su-accordion su-u-trim\"><div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus su-spoiler-closed\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>\uace0\uae09 Excel\uc5d0\uc11c\ub294 \uc5b4\ub5a4 \uc9c8\ubb38\uc744 \ud560 \uc218 \uc788\ub098\uc694?<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">a) VLOOKUP, INDEX-MATCH, SUMIFS\uc640 \uac19\uc740 \uace0\uae09 \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \ubcf5\uc7a1\ud55c \ub370\uc774\ud130 \uacc4\uc0b0\uc744 \uc218\ud589\ud558\ub824\uba74 \uc5b4\ub5bb\uac8c \ud574\uc57c \ud558\ub098\uc694?<\/p>\n<ol>\n<li>\u00a0\ub370\uc774\ud130 \ubd84\uc11d\uacfc \uc694\uc57d\uc744 \uc704\ud574 \ud53c\ubc97 \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uace0 \uc0ac\uc6a9\ud558\ub294 \uacfc\uc815\uc744 \uc124\uba85\ud574 \uc8fc\uc2dc\uaca0\uc2b5\ub2c8\uae4c?<\/li>\n<li>\u00a0\ub9e4\ud06c\ub85c\ub97c \uc0ac\uc6a9\ud558\uc5ec Excel\uc5d0\uc11c \ubc18\ubcf5\uc801\uc778 \uc791\uc5c5\uc744 \uc790\ub3d9\ud654\ud558\ub294 \ubc29\ubc95\uc740 \ubb34\uc5c7\uc785\ub2c8\uae4c? \uc608\ub97c \ub4e4\uc5b4\uc904 \uc218 \uc788\uc2b5\ub2c8\uae4c?<\/li>\n<li>\u00a0Excel\uc5d0\uc11c \ub300\uc6a9\ub7c9 \ub370\uc774\ud130 \uc138\ud2b8\ub97c \ucc98\ub9ac\ud558\uace0 \ubd84\uc11d\ud558\ub294 \ub370 \uc5b4\ub5a4 \uae30\uc220\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub098\uc694?<\/li>\n<li>\ub370\uc774\ud130\uac00 \ubcc0\uacbd\ub428\uc5d0 \ub530\ub77c \uc790\ub3d9\uc73c\ub85c \uc5c5\ub370\uc774\ud2b8\ub418\ub294 \ub3d9\uc801 \ucc28\ud2b8\uc640 \uc2dc\uac01\ud654\ub97c \uc5b4\ub5bb\uac8c \ub9cc\ub4dc\ub098\uc694?<\/li>\n<li>Excel\uc5d0\uc11c \ub370\uc774\ud130 \uac80\uc99d\uc744 \ud558\ub294 \ubaa9\uc801\uc740 \ubb34\uc5c7\uc774\uba70, \uc774\ub97c \ud6a8\uacfc\uc801\uc73c\ub85c \uad6c\ud604\ud558\ub824\uba74 \uc5b4\ub5bb\uac8c \ud574\uc57c \ud569\ub2c8\uae4c?<\/li>\n<li>\uc870\uac74\ubd80 \uc11c\uc2dd\uc758 \uac1c\ub150\uc744 \uc124\uba85\ud558\uace0 Excel\uc5d0\uc11c \uc5b4\ub5bb\uac8c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294\uc9c0 \uc608\ub97c \ub4e4\uc5b4\uc904 \uc218 \uc788\ub098\uc694?<\/li>\n<li>\u00a0\ub370\uc774\ud130 \ud14c\uc774\ube14, \ubaa9\ud45c \ud0d0\uc0c9, \uc194\ubc84\uc640 \uac19\uc740 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc2dc\ub098\ub9ac\uc624 \ub610\ub294 \uac00\uc815 \ubd84\uc11d\uc744 \uc5b4\ub5bb\uac8c \uc218\ud589\ud558\uc2dc\ub098\uc694?<\/li>\n<li>\u00a0Excel\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uc815\ub9ac\ud558\uace0, \ubcc0\ud658\ud558\uace0, \uc870\uc791\ud558\ub294 \uace0\uae09 \uae30\uc220\uc5d0\ub294 \uc5b4\ub5a4 \uac83\uc774 \uc788\uc2b5\ub2c8\uae4c?<\/li>\n<li>\u00a0Excel\uc5d0\uc11c \uc804\ubb38\uc801\uc778 \ubcf4\uace0\uc11c\uc640 \ub300\uc2dc\ubcf4\ub4dc\ub97c \ub9cc\ub4dc\ub294 \ubc29\ubc95\uc744 \ubcf4\uc5ec \uc8fc\uc2e4 \uc218 \uc788\ub098\uc694?<\/li>\n<\/ol>\n<\/div><\/div> <div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus su-spoiler-closed\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Excel\uc5d0\uc11c \uace0\uae09 \uc218\uc900\uc744 \uc5bb\uc73c\ub824\uba74 \ubb34\uc5c7\uc744 \uc54c\uc544\uc57c \ud569\ub2c8\uae4c?<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p>Excel\uc5d0\uc11c \uace0\uae09 \uc218\uc900\uc744 \ub2ec\uc131\ud558\ub824\uba74 \ub2e4\uc74c\uc744 \ud3ec\ud568\ud558\uc5ec \uae30\ubcf8\uc801\uc778 Excel \uae30\uc220\uc5d0 \ub300\ud55c \uac15\ub825\ud55c \uae30\ubc18\uc774 \ud544\uc694\ud569\ub2c8\ub2e4.<\/p>\n<ol>\n<li>a) \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\ub97c \ub9cc\ub4e4\uace0 \uc11c\uc2dd\uc744 \uc9c0\uc815\ud558\ub294 \ub370 \ub2a5\uc219\ud569\ub2c8\ub2e4.<\/li>\n<li>b) SUM, AVERAGE, COUNT \ub4f1\uacfc \uac19\uc740 \ud544\uc218 \ud568\uc218\uc640 \uacf5\uc2dd \uc774\ud574<\/li>\n<li>c) \ubc94\uc704, \uc140, \uc6cc\ud06c\uc2dc\ud2b8\ub97c \ud6a8\uc728\uc801\uc73c\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ub2a5\ub825.<\/li>\n<li>d) \uc815\ub82c, \ud544\ud130\ub9c1, \uc870\uac74\ubd80 \uc11c\uc2dd\uacfc \uac19\uc740 \uae30\ubcf8 \ub370\uc774\ud130 \ubd84\uc11d \uae30\uc220\uc5d0 \ub300\ud55c \uc9c0\uc2dd.e) Excel\uc758 \uae30\ubcf8 \ucc28\ud2b8 \ubc0f \uadf8\ub798\ud504 \uae30\ub2a5\uc5d0 \ub300\ud55c \uc9c0\uc2dd.<\/li>\n<\/ol>\n<p>\uc774\ub7ec\ud55c \uae30\ubcf8 \uae30\uc220 \uc678\uc5d0\ub3c4 \uace0\uae09 Excel \uc0ac\uc6a9\uc790\ub294 \ub2e4\uc74c \ubd84\uc57c\uc5d0 \ub300\ud55c \uc9c0\uc2dd\uc744 \ubcf4\uc720\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n<ul>\n<li>\uace0\uae09 \ud568\uc218\uc640 \uc218\uc2dd\uc5d0\ub294 VLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS \ubc0f \uc911\ucca9 \ud568\uc218\uac00 \ud3ec\ud568\ub429\ub2c8\ub2e4.<\/li>\n<li>\ud53c\ubc97 \ud14c\uc774\ube14\uacfc \uadf8\ub8f9\ud654, \uacc4\uc0b0 \ud544\ub4dc, \uc2ac\ub77c\uc774\uc11c\ub97c \ud3ec\ud568\ud55c \uace0\uae09 \uae30\ub2a5.<\/li>\n<li>\ub370\uc774\ud130 \uc815\ub9ac \ubc0f \ubcc0\ud658\uc744 \uc704\ud55c Power Query\uc640 \uac19\uc740 \ub370\uc774\ud130 \ubd84\uc11d \ub3c4\uad6c.<\/li>\n<li>\ubc18\ubcf5\ub418\ub294 \uc791\uc5c5\uc744 \uc790\ub3d9\ud654\ud558\uace0 \uc0ac\uc6a9\uc790 \uc815\uc758 \uae30\ub2a5\uc744 \ub9cc\ub4e4\uae30 \uc704\ud574 \ub9e4\ud06c\ub85c\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/li>\n<li>\ub3d9\uc801 \ucc28\ud2b8, \ucd94\uc138\uc120, \uace0\uae09 \uc11c\uc2dd \uc635\uc158\uc744 \ud3ec\ud568\ud55c \uace0\uae09 \ucc28\ud2b8 \uc791\uc131 \uae30\uc220.<\/li>\n<li>\uc2dc\ub098\ub9ac\uc624 \ubd84\uc11d\uc744 \uc704\ud55c \ub370\uc774\ud130 \ud14c\uc774\ube14, \ubaa9\ud45c \ud0d0\uc0c9, \uc194\ubc84\uc640 \uac19\uc740 \uac00\uc815\uc801 \ubd84\uc11d \ub3c4\uad6c.<\/li>\n<li>\ub370\uc774\ud130\uc758 \uc815\ud655\uc131\uacfc \uc77c\uad00\uc131\uc744 \ubcf4\uc7a5\ud558\uae30 \uc704\ud55c \ub370\uc774\ud130 \uac80\uc99d \uae30\uc220.<\/li>\n<li>h) \ud14d\uc2a4\ud2b8-\uc5f4, \uc5f0\uacb0, \ud50c\ub798\uc2dc \ucc44\uc6b0\uae30\uc640 \uac19\uc740 \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud55c \uace0\uae09 \ub370\uc774\ud130 \uc870\uc791 \uae30\uc220.<\/li>\n<li>\ub370\uc774\ud130 \ud1b5\ud569 \ubc0f \uc678\ubd80 \ub370\uc774\ud130 \uc18c\uc2a4 \uc5f0\uacb0.<\/li>\n<li>\uace0\uae09 \uc11c\uc2dd \uc635\uc158\uacfc \uc2dc\uac01\uc801 \uc694\uc18c\ub97c \ud65c\uc6a9\ud574 \uc804\ubb38\uc801\uc778 \ubcf4\uace0\uc11c\uc640 \ub300\uc2dc\ubcf4\ub4dc\ub97c \ub9cc\ub4ed\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/div><\/div> <div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus su-spoiler-closed\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>\uace0\uae09 Excel\uc744 \ubc30\uc6b0\ub294 \ubaa9\uc801\uc740 \ubb34\uc5c7\uc785\ub2c8\uae4c?<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p>\uace0\uae09 Excel\uc744 \ubc30\uc6b0\ub294 \ub370\ub294 \uc5ec\ub7ec \uac00\uc9c0 \ubaa9\uc801\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<ol>\n<li>\ud5a5\uc0c1\ub41c \ub370\uc774\ud130 \ubd84\uc11d: \uace0\uae09 Excel \uae30\uc220\uc744 \uc0ac\uc6a9\ud558\uba74 \ubcf5\uc7a1\ud55c \ub370\uc774\ud130 \uc138\ud2b8\ub97c \ubcf4\ub2e4 \ud6a8\uc728\uc801\uc73c\ub85c \ubd84\uc11d\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uace0\uae09 \uacc4\uc0b0\uc744 \uc218\ud589\ud558\uace0, \uc815\uad50\ud55c \ub370\uc774\ud130 \ubd84\uc11d \uae30\ub2a5\uc744 \uc801\uc6a9\ud558\uace0, \ub370\uc774\ud130\uc5d0\uc11c \uc758\ubbf8 \uc788\ub294 \ud1b5\ucc30\ub825\uc744 \ubc1c\uacac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li>\u00a0\uc790\ub3d9\ud654 \ubc0f \ud6a8\uc728\uc131: \uace0\uae09 Excel \uae30\ub2a5\uc744 \uc775\ud788\uba74 \ubc18\ubcf5\uc801\uc778 \uc791\uc5c5\uc744 \uc790\ub3d9\ud654\ud558\uace0, \uc6cc\ud06c\ud50c\ub85c\ub97c \uac04\uc18c\ud654\ud558\uba70, \ub370\uc774\ud130 \ucc98\ub9ac, \ubcf4\uace0, \ubd84\uc11d\uc5d0 \uc18c\uc694\ub418\ub294 \uc2dc\uac04\uacfc \ub178\ub825\uc744 \ud06c\uac8c \uc808\uc57d\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li>\uac1c\uc120\ub41c \ubcf4\uace0 \ubc0f \uc2dc\uac01\ud654: \uace0\uae09 Excel \uae30\uc220\uc744 \uc0ac\uc6a9\ud558\uba74 \uc2dc\uac01\uc801\uc73c\ub85c \ub9e4\ub825\uc801\uc778 \ubcf4\uace0\uc11c, \ub300\ud654\ud615 \ub300\uc2dc\ubcf4\ub4dc, \ub3d9\uc801 \ucc28\ud2b8\ub97c \ub9cc\ub4e4\uc5b4 \uc774\ud574\uad00\uacc4\uc790\uc5d0\uac8c \ub370\uc774\ud130 \ud1b5\ucc30\ub825\uc744 \ud6a8\uacfc\uc801\uc73c\ub85c \uc804\ub2ec\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li>\u00a0\uacbd\ub825 \ubc1c\uc804: \uace0\uae09 Excel \ub2a5\ub825\uc740 \ub2e4\uc591\ud55c \uc0b0\uc5c5\uacfc \uc9c1\ubb34\uc5d0\uc11c \ub9e4\uc6b0 \ub192\uc774 \ud3c9\uac00\ub429\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \uc0c8\ub85c\uc6b4 \uacbd\ub825 \uae30\ud68c\ub85c\uc758 \ubb38\uc744 \uc5f4\uac70\ub098 \uc870\uc9c1 \ub0b4\uc5d0\uc11c \ub354 \ub3c4\uc804\uc801\uc774\uace0 \ubd84\uc11d\uc801\uc778 \uc5ed\ud560\uc744 \ub9e1\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ol>\n<\/div><\/div><\/div>\n<p>&nbsp;<\/p>","protected":false},"excerpt":{"rendered":"<p>\uc624\ub298\ub0a0\uc758 \ub370\uc774\ud130 \uc911\uc2ec \uc138\uacc4\uc5d0\uc11c Microsoft Excel\uc5d0 \ub300\ud55c \ub2a5\uc219\ud568\uc740 \ub9e4\uc6b0 \uc694\uad6c\ub429\ub2c8\ub2e4. \ub300\ubd80\ubd84\uc758 \uac1c\uc778\uc774 Excel\uc5d0 \ub300\ud55c \uae30\ubcf8\uc801\uc778 \uc774\ud574\ub825\uc744 \uac00\uc9c0\uace0 \uc788\uc9c0\ub9cc, Excel \uae30\uc220\uc744 \ud55c \ub2e8\uacc4 \ub354 \ub192\uc774\uba74\u2026<\/p>","protected":false},"author":2,"featured_media":9524,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[139,1016],"tags":[],"class_list":["post-9522","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-career","category-datacamp"],"_links":{"self":[{"href":"https:\/\/neonpolice.com\/kr\/wp-json\/wp\/v2\/posts\/9522","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/neonpolice.com\/kr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/neonpolice.com\/kr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/neonpolice.com\/kr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/neonpolice.com\/kr\/wp-json\/wp\/v2\/comments?post=9522"}],"version-history":[{"count":0,"href":"https:\/\/neonpolice.com\/kr\/wp-json\/wp\/v2\/posts\/9522\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/neonpolice.com\/kr\/wp-json\/wp\/v2\/media\/9524"}],"wp:attachment":[{"href":"https:\/\/neonpolice.com\/kr\/wp-json\/wp\/v2\/media?parent=9522"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/neonpolice.com\/kr\/wp-json\/wp\/v2\/categories?post=9522"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/neonpolice.com\/kr\/wp-json\/wp\/v2\/tags?post=9522"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}