DURATION
1 Day
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 95 interface such as configuring the desktop, using Control Panel, moving and sizing windows, and switching between tasks.
Module 1: Introduction
Overview on new Features in Excel 2002
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: Formulas & Functions
Formula Concept
Creating Simple Formulas
Natural Language Formulas
Range Finder
Formula Evaluating Toolbar
Formula Evaluator
Cell Addressing
Using Expanded AutoSum functionality
Paste Function Wizard
Auto Calculate
ScreenTips for function arguments
Watch Window
CountIf Functions
Date Functions
Logical Function
Lookup Function
Module 4: Formatting Data
Using AutoFormat
Custom Formatting using Toolbar and Menu options
Conditional Formatting (optional)
Module 5: Creating Charts
Type of Charts
Chart Basic
Creating Charts
Modifying Chart
Formatting Charts
Module 6: Printing Worksheets And Charts
Previewing Worksheet
Page Break Preview
Setting Up Pages
Printing Worksheet
Module 7: Data Management
Creating Database
AutoComplete & Picklist
Sorting data
AutoFiltering
Programme scope, delivery arrangements and suitability are confirmed during enquiry.