Ms Excel 95/97/2000/XP

MThis course teaches about fundamental spreadsheet concepts. Topics include creating, formatting, enhancing, and printing worksheets; working with formulas, utilizing basic functions and charts, and using multiple worksheets and workbooks.

Go to Top

Course Objectives

• Understand the disadvantages of paper spreadsheets and the advantages of electronic spreadsheets.
• Change the appearance of worksheet data by using a variety of formatting techniques.
• Create basic worksheets by entering text, values, and formulas.
• Prepare a document for printing by using the Spell Check feature and a variety of printing options.
• Create formulas by using Excel’s built-in functions.
• Use the three-dimensional aspect of the Excel workbook environment by creating formulas that reference cells on multiple worksheets.
• Move and copy data by using shortcut menus, drag and drop editing, and toolbar
  

Go to Top

Pre-requisites

Basic knowledge of Windows is required.

Go to Top

Course Duration

Recommended Hour - 6 Hours

Go to Top

Course Outline

• The paper spreadsheet
• The Excel program
• The workbook environment
• Entering and correcting data
• Saving a file
• Using formulas
• Navigation and movement techniques
• Working with ranges and functions
• Editing cell contents
• Inserting rows and ranges
• Moving and Copying data
• Absolute references
• Using the Fill Series feature
• Formatting a worksheet
• Number formats and text alignment
• Using a multi-sheet workbook
• Creating a chart
• More..

Please note that the course outline does not exhaust here, for a more detail course outline, email us at info@i-edu.com.sg.

Go to Top