How to Handle Multiple Excel Header Rows Without Ruining Your Dataset

Learn a faster method to unpivot multiple header rows in Excel using Power Query. Optimize your data cleanup and reduce query ...
YouTube on MSN

I mastered Excel: pull data like a pro!

Learn how to pull data from another Excel sheet based on specific criteria. This video demonstrates four methods to extract ...
How-To Geek on MSN

I finally automated Excel timestamps, and it fixed my biggest data trust problem

Excel's Power Query lets you build report-level and table-level timestamps that update on refresh.
Computerworld

Alternative methods of zooming in Excel 2008

Macworld.com – One of the things I don’t like about Excel 2008 is that setting zoom levels is a bit more complex than it need be. If you use Excel’s View -> Zoom menu, this opens a new window, from ...
TechRepublic

Two quick methods for removing data validation rules in Excel

Two quick methods for removing data validation rules in Excel Your email has been sent Susan Harkins shows you a quick method for removing validation rules for multiple ranges in Excel, at the same ...