MS-Excel - 2003 Tutorials

he tips in this tutorial are designed to take some of the drudgery out of doing data entry by helping you work more efficiently and, at the same time, more accurately.

Although Excel comes stocked with a wide variety of built-in functions, some of which are pretty specialized, they don't begin to cover all the types of specific computations you need to perform.

Spreadsheets are full of them, and because they don't get there by magic, it behooves you to know all the tricks of the trade for entering them as efficiently as possible.

Here you find out how to max out the worksheet display so that you access as many cells and as much of your spreadsheet data as possible.

Excel's macro feature records all the commands and keystrokes that you make in a language called Visual Basic for Applications (VBA).

Find out how you can speak your spreadsheet data entries as well as voice your Excel commands (it feels really good to tell a computer where to go!).

This tutorial covers the creating and editing of all these types of hyperlinks.

How to automate lookups in a worksheet table. The magic of being able to retrieve values from long boring schedules of numbers for use in other formulas without having to actually find the cell reference myself was quite thrilling.

Excel includes a powerful feature known as Text to Speech that can help you through the drudgery of checking and verifying the accuracy of your data entries.

This tutorial covers how to use the data form that Excel automatically creates for any data list you generate to add, edit, and find the information you need to maintain.