| |
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
|
|