Working Smart with Microsoft Excel

4.9

Course Objectives

Basic knowledge of Windows is essential with the following pre-requisites:

- Able to switch between task applications
- Able to create a spreadsheet with simple formatting
- Able to use Auto Filter command
- Able to use basic functions – AutoSum, Count, Max, Min and Average functions

Target Audience

Administration Staff
Financial Executive
Operational Staff
Resource and planning team
Supervisors
Engineers

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussion, and practical exercise.

Course Modules

Module 1: Keeping dynamic data range as Table

Create Table
Quick insert of new row
Quick Formatting using Table Style
Turn on quick summary with Subtotal
Cleaning Up Duplicate Entry
Convert Table as Range

Module 2: Getting a summary to meet specific criteria

Adding up value with SUMIF / SUMIFS
Finding number of entry with COUNTIF / COUNTIFS
Average up value with AVERAGEIF / AVERAGEIFS
return an alternative result with IFERROR

Module 3: Rules to control user input in a cell

Dropdown list to limit entries
Restrict value entry for number and date
Custom user defined restriction

Module 4: Quick search, compile and compare data from multiple sheets / workbooks

Vertical search for exact matching data using VLOOKUP
Horizontal search for matching data using HLOOKUP
VLOOKUP as alternative for Nested IF function
Multiple searches with INDEX and MATCH

Module 5: Identify data trends and patterns

Highlight Cell Rules
Using Data Bars
Using Icon Sets
Creating New Rules with Formula

Get To Know The Trainer

Trainer Jarina

4.5

Managing and maintaining a Microsoft Windows Server 2003 Environment - educate the IT professionals who implement, manage, and troubleshoot existing network and system environments based on the Windows Server 2003 platform. Implementation responsibilities include installing and configuring parts of systems. Management responsibilities include administering and supporting systems

VIEW PROFILE

Chat with us LIVE to get a

FREE QUOTATION!

THIS PUBLIC COURSE INCLUDES

*T&C Applies

PARTICIPANT REVIEWS FOR THIS COURSE

4.9

sS
suda Saelee
Executive, HR / Learning and Development
5
TC
Tommy Chin
Executive, HR / Learning and Development
5
HT
Hip Tran
Senior Executive, HR / Learning and Development
5
Very good and easy for your employees
PK
Pauline Kho
Manager / Supervisor, HR / Learning and Development
5
A very good Excel training that is relevant to people who need to use Excel alot. The best part is it is only 1 day class and the course fee are affordable.
RA
Riezel Aguila
Executive, HR / Learning and Development
5
NK
Norziatonakma binti Kamarudin
Assistant Manager, Corporate Communications
5
AS
Atiqah Mat Senin
Executive, Marketing / Design
5
CL
Chris Lai
Assistant Manager, HR / Learning and Development
4