Excel » Templates »

Time sheet for work

I have built a sheet to track time at work. It is very simple, there are 13 sheets, one for […]

Calendar – monthly view

This article describes how to build a calendar showing all days in a chosen month with corresponding scheduled events. What's […]

Multi-level To-Do list template

Today I will share a To-do list excel template with you. You can add text to the sheet and an […]

Heat map yearly calendar

The calendar shown in the image above highlights events based on frequency. It is made only with a few conditional […]

Highlight events in a yearly calendar

This article demonstrates how to highlight given date ranges in a yearly calendar, this calendar allows you to change the […]

Create monthly time sheet using a Pivot Table

Today I am going to demonstrate how amazing pivot tables are! Take a look at this time sheet. You can […]

Shift Schedule

Geoff asks: Hi Oscar, I have a cross reference table we use for shift scheduling. The x-axis is comprised of […]

Plot date ranges in a calendar part 2

I will in this article demonstrate a calendar that automatically highlights dates based on date ranges, the calendar populates names […]

Excel template: Getting Things Done [VBA]

In this article, I am going to demonstrate a simple workbook where you can create or delete projects and add […]

Advanced Gantt Chart Template

This Gantt chart uses a stacked bar chart to display the tasks and their corresponding date ranges. Completed days are […]

Free School Schedule Template

This template makes it easy for you to create a weekly school schedule, simply enter the time ranges and the […]

Basic invoice template

Rattan asks: In my workbook I have three worksheets; "Customer", "Vendor" and "Payment". In the Customer sheet I have a […]

Monthly calendar template #2

I have created another monthly calendar template for you to get. Select a month and year in cells A1 and […]

Monthly calendar template

The image above shows a calendar that is dynamic meaning you choose year and month and the calendar instantly updates […]

Invoice template with dependent drop down lists

This article demonstrates a basic invoice template I created. It lets you use dropdown lists to quickly select products on […]

Weekly schedule template

I would like to share this┬ásimple weekly schedule I created. How to use weekly schedule Type any date in cell […]