Making your Own Excel Travel Planner Template
You can make your travel planner in an Excel spreadsheet. Microsoft Excel is an easy software to work with. If you’re good at excel, you can create a detailed schedule of your activities before and during the holiday time. If you aren’t, no problem; you can still try using it. It’s easy to do, though it might take a little time to familiarize yourself with the design software. Basically, you should know what you want out of it. You can draw it in rough on paper, and copy it on your excel spreadsheet. You can use your creativity to:
Design your template
Vary text fonts and colors
Add or remove rows and columns
Adjust the column and row sizes
Create borders for blocks
Highlight priority tasks
Just make sure you highlight each must-do lists or reminders and dates with same colors, so they’re easy to locate at a glance. Borders will help you to check a whole block easily. Once you’ve got the excel travel planner template ready, you can use it again, and update the travel planner with your next holiday info.
What to Include in the Excel Travel Planner Template?
You’ve decided to draw your template but don’t know what to include and where, then this excel travel planner template design description will give you an idea about what all you can do. At the top of your excel sheet, you can type where you’re going for a holiday. Then type in Travel Dates keeping a cell space for information you want to fill in. Similarly add the start date and end date in the same row. In the next row, beginning with the month and year, you can put in the dates of your holiday one-by-one in a row in bold, say if your holiday starts from January 1, 2010, followed by the other dates. On the extreme left down, you can optionally keep the month’s calendar, say January 2010, in this case, (the option is built-in in excel, so you don’t have to type in the calendar; just go to Insert, select Object and then choose Calendar). Once you’ve installed the calendar, you can also highlight the start and end dates of your holiday on it. Underneath, in the same column, type Things to Do and below that make a note of things that you need to take along like
a map of the place you’re visiting (if you’re going there for the first time or traveling by road)
any vouchers you will be able to avail there (specially if you are visiting a spa resort)
warm clothes (that’s a must, especially, if you are going in fall or winter)
sports gear (e.g.: fishing gear)
to the things to do list. Keep a column on the left of the list free, so you can cross-check whether you’ve packed all of them, in the check box. Below this, add Things to Remember, which will have to and fro airline reservations, accommodation at the vacation destination and rental car details, starting from the left of the spreadsheet. Below this, for the Activity Schedule, you can distribute the day on hourly basis, and put down the schedule of activities to be done on each day. This holiday travel template will be easy to create. Just keep in mind that your travel planner template should not be complicated or difficult to follow. After you’ve finished working on it, don’t forget to save the excel travel planner template. Once completed, you can either take a print-out and fill it manually with ink or if you’re taking your laptop along on your holiday, you can still update or refer to it.