• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Power Query Updates

You are here: Home / Power Query / Power Query Updates
May 24, 2017 by Mynda Treacy

The monthly update cycle for Excel’s Power Query sure keeps us on our toes.

Power Query Updates for Excel 2010 and 2013

If you’re using Excel 2010, 2013 then you update Power Query by going to the Power Query download page and getting the latest copy and reinstalling it. No need to uninstall first, just download and install again.

Power Query Updates for Excel 2016 (non-subscription)

For Excel 2016 users who aren’t on an Office 365 subscription there’s bad news and good news. The bad news is you don’t get updates, the good news is you don’t have to re-learn how to do things in Power Query because Microsoft changed something!

That’s not to say the good outweighs the bad 😉

Power Query Updates for Excel 2016 Office 365

For Excel 2016 users with an Office 365 subscription your updates come at different intervals depending on your update channel. By default, Office 365 is installed on the Deferred Channel. This is often up to 6 months behind the Current Channel.

To find what Channel you’re on go to the File tab > Account. Below the Version number in the Product Information you’ll see the channel details. For example, this is what mine looks like:

MS Office product information

You can see I’m on a ‘special’ Office Insider Slow channel, the standard channels are Deferred and Current. You can find the updates available for the various channels on this page (change the radio buttons on the left-hand side to view the details for the different channels).

And this page explains how to switch to the current channel.

Updating Power Query Course

On my short-term to-do list is updating the Power Query course for the Excel 2016 menu (remember it’s only the Excel ribbon/menu, not the Power Query Editor menu itself), however with the constant changes it’s a moving target. For example, for non-updating versions of Excel 2016 the menu looks like this:

updating Power Query course

But recently my Excel 2016 Power Query menu has changed again and now looks like this:

Power Query menu 2016

Where do you think you’d click if you now wanted a ‘New Query’? If you said ‘Get Data’ you’d be right.

Did you also notice the old ‘Get External Data’ group has gone? It’s now hidden and only recoverable by changing the settings in Excel Options (via File tab):

Excel Options settings

Microsoft hid the old Get External Data menu because Power Query is the new Get data tool and it’s light years ahead of the legacy data import processes.

So, as Excel users these days we need to get used to Microsoft moving our menus around as they continue to develop and improve our beloved Excel.

And, as I’ve said before, when we’re learning we need to be prepared to go looking for icons and tools that look one way in a video, book or blog post, and are different in the latest version of the software we now have at our fingertips. To help us locate rogue icons we must comprehend the task, we can’t just copy clicks and learn by rote. Because when we comprehend the task we can use our understanding to bridge the gap between what we see in the video, book or blog post and the menus we have on our PC.

Of course, if you get stuck, our Excel Forum is where you can go for help.

Learn Power Query

Power Query is the most important Excel skill you can learn this year. It's going to give you the most bang for your training buck because it's for every Excel user. I can't think of an Excel job that doesn't involve getting data from somewhere, cleaning that data, adding columns and calculations to that data, and all before we can use it for reporting, or further analysis.

Power Query simplifies and automates these repetitive tasks with point and click ease.

If you haven't got yourself up to speed with Power Query yet, then please check out my Power Query course.

More Power Query Posts

Power Query if Statements incl. Nested ifs, if or, if and

How to write Power Query if statements, including nested if, ‘if or’ and ‘if and’, which are easier to write than their Excel counterparts.
power query variables

Power Query Variables 3 Ways

Power Query Variables enable you to create parameters that can be used repeatedly and they’re easily updated as they’re stored in one place.
delete empty rows and columns using power query

Remove Blank Rows and Columns from Tables in Power Query

Delete blank rows and columns from tables using Power Query. Even rows/columns with spaces, empty strings or non-printing whitespace
extracting data from lists and records in power query

Extracting Data from Nested Lists and Records in Power Query

Learn how to extract data from lists and records in Power Query, including examples where these data structures are nested inside each other.
combine files with different column names in power query

Combine Files With Different Column Names in Power Query

Learn how to load data into Power Query when the column names in your data don't match up. Sampe files to download.
power query keyboard shortcuts

Power Query Keyboard Shortcuts to Save Time

Time saving keyboard shortcuts for Power Query that work in both Excel and Power BI. Download the free Shortcuts eBook
remove text between delimiters power query

Remove Text Between Delimiters – Power Query

Remove all occurrences of text between delimiters. There's no in-built Power Query function to do this, but this code does.
power query advanced editor tips

Tips for Using The Power Query Advanced Editor

Tips for using the Power Query Advanced Editor in Excel and Power BI. Watch the video to see these tips in action
pivot unknown variable number of rows to columns

Pivot an Unknown Number of Rows into Columns

How do you pivot rows to columns when you don't know how many rows you're dealing with? It's not as easy as you may think.
try otherwise power query iferror

IFERROR in Power Query Using TRY OTHERWISE

Using TRY..OTHERWISE in Power Query Replicates Excel's IFERROR So You Can Trap and Manage Errors In Your Queries.


Category: Power Query
Previous Post:Excel ThemesExcel Themes
Next Post:Excel Dates Displayed in Different Languages

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Current ye@r *

Leave this field empty

Sidebar

More results...

launch excel macros course excel vba course

Featured Content

  • 10 Common Excel Mistakes to Avoid
  • Top Excel Functions for Data Analysts
  • Secrets to Building Excel Dashboards in Less Than 15 Minutes
  • Pro Excel Formula Writing Tips
  • Hidden Excel Double-Click Shortcuts
  • Top 10 Intermediate Excel Functions
  • 5 Pro Excel Dashboard Design Tips
  • 5 Excel SUM Function Tricks
  • 239 Excel Keyboard Shortcuts

100 Excel Tips and Tricks eBook

Download Free Tips & Tricks

Subscribe to Our Newsletter

Receive weekly tutorials on Excel, Power Query, Power Pivot, Power BI and More.

We respect your email privacy

239 Excel Keyboard Shortcuts

Download Free PDF

mynda treacy microsoft mvpHi, I'm Mynda Treacy and I run MOTH with my husband, Phil. Through our blog, webinars, YouTube channel and courses we hope we can help you learn Excel, Power Pivot and DAX, Power Query, Power BI, and Excel Dashboards.

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk – For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.