Excel Download Package

	Home	Product	Features	Site Map	Resources	Privacy	Contact

Categories

Applications

Business Finance

Database Management

Email & News Convertor

Inventory Systems

Multimedia & Design

Personal Finance

Personal Info Managers

Presentation Tools

Project Management

Software Development

Spreadsheets

Web Authoring & Development

Word Processing

Multiple Regression Analysis
The Multiple Regression Analysis and Forecasting template provides a solid...

EXCEL to MySQL
Access-to-MSSQL is a program to move MS Access databases to MS SQL server....

MSSQL to EXCEL
Access-to-MSSQL is a program to move MS Access databases to MS SQL server....

MYSQL to Excel
MSSQL-to-Excel is a program to publish Microsoft SQL databases as Microsoft...

Project Management - Excel Business Tools
The Project Planning and Management excel template is designed as a generic...

Home : Business Finance : SpreadSheet :

Excel Download Package

Excel Download Package offers 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, Excel VBA Tips and Tricks, and much more.

Main features and benefits:

Covers topics: 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.
Includes "Excel and Excel VBA Tips and Tricks" collectes special tips on Conditional Formatting, Vlookup, Validation, Dynamic Ranges within a range and some slick uses for Checkboxes.

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 is a way to create a dynamic "Sheet Navigator" that is added to the standard right click Pop-up menu.
Time Saving Microsoft Excel Solutions is a downloadable book in a Windows help file format that contains hundreds of solutions to Microsoft Excel problems. And it is free.