Excel Templates
> Invoice
> Mortgage
Free Calculators
Vertex42 Articles
Microsoft Excel® connects the worlds of business, finance, marketing, engineering, math, statistics, and academics. If you use or create spreadsheets, odds are that you use Excel. In addition to sponsoring the Excel Nexus, Vertex42 provides templates, tutorials, and articles to help increase your productivity while taking advantage of the power and popularity of spreadsheets.
Over 2 Million Excel spreadsheets downloaded since 2003!
Financial CalculatorsDownload a free Excel-based financial calculators and templates.
|
Free CalendarsPrintable calendars, calendar templates, blank calendars. Monthly, yearly, and weekly.
|
Timesheet TemplatesEmployee time tracking and expense reporting is a popular use for Excel. Download our free timesheet template. |
Monte Carlo SimulationMonte 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. |
BudgetsCheck out our collection of family, home, and personal budget templates. |
Fun & GamesYes, Excel can actually be fun! Download a spirograph or sudoku puzzle grid, and find other games created with Excel. |
Dashboard ReportsProfessional data visualization and business intelligence tools. Learn how to create concise reports with visually appealing charts and graphs. |
Create Sparklines in ExcelIn-cell sparklines, bar charts , mini pie charts  , bullet graphs  , and whisker graphs  (i.e. win/loss charts) . |
Main Excel Portal Pages: New Excel Links, Most Popular Excel Links, Vertex42 Picks
What's New at Vertex42?
- 4/30/08: New Loan Calculator
- 4/23/08: New Expense Report Template
- 4/22/08: New Timesheets and a Timecard Template
- 4/21/08: New To Do List Template
- 4/19/08: New 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 CalculatorThree 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 CalculatorIf 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 CalculatorFinally, an Excel spreadsheet designed specifically for Canada mortgage calculations.
- Free Auto Loan Payment CalculatorCalculate 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 CalendarsVisit 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 WorksheetA free spreadsheet for planning your family, personal, and home budget, plus a list of printable budget worksheets in pdf format.
- Excel Gantt Chart TemplateA free spreadsheet for creating simple project schedules and timelines.
- Excel 2007 Nexus
Have you tried the new Excel 2007? It is such a wildly different product, we've added a branch to the Excel Nexus specifically for Excel 2007. (8/12/2006)
- 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 SpreadsheetEstimate 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 ExcelA 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)
- Loan 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)
- Excel Yearly Calendar
Download a free yearly calendar template for Excel. This is the latest in our line of Calendar and Scheduling templates. (10/5/04)
- Weekly Work Schedule TemplateUnlike most of the stuff on this site, this one isn't free, but it definitely isn't expensive, either. It is similar to the class schedule template, but with some additional bells and whistles. (8/16/04)
- Microsoft Excel Solver Add-In ExamplesThe Microsoft Excel solver add-in is one of the features that makes engineering and financial spreadsheet models powerful. To be called a "solver" doesn't do it justice, though, because it is really a useful optimization algorithm.
- Excel in KinematicsExcel tutorials and templates that I used for a course on Kinematics (Design of Machinery). (8/31/05)