Excel Download Package

Over 33 Excel & VBA Workbook Examples

Description of Excel Download Package:

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 12.99

See Also: All products from OzGrid Business Applications

1. Analysis Collection for Microsoft Excel
   Get two downloadable books on Excel macos, another on time saving solutions, and 19 time saving add-ins, including the Spreadsheet Assistant.
2. Funding Plan Pro
   Funding Plan PRO for Excel provides the perfect financial planner for any 10 year projection.
3. Measurements to Excel
   The objective of this application is to facilitate the management of data generated by measurement applications of three-dimensional pieces such as Metrolog, PcDmis or Tutor...
4. Password Assistant for Excel
   The Password Assistant allows you to unlock worksheets or workbooks that are password protected!. It does the task in just minutes.
5. OM-MULTIMON
   Excel Spreadsheet Template for Ratio-to-moving-average seasonal adjustment
6. Random Sampler for Microsoft Excel
   Use the Random Sampler to randomly select your samples!
7. Report Maker 1.20
   Browse databases, run SQL queries, or build reports. Report Maker is a hip software tool that helps you to create report form database. You can Create report of thousands record in five minutes! Simply drag and drop the fields you want.
8. Excel Duplication Manager Add-in
   Manage duplicate data in your Workbook with ease.
9. Daily Multi Task Scheduler
   The Multiple Daily Tasks Excel spreadsheet assigns multiple tasks, shifts, or clients to your employees or multiple employees to your tasks, shifts, clients, or vehicles for one week.
10. Data Loader for Microsoft Excel
    The Data Loader is a menu driven add-in for Microsoft Excel that makes loading data from one worksheet to another fast and easy.
11. C-Organizer Professional 3.5.0
    C-Organizer Professional is the elegant and powerful personal information manager
12. Biweekly Amortization - for Windows 95 or higher
    Biweekly.EXE - This program calculates and displays the reduced loan period and total payment with this type mortgage.
13. Multi-Cell Goal Seeker for Microsoft Excel
    The Multi-Cell Goal Seeker for Microsoft Excel allows you to get goal seek solutions to many spreadsheet cells at one time.
14. Richworks.Now
    Personal Finance Manager
15. Advanced Excel Find
    Easy and fast search through multiple worksheets and workbooks in Excel. Simultaneous search in values, formulas and comments, free moving around search results and more.
16. Cell Color Assistant for Microsoft Excel
    Use th Cell Color Assistant in Microsoft Excel to create your own custom color toolbar.
17. Personal Finances+ for Windows 3.1
    Pfinance.EXE - A collection of 8 personal finance programs
18. Excel Typos Finder 1.4
    Aren't you sick and tired of typos? It is a specially designed tool to help you polish off all typos in your Excel workbook. Introduce a new order in your data!
19. Variable Rate Mortgage - for Windows 95 or higher
    Varimtge.EXE - You can use this program to either investigate or track a variable-rate mortgage or to project the payout of this type mortgage.
20. Finance Helper 2001 Program Code 3.8
    Easy to use Financial and Budget Program