Question

Practice using Get & Transform (Also called Power Query)

Answer 1

I don’t think you will have to practice much to get up to speed if you have been out a few years. Also given some companies are still using excel 2007, you should be fine.

Answer 2

I prefer the 2019 version to 2016 due to the UI changes but they’re pretty much identical. Weird your job is mentioning power query editor, it seems like most employers knowledge of excel ends with “pivot tables and vlookups” like they’re some complex feature….

Edit: I will say an underutilized aspect of excel is array formulas tho. You can replicate sumifs logic on closed external workbooks

Answer 3

I learned a lot from watching ExcelisFun YouTube channel. And by actually using it and googlong what I need to do.

Answer 4

youtube videos and stackexchange is pretty much how i learned how to use powerquery