OzGrid excel Addins Collection

Excel add-ins Collection

Description of OzGrid excel Addins Collection:

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 54.95

See Also: All products from OzGrid Business Applications

1. Funding Plan Pro
   Funding Plan PRO for Excel provides the perfect financial planner for any 10 year projection.
2. menuZap for Excel
   The innovative menuZap menu dialog box empowers the way you manage and select your workbooks sheets.
3. Forms ComboBox Wizard Add-in
   If you often work in Excel with ComboBoxes from the Forms toolbar this Excel add-in can save you many hours and prevent errors.
4. Data Loader for Microsoft Excel
   The Data Loader is a menu driven add-in for Microsoft Excel that makes loading data from one worksheet to another fast and easy.
5. ForecastingTools Graph
   ForecastingTools Graph provides the most Known and commonly used Forecasting methods for Marketing, Economics, Accounting, Operations Management.
6. Sales Leads 2008 for Excel 2007
   Our Sales Leads 2008 CD for Excel 2007 supplies over 10 million sales contacts and addresses sorted in to 51 States.
7. DigDB Excel Add-in Toolkit for Excel2000 & Up 6.3
   Use this Excel add-in toolkit to empower yourself. It removes duplicates - you can dedupe by matching one table against another, or filter, count, purge duplicates by key fields. You can do Access-like query, aggregation, and join.
8. SpreadCalc 1.01
   SpreadCalc - for those who use Excel seldom and don't need all its complicated features. A handy utility with most often used features of Excel but for less money - for you.
9. OzGrid excel Addins Collection
   Excel add-ins Collection
10. ModernValue
    Includes 1 hour of value modeling or consulting help by Stuart Haxton! Investment commercial real estate total valuation, in Excel. Stand-alone or use with Argus exported data. The most educational, intuitive and visual valuation model.
11. Excel Level 1 Lessons
    10 Lessons and 5 Workbook examples on Excel level 1
12. Biweekly Amortization - for Windows 95 or higher
    Biweekly.EXE - This program calculates and displays the reduced loan period and total payment with this type mortgage.
13. Spreadsheet Assistant for Microsoft Excel
    Save time in Microsoft Excel with the Spreadsheet Assistant.
14. Variable Rate Mortgage - for Windows 3.1
    Varimtge.exe - You can use this program to either investigate or track a variable-rate mortgage or to project the payout of this type mortgage.
15. Richworks.Now
    Personal Finance Manager
16. ExcelSmartTools Premium Edition
    This Add-In adds and enhances Microsoft Excel commands and functions. Many improvements are great time-savings features for tedious and repetitive tasks.
17. TorniaiSansUT Light PC
    TorniaiSansUT Light PC
18. Employee Scheduler in Excel
    An Excel-based scheduler for hourly and salaried employees. Allows you to schedule hours as a percentage of your anticipated revenue.
19. COMxL RS232C
    Link a measuring instrument to YOUR Excel worksheet via RS232 port
20. Cell Color Assistant for Microsoft Excel
    Use th Cell Color Assistant in Microsoft Excel to create your own custom color toolbar.