Add Power to Excel Spreadsheets
Multi Scenarios Manager for Excel
$69.95
Using Multi Scenarios Manager for Excel, you may quickly and very simply create, evaluate and manage multiple scenarios of your models in Microsoft Excel.
Spreadsheet Presenter
$59.95
Spreadsheet Presenter is an add-in for Microsoft Excel which will allow you to customize your charts and reports in Microsoft Excel - as you desire. You will have many tools available to improve your worksheets, making them easier to read and follow, for your presentations and reports.
Excel Scheduler $39.00
Free 30 Day Money Back Guarantee
Project Management, Gantt Charting, and Employee Scheduling.
For all versions of Microsoft Excel.
To run Excel Scheduler, simply run Excel and read in template(s) of choice.
Project Management:
CPMDAILY.XLS
CPMHOUR.XLS
CPMWEEK.XLS
Gantt Charting
GANTDAY.XLS
GANTHOUR.XLS
GANTWEEK.XLS
Employee Scheduling
DAYSOFF.XLS
Shift Scheduler Continuous Excel
The Shift Scheduler will build a roster structure to your
specifications, allocate staff automatically, and generate a printable roster, all at the
click of a button. It is compact and user friendly allowing you to add staff and shifts
(maximum 150) with ease. Default values for continuous shifts mean that the only shift
data required is the start date/time and length for the first shift, everything else is
automated. For non-continuous or varying shifts you have the capacity to overwrite default
data and structure shift settings to suit your specific requirements.
Constraints you can apply when allocating staff include the maximum hours a staff member
can work within the roster period, the maximum continuous work hours, the minimum break
between shifts, and the maximum number of days in a row that can be worked. You can also
set a Yes or No work status to define a must work or must not work requirement. Your
roster is printed using standard Excel commands or using the Format Print function to
build a compact and easy to read roster schedule table. The Next Roster function allows
you to roll roster details into the next roster period to quickly build consecutive
rosters. Operational instructions are provided as convenient mouse over comments.
Privacy Keeper
$29.95
Privacy Keeper is an add-in for MS Office to protect your documents and privacy of your
computer.
Using it you will be able to manage passwords of many documents in MS Office. Create,
erase and store your passwords in Privacy Keeper and when you open a protected document
you will open it automatically.
Keep your computer against strangers using our Privacy tools. Erase opened documents
history of your computer and delete nonrecoverable files.
Also you have an Alarm Messages to receive messages for meetings when you work in MS
Office.
Platform : MS Excel, MS Word and MS Power Point only.
Teaching and Training with MS Excel
E-books, courses, lessons, tips, tricks, and more
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
$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
OzGrid Plus and Duplication Manager + free Excel Download Package ($12.95) + free File Size Reducer for Excel
Savings! $59.90
$39.95
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 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 and remove duplicate lines from a table.
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.
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.
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
Number Manager + free Excel Download Package ($12.95) + free File Size Reducer for Excel
$29.95
The number manager fills in the gaps in Excel when working with numbers. It allows you
to add 15 different number formats that are not part of Excel's built in number formats.
Retain leading zeros, show dollars and cents, Align all decimals, have negatives in
brackets, hide negatives, positives, zeros, text, numbers, or all. There is even a Listbox
where you can select anyone of 172 currency codes to format you numbers as USD25.00,
AUD356.32 etc.
Ever had those stubborn numbers that Excel only sees as text? With the Number Manager all
you do is click the Force To Numbers and the problem goes away.
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. The Alter values can be used to increase,
decrease, multiply or divide your numbers by any value or percentage.
The Convert/Remove tab is just the thing for those stubborn imported (or not) numbers and
text. You can remove all text from a mix of text and numbers, remove all numbers from a
mix text and numbers. A common problem with numbers being imported is some programs (SAP
etc) bring in negatives as 100- instead of -100. Excel will see these as text and not
negative values. With the Number Manager all you do is click a button and they are
instantly put the right way. Another common issue is dates ending up as 010503 (01/05/03),
1503 (1/5/03) etc. Excel think these are numbers and not dates, meaning you cannot work
with them. With the Number Manager you click a button and they are changed to become real
dates that Excel does recognize.
Excel 97/2000/XP and Windows
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
Excel Time Sheet + free Excel Download Package ($12.95) + free File Size Reducer for Excel
$15.95
This extremely easy and simple to use Excel Time Sheet will keep track of your
employees hours. It allows you to specify and set unpaid breaks in 5 minute intervals on a
daily basis. If your employees work hours that span into a new day, no problem, the time
calculations will accommodate this. All Start and End times span a 24 hours period in 15
minute intervals, all you do is select a Start time and End time from a drop down list.
This makes it impossible to enter times that Excel wont recognize.
All you do is enter your employee names once, save as a Template and you are set.
The Time Sheet incorporates a 7 day week with any day being optional. If you need another
pay period let us know and we will modify it for you.
Excel 97/2000/XP and Windows
Excel Time Sheet Advanced + free Excel Download Package ($12.95) + free File Size Reducer for Excel
$29.95
This extremely easy and simple to use Excel Time Sheet will keep track of your
employees hours. It allows you to specify and set unpaid breaks in 5 minute intervals on a
daily basis. If your employees work hours that span into a new day, no problem, the time
calculations will accommodate this. All Start and End times span a 24 hours period in 15
minute intervals, all you do is select a Start time and End time from a drop down list.
This makes it impossible to enter times that Excel wont recognize.
The Time Sheet incorporates a 1, 2, 3 or 4 week period with any week and/or day being
optional. All you do is enter your employee names once, save as a Template and you are
set.
1 Enter your employee names in the cells below Employee Name. The same names will
automatically flow through to Week2, Week3 and Week4.
2 Select the starting date from directly below Week 1 Includes. 7 day periods will
automatically flow through to Week2, Week3 and Week4.
3 Once you have done this, go to File>Save As and Save as a Template into the path that
Excel defaults to.
4 If Week2, Week3 or Week4 are not needed, simply ignore them and do not enter any times
on them.
5 You can now add the Time Sheet as a Template Workbook simply by going to File>New
The Totals sheet has a very easy to use Pivot Table which is based off all employees and
their hours. You can simply specify to display results by Week and/or by Name or show All
Names and/or All Weeks. Double clicking on any hours within the Total Hours field will
give you a Break Down of the displayed data.
Excel 97/2000/XP and Windows
FormulaManager + free Excel Download Package ($12.95) + free File Size Reducer for Excel
$29.95
Free 30 Day Money Back Guarantee
The Formula Manager is designed to make the managing of all formulas a breeze. It can be used to map your spreadsheet by formula type. You can format the background color of all formulas that match the criteria you set. It a can also format the font of all formulas that match any criteria you set. Once applied, you can tell at a glance which cells contain formulas and which do not.
When you have a spreadsheet that contains formulas, you want to be sure that no user can delete, over-write or modify them. The Formula Manager can do this for you in seconds! Just specify which formula types to Lock, Hide or Lock and Hide. You can even protect the sheet in the same step! You can also easily Lock or Unlock all cells in one click.
Excel 97/2000/XP and Windows
Text Manager + free Excel Download Package ($12.95) + free File Size Reducer for Excel
$29.95
Free 30 Day Money Back Guarantee
The Text Manager will make working with text in your spreadsheet very easy. It is particularly useful for text which has been imported into Excel. You specify the range to affect, this can be specified cells or the entire sheet.
The Change Case lets you instantly change the case of your text. You can nominate to change your text to all UPPER CASE, all lower case, or Proper Case.
The Remove Character or Text can save you many hours of manually removing specific characters, or text, from 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.
Excel 97/2000/XP and Windows
Formula & Text Manager + free Excel Download Package ($12.95) + free File Size Reducer for Excel
Savings!
$59.90 $39.95
Free 30 Day Money Back Guarantee
Please see The Formula Manager and The Text Manager above.
Excel 97/2000/XP and Windows
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
OzGrid Excel Plus Add-in + free Excel Download Package ($12.95) + free File Size Reducer for Excel
$29.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.
Comes 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
TimeAndWageBook + free Excel Download Package ($12.95) + free File Size Reducer for Excel
$35.00
Free 30 Day Money Back Guarantee
If you need to track employee hours and calculate their pay based on the hours worked, this Workbook will make it a breeze! It is an Excel Workbook which you enter, one time only, all your employee names into. You then enter their hourly rate and then simply enter their total hours worked for each day. It also has the option to add 2 different overtime rates and the hours after which these rates apply, all calculations are done for you! You can also (optionally) add 2 different rates for both Saturday and Sunday rates. If your employees work Public holidays, there is another option for Public holiday rates. All you do is fill in the needed details once and save as a Template.
Excel 97/2000/XP and Windows
Grab It! is a Microsoft Excel based application that digitizes
data from
pictures. Graphs and charts can have data point values digitized
and angle and distance measurements can also be made on photos. Skewed graphs are handled
automatically (sometimes scanning isn't perfectly straight) as well as linear, log, date
or time charts. Output is displayed in real time and special features for error bar
graphs, stock charts, and multiple data sets are included.
COMxL RS232C is an ease-to-use and very-helpful
Add-Ons/Add-Ins for MS Excel 97/2000 's user. It lets you link your instrument to your any
Excel worksheet directly via RS232 port. The readings from instrument can go/fill-in
anywhere you want to them to go by just simply highlighting the range. The moving
direction of fill-in Data can be selected (top-down or left-to-right).
Key features:
* Import instrument's DATA via RS232C port to MS Excel worksheet.
* Ease to setup for instrument with RS232C port and use.
* Date&Time stamping .
* Send ASCII command to instrument to download its DATA.
* Timer sampling for DATA input.
* Pop-up message for Upper/Lower Limits warning.
* Send a set of commands from File "CmmdsListFile.txt" to instrument.
* Send Command from clipboard to instrument or other computer.
* Send Text in the clipboard to instrument or other computer.
* Commands list and Upper/Lower Limits list available.
JEM Plus is an unbelievable product that will boost productivity and take data integrity to new heights. This is a must-have software for individuals that work with Microsoft Excel. Gain greater control and speed when managing and manipulating spreadsheets . Contains over 40 robust utilities, 207 additional worksheet functions (mostly financial), and a wonderful help file with detailed explanations. JEM Plus provides professionals and everyday users the power to get the most out of their Microsoft Excel spreadsheets. JEM Plus integrates seamlessly with your existing Excel spreadsheets. Experience the smarter way to work. JEM Plus makes great software better.
EldoS AutoSaveXL is an add-in for MS Excel 2000 and MX Excel XP that is used to automatically save the files periodically. It is a replacement for built-in autosave feature, however AutoSaveXL doesn't ask for confirmation and creates any number of backup files not spoiling an original version.
If you are not satisfied with the Excel's built-in Find where
you have to make numerous clicks to find the information needed, the Advanced Excel Find
can serve all your needs.
It enhances Excel's built-in Find and makes search through multiple worksheets and
workbooks in Excel fast easy and comfortable. The whole thing takes you just a few seconds
and a couple of clicks.
The Advanced Excel Find has all features of the Excel's built-in Find and besides you have
the advantages of simultaneous search in values, formulas and comments; search in all or
selected worksheets and workbooks at the same time; multiple selections of the found
items...
One click and you can move freely around search results, select the items of interest and
just continue you work.
The Advanced Excel Find is an add-in designed for MS Excel 2000 and MS Excel XP and adds
no new workbooks or VBA macros.
If you ever tried to find cells containing conditional
formats, formulas,
comments, and such, you would appreciate Advanced Excel Select at its true value.
Just two clicks to have the job done!
It also introduces a feature useful in fast table formatting:
Select by Format.
Save your time and nerves with Advanced Excel Select:
• A single dropdown menu on a toolbar;
• Select rows and columns that have the same format with the button on a toolbar;
• Simple installation and clean uninstallation.
Aren't you sick and tired of typos in your spreadsheets?
It is a specially designed tool to help you polish off all
typos in your Excel workbook.
The Typos Finder is an add-in for Microsoft Excel 2000 and 2002 that:
• Searches for fuzzy duplicates and quickly finds values containing one to four
typos
• Recognizes lost symbols, inserted symbols and misprinted symbols
• Searches for typos inside the selected range or inside the current column
of the current list
• Shows all found typos in the convenient typos list
• Allows correcting typos by ONE CLICK ONLY
• It can easily handle over 65,000 rows
Kill typos in your workbooks!