Entering and Editing Text and Values

After you create a workbook, you can begin entering data in cells. Cell entries can include many types of data, including text and values. When you type, data is entered in the active cell.

Text and values

Text entered in cells can be any length required, and it can be formatted just as in a word processing program; size, font, and style can all be changed. By default, text in a cell is left-aligned.

Values can include numbers, formulas, and functions. Excel recognizes cell data as a value when it's a number or when it begins with +, -, =, @, #, or $. By default, a value in a cell is right aligned.

Overflowing text and values

If a long text string doesn't fit in a cell, it will appear to go into the next cell if that cell is empty. The text ins't really in that next cell, though. If there is data in that next cell, the long string of text is truncated to fit the cell it's in.

If a long value doesn't fit in a cell, Excel displays a row of # characters. This indicates that the cell is too narrow to display the value.

The Num Lock key

The numeric keypad, on the right side of most computer keyboards, is controlled by a Num Lock key in the upper-left corner of the keypad. Press Num Lock once to switch the keypad from functioning as numeric keys to functioning as navigation keys. Press Num Lock again to return to numbers. When numbers are active, a Num Lock light typically lights on the keyboard.


CBT Planet Offers Microsoft Office and Excel 2007 Training

CBT Planet offers a world of computer based training courses ranging from IT certification to soft skill training. One of the most popular categories revolves around the Microsoft Office 2007 suite. With the complete redesign of Office comes an increased need for training. Not only do new users need help getting up to speed, existing Office users do as well.

Office 2007 CBT training makes mastering the various applications such as Word, Excel, PowerPoint, and Access a simple matter of watching instructor-led training videos and participating in interactive, computer based activities. Step-by-step demonstrations with clear explanations help users to understand each task. By seeing the software in action and hearing expert narration, students experience Microsoft Office the way it was meant to perform.

A simulated Office 2007 environment and hands-on labs reinforce the learning and give practical experience. Students learn how to navigate the software and use the features by seeing and doing.

CBT Planet carries a variety of Office courses in licenses that meet just about every need imaginable. From individual courses such as Word 2007 or Excel 2007 trainingand IT certification courses emphasizing Office deployment tasks to corporate libraries loaded with all of the Office titles, CBT Planet delivers.

What's it like using a computer based training course? Let's take a look at an Excel tutorial as an example. If someone in your organization needs Excel 2007 skills, instead of sending him offsite for training classes, keep him at his desk where he can study and participate without ever leaving the office. He'll learn spreadsheet concepts and how to use the features of Excel from a certified instructor. He learns at his own pace and can start and stop the training at will. If an important client needs his assistance, your employee can suspend his training to troubleshoot the client's problem and then return to his training afterwards. Not only is your employee gaining valuable Excel skills, he is still accessible should you need him.

The flexibility of Microsoft Excel training extends to individuals who need to update their skills. Anyone who needs to master Office can do it with help from CBT Planet.