MICROSOFT EXCEL - FOUNDATION

Previous 1 / 9 Next


Microsoft Excel - Foundation

Course Duration: 1 Day

Audience:

This course is suitable for participants who wish to gain the foundational understanding of Microsoft Excel that is necessary to create and work with electronic spreadsheet.

Prerequisites:

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

Benefits:

  • Get started with Microsoft Excel
  • Identify the elements and interface of Excel
  • Performing calculations, basic formulas and functions
  • Modify worksheet & formatting worksheet
  • Printing and managing large workbook

Course Outlines:

Module 1: Getting Started with Microsoft Excel

  • Identify the elements of the Excel Interface
  • Creating a new blank workbook

Module 2: Performing Calculations

  • Creating formulas in a Worksheet

Module 3: Modifying a Worksheet

  • Manipulate the data
  • Insert, manipulate and delete cells, columns and rows
  • Search and replace data
  • Spell check a worksheet

Module 4: Formatting a Worksheet

  • Modify fonts
  • Add borders and colors to cells
  • Apply number formats
  • Align cell contents

Module 5: Printing Workbook Contents

  • Define the basic page layout for a workbook
  • Refine the page layout and apply print options

Module 6: Managing Large Workbooks

  • Format worksheet tabs
  • Manage worksheets
Please leave your enquiry here, we will reply as soon as possible.
Name*  
Company Name  
Product Interested  
Quantity  
Email*  
Contact No.*  
Messages*  
   

Switch to Mobile Version
available in
Subscribe Newsletter