Are you an Excel for Mac Power Query user? Are you frustrated with missing Get Data functionality (compared to Excel for Windows)? Check out this add-in!
Microsoft have done a great job with adding Power Query to Excel on the Mac. However, compared to Power Query in Excel on Windows, when it comes to Get Data, there are several missing options.
This week I came across a free addin called MoreQuery for Mac which attempts redress the balance by adding four additional data sources under Get Data, two of which I’m going to cover in this video - Get Data From Range and Get Data From Folder.
I’d like to say a huge thank you to Suat Ozgur who wrote the addin and Bill Jelen for sharing it on LinkedIn
For full details see the timestamps below:
⏱ Timestamps
00:00:00 Introduction
00:01:47 From Table or Range
00:03:10 Combine Multiple Files from a Folder
🗒 Notes and Resources
You can download the addin from: www.mrexcel.com/download-cent... (V2 released 18 May 2023)
This link contains details of how the addin was created (from a technical point of view);
www.mrexcel.com/board/excel-a...
If you have support queries please contact Suat directly. His email address is embedded in the VBA code of the addin
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #powerquery #mac
Негізгі бет Excel for Mac: Power Query Just Got Better with MoreQuery - a Free Add-In. Check It Out Here!
Пікірлер: 28