• Home
  • Microsoft 365 Copilot for Excel

Microsoft 365 Copilot for Excel

Course Information

  • Sessions 1 day
  • Duration 7.5 hrs
  • Level Intermediate
  • Assessment NA

Venue

Kuala Lumpur: G-3A-02, Suite Pejabat Korporat, KL Gateway, No 2, Jalan kerinchi, Gerbang kernichi Lestari, 59200 Kuala Lumpur, Malaysia
Penang: Jalan Sungai Dua, 11700 Penang, Malaysia.

Download Course Brochure

Certification

  • Certificate of Completion from Tertiary Courses - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Completion from Tertiary Courses.

Microsoft 365 Copilot for Excel

Course Code: C34
  • HRDF

9 Review(s) | Add Your Review

What's This Course About

Transform the way you work with spreadsheets in Microsoft 365 Copilot for Excel. This hands-on 1-day course shows you how Copilot—the AI assistant built into Excel—lets you analyse data, generate formulas and build reports using plain-English prompts instead of memorising functions. You will learn to prepare your data as Excel tables so Copilot works at its best, ask Copilot to highlight, sort and filter data, generate complex formula columns, and surface trends and insights instantly.

Through practical exercises, participants will use Copilot to clean and enrich real-world datasets, build PivotTables and charts from a simple request, run deeper analysis with Advanced Analysis and Python in Excel, and turn raw data into presentation-ready summaries. You will also learn prompt best practices and the limits of AI-generated analysis so you can verify results with confidence. By the end of the course, you will be able to complete everyday Excel analysis tasks in a fraction of the time—no advanced formula knowledge required.

Course Fee

MYR1,100.00

Course Date

Additional Note

Please bring your own laptop for hands-on training. If you don't have laptop, we can provide spare laptop for training use.

Disclaimer: The course dates displayed on our website are tentative and subject to trainer availability. We will confirm the final date after checking with the trainer. You are also welcome to email us your preferred date at sales@tertiarycourses.com.my, and we will do our best to coordinate with the trainer's schedule.

Post-Course Support

  • We may provide consultation related to the subject matter after the course.
  • Please email your queries to sales@tertiarycourses.com.my and we will forward your queries to the subject matter experts and get back to you as soon as possible.

Cancellation & Reschedule Policy

  • We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% to participants.
  • Note: the venue of the training is subject to changes due to class size and availability of the classroom. The minimum class size to start a class is 3 Pax.

Course Details

Course Details

What You'll Learn

Topic 1: Getting Started with Copilot in Excel

  • Introduction to Microsoft 365 Copilot in Excel
  • Preparing Data as Excel Tables for Copilot
  • Writing Effective Prompts for Data Tasks
  • Highlighting, Sorting and Filtering Data with Copilot
  • Generating Formula Columns from Plain-English Requests

Topic 2: AI-Powered Data Analysis and Insights

  • Cleaning and Enriching Data with Copilot
  • Building PivotTables and Charts from a Prompt
  • Surfacing Trends, Outliers and Insights
  • Advanced Analysis with Python in Excel
  • Verifying Results and Prompt Best Practices

Course Info

Promotion Code

Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.

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 can download and install the following software:

Hardware: Windows and Mac Laptops

  • The staff will send you an invoice with the fee breakdown.
  • Enter the course fee payable by you (including GST) and enter the amount of credit to claim.
  • Upload your invoice and click ‘Submit’

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

Saeid is co-founder of Skymics Sdn Bhd. He has 8 years of experience in the field of IoT (Internet of Things) and Information Technology. He is a certified IBM IoT Practitioner and instructor, and a Certified Citizen Data Scientist Train-The-Trainer. He has been co-inventor of 3 inventions during the last 4 years.

Review

Customer Reviews (9)

Would attend again Review by Course Participant/Trainee
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
The trainer was knowledgeable and explained the concepts clearly with real-world examples. (Posted on 11/02/2025)
Highly recommended Review by Course Participant/Trainee
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
Solid content and a supportive trainer. I would definitely sign up for more courses here. (Posted on 10/09/2024)
Fantastic experience Review by Course Participant/Trainee
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
A very practical course. The trainer made a complex topic simple and enjoyable to learn. (Posted on 23/07/2024)
Very useful course Review by Course Participant/Trainee
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
Very engaging session. The trainer patiently answered all our questions and gave useful tips. (Posted on 19/04/2024)

Items 6 to 9 of 9 total

per page
Page:
  1. 1
  2. 2

Write Your Own Review

You're reviewing: Microsoft 365 Copilot for Excel

How do you rate this product? *

  1 star 2 stars 3 stars 4 stars 5 stars
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