Duration: 2 days
Time: 9am to 6pm
Course Code: CRS-Q-0040016-ES

What Will Be Taught For This MS Excel Perform Spreadsheet Functions Course?

This course provides the basis for the practice-based test for ICDL Perform Spreadsheet Functions exam. It sets out essential concepts and skills relating to understanding the concept of spreadsheets and using a spreadsheet to produce accurate work outputs.

Successful candidates will be able to:

  • Work with spreadsheets and save them in different file formats, locally or in the cloud.
  • Use available help resources, shortcuts and the go to tool to enhance productivity.
  • Enter data into cells and use good practice in creating lists. Select, sort and copy, move and delete data.
  • Edit rows and columns in a worksheet. Copy, move, delete and appropriately rename worksheets.
  • Create mathematical and logical formulas using standard spreadsheet functions. Use good practice in formula creation and recognize error values in formulas.
  • Format numbers and text content in a spreadsheet and use available autoformat/table styles.
  • Choose suitable charts, and create and format charts to communicate information meaningfully.
  • Adjust spreadsheet page settings and check and correct spreadsheet content before printing.

Module 1. Exploring Microsoft Excel

  • Starting Excel
  • The User Interface
  • The Backstage View
  • Excel Options
  • Creating a Workbook
  • Opening a Workbook
  • Saving the Workbook
  • Closing the Workbook
  • Working with Worksheets
  • Using the Ribbon
  • Hiding the Ribbon
  • Using Zoom Tools
  • Closing & Exiting Excel
  • Practice - Exploring Microsoft Excel

Module 2. Getting Help

  • Using Microsoft Excel Help and Resources
  • Working with Excel Help
  • Practice - Getting Help

Module 3. Basic Workbook Skills

  • Using Keyboard for Selection
  • Using GoTo
  • Entering Text
  • Entering Numbers
  • Shortcuts for Data Entry
  • Editing Data
  • Spell Check
  • Creating a New Folder When Saving
  • Saving the Workbook with Another File Type
  • Practice - Basic Workbook Skills

Module 4. Selection

  • Selecting a cell
  • Selecting a range of adjacent cells
  • Selecting a range of non-adjacent cells
  • Selecting the entire worksheet
  • Selecting a row
  • Selecting a range of adjacent rows
  • Selecting a range of non-adjacent rows
  • Selecting an entire column
  • Selecting a range of columns
  • Selecting a range of non- adjacent columns
  • Practice – Selection

Module 5. Working with Columns and Rows

  • Adjusting the Column Width
  • Adjusting the Row Height
  • Automatically Adjusting Columns
  • Hiding and Un-hiding Rows and Columns
  • Inserting Columns and Rows
  • Deleting Columns and Rows
  • Freezing and Unfreezing Columns and Rows
  • Practice - Working with Columns and Rows

Module 6. Number Formatting

  • About Number Formats
  • Accounting Number Style
  • Percent Style
  • Comma Style
  • Decimal Places
  • Practice – Number Formatting

Module 7. Text Formatting

  • Formatting Text
  • Changing the Font
  • Changing Font Size
  • Bold and Italic
  • Underlining Text
  • Font Color
  • Rotating Text
  • Text Wrapping
  • Cell Alignment
  • Apply Table Style
  • Practice – Text Formatting

Module 8. Cell Formatting

  • Merging Cells
  • Vertical Alignment
  • Unmerge Cells
  • Adding Borders
  • Drawing Borders
  • Adding Fill Colors
  • Format Painter
  • Inserting Cut or Copied Cells
  • Deleting Cells
  • Practice – Cell Formatting

Module 9. Working with Tables

  • Adding Table Rows and Columns
  • Practice - Working with Tables

Module 10. Formulas

  • Using Basic Formulas
  • Entering Formulas
  • Basic Functions
  • Using the AutoSum Button
  • Using the AutoSum List
  • Using Formula AutoComplete
  • Editing Functions
  • Using Auto Calculate
  • Modifying Formulas using the Range Border
  • Error Checking
  • Create Absolute Reference
  • Using IF Function
  • Practice – Basic Formulas

Module 11. Cut, Copy and Paste

  • Copying and Pasting Data
  • Cutting Data
  • Copying Formulas
  • Paste Options
  • Paste List
  • Filling Cells
  • Drag-and-Drop Editing
  • Undo and Redo
  • Practice – Cut, Copy and Paste

Module 12. Data Management

  • Sorting
  • Finding Data
  • Replacing Data
  • Finding and Replacing Cell Format
  • Practice – Data Management

Module 13. Creating Charts

  • Inserting a column chart
  • Inserting a line chart
  • Inserting a bar chart
  • Inserting a pie chart
  • Resizing a chart
  • Deleting a chart
  • Adding a Chart Title
  • Changing the Chart Background
  • Format chart legend, axis
  • Changing a column, bar, line or pie slice colors
  • Changing the chart type
  • Adding a Data Table
  • Changing the Chart Layout
  • Moving charts
  • Delete chart
  • Practice - Creating Charts

Module 14. Using Page Setup

  • Worksheet margins
  • Worksheet orientation
  • Worksheet page size
  • Headers and Footers
  • Header and footer fields
  • Scaling your worksheet to fit a page(s)
  • Repeating Row and Column Labels
  • Changing Page Breaks
  • Setting/Removing a Print Area
  • Changing Sheet Options
  • Practice - Using Page Setup

Module 15. Printing

  • Print Preview
  • Printing the Current Worksheet
  • Printing a Selected Range
  • Printing a Page Range
  • Printing Multiple Copies
  • Practice - Printing

Who Should Attend This MS Excel Perform Spreadsheet Functions Course Training?

Ideal for beginners in Microsoft Office Excel to develop a solid foundational understanding of spreadsheet concepts and applications.

Pre-requisite

An understanding of Windows / Microsoft Excel 2013/2016 will be an added advantage.

  w/o GST w GST
Course Fee $400 $428
Singapore Citizen & PR aged ≥ 21 years $111 $139
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
$40 $68
Singapore Citizen aged ≥ 35 years with earning ≤ $2,000/month
(WTS Scheme)
$20 $48
  w/o GST w GST
Course Fee $400 $428
Singapore Citizen & PR aged ≥ 21 years $111 $139
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
$40 $68
Singapore Citizen aged ≥ 35 years with earning ≤ $2,000/month
(WTS Scheme)
$20 $48
  w/o GST w GST
Course Fee $400 $428
Singapore Citizen & PR aged ≥ 21 years $40 $68
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
$40 $68
Singapore Citizen aged ≥ 35 years with earning ≤ $2,000/month
(WTS Scheme)
$20 $48

Trainee shall be bound by the Terms and Conditions of any applicable funding scheme.

Please ensure that you have read our Terms and Conditions before submitting the enrolment form.






Please click on the course date to enrol.