DURATION
1 Day
Target Group
The program is designed to give office workers a basic understanding on the working of Microsoft Excel, its benefits and applications. The program will equip participants with basic skills require in utilizing Excel spreadsheets in day to day business environments. Hands-on exercises related to actual business applications will help participants concepts & features covered.
Prerequisites
Working knowledge of the Microsoft Windows 2000/XP interface such as configuring the desktop, using Control Panel, moving and sizing windows, and switching between tasks
Course Objectives
The program is designed for experienced Excel users who need to know the advance features of Excel 2003. The objective of this program is to equip participants with skills to customize the Excel environments for office automation. Hands-on exercises related to actual business applications will help participants to reinforce concepts & features covered.
Module 1: Introduction to Excel
Overview on new Features in Excel 2003
Reliability and Data Recovery
Understanding Excel User Interface
Understanding Toolbars
Moving Around in a Worksheet
Using Office Assistant
Module 2: Working With Spreadsheet
Workbook & Worksheet Concepts
Color-coded worksheet tabs
Entering Worksheet Data
Using AutoCorrect
Using AutoComplete
AutoFill
Moving Data
Copying Data
Remove Data
Multiple Undos
Smart Tags
Working with Rows and Columns
Module 3: Printing Worksheets
Previewing Worksheet
Page Break Preview
Setting Up Pages
Printing Worksheet
Programme scope, delivery arrangements and suitability are confirmed during enquiry.