Credit: Rob Schultz
The list of 'anythings' Excel can do keeps growing, as new versions with more templates and better features are released. Many prefer the simplicity of Excel over Word because it offers a huge, very adaptable grid with drag-and-drop graphics that are easy to manipulate.
Custom projects in Excel include invoices, sales receipts, expense reports, budgets, mileage records, graph paper, note pads, business cards, forms, flyers, brochures, certificates, flowcharts, and so much more. Excel provides dozens of fill-in-the-blank templates, or you can follow our instructions to create your own projects.
Customize calendar templates
We've already shown you how to create a custom calendar in Excel, but you can always start with one of Excel's Template Calendars. For example, Excel's Any Year Calendar provides 12 months at a glance for any year you need. Click the small option arrows beside the year to change the year (including all 12 months). Click the merged cells AE/AF1 beside the words "Select Week Start" to activate this feature. Click the small option arrow box to reorganize the calendar from Sunday through Saturday to Monday through Sunday.
Go to the Main/Full-Screen File menu (now called the Backstage panel), click New, then type Calendars in the Search box to view dozens of calendar templates, which can all be customized, including current year, images, special days/holidays, events, colors, fonts, styles, and even corporate logos.
Set up graph paper
All you want is a few sheets of grid/graph paper in a hurry. No problem. Open a blank Excel spreadsheet. For a standard 8.5x11-inch piece of paper, highlight cells A1 through BD83. From the Home tab's Cells group, select Format > Column Width. Enter 1 in the dialog box and click OK. With the same range still highlighted, select Format > Row Height. Enter 9 in the dialog box and click OK.
Next, change the margins to a half-inch on all sides. From the Page Layout tab's Page Setup group, select Margins > Custom. Select the Margins tab in the Page Setup dialog, and enter .5 for Top, Bottom, Left, and Right. Set the Header and Footer margins to 0, then check both boxes under Center on Page: Horizontally and Vertically.
Before you close this dialog box, select the Sheet tab, check the box for Gridlines, then click OK. Highlight the range again (cells A1 through BD83). From the Page Layout tab's Page Setup group, click Print Area > Set Print Area. Now, just print as many as you need (and don't forget to save your work).
Make address labels
This one is a cinch for Excel and you can add lots of mini pictures to the labels to jazz up the aesthetics or use your company logo. The easiest way to design label sheets is to review the actual labels online at sites such as Avery, (which provides the size and placement of the labels on an 8.5x11-inch sheets). The labels in this spreadsheet are based on the "Address Label, 30 per sheet - 1 x 2 5/8" (a common size available everywhere).
Sign up for Computerworld eNewsletters.