Microsoft Excel is an electronic spreadsheet that runs on a personal computer. You can use it to organize your data into rows and columns. You can also use it to perform mathematical calculations quickly. This tutorial teaches Microsoft Excel basics. Although knowledge of how to navigate in a Windows environment is helpful, this tutorial was created for the computer novice. This lesson will introduce you to the Excel window. You use the window to interact with Excel.
The Microsoft Excel Window
Moving Quickly Around the Microsoft Excel Worksheet
Selecting Cells
Entering Data
Editing a Cell
Changing a Cell Entry
Wrapping Text
Deleting a Cell Entry
Entering Numbers as Labels or Values
Smart Tags
Saving a File
Closing Microsoft Excel
Lesson 2: Formatting Text and Performing Mathematical Calculations
Lesson 1 familiarized you with the Excel 2007 window. 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.
Choosing a Default Font
Adjusting the Standard Column Width
Cell Alignment
Adding Bold, Underline, and Italic
Changing the Font, Font Size, and Font Color
Working with Long Text
Changing a Single Column Width
Moving to a New Worksheet
Setting the Enter Key Direction
Making Numeric Entries
Performing Mathematical Calculations
The AutoSum Icon
Automatic Calculation
Formatting Numbers
More Advanced Mathematical Calculations
Cell Addressing
Deleting Columns
Deleting Rows
Inserting Columns
Inserting Rows
Creating Borders
Merge and Center
Adding Background Color
Using Auto Format
Saving Your File
Closing Microsoft Excel
Lesson 3: Numbers and Mathematical Calculations
By using functions, you can quickly and easily make many useful calculations, such as finding an average, the highest number, the lowest number, and a count of the number of items in a list. Microsoft Excel has many functions you can use. This lesson teaches you how to use functions and how to print.
Reference Operators
Functions
Typing a Function
Calculating an Average
Calculating Min
Calculating Max
Calculating Count
Filling Cells Automatically
Printing
Print Preview
Saving Your File
Closing Microsoft Excel
Lesson 4: Creating Charts
In Microsoft Excel, you can represent numbers in a chart. This lesson teaches you how to create a chart in Excel.
Creating a Column Chart
Changing the Size and Position of a Chart
Modify Your Chart
Saving Your File
Closing Microsoft Excel
