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.

Accounting in Excel Converting in Excel Management in Excel
Analysis in Excel E-Books about Excel Marketing in Excel
Budgeting in Excel Finance in Excel Planning in Excel
Excel Calculators Forecasting in Excel Project Management
Cars Accounting with Excel Employment in Excel Quality Control in Excel
Charting in Excel Inventory Management in Excel Scheduling in Excel
Checks in Excel Investment Management in Excel Wage Calculation in Excel

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

More Info

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

More Info

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.

More Info

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

More Info

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

More Info

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

More Info

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

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.

Features

  • 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

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

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

More Info

1(6) Next

Home