Microsoft Excel 2007
Class 1: Introduction and Beyond
| Duration: | 1 day (7 hours) |
| Prerequisite: | Basic knowledge of the windows environment, basic keyboard skills |
| Course Materials: | Course manual with CD containing exercises |
| Prices: | $195 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student |
| Description: | In this first Excel class, you'll get acquainted with Excel's interface and learn the basic techniques for creating spreadsheets and entering and organizing data. You'll learn how to format your work to make it more presentable. You'll also be introduced to Excel's most important feature—formulas. You'll learn how to perform calculations and even start working with some simple functions. |
Creating and Navigating Worksheets
- Excel's New Interface
- Creating a Basic Worksheet
- Editing Data
- Navigating in Excel
- Saving Files
- Opening Files
Adding Information to Worksheets
- Adding Different Types of Data
- Quick Ways to Add Data
Moving Data Around a Worksheet
- Selecting Cells
- Moving Cells Around
- Adding and Moving Columns or Rows
Managing Worksheets and Workbooks
- Worksheets and Workbooks
- Find and Replace
- Spell Check
Formatting Cells
- Formatting Cell Values
- Formatting Cell Appearance
Smart Formatting Tricks
- The Format Painter
- Styles and Themes
- Conditional Formatting
Fundamentals of Formulas
- Creating a Basic Formula
- Arithmetic, Comparison, and Reference Operators
- Copying Formulas
- Using the AutoSum Feature
- Relative and Absolute Cell References
- Working with 3-D (External) References
Viewing and Printing Worksheets
- Controlling Your View
- Printing
- Controlling Pagination