Home    About Us     Services     Contact Us

Hosting
Professional Development
Computer Applications
 
Phone:  306.781.0360
Fax:  306.781.0369

 Email Us
 
Microsoft Office
Microsoft Office Microsoft Office Specialist
Internet and Computing Core Specification

- Access 2007 Advanced

- Access 2007 Expert

- Outlook 2007 Advanced

- Outlook 2007 Expert

- Power Point 2007 Advanced

- Power Point 2007 Expert

- Excel 2007 Fundamentals

- Excel 2007 Advanced

- Excel 2007 Expert

- Word 2007 Fundamentals

- Word 2007 Advanced

- Word 2007 Expert

Excel 2007 Fundamentals

Course description
Overview: Student will learn basic commands, functions, and capabilities of Microsoft Excel 2007.

Prerequisites: Introduction to computers or equivalent knowledge.

Benefits: Students will learn how use an electronic spreadsheet to create basic data reports.

Objectives

  • Start and run Microsoft Excel 2007

  • Use a mouse to select from menus, toolbars, prompts and screens

  • Enter, edit and format information on the worksheet

  • Enhance worksheets with fonts and borders

  • Design and build sample worksheets

  • Freeze the titles on large worksheets

  • View different parts of a worksheet simultaneously

  • View several worksheets at one time

  • Print worksheets

  • Exit and save your session

Course content

Introduction
Overview
Looking at the Excel Screen
Handling Files
Entering data
Summary

Using the Worksheet
Editing cell contents
Copying and Moving data
Adjusting Column widths or Rows
Inserting and Deleting Rows and Columns
Summary

Formulas & Common Functions
Creating and Editing Simple Formulas
Using Common Functions With Cell Ranges
Using Absolute & Relative Cell References
Managing Worksheets
Summary

Formatting Worksheets
Formatting a Cell

Clearing Cell Contents and Formatting
Using AutoFormat
Formatting Worksheets

Looking at Windows & Printing
Previewing the Worksheet
Adding Page Breaks
Customizing the Printout
Printing the Worksheet
Using Window Panes
Summary

Working with Charts
Basic charting
Selecting chart types
Working with pie charts
Printing Charts
Adding New Data
Summary


 

                      Home    About Us     Services     Course Calendars    Contact Us

 

copyright 2005 INtouch Career College

site designed by 24-7 INtouch call center provider