OzGrid excel Addins Collection
Author: OzGrid Business Applications
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
 Download now
 Click to buy from RegNow
Other products from OzGrid Business Applications :
- Complete Excel Course (Business & Finance > Spreadsheets)
- Excel and Excel VBA Tips and Tricks (Business & Finance > Spreadsheets)
- Excel Download Package (Business & Finance > Spreadsheets)
- Excel Duplication Manager Add-in (Business & Finance > Spreadsheets)
- Excel Level 1, 2 and 3 Training (Business & Finance > Spreadsheets)
- Excel Level 1 Lessons (Business & Finance > Spreadsheets)
- Excel Level 2 Lessons (Business & Finance > Spreadsheets)
- Excel Level 3 and Excel VBA Courses (Business & Finance > Spreadsheets)
- Excel Level 3 & Excel VBA & Excel UserForm Courses (Business & Finance > Spreadsheets)
- Excel Level 3 Lessons (Business & Finance > Spreadsheets)
- Excel Levels 1 and 2 Training (Business & Finance > Spreadsheets)
- Excel OzGid Plus With Duplication Manager (Business & Finance > Spreadsheets)
- Excel VBA Level 1 and Excel UserForms (Business & Finance > Spreadsheets)
- Excel VBA Level 1 Lessons (Business & Finance > Spreadsheets)
- Excel VBA UserForm Lessons (Business & Finance > Spreadsheets)
- Formula and Text Manager for Excel (Business & Finance > Spreadsheets)
- Formula Manager (Business & Finance > Spreadsheets)
- Formula Ref Changer and Sheet Index Creator (Business & Finance > Spreadsheets)
- Number Manager (Business & Finance > Spreadsheets)
- Number,Text & Formula Manager (Business & Finance > Spreadsheets)
- OzGrid excel Addins Collection (Business & Finance > Spreadsheets)
- OzGrid Excel Plus Add-in (Business & Finance > Spreadsheets)
- Text Manager (Business & Finance > Spreadsheets)
- Time Sheet Advanced (Business & Finance > Spreadsheets)
- TimeAndWageBook (Business & Finance > Spreadsheets)
Click here to view all products list from OzGrid Business Applications ...
| 
