|
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!
Download a free Excel-based financial calculators and templates.
|
Printable calendars, calendar templates, blank calendars. Monthly, yearly, and weekly.
|
Employee time tracking and expense reporting is a popular use for Excel. Download our free timesheet template. |
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. |
Check out our collection of family, home, and personal budget templates. |
Yes, Excel can actually be fun! Download a spirograph or sudoku puzzle grid, and find other games created with Excel. |
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) . |
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
- 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.
- 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 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)
- 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 Template
Unlike 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 Examples
The 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 Kinematics
Excel tutorials and templates that I used for a course on Kinematics (Design of Machinery). (8/31/05)
|