ICDL Module 4: ES WSQ - Perform Advanced Spreadsheet Functions (Microsoft Excel 2013) ITBM
Price: SGD 1,605
  • Duration: 14 Days

Course details

This course provides the basis for the practice-based test for ICDL Perform Advanced Spreadsheet Functions exam.

The exam requires the candidate to use the spreadsheet application to produce what are deemed to be advanced spreadsheet outputs. The candidate shall be able to operate effectively at more than a basic level of competence and be able to edit and enhance numeric, text and graphical data and to sort, query and link data. The candidate shall be able to carry out advanced formatting and presentation operations on charts and graphs. The candidate shall be able to use functions such as those associated with logical, statistical or mathematical operations. The candidate shall be able to use available analysis and audit tools and to run and record simple macros.

COURSE OUTLINE

  • Module 1. Using Conditional and Custom Formats
  • Module 2. Using Templates
  • Module 3. Working with Databases
  • Module 4. Working with Advanced Filters
  • Module 5. Revising Charting Features
  • Module 6. Creating/Revising PivotTables
  • Module 7. Using Auditing Tools and Range Names
  • Module 8. Exporting and Importing Data
  • Module 9. Using Advanced Functions
  • Module 10. Using Scenarios
  • Module 11. Using Worksheet Protection
  • Module 12. Tracking and Merging Workbooks
  • Module 13. Recording Macros
  • Module 14. Comments
Updated on 03 September, 2016

About ITBM

Instructional & Courseware Design

  • Customized CD Learning, e-Learning and Courseware for companies. Find out more now.

Office Workflow Automation

  • When running your day-to-day business, you realise that things can be made easier for you if the system is computerised. But how do you get started? More information here.
See all ITBM courses
Are you from ITBM ? Claim your course!
Courses you can instantly connect with... Do an online course on Microsoft Excel starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or