|
Excel and Excel VBA Tips and Tricks
Software:Business & Finance:Spreadsheets > Excel and Excel VBA Tips and Tricks
"10 Day Money Back Guarantee. 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 Solutions: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-inFormula Ref Sheet Index Add-inOzGrid Excel Plus Add-inTime Wage and PaybookOzGrid Add-in Collection"
» Related Software
Visual eNote
Software:Business & Finance:Personal Info Managers > Visual eNote
"Visual eNote is one of the most popular, virtual-sticky-note program. Visual eNote is a featured remind software and scheduler program for Windows. It can help you keep in mind important information by displaying skinnable sticky note on your Windows desktop or send to the desktop of any other PC that on the network. 1. Powerful Network Reminder - you can send reminder or note via Visual eNote / Windows Message / PC NAME / IP / MAC / eMail to colleague and friend on the network, and you can instant message send with them 2. Powerful Customize-Remind - you can set reminded alarm time as you like for every important note; set expiration dates to automatically trash old note 3. Easy and Visual multi-level Organize & Management - you can Organize & Management Notes Reminders and Linkman via Visual eNote Manager 4. Security Protect User Data - User can set a password to logon Visual eNote, Even on same PC, different users can use their own separate password to logon, also can password security protect for every Notes 5. Powerful and Convenient Editing and Typesetting - Including note size, note color, font size, font color and priority, set Transparency, 3D setting, Main color of the interface, Zoom and etc 6. Convert Document file to Note - The content of Word and TXT files can be easily convert as the text content of Note, add many attachments 7. Custom-self Reminder Sound - You can set the prompt sound of receiving Note (allowing use-defined select). For different linkmen, users can appoint different prompt sound and different default storing position 8. Powerful Search function, Reminders without the clutter 9. etc. The functionality of Visual eNote suits it for home or business users. It can help you keep in mind important information by displaying skinnable sticky note on your Windows desktop or send to any other PC on the network. This is a great tool for instant communication with colleagues and friends, or for use in a small office or over a home LAN. ******************************************************************************************** Desktop Edtion - Designed for personal or home use. None Network & Linkman Functions. Standard Edtion - Designed for office, LAN, corporation, school, non-commercial or personal use. All Functions."
AceNotes
Software:Business & Finance:Personal Info Managers > AceNotes
AceNotes is the Ultimate Personal information Manager (shareware) that lets you manage and store all your information quickly, clearly and easily. It also can recover anything you store with its powerful built-in search facility. You will never again forget or lose important information.
BuilderPACK Advantage for Excel
Software:Business & Finance:Project Management > BuilderPACK Advantage for Excel
ACCURATE ESTIMATING, EFFECTIVE EXPENSE TRACKING. Combo package includes: HomeCOST Estimator for Excel and JobCOST Controller for Excel. HomeCOST Estimator: Designed for builders, contractors, architects, real estate professionals and insurance adjusters. With built-in modifiable data for local city indexes, class of construction, type and style factors, typical upgrade and additional feature prices and selections made using a wizard interface, HomeCOST Estimator is an indispensable tool for creating fast and accurate home valuation estimates. JobCOST Controller for Excel: Designed for contractors, builders, remodelers, project managers, cost engineers and architects, JobCOST Controller tracks construction costs tied to user-defined cost categories. Reports budgets, actuals and committed costs. Accurately forecasts costs at job completion, reports variances, alerts for over and under budget activities. Product registration will entitle you to lifetime free software updates.
HandyDB .NET
Software:Business & Finance:Inventory Systems > HandyDB .NET
With HandyDB .NET you can create a Pocket Access database wich is compatible with MS Access desktop computer database, this means that all database created on-the-move in your PocketPC using HandyDB .NET can easily transfered to your desktop using MS ActiveSync. When you transfer your Database to your PC you can edit or modify available records on desktop and re-Sync to your Pocket PC to keep the changes with you.
PocketShop for Windows Only (i.e., Not Pocket PC)
Software:Business & Finance:Personal Finance > PocketShop for Windows Only (i.e., Not Pocket PC)
Create shopping lists quickly and easily! Track coupons, pricing, and print out shopping list arranged by store and aisle. A Pocket PC version is also available, but this specially reduced price allows you to register JUST the Windows version, not the Pocket PC software. (If you've got a Pocket PC, please choose PocketShop for Pocket PC.)
|