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, ...
How-To Geek on MSN

Don't just hit save: 5 Excel formats that will change the way you work

Upgrade from standard Excel workbooks to specialized formats that shrink, shield, and streamline your spreadsheets.
TechRepublic

Sample file: Excel dashboard with PivotChart and Slicer objects

This file demonstrates the techniques explained in the article Create a quick and effective dashboard using Excel’s PivotChart and Slicer objects. Discover the secrets to IT leadership success with ...
TechRepublic

Sample file: How to split a column using an IF() function in Excel

This is the demonstration file to accompany the article, How to split a column using an IF() function in Excel, by Susan Harkins. From the hottest programming languages to commentary on the Linux OS, ...