You have no items in your shopping cart.
Course Details
Course Details
What You'll Learn
Topic 1: Excel Fundamentals with Copilot
Topic 2: Skills and Rules
Topic 3: Interactive Dashboards with Copilot, Skills and Rules
Course Info
Minimum Entry Requirement
Knowledge and Skills
- Able to operate using computer functions
- Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)
Attitude
- Positive Learning Attitude
- Enthusiastic Learner
Experience
- Minimum of 1 year of working experience.
Target Age Group: 21-65 years old
Minimum Software/Hardware Requirement
Software:
You will need the following for this course:
- Microsoft 365 Copilot – a training account will be provided
Hardware: Windows PC or Mac laptop
HRD Corp Claimable
This course is HRD Corp claimable for eligible employers. Find out how to apply for the grant and claim the course fee on our HRD Corp Claimable Courses page.
Job Roles
Job Roles
- Data Analyst
- Business Analyst
- Financial Analyst
- Operations Manager
- Marketing Analyst
- HR Metrics Specialist
- Sales Operations Specialist
- Report Developer
- Project Manager
- Management Accountant
- Product Manager
- Supply Chain Analyst
- Performance Metrics Specialist
- Market Researcher
- Business Intelligence Coordinator
Trainers
Trainers
Spreadsheets, dashboards and the logic behind them appear throughout the work of Dr. Alfred Ang, a full-stack AI developer, Agentic AI solution architect and corporate trainer. As Chief Technology Officer of Tertiary Infotech Academy Pte Ltd, the Singapore training organisation behind Tertiary Courses, Dr. Ang builds solutions end to end, covering front ends, back ends, databases, cloud deployment and native mobile apps. Much of that work involves turning raw tables into decisions. Dr. Ang built IT project management Kanban boards with large KPI tiles, colour-coded statuses and project status charts, a portfolio dashboard with project timelines, and a warehouse inventory dashboard with a filterable, sortable stock table and derived stock status. An inventory forecasting agent running on a local language model reads stock levels, flags items under reorder thresholds and computes forecasts automatically. The HR and accounting platform that Dr. Ang developed for the academy calculates leave balances, attendance hours, payroll and expense claims, the kind of rules-based calculation that many teams still maintain in Excel. Interactive Python and Streamlit labs teach beginners data mining and machine learning, and a stock analysis dashboard combines live charts with an AI agent that interprets price movements. Dr. Ang has also written Claude Code skills that package instructions and rules for repeatable AI tasks, an idea that maps closely onto Copilot's skills and rules. The full collection, more than 300 public repositories, is open on GitHub for anyone to explore.
Microsoft 365 Copilot for Excel follows a progression of eight labs across three topics, and Dr. Ang uses real-world data habits to make each one count. In Excel Fundamentals with Copilot, learners prepare and clean data, write effective prompts, generate and explain formulas, analyse results and create charts, learning to check every formula Copilot proposes rather than accepting it blindly. The second topic introduces skills and rules: reusable instructions that tell Copilot how to format outputs, apply business logic consistently and follow the team's conventions, so the same analysis can be repeated next month without rewriting prompts. Dr. Ang draws on experience building reusable AI skills to show how clear, well-scoped instructions produce reliable results. The third topic brings everything together in interactive dashboards built with Copilot, skills and rules, where learners combine pivot tables, charts, slicers and summary insights into a dashboard that a manager can understand at a glance. Throughout the labs, Dr. Ang demonstrates a task, explains the reasoning behind the prompt and then lets learners practise on their own copy, with time to troubleshoot unexpected results together. Data accuracy, privacy and knowing when to fall back on a manual formula are discussed openly. Learners leave with completed lab workbooks, a dashboard they built themselves and a set of prompts, skills and rules they can reuse at work. Shortcuts for reviewing and correcting Copilot's output are shared along the way. Dr. Ang's dashboards and data tools can be explored at https://github.com/alfredang
Saeid Alizadeh is a data analytics and visualisation specialist with more than eight years of hands-on experience in data processing, visualisation and analytics, and is a Microsoft Certified: Power BI Data Analyst Associate. He has trained Malaysian professionals in data analysis and data visualisation with Tertiary Infotech Sdn. Bhd. since 2016 and has been an HRD Corp Accredited Trainer since 2021, specialising in Power BI, Excel data analysis and Tableau. As Chief Technology Officer of Skymics Sdn. Bhd., a Kuala Lumpur MSC Malaysia-status IoT company, he leads solutions in which data from smart energy monitoring, smart plantation, smart building and environmental monitoring systems is collected, cleaned and turned into dashboards and decisions, and he has also worked on social media analytics and smart-city energy management projects. Earlier in his career he served as IT Director at World Wide Science. He is a Certified Citizen Data Scientist Train-the-Trainer and a certified IBM IoT Practitioner and Instructor, is co-inventor of three inventions, and holds an MBA in Information Technology from Multimedia University and a Bachelor's degree in Computer Science (Information Technology).
On this course, Saeid draws on Excel data analysis, one of his core specialisms. He shows learners practical ways to clean and organise data, analyse it with formulas, PivotTables and Power Query, and present results in clear charts and dashboards.
Review
Customer Reviews (21)
- Highly recommended Review by Course Participant/Trainee
-
The training was very practical and hands-on. I could apply what I learned to my work immediately. (Posted on 03/12/2025)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Clear and easy to follow Review by Course Participant/Trainee
-
Very engaging session. The trainer patiently answered all our questions and gave useful tips. (Posted on 19/05/2025)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Would attend again Review by Course Participant/Trainee
-
The trainer was knowledgeable and explained the concepts clearly with real-world examples. (Posted on 11/02/2025)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Highly recommended Review by Course Participant/Trainee
-
Solid content and a supportive trainer. I would definitely sign up for more courses here. (Posted on 10/09/2024)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Fantastic experience Review by Course Participant/Trainee
-
A very practical course. The trainer made a complex topic simple and enjoyable to learn. (Posted on 23/07/2024)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment
Write Your Own Review
- Recommended Courses
