Course Description
This course is designed to give office workers a systematic understanding of a spreadsheet and its benefits. This program will equip participants with essential skills of effectively utilizing spreadsheet software in a day-to-day business environment. Hand-on exercises will help to reinforce concepts and features covered.
Pre-requisites
Basic knowledge of Windows is required with the following pre-requisites:
Able to maneuver with the mouse – Point, Click, Drag and Double Click.
Able to configure the desktop
Able to use the control Panel
Able to move and re-size Applications Windows
Able to switch between task applications
Module 1: Introduction
What Is Microsoft Excel 2000
Starting Microsoft Excel
The Parts Of A Worksheet Window
New Features in Excel 2000
Understanding the Toolbars
Moving Around in a Worksheet
Office Assistant
Module 2: Excel Basic
Creating A New Workbook
Changing No. Of Worksheets
Entering Worksheet Data
Using AutoCorrect
Using AutoComplete
AutoFill
Moving Data
Copying Data
Removing Data
Multiple Undos
Working With Rows and Columns
Saving Data
Closing A File
Opening An Existing Worksheet
:: Course EXC231 ::
Module 3: Formatting Spreadsheet
Format Data With AutoFormat
Custom Formatting
Conditional Formatting (Optional)
Clearing Formatting
Programme scope, delivery arrangements and suitability are confirmed during enquiry.