Getting tabular data from Analysis Services cubes using a PivotTable
Analysis Services cubes commonly have user-defined hierarchies, such as a date hierarchy. Getting a table of data at the right level of detail can be tricky. Large PivotTables can be slow to set up and manipulate. Learn more on how best to complete this task.
PowerPivot 2012 is now available for download here.
This new version, released March 2012, comes with many enhancements including user-defined hierarchies. For a comprehensive list of what's new click here.
Locating words or phrases in a worksheet
This trick can be more useful than Find as it identifies all cells that include the words/phrases at the same time. Great for auditing a listing of transaction descriptions.
Two ways to create a PivotTable from an Excel range using Excel 2010
Learn how to build your PivotTable and get the benefits of Excel's OLAP Tools
One of Excel's best kept secrets
Some reports, such as financial reports, require a very specific
layout that PivotTables don't afford. Find out how Excel Cube
Functions make it easy to build these reports and stay live-linked to
your database. Helps with dashboards too! 
How to copy a cell down a column - not a drag.
This is a real time-saver when copying a cell down hundreds of rows.
Cell Mate
Check out Cell Mate for a variety wish-I'd-known-that-before video Excel tips, trickery, and shortcuts.