Please enable JavaScript
24 hours – ICDL Perform Advanced Spreadsheet Functions (Advanced Excel 2016) – Eagle Infotech Consultants
Eagle Infotech Consultants
150 Orchard Road #06-14
Orchard Plaza Singapore 238841

24 hours – ICDL Perform Advanced Spreadsheet Functions (Advanced Excel 2016)


Course Duration
24 hours

Course Reference Number
CRS-Q-0028427-ES
Funding Validity Period
Till  1 Aug 2020
Mode of Training
Classroom
Course Synopsis

ICDL Advanced Spreadsheets is a high level certification programme which presents learners with the opportunity to bring their spreadsheet skills to an expert level. This allows them to use the full potential of the spreadsheet application to produce higher quality management information.Individuals with ICDL Advanced Spreadsheets certified skills can:

  • Produce higher quality information
  • Pinpoint key information quicker and more easily
  • Provide more sharply-defined analysis
  • Produce more sophisticated reports
  • Use advanced editing, data handling, functions and analysis features
  • Use macros within the spreadsheets application

Target Audience
Prospective learners should ideally have the ICDL certification and/or previous experience using computers and common software applications. Typically, these would be individuals who use a wide range of advanced functionalities within a spreadsheet application in a personal or professional context. Spreadsheet applications enable learners to manipulate and produce precise information and conduct crucial data analysis. The ICDL Advanced Spreadsheets certification has been specifically designed to provide learners with the skills to exploit the full potential of the spreadsheet application.

Course Content

Overview of Module

Considerations in designing spreadsheets
  • The purpose and structure of the spreadsheet
  • The intended audience or users
  • Other considerations
Formatting
  • Table AutoFormat
  • Conditional formatting
  • Apply data formats
  • Using multiple worksheets
  • Insert, move  remove split
  • Hide and show rows, columns, worksheet
Functions and formulae
  • Using cell references in formula
  • Function syntax and categories
  • Logical functions
  • Nested functions
  • Mathematical functions
  • Statistical functions
  • Date and Time functions
  • Financial functions
  •  Text functions
  • Lookup and Reference functions
  • Database functions
  • Creating Three Dimensional worksheets
  • Paste Special options
Charts
  • Using Custom Charts
  • Formatting charts
Analysis
  • Managing data in a spreadsheet
  • PivotTable
  • Data Tables
  • Scenario Manager
  • Sorting a database
  • Using Auto and Advanced Filters
  • Subtotals and Outlining
Validating and Auditing
  • Data validation
  • Formula Auditing
Enhancing Productivity
  • Range Names
  • Using Templates
  • Linking data
  • Inserting hyperlinks and bookmarks
  • Import data to Excel
  • Macros
Collaborative Editing
  • Working with comments
  • File protection
  • Accessing and sharing data

Course Fees (Self-Sponsored)

Full Fee GST Nett Fee after Funding (Incl. GST)
MCES Normal WTS
$550 $38.50 $93.50 $180.50 $66

MCES: Singaporean age 40 and above
Normal: Singaporean/PR age 21 and above
WTS: Singaporean age 35 and above and earning  $2,000 or below per month

 

View Course Dates