How to Create an Employee Calendar in Excel. When you own or manage a small business, you may need to track employees' vacation times, hours worked or shifts scheduled.

Create your own calendar in Excel by hand If the templates dont offer what you want, and youd rather not use a VBA macro, heres how you can create your calendar in Excel exactly as you want it.

Click "Create" to copy your calendar to an Excel worksheet. Click a cell you want to edit and enter your text. To change the font size, click and drag the text, ...