MS Excel Add-ins, Spreadsheets, Workbooks, Templates
Buy OfficeReady Professional 3.0 – over 500 templates for Microsoft Office + PDF creation. Click Here
You can find below MS Excel add-ins, MS Excel Spreadsheets, and MS Excel Templates, MS Excel Workbooks, VBA Code for Excel for your business & home.
Please click on an Excel topic above or see the full Microsoft Excel add-ins, spreadsheets, workbooks, and templates list below.
Free 30 Day Money Back Guarantee
$229.95
All Programs
supplies:
Investment-Calc PRO for NPV & IRR
calculations.
Cash Flow templates
10 Year financial plan templates (balance sheets,
income, cash flows and ratios_ Financial ratios for 2
and 5 periods.
Loans Amortization Manager
CheckMy Loans 2000
Budget Templates
Costing templates
Valuation templates
Buy To Rent NPV & IRR templates
Asset Register PRO templates
OS : Windows 95, 98, ME, 2000/2003 or XP & MS Office or Excel 97 or later.
Asset Register PRO for
Excel supplies nine asset registers plus YTD
depreciation reports for fixed, intangible and
investment assets, updating and reporting depreciation
calculations and book values at each month end. Each
asset entered into the register can contain the asset
sequence number, date of purchase, description of
asset, serial number, supplier's name, purchase order
number, G/L reference code, accounting cost, useful
life (depreciation period), physical location, plus
if/when disposed/sold and gain/loss calculations and
impairment ledgers for investments, intangibles and
goodwill. Asset Register PRO can be used
by the smallest to the largest enterprise to keep
track of their assets and monthly depreciation
calculations. Asset Register PRO applies the
straight-line depreciation method, and the declining
balance method adjusted annually and monthly.
Depreciation tables supply monthly depreciation and
cumulative depreciation from the acquired date to any
period up to 240 months.
Quick and easy entry of
assets into the registers using Excel's Data (Entry)
> Form with the Name box.
Asset Register PRO provides continuous month end
sequencing so that the asset class registers update
each asset depreciation and book value every month
automatically and combines all month end values into a
Year To Date and Totals report. Different depreciation
periods can be applied to individual assets and within
each class of assets.
Asset Register PRO calculates book values at disposal
dates and gain/losses on disposal.
All month end depreciation calculations and book
balances can be recalculated backwards and forwards to
any month end date by making a simple one step
adjustment to the month end date held in the adate
field. You can recalculate and forecast depreciation
totals and written down balances for any month end past
or future. Such calculations can be very useful for
preparing financial business forecasts and for checking
depreciation calculations.
Provides asset confirmation fields for audit
purposes. $139.95
Free 30 Day Money Back Guarantee
Excel 97 & 2000
OS : Windows 9x, Me, NT, 2000, XP
Investment-Calc PRO For Cash Flow Analysis $169.95
Free 30 Day Money Back Guarantee
Investment-Calc PRO 2002
for cash flow analysis provides 18 ready to use Excel
worksheets for quick calculation of after tax
discounted cash flow, net present values, internal rate
of return (IRR), and return on investment (ROI).
Provides monthly and yearly cash flow discount factors
using prepared tables and easy to use financial
models.
Includes project and company valuation using DCF,
economic value added calculations, profit/loss, EBIT
and free cash flows.
$125.00
Free 30 Day Money Back Guarantee
Investment-Calc 2002 PRO
Version 6.0 for Excel.
Top of the popularity list of single software
purchases for ten months in succession, Investment-Calc
PRO provides managers and investors with quick and
simple tools to calculate NPV, DCF, IRR, EVA and ROI
for any capital investment using ready made
spreadsheets which automate calculations for projects
financed with leases and loans, and supply annual
interest, depreciation and tax values. Includes new
sensitivity analysis tables, which allow users to keep
their original forecasts while varying their
assumptions for instant recalculations of NPV and IRR
forecasts under any combination of key variables.
New version 6.0 includes new additional workbooks for
calculating the internal rate of return of any
irregular cash outflows/inflows forecast over 60 months
or 50 years. Version 6.0 also incorporates a new simple
list way of creating cash flow forecasts, which speeds
up calculations and reduces work time.
You can create and manipulate cash flow worksheets
with ready to use forms for capital purchases, loan and
lease financing options and incremental working capital
forecasts to calculate NPV/ROI, EBIT, free cash flow
and accounting rate of returns. Annual asset
depreciation calculations and loan repayment values are
extracted from pre-programmed tables. From the program
library you can quickly check the capital efficiency of
an asset financed by a lease or loan, produce NPV
calculations based on monthly income and expense
forecasts for up to 30 years x 12 monthly periods, set
up quick 30 year models of income (or recaptured costs)
projected from new capital investment incorporating
working capital, taxes, depreciation plus additional
capital investments if required during the project
term, to calculate discounted cash flows, NPV and IRR.
Includes ready made compounding templates for
calculating investment deposit interest compounded on a
daily
basis for any time period, any interest rate,
incorporating variable deposits and withdrawals on
irregular dates, plus yearly compounding tables
calculating the amount of investment required today to
replace asset prices in the future, and use the program
to calculate the NPV of a company's forecast cash flows
over any period up to 20 years to calculate business
per share valuations.
This is currently our most popular program used by
owners, investors, managers, law firms, and
accountants. Create and manipulate cash flow worksheets
to analyse company acquisitions, capital investments,
lease purchases, using combinations of term
loan/capital lease financing, plus calculate daily
compound deposit interest and optimise capital
budgeting to maximise returns. Plenty of help notes and
directions are included together with Excel Solver
equations to solve capital allocation optimisation
problems.
FASTPLAN PRO $169
Free 30 Day Money Back Guarantee
FASTPLAN 2001 provides an
integrated suite of spreadsheets for Excel 97 &
2000 which build monthly business plans for any period
up to 5 years and calculates 5 year balance sheets,
income statement and cash flow forecasts. Monthly build
up provides product unit sales forecasting, price
variations, and cost of sales assumptions.
Risk analysis feature recalculates financial forecasts
for any change in revenue assumptions.
FastPlan PRO Version 3.0 provides fast track compilation of 5-year financial plans for a single business to plug straight into your business plans for presentations to venture capital sources, investors, banks, or for company planning purposes. Version 4.0 combines multiple FastPlan PRO Excel workbooks into one consolidated five year balance sheets, income statements and cash flow statements for a group of companies or budgets. Incorporate federal and state income tax calculations. More Info
Financial Ratios For Business Performance Measures
Awards : 5 Stars
Calculate Financial Ratios Using WINDEX (5) For
Excel.
Windex (5) provides a family of five prepared Excel
worksheets for setting up five year balance sheets,
income statements and cash flow reports from which
Windex calculates all fifty key financial ratios
together with messages alerting you to the significance
of period to period changes. You can use just one set
of financial data inputs to calculate one period
ratios. Each ratio is fully explained with all
equations listed. $125.00
Free 30 Day Money Back Guarantee
Master Budgets PRO For Excel (All Versions)
$125
Master Budgets PRO
consolidates 10 individual budgets into one Master
Budget and monthly actual reports into one consolidated
Master Report with year to date summaries and
adjustable reporting time frames.
The Master Budget consolidates up to 10 individual
budgets into a full year total budget.
Profit Center/Departmental
Budgets provide each department or profit center with a
12 month budget. Master Budgets PRO supplies 10 profit
center/departmental budget worksheets, with up to 31
revenue items and 100 expense categories, plus cost of
sale budgeting table and operating profit margin
calculations.
Monthly Reports provide each profit center/department
enters with a report worksheet for actual monthly
results.
Presents monthly differences for each income and/or
expense item from budget and percentage differences
above or below budget.
The Master Report consolidates individual monthly
reports into year-to-date totals for the business as a
whole.
Smart functions provided by Excel make your monthly
budgeting run really smoothly. You can run the monthly
clock backwards in the Master (year-to-date) Report to
review consolidated figures standing at any previous
month end or forwards to target the gap between YTD
budget and actual results ahead.
Free 30 Day Money Back Guarantee
EasyProjectPlan (Excel Project Plan)
$120.00
Easy Project Plan© solves ALL of the above issues using an easy-to-use Excel template
$149.00
The Shift Schedules Excel spreadsheet automatically assigns up to 500 people to up to 20 shifts per day in response to your scheduling needs and your employee's preferences and qualifications while enforcing rest times between shifts.
Easy Hours Scheduler with Excel
Use the S15-Easy Hours Scheduler to assign daily hours to 3 groups of employees each day for 4 weeks.
Requires Excel 97 or later.
QuickValue PRO $99.00
Awards: 5 Stars
Calculate Business & Share Valuations with QuickValue 2002 and Excel.
Compute the net worth of any business large or small to your chosen forecast horizon 5-20 years ahead with five integrated Excel worksheets in QuickValue 2002. The first Quick Valuation spreadsheet values any asset producing cash flow by calculating net present values per share 5 years to 20 years ahead. QuickValue also supplies five-year balance sheets and income statements which are used to calculate your five year cash flows which then supply instant calculations of annual Operating Cash Flows/Share, EBIT/Share, annual per share values, Economic Value Added/Share, and 5 year Net Assets/Share together with Net Present Values per Share and annualized growth rates of shareholder returns over the 5-year period. Maximise your business future and its net worth with QuickValue 2002. Version 2.0 contains CONVERT which converts any 5-10-15 year profit forecast to a valuation using free cash flow calculations plus Net Present Valuations, together with an extra spreadsheet that calculates buyers rate of return from any business acquisition.
Free 30 Day Money Back Guarantee
Rainbow Analyst Professional
$199.00
Rainbow Analyst Professional uses color to map the structure of Excel spreadsheets, so that you can quickly pick out potential problems and errors.
Platform: Windows 98 or later.
NPV & IRR/MIRR Excel Templates
$67.00
NPV & IRR/MIRR calculations for regular periods (for example for annual receipts and investments) and for a schedule that is not necessarily periodic.
Requires Excel 97 or later.
Spreadsheet Consolidator for Excel
$69.95
Spreadsheet Consolidator is an add-in for Microsoft Excel which will allow you to consolidate spreadsheet data from one or several sheets from one or many open workbooks, easily and quickly.
Requires Excel 2000 or later.
Program features
-
Ability to recover Microsoft Excel 6.0 / 95 / 97 / 2000 / XP / 2003 documents
-
Ability to recover deleted and overwritten documents
-
Ability to recover corrupted documents from entire disk instead of retrieving data from a single file that allows to recover data even in the most desperate cases
Tools for Excel Tables
Tools for Excel Tables is
an addin that combines the functionalities of Microsoft
Excel in order to create more robust functionalities
which let you extracting multiple conditional data,
splitting tables, smart consolidation, merging tables,
categorizing databases, extracting unique records,
stratifying data and much more...
It is an priceless, time saving tool for accountants,
auditors, financial and data analysts. Specialists in:
fraud detection, financial management, information
system monitoring, and any other data analysis and
manipulation activity that involves the use of data
bases or large tables in Excel spreadsheets.
Requires Excel 97 or later.
Excel Model Builder
With Excel Model Builder you can perform fast and accurately repetitive and time consuming tasks, such as transposing linked formulas, if formulas, consolidating sheets, swapping data, etc.
Requires Excel 97 or later.
Automate Faster Your Office with VBA Code
$149.00
Create better VBA code faster! For Microsoft® Access, Microsoft® Excel, Microsoft® Word, Microsoft® Outlook and other Microsoft Office applications.
Microsoft Office 97 or later
The Spheresoft Modeler
The Spheresoft Modeler allows users to enter a value and multiple formulas into each cell of Microsoft Excel, and it permits circular references, making for spreadsheet models that are much more compact and easier to use.
Microsoft SQL/Analysis Services - o2olap for Excel
$850.00
Free 30 Day Money Back Guarantee
Microsoft Analysis Services (OLAP) and SQL Server are outstanding products but lack some key capabilities for finance and analyst users such as spreadsheet modelling, freeform reports and writeback. O2OLAP for Excel overcomes these limitations, allowing users to take advantage of the inherent architectural and commodity cost benefits of Microsoft technologies. New market leading functionality enables users to create executive information systems (EIS) without having to write or support a macro.
Microsoft Office 2000/XP/2003
MITCalc
Mechanical, Industrial and Technical Calculations for Excel
$49.00
Are you a mechanical engineer, design engineer, engineering draughtsman, technical employee, or a student at a college? Do you need to work with a professional computational system? But you are not willing or cannot pay thousands of dollars for inadequately complex or incomprehensible solutions? Then you may just need MITCalc.
OzGrid Excel Addins Collection + free Excel Download Package ($12.95) + free File Size Reducer for Excel
Savings!
$174.00 $69.95
Free 30 Day Money Back Guarantee
Formula
Report Generator. Allows you to very easily create a
report showing formulas within your Workbook that are
either external references, internal references or
both. You can also nominate which Worksheet(s) to use
to base your report on. Dynamic Range Namer. This will
allow you to very quickly and easily create any one of
eight different types of dynamic ranges that will
expand down rows or across columns. You can even
nominate the column or row to use as the criteria. It
can also expand automatically each day month or
week.
Real Calendar. This one will create
a live calendar in an instant using real dates, so you
can reference it if needed. The current day is always
highlighted and updates automatically.
Sheet Creator and Sorter. This
option will create any number of pre-named worksheets
which can be Financial Years (1901-2050), Weekdays
(Monday-Sunday), Months (January-December), Years
(1901-2050), Quarters (Quart1-Quart4), Days
(Day1-Day1460) and Weeks (Week1-Week208). It also has
an option that allows you to Sort (ascending or
descending) any Worksheets in any Workbook.
A Random Number Generator. This can
produce up to 1000 non repeating random numbers that
meet a criteria you specify.
Conditional Row Deletion. This one
will save many hours of repetitive work when you need
to quickly and easily delete rows in a Worksheet that
meet any criteria. There is an option that allows you
to easily nominate any one of Excels six Error Types,
or all of them. There is also a simple option that
allows you to nominate the criteria.
Duplication Report. Will produce a
statistical table of your data. Including a Count of
occurrences of each item, the total number of
duplicates and a total of all entries. It will also
produce a list of your data containing only unique
entries. Better than a Pivot Table in a single
click.
Do On Time. This feature allows you
to run a macro (recorded or written) at a set time,
display a personal message or reminder at a specified
time or even open a nominated Workbook at a set
time.
Formula Reference Changer. This
handy little Excel Add-in can very quickly change
thousands of formula references to your specified type.
It has 3 levels of areas to effect:
Selection only;
Entire Active Sheet;
Entire Workbook.
Sheet Index Creator. Have a
workbook with a large number of Worksheets? Find it
hard and too time consuming navigating through all the
sheets? This option allows you to easily create an
Index Sheet that has click-able links to all sheets. It
also has the option of placing a "Back to Index" link
on all the sheets.
Duplication Manager. This very
handy add-in will make your management of lists a
breeze. It is designed to assist you when you have
duplicates in 1 or more lists. You can create a list of
uniques, hide all duplicates, create a summary report,
color code all duplicates, up to 3 levels and even
prevent users from adding duplicates to a list or
table! There is also the option to compare 2 lists for
matching entries.
File Size Reducer. It's a common
problem with Excel Workbooks to increase in size
unrealistically, even after you think you have cleared
out all the data. The File Size Reducer has become
extremely popular as it can reduce unrealistic file
size by 50% or more! All you need to do is install the
add-in and click the button.
Excel 97/2000/XP and Windows
Excel Scheduler
Free 30 Day Money Back Guarantee
Project Management, Gantt Charting, and Employee Scheduling.
For all versions of Microsoft Excel.
To run Excel Scheduler, simply run Excel and read in template(s) of choice.
Project Management:
CPMDAILY.XLS
CPMHOUR.XLS
CPMWEEK.XLS
Gantt Charting
GANTDAY.XLS
GANTHOUR.XLS
GANTWEEK.XLS
Employee Scheduling
DAYSOFF.XLS
Shift Scheduler Continuous Excel
$68.00
The Shift Scheduler will
build a roster structure to your specifications,
allocate staff automatically, and generate a printable
roster, all at the click of a button. It is compact and
user friendly allowing you to add staff and shifts
(maximum 150) with ease. Default values for continuous
shifts mean that the only shift data required is the
start date/time and length for the first shift,
everything else is automated. For non-continuous or
varying shifts you have the capacity to overwrite
default data and structure shift settings to suit your
specific requirements.
Constraints you can apply when allocating staff
include the maximum hours a staff member can work
within the roster period, the maximum continuous work
hours, the minimum break between shifts, and the
maximum number of days in a row that can be worked. You
can also set a Yes or No work status to define a must
work or must not work requirement. Your roster is
printed using standard Excel commands or using the
Format Print function to build a compact and easy to
read roster schedule table. The Next Roster function
allows you to roll roster details into the next roster
period to quickly build consecutive rosters.
Operational instructions are provided as convenient
mouse over comments.
Free 30 Day Money Back Guarantee
ZRandom
$29.95
ZRandom implements high
quality random number generation for Microsoft Excel
using the Merssenne Twister algorithm :
* Use higher quality pseudo-random numbers than the
Excel RAND() and VBA Rnd() functions.
* Generate random numbers from 16 discrete and
continuous distributions. ZRandom implements the
following discrete distributions: Uniform, Bernoulli,
Geometric, Hypergeometric, Negative Binomial and
Poisson. ZRandom implements the following continuous
distributions: Beta, Burr, Exponential, Gamma,
Lognormal, Normal, Pareto, Triangular, Uniform and
Weibull.
* Create large batches of random numbers using the
interactive user interface.
* Excel functions for use in spreadsheet
formulas.
* Random Sort and Random Sample
* Interactive distribution wizard
* A VBA interface to generate random numbers in your
code.
Excel 97 or above
Annotator for Microsoft Office $17.95
Interact with your familiar
Microsoft Office (97/2000/XP/2003) in new ways and
change your Office experience by using the pen/tablet
and the inking capabilities of Meanders' Annotator
to:
Review, comment, markup Office documents, draw and
annotate tables, charts, diagrams, etc directly with
your handwriting inside Microsoft Word, Microsoft Excel
and Microsoft PowerPoint.
Comment directly on Microsoft Excel worksheets when
reviewing data and charts.
Prepare handwritten Microsoft PowerPoint slides for
clearer and faster illustration.
Write and sign handwritten messages in Microsoft
Outlook when using Microsoft Word as your e-mail
editor.
Write anything in any language (Chinese, Japanese,
French, German, etc). Sign a document with a personal
touch.
Make difficult illustrations easy, such as musical
symbols, engineering diagrams like molecular formula or
structural formula in chemistry, complex mathematical
notations or equations, electrical and electronic
circuits and so on.
Fill forms and questionnaires quickly inside Microsoft
Word with digital ink.
Take notes intuitively and smoothly for a meeting.
Alternate typing and handwriting at your will.
Share the documents with others in native Office file
formats without compatibility problems.
Work with both Tablet PCs and normal desktop or laptop
PCs which are installed with mouse or major tablets
from WACOM (Intuos, Graphire, Cintiq, Volito, Favo,
PenPartner, ArtZ, ArtPad, etc), Genius (WizardPen,
NewSketch, EasyPen, etc), Aiptek (HyperPen, etc) and
others.
Teaching and Training with MS Excel
E-books, courses, lessons, tips, tricks, and more
Calendar
for Excel is a Microsoft Excel add-in that creates a
variety of calendars and planners. The spreadsheet
environment is used to quickly generate daily and
weekly planners including task lists with links to a
monthly overview. Professional calendars are
effortlessly produced in one month, six months and
yearly formats.
You need to have MS Excel 97,
2000 or 2002 installed on your computer.
Create a variety of calendars and planners in an Excel
spreadsheet enviroment.
OS: Windows 95/98/NT/2000/XP
Excel-to-MySQL
Excel-to-MySQL is a program to convert MS Excel spreadsheet into MySQL database. Each worksheet becomes a table, each row becomes a record and each cell becomes a field.
- All versions of MS Excel are supported
- Converts individual worksheets
- Merges MS Excel data into an existing MS SQL database
- Converts Comma Separated Values (CSV) files into MS SQL tables
- Easy-to-use wizard-style interface
- Full install/uninstall support
- Windows 2000/XP or Windows NT 4 with Internet Explorer 5 or later or Windows 98/ME or Windows 95 with Internet Explorer 5 or later
- At least 32 MB of available memory
MySQL-to-Excel
MySQL-to-Excel is a program to convert MySQL databases into MS Excel spreadsheet. All MySQL data types are supported. The program has easy-to-use wizard style interface and works with all versions of MySQL servers.
Features
- All MS SQL data types are supported
- Fast conversion engine (20MB MS SQL database - in 1 minute on average P-III system)
- Converts individual tables
- Output spreadsheet is compatible with MS Excel 5.0 and higher
- Easy-to-use wizard-style interface
- Full install/uninstall support
Requirements
- Windows 2000/XP or Windows NT 4 with Internet Explorer 5 or later or Windows 98/ME or Windows 95 with Internet Explorer 5 or later
- At least 32 MB of available memory
- MS SQL environment (server or client components of MS SQL should be installed on the same machine where you run MSSQL-to-Excel from)
Excel Download Package
$12.95
Free 30 Day Money Back Guarantee
This package includes 33 fully accessible Workbook examples that cover topics like, Vlookup,Match,Index,Dfuntions,Advanced Filter,Validation,Conditional Formatting,Custom VBA Functions,VBA Functions,Listbox,Combobox,Working with Excel Menus in VBA,Printing Long List Code,Dynamic Named Ranges and much more!
Also included is "Excel and Excel VBA Tips and Tricks", normally $7.50
This HUGE collection has a Workbook with special tips on Conditional Formatting, Vlookup, Validation, Dynamic Ranges within a range and some slick uses for Checkboxes. There are some links to some excellent Excel software sites that sell Excel software and Add-ins.
The VBA section includes a UDF to Count ,Sum and Sort by color, Generate x non-repeating random numbers between a top and bottom range, Find the specified occurrence matching criteria from two Columns. There are step-by-step instructions on how to add descriptions to UDF's and how to create their category. There is a way to create a dynamic "Sheet Navigator" that is added to the standard right click Pop-up menu. How to create a simple UserForm that is linked to a data table. There is also a page on which VBA function to use when there is no equivalent WorksheetFunction.
Included FREE:
Time Saving Microsoft Excel Soltions:
Time Saving Microsoft Excel Solutions is a downloadable book in a Windows help file format that contains hundreds of solutions to Microsoft Excel problems. You do not need to purchase and it does not expire - it is freeware. Download and use whenever you have the time or need. It is a great way to improve your Excel skills and find time saving Excel solutions.
No special software is needed to use - just download, run ,and open Excel. Access from the Excel Tools menu by clicking on the new menu item. Time savings Excel solutions are always just a click away - you even save time by avoiding fruitless Internet searches!
Free Demos Of:
Duplication Manager Add-in
Formula Ref Sheet Index Add-in
OzGrid Excel Plus Add-in
Time Wage and Paybook
OzGrid Add-in Collection
Excel 97/2000/XP and Windows
Duplication Manager + free Excel Download Package ($12.95) + free File Size Reducer for Excel
$29.95
This very handy add-in will make your management of
lists a breeze. It is designed to assist you when you
have duplicates in 1 or more lists. You can create a
list of uniques, hide all duplicates, create a summary
report, color code all duplicates, up to 3 levels and
even prevent users from adding duplicates to a list or
table! There is also the option to compare 2 lists for
matching entries.
Come with the FREE File Size Reducer:
It's a common problem with Excel Workbooks to increase
in size unrealistically, even after you think you have
cleared out all the data. The File Size Reducer has
become extremely popular as it can reduce unrealistic
file size by 50% or more! All you need to do is install
the add-in and click the button.
Excel 97/2000/XP and Windows
1(6) Next