Software:Business & Finance:Spreadsheets > Name-Manager

"This Excel Add-in will allow you to easily and quickly create and manage all Excel named ranges and constants. You can delete all redundant or broken names, create named constants, dynamic named ranges (ideal for charts and Pivot tables), create Worksheet level names, consecutive named ranges and more.

Go to & View Excel Named RangesTo go to a range, you simply double click it.

Dynamic Named Range Index Sheet CreatorWill add a Worksheet to your Workbook that will list ALL your named ranges with clickable Hyperlinks for each. The index that is created is dynamic and will automatically update each time you select the Worksheet.

Hide Named Ranges From OthersOn this page you select all or some names that you want to hide.

Show or View Hidden Excel NamesYou then simply choose some/all to Unhide and click the Unhide button.

Delete Dead, Old, Redundant NamesBy accessing the Orphaned Names page. This page will only show those named ranges which have lost their reference. You can then either delete all, or some, or use the Add/Edit/Delete Names button to re-define them.

Create a Map on Worksheets of Your Named RangesAs the saying goes, ""a picture can paint a thousand words"".

Create Consecutive Named Ranges.This feature is a real time saver. There are times when it makes perfect sense to name related ranges with consecutive names. For example, you might have four separate ranges on the one Worksheet that represent each quarter of the year. After selecting the ranges, simply type the name quarter, click Create Names and you instantly get 4 named ranges, Quarter, Quarter2, Quarter3 and Quarter4. Or perhaps you have 52 ranges that represent the Weeks of the year. To do this manually would take quite a while, with the Name Manager it can be done in minutes!

Create Same Name Sheet Level Names.Sheet Level Names allow you to use the exact same name to refer to a range on many different Worksheets. For example, you can have the name ThisMonth represent the range A1:A10 on many different Worksheets. Then, if you used =SUM(ThisMonth) the SUM would always sum A1:A10 of the sheet the formula resides on. If using the sheet level named range in VBA code, it will always refer to the ActiveSheet at the time, assuming it has been specified.

Create Named Constants with ValuesNamed Constants are ideal for use in a large spreadsheet where common values are used in calculations. Once a name has been assigned to a value, the name can be used in formulae. For example if the number 0.15 (or 15%), with the text TaxRate, is a Named Constant with the value of 0.15 or 15%. This could then be used in calculations like =A1*TaxRate. Then, if the tax rate changes, you simply make the change to the Named Constant and all your formulae will update to reflect the new value.

Create Named Formulas in Excel SpreadsheetsNamed Formulas can be used to create your own custom functions. Once created, they save you having to re-enter the formula name, correct formula syntax, parenthesis and formula reference range over-and-over. The functions you can choose from are: AVERAGE, COUNT, COUNTA, COUNTBLANK, MAX, MIN and SUM.

Create Dynamic Named Ranges in Excel SpreadsheetsThe Dynamic Ranges page is arguably the add-ins most powerful and useful feature. Dynamic Named Ranges are ranges that will expand/contract according to the data in the range. The great part about this is your named ranges will only include those cells that house data. This makes them ideal for Pivot Tables, Charts, Validation Lists, and restricting formula calculations.

There are 8 different types of Dynamic Ranges you can create: Numbers Only, Text and Numbers, Last Text Entry, Last Numeric Entry, Monthly, Weekly, Day of Month, Linked to Single Cell."

Software:Business & Finance:Project Management > Vehicle Rentals Manager Software

"Rentals Manager is an easy to use vehicle rental package designed specifically for the vehicle rental industry, and especially for those with a diverse fleet of vehicles."" User Friendly"" - The software package has been designed to replace the typical manual system. Its ease of operation and user friendly interface ensures that the software shall become a powerful business tool for the management of your fleet....... "" Flexible"" - A wide range Flexible Reporting capabilities will ensure that all aspects of your business are readily available on-screen or as printed reports........ Rentals Manager has been designed to be user friendly, simple to use, yet powerful in functionality. The Vehicle Booking and Check-Out procedures are typical of the simple functionality of Rentals Manager. Simply enter the customer's name, address and license details... Enter the start and end dates for the rental.... Nominate the pick-up and drop-off locations and the method of payment. Then all you need to do is print the contract and save the booking. It is literally that simple............ ->Can you recall your customers license details instantly? YES! - > Can you see your vehicle usage instantly? YES! -> Can you recall an old contract instantly? YES! - ""Features Include"" -> Detailed Vehicle Data Base, -> Detailed Customer Data Base, -> Simple Customer Searches, -> Detailed Contract Printing, -> Unlimited Bookings, -> Calendar & Multiple Rental Rates, -> Detailed Vehicle Usage History... ""Fully Flexible Reporting on:"" -> Daily Activity Rentals by Source Rentals & by Sales Person, -> Rentals by Vehicle Income & by Payment Type, -> User Customisable Settings, -> Business Source, -> Salespersons, -> Pick-up Location & Drop-off Location, -> Payment Method, -> Customisable Reporting, -> Rental Contract Layout & Rental Contract Contents, -> Rental Contract Messages, -> Receipt Messages"

Software:Business & Finance:Spreadsheets > Formula and Text Manager for Excel

FORMULA MANAGER:The Formula Manager is designed to make the managing of all formulas a breeze. It can be used to map your spreadsheet by formula type. You can format the background color of all formulas that match the criteria you set. It a can also format the font of all formulas that match any criteria you set. Once applied, you can tell at a glance which cells contain formulas and which do not.

When you have a spreadsheet that contains formulas, you want to be sure that no user can delete, over-write or modify them. The Formula Manager can do this for you in seconds! Just specify which formula types to Lock, Hide or Lock and Hide. You can even protect the sheet in the same step! You can also easily Lock or Unlock all cells in one click.

The formula types you can specify for Formatting (font and/or background), Hiding and Locking are:Referencing other WorkbooksReferencing other sheets in WorkbookReferencing active sheet All types

The Formula Report Generator Allows you to very easily create a report showing formulas within your Workbook that are either external references, internal references or both. You can also nominate which Worksheet(s) to use to base your report on. The report that is generated contains, the formula as in the cell, the address of the cell and the sheet is resides on. Auto filter is also automatically applied for ease of reading.

Also included is a Formula Copy. This allows you to easily copy any formula range and paste it to a destination without any references changing. The option is the Transposing of formulas (row to columns and columns to rows) again, without any references changing.

File Size Reducer: FREE

TEXT MANAGER:The Text Manager will make working with text in your spreadsheet very easy. It is particularly useful for text which has been imported into Excel. You specify the range to affect, this can be specified cells or the entire sheet.

The Change Case lets you instantly change the case of your text. You can nominate to change your text to all UPPER CASE, all lower case, or Proper Case.

The Remove Character or Text can save you many hours of manually removing specific characters, or text, from specified text. You can even copy the characters to remove directly from the Windows Character Map. If the character or text you wish to remove is not available, simply check the Specify Character or Text option.

One very common problem with text (particularly imported text) is the unavoidable importing of spaces. Not only does this make your text unsightly and hard to read, but it can also prevent:

- Numbers not being seen as true numbers. - Dates not being seen as true dates. - Hard or impossible to break up text. - Hard or impossible to reference text. - Hard or impossible to use text in formulas.

You can remove all Leading spaces, Trailing spaces, Trailing and Leading spaces, or All spaces, except for single spaces between words.

Have some text you wish to concatenate (link together)? The Text Manager can do this is quickly and easily. Simply specify the cells to concatenate, then specify the cell to concatenate the text into and click OK. Your text will instantly be joined. You can also tell the Formula Manager to add a space between each cell that is joined.

Software:Home & Education:E-books & Literature > Business Correspondence - How to Write

"BUSINESS CORRESPONDENCE

HOW TO WRITE THE BUSINESS LETTER:

24 chapters on preparing to write the letter and finding the proper viewpoint; how to open the letter, present the proposition convincingly, make an effective close; how to acquire a forceful style and inject originality; how to adapt selling appeal to different prospects and get orders by letter-- proved principles and practical schemes illustrated by extracts from 217 actual letters.

Business Correspondence teaches correct  formats and practical approaches to basic office correspondence. The book is full of cases and comparison of various interpersonal styles, this book is an excellent practical resource for readers who need to master practical business writing and interpersonal skills.

http://www.goldenstarebooks.com/businesscorrespondence"

Software:Business & Finance > FastStart Human Resource Pack

This product contains more than ten highly useful Microsoft Excel templates to manage your HR activities effectively. Organize your workforce with these handy forms. The Human Resource Pack includes: Absence Report, Employment Application, Career Data Card, Employee Disciplinary Card, Performance Appraisal, Warning Form, Injury Claim Form, Interview Form, and Vacation Request Form.The Human Resources PackÂ’s ten spreadsheet solutions help you better organize your workforce. Get to know the numbers that effect your life and exercise tighter control over your personal finances. The Employee Information Form helps you track and record all the vital information on your company's employees. The I-9 Form, important to fill out in today's increasingly international environment, records citizenship status of new employees. The Vacation Request Form helps you figure out work schedules and keep your office covered. The Absence Report helps your track the frequency of absence of each of your employees. The Employment Application, Interview Form and Employee Performance Appraisal are forms to used to assist you in keeping track of your potential employees as well as your new hires. The FastStart Human Resources Pack targets the most common Human Resource Department tasks and will start you on the road to work force organization!

Software:Business & Finance:Personal Finance > QuoteLoader

IT Locus QuoteLoader is a software program that allows a customer to receive financial data and to accumulate for further analysis in the format accessible to the analytical applications.

IT Locus QuoteLoader software provides a universal interface to the main suppliers of stock quotes. Some of its features are listed below.

OS independence: IT Locus QuoteLoader software is Windows, UNIX, Linux, and MacOS compatible. It was designed using portable libraries with critical parts of the code optimized for a particular operating system. This makes it the best choice for organizing dealing centers based on free platforms like Linux or Free BSD.

Numerous commercial data sources supported IT Locus QuoteLoader has a built-in plugin support. To begin working with a particular data provider a user just has to subscribe for the data and to install the corresponding plugin.

Free data sources compatibility IT Locus QuoteLoader can be used for loading historical data from Yahoo Finance server ( For private noncommercial use)

Saving the data in different formats The data loaded by IT Locus QuoteLoader can be saved in all main formats such as ASCII, MetaStock and in databases having an ODBC interface. Switching between different formats is made by one mouse click. A conversion between formats, data import and synchronous data updating in different formats are possible.

Data management. The loaded data may be grouped in portfolios for further analysis