tag:blogger.com,1999:blog-93079352024-03-06T13:01:16.095-07:00Excel TemplatesNew and Interesting Excel Templates and SpreadsheetsJon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.comBlogger147125tag:blogger.com,1999:blog-9307935.post-62799664323686490022017-01-10T17:53:00.001-07:002017-01-10T17:57:07.641-07:004 New Task List Templates<div class="separator" style="clear: both; text-align: center;">
<img alt="Project Task List Thumbnail" border="0" src="https://cdn.vertex42.com/ExcelTemplates/Images/todolists/project-task-list-template_200.png" title="Project Task List Thumbnail" /></div>
<div>
These 4 new task list templates demonstrate various techniques that you can use to spice up your lists in Excel. Add drop-down lists, custom icon sets, conditional formatting rules, etc. The <a href="https://www.vertex42.com/ExcelTemplates/task-list-template.html">Project Task List Template</a> shown to the left is just one of them.</div>
<div>
<br /></div>
Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-84400183891913526012013-07-09T11:04:00.003-07:002016-11-21T14:45:20.339-07:00Chore Chart for Kids<div class="separator" style="clear: both; text-align: center;">
<a href="http://cdn.vertex42.com/ExcelTemplates/Images/kids-chore-chart-template_200.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://cdn.vertex42.com/ExcelTemplates/Images/kids-chore-chart-template_200.png"></a></div>
If you are looking for a way to keep track of both chores and a weekly schedule, you can try this new <a href="https://www.vertex42.com/ExcelTemplates/kids-chore-schedule.html">chore chart template</a>.<br>
<br>
<a href="https://excel-templates.blogspot.com/2013/07/chore-chart-for-kids.html#more">Read more »</a>Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-83266440354032247812013-07-03T10:15:00.000-07:002016-11-21T14:46:01.623-07:00Chore Schedule for Kids<div class="separator" style="clear: both; text-align: center;">
<a href="http://cdn.vertex42.com/ExcelTemplates/Images/kids-chore-schedule_200.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://cdn.vertex42.com/ExcelTemplates/Images/kids-chore-schedule_200.png" /></a></div>
If you have more than one child, this <a href="https://www.vertex42.com/ExcelTemplates/kids-chore-schedule.html">chore schedule template</a> can help you assign chores in a way that lets both you and your kids easily keep track of who is doing what.Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-55733884376412279122013-06-07T20:51:00.004-07:002016-11-28T15:24:25.919-07:00Time Tracking Template for Excel<div class="separator" style="clear: both; text-align: center;">
<a href="http://cdn.vertex42.com/ExcelTemplates/Images/time-tracking-template.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img alt="Time Tracker Thumbnail" border="0" src="https://cdn.vertex42.com/ExcelTemplates/Images/time-tracking-template_180.png" title="Time Tracker Thumbnail" /></a></div>
<div>
Consultants and sub-contractors often need a way to log hours worked differently than regular employees. This <a href="https://www.vertex42.com/ExcelTemplates/time-tracker.html">time tracking template</a> was designed to help consultants log hours worked and bill for those hours, keeping track of what hours have already been billed.</div>
<div>
<br /></div>
<a href="http://www.blogger.com/blogger.g?blogID=9307935"></a>
<br />
<blockquote>
</blockquote>
Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com1tag:blogger.com,1999:blog-9307935.post-81981408052536581322013-06-07T20:35:00.000-07:002016-11-28T15:26:01.190-07:00Wedding Planning Checklist - New Version<div class="separator" style="clear: both; text-align: left;">
<a href="https://cdn.vertex42.com/ExcelTemplates/Images/wedding-planning-checklist.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img alt="Wedding Planning Checklist Thumbnail" border="0" src="https://cdn.vertex42.com/ExcelTemplates/Images/wedding-planning-checklist_180.png" title="Wedding Planning Checklist Thumbnail" /></a></div>
During the process of creating the new XLSX version (Excel 2007 or later) of the <a href="https://www.vertex42.com/ExcelTemplates/wedding-planning-checklist.html">wedding planning checklist</a>, we also updated the look to this emerald green, and finally corrected the spelling of stationery. :-)<br />
Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-41771433896289372602013-02-13T10:52:00.004-07:002016-11-28T15:29:53.816-07:00Baseball Roster and Lineup Template<a href="https://cdn.vertex42.com/ExcelTemplates/Images/baseball-roster-template_180.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img alt="baseball roster template" border="0" src="https://cdn.vertex42.com/ExcelTemplates/Images/baseball-roster-template_180.png" /></a>This new <a href="https://www.vertex42.com/ExcelTemplates/baseball-roster.html">baseball roster</a> template includes a Roster worksheet for player and parent contact information, a Lineup worksheet for creating auto-rotating lineups, a printable Scorecard worksheet for keeping stats at the game, and a Stats worksheet for keeping a record of the stats for each game.Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-40529359455245877212013-02-05T11:48:00.001-07:002016-11-28T15:33:23.673-07:00Customer Relationship Management Template<div class="separator" style="clear: both; text-align: center;">
<a href="https://cdn.vertex42.com/ExcelTemplates/Images/crm-template-in-excel.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img alt="CRM Template" border="0" src="https://cdn.vertex42.com/ExcelTemplates/Images/crm-template-in-excel_200.png" height="143" width="200" /></a></div>
This <a href="https://www.blogger.com/blogger.g?blogID=9307935">CRM Template</a> provides a framework for creating a custom CRM system for a small business. It allows you to keep a log of contacts made with sales leads and sort the list based on last contact, next contact, etc.Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-54087575359383699122013-01-29T12:42:00.000-07:002016-11-28T15:33:37.097-07:00Schedule of Events Template<div class="separator" style="clear: both; text-align: center;">
<a href="https://cdn.vertex42.com/calendars/images/yearly-schedule-of-events.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="180" src="https://cdn.vertex42.com/calendars/images/yearly-schedule-of-events_180.png" width="139" /></a></div>
This <a href="https://www.vertex42.com/calendars/yearly-schedule-of-events.html">Yearly Schedule of Events</a> template uses conditional formatting to highlight dates in mini calendars based upon a chosen "event type" such as "holiday". You can define your own custom event types if you don't want to use the types already in the template (holiday, event, note). This type of event schedule is commonly used by schools or other organizations for showing events going on throughout the year.Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-91275649808875258352012-12-06T12:54:00.002-07:002016-11-28T15:33:49.018-07:00New Medication List Template<div class="separator" style="clear: both; text-align: center;">
<a href="https://cdn.vertex42.com/ExcelTemplates/Images/medication-list-template.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="154" src="https://cdn.vertex42.com/ExcelTemplates/Images/medication-list-template_200.png" width="200" /></a></div>
Try this new <a href="https://www.vertex42.com/ExcelTemplates/medication-list.html">Medication List Template</a> to keep track of your prescriptions, vitamins, and supplements. Print the list to take with you to your healthcare visits.
Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-25820261887446860352012-11-26T16:33:00.001-07:002016-11-28T15:34:00.867-07:00New Vehicle Maintenance Log Template<div class="separator" style="clear: both; text-align: center;">
<a href="https://cdn.vertex42.com/ExcelTemplates/Images/vehicle-maintenance-log.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="180" src="https://cdn.vertex42.com/ExcelTemplates/Images/vehicle-maintenance-log_180.png" width="139" /></a></div>
This new <a href="https://www.vertex42.com/ExcelTemplates/vehicle-maintenance-log.html">Vehicle Maintenance Log</a> came about due to a recent request from a Vertex42 Facebook fan. It lets you record the maintenance history and repairs for your vehicle(s). You can also use it to list the manufacturer's recommended maintenance schedule.Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-26848268902654167172012-11-07T13:01:00.000-07:002016-11-28T15:34:11.714-07:00Business Mileage Tracking and Reimbursement<div class="separator" style="clear: both; text-align: center;">
<a href="https://cdn.vertex42.com/ExcelTemplates/Images/mileage-tracker.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="180" src="https://cdn.vertex42.com/ExcelTemplates/Images/mileage-tracker_180.png" width="139" /></a></div>
If you use a vehicle for business use, then you may be able to deduct mileage expenses on your tax return. To do that, you'll need to keep certain records. Vertex42's new <a href="https://www.vertex42.com/ExcelTemplates/mileage-tracking.html">Mileage Tracking Log</a> can help you keep the mileage records as well as calculate the reimbursement amount.
Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-6876046358918643492012-10-18T15:57:00.002-07:002016-11-28T15:34:28.354-07:00Project Budgeting Templates<div class="separator" style="float: left; margin-right: 20px; text-align: left;">
<img border="0" height="180" src="https://cdn.vertex42.com/ExcelTemplates/Images/project-budget-template_180.png" width="139" /></div>
Just added 3 new <a href="https://www.vertex42.com/ExcelTemplates/project-budget.html">Project Budgeting Templates</a>. One was created based on my gantt chart template and uses a WBS (work breakdown structure) layout. The others were based on the business budget template and personal budget spreadsheet. Hopefully, there will be something that can be used for nearly any project.
<br />
<div class="separator" style="clear: both; text-align: left;">
<img border="0" height="180" src="https://cdn.vertex42.com/ExcelTemplates/Images/project-budget-basic_180.png" width="139" />
<img border="0" height="155" src="https://cdn.vertex42.com/ExcelTemplates/Images/project-budgeting-monthly_200.png" width="200" /></div>
Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-22110186686404333772012-10-08T16:59:00.000-07:002016-11-28T15:36:46.418-07:00Bill of Materials Example<div class="separator" style="clear: both; text-align: center;">
<a href="https://cdn.vertex42.com/ExcelTemplates/Images/bill-of-materials-example.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="180" src="https://cdn.vertex42.com/ExcelTemplates/Images/bill-of-materials-example_180.png" width="139" /></a></div>
Download a <a href="https://www.vertex42.com/ExcelTemplates/bill-of-materials.html">Bill of Materials</a> template to create a parts list for your product. The example shows the pieces for building a custom mini Star Wars® X-Wing™ model out of LEGO® bricks.
Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-56390242430706684342012-08-06T08:29:00.001-07:002016-11-28T15:37:04.577-07:00Project Tracker for Excel<div class="separator" style="clear: both; text-align: center;">
<a href="https://www.vertex42.com/ExcelTemplates/project-tracking-template.html" imageanchor="1" style="clear:left; float:left;margin-right:1em; margin-bottom:1em"><img border="0" alt="Project Tracker" height="154" width="200" src="https://cdn.vertex42.com/ExcelTemplates/Images/project-tracking-template_200.png" /></a></div>If you are a contractor or freelancer, you can use this <a href="https://www.vertex42.com/ExcelTemplates/project-tracking-template.html">Project Tracking Template</a> to record all of the individual tasks and deliverables that have been assigned to you by a specific client. It is particularly useful when the client assigns new tasks frequently, and you want a way to keep track of the new and completed tasks.Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-30546445543218101612012-03-28T12:49:00.003-07:002016-11-28T15:36:17.816-07:00Soccer Team Roster Template<img alt="Soccer Roster Template" border="0" src="https://cdn.vertex42.com/ExcelTemplates/Images/soccer-team-roster-template_180.png" style="cursor: hand; cursor: pointer; float: left; height: 180px; margin: 0 10px 10px 0; width: 139px;" />Use this <a href="https://www.vertex42.com/ExcelTemplates/soccer-roster-template.html">Soccer Roster Template</a> to create a 1-pager that contains admin and contact info along with the team roster information and the game schedule. The template also help coaches to track stats and create game lineups.Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-70108937467244476862012-01-19T13:02:00.003-07:002016-11-28T15:35:49.206-07:00House Cleaning Schedule and Checklists<a href="https://www.vertex42.com/ExcelTemplates/house-cleaning-schedule-checklist.html"><img alt="Cleaning Schedule Template" border="0" src="https://cdn.vertex42.com/ExcelTemplates/Images/house-cleaning-schedule-template_200.png" style="cursor: hand; cursor: pointer; float: left; height: 154px; margin: 0 10px 10px 0; width: 200px;" /></a> This new <br />
<a href="https://www.vertex42.com/ExcelTemplates/house-cleaning-schedule-checklist.html">Cleaning Schedule / Checklist</a> template will help you get organized. Add your chores to the 4-week schedule and download checklists for cleaning house and spring-cleaning.Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-40319169417057570852012-01-11T15:21:00.002-07:002016-11-28T15:35:33.102-07:00Reward Chart Templates<a href="https://www.vertex42.com/ExcelTemplates/reward-charts.html"><img alt="Reward Chart Template" border="0" src="https://cdn.vertex42.com/ExcelTemplates/Images/reward-chart-for-kids_200.png" style="cursor: hand; cursor: pointer; float: left; height: 155px; margin: 0 10px 10px 0; width: 200px;" /></a> Download a few different types of <a href="https://www.vertex42.com/ExcelTemplates/reward-charts.html">Reward Charts</a> for your kids, including a simple reward chart as shown in the image, a practice chart, school behavior chart, and a weekly reward chart for multiple kids.Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-83175039799315437782011-11-16T16:35:00.003-07:002016-11-28T15:37:59.459-07:00Job Application Template<a href="https://www.vertex42.com/ExcelTemplates/job-application-form.html" onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}"><img alt="Job Application Template" border="0" src="https://cdn.vertex42.com/ExcelTemplates/Images/job-application-form_180.png" style="cursor: hand; cursor: pointer; float: left; height: 180px; margin: 0 10px 10px 0; width: 139px;" /></a> This new <a href="https://www.vertex42.com/ExcelTemplates/job-application-form.html">Job Application Form Template</a> can help you gather information from job applicants without having to design your own form. You customize it as needed, or use it as-is.Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-69188716414530480012011-10-18T15:09:00.003-07:002016-11-28T15:38:42.128-07:00College Budget Template<a href="https://cdn.vertex42.com/ExcelTemplates/Images/college-student-budget.png"><img alt="College Student Budget" border="0" src="https://cdn.vertex42.com/ExcelTemplates/Images/college-student-budget_200.png" style="cursor: hand; cursor: pointer; float: left; height: 154px; margin: 0 10px 10px 0; width: 200px;" /></a><br />
This new <a href="https://www.vertex42.com/ExcelTemplates/college-budget.html">College Budget</a> template can help you create a yearly college budget, with expenses grouped by semester.Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-41849153851497411252011-10-12T15:58:00.001-07:002016-11-28T15:39:26.596-07:00Stock Inventory Control Spreadsheet<a href="https://cdn.vertex42.com/ExcelTemplates/Images/inventory-control-template.png"><img alt="Inventory Control Template" border="0" src="https://cdn.vertex42.com/ExcelTemplates/Images/inventory-control-template_200.gif" style="cursor: hand; cursor: pointer; float: left; height: 157px; margin: 0 10px 10px 0; width: 200px;" /></a> This new <a href="https://www.vertex42.com/ExcelTemplates/inventory-control-template.html">Inventory Control Spreadsheet</a> includes a worksheet for tracking current, on order, back ordered stock. It also includes an inventory label template, supplier contact info list, and physical count sheet.Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-13583252939651611302011-09-28T12:28:00.002-07:002016-11-28T15:40:08.125-07:00Packing List Template<a href="https://cdn.vertex42.com/ExcelTemplates/Images/vacation-packing-list.gif"><img alt="Packing List Template" border="0" src="https://cdn.vertex42.com/ExcelTemplates/Images/vacation-packing-list_180.gif" style="cursor: hand; cursor: pointer; float: left; height: 180px; margin: 0 10px 10px 0; width: 139px;" /></a><br />
This new <a href="https://www.vertex42.com/ExcelTemplates/packing-list.html">Packing List</a> template contains lists to help prepare for business travel, vacation, and college.Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com1tag:blogger.com,1999:blog-9307935.post-18639640260383595402011-09-20T12:19:00.003-07:002016-11-28T15:40:36.115-07:00Software Inventory Tracking Template<a href="https://www.vertex42.com/ExcelTemplates/software-inventory-tracking.html"><img alt="Inventory Tracking Template" border="0" src="https://cdn.vertex42.com/ExcelTemplates/Images/software-inventory-tracking_200.gif" style="cursor: hand; cursor: pointer; float: left; height: 154px; margin: 0 10px 10px 0; width: 200px;" /></a><br />
The new <a href="https://www.vertex42.com/ExcelTemplates/software-inventory-tracking.html">Software Inventory</a> template was derived from the asset tracking template, but designed specifically for tracking software licenses, computer hardware, license expiration, etc.Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-11061918444524726352011-07-28T16:33:00.003-07:002016-11-28T15:41:28.428-07:00Wedding Guest List Template<a href="https://www.vertex42.com/ExcelTemplates/wedding-guest-list.html"><img alt="Wedding Guest List" border="0" src="https://cdn.vertex42.com/ExcelTemplates/Images/wedding-guest-list_180.gif" style="cursor: hand; cursor: pointer; float: left; height: 139px; margin: 0 10px 10px 0; width: 180px;" /></a> Use this <a href="https://www.vertex42.com/ExcelTemplates/wedding-guest-list.html">Wedding Guest List Template</a> to help you keep track of your wedding invitations and the number of people attending your rehearsal dinner and/or reception. You can also make notes about dietary restrictions and gifts received.Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-10283429959746615012011-04-25T14:31:00.004-07:002016-11-28T15:42:05.226-07:00Periodic Table in Excel<a href="https://cdn.vertex42.com/ExcelTemplates/Images/periodic-table-of-the-elements.gif"><img alt="Periodic Table in Excel" border="0" src="https://cdn.vertex42.com/ExcelTemplates/Images/periodic-table_thumbnail.gif" style="cursor: hand; cursor: pointer; float: left; height: 94px; margin: 0 10px 10px 0; width: 120px;" /></a> Need a periodic table packed with element property data? Check out this <a href="https://www.vertex42.com/ExcelTemplates/periodic-table-of-elements.html">Periodic Table</a>. Thanks to print scaling in Excel, it is possible to create a good-looking, data-rich, periodic table and have it print nicely on a single sheet of paper.Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-61723808861482421652011-03-08T09:33:00.002-07:002016-11-28T15:42:44.465-07:00Contact List Template<a href="https://cdn.vertex42.com/ExcelTemplates/Images/contact-list-template.gif"><img alt="Contact List" border="0" src="https://cdn.vertex42.com/ExcelTemplates/Images/contact-list-template_sm.gif" style="cursor: hand; cursor: pointer; float: left; height: 120px; margin: 0 10px 10px 0; width: 151px;" /></a><br />
Download this <a href="https://www.vertex42.com/ExcelTemplates/contact-list.html">Contact List</a> template to customize your phone list, address list, email list or other contacts.Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0