Microsoft Excel 2007 Level 1,
Introduction and Beyond
| Duration: | 1 day |
| Prerequisite: | Basic knowledge of the windows environment, basic keyboard skills |
| Course Materials: | Course manual with CD containing exercises, 136 pages |
| 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: | This class covers the basic concepts of Microsoft Excel 2007 with working with charts, formulas, and functions. The manual is recognized as a Microsoft Approved Study Guide for the Microsoft Office Specialist Program Certification Exam. The manual is also a great reference for after the class. |
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
Formula Shortcuts
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