Microsoft's spreadsheet program can do way more than you might imagine. These are the hacks and tricks you need to know.

Handle millions of rows by loading queries into Power Pivot, building relationships, and creating measures for fast variance ...

This example shows how to load only the required data on demand when the detail view is open. This can be useful if the grid control is bound to a large set of detailed data and you do not want to ...