Knowledge Transfer Microsoft Certified Training Partner CTEC
Knowledge Transfer is a Microsoft Certified Gold Partner
Microsoft Certified Gold Training Partner
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 2010 Level 1 Overview


Unit 1: Getting started

  • Topic A: Spreadsheet terminology
  • Topic B: The Excel environment
  • Topic C: Getting help
  • Topic D: Navigating a worksheet

Unit 2: Entering and editing data

  • Topic A: Entering and editing text and values
  • Topic B: Entering and editing formulas
  • Topic C: Working with pictures
  • Topic D: Saving and updating workbooks

Unit 3: Modifying a worksheet

  • Topic A: Moving and copying data
  • Topic B: Moving and copying formulas
  • Topic C: Absolute and relative references
  • Topic D: Inserting and deleting ranges, rows, and columns

Unit 4: Using functions

  • Topic A: Entering functions
  • Topic B: AutoSum
  • Topic C: Other common functions

Unit 5: Formatting

  • Topic A: Text formatting
  • Topic B: Row and column formatting
  • Topic C: Number formatting
  • Topic D: Conditional formatting
  • Topic E: Additional formatting options

Unit 6: Printing

  • Topic A: Preparing to print
  • Topic B: Page Setup options
  • Topic C: Printing worksheets

Unit 7: Charts

  • Topic A: Chart basics
  • Topic B: Formatting charts

Unit 8: Managing large workbooks

  • Topic A: Viewing large worksheets
  • Topic B: Printing large worksheets
  • Topic C: Working with multiple worksheets

Unit 9: Graphics and screenshots

  • Topic A: Conditional formatting with graphics
  • Topic B: SmartArt graphics
  • Topic C: Screenshots

 

 

View Printer Friendly Page

Course Schedule
  Start Date  City  Price  
 8/2/2017
 $199
Enroll
 8/2/2017
 $199
Enroll
 10/10/2017
 $199
Enroll
 10/10/2017
 $199
Enroll
 12/7/2017
 $199
Enroll
 12/7/2017
 $199
Enroll

To Inquire About Future Classes

Request a class date

if one is not scheduled.