Lesson 1: Entering Text and Numbers
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.
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.
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.
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.
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
