Sale!

Microsoft Excel 2007 Foundation

RM850.00

Objective

  • Give participant a systematic understanding of a spreadsheet ad its benefits
  • Equip participant with essential skills of effectively utilizing spreadsheet software in a day-to-day business environment

Upon completion of this program, participants should be able to:

  • Create a spreadsheet with simple formatting
  • Create a chart
  • Print a spreadsheet with headers and footers added

Prerequisites

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

  • Able to maneuver with the mouse – Point, Click, Drag and Double Click
  • Able to configure the desktop
  • Able to use the Control Panel
  • Able to move and re-size Application Windows
  • Able to switch between task applications

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.

Methodology

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

Module

  • GETTING STARTED
    • Lesson 1.1 – About Workbooks
      • Creating a New Workbook
      • Opening a Workbook
      • Saving a Workbook
      • About Excel File Types
      • Closing a Workbook
    • Lesson 1.2 – Exploring your Workbook
      • Using Worksheets
      • The Active Cell
      • Selecting Cells
      • Exploring a Worksheet
      • The Zoom Feature

 

  • THE NEW INTERFACE
    • Lesson 2.1 – The Quick Access Toolbar
      • The Default Buttons
      • Adding Buttons
      • Removing Buttons
      • Customizing the Toolbar

 

  • EXCEL BASICS
    • Lesson 3.1 – Working With Excel 2007
      • Columns, Rows, Cells, and Ranges
      • Creating Worksheet Labels
      • Entering and Deleting Data
    • Lesson 3.2 – Basic Excel Features
      • What is AutoFill?
      • What is AutoSum?
      • What is AutoComplete?
      • Working with Basic Formulas
    • Lesson 3.3 – Moving your Data
      • Dragging and Dropping Cells
      • How to Cut, Copy, and Paste Cells
      • How to Cut, Copy, and Paste Multiple Cells and Items
      • How to Use Paste Special
      • How to Insert and Delete Cells, Rows, and Columns
      • Using Undo, Redo, and Repeat

 

  • EDITING YOUR WORKBOOK
    • Lesson 4.1 – Modifying Cells and Data
      • Changing the Size of Rows or Columns
      • Adjusting Cell Alignment
      • Rotating Text
      • Creating Custom Number and Date Formats
    • Lesson 4.2 – Cell Formatting
      • The Format Painter
      • Cell Merging and AutoFit
    • Lesson 4.3 – Enhancing a Worksheet’s Appearance
      • Adding Patterns and Colors
      • Adding Borders
      • Working with Style
    • Lesson 4.4 – Working With Charts
      • Creating a Chart
      • Formatting a Chart
      • Modifying Charts with the Layout Ribbon
      • Manipulating a Chart

 

  • PRINTING AND VIEWING YOUR WORKBOOK
    • Lesson 5.1 – Using the View Ribbon
      • Using Normal View
      • Using Full Screen View
      • Using Page Layout View
      • Page Break Preview
    • Lesson 5.2 – Printing your Workbook
      • Opening Print Preview
      • Using the Print Preview Ribbon
      • Quick Printing
      • The Print Dialogue
      • Using Page Setup

Fee: RM 850 per pax

Loyalty Points: 850 Points

Duration: 1 Day

Note: In-house course is available. Request it HERE

Trainer

Kua Su-Ann

Biodata:
Su-Ann has been in the IT training industry for the 20 years and has trained thousands of people on the use of Microsoft Office. As Microsoft Office application is her area of specialization, she is an expert in all versions of the software and is capable of teaching at the basic, intermediate and advanced level. She has provided training to a variety of people: bankers, IT Personnel, young and old office workers, managers, senior managers, directors and corporate C-level executives. Su-Ann is the trainer of choice for many of our Blue Chip clients. Besides training, she has also been deeply involved in courseware development. In addition to developing generic courseware on Microsoft Office Applications, she has developed customized courseware to meet the unique requirements of the clients.