MICROSOFT EXCEL FOR BASIC

Course Synopsis :

In this course, students create and edit basic Microsoft® Office Excel® 2016/2019 worksheets and workbook

Course Objectives

Upon successful completion of this course, students will be able to: -

• Explore the Microsoft Office Excel environment and create a basic worksheet.
• Perform basic calculations.
• Modify and format a worksheet

Method of Instruction: 80 % Hands on training and 20% theory

Language : Bahasa Melayu and English

Course Content

 Module 1: Getting Started with Excel

• Introduction
• Getting to know Excel
• The Excel interface
• Working with the Excel environment
• The Ribbon
• To change the Ribbon Display Options:
• The Quick Access Toolbar
• To add commands to the Quick Access Toolbar:
• How to use Tell me:
• Worksheet views
• Backstage view
• To access Backstage view

 Module 2: Cell Basics

• Introduction
• Understanding cells
• To select a cell:
• To select a cell range:
• Cell content
• To insert content:
• To delete (or clear) cell content:
• To delete cells:
• To copy and paste cell content:
• To access more paste options:
• To cut and paste cell content:
• To drag and drop cells:
• To use the fill handle:
• To continue a series with the fill handle:

 Module 3: Modifying Columns, Rows, and Cells

• Introduction
• To modify column width:
• To AutoFit column width:
• To modify row height:
• To modify all rows or columns:
• Inserting, deleting, moving, and hiding
• To insert rows
• To insert columns
• To delete a row or column:
• To move a row or column
• To hide and unhide a row or column
• Wrapping text and merging cells
• To wrap text in cells
• To merge cells using the Merge & Center command
• To access more merge options
• To center across selection

 Module 4: Intro to Formulas

• Introduction
• Mathematical operators
• Understanding cell references
• To create a formula:
• Modifying values with cell references
• To create a formula using the point-and-click method:
• Copying formulas with the fill handle
• To edit a formula

 Module 5: Page Layout and Printing

• Introduction
• To access the Print pane:
• Show Margins / Zoom to Page
• To print a workbook
• Choosing a print area
• Adjusting content
• To modify margins in the Preview pane

 Module 6: Charts

• Introduction
• Understanding charts
• To insert a chart:
• Chart and layout style
• Other chart options