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


No comments:

Post a Comment

Calendar