| Course
Outline
Duration
2 Half Days
Prerequisite
Experience with Windows.
Objectives
To provide a thorough understanding of the comprehensive
concepts and skills that will enable the participant to
effectively use Microsoft Excel.
Methodology
Group and individual instruction, hands on practical exercises,
visual aids, comprehensive course documentation.
Confirmation of Assessment Plan
This will be issued to the trainee at commencement of
training session.
Expected Outcome
By the end of the course the participant should be able
to use the following functions and features of Microsoft
Excel.
CONTENT
Getting started
- Moving around the
- Worksheet
- Using the Menus
Creating and Saving a Worksheet / Workbook
- Importance of Spreadsheet
Design
- Entering Text, Numbers,
Formulas and Functions
- Aligning Text
- Closing a Workbook/
Worksheet
Manipulating a Worksheet /Workbook
- Copying and Moving
- Clearing the Contents
of a Cell
- Formatting Cells
- Hiding Columns/Rows
- Fill Handle
Printing a Workbook
- Defining Page Setup
- Selecting Row Titles
- Selecting the Range
to be Printed
- Previewing a Printout
- Printing a Worksheet
Graphs and Charts
- Basic Embedded Charts
- Enhancing a Chart Sheet
- Editing a Chart Sheet
More Complex Tables
-
Understanding
Ranges
-
Copying
Formulas
-
Coping
in the Worksheets/Workbook
-
More
Complex Formulas
-
Protecting
Data
Sorting
-
Sorting
Data
Productivity Tools
-
Creating
Windows to View More Data
-
Inserting
Rows and Columns
|
