Businesses need professionals who can bridge data and decision-making. This course is designed to equip learners with advanced spreadsheet skills using Microsoft Excel. It focuses on enhancing productivity, improving data analysis, and producing professional reports.
Learning Outcomes:
Perform statistical analysis using Excel functions
Visualise data with appropriate chart types
Apply pivot tables and slicers for data summarisation
Key Topics:
Advanced Formatting Techniques
Pivot tables, pivot charts, and data filters
Productivity Features such as Macros
Exam Details
This course also prepare participants' on key concepts and domains covered in the ICDL Management Spreadsheets certification.
To maximise success, participants are strongly encouraged to complement the course with additional self-study, revision of course materials, and dedicated practice before attempting the exam.
FUNDING INFORMATION
SkillsFuture Singapore (SSG)
Funding is available on Course Fee. Please see below for the eligibility categories available.
| Self-sponsored | Singapore Citizen & PR aged ≥ 21 years | Up to 50% funding |
| Singapore Citizen aged ≥ 40 years | Up to 70% funding | |
| Company Sponsored (Non-SME) | Singapore Citizen & PR aged ≥ 21 years | Up to 50% funding |
| Singapore Citizen aged ≥ 40 years | Up to 70% funding | |
| Company Sponsored (SME) | Singapore Citizen & PR aged ≥ 21 years | Up to 70% funding |
| Singapore Citizen aged ≥ 40 years | Up to 70% funding |
SSG Funding Requirements
- Trainees must scan their attendance twice daily using the SingPass application.
- Trainees must attain at least 75% attendance.
- Trainees must pass the in-house assessment to be eligible for funding.
- Trainee and/or sponsoring company is/are required to meet all SSG-mandated eligibility criteria and requirements for funding. For more information, please refer to SkillsFuture homepage.
Appeal Policy and Procedure
- As a candidate in this course assessment, you may appeal your results if you disagree with them.
- To do so, submit your written appeal request via email to esv_comat_cse@stengg.com within 3 working days from date of assessment.
Cancellation, Postponement and Refund Policy
- Request for cancellation or postponement must be submitted in writing more than 4 weeks before the class start date to avoid any charges.
- Written notice for cancellation or postponement received 2 to 4 weeks before class start date will incur Late Cancellation Charge - 50% of course fee.
- Written notice for cancellation or postponement received less than 2 weeks before class start date will incur Late Cancellation Charge - 100% of course fee.
- If payment has been made and ST Engineering e-Services Pte Ltd accepts the trainee's written notification to cancel or withdraw from the course, ST Engineering e-Services Pte Ltd will issue a refund, less any applicable Late Cancellation Charges.
Feedback Policy and Procedure
- You may submit feedback via email to esv_comat_cse@stengg.com or your servicing Account Manager.
- Any formal feedback will be handled within 10 working days from receipt with a written reply given. An interim reply will be provided should more time be required.
Lesson 1: Conditional Formatting
- Applying Conditional Formats
- Changing a Conditional Format
- Adding a Conditional Format
- Creating a Custom Conditional Format
- Using Data Bars
- Deleting a Conditional Format
- Creating a Custom Number Format
Lesson 2: Templates
- Saving a Workbook as a Template
- Using a Template
- Editing a Template
- Deleting a Template
Lesson 3: Advanced Chart
- Formatting an Axis
- Changing the Axis Scaling
- Formatting the Data Series
- Adding Data from Different Worksheets
- Using a Secondary Axis
- Changing Data Series Chart Types
- Changing Source Data Range
Lesson 4: Naming Cells and Ranges
- Assigning Names
- Using Range Names in Formulas
- Creating Range Names from Headings
- Applying Range Names
- Deleting Range Names
- Using Range Names in 3-D Formulas
Lesson 5: Validation and Auditing
- Sorting
- Multiple Levels Sort
- Using Custom Sort
- Creating Subtotals in a List
- Removing Subtotals from a List
- Using Data Validation
- Validating Data using a List
- Creating a Custom Error Message
- Removing Data Validation
- Displaying/Removing Dependent Arrows
- Displaying/Removing Precedent Arrows
- Showing Formulas
- Protecting a Worksheet
- Unprotect a worksheet
- Assigning a Password to a File
- Removing a Password from a File
Lesson 6: Advanced Formulas and functions
- Using the VLOOKUP Function
- Using the HLOOKUP Function
- Using the IF Function
- Using the IFS Functions
- Using an AND Condition with IF
- Using an OR Condition with IF
- Using the ROUND Function
- Using Date Function
- Using COUNTIF / SUMIF Function
- Using COUNTIFS / SUMIFS Function
- Using RANK Function
- Using Financial Functions
- Using Text Functions
Lesson 7: Advanced Filter
- Creating a Criteria Range
- Using a Criteria Range
- Showing All Records
- Using an Advanced And Condition
- Using an Advanced Or Condition
- Copying Filtered Records
- Using Database Functions
- Removing Duplicates from a Table
Lesson 8: Importing and Linking
- Importing Data from Text Files
- Use Text to Column
- Removing the Query Definition
- Creating a Hyperlink
- Editing a Hyperlink
Lesson 9: PivotTables
- Creating a PivotTable Report
- Adding PivotTable Report Fields
- Selecting a Page Field Item
- Refreshing a PivotTable Report
- Changing the Summary Function
- Adding New Fields to a PivotTable Report
- Moving PivotTable Report Fields
- Hiding/Unhiding PivotTable Report Items
- Deleting PivotTable Report Fields
- Creating a Page Field Report
- Formatting a PivotTable Report
- Creating a PivotChart Report
Lesson 10: Scenario Analysis
- Creating a Scenario
- Displaying a Scenario
- Editing a Scenario
- Creating a Scenario Summary Report
- Working with Data Tables
- Placing Formulas in Data Tables
- Creating a One-Variable Table
- Creating a Two-Variable Table
Lesson 11: Macros
- Recording a Macro
- Saving a Macro-Enabled Workbook
- Running a Macro
- Assigning a Shortcut Key
- Using a Shortcut Key
- Deleting a Macro
- Adding a Macro to Quick Access Toolbar
- Deleting a Macro Button from QAT
Optional 12: Share workbook
- Saving a Shared Workbook
- Viewing Shared Workbook Changes
- Changing the Update Frequency
- Highlighting Changes
- Managing Conflicting Changes
- Resolving Conflicting Changes
- Setting Change History Options
- Adding a History Worksheet
- Reviewing Tracked Changes
.png?width=50&name=Artificial%20Intelligence%20(AI).png)
-1.png?width=360&name=Server%20(4)-1.png)
/AI%20(6)-1-1.png?width=360&name=AI%20(6)-1-1.png)
/AI%20(8)-1.png?width=360&name=AI%20(8)-1.png)
-1.png?width=360&name=Automation%20RPA%20(2)-1.png)
/AI%20(5)-1.png?width=360&name=AI%20(5)-1.png)
