MS Excel Add-ins, Spreadsheets, Workbooks, Templates, VBA Code for Your Business and Home
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.
Please click on an Excel topic above or see the full Microsoft Excel add-ins, spreadsheets, workbooks, and templates list below.
Automate Faster Your Office with VBA Code
$149.00
Create better VBA code faster! For Microsoft® Access, Microsoft® Excel, Microsoft® Word, Microsoft® Outlook and other Microsoft Office applications.
Microsoft Office 97 or later
Microsoft SQL/Analysis Services - o2olap for Excel
$850.00
Free 30 Day Money Back Guarantee
Microsoft Analysis Services (OLAP) and SQL Server are outstanding products but lack some key capabilities for finance and analyst users such as spreadsheet modelling, freeform reports and writeback. O2OLAP for Excel overcomes these limitations, allowing users to take advantage of the inherent architectural and commodity cost benefits of Microsoft technologies. New market leading functionality enables users to create executive information systems (EIS) without having to write or support a macro.
Microsoft Office 2000/XP/2003
MITCalc
Mechanical, Industrial and Technical Calculations for Excel
$49.00
Are you a mechanical engineer, design engineer, engineering draughtsman, technical employee, or a student at a college? Do you need to work with a professional computational system? But you are not willing or cannot pay thousands of dollars for inadequately complex or incomprehensible solutions? Then you may just need MITCalc.
Excel Scheduler
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
$68.00
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.
Free 30 Day Money Back Guarantee
ZRandom
$29.95 
ZRandom implements high
quality random number generation for Microsoft Excel
using the Merssenne Twister algorithm :
* Use higher quality pseudo-random numbers than the
Excel RAND() and VBA Rnd() functions.
* Generate random numbers from 16 discrete and
continuous distributions. ZRandom implements the
following discrete distributions: Uniform, Bernoulli,
Geometric, Hypergeometric, Negative Binomial and
Poisson. ZRandom implements the following continuous
distributions: Beta, Burr, Exponential, Gamma,
Lognormal, Normal, Pareto, Triangular, Uniform and
Weibull.
* Create large batches of random numbers using the
interactive user interface.
* Excel functions for use in spreadsheet
formulas.
* Random Sort and Random Sample
* Interactive distribution wizard
* A VBA interface to generate random numbers in your
code.
Excel 97 or above
Annotator for Microsoft Office $17.95
Interact with your familiar
Microsoft Office (97/2000/XP/2003) in new ways and
change your Office experience by using the pen/tablet
and the inking capabilities of Meanders' Annotator
to:
Review, comment, markup Office documents, draw and
annotate tables, charts, diagrams, etc directly with
your handwriting inside Microsoft Word, Microsoft Excel
and Microsoft PowerPoint.
Comment directly on Microsoft Excel worksheets when
reviewing data and charts.
Prepare handwritten Microsoft PowerPoint slides for
clearer and faster illustration.
Write and sign handwritten messages in Microsoft
Outlook when using Microsoft Word as your e-mail
editor.
Write anything in any language (Chinese, Japanese,
French, German, etc). Sign a document with a personal
touch.
Make difficult illustrations easy, such as musical
symbols, engineering diagrams like molecular formula or
structural formula in chemistry, complex mathematical
notations or equations, electrical and electronic
circuits and so on.
Fill forms and questionnaires quickly inside Microsoft
Word with digital ink.
Take notes intuitively and smoothly for a meeting.
Alternate typing and handwriting at your will.
Share the documents with others in native Office file
formats without compatibility problems.
Work with both Tablet PCs and normal desktop or laptop
PCs which are installed with mouse or major tablets
from WACOM (Intuos, Graphire, Cintiq, Volito, Favo,
PenPartner, ArtZ, ArtPad, etc), Genius (WizardPen,
NewSketch, EasyPen, etc), Aiptek (HyperPen, etc) and
others.
Teaching and Training with MS Excel
E-books, courses, lessons, tips, tricks, and more
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-to-MySQL
Excel-to-MySQL is a program to convert MS Excel spreadsheet into MySQL database. Each worksheet becomes a table, each row becomes a record and each cell becomes a field.
- All versions of MS Excel are supported
- Converts individual worksheets
- Merges MS Excel data into an existing MS SQL database
- Converts Comma Separated Values (CSV) files into MS SQL tables
- Easy-to-use wizard-style interface
- Full install/uninstall support
- Windows 2000/XP or Windows NT 4 with Internet Explorer 5 or later or Windows 98/ME or Windows 95 with Internet Explorer 5 or later
- At least 32 MB of available memory
MySQL-to-Excel
MySQL-to-Excel is a program to convert MySQL databases into MS Excel spreadsheet. All MySQL data types are supported. The program has easy-to-use wizard style interface and works with all versions of MySQL servers.
Features
- All MS SQL data types are supported
- Fast conversion engine (20MB MS SQL database - in 1 minute on average P-III system)
- Converts individual tables
- Output spreadsheet is compatible with MS Excel 5.0 and higher
- Easy-to-use wizard-style interface
- Full install/uninstall support
Requirements
- Windows 2000/XP or Windows NT 4 with Internet Explorer 5 or later or Windows 98/ME or Windows 95 with Internet Explorer 5 or later
- At least 32 MB of available memory
- MS SQL environment (server or client components of MS SQL should be installed on the same machine where you run MSSQL-to-Excel from)
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
1(6) Next