About this Course

This module enables candidates to understand the concept of spreadsheets and to demonstrate the ability to use a spreadsheet application. Candidates will understand and be able to accomplish tasks associated with developing, formatting, modifying and using a spreadsheet, in addition to using standard formulas and functions, and demonstrate competence in creating and formatting graphs or charts.

On completion of this module each candidate will be able to:

1. Work with spreadsheets and save them in different file formats 
2. Choose built-in options such as the Help function within the application to enhance productivity
3. Enter data into cells and use good practice in creating lists. Select, sort and copy,  move and delete data
4. Edit rows and columns in a worksheet. Copy, move, delete and appropriately rename   worksheets
5. Create mathematical and logical formulas using standard spreadsheet functions. Use good practice in formula creation and recognize error values in formulas
6. Format numbers and text content in a spreadsheet
7. Choose, create and format charts to communicate information meaningfully 
8. Adjust spreadsheet page settings and check and correct spreadsheet content before finally printing spreadsheets

• Understand Spreadsheet Principles
• Start a Spreadsheet Program
• Recognize the Spreadsheet
• Screen Layout
• Use the Ribbon and Quick
• Access Toolbar
• Use Help
• Change Preferences
• Close a Spreadsheet Program

• Workbooks
• Open a Workbook
• Open Multiple Workbooks
• Use Scroll Bars
• Close a Workbook

• Start a New Workbook
• Enter Text and Numbers
• Save a New and Named Workbook
• Save Workbooks in Different Formats
• Save a Workbook as a Template

• Enter Basic Formulas
• Use AutoSum
• Check Formulas
• Check Spelling

• Use Multiple Worksheets, Workbooks
• Switch Between Open Workbooks
• Rename Worksheets
• Copy and Move Between
• Worksheets, Workbooks
• Insert and Delete Worksheets

• Edit Data in the Formula Bar and Cells
• Delete Cell Contents
• Use Undo and Redo
• Select Ranges of Data
• Use the Fill Handle
• Erase and Sort Data
• Cut, Copy and Paste
• Find and Replace Text

• Print a Worksheet and Workbook
• Use Print Preview
• Change the Page Setup
• Add Headers and Footers
• Use Print Titles
• Display and Print Formulas
• Print Specified Areas of a Worksheet

• Format Numbers, Dates & Percentages
• Change Cell Alignment and Rotate Text
• Add Borders and Colour
• Change Row Height and Column Width
• Insert and Delete Rows and Columns
• Use Freeze & Zoom
• Use the Format Painter

• Use Paste Function
• Use the Functions Sum, Count & Average
• Use the Functions Max, Min and IF
• Use Relative and Absolute Addressing

• Format a Chart
• Print Charts
• Use Chart Options
• Create a Chart
• Select Chart Type
• Move, Copy and Resize Charts

For beginner and professional who in need of Excel in order to produce charts and data analysis.

Need to possess the knowledge of Basic PC

Successful trainees will receive the internationally recognized ICDL Certificate upon completion of the course. This certificate is administered by ICDL Singapore. This is a joint certification between WDA and ICDL Singapore. Student must take a 45 minutes online assessment at the end of the course.

ICDL - Perform Advanced Spreadsheet Functions (Advanced Excel 2007)

Rate this course:

Log in to submit

Comments