ICDL - Perform Advanced Spreadsheet Functions ( Adv excel) 15, 16 & 17 Aug 2022 830AM -5:30PM 24 HRS
Course Info
Course Title : Perform Advanced Spreadsheet Functions
(ICDL - Advanced Excel V2019)
Course Reference NumberTGS-2020504094Funding Validity PeriodFrom 02 Jun 2020 To 04 Aug 2024
(ICDL - Advanced Excel V2019)
Course Reference Number
TGS-2020504094
Funding Validity Period
From 02 Jun 2020 To 04 Aug 2024
Course Info 课程信息:
Course Info 课程信息:
- Full Course Fee 课程原价: SGD600
- SG citizen >= 40 years old：S$222.00 (Incl GST)
新加坡公民>=40岁： S$222.00（已含GST)
- SG citizen aged 21-39 & PR: SGD 342.00 (Incl GST)
新加坡公民 21-39 岁 ， PR : S$342.00 (已含GST)
- SME (SC & PR) ：S$222.00Incl GST)
中小型企业公民和PR 员工(公司赞助员工）： S$222.00(已含GST)
- SkillsFuture Credit (SFC) is applicable for course fee for SG citizen
新加坡>=25的公民可以用培训补贴付学费
- Absentee payroll is applicable for Corporate training
公司赞助员工培训， 公司可以申请缺勤津贴
- Full Course Fee 课程原价: SGD600
- SG citizen >= 40 years old：S$222.00 (Incl GST)
新加坡公民>=40岁： S$222.00（已含GST)
- SG citizen aged 21-39 & PR: SGD 342.00 (Incl GST)
新加坡公民 21-39 岁 ， PR : S$342.00 (已含GST)
- SME (SC & PR) ：S$222.00Incl GST)
中小型企业公民和PR 员工(公司赞助员工）： S$222.00(已含GST)
- SkillsFuture Credit (SFC) is applicable for course fee for SG citizen
新加坡>=25的公民可以用培训补贴付学费
- Absentee payroll is applicable for Corporate training
公司赞助员工培训， 公司可以申请缺勤津贴
Training Mode: Classroom Training
培训方式： 教室培训
Training Time: 8:30 - 17:30
培训时间： 8:30 - 17:30
Course Inquiry课程咨询: VERA 94300059
Karen 90184057
Karen 90184057
COURSE SYNOPSIS
ICDL Advanced Spreadsheets is a high level certification programmed 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
1. Considerations in designing spreadsheets
2. Formatting
- Table AutoFormat
- Conditional formatting
- Apply data formats
- Using multiple worksheets
- Insert, move and remove split
- Hide and show rows, columns, worksheet
3. Functions and formula
- Using cell references in formula
- Function syntax and categories
- Logical functions
- Nested functions
- Nested functions
- Mathematical functions
- Statistical functions
- Date and Time functions
- Financial functions
- Text functions
- Lookup and Reference functions
- Database functions
- Creating Three-D worksheets
- Paste Special options
4. Charts
- Using Custom Charts
- Formatting charts
5. Analysis
- Managing data in a spreadsheet
- PivotTables
- Data Tables
- Scenario Manager
- Sorting a database
- Auto and Advanced Filters
- Subtotals
6. Validating and Auditing
- Data validation
- Auditing
7. Enhancing Productivity
- Range Names
- Using Templates
- Linking data
- Inserting hyperlinks and bookmarks
- Import data to Excel
- Macros
8. Collaborative Editing
- Working with comments
- File protection
- Accessing and sharing data