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.

Module 1: Formulas & Functions

Formula Concept

Range Finder

Cell Addressing

About Functions

Auto Sum

About List in Excel 2003

Convert a List to a Range

Using Paste Functions

Auto Calculate

CountIF Functions

Date Functions

Logical Functions

Lookup Functions

Module 2: Formatting Spreadsheet

Formatting Data Automatically

Custom Formatting

Euro Conversion

Changing Font Attributes

Conditional Formatting

Module 3: Charts

Type of Charts

Creating Charts

Modifying Chart

Formatting Chart

Turning Gridlines On/Off

3-D Views

Module 4: Data Management

Creating Database

AutoComplete & Picklist

Sorting

Using Filter in Excel 2003

Compare Documents Side by Side

Programme scope, delivery arrangements and suitability are confirmed during enquiry.