Software for MS Excel
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
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
$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
Please see also MS Excel add-ins, MS Excel Spreadsheets, and MS Excel Templates, MS Excel Workbooks, VBA Code for Excel for your business & home.