Freeware Directory

Freeware - Microsoft Office Excel

Four freeware add-ins for Microsoft Excell. Formula Mapper - Graphical representation of formula relationships. Name Box Extender - Increases the width of the ‘name' drop down box. Formula Indenter - Allows formulae to be viewed as little discrete pieces of program code by indenting the formulae using programmer like indentation conventions. Password Remover - Removes worksheet passwords and workbook passwords from Microsoft Excel workbooks.

List all files from any device including directories and subdirectories, perfect for documenting data archives. Shows filename, size, save date & time and path for each file, sort by filename, size, save date & time or path, re-sort anytime. List up to 65,500 files. Export list to new Excel sheet for archival. Secure code signed and time stamped by Thawte, Inc. class 3 certificate.

BMP to XLS converts bitmap images to Microsoft Excel files, just select the bitmap image and click on the "Convert" button, the software will open an instance of Microsoft Excel that will be closed after the process. There is a demo image and xls file in the *.exe path. It will automatically convert every bitmap to an 8-bit bitmap so you don't have to worry about the result quality. Requires Microsoft Excel to be installed. author: Mattia Campolese
required: Windows+Excel

The Bond Yield Calculator enables the automatic generation of scheduled bond payments and the calculation of resulting yield to maturity. The model is equipped to handle 'odd' first time periods and is ideal to speed up bond payment and yield calculations.

A free library of 50+ new worksheet functions for Excel (all versions) - Strip the accents from a string, convert a value from a base into another base, determine the number of unique values in a range or array, return an age in years, months and days, determine the date of Easter Sunday for a given year, evaluate a formula or expression, and much more.

Excel Yearly Calendar Template (Microsoft Excel spreadsheet, No Macros) is a free yearly calendar for Excel. Create and print yearly calendars or even multiple-year calendars. This spreadsheet is simple to customize.

This free Excel calendar template allows you to quickly and easily create a monthly calendar by simply choosing a year and month. You can also choose a color scheme for your calendar using simple form controls. Use this Excel calendar spreadsheet for planning, printing, and scheduling. [Requires Microsoft Excel 97 or later]

ReplaCLude is an Excel VBA utility that enables you to "Replace and Include" in multiple files. You can replace the "TAG" with specified text, you can include (Insert) another file at the "TAG" point. ReplaClude doesn't modify original files that contain a "TAG", it reads your files as a source file and creates a new Target file. The replace and include rules can be configured for each target files.

Absolutely Free Training Videos for Excel, download or play as flash files in Internet Explorer. Subjects covered include - Using "Paste Special", Formatting Charts. All about Pivot Tables - Create a Basic Pivot Table, Sorting in a Pivot Table, Create a Drill Down Effect with a Pivot Table, Adding a Calculated Field in a Pivot Table.

Pivot Table Helper makes working with pivot tables comfortable and fast. Pivot Table Helper adds its own toolbar to Excel that allows you to select pivot table areas, to set pivot field formatting, to add/remove grand totals, to clear pivot table formatting. Pivot Table Helper is an add-in for Microsoft Excel 2000, 2002 and 2003.

Change Case is a Microsoft Excel Macro that will change the selected text to proper, upper, or lower case. The user simply highlights the text they want to change, selects the new case and the macro will convert all the text to the new case. Works with Microsoft Excel 97, 2000, or XP.

DataPig Explosion, a Survival Kit for Excel, is an Excel Add-In created for users who spend more time cleaning up spreadsheets than focusing on the their core business. With this handy utility, you can quickly and easily apply over 15 separate formatting and data normalization function to an entire spreadsheet at one time!! Datapig Excel Explosion can also split your Excel dataset into separate Excel workbooks based on criteria you define! You can create a separate workbook for each Employee in your dataset or each City, or State, or... etc. etc. All this with one click!

This MSExcel workbook provides a simple but powerful tool for tracking a bond portfolio. It was created to track a muni portfolio but could be adjusted to track other types of bonds. The analytics section of the workbook includes features such as tracking of modified duration and sensitivity for each bond as well as for the portfolio overall.

The Bond Yield Calculator enables the automatic generation of scheduled bond payments and the calculation of resulting yield to maturity. The model is equipped to handle 'odd' first time periods and is ideal to speed up bond payment and yield calculations. Cmpatible with Microsoft Excel 97 or above.

This package contains program adaptations to invert large matrices with thousands of elements and solve linear system with many variables (up to 250 ). Operations performed are: inversion, multiplication, solving linear system, linear regression and polynomial regression. A useful Excel addin is added to handling large matrices. Help on-line.

Clustering is a very popular and useful technique in data analysis / data mining, here is a small tool in Excel using which you can find clusters in your data set. The tool uses Self Organizing Maps (SOM) - originally proposed by T.Kohonen as the method for clustering. This is a very basic version of SOM and severely restricted in speed and capability. A better name for this tool would be, perhaps, 'A Poor Man's SOM' but, if you are new to SOM or just want a simple program to try, or want an easy way to produce a sample presenhtation, then here is a small toy to play with and get a feel about how it works.

Builds Classification / Decision tree models in Excel - Draws the tree in Excel and links up the cells in the tree automatically so that it can be used to classify new data set. Graphically shows the class distribution in each node of the tree. The application is good for small experiments and definitely pretty good just for fun, ideal for a beginner to get some initial idea about Tree based modeling. Warning! This application heavily uses Excel's Advanced Filter and Pivot Table features. Before downloading the application, please check whether your version of Excel has these two features. If not, then you cannot run this application on your version of Excel.

This is a tool to build Neural Network Classification models in Excel. Uses feedforward-backpropagation algorithm. Tracks misclassification error on training and validation data. Can automatically handle categorical variables and missing values. Saves the final model in a separate excel workbook.

A collection of simple, useful spreadsheets (suitable for Excel Version 7.0 and later, and compatible programs) for personal financial analysis. Features automatic tax calculations for up to two partners, balance sheet and assets and liabilities, investment projections, disposable income calculation. Graphing of key data.

This Excel addin performs multi-precision floating point arithmetic. Perhaps the first package that extends the standard Excel precision from 15 up to 200 significant digits. It is for Excel 97/98 and consists of a set of 50 functions for arithmetic, trigonometric, logarithm, exponential calculus. Useful for testing algorithms. Help on line. Very easy to use and no installation.

The first package for multi-precision floating point arithmetic in Excel 97/2000, with 160 functions for arithmetic, trigonometric, logarithm, exponential, hyperbolic calculus. Linear Algebra: System resolution with Gauss-Jordan algorithm (also in a didactic step-by-step method). Gauss-Seidel iterative method. Matrix operations. Determinant. Matrix Inversion. Characteristic Polynomial with Newton-Girard formulas. Crout's algorithm for LU decomposition. Similarity Transformation. Matrix power. Lots mmore!

Add-In for MS-Excel 5.0/7.0/8.8 for converting national monetary to EURO and vice versa, also convert a national monetary to another - 2 posibilities: exact calculation or rounding to smallest coin.

Add-In for MS-Excel v8.0 with extended trigonometric functions to calculate with decimal degrees, also included: get decimal degrees from trigonometric values, also included conversion decimal degrees to degrees.minutes seconds and vice versa, also included INVOLUT function and getting decimal degrees from Involut value (also avalable with german decompressing tool) download size 110K, installed size 25K

Excel Invoice Template provides a Fill-In-The-Blanks invoice form and is capable of creating and calculating invoices. The template shows quantity, description, unit price, taxable status, and amount per line. Sub-total, tax and total amount are computed from the line items automatically. The template offers a What-You-See-Is-What-You-Get invoice form. If you know how to use Microsoft Excel, you know how to use Excel Invoice Template.

An Uncommon Way to Wealth, Free Excel Spreadsheets for managing finances. Inventory Spreadsheet - keep track of what's in your house. Grocery Savings Spreadsheet - also known as a pricebook, keep track of regular purchases. Cup o' Joe Factor Calculator - determine just how much your habits cost you. Millionaire Calculator - ever wondered just how long it will take for you to save a million dollars? Checkbook Balancer - Hate to balance your checkbook? This spreadsheet takes the drudgery out of a tedious task, and is a great way to learn to balance your checkbook. Car Maintenance Schedule Spreadsheet - Helps keep track of your car maintenance information, and shows you when a maintenance item is due. These and several more are available for download. Feel free to modify them as you see fit so that they work best for you.