Microsoft EXCEL Training - Basic Level @ Malaysia

Trained by MOS certified trainer Kent Lau


This training provides participants with basic knowledge to use Microsoft Excel better.

Effective Training methods:
Partner sharing, group sharing, class sharing, revision technique with powerful motivation tips to help participants learn happily. We create a fun environment to learn Excel.

Learning outcome:
At the end of this training, participants will be able to edit, view data in Microsoft Excel as well as create simple formulas.

What you will learn?

TOPIC 1. The Excel Environment and basic configuration. We introduce you to Ribbon, you learn how to maximizing and minimizing Ribbon, how to access to most common used command faster, how to focus your Excel task more.

1.1. We help you uUnderstand different multiple Excel format, how to save workbook in multiple format (xlsx, and xlsm or xls)
1.2. Learn how to open a recent workbook

TOPIC 2. Navigation & Searching information. Learn how to use Keyboard shortcuts to complete Excel task faster, how to find a text, how to find a text and replace them all

2.1 Learn to use split panes. How to split a worksheet better and faster.

TOPIC 3. Data Entry. Learn how to automatically fill a list of day, numbers. Mastering the Must-know technique to enter date and time. Learn "Multiple Cells data entry" technique.

You will learn to create Time Table and setting up lists

TOPIC 4. Formulas. Learn how to create a simple formula, learn what is "Formula precedence", how to nme a cell and range



TOPIC 5. Functions. Introduce you to "What is function?" and "What is argument?"
5.1. Learn to use some basic functions: SUM, AVERAGE, MAX, MINand find out the different between COUNT and COUNTA.

TOPIC 6: Manual vs. Automatic Formatting. Learn to use formatting shortcuts.
Learn how to add row/column, deleting row/column, hiding row/column, wrapping text, merging or unmerge cells.


TOPIC 7. Working with Worksheet. Learn the secret faster way of copy one or multiple worksheet(s)
learn to delete worksheet, rename worksheet, viewing multiple worksheets same time and synchronous scrolling.

Prerequisites
Participants should understand the basics of using Windows operating system such dragging, copy files, create new folder, rename files.

Duration: One day

Interested? please PM me : ) Thank you.


Visit my fan page for Microsoft Excel tips for Malaysian
https://www.facebook.com/MalaysianFavourite...rosoftExcelTips

Class photo taken while learning Ms Excel
Our latest client: Maybank, TESCO


Certificate is given upon completion. Thank you.
We can arrange for you to gain MOS certificate.

Training Location:
Creativewise Sdn Bhd (formerly UGROW IT Solutions)
26-2, Jalan OP 1/5, Pusat Perdagangan One Puchong.

About Us
Creativewise Sdn Bhd
- 14 yrs experience in IT industry
- 6 yrs corporate training experiences

We provide Microsoft Excel, Powerpoint training for senior management and executive. We has successfully trained LB Aluminium Berhad, Nokia Siemen Network, ThaiExpress Sdn Bhd, SGS Malaysia Sdn Bhd, DataStream Solution (Brunei) Sdn Bhd, 3ntity Berhad, SGS Labuan (Group of Oil & Gas Chemists), AVNET Malaysia Sdn Bhd, SOMFY Sdn Bhd, KTC , New Horizons Malaysia, Nota Asia, Tunku Abdul Rahman College, Kawan Food Berhad, Merge Energy Berhad, PUMA, Syngenta, Ntritex Sdn Bhd and etc

"Kent has helped my staff to reduce data analysis time in calculating staff overtime." ~ LB Aluminium Berhad

Contact:
www.ugrowit.net

Thank you very much for viewing our profile.

This post has been edited by kent_lau7: Sep 6 2013, 07:09 AM