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. OzGrid excel Addins Collection
   Excel add-ins Collection
2. Easy Hour Assignments for 25 People with Excel
   The Easy Hours Scheduler saves you scheduling headaches and time by letting you simply specify your daily staffing needs and then assign them to up to 25 people by inserting a number in the start time column.
3. Spreadsheet Presenter
   Spreadsheet Presenter is an add-in for Microsoft Excel which will allow you to customise your charts and reports in Excel as you want.
4. Quick Charts for Microsoft Excel
   Quick Charts for Excel is a menu driven Excel workbook that allows you to construct a graph of one row of data and then to easily change from one row of data to another using the Quick Charts tool bar.
5. Model Assistant Suite
   Model Assistant Suite is the most useful collection of add-ins for people who use Excel as a decision making tool: to build, understand, communicate or audit more robust models, quicker.
6. XL Style Manager
   XL Style Manager is an add-in for MS Excel that allows you to: •  Create your own unique style collection quickly and easily. •  See visually your style collection.
7. IBM Smart Suite Lotus Millennium Edition 9.6
   Smart Suite Millennium Edition 9.6 CD with Lotus 1-2-3, word processor and organiser.
8. Advanced Data Grid Control - Standard License 3.5
   This java Data Grid Control applet enables the display of data in rows and columns in java & web applications. Powerful features include Fast Sorting, Data Acquisition, URL Hyperlinks, Embedded Images, Column Totalling and much more.
9. Excel Download Package
   Over 33 Excel & VBA Workbook Examples
10. ConsoXL
    Excel sheets consolidation with a few clicks. ConsoXL groups the sheets and calculates the total. Optionally it can create the links between the sheets and group them all into one workbook while keeping formulas. It just needs the list of files.
11. Excel OzGid Plus With Duplication Manager
    The OzGrid plus and Duplication Manager bundled.
12. HomeCost Estimator for Excel 2.3
    Home construction cost estimating system for Excel with localized cost data
13. 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.
14. TreeDBNotes Pro 2.00
    PIM, Word Processor,Contact,Password Manager with Tree Structure (rtf,html,txt)
15. Excel Level 2 Lessons
    10 Lessons and 5 Workbook examples on Excel level 2
16. Personal Portfolio Manager 7.0.2
    Investment portfolio management and analysis for individual investors.
17. Portfolio Optimization 1.0
    The Portfolio Optimization model by Excel Business Tools
18. TorniaiSansUT Bold PC
    TorniaiSansUT Bold PC
19. Excel-to-MySQL
    a program to convert MS Excel spreadsheet into MySQL
20. Excel Level 1, 2 and 3 Training
    MS Excel Training for newsletter members only