Microsoft Excel 2007 Foundation

Purchase this product now and earn 300 Points!
0 out of 5 based on 0 customer ratings

 Microsoft-Excel-2007-Foundation-HRDF-Trainings

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

RM1,300.00 RM850.00

Qty:
Request For In-House
If you purchase this product you will earn 850 Points!

Fee: RM 850 per pax


Loyalty Points: 850 Points


Duration: 1 Day


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

 Microsoft-Excel-2007-Foundation-HRDF-Trainings

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

Reviews

There are no reviews yet.

Be the first to review “Microsoft Excel 2007 Foundation”

You're reviewing: Microsoft Excel 2007 Foundation . How do you rate this product? *

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.

Redemption Products

Pin It on Pinterest