EXCEL 2003:
LEVEL1
► Click here for Excel Level 2
Course Objectives:
You will
create and edit basic Microsoft Office Excel 2003 worksheets and
workbooks
Target Students:
This
course is designed for persons preparing for certification as a
Microsoft Office Specialist in Excel, who already have knowledge
of the Microsoft Office Windows 98 (or above) operating system,
and who desire to gain the skills necessary to create, edit,
format, and print basic Microsoft Excel 2003 worksheets.
Pre-requisites:
To ensure your
success, we recommend you first take the following Element K
course or have equivalent knowledge: Windows: Introduction
|
Course Content:
|
|
-
Getting Started with
Excel
An
Overview of Excel
Navigate
in Excel
Select
Data
Enter
Data
Save a
Workbook
Obtain
Help
-
Modifying a Worksheet
Move and
Copy Data Between Cells
Fill
Cells with Series of Data
Edit
Cell Data
Insert
and Delete Cells, Columns, and Rows
Find,
Replace, and Go To Cell Data
Spell
Check a Worksheet
-
Formatting a
Worksheet
Change
Font Size and Type
Add
Borders and Colour 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
-
Developing a Workbook
Format
Worksheet Tabs
Reposition Worksheets in a Workbook
Insert
and Delete Worksheets
Copy and
Paste Worksheets
Copy a
Workbook
-
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
-
Customizing Layout
Split a
Worksheet
Arrange
Worksheets
Freeze
and Unfreeze Rows and Columns
Hide and
Unhide Worksheets
|
| |
Benefits
Duration:
1 Day
► Click here for Excel Level 2
