Business - Spreadsheets

Excel Basic, Intermediate and Advanced Training v.1

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 30 lessons, each between 5 and 10 Word Document pages long, and 15 Workbook examples. There is also online Microsoft Pivot Table tutorial.

United States ZIP Code Database (Gold + Multi-County Edition) May.2008

United States ZIP codes database one month subscription service. The database includes ZIP code, city name, alias city name, state code, phone area code, city type, county name, country FIPS, time zone, day light saving flag, latitude, longitude, county elevation, MSA, PMSA, CBSA and Census 2000 data in United States. The complete database contains over 76,000 precise records. Immediate download available in several formats ie. ASCII text, Microsoft Excel, Microsoft Access and dBASE V.

Portfolio Optimization v.1.0

The Portfolio Optimization model calculates the optimal capital weightings for a basket of investments that gives the highest return for the least risk. The unique design of the model enables it to be applied to either financial instrument or business portfolios. The ability to apply optimization analysis to a portfolio of businesses represents an excellent framework for driving capital allocation, investment, and divestment decisions.

Portfolio Performance Monitoring v.1.0

The Portfolio Monitoring model enables the ongoing monitoring and periodic valuation of a portfolio of investments. The model allows the entering of investment transactions during a reporting period to calculate performance. Furthermore, incremental investment transactions undertaken during a period are fully accounted for in the period's performance calculations.