Excel 2003

KnowledgeAir
Buffalo, New York, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Microsoft® Office Excel 2003 to manage, edit, and print data.

--------------------------------------------------------------------------------

Course Outline:

--------------------------------------------------------------------------------
Lesson 1; Getting Started with Excel An Overview of Excel

Navigate in Excel
Select Data
Enter Data
Save a Workbook
Obtain Help

Lesson 2: Modifying a worksheet

Move and Copy Data Between Cells
Fill Cells with Series of Data
Edit Cell Data
Insert and Delete Cells, Columns & Rows
Find, Replace, and Go To Cell Data
Spell Check a Worksheet

Lesson 3: Performing Calculations

Create Basic Formulas
Calculate with Functions
Copy Formulas and Functions
Create an Absolute Reference

Lesson 4: Formatting a Worksheet

Change Font Size and Type
Add Borders and Color to Cells
Change Column Width and Row Height
Merge Cells
Apply Number Formats
Create a Custom Number Format
Align Cell Contents
Find and Replace Formats
Apply an AutoFormat
Apply Styles
Lesson 5: Developing a Workbook

Format Worksheet Tabs
Reposition Worksheets in a Workbook
Insert and Delete Worksheets
Copy and Paste Worksheets
Copy a Workbook

Lesson 6: Printing Workbook Contents

Set a Print Title
Create a Header and a Footer
Set Page Margins
Change Page Orientation
Insert and Remove Page Breaks
Print a Range

Lesson 7: Customizing Layout

Split a Worksheet
Arrange Worksheets
Freeze and Unfreeze Rows and Columns
Hide and Unhide Worksheets

...''

Phone:866-322-3685

School Address:

KnowledgeAir Buffalo
726 Exchange St, Suite 628
Buffalo, NY 14210

KnowledgeAir Rochester
100 Allens Creek Road
Rochester, NY 14618


Jobs & Resumes: Buffalo
Houses & Roommates: Buffalo

Search other schools for Excel 2003 training resources.

E-mail Etiquette
Negotiating
Time Management
Personal Workflow System
Personal Branding
Personal Scorecard Workshop
The Habit Creature
Crystal Reports 11
Access 2003
Excel 2007
OneNote 2007
PowerPoint 2003
Word 2007
Illustrator CS3
InDesign CS3
Photoshop CS3
SQL Server 2005
Implementing a Microsoft SQL Server 2005 Database

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback.