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
Prerequisite
Basic computer and file-management skills are expected. Familiarity with basic Excel worksheets, formulas and tables will help you follow the exercises.
Software Requirement
You will need the following for this course:
- Microsoft 365 Copilot – confirm training-account availability with the trainer
Install and test the listed software before class. Confirm the required version and account or licence access in your joining instructions. Cloud and AI services may charge subscription or usage fees.
Hardware Requirement
Use a Windows laptop for Power Pivot, desktop automation or Windows-only Excel features. For other Excel exercises, a supported Windows or Mac version can be used; confirm feature compatibility with the trainer.
Bring your own computer and charger, with a reliable internet connection and permission to install the required software. For live online classes, also prepare a microphone or headset.
If you need help arranging a suitable device, contact us before the class to confirm availability.
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
Dr. Muhammed Siraj is a cybersecurity specialist and academic with 15 years of experience, serving as Senior Lecturer in the Department of Informatics and Director of Graduate and Continuous Education at Academic City University in Accra. He holds a PhD in Security in Computing from Universiti Putra Malaysia, where his research focused on blockchain security, an MSc in Information and Communication Technology from Aalborg University in Denmark, and a degree from the University of Ghana. He is a licensed independent assessor with Ghana's Cyber Security Authority, holds leadership roles in national cybersecurity and privacy professional bodies, and is certified as a Certified Ethical Hacker (CEH), Computer Hacking Forensic Investigator (CHFI) and Certified Data Protection Supervisor (CDPS). Before joining Academic City, he served as Acting Director of ICT and Data Protection Supervisor at Wisconsin International University College. His expertise spans penetration testing, digital forensics, incident response, malware analysis, cryptography, cloud and IoT security, zero trust architecture, cyber threat intelligence, data protection, and governance, risk and compliance.
Dr. Siraj's research interests cover blockchain, cybersecurity, distributed computing, consensus protocols and machine learning, with published work on blockchain consensus security, smart-contract privacy preservation for sensitive records in the cloud, and new consensus mechanisms. This background gives him a distinctive perspective on artificial intelligence: as organisations adopt AI tools, agents and data-driven automation, he helps learners understand how to protect the data these systems depend on, recognise new attack surfaces, and put sound governance, privacy and access controls in place so that AI can be used safely and responsibly. In the classroom he connects technical practice with regulation, privacy and human factors, drawing on real-world security and data-protection cases to show how concepts apply in professional settings, and his experiential, hands-on teaching style has made him a trusted trainer for students and working professionals alike.
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
Review
Customer Reviews (9)
- Would attend again Review by Course Participant/Trainee
-
The trainer was knowledgeable and explained the concepts clearly with real-world examples. (Posted on 3/25/2026)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
-
The training was very practical and hands-on. I could apply what I learned to my work immediately. (Posted on 12/19/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 6/3/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 - Excellent course Review by Course Participant/Trainee
-
Excellent delivery and good balance between theory and practice. Learned a lot in a short time. (Posted on 5/19/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 5/4/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
Write Your Own Review
- Recommended Courses
