DURATION
1 day
Target Group
The Microsoft Excel 2000 (Intermediate) course is targeted at IT Manager, IT Executive, HR Officer, HR Manager, IT Consultant, IT Assistant, Secretary, Purchasing Executive, Purchasing Officer, Training Officer, Administrator, MIS Officer, MIS Manager, and Information Technologist.
Prerequisites
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
Working knowledge of the Microsoft Windows 95 or 98 interface
Must have attended Excel 2000 (Basic)
Course Objectives
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
Module 1: Formulas
Creating Simple Formulas
Natural Language Formulas
Range Finder
Cell Addressing
Module 2: Functions
About Functions
AutoSum
Using Paste Functions
Auto Calculate
Using CountIf Function
Using Date Function
Using If Function
Using VLookup Function
Using Hlookup Function
Module 3: Charts
Types Of Charts
Creating Chart
Modifying Chart
Removing Data From The Chart
Adding Data To The Chart
Formatting Chart
Changing Chart Type
Format Chart Objects
Show/Hide Legend
Show/Hide Data Table
Rotated Text On Chart Axis
Turning Gridlines On/Off
View Chart in 3-D view
Module 4: Data Management
Creating Database
Auto Complete And Picklist
Sorting
AutoFiltering
Programme scope, delivery arrangements and suitability are confirmed during enquiry.