MS Excel Slicers Without PivotTables : The Disconnected Table Trick

Learn the secret to building interactive Excel reports with slicers and disconnected tables—no PivotTable needed for dynamic filtering.
How-To Geek on MSN

How to Use the VSTACK and HSTACK Functions in Microsoft Excel

You can use Excel's VSTACK and HSTACK functions to append data in regular cell ranges, Excel tables, or named ranges. into cell E1 stacks the three arrays in the cell ranges A2 to C6, A9 to C13, and ...
GitHub

Custom functions in Excel

Custom functions enable you to add new functions to Excel by defining those functions in JavaScript as part of an add-in. Users within Excel can access custom functions just as they would any native ...
MUO on MSN

These two Excel functions make stacking data from multiple sheets too easy

The VSTACK and HSTACK functions enable efficient data combination from multiple sheets while maintaining dynamic ...
PC Magazine

These 46 Pro Excel Tips Will Transform You Into a Spreadsheet Magician

Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know. I've been writing professionally about computers, the internet, and technology ...