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

Excel's Custom Views tool lets you create a snapshot of your spreadsheet, allowing you to toggle between layouts.

Stop manually inserting rows and columns—use Excel's "secret" right-click-drag menu to move, swap, and convert data instantly.

With Endex, you can build a full DCF in Excel, including history, projections, and valuation outputs, producing audit ready ...