Power Query and the Secrets of the LOAD To Option
Most people who use Power Query to import data into Excel get to the final step and click the Load button. Why? Probably because it's "just there".
But with just a couple of extra clicks you can uncover a whole array of extra options for controlling the destination of the imported data.
There’s also a gotcha to watch out for if you tick a particular checkbox.
All will be revealed in this video including how to change the default settings for importing data.
For full details see the timestamps below:
⏱ Timestamps
00:00:00 Introduction
00:00:32 Load data into a new worksheet
00:01:23 Load data into an existing worksheet
00:02:19 Load data into the Data Model
00:04:00 Load multiple datasets
00:06:51 Change the default load settings
🗒 Notes and Resources
Download a copy of the files used in this video: https://share.getcloudapp.com/BluWREw5
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #powerquery #import