Templates


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 each […]

Calendar – monthly view

Tesh asks: How easy is it to modify this for recurring tasks (weekdays, weekly, monthly, quarterly and yearly) and maybe […]

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 excel creates […]

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 calendar

Steven asks: I got 6 events with different dates... Event - DATE START - DATE END 1 2 3 4 […]

Monthly time sheet by project

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

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 have created a new version of Visualize date ranges in  a calendar. This excel file let´s you enter names […]

Excel template: Getting Things Done [VBA]

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

Holiday planner

Todays template is a holiday planner. It is a stacked bar chart and the worksheet contains a few lines of […]

Advanced Gantt Chart Template

This Gantt chart template is a stacked bar chart and new tasks are added as you type them. Completed (green) […]

Free School Schedule Template

This template makes it easy for you to create a weekly school schedule. The template has hours divided into 10 […]

Basic invoice template

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

Cash drawer bill extractor

Question: I need to setup a template to remove the largest available (Qty and denomination)bills and leave exactly $150 back […]

Monthly calendar template #2

I have created another monthly calendar template for you to download. Download excel calendar template Monthly-calendar-template #2.xls (Excel 97-2003 Workbook […]

Monthly calendar template

I have created a monthly calendar template for you to download. Download excel calendar template Week starts with sunday Monthly […]

Invoice template with dependent drop down lists

Overview This post descibes how to use a basic invoice template I created. The invoice template let´s you use dropdown […]

Weekly schedule template

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