MS Excel Add-ins, Spreadsheets, Workbooks, Templates, VBA Code for Your Business and Home
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
$189.00
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.
The Complete Excel Training Bible
The Complete Excel Training Bible: Courses101-201-301-401A–501 -601 & 701.
Complete training in all aspects of Excel applications with spreadsheet examples.
With these nine Add ins for Microsoft Excel you will enhance your Excel with added capabilities that are well beyond the standard Microsoft Excel program:
- 1.NEW FORMULA MANAGER
- 2.NEW POWER-PLUS MANAGER
- 3.NEW DUPLICATION MANAGER
- 4.NEW NUMBER MANAGER
- 5.NEW TEXT MANAGER
- 6.NEW RANGE MANAGER
- 7.NEW FORMULA REFERENCE CHANGER
- 8.NEW SHEET INDEX CREATOR
- 9.NEW EXCEL FILE SIZE REDUCER
The Complete Excel Training Bible & Excel Add-ins Collection
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.95
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
$29.95
Retrieve and show classic menus and toolbars again in Microsoft Office 2007 (include Access, Excel, Outlook, PowerPoint and Word), seems as Office 2003.
$15.99
Retrieve and show classic menus and toolbars again in Microsoft Excel 2007, look like the Excel 2003. You could not see the classic main menu and toolbars in Excel 2007, because they are disappeared and replaced by ribbon.
$39.95
Likeoffice Excel Utility Pro designed to ease your work using Microsoft Excel
EasyProjectPlan (Excel Project Plan)
$120.00
Easy Project Plan© solves ALL of the above issues using an easy-to-use Excel template.
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
Excel Spreadsheet Auditor
$79.95
Excel Spreadsheet Auditor is an Excel add-in which enables you to view formulas in a different, friendlier manner. Excel Spreadsheet Auditor shows all origin links which may exist between formulas of a selected range. Also it shows any and all dependence links which may exist between formulas of a selected range.
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