Lesson 2: Entering Excel Formulas and Formatting Data

Lesson 1 familiarized you with the Excel 2007 window, taught you how to move around the window, and how to enter data. A major strength of Excel is that you can perform mathematical calculations and format your data. In this lesson, you learn how to perform basic mathematical calculations and how to format text and numerical data.

• Set the Enter Key Direction
• Perform Mathematical Calculations
• AutoSum
• Perform Automatic Calculations
• Align Cell Entries
• Perform Advanced Mathematical Calculations
• Copy, Cut, Paste, and Cell Addressing
• Insert and Delete Columns and Rows
• Create Borders
• Merge and Center
• Add Background Color
• Change the Font, Font Size, and Font Color
• Move to a New Worksheet
• Bold, Italicize, and Underline
• Work with Long Text
• Change a Column's Width
• Format Numbers

Posted in: Microsoft Excel 2007 Tutorial — Free