Excel MVP Blog Roundup

This post has been republished via RSS; it originally appeared at: Excel Blog articles.

This week, we bring you more Excel knowledge from MVPs Chandoo, Jan Karel Pieterse, and Jeff Lenning.

 

Power Query Tutorial – What is it, How to use, Full examples, Tips & Tricks

Chandoo shares a tutorial on Power Query in Excel, including examples and tips & tricks.

 

Enabling Drag And Drop Between Two Listboxes On A VBA Userform

Jan Karel Pieterse walks through a few lines of VBA code to enable drag and drop between two listboxes on a userform.  

 

Dynamic Arrays (part 1, 2, and 3)

Jeff Lenning provides an overview of dynamic arrays in Excel in this three-part blog series.

 

Find this useful? Click Like below.

Want to know more about a specific Excel topic? Leave us a comment.

 

REMEMBER: these articles are REPUBLISHED. Your best bet to get a reply is to follow the link at the top of the post to the ORIGINAL post! BUT you're more than welcome to start discussions here:

This site uses Akismet to reduce spam. Learn how your comment data is processed.