Appleworks 6 Spreadsheet

Course Description

This course introduces basic spreadsheet design and development. Topics include writing formulas, using functions, enhancing spreadsheets, creating charts, and printing. Upon completion, students should be able to design and print basic spreadsheets and charts.

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.
• Move and copy data by using shortcut menus, drag and drop editing, and toolbar
• Create charts
  

Go to Top   

Pre-requisites

Basic knowledge of Macintosh is required.

Go to Top   

Course Duration

Recommended Hour - 12 Hours

Go to Top   

Course Outline

• About spreadsheets
• Entering and editing spreadsheet data
• Working with spreadsheet cells, rows and columns
• Using formula and functions in a spreadsheet
• Sorting spreadsheet data
• Formatting spreadsheet cells
• Formatting spreadsheet documents
• Special printing options for spreadsheets
• Spreadsheet keyboard shortcuts
• Creating charts
• 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