Excel Skills for Workplace Digitalisation
About This Course
In this 2-day course, learners will be competent in managing workplace data using intermediate Excel tools to support reporting and operational decision-making. Learners will master formatting and validation, intermediate functions including XLOOKUP and SUMIFS, PivotTables, charts, and basic automation with examples drawn from sectors including Food & Beverage, Hospitality, Retail, and Logistics.
Through hands-on practice, learners will produce accurate spreadsheets and actionable reports that improve workplace efficiency. By the end of this course, learners will handle data and meet employer expectations for Excel proficiency in digitally enabled workplaces.
What You'll Learn
1. Format and validate spreadsheet data using styles, conditional formatting, and validation rules to ensure accuracy.
2. Apply functions including XLOOKUP, SUMIFS, and COUNTIFS to solve business problems such as sales monitoring, inventory tracking and scheduling.
3. Analyse datasets using PivotTables, filters, and charts to generate reports that support workplace decision-making.
4. Consolidate information across worksheets using linking and basic macros to streamline reporting processes efficiently.
5. Present data findings clearly using appropriate charts and formatting to communicate insights to workplace stakeholders.
Entry Requirements
* Completed GCE N-Level OR equivalent (e.g. ITE Skills Certificate),
OR
* Mature candidates aged 21 and above with relevant working experience.
English literacy requirement:
* Able to read workplace instructions and prepare basic written communication equivalent to GCE N/O-Level English proficiency.
Digital literacy requirement:
* Able to operate a computer for basic functions such as:
* Logging into a computer
* Saving/opening files
* Typing text
* Using a mouse and web browser