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 convert a birth date to an age without an expression using Microsoft Excel Power Query

This is the demonstration file to accompany the article, How to convert a birth date to an age without an expression using Microsoft Excel Power Query, by Susan Harkins. From the hottest programming ...
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, ...
MCPmag

Find Data in Excel Using PowerShell

Sometimes you need to scan some files for a piece of data like a string, phrase or some number, and one of those files just happens to be an Excel spreadsheet. You could open up the file, launch the ...