This article is contributed. See the original author and article here.

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.

 

Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.

%d bloggers like this: