|
|
EXCEL ADD-IN FILES
- Add page indexes to ink all spreadsheets together.
- Add Reminder notes. Like those little yellow pads, bring reminders messages into your Excel at preset times and dates.
- Add all formulas list with links to each formula cell.
- Manage cell ranges with more options than provided by Microsoft.
- Convert imported numbers to true Excel formats.
- Hide zeros, hide text, hide numbers, hide negatives, hide positives with one click.
- Create one year Excel 365 days calendars.
- Manage List duplicates, number formats and equations much more efficiently and make Excel work faster for you.
- Convert vertical number sequences into horizontal rows with one click.
- Copy data to a different part of your spreadsheets keeping the orginal cell references the same.
- Random numbers generator.
Unlimited license allows installation of the Add-ins into an unlimited number of Computers, and/or Networks within your organization. Ideal and VERY cost effective for corporate environments!
All nine Excel add-ins can be downloaded instantly as part of our Excel Financial Collection Super Gold Edition when purchased from this site.
Reduce the time you work with Excel. You can reduce hundreds of hours of valuable work time every year with these Excel Add-Ins. We have color coded the principle time saving tools in blue.
|
OUR PRICE ADVANTAGE. Regular price $203.95. Our price $119.40.
|
|
|
BEST VALUE BONUS SPECIAL OFFER* – BUY NOW – SAVE $60.00 WITH OUR COMBINED ADD-INS & EXCEL TRAINING BIBLE COLLECTION. Our price $178.80.
|
|
* Plus Free Bonus Excel Currency Database. Change any Excel list containing fx values in any mix of 80 different foreign currencies into your local currency instantly – In today's environment of volatile exchange rates, instant recalculations of multiple fx cost values into the current value of your home currency is an essential tool. Free bonus workbook with this Combined Collection. (The Free Bonus Excel Currency Database is also provided with our Excel Financial Super Gold Collection).
EXCEL ENHANCEMENT 1
The new Formula Manager makes the managing, mapping and reporting all Excel formulas so much clearer and simpler than provided by the Excel program.
Mapping your spreadsheet by formula type saves work time and money. You can format the background color of all formulas matching the business criteria you set. You can format the font of all formulas that match any criteria you set in one quick step. You can tell at a glance which cells contain formulas and which do not. You can lock or hide all formulas. You can copy without the references changing. This and much more!
FORMAT
- Map all your spreadsheets by formula type.
- Format the background color of all formulas that match the criteria you set.
- Format the font of all formulas that match the criteria you set.
REPORT
- The formulas in the cell.
- The address of the cell.
- The sheet it resides on.
- Auto filter is also automatically applied for ease of reading and filtering.
- Report includes Clickable Hyperlinks direct to the specified formula cell.
PROTECTION
- Lock and hide formulas
- Lock only formulas
- Hide only formulas
- Lock/Hide and protect all Worksheets in one go.
COPY
- Copy without formula references changing.
- Copy and transpose (row to column or column to row) without formula references changing.
The new Power Plus Manager really reduces many annoying and frequent time wasting tasks in Excel down to the very minimum. Save time and money when you or any of your staff are working with Excel.
- Formula Report Generator. Makes tracking references and external data links really quick and save a lot of time wasting looking for internal and external references. Allows you to create reports to distinguish 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. Report includes clickable Hyperlinks direct to any specified formula cell.
- Dynamic Range Name Creator. This is a real time saver. It allows the user to quickly and easily create dynamic ranges that expands rows down or columns across in a snap. You can nominate single columns or rows to expand. It can also expand automatically each day month or week.
- Real Calendar. This Add-in creates a live calendar in an instant, so you can reference it if needed when you are working with dates in Excel. The current day is always highlighted and updates automatically. A real time saver if you or your staff are working with dates in Excel.
- Sheet Creator and Sorter. This option creates 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 real time saver if you are working with dates, schedulers, financial plans.
- A Random Number Generator. This can produce up to 1000 non repeating random numbers that meet a criteria you specify. Extremely useful when preparing spreadsheets with probability formula.
- Conditional Row Deletion. This is a real time saver and one that will save many hours of repetitive work for you and your staff. You all know when you see rows containing a criteria you don't need (like zeros or stock items older than a specified date) that you need some way to delete these rows..quickly. This add-in lets quickly and easily delete rows that meet any criteria of your choice. If you see any Excel error messages in rows you can select these as criteria and quickly delete as well.
- 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. Like 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. Really useful when you want to remind yourself of another user at predetermined date and time.
This new duplication manager is a great improvement for users working with lists, tables, addresses, personnel records, product lists etc in Excel who need to identify, manage, delete, hide duplicate entries. The Duplication Manager saves real work time when you need to track down and manage duplicates.
- Find Excel duplicates; Delete Excel duplicates; Mark & Highlight Excel Duplicates. This really useful add-in provides new way to manage lists and duplicates in Excel. It makes finding duplicates in 1 or more lists and/or table much faster.
- Create a Non Duplicate Excel List: CREATE A LIST OF UNIQUE DATA
If you have a list that contains duplicate entries it is a very time consuming and expensive process to remove them manually! The bigger the list, the more time consuming it is. The Duplication Manager provides a new function > Create Unique List > that will create a fresh copy of your list on a new Worksheet that contains only single occurrences of each entry instantly! This option is ideal for a large list of email addresses, names, items or personnel tables.
- Hide Excel Duplicates: DISPLAY ONLY UNIQUE DATA
If you have a list that contains duplicate entries it is a very time consuming process to manually hide them all! The bigger the list, the more time consuming it is. The Duplication Manager provides a new function > Display Only Unique > that will hide all duplicates in your list showing only one occurrence of each entry!
- Pivot Table Report of Excel Duplicates: CREATE A SUMMARY REPORT
The option Summary Report will convert your list (of anything) into a > Mini Pivot Table report. This tells you at a glance how many times each entry in the list occurs and a total count of one occurrence of each entry. You can use the Pivot table created to hide/show specified entries in the list. If you find Pivot tables a bit tricky, this auto generate Pivot Table Report will save you much development time and effort.
- Flag/Identify Excel Duplicates: COLOR CODE ALL DUPLICATES, UP TO 3 LEVELS
The option Highlight Duplicates will color code all entries, appearing more than once in a list or table containing data. If an entry occurs twice it will have a Green background, if it appears three times it will have a Yellow background. Any entry occurring more than three times will have a Red background. The table or list range will also be converted into dynamic mode so that, if the user adds more entries and that entry then appears 2, 3 or more times, all these new entries will be color coded accordingly.
- Prevent Duplicates in Excel: PREVENT USERS FROM ADDING DUPLICATES TO A LIST OR TABLE
The option > Prevent Further Duplicates > will prevent you, or another user entering data that already exists in your table or list. When or if you try to add an entry that is already present, you will be shown a pop-up message telling the user the entry already exists. This is a real time saver for List management!
- Compare Excel Lists for Duplicates: COMPARE 2 LISTS FOR MATCHING ENTRIES
The option > Compare Two Lists > will create a Mini Pivot Table report that will tell you at a glance how many times each entry in each list occurs and a total count of one occurrence of each entry. You can then use the Pivot table created to hide/show specified entries in the list. You can also review a single list generated of combined entries.
- Delete/Remove Duplicates: REMOVE DUPLICATES FROM ANY RANGE
The option > Create a list of unique data > is just what users need to remove duplications from a single column list quickly. Also there are times when users can have duplications in a range, or table, containing more than one column. The option > Remove Duplicates > will scan for all duplicates in a large table, array or list and remove.
- Remove/Delete Duplicates Existing in Another List:
The option > Compare 2 lists for matching entries > is perfect for displaying items that appear in both lists, but does not remove them. The option > Remove Entries from "List Range" that Occur in "List 2 Range" will remove duplicates from 2 lists, arrays or tables instantly. As it creates a copy, the original 2 lists are left unchanged.
- Delete/Remove Duplicates Rows From Tables:
The option > Create a list of unique data > removes duplicate entries in a single column list. However, there are times when you have a table of data where some rows are simply duplicates of other rows. The option Create Unique Table will remove all duplicated rows and create a copy of your table where all rows are unique.
- Remove First Occurrence of Duplicates:
It is very common to have a table of data where some entries in a particular column have been repeated over-and-over. Sometimes you need to remove these repeated entries leaving only the first occurrence. Then leave the cells in-between blank. The Create Blanks Between options is needed.
The Number Manager fills in all the number crunching gaps that Excel missed out!! It makes formatting numbers, currencies and other numerical values much quicker and painless! Plus all the number formats which are not part of Excel's standard program.
Aligns all decimals, negatives in brackets, hides negatives, positives, zeros, text, numbers, or all automatically. No need to keep returning to Format > Cells > Saves hours of development time.
Excel users often come across number formatting that Excel only sees as text. With the Number Manager all you need do is click the > Force To Numbers > option and this problem will vanish immediately.
The > Round option > on the > Change Value tab > allows you to instantly round up, round down or round to any specified number of decimal places. This is SO MUCH QUICKER than writing the Excel Rounding command into a cell formula!!
The > Alter values > option can be used to increase, decrease, multiply or divide your numbers by any value or percentage. This is SO MUCH QUICKER than writing the change formula into cells!!
The > Convert/Remove > tab removes all text from a mix of text and numbers and all numbers from a mix text and numbers. A common problem with numbers being imported into Excel is that some programs (SAP etc) bring negatives as 100- instead of -100. Excel sees these as text. With the Number Manager you click a button and all text values are instantly converted to the right way. Another common problem with imported values is that dates end up looking like this > 010503 (for 01/05/03), or 1503 (for 1/5/03) etc. Excel thinks these are numbers and not dates, meaning you cannot work with them. With Number Manager you click a button and all these misalignments are changed to real dates that Excel recognizes instantly.
The Text Manager makes working with text in your Excel spreadsheet really much easier. The Text Manager is particularly useful for text imported into your Excel. You specify the range to affect, this can be specified cells or the entire sheet.
The > Change Case > option will instantly change the case (upper, lower or proper) of your text. You can nominate to change your text to:
- UPPER CASE
- lower case
- Proper Case
The > Remove Character or Text > option will save you hours of work removing specific characters, or text, from a specified text. You can even copy the characters to remove directly from the Windows Character Map. If the character or text you wish to remove is not available, simply check the > Specify Character or Text > option.
One very common problem with text (particularly imported text) is the unavoidable importing of spaces. Not only does this make your text unsightly and hard to read, but this will also prevent:
- Numbers not being seen as true numbers.
- Dates not being seen as true dates.
- Hard or impossible to break up text.
- Hard or impossible to reference text.
- Hard or impossible to use text in formulas.
You can remove all these problems instantly savings hours of manual deletions:
- Leading spaces.
- Trailing spaces.
- Trailing and Leading spaces.
- All spaces, except for single spaces between words.
When you have text you wish to concatenate (link together) the Text Manager will link specified cells quickly and easily. Simply specify the cells to concatenate, specify the cell to concatenate the text into and click OK. Your text is then instantly joined. You can also tell the Text Manager to add a space between each cell that is joined.
Range Manager allows you to easily and quickly create and manage all Excel named ranges and constants savings hours of development time. You can delete all redundant or broken Names quickly, create named constants and dynamic ranges (indispensable when managing Charts or Pivot tables), create Worksheet level names, consecutive named Ranges and more.
If you are aware of the benefits of using named Ranges as opposed to simple range addresses – for example =SUM(Year_2005_Figures) rather than =SUM($A$2:$D$5000). The use of named Ranges means you can get to the named Ranges quickly and easily. Unfortunately most Excel users don't get past using named Ranges in this manner and do not realize their full potential.
With the new Named Range Manager you can instantly unlock the full potential of named Ranges with all these extra quick time saving features for Excel:
- GO TO & VIEW NAMED RANGES
- CREATE A DYNAMIC NAMED RANGE INDEX SHEET
- HIDE NAMES
- SHOW HIDDEN NAMES
- EASILY REMOVE & IDENTIFY ORPHANED NAMES
- CREATE NAME MAPS
- CREATE CONSECUTIVE NAMED RANGES
- CREATE SHEET LEVEL NAMES
- CREATE NAMED CONSTANTS
- CREATE NAMED FORMULAS
- CREATE DYNAMIC NAMED RANGES
The Formula Reference Changer will quickly change thousands of formula references in your Excel spreadsheets to a specified type. It has 3 levels of areas to affect:
- Selection only
- Entire Active Sheet
- Entire Workbook
You can change a selected range, values in an entire spreadsheet or a complete workbook to these types of formula reference (cell A1 example). Saves hours of manually changing cell references:
- Absolute ($A$1)
- Relative (A1)
- Relative row/Absolute column ($A1)
- Relative column/Relative row (A$1)
If you or your staff develop workbooks with a large number of Worksheets it can be too time consuming to navigate through all spreadsheets to locate the page you want. The Sheet Index Creator allows you to create an Index Sheet that has click-able links that "go to" the selected spreadsheet. It also has the option of placing a "Back to Index" link on all your spreadsheets. Makes navigation throughout all Excel workbooks so much simpler and quicker, plus it provides an overview in one index of all available spreadsheet pages.
|
