Knowledge Transfer Microsoft Certified Training Partner CTEC
Knowledge Transfer is a Microsoft Certified Gold Partner
Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training
 

 

 



 Course Search
Keyword
Course #
State

 Training Delivery
 
Training Delivery
Custom Curriculum
Course List
 
 Main Menu
 
Home
View Courses
Site Index
 
 


Microsoft Excel 2007 Level 1 Overview


Getting Started with Office 2007 

  • Understanding the Office 2007 Suite
  • Starting and Exiting an Office Program
  • Viewing the Office 2007 User Interface
  • Creating and Saving a File
  • Opening a File and Saving it with a New Name
  • Viewing and Printing your Work
  • Getting Help and closing a file

Getting Started with Excel 2007

  • Understanding Spreadsheet Software
  • Touring the Excel 2007 Window
  • Understanding Formulas
  • Entering Labels and Values and Using AutoSum
  • Editing Cell Entries
  • Entering and Editing a Simple Formula
  • Switching Worksheet Views
  • Choosing Print Options

Working with Formulas and Functions 

  • Complex Formulas
  • Inserting a Function
  • Typing a Function
  • Copying and Moving Cell Entries
  • Understanding Relative and Absolute Cell References
  • Copying Formulas with Relative Cell References
  • Copying Formulas with Absolute Cell References
  • Rounding a Value with a Function 

Formatting a Worksheet 

  • Formatting Values
  • Changing Font and Font Size
  • Changing Attributes and Alignment
  • Adjusting Column Width
  • Inserting and Deleting Rows and Columns
  • Applying Colors, Patterns, and Borders
  • Applying Conditional Formatting
  • Naming and Moving a Sheet
  • Checking Spelling

Working with Charts 

  • Planning a Chart
  • Creating a Chart
  • Moving and Resizing a Chart
  • Changing the Chart Design
  • Changing the Chart Layout
  • Formatting a Chart
  • Annotating and Drawing on a Chart
  • Creating a Pie Chart 

Analyzing Data Using Formulas and Functions

  • Formatting Data Using Text Functions
  • Summing a Data Range Based on Conditions
  • Checking Formulas for Errors
  • Constructing Formulas Using Named Ranges
  • Building a Logical Formula with the IF Function
  • Building a Logical Formula with the AND Function
  • Calculating Payments with the PMT Function

 

View Printer Friendly Page

Course Schedule
  Start Date  City  Price  
 1/19/2009
 $199
Enroll
 2/9/2009
 $199
Enroll
 3/12/2009
 $199
Enroll

To Inquire About Future Classes

Request a class date

if one is not scheduled.