Perform Advanced Spreadsheet Functions
TGS-2023039918
Course Overview
This module, in conjunction with CoPilot, sets out advanced skills and knowledge that can be used to perform complex mathematical and statistical calculations, to produce high quality management information, to present that information in sophisticated reports, and to use the advanced features in a spreadsheet application to improve productivity.
Training Type
Full Time
Mode of Assessment
*This course includes an online assessment (ICDL).
Who Should Attend
This training is relevant to anyone with a basic working knowledge of using Microsoft Excel who need to upgrade their skills and knowledge to better manage large sets of data, efficiently and effectively analyse these data sets and present findings in an impactful manner to benefit from data-based decision-making.
Course Duration
3 Days
Total Training Duration (Hour)
24
Course Outline
Learning Unit 1: Formatting
- Create custom data formats
- Split text to columns
- Using multiple worksheets
- Add, move and remove splits
- Hide and show rows, columns and worksheets
Learning Unit 2: Formulas and Functions
- Use cell references in formulas
- Use intermediate and advanced level functions and formulas in Excel
Learning Unit 3 – Creating charts and Sparklines
- Creating charts and Sparklines
- Formatting charts and Sparklines
- Creating charts with CoPilot
Learning Unit 4: Analysis
- Analysis with PivotTable and PivotChart
- Using Excel tables
- Apply Conditional Formatting
- Sorting and filtering
- Data table
- Scenarios
- Subtotals and Outlining
Learning Unit 5: Validating and Auditing
- Data Validation
- Formula auditing
Learning Unit 6: Analysis
- Analysis with PivotTable and PivotChart
- Using Excel tables
- Apply Conditional Formatting
- Sorting and filtering
- Data table
- Scenarios
- Subtotals and Outlining
Learning Unit 7: Collaborative Editing
- Working with notes and comments
- Worksheet and Workbook Protections
- Sharing workbooks
- Track changes
- Compare and merge workbooks
Course Learning Outcome
By the end of this course, learners will be able to:
• Apply advanced formatting options such as conditional formatting and customised number formatting and handle worksheets
• Use functions such as those associated with logical, statistical, financial and mathematical operations
• Create charts and apply advanced chart formatting
• Work with tables and lists to analyse, filter and sort data. Create and use scenarios
• Validate and audit spreadsheet data
• Enhance productivity by working with named cell ranges and macros
• Use linking, embedding and importing features to integrate data
• Compare and merge spreadsheets. Apply spreadsheet security features
Pre-requisites
- Learners must be able to read, write, speak and listen to English at secondary school level
- Learners to have minimum GCE ‘O’ level or ITE certificate education
- Learner should have at least 1 year’s working experience in any industry.
- Learners must be able to operate a personal computer, use keyboard and mouse
- Learners must have basic to intermediate ability in using Microsoft Excel
Funding Information
15 Nov 2023 To 14 Nov 2025
Course Pre-Requisites
Price
| Course Fee Payable | ||
|---|---|---|
| Original Fee | Before GST | With GST (9%) |
| Course Fee | $720.00 | $784.80 |
| Individual Pricing (Fee payable to Training Provider) | Before GST | With GST (9%) |
| Individual (Baseline) | $360.00 | $424.80 |
| Individual (MCES) | $216.00 | $280.80 |
| Corporate Pricing (Fee payable to Training Provider) | ||
| SME | Before GST | With GST (9%) |
| Corporate (SME) | $216.00 | $280.80 |
| Non-SME | Before GST | With GST (9%) |
| Corporate (Non-SME, Baseline) | $360.00 | $424.80 |
| Corporate (Non-SME, MCES) | $216.00 | $280.80 |
Company Sponsored Funding Types
- SME
- Company registered or incorporated in Singapore AND employment size of not more than 200 or with annual sales turnover of not more than $100 million
- 70% of course fee funded
- Non-SME (Baseline)
- Non-SME companies, employee is Singaporean or PR aged below 40
- 50% of course fee funded
- Non-SME (MCES)
- Non-SME companies, employee is Singaporean aged 40 years and above
- 70% of course fee funded
Absentee Payroll Funding for Companies:
- $4.50 per training hour capped at $100,000 per enterprise per calendar year
------------------------------------------------------------------------
Self-sponsored Funding Types
- MCES
- Singaporean aged 40 years and above
- 70% of course fee funded
- Normal
- Singaporean / PR aged 21 years and above
- 50% of course fee funded
