{"id":2657,"date":"2021-01-18T18:48:51","date_gmt":"2021-01-18T17:48:51","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=2657"},"modified":"2024-02-06T18:27:58","modified_gmt":"2024-02-06T17:27:58","slug":"install-power-query-with-excel-2013","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/install-power-query-with-excel-2013\/","title":{"rendered":"Install Power Query With Excel 2013"},"content":{"rendered":"<p><a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/50-things-you-can-do-with-excel-power-query\/\" target=\"_blank\" rel=\"noopener\" title=\"Power Query\" data-wpil-keyword-link=\"linked\">Power Query<\/a> is a new add-in\u00a0that was introduced in\u00a0Excel 2013 by Microsoft and was that popular that they made it backward compatible with Excel 2010.<\/p>\n<p><span style=\"text-decoration: underline; color: #0000ff;\"><a style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/installing-power-query-excel-2010\/\" target=\"_blank\" rel=\"noopener noreferrer\">Read the tutorial on how to install Power Query in Excel 2010 here<\/a><\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/install-power-query-with-excel-2013\/#So_what_is_Power_Query\" title=\"So what is Power Query?\">So what is Power Query?<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/install-power-query-with-excel-2013\/#So_how_do_I_get_your_hands_on_this_super_awesome_add-in%E2%80%A6I_hear_you_say\" title=\"So how do I\u00a0get your hands on this super awesome add-in&#8230;I hear you say?\">So how do I\u00a0get your hands on this super awesome add-in&#8230;I hear you say?<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"So_what_is_Power_Query\"><\/span><strong>So what is Power Query?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Well you know when you get data from a file, a data dump\/import or an external data source and it comes into Excel in an ugly, unworkable format? \u00a0I can hear you say YEEEES!<\/p>\n<p>Well Power Query Excel 2013 accesses, cleans and transforms all that messy data and displays it in a way that Excel loves and can work with. \u00a0The best thing is that the next time you receive the same ugly file, all you need to do is press the Refresh button and your data will automatically be cleaned up and displayed the correct way!<\/p>\n<p>So no more <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formulas\" data-wpil-keyword-link=\"linked\">formulas<\/a>, text to columns, trim spaces, vlookup, find &amp; replace etc.<\/p>\n<p>You have all that functionality in Power Query at the press of a menu command!\u00a0Now\u00a0your life has just become a lot&#8230;well, a hell of a lot easier \ud83d\ude42<\/p>\n<p>Apart from cleaning data, Power Query can append or merge two separate tables together (bye bye VLOOKUP!) as well as create extra\u00a0columns in your data\u00a0which can display your custom\u00a0calculations!<\/p>\n<p>You can use\u00a0Power Query to perform\u00a0transformations that would be very complex\u00a0in <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-macros-examples\/\" target=\"_blank\" rel=\"noopener\" title=\"VBA\" data-wpil-keyword-link=\"linked\">VBA<\/a> or SQL. \u00a0So goodbye VBA coding \ud83d\ude42 \ud83d\ude42 \ud83d\ude42<\/p>\n\n<h2><span class=\"ez-toc-section\" id=\"So_how_do_I_get_your_hands_on_this_super_awesome_add-in%E2%80%A6I_hear_you_say\"><\/span><strong>So how do I\u00a0get your hands on this super awesome add-in&#8230;I hear you say?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>First, you need to have <a class=\"wpil_keyword_link\" href=\"https:\/\/www.office.com\/\" target=\"_blank\" rel=\"noopener nofollow\" title=\"Microsoft Office\" data-wpil-keyword-link=\"linked\">Microsoft Office<\/a> 2013. \u00a0If you do not have this then you will need to upgrade to Office 365 using this link:<\/p>\n<p><span style=\"text-decoration: underline; color: #0000ff;\"><a style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/products.office.com\/en-us\/home\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">https:\/\/products.office.com\/en-us\/home<\/a><\/span><br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/uGBaZdVdAfk?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">?<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><br \/>\n<span style=\"color: #ff0000;\"><strong>STEP 1<\/strong><\/span>: The first step is to check the Excel bit version that you have on your PC.<\/p>\n<p>To check the bit version, you need to go and open any\u00a0Excel workbook and go to <strong>File &gt; Account &gt; About Excel, <\/strong>and from the pop-up dialogue box, you will see the <strong>bit number<\/strong>, either<strong>\u00a032-bit or 64-bit<\/strong>. \u00a0Once you know this, close out of Excel completely!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/bit-version.png\" rel=\"attachment wp-att-2658\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Install Power Query With Excel 2013\"  class=\"alignnone size-full wp-image-2658\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/bit-version.png\" alt=\"Install Power Query With Excel 2013\" width=\"774\" height=\"682\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/bit-version.png 774w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/bit-version-300x264.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/bit-version-768x677.png 768w\" sizes=\"(max-width: 774px) 100vw, 774px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> You will need to click on the following link and <strong>download the Power Query add-in<\/strong> from Microsoft&#8217;s website:<\/p>\n<p><span style=\"text-decoration: underline;\"><span style=\"color: #0000ff;\"><a style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=39379\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=39379<\/a><\/span><\/span><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/power-query-link.png\" rel=\"attachment wp-att-2551\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How To Install Power Query in Excel 2010\"  class=\"alignnone size-full wp-image-2551\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/power-query-link.png\" alt=\"How To Install Power Query in Excel 2010\" width=\"830\" height=\"524\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/power-query-link.png 830w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/power-query-link-300x189.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/power-query-link-768x485.png 768w\" sizes=\"(max-width: 830px) 100vw, 830px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span> <strong>Press the Download button<\/strong> and you will need to <strong>select the download bit version<\/strong>\u00a0based on the bit system your Excel 2013 version is running (from Step 1):<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/power-query-download-version.png\" rel=\"attachment wp-att-2556\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How To Install Power Query in Excel 2010\"  class=\"alignnone size-full wp-image-2556\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/power-query-download-version.png\" alt=\"How To Install Power Query in Excel 2010\" width=\"745\" height=\"267\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/power-query-download-version.png 745w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/power-query-download-version-300x108.png 300w\" sizes=\"(max-width: 745px) 100vw, 745px\" \/><\/a><\/p>\n<p>Press the <strong>NEXT<\/strong> button&#8230;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/next.png\" rel=\"attachment wp-att-2557\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How To Install Power Query in Excel 2010\"  class=\"alignnone size-full wp-image-2557\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/next.png\" alt=\"How To Install Power Query in Excel 2010\" width=\"398\" height=\"422\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/next.png 398w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/next-283x300.png 283w\" sizes=\"(max-width: 398px) 100vw, 398px\" \/><\/a><\/p>\n<p>&#8230;and this will start the download of the add-in installer .msi file installer on your browser (if you do not see this, go to your browser&#8217;s Downloads folder).<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4:<\/span>\u00a0Click on the .msi file to run the installer<\/strong>:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/msi.png\" rel=\"attachment wp-att-2558\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How To Install Power Query in Excel 2010\"  class=\"alignnone size-full wp-image-2558\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/msi.png\" alt=\"How To Install Power Query in Excel 2010\" width=\"213\" height=\"44\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5:<\/strong><\/span>\u00a0\u00a0This will bring up the <strong>Microsoft Power Query for Excel Setup<\/strong>:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/power-query-set-up.png\" rel=\"attachment wp-att-2560\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How To Install Power Query in Excel 2010\"  class=\"alignnone size-full wp-image-2560\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/power-query-set-up.png\" alt=\"How To Install Power Query in Excel 2010\" width=\"495\" height=\"387\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/power-query-set-up.png 495w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/power-query-set-up-300x235.png 300w\" sizes=\"(max-width: 495px) 100vw, 495px\" \/><\/a><\/p>\n<p>Click the <strong>Next<\/strong> button and <strong>accept the terms of the Licence Agreement<\/strong> and press <strong>Next<\/strong> again:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/licence-agreement.png\" rel=\"attachment wp-att-2561\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How To Install Power Query in Excel 2010\"  class=\"alignnone size-full wp-image-2561\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/licence-agreement.png\" alt=\"How To Install Power Query in Excel 2010\" width=\"495\" height=\"387\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/licence-agreement.png 495w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/licence-agreement-300x235.png 300w\" sizes=\"(max-width: 495px) 100vw, 495px\" \/><\/a><\/p>\n<p>You will be asked in which <strong>destination folder you want to install Power Query Excel 2013<\/strong>.<\/p>\n<p>Click <strong>Next for the default folder<\/strong> or <strong>Change if you want to install it in another folder:<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/destimation-folder.png\" rel=\"attachment wp-att-2562\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How To Install Power Query in Excel 2010\"  class=\"alignnone size-full wp-image-2562\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/destimation-folder.png\" alt=\"How To Install Power Query in Excel 2010\" width=\"495\" height=\"387\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/destimation-folder.png 495w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/destimation-folder-300x235.png 300w\" sizes=\"(max-width: 495px) 100vw, 495px\" \/><\/a><\/p>\n<p>Click <strong>Next<\/strong> and select the <strong>Install<\/strong> button:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Install.png\" rel=\"attachment wp-att-2563\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How To Install Power Query in Excel 2010\"  class=\"alignnone size-full wp-image-2563\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Install.png\" alt=\"How To Install Power Query in Excel 2010\" width=\"495\" height=\"387\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Install.png 495w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Install-300x235.png 300w\" sizes=\"(max-width: 495px) 100vw, 495px\" \/><\/a><\/p>\n<p>Click <strong>Yes<\/strong> if it asks you if you want to install Power Query on your computer. \u00a0<strong>The install for Power Query in Excel 2013 will now begin.<\/strong><\/p>\n<p>You will get the following message once your install has been <strong>completed successfully<\/strong>. \u00a0Press <strong>Finish!<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/setup-complete.png\" rel=\"attachment wp-att-2564\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How To Install Power Query in Excel 2010\"  class=\"alignnone size-full wp-image-2564\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/setup-complete.png\" alt=\"How To Install Power Query in Excel 2010\" width=\"495\" height=\"387\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/setup-complete.png 495w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/setup-complete-300x235.png 300w\" sizes=\"(max-width: 495px) 100vw, 495px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 6:<\/strong><\/span> <strong>Open a blank Excel workbook<\/strong> and on the ribbon menu you should now see the <strong>Power Query<\/strong>\u00a0tab:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/power-query-ribon.png\" rel=\"attachment wp-att-2659\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Install Power Query With Excel 2013\"  class=\"alignnone size-full wp-image-2659\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/power-query-ribon.png\" alt=\"Install Power Query With Excel 2013\" width=\"854\" height=\"129\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/power-query-ribon.png 854w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/power-query-ribon-300x45.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/power-query-ribon-768x116.png 768w\" sizes=\"(max-width: 854px) 100vw, 854px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 7:<\/strong><\/span> If you<span style=\"text-decoration: underline;\"><strong> do not see the Power Query tab<\/strong><\/span> you will need to activate this from the back end of Excel.<\/p>\n<p>You will need to go to<strong> File &gt; Options &gt; Add-Ins &gt;<\/strong> and at the bottom, you will need to select the <strong>Manage<\/strong> drop-down and choose <strong>COM Add-ins,<\/strong> and hit the <strong>Go<\/strong> button:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/excel-options.png\" rel=\"attachment wp-att-2660\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Install Power Query With Excel 2013\"  class=\"alignnone size-full wp-image-2660\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/excel-options.png\" alt=\"Install Power Query With Excel 2013\" width=\"826\" height=\"678\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/excel-options.png 826w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/excel-options-300x246.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/excel-options-768x630.png 768w\" sizes=\"(max-width: 826px) 100vw, 826px\" \/><\/a><\/p>\n<p>This will open the COM Add-Ins dialogue box and you will need to<strong> check the box for Microsoft Power Query for Excel and press OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/com-addins-check.png\" rel=\"attachment wp-att-2568\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How To Install Power Query in Excel 2010\"  class=\"alignnone size-full wp-image-2568\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/com-addins-check.png\" alt=\"How To Install Power Query in Excel 2010\" width=\"607\" height=\"247\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/com-addins-check.png 607w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/com-addins-check-300x122.png 300w\" sizes=\"(max-width: 607px) 100vw, 607px\" \/><\/a><\/p>\n<p>You will now see Power Query for Excel 2013 on your ribbon!<\/p>\n<p><strong>Further Learning:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/remove-duplicates-using-power-query\/\" target=\"_blank\" rel=\"noopener\">Remove Duplicates Using Power Query<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/split-a-query-into-two-parts-in-power-query\/\" target=\"_blank\" rel=\"noopener\">Split a Query into Two Parts in Power Query<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/comment-in-query-steps-in-power-query\/\" target=\"_blank\" rel=\"noopener\">Comment In Query Steps In Power Query<\/a><\/li>\n<\/ul>\n<p><span style=\"text-decoration: underline; color: #0000ff;\"><strong>HELPFUL RESOURCE:<\/strong><\/span><\/p>\n<p>Now that you have successfully installed Power Query on your desktop, we have a <span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-21.html\" target=\"_blank\" rel=\"noopener noreferrer\">Free Power Query webinar<\/a><\/span> that will show you its best features\u00a0that will make you more efficient and stand out from the crowd&#8230; <strong>Click below to register for free now:<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-21.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" title=\"VLOOKUP Example: Vlookup with a Drop Down List\"  class=\"wp-image-5921 size-full aligncenter\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/530x300-PQ.jpg\" alt=\"VLOOKUP Example: Vlookup with a Drop Down List\" width=\"530\" height=\"300\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/530x300-PQ.jpg 530w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/530x300-PQ-300x170.jpg 300w\" sizes=\"(max-width: 530px) 100vw, 530px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Power Query is a new add-in\u00a0that was introduced in\u00a0Excel 2013 by Microsoft and was that popular that they made it backward compatible with Excel 2010. Read the tutorial on how to install Power Query in Excel 2010 here So what is Power Query? Well you know when you get data from a file, a data [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17222,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[121,120],"tags":[117],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/2657"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=2657"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/2657\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17222"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=2657"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=2657"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=2657"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}