If you would like to reduce the amount of Excel editing you have to do considering using the SourceYourMeeting.com Guest User functionality. This allows your customer to customize their own report and see the online grid for just the projects/meetings you share with them.
Create Macros when you have repeat actions. You know what they say about doing the same thing over and over again.
Once you create a template do Save As so you don't overwrite it by mistake. (SavesAs Template (.xlmt))
Copy a Tab of data to another tab before manipulating the data so you have a starting point to go back to.
Hide columns you don't wish to display, (avoid Delete whenever possible) (Lynda.com has a great tutorial on using the Protect Workbook as well, to protect hidden columns from other users.
Widen columns by the width of the data (Careful not to expand all to the number of characters because comments fields have 1000+ characters)
Double click on the vertical divider line between a columns (or multiple selected columns)
Another function that is helpful is to "Wrap Text" in cells that have Comments
Format (Horizontal Alignment)
Sort and Filter: Here you will want to set your order or filter data
Filters on a single Row or Multiple Rows using "Filter" on the Data Tab in Excel
Preparing to Distribute or Show
Page Setup (Preview / Page view / Gridlines / Row and Column Headings) this is where you will want to:
Change the orientation to Landscape
Adjust the Scaling to fit more on a page
Add a customer header and footer for Page 1, Logo, Phone Number, etc)
On Sheet Tab click "Gridlines", "Row and column headings"
Print Titles (Page Layout Tab) allows you to select a row or columns you'd like to show on every page on reports that will print on multiple pages.