This course equips learners with the essential skills to create, format, and manage spreadsheets effectively. It covers key concepts and practical techniques for organizing data, performing calculations, and presenting information using charts and formulas.
Learning Outcomes:
Identify key features of Excel for data work
Apply basic functions to clean and analyse data
Create visual representations of data using charts
Organize and format data for clarity and accuracy
Manage multiple worksheets and prepare spreadsheets for printing
Key Topics:
Apply formulas and functions to perform calculations
Excel data functions and formatting tools
Chart creation and dashboard layout
Basic statistical tools and interpretation
Exam Details
This course is designed to build participants’ understanding of key concepts and domains covered in the Data and Statistical Analytics with Excel (SFw) certification.
Participants will be prepared to attempt the certification exam, which assesses proficiency in essential Excel techniques for data management, formatting, formulas, and basic analytics.
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: Getting Started with Spreadsheets
- Starting Excel
- The User Interface
- Using Microsoft Excel Help and Resources
- Exit Excel
Lesson 2: Basic Workbook Functions
- Cells Navigation
- Using GoTo
- Entering Data
- Shortcuts for Data Entry
- Editing Data
- Spell Check
- Saving and Creating New Workbook
Lesson 3: Working with Selection
- Selecting a cell
- Selecting a range of adjacent cells
- Selecting a range of non-adjacent cells
- Selecting the entire worksheet
- Selecting a row
- Selecting a range of adjacent rows
- Selecting a range of non-adjacent rows
- Selecting an entire column
- Selecting a range of columns
- Selecting a range of non- adjacent columns
Lesson 4: Formatting the Worksheet
- Adjusting the Column Width
- Adjusting the Row Height
- Automatically Adjusting Columns
- Hiding and Un-hiding Rows and Columns
- Inserting Columns and Rows
- Deleting Columns and Rows
- Freezing and Unfreezing Columns and Rows
- Apply Number Formats
- Apply Text Formats
- Apply Borders and Fill
- Format Painters
- Clearing Formats
Lesson 5: Formulas and Functions
- Using Basic Formulas
- Entering Formulas
- Basic Functions
- Using the AutoSum Button
- Using Statistical Functions (MAX, MIN, COUNT, AVERAGE)
- Using AutoFill
- Editing Functions
- Using Date Functions
- Error Checking
- Create Absolute Reference
- Using IF Function
Lesson 6: Working with Tables
- Apply Table Formats
- Changing Table Style
- Adding Table Rows and Columns
- Adding Total Row in Table
- Apply Table Filters
Lesson 7: Data management
- Sorting
- Finding Data
- Replacing Data
- Finding and Replacing Cell Format
Lesson 8: Charts
- Inserting a chart
- Resizing a chart
- Deleting a chart
- Adding a Chart Title
- Changing the Chart Background
- Formating chart legend, axis
- Changing a column, bar, line or pie slice colors
- Changing the chart type
- Adding a Data Table
- Changing the Chart Layout
- Moving charts
- Deleting chart
Lesson 9: Preparing outputs
- Worksheet margins
- Worksheet orientation
- Worksheet page size
- Add Headers and Footers
- Scaling your worksheet to fit a page(s)
- Repeating Row and Column Labels
- Changing Page Breaks
- Setting/Removing a Print Area
- Printing the Current Worksheet
- Printing a Selected Range
- Printing Multiple Copies
.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)
