How-To Geek on MSN

5 everyday actions that Power Query does better than regular Excel tools

Any null values will show as blank cells in the final Excel table. If you'd prefer to fix this within the Power Query Editor, ...
Houston Chronicle

How to Create a Hyperlinked Table of Contents for Worksheets

Combine the navigational features of hyperlinks with the organizational capabilities of a table of contents, and you get a powerful new way to manage large Excel workbooks. You can create an Excel TOC ...