Work Schedule Template for Excel

Similar to our free class schedule template, this bi-weekly work schedule template allows you to quickly print a template for planning your week or organizing shift schedules. It is based upon the Work Week view in Microsoft Outlook. However, since it is an Excel spreadsheet, it is completely customizable!

Bi-Weekly Work Schedule Template

Screenshot

Plan your work week using this work schedule template for Excel. With just a few clicks, you can modify the Year, Month, Week, and Start Time. You can also go a step further and customize the template to suit your needs. "No Installation, No Macros - Just a simple spreadsheet"

Download Now Cost: Free ($0.00) License: Personal Use Only File Type: .xls Version: 1.3 Required: Microsoft Excel® 2002(XP), 2003, or 2007

FEATURES:

1) Simple Controls For the Year, Month, Week, and Start Time

This template uses Excel's built-in form controls, so there are no macros that tend to make many other spreadsheets difficult to customize.

Figure 1: Controls for Choosing Year, Month, Week, and Start Time

2) Convenient Previous and Next Month Calendars

These monthly calendars help you see at a glance what weeks you are working on.

The next-month calendar is handy for highlighting important future dates or goals after the schedule has been printed. To highlight specific dates, you can use Excel's drawings tools to circle specific dates.

Figure 2: Monthly calendars for reference and planning.

3) Dates Included for Each Day of the Week

You could use a template that does not include the dates, but if you are going to use this template more than once, or plan to print copies for your co-workers, you can't do without the dates.

Figure 3: Dates displayed for each day of the week.

4) Easy Printing

The work schedule template has already been set up to print to a normal letter-sized sheet of paper. However, you can customize the spreadsheet to print to other sizes and orientations (by changing column widths and font sizes and/or using Excel's page-setup to fit the spreadsheet to other sizes).

Printing a Specific Range of Cells to Any Size Paper in Excel:

1. Go to File -> Print Area -> Set Print Area.
2. Select the range of cells you want to print.
3. Go to File -> Page Setup
4. In the Page tab, select the "Fit To: " option
5. Select print preview and change other printing options as needed.
6. To change the paper size in the Page Setup window, press the "Options..." button and depending upon your printer, the paper size selection may be in the "Advanced..." settings.

5) Times Adjust To Accommodate YOUR Work Schedule

This work schedule template divides each day of the week into 30-minute intervals, starting with the hour you specify (see Figure 1). This is handy if you tend to work shifts other than the basic 8:00am-5:00pm.

What This Template Won't Do

It won't store the entries that you make into a database so that you can keep a history of your appointments or plans. If you need this type of functionality, I would suggest using Microsoft Outlook (which you probably already have if you own Excel).

Instead of Paying For This Template ...

If you like this Excel template, please just tell your friends and coworkers about it.