|
|
|
|
|
|
This course is provided by Wintrac. Wintrac provides one stop shopping for all your IT training needs. Wintrac’s course catalog of over two thousand courses includes courses on Desktop Application Software training, E-Mail/Groupware training,
Office Suite training,
Operating Systems training,
Presentations training,
Spreadsheets training,
Web Browsers training and
Word Processing training
Overview
This course, Excel 2002 Level 1, is the first course in a series. This course will give you the skills to create, edit, format, and print basic worksheets and charts in Excel.
Course Objectives
You will create basic worksheets and charts.
Prerequisites
To ensure your success, we recommend you first take the following course or have equivalent knowledge:
- Windows 2000 : Introduction.
Target Student
Persons desiring to prepare to be a certified Microsoft Office User Specialist (MOUS) in Excel, and who already have knowledge of Microsoft Windows 98 or above operating system, and desire to gain the skills necessary to create, edit, format, and print basic worksheets and charts in Excel.
Performance-Based Objectives
Upon successful completion of this course, students will be able to:
- create a basic worksheet by entering text and values.
- work with cells and cell data by using a variety of moving
and copying techniques.
- perform calculations on data by using formulas, including
functions.
- change the appearance of worksheet data by using a variety
of formatting techniques.
- work with multiple worksheets by formatting, repositioning,
copying and moving, and adding and deleting worksheets within a workbook.
- create and modify charts.
- set the page display and printing options.
Certification
Microsoft
Excel 2002: Level 1 is one of a series of courseware titles that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more product proficiency exams in order to earn Office Specialist certification.
Internet and Computing Core Certification (IC3)
Excel 2002: Level 1 is one of four courseware titles that address the Module 2 (Key Applications) objectives of the Internet and Computing Core Certification (IC3) program. Modules 1 (Computing Fundamentals) and 3 (Living Online) objectives are addressed in other courseware titles. Certification candidates must pass three exams--one associated with each module--in order to earn IC3 certification
Delivery Method
Instructor-led, group-paced, classroom-delivery learning model with structured, hands-on activities.
Course duration
1 Day(s)
Course outline
Lesson 1: Getting
Started
- Topic 1A: Identify
What You Can Do with Excel
- Topic 1B: Enter Data
in a Worksheet
- Topic 1C: Edit Data
- Topic 1D: Change the
Appearance of Data
- Topic 1E: Save a Workbook
- Topic 1F: Obtain Help
Lesson 2: Editing
Your Worksheet
- Topic 2A: Moving Data
to Other Cells
- Topic 2B: Copy Data
to Other Cells
- Topic 2C: Fill Cells
with a Series of Data
- Topic 2D: Insert and
Delete Rows and Columns
- Topic 2E: Undo and
Redo an Entry
- Topic 2F: Find and Replace Numbers
- Topic 2G: Enter Data
in a Range
- Topic 2H: Verify Data
in a Range
Lesson 3: Performing
Calculations
- Topic 3A: Sum a Range
of Data
- Topic 3B: Use a Built-in
Function
- Topic 3C: Copy a Formula
- Topic 3D: Create an
Absolute Reference
Lesson 4: Formatting
- Topic 4A: Specify
Number Formats
- Topic 4B: Create a
Custom Number Format
- Topic 4C: Change Font
Size and Type
- Topic 4D: Apply Styles
- Topic 4E: Add Borders
and Color to Cells
- Topic 4F: Find and
Replace Formats
- Topic 4G: Change Column
Width and Row Height
- Topic 4H: Align Cell
Contents
- Topic 4I: Merge and
Center Cells
- Topic 4J: Apply an
AutoFormat
Lesson 5: Working
with Multiple Worksheets
- Topic 5A: Format Worksheet
Tabs
- Topic 5B: Reposition
Worksheets in a Workbook
- Topic 5C: Copy Worksheets
- Topic 5D: Change the
Number of Worksheets
Lesson 6: Creating
and Modifying Charts
- Topic 6A: Create a
Chart
- Topic 6B: Modify Chart
Items
- Topic 6C: Format a
Chart
- Topic 6D: Change the
Chart Type
Lesson 7: Setting
Page Display and Printing Options
- Topic 7A: Freeze Rows
and Columns
- Topic 7B: Set Print
Title
- Topic 7C: Set Page
Margins
- Topic 7D: Create a
Header and Footer
- Topic 7E: Change Page
Orientation
- Topic 7F: Insert and
Remove Page Breaks
- Topic 7G: Print a
Range
Appendix A: Common Problems Associated with Printing Appendix B: Microsoft
Office Specialist ProgramAppendix C: Internet and Computing Core Certification
(IC³) Program
Platform Requirements
Hardware Requirements
- A Pentium 133 MHz or higher processor required for all operating
systems.
- A minimum
of 64 MB of RAM, recommended, for Windows 2000 Professional; in addition,
you should have 8 MB of RAM for each application running simultaneously. (Note:
Memory requirements may differ for other operating systems.)
- A minimum of 516 MB of free hard disk space. (Under Windows
2000, at least 4 MB of space must be available in the Registry.)
- Either a local CD-ROM drive or access to a networked CD-ROM
drive.
- A floppy-disk drive.
- A two-button mouse, an IntelliMouse, or compatible pointing
device.
- A VGA or higher-resolution monitor; Super VGA recommended.
- An installed printer driver.
- A sound card.
Software Requirements
- A custom installation of Microsoft Office XP Professional—see the Class Setup Requirements for additional instructions.
|
|
|
|
|
