EXCEL BASICS | MICROSOFT OFFICE SERIES

COURSE DURATION	:	1 Day (7 Hours)
AWARD TYPE	:	Certificate of Completion
TOTAL COURSE FEES	:	RM 400 per participant (HRDF Claimable)
VENUE	:	In-house (client’s location)
MIN/MAX Participants	:	Minimum 3 participants, Maximum 8 participants

WHO SHOULD ATTEND

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.

PREREQUISITES

Basic knowledge of Windows is essential

METHODOLOGY

This program will be conducted with interactive lectures, discussions and practical exercise

LEARNING OUTCOME

1. Give participant a systematic understanding of a spreadsheet ad its benefits
2. Equip participant with essential skills of using Microsoft Excel effectively for businesses

Introduction to Spreadsheets

1. Creating a New Workbook
2. Understand the Basic Parts of a Workbook
3. Saving a Workbook
4. Opening a Workbook

Your First Workbook

1. Selecting Data
2. Entering and Deleting Data
3. Using Undo and Redo
4. Using Cut, Copy, and Paste 

Working with Data

1. Inserting Rows and Columns
2. Merging and Splitting Cells
3. Moving Cells
4. Using Paste Special
5. Using Find and Replace
6. Hiding and Unhiding Cells 

Hiding and unhiding Cells

1. Using AutoFill
2. Using Flash Fill
3. Using AutoSum
4. Using AutoComplete
5. Using AutoCalculate

Formatting Texts

1. Changing the Font Face, Size, and Color
2. Applying Text Effects
3. Applying Borders and Fill
4. Using the Font Tab of the Format Cells Dialog
5. Clearing Formatting 

Formatting Data

1. Wrapping Text
2. Changing the Size of Rows and Columns
3. Adjusting Cell Alignment
4. Changing Text Direction
5. Changing Number Format

Charting Data

1. Creating Sparklines
2. Inserting Charts 

Viewing, Printing, and Sharing Your Workbook

1. Using Views
2. Saving a Workbook as PDF or XPS
3. Printing a Workbook

Customising the Interface

1. Changing Ribbon Display Options
2. Customizing the Quick Access Toolbar
3. Hiding and Showing Ribbon Tabs
4. Creating Custom Ribbon Tabs
5. Resetting Interface Changes