Software:Business & Finance:Spreadsheets > Number Manager

The number manager fills in the gaps in Excel when working with numbers. It allows you to add 15 different number formats that are not part of Excel's built in number formats. Retain leading zeros, show dollars and cents, Align all decimals, have negatives in brackets, hide negatives, positives, zeros, text, numbers, or all. There is even a Listbox where you can select anyone of 172 currency codes to format you numbers as USD25.00, AUD356.32 etc.

Ever had those stubborn numbers that Excel only sees as text? With the Number Manager all you do is click the Force To Numbers and the problem goes away.

The Round option on the Change Value tab allows you to instantly round up, round down or round to any specified number of decimal places. The Alter values can be used to increase, decrease, multiply or divide your numbers by any value or percentage.

The Convert/Remove tab is just the thing for those stubborn imported (or not) numbers and text. You can remove all text from a mix of text and numbers, remove all numbers from a mix text and numbers. A common problem with numbers being imported is some programs (SAP etc) bring in negatives as 100- instead of -100. Excel will see these as text and not negative values. With the Number Manager all you do is click a button and they are instantly put the right way. Another common issue is dates ending up as 010503 (01/05/03), 1503 (1/5/03) etc. Excel think these are numbers and not dates, meaning you cannot work with them. With the Number Manager you click a button and they are changed to become real dates that Excel does recognize.

Software:Business & Finance:Spreadsheets > Spreadsheet Consolidator

"

If your problem involves big volumes of Microsoft Excel spreadsheets and requirements for flexibility in consolidation then, Spreadsheet Consolidator is the accurate tool for you.

Spreadsheet Consolidator is an add-in for Microsoft Excel which will allow you to consolidate spreadsheet data from one or several sheets from one or many open workbooks, easily and quickly.

Save yourself a lot of time and effort, right now, downloading – for free - our trial software for you to test. You will be delighted!

In this new version 2.0 of Spreadsheet Consolidator, you will be able to:

• Consolidate ranges,
• Work into Excel 2007, because it is completely compatible with Office 2007.

Spreadsheet Consolidator is a part of Excel Model Builder wherefore, if you purchase this product you will be able to upgrade it paying only the difference.

Software:Business & Finance > Annotate!Pro

Communicate effectively with your colleagues. Draw on top of any program running on your desktop. Save a screenshot of your work to distribute for better communication.

Software:Business & Finance:Applications > EasyCustomers

"The program allows you to differentiate customers on the basis of criteria that are already available (profession, supervisor, info as to where a customer came from) and customer ""statuses"" introduced by the user. The program supports the personalized Email posting, export and import of information from Excel and operations with customer groups. Powerful search engine will help you to rapidly find the customer on the basis of any available information. To improve usability, the customer tree (hierarchy) is provided. The multi-user mode that enables to assign access permissions (to information and functions of the program) for various users is incorporated into the program."

Software:Business & Finance:Spreadsheets > Excel Level 1 Lessons

CURRENT SPECIAL Was $65.00 Now $29.95

These lessons have been written by OzGrid Business Applications who develop Excel spreadsheets on a professional basis. Each lesson is drawn from 'real world' experience and not made up class room scenarios. There are 10 lessons, each between 5 and 10 Word Document pages long, and 5 Workbook examples.

BASIC COURSE OUTLINE:

The Fundamentals of Excel, Cut, Copy, Insert, Delete, Paste Special, Custom Formatting, Undo, Redo, Excel Formulas - The least you should know, Useful functions and Paste Function, Calc, Comments, Drawing toolbar, Edit Replace, Delete Clear, Essential Printing, Data Sorting, Hiding, AutoFormats, Protection, Basic Charts, Basic Formatting, If Function.

WHY USE US FOR EXCEL TRAINING?

Like all our products and services, OzGrid training will cater to your specific needs. OzGrid specializes in Microsoft Excel, this is all we do! Over time we have focused our business directly towards Excel. Other training companies will offer training in many different Applications, and while they may supply information from good trainers it is very unlikely the trainers will know Excel to the extent we do! Remember we develop Excel spreadsheets in our day-to-day business so we know what you will encounter in your day-to-day use of Excel. We are not just Excel teachers, but also Excel developers!

Software:Business & Finance:Personal Info Managers > MilePro

MilePro facilitates the retrieval of your account data from all major loyalty programs, simultaneously! Personal data is entered just once & remains on your own computer. Retrieves summaries, activity, elite level and upgrade status. Editorial content helps maximize your mileage-earning opportunities. Supports multiple users with new features added regularly.