PC MS Excel Add-ins, VBA Code for Your Business and Home
OzGrid Plus and Duplication Manager+ free Excel Download Package ($12.95) + free File Size Reducer for Excel
Savings! $59.90
$39.95
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.
Excel Duplication Manager Add-in:
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 and remove duplicate lines from a
table.
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.
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.
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
Time Wage and Paybook
OzGrid Add-in Collection
Excel 97/2000/XP and Windows
COMxL RS232C
COMxL RS232C is an
ease-to-use and very-helpful Add-Ons/Add-Ins for MS
Excel 97/2000 's user. It lets you link your instrument
to your any Excel worksheet directly via RS232 port.
The readings from instrument can go/fill-in anywhere
you want to them to go by just simply highlighting the
range. The moving direction of fill-in Data can be
selected (top-down or left-to-right).
Key features:
* Import instrument's DATA via RS232C port to MS Excel
worksheet.
* Ease to setup for instrument with RS232C port and
use.
* Date&Time stamping .
* Send ASCII command to instrument to download its
DATA.
* Timer sampling for DATA input.
* Pop-up message for Upper/Lower Limits warning.
* Send a set of commands from File "CmmdsListFile.txt"
to instrument.
* Send Command from clipboard to instrument or other
computer.
* Send Text in the clipboard to instrument or other
computer.
* Commands list and Upper/Lower Limits list
available. $59.00
EldoS AutoSaveXL
EldoS AutoSaveXL is an
add-in for MS Excel 2000 and MX Excel XP that is used
to automatically save the files periodically. It is a
replacement for built-in autosave feature, however
AutoSaveXL doesn't ask for confirmation and creates any
number of backup files not spoiling an original
version.
$9.95
Real Option Valuation
The Real Option Valuation model encompasses a suite of option pricing tools to quantify the embedded strategic value for a range of investment scenarios. Traditional discounted cash flow investment analysis will only accept an investment if the returns on the project exceed the hurdle rate. While this is a worthwhile exercise, it fails to consider the myriad of strategic options that are associated with many investments. This model provides the ability to identify what options might exist in your proposal and the tools to estimate the quantification of them.
The key features of the Real Option Valuation model include:
Ease and flexibility of input, with embedded help prompts.
Informative 'Quick Start' menu for choosing the correct tool for the situation.
Modified Black Scholes models to value the options to delay, expand, or abandon investments.
Automatic binomial 'tree' builder model to evaluate complex strategic options with multiple stages.
Nash equilibrium Game Theory model to evaluate market entry strategies in a competitive environment.
Ability to predefine historical investment and/or industry risk profiles to utilize across models.
(Requires Microsoft Excel 97 or above)
Note for Excel 2002 users: This model invokes the Solver.xla add-in within the VBA code. This may cause a compile error when opening the model in Excel 2002 (XP). $26.00
Advanced Excel Find
Awards:5 Stars
If you are not satisfied
with the Excel's built-in Find where you have to make
numerous clicks to find the information needed, the
Advanced Excel Find can serve all your needs.
It enhances Excel's built-in Find and makes search
through multiple worksheets and workbooks in Excel fast
easy and comfortable. The whole thing takes you just a
few seconds and a couple of clicks.
The Advanced Excel Find has all features of the
Excel's built-in Find and besides you have the
advantages of simultaneous search in values, formulas
and comments; search in all or selected worksheets and
workbooks at the same time; multiple selections of the
found items...
One click and you can move freely around search
results, select the items of interest and just continue
you work.
The Advanced Excel Find is an add-in designed for MS
Excel 2000 and MS Excel XP and adds no new workbooks or
VBA macros.
Excel Typos Finder
Awards:5 Stars
Aren't you sick and tired of typos in your spreadsheets?
It is a specially designed
tool to help you polish off all typos in your Excel
workbook.
The Typos Finder is an add-in for Microsoft Excel 2000
and 2002 that:
• Searches for fuzzy duplicates and quickly
finds values containing one to four typos
• Recognizes lost symbols, inserted symbols
and misprinted symbols
• Searches for typos inside the selected
range or inside the current column of the current
list
• Shows all found typos in the convenient
typos list
• Allows correcting typos by ONE CLICK
ONLY
• It can easily handle over 65,000 rows
Kill typos in your workbooks!
Merge Assistant for Microsoft Excel $24.95 More Info
The Merge Assistant is an add-in for Microsoft Excel that will combine entries in multiple cells into one cell.
Prev 1(2)
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.
MS Excel Topics