MS Excel Spreadsheets
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
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.
Features
- 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
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
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)
ExcelSmartTools
$50.00
ExcelSmartTools was developed during the last months, and adds news features or upgrades existing features to Microsoft Excel. Because actual spreadsheets software, namely Microsoft Excel, are very powerful and complete software, it was hard to find significant areas of improvement. Thanks to many source of ideas, it was possible to design and develop an Add-In that improves and reduces very time consuming operations, and is now part of my Microsoft Excel spreadsheet.
MS Excel 97 or later
More
Info
ExcelSmartTools DataClean $35.00
ExcelSmartTools DataClean is developed for helping users to edit, to correct and to clean spreadsheets, lists and reports importers from ERP (for instance AS400), web sites, and from other software packages.
MS Excel 97 or later
FormulaManager + free Excel Download Package ($12.95) + free File Size Reducer for Excel
$29.95
Free 30 Day Money Back Guarantee
The Formula Manager is designed to make the managing of all formulas a breeze. It can be used to map your spreadsheet by formula type. You can format the background color of all formulas that match the criteria you set. It a can also format the font of all formulas that match any criteria you set. Once applied, you can tell at a glance which cells contain formulas and which do not.
When you have a spreadsheet that contains formulas, you want to be sure that no user can delete, over-write or modify them. The Formula Manager can do this for you in seconds! Just specify which formula types to Lock, Hide or Lock and Hide. You can even protect the sheet in the same step! You can also easily Lock or Unlock all cells in one click.
Excel 97/2000/XP and Windows
Text Manager + free Excel Download Package ($12.95) + free File Size Reducer for Excel
$29.95
Free 30 Day Money Back Guarantee
The Text Manager will make working with text in your spreadsheet very easy. It is particularly useful for text which has been imported into Excel. You specify the range to affect, this can be specified cells or the entire sheet.
The Change Case lets you instantly change the case of your text. You can nominate to change your text to all UPPER CASE, all lower case, or Proper Case.
The Remove Character or Text can save you many hours of manually removing specific characters, or text, from specified text. You can even copy the characters to remove directly from the Windows Character Map. If the character or text you wish to remove is not available, simply check the Specify Character or Text option.
Excel 97/2000/XP and Windows
Formula & Text Manager + free Excel Download Package ($12.95) + free File Size Reducer for Excel
Savings!
$59.90
$39.95
Free 30 Day Money Back Guarantee
Please see The Formula Manager and The Text Manager above.
Excel 97/2000/XP and Windows
AnalyzerXL
$99.95
Free 30 Day Money Back Guarantee
Technical Analysis in Microsoft Excel. 146 indicators and experts. Free download real and historical stock quotes from USA, Europe, and Canada into Excel spreadsheets. Mutual funds, corporate bonds, Major USA Market Indices, Major World Indices are downloadable into Microsoft Excel spreadsheets. Daily, weekly and monthly quotes into one Excel spreadsheets. Quotes refresh. The best way to start technical Analysis for the beginner.
JEM Plus
$49.95
JEM Plus is an unbelievable product that will boost productivity and take data integrity to new heights. This is a must-have software for individuals that work with Microsoft Excel. Gain greater control and speed when managing and manipulating spreadsheets . Contains over 40 robust utilities, 207 additional worksheet functions (mostly financial), and a wonderful help file with detailed explanations. JEM Plus provides professionals and everyday users the power to get the most out of their Microsoft Excel spreadsheets. JEM Plus integrates seamlessly with your existing Excel spreadsheets. Experience the smarter way to work. JEM Plus makes great software better.
System Requirements Software: Microsoft Excel 97/2000/2003/XP OS: Windows 9x/ME/NT/2000/2003/XP
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
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
Spreadsheet xlNavigator 2003 TM
Spreadsheet XlNavigator is a neat Excel add-on that lets you see the relationship of formula cells in your complex workbooks. Have you ever wished for an easy, flow-chart view of a complex spreadsheet so that you could immediately identify precedent and dependent cells? Now you can with XlNavigator. Simply highlight the cells or sheets you want to view and instantly see a chart depicting which cells feed data to which other cells. A zoom feature lets you focus on the area of interest and a global view lets you move a small highlight frame to wherever you wish. Spreadsheet XlNavigator is easy to use and you'll appreciate the insight into your workbooks. Key Benefits Navigate the spreadsheet using cell precedent-dependent representation. Flow chart representation emphasizes calculation order. Direct link between xlNavigator representation and Excel spreadsheet cells. Visual representation makes troubleshooting complex spreadsheets much easier.
The Spreadsheet XlNavigator 2003 version replaces
the 2002, and 2000 versions. Many new features such as
edge navigation, ability to resize the form have been
added.
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!
Prev 2(2)
MS Excel Topics
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.