MS Excel Add-ins, VBA Code for Your Business and Home

OzGrid Excel Addins Collection + free Excel Download Package ($12.95) + free File Size Reducer for Excel

  Savings!     $174.00    $69.95

Free 30 Day Money Back Guarantee

    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.
    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.
    Formula Reference Changer. This handy little Excel Add-in can very quickly change thousands of formula references to your specified type. It has 3 levels of areas to effect:

Selection only;
Entire Active Sheet;
Entire Workbook.

    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.
    Duplication Manager. 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.
    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

More Info

Calendar for Excel

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 Download Package

   $12.95

Free 30 Day Money Back Guarantee

This package includes 33 fully accessible Workbook examples that cover topics like, Vlookup,Match,Index,Dfuntions,Advanced Filter,Validation,Conditional Formatting,Custom VBA Functions,VBA Functions,Listbox,Combobox,Working with Excel Menus in VBA,Printing Long List Code,Dynamic Named Ranges and much more!

Also included is "Excel and Excel VBA Tips and Tricks", normally $7.50

This HUGE collection has a Workbook with special tips on Conditional Formatting, Vlookup, Validation, Dynamic Ranges within a range and some slick uses for Checkboxes. There are some links to some excellent Excel software sites that sell Excel software and Add-ins.

The VBA section includes a UDF to Count ,Sum and Sort by color, Generate x non-repeating random numbers between a top and bottom range, Find the specified occurrence matching criteria from two Columns. There are step-by-step instructions on how to add descriptions to UDF's and how to create their category. There is a way to create a dynamic "Sheet Navigator" that is added to the standard right click Pop-up menu. How to create a simple UserForm that is linked to a data table. There is also a page on which VBA function to use when there is no equivalent WorksheetFunction.

Included FREE:

Time Saving Microsoft Excel Soltions:

Time Saving Microsoft Excel Solutions is a downloadable book in a Windows help file format that contains hundreds of solutions to Microsoft Excel problems. You do not need to purchase and it does not expire - it is freeware. Download and use whenever you have the time or need. It is a great way to improve your Excel skills and find time saving Excel solutions.

No special software is needed to use - just download, run ,and open Excel. Access from the Excel Tools menu by clicking on the new menu item. Time savings Excel solutions are always just a click away - you even save time by avoiding fruitless Internet searches!

Free Demos Of:

Duplication Manager Add-in

Formula Ref Sheet Index Add-in

OzGrid Excel Plus Add-in

Time Wage and Paybook

OzGrid Add-in Collection 

Excel 97/2000/XP and Windows

Duplication Manager   + free Excel Download Package ($12.95) + free File Size Reducer for Excel

  $29.95

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.

Come with the FREE 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

More Info

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

Number, Formula & Text Manager + free Excel Download Package ($12.95) + free File Size Reducer for Excel

   Savings! * $59.90 $44.95

Number,Text & Formula Manager is 3 seperate Excel Add-ins bundled together to save you 50% off the individual prices. Read about these 3 add-ins in details and see screen shots on this site.

Excel 97/2000/XP and Windows

More Info

1(2) Next

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

Accounting in Excel Converting in Excel Management in Excel
Analysis in Excel E-Books about Excel Marketing in Excel
Budgeting in Excel Finance in Excel Planning in Excel
Excel Calculators Forecasting in Excel Project Management
Cars Accounting with Excel Employment in Excel Quality Control in Excel
Charting in Excel Inventory Management in Excel Scheduling in Excel
Checks in Excel Investment Management in Excel Wage Calculation in Excel

Home