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.
Cell Mate
Check out Cell Mate for a variety wish-I'd-known-that-before video Excel tips, trickery, and shortcuts.
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! 
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.
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.