Workbook Software

The Project Planning and Management template is designed as a generic solution to plan and manage any project. Building the budget as tasks are identified facilitates the processes of business case proposal, valuation and funding. Progress can be monitored from automatic creation and updating from remote participant workbooks. Project performance can be monitored with best practice Earned Value Analysis throughout the complete project lifecycle.

Convert web site files to Excel. Simply browse to the HTML files and send the contents to a blank Excel workbook. You must have Excel installed on your machine.

Detect spreadsheet errors with the following tools: advanced formula direction highlighting, cell dependency hierarchical walkers, formula analysis, workbook summary reports, named range analysis, detection of empty or text cell references, and Nested IF views. Detect changes in models by using workbook or worksheet comparison reports. Summarize all the Excel documents found on a local or network drive and produce interactive reports. Minimize ..

Copy sheets between two Excel books. Browse to your two files, select the sheet you want to copy, move, delete, or rename.

Powerful Excel workbook for stocks & mutual funds. Quotes directly from Internet with no downloads or conversions. Manage stocks & mutual funds your way. Stealth quote interface uses simple & familiar =functions(). Works with all proxy servers. Example workbook with spreadsheets show how to dynamically update market price, change, volume, high/low price, date, and time. Excel calculates gain/loss, value and much much more.

Change formula references from absolute to relative or relative to absolute. Address changes are made by selection, sheet, or entire workbook. This Excel Addin is great if you are moving, copying and pasting cells.

Option pricing spreadsheet that calculates the theoretical price and all of the Option Greeks for European Call and Put options. The spreadsheet also allows the user to enter up to 10 option legs for option strategy combination pricing. The calculations are made in Visual Basic and all of the code used is fully disclosed in the Visual Basic editor for user intervention.

Delete file links in your Excel files. Excel files can be automatically backed up before work is done. This will eliminate the message: This workbook contains links to other data sources. If you update the links, Excel attempts to retrieve the latest data. If you don't update, Excel uses the previous information. You must have Excel 2002 (XP) or higher installed on your machine.

Hide Worksheets is a must have excel add-on tool to quickly and easily hide or unhide worksheets. By using Excel's built in unhide worksheet function it can be very time consuming and frustrating unhiding one worksheet at a time. With Hide Worksheets it takes a matter of seconds to hide or unhide several or even all the worksheets in a workbook. Download the trial and give it a try you'll wonder why Excel doesn't have this feature built in.

Recover passwords to Microsoft Excel files: password to open, password to modify, workbook protection password, sheet protection passwords. Most passwords are recovered instantly; password to open requires brute-force or dictionary attack. All versions of MS Excel (from 4.0 through XP and Pocket Excel) are supported.