|
|
Vertex42™ is a leading provider of Excel templates, financial calculators, and calendars. We also host The Excel Nexus - The ultimate directory of 3rd-party Microsoft Excel® resources, including add-ins, templates, tutorials, and consulting services.
Quickly create project schedules with this professional Gantt Chart template. |
Try our invoice templates, purchase order templates, and billing statements. |
Employee time tracking and expense reporting is a popular use for Excel. Download our free timesheet template. |
Check out our collection of family, home, business, and personal budget templates. |
Our loan amortization spreadsheet works for many types of fixed-rate loans and allows you to enter optional extra payments.
|
Our full-featured mortgage calculator, including fixed-rate and adjust-rate mortgages, amortization schedule, and optional extra payments. |
How fast can I get out of debt? Try different debt reduction strategies and list up to 20 creditors.
|
How fast will my savings account grow?. Set up a simple savings plan and estimate the interest earned in your savings account over time.
|
These free calendars are .PDF files that can be downloaded and printed. Print in color, or black and white. |
Create and print your own photo calendar. |
Class schedules, weekly schedules, work schedules, and shift schedules. Free daily, weekly, and monthly planners. |
A collection of templates that let you create a full-year calendar for almost any year.
|
Professional data visualization and business intelligence tools. Learn how to create concise reports with visually appealing charts and graphs. |
In-cell sparklines, bar charts  , mini pie charts  , bullet graphs  , and whisker graphs  (i.e. win/loss charts) . |
Monte Carlo (MC) simulation is often used in business for risk
and decision analysis, to help make decisions
given uncertainties in market trends, price fluctuations, and
other variable factors. |
Yes, Excel can actually be fun! Download a spirograph or sudoku puzzle grid, and find other games created with Excel. |
WHAT'S NEW
- 2/26/10: New Resume Template and CV Template for Word. Check out the 5 C's of Resume Writing as well.
- 2/17/10: New free Home Equity Line of Credit Calculator.
- 2/11/10: Free Blood Sugar Chart spreadsheet and printable Blood Sugar Log.
- 2/9/10: Free Graph Paper - Excel, Word, and printable PDFs
- 1/29/10: Free Credit Repair Spreadsheet to help you improve your FICO® score.
- 1/26/10: New free Packing Slip template.
- 1/23/10: Printable Moving Checklist.
- 1/20/10: Free Lesson Plan Template for teachers.
- 1/19/10: Free Critical Path Method spreadsheet for project management.
- 1/7/10: Free GPA Calculator for tracking your grades.
- 12/16/09: Printable Receipt Template and PDF forms.
- 12/15/09: New Perpetual Calendar template. In Spanish: Plantilla Calendario. In French: Calendrier
- 12/9/09: New Camping Checklist and Backpacking Checklist.
- 12/3/09: Free New Baby Checklist for getting ready for your new arrival.
- 11/19/09: New Free Gradebook for teachers.
- 11/17/09: New Free Fax Cover Sheet template.
- 10/29/09: Fishbone Diagram Template for Cause and Effect Analysis.
- 10/21/09: Annuity Payment Calculator for retirement calculations
- 10/16/09: Part 1 of Depreciation in Excel: Depreciation Schedule Template, Part 2: MACRS Depreciation Rate, Part 3: Depreciation Calculator.
- 10/14/09: College Savings Calculator - Create a college savings plan.
- 10/13/09: Discount factor table lists formulas for common time value of money conversions.
- 10/7/09: Free NPV Calculator - Learn how to calculate NPV and IRR
- 9/30/09: How to calculate Exponential Growth Rate using Excel formulas or curve fitting.
- 9/23/09: Create a Box Plot in Excel
- 9/15/09: Control Chart Template for Statistical Process Control
- 9/9/09: Free Printable Running Log
- 9/2/09: Free Organizational Chart Template.
- 8/17/09: Profit and Loss Template (3-year projection)
- 8/14/09: Business Budget Template
- 8/12/09: Create your own Photo Calendars
- 7/27/09: Attendance Record template for clubs, meetings, church and sunday school classes.
- 7/21/09: Free Sign Up Sheets for Potlucks, Volunteer sign-ups, etc.
- 7/15/09: How to Create a Dot Plot in Excel.
- 6/26/09: Free Exercise Log and Free Workout Log
- 6/23/09: Free Workout Chart for creating a weekly weight lifting program.
- 6/18/09: Free Exercise Chart
- 6/3/09: Free Sign In Sheets for meetings, patient appointments, visitor sign in / sign out, etc.
- 5/19/09: Create a Pareto Chart in Excel.
- 5/15/09: Vacation Accrual and Tracking template for employees and HR.
- 4/23/09: New Break Even Analysis Calculator for analyzing new ventures or products.
- 4/22/09: Free printable Monthly Planner template.
- 4/16/09: Free Meal Planner template and printable menu planners.
- 4/13/09: Printable weekly planner template.
- 3/31/09: Billing Statement Template that can double as an accounts receivable ledger for invoice tracking.
- 3/20/09: Expense Tracking template.
- 3/11/09: Invoicing article and a Weight Loss Chart template.
- 2/26/09: Calendars for Blogs, holiday calendar, and other ideas for Embedding Google Spreadsheets in Your Blog.
- 2/24/09: Created a printable grocery list template.
- 2/11/09-2/13/09: New Interest-Only Loan Calculator, Ideal Weight Chart and Calculator and Body Mass Index (BMI) Chart for Excel and in PDF format.
- 1/15/09: Printable daily planner template.
- 12/17/08: New articles: How to Make a Budget and How to Budget
- 11/13/08: Articles on Simple Interest and Negative Amortization, and a brand new Simple Interest Loan Calculator. Updated Amortization Chart template.
- 10/28/08: Added a Net Worth Calculator for Excel.
- 10/8/08: Created Financial Statement Templates, including a Balance Sheet template, Income Statement template, and Statement of Cash Flows.
- 8/12/08: Printable daily Food Log for keeping track of your calorie and water intake.
- 7/16/08: Many of the Vertex42 spreadsheet templates are now available in the new Google Docs Template Gallery.
- 4/30/08: Loan Calculator
- 4/23/08: Expense Report Template
- 4/22/08: Timesheets and a Timecard template
- 4/21/08: To Do List Template
- 4/19/08: Service Invoice and Sales Invoice and Purchase Order Template
- New Budget Spreadsheets :: We've created 4 new budget spreadsheets: Personal Monthly Budget | Personal Yearly Budget | Household Monthly Budget | Family Budget Planner
- Shift Schedule Template :: Organize your employee work assignments.
- Savings Interest Calculator :: Estimate interest earned in your savings account, with optional monthly or annual deposits.
- 401(k) Savings Calculator :: Estimate your future 401k balance, taking into account your employer match, annual raises, etc.
- Wedding Budget and Wedding Checklist :: These two new templates provide a comprehensive list of items to consider for wedding planning.
- Gas Mileage Log & Calculator :: Print a mileage log to keep in your car, and use the mileage calculator to create a mileage chart to track your car's performance over time.
- Debt Reduction Snowball Calculator :: Use the debt snowball strategy to pay off your credit cards, student loans, and other debts as soon as possible. Creates a printable payment schedule.
- Mortgage Calculator :: A feature-packed mortgage calculator for fixed or adjustable rate mortgages, with extra payment options.
- Home Equity Loan Calculator :: Three home equity calculators for (1) creating a payment schedule for a fixed-rate loan, (2) estimating how much money you can borrow, and (3) estimating how much equity you will have in your home X years from now.
- Credit Card Payoff Calculator :: If I make a monthly payment of $X.XX, how long will it take to pay off a credit card at the current interest rate?
- Free Canadian Mortgage Calculator :: Finally, an Excel spreadsheet designed specifically for Canada mortgage calculations.
- Free Auto Loan Payment Calculator :: Calculate the cost of purchasing a car or truck, create an auto loan amortization table, and analyze different loans to see the effect on the monthly payment and total interest.
- Free Printable Calendars :: Visit our new Calendar Nexus. This section of our website is THE place to download free calendars in a variety of colors and formats.
- Home Budget Worksheet :: A free spreadsheet for planning your family, personal, and home budget, plus a list of printable budget worksheets in pdf format.
- Excel Gantt Chart Template :: A free spreadsheet for creating simple project schedules and timelines.
- Loan Amortization Calculator :: This handy loan calculator is web-based, so you don't need to own Excel to use it. It was converted from some of the loan spreadsheets on this website. (6/10/2006)
- Retirement Planning Spreadsheet :: Estimate the value of an annuity at retirement. Compare total payments to interest earned. Run simulations with random annual interest rates and a variable number of annual payments. (12/13/2005)
- Stock Quotes in Excel :: This page provides a Stock Quote web query template and explains how to use the MSN Money Stock Quote Add-in to download free stock quotes into Excel.(12/6/2005)
- How to Create a Timeline in Excel :: A tutorial showing a new way of creating timeline using an XY chart with error bars as leader lines. (9/2/05)
- Adjustable Rate Mortgages: ARM Calculator :: Estimate monthly payments for 10/1, 7/1, 5/1, and 3/1 ARM loans. (6/4/05)
- Amortization Schedule (with optional extra payments) :: Yet another spreadsheet related to loans and mortgages. This one allows optional extra payments and includes rounding to nearest cent. (4/9/05)
- Extra Payment Mortgage Calculator :: A spreadsheet for calculating the amount of interest expense saved when making additional mortgage payments. (4/6/05)
- Balloon Loan Calculator :: Download a free loan calculator spreadsheet that creates a payment and amortization schedule for a balloon loan. (3/24/05)
|
|
Loading Vertex42's Latest Excel Tip 
