How to Make a Sales Order Form in Excel 2007. ... You can highlight multiple cells at once if necessary. ... the templates are found by clicking the File tab instead of the Office button.

The pivot table is a collection of tools that Excel uses to create reports from complex, multi-file spreadsheet data. Here's how to generate reports for single tables ...