Excel and Excel VBA Tips and Tricks

Tips and Tricks for Excel Workbook, plus free add-in demos

Description of Excel and Excel VBA Tips and Tricks:

See 33+ Workbook Examples To Save Even More. Copy this URL into your address bar: https://www.regnow.com/softsell/nph-softsell.cgi?item=7924-15

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

See Also: All products from OzGrid Business Applications

1. Significant Digit Assistant for Microsoft Excel
   One of the key functions that Microsoft left out of Microsoft Excel is one that rounds values to the number of significant digits that you wish to use. The Significant Digit Assistant adds this function to Excel!
2. CZ-Xls2Txt COM
   CZ-Xls2Txt COM is a COM component/object designed to assist you, the developer, to quickly add a powerpoint document conversion utility to your application. It can be called from VB, VC, DELPHI.
3. Spreadsheet xlNavigator 2003 TM
   Intuitive display of Spreadsheet cell dependencies
4. OM-MULTIMON
   Excel Spreadsheet Template for Ratio-to-moving-average seasonal adjustment
5. RepairCost Estimator for Excel 2.5
   Repair and restoration construction cost estimating system for Excel
6. CZ Excel Converter
   CZ Excel Converter is the award-winning, powerful batch document converter that converts between XLS, HTML, XML, MTH, CSV, TEXT, DBF, Lotus 1-2-3, WKS, WQ1, SLK, DIF and more! The software supports batch conversion, command line and folder watcher.
7. Master Budgets PRO
   Excel workbook containing 20 budgeting and reporting spreadsheets consolidated into a Master YTD report
8. Excel to Pdf Converter 3000
   Excel to Pdf Converter 3000 provides the fast, affordable way to free create professional-quality documents in the popular PDF file format.
9. Name Splitter for Microsoft Excel
   quickly and easily split names that are in one cell into individual names in individual cells.
10. Time Sheet Advanced Open Source
    With this version the password for the Worksheets and the VBA code is supplied. This extremely easy and simple to use Excel Time Sheet will keep track of your employees hours.
11. PCFolio
    Track your Gain/losses, average amount paid for securities, amounts invested, total commissions paid and more. Profit and losses and the portfolio s balance are computed live using current prices obtained free from the Web.
12. TorniaiSansUT BlackItalic PC
    TorniaiSansUT BlackItalic PC
13. OzGrid excel Addins Collection
    Excel add-ins Collection
14. Richworks.Now
    Personal Finance Manager
15. Budget Advisor 2.01
    An easy way to keep track of your monthly budget.
16. Loan Amortization - for Windows 3.1
    Loanamor.EXE - This program is a standard amortization schedule which displays annual interest paid for your use at tax time and it can also be used for any simple interest loan with multiple payment periods.
17. Excel OzGid Plus With Duplication Manager
    The OzGrid plus and Duplication Manager bundled.
18. Biweekly Amortization - for Windows 3.1
    Biweekly.EXE - This program calculates and displays the reduced loan period and total payment with this type mortgage.
19. Retirement Investment Required - for Windows 3.1
    Retirinv.EXE - You can calculate the amount of money you need to be investing monthly to provide a monthly withdrawa supplemented by Social Security, pensions, annuities or other income sources.
20. Variable Rate Mortgage - for Windows 3.1
    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.