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.
Downloads: 64880 - Demo - Download Now
Save each row or column as a text file in one or many MS Excel files. Each cell in a text file can be separated by an enter, comma-space, comma, space, etc. Excel 2000 or higher required.
Downloads: 82409 - Shareware - Download Now
Batch Search and Replace multiple Excel spreadsheets. Change hyperlinks and UNC paths when servers get renamed, update names, addresses, phone numbers, data sources, translate with find/replace lists. Automatically handles passwords
Downloads: 65591 - Shareware - Download Now
Delete / remove formulas in Excel cells and replace them with the actual value of the cell. This can be applied to a block of selected cells all at once.
Downloads: 39877 - Shareware - Download Now
Move decimal place left or right in block of selected cells in MS Excel. Excel 2000 or higher required.
Downloads: 53977 - Shareware - Download Now