ECDL/ICDL: Spreadsheets v 4.0

ExecuTrain
Alpharetta, Georgia, 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. This training, which has been approved by the ECDL Foundation, includes exercise items intended to assist ECDL Candidates in their training for ECDL. These exercises are not ECDL certification tests. For information about authorized ECDL Test Centers in different national territories, please refer to the ECDL Foundation website at www.ecdl.com

Objectives:
In this course, you will create and edit basic Microsoft® Office Excel 2003 worksheets and workbooks.
Hardware and Software Required:
Browser Firefox 1.x
Browser Other: Safari 1.x
Browser Microsoft Internet Explorer 6.0
Operating SYSTEM MacOS X 10.3.x
Operating SYSTEM MS-Windows XP, 2000, OR 2003 server
Flash Player 8
Pentium III WITH 500 MHz
128MB RAM
256K connection (broadband recommended)

Table of Contents:

Course Introduction

Course Introduction

Getting Started with Excel

Lesson Introduction

Explore the Excel Window

Select Data

Insert and Delete Data

Save a Workbook

Work with Multiple Workbooks

Use the Help Feature

Change the Excel Window Layout

Change the Excel Settings

Lesson Follow Up

Manipulating Data

Lesson Introduction

Edit Data

Copy and Move Data Between Cells

Copy and Move Data Between Worksheets

Copy and Move Data Between Workbooks

Fill Cells with Series of Data

Find and Replace Data

Sort Data

Lesson Follow Up

Working with Cells

Lesson Introduction

Insert and Delete Columns and Rows

Freeze and Unfreeze Columns and Rows

Change Column Width and Row Height

Lesson Follow Up

Managing Worksheets

Lesson Introduction

Manipulate Worksheets

Copy and Move Worksheets Within Workbooks

Copy and Move Worksheets Across Workbooks

Lesson Follow Up

Calculating Data

Lesson Introduction

Create Basic Formulas

Calculate Data Using Functions

Calculate with Logical Functions

Create Relative Cell References

Create Absolute Cell References

Create Mixed Cell References

Lesson Follow Up

Formatting a Worksheet

Lesson Introduction

Change Font Type, Size, and Style

Apply Borders and Shading

Merge Cells

Format Numeric Data

Align Cell Contents

Lesson Follow Up

Creating and Modifying Charts

Lesson Introduction

Create a Chart

Format Chart Items

Change the Chart Type

Copy and Move Charts

Lesson Follow Up

Printing a Workbook

Lesson Introduction

Preview a Worksheet

Change Sheet Layout

Create and Modify Header and Footer

Set Page Margins

Set Page Layout

Print a Workbook

Lesson Follow Up


...''

Phone:1-800-908-7246

School Address:



Jobs & Resumes: Alpharetta
Houses & Roommates: Alpharetta

Relational Database
SAP R/3 V4.0: User Basics
Security Awareness
StarOffice 5.1
PC Maintenance and Troubleshooting
WordPerfect 12
ECDL/ICDL: Concepts of Information Technology (IT) v 4.0
ECDL/ICDL: Databases v 4.0
ECDL/ICDL: Information and Communication v 4.0
ECDL/ICDL: Presentations v 4.0
ECDL/ICDL: Word Processing v 4.0
ASP.NET: Using Visual C#, ADO.NET, and XML
ASP.NET: Using VisualBasic.NET, ADO.NET, and XML
Configuring and Managing Microsoft® Exchange Server 2003
Configuring and Managing Project Server 2003
TCP/IP
Upgrading Web Development Skills from ASP to Microsoft ASP.NET
ADO.NET
Creating ASP.NET Web Applications

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: Schools can use this unlimited free web marketing service by submitting their course descriptions and school introductions. Two outbound links will be granted to each posting.