MS EXCEL

 

Information on Microsoft Computer Training Courses in South Africa for Ms Exel

 
 

Microsoft Excel

MS Excel 2002: Level 1

Microsoft Excel Course Specifications

Duration: 1 day

MS Excel Course Description

Overview:
Students will create, edit, format and print basic worksheets and charts in Microsoft Excel.

Prerequisites:
Windows 2000: Introduction

Delivery Method:
Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.

Benefits:
Students will learn how to use an electronic spreadsheet to create basic worksheets and charts.

Target student: 
The target student for this course is a user who has worked with personal computers and used Windows to manage information, run programs, and access the Web.

Performance-Based Objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

  • You will create a basic worksheet by entering text and values.

  • You will work with cells and cell data by using a variety of moving and copying techniques.

  • You will perform calculations on data by using functions and formulas.

  • You will change the appearance of worksheet data by using a variety of formatting techniques.

  • You will use a variety of techniques to manipulate multiple worksheets in a workbook.

  • You will create and modify a chart by using various charting techniques.

  • You will apply numerous page display settings to prepare a worksheet for printing.

Course Content

Lesson 1:
Getting Started
Identify What You Can Do with Microsoft Excel
Enter Data in a Worksheet
Edit Data
Change Text Appearance
Save a Workbook
Using Help

Lesson 2:
Editing Your Worksheet
Move Data to Other Cells
Copy Data to Other Cells
Fill Cells with a Series of Data
Insert and Delete Rows and Columns
Undo and Redo an Entry
Find and Replace Numbers
Enter Data in a Range
Lesson 3:
Performing Calculations
Sum a Range of Data
Use a Built-in Function - min, max, averag
Copy a Formula
Create an Absolute Reference using F4

Lesson 4:
Formatting
Specify Numeric Format
Change Font Size and Type
Add Borders to Cells
Change Column Width and Row Height
Align Cell Contents
Merge and Split Cells
Apply an AutoFormat

Lesson 5:
Working with Multiple Worksheets
Format Worksheet Tabs
Reposition Worksheets in a Workbook
Copy Worksheets
Change the Default Number of Worksheets

Lesson 6:
Creating and Modifying Charts
Create a Chart
Modify Chart Items
Format a Chart
Change the Chart Type

Lesson 7:
Setting Page Display and Printing Options
Freeze and Unfreeze Rows and Columns
Set Print Titles
Set Page Margins
Create a Header and Footer
Change Page Orientation
Print a Range

Microsoft Excel 2002: Level 2

Course Specifications

Duration : 1 day

Course Description

Overview:  
Students will create templates, sort and filter data, import and export data, analyze data, and collaborate on the Web.

Prerequisites:
Excel 2002: Level 1

Delivery Method:
Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.

Benefits:
Students will gain the skills needed to create and use templates, sort and filter data, import and export data and  analyze data.

Target student: 
The target student for this course is a user who has worked with Excel and has experience creating basic worksheets and charts.

Performance-Based Objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

  • You will use Excel and user-defined templates to create templates and workbooks.

  • You will use a variety of techniques to sort and filter data.

  • You will reuse and share data by importing and exporting.

  • You will use various functions and auditing features to create advanced formulas and audit worksheets.

  • You will use PivotTable reports, PivotChart reports, and other analysis tools to analyze data.

Lesson 1:
Working with Templates
Create a Workbook from an Excel Template
Create a Template

Lesson 2:
Sorting and Filtering Data
Sort Data
Add Subtotals to a Worksheet
Filter Lists

Lesson 3:
Working with Advanced Formulas
Share Data Among Worksheets
Create a Name for a Range of Cells
Use Functions to Create Advanced Formulas
Trace Cell Precedents
Trace Cell Dependents

Lesson 4:
Analyzing Data
Create a PivotTable Report
Create a PivotChart Report

Lesson 5:
Collaborating
Insert and Edit a Hyperlink
Add and Edit Comments in a Worksheet
Create Discussion Comments
Respond to Discussion Comments

icrosoft Excel 2002: Level 3

Course Specifications

Duration" 1 day

Course Description

Students will customize their workbooks, work with multiple data sources, collaborate with other users, and enhance their spreadsheets using charts and graphic objects.
Target Student:  The target student for this course is a user who has worked with personal computers and used Windows to manage information, run programs, access the Web, and who has a working knowledge of Excel 2002.

Prerequisites:
Windows 2000: Introduction
Excel 2002: Level 1
Excel 2002: Level 2

Delivery Method:
Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.

Benefits:
Learn how to customize their workbook, work with multiple data sources, collaborate with other Excel users, and use charts and graphic objects to enhance their worksheets.

Performance-Based Objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

  • Apply conditional formatting; add data validation criteria; customize menus and toolbars; and create, edit, and run macros. The student will also view data using the outline.

  • Create a workspace, consolidate data, view the consolidated data, and link cells.

  • Protect their worksheet, protect their workbook, add and remove file passwords, share their workbooks, set revision tracking, merge workbooks, and track changes.

  • Chart non-adjacent data, modify embedded charts and chart items, and add a trend line to their chart.

  • Create, change the order of, group, move, copy, and format graphic objects. They will also insert and modify clip art.

Course Content

Lesson 1:
Customizing Your Workbook
Applying Conditional Formatting
Adding Data Validation Criteria
Customizing Menus
Customizing Toolbars
Creating a Macro
Grouping and Outlining Structured Data

 

Lesson 2:
Working with Multiple Data Sources
Creating a Workspace
Linking Cells in Different Workbooks
Editing Links

Lesson 3:
Collaborating with Others Using Workbooks
Protecting Your Worksheets
Protecting Your Workbook
Sharing Your Workbook
Setting Revision Tracking
Merging Workbooks
Tracking Changes

 

Lesson 4:
Enhancing Your Worksheet Using Charts
Charting Non-adjacent Data
Modifying Chart Items
Creating a Trend Line

 

Lesson 5:
Using Graphic Objects to Enhance Your Worksheet
Creating Graphic Objects
Resizing, Moving, and Copying Graphic Objects
Changing the Order of Graphic Objects
Grouping Graphic Objects
Formatting Graphic Objects
Inserting Clip Art
Modifying Clip Art

 

 

Home Training Courses MS Specialist MS Training Companies Links Contact
WEB DESIGN. WEB OPTIMISATION, AND HOSTING BY UQH - www.ultraquickhost.com
©Ultra Quick Host ®UQH
It is illegal to copy or reproduce any information or images contained in this website without written application and subsequent permission from Ultra Quick Host