🚀 Diploma in AI Integrated Development: Web × Apps × Data Science 將於 2026年5月7日 開始 Early Bird 優惠 🎓 英國學歷課程! NCC Diploma in Computing 將於 2026年5月5日 註冊截止日期 Limited Seats
Office - Copilot

Certificate in Microsoft Copilot 365: Copilot AI For Microsoft 365 Office

Your New Way to Work in Future

Copilot Banner

課程簡介

Microsoft Copilot 是一款強大的 AI 工具,能與 Microsoft 365 應用程式無縫整合,幫助你大幅提升工作效率。 這門課程將引導你全面掌握 Copilot 在 Word、PowerPoint、Excel 及 Outlook 中的應用技巧。你將學會如何利用它來建立和編輯文件與簡報,進行數據分析,以及撰寫和管理郵件。 無論你是職場新手還是資深工作者,這門課程都能幫助你充分利用 AI 的力量,將 Copilot 轉化為你的得力助手。

課程目標

Web Interface and Prompting

掌握 Microsoft Copilot 的免費網頁介面及企業帳號介面,並學會提示工程語義關聯及提示技巧。

Prompt Engineering

學會提示工程中的角色提示、語義提示以及單次與多次提示的最佳實踐。

Microsoft Word

使用 Microsoft Copilot 建立文檔,進行格式化、語氣調整,並進行文檔摘要與表格化。

Microsoft PowerPoint

使用 Microsoft Copilot Pro 建立 AI 驅動的簡報,生成圖表與圖像,並組織長簡報內容。

Microsoft Excel

利用 Microsoft Copilot 進行數據洞察、公式生成、數據清理、轉換以及可視化分析。

Data Transformation

學會利用 Copilot 進行數據分割、重組與格式化處理,以滿足不同的分析需求。

Microsoft Outlook

使用 Copilot 寫作智慧郵件、總結郵件線索、自動回覆並提升郵件撰寫技巧。

AI-Powered Efficiencies

使用 Microsoft Copilot 實現工作流程自動化,提升生產效率並優化日常工作成效。

Video Images
Demo Video -
Creating a Pivot Table for business data

課程相關資料

  • 課程對象針對企業客戶而設
  • 上課模式面授上課或者即時網上教學
  • 上課安排客戶可到本校上課或要求導師上門授課
  • 上課收費每班最多20人,每班收費$10,800
  • 課程時數6小時
  • 使用軟件Office 365 需持有 Copilot Pro 授權
  • 入學要求任何具有 Office 工具經驗者均可參加

課程內容

Microsoft Copilot Web Interface
  • Microsoft Copilot's Free Web Interface Navigation and Operation
  • Microsoft Copilot Web Interface Using Work Account
  • Understanding Copilot Interface Features and Capabilities
  • Accessing Different Copilot Models and Settings
Prompt Engineering Fundamentals
  • Definition and Importance of Prompt Engineering
  • How AI Language Models Work and Their Limitations
  • Basic Components of Effective Prompt Structure
  • Understanding Context and Token Limitations
Advanced Prompting Techniques
  • Prompt Engineering Semantic Association & Role Prompting
  • Zero-shot, One-shot, and Few-shot Prompting Methods
  • Chain-of-Thought Prompting Techniques
  • Context Learning and Example-driven Prompt Design
  • Creating and Reusing Prompt Templates
Prompt Optimization Strategies
  • Writing Clear, Specific, and Actionable Prompts
  • Good vs Bad Prompts: Detailed Example Analysis
  • Balancing Prompt Length and Complexity
  • Scenario-specific Prompt Customization Strategies
  • Systematic Approach to Prompt Iteration and Improvement
  • Handling AI Response Bias and Error Correction
Microsoft 365 Specific Prompting
  • Prompt Formats Specific to Microsoft 365 Applications
  • Cross-application Consistency in Prompting Strategies
  • Enterprise Environment Prompt Security Considerations
  • Multilingual Prompt Design and Application

Document Creation with Copilot
  • Creating Documents in Microsoft Word with Copilot
  • Referencing Existing Documents while Creating Drafts With Copilot
  • Create Documents With Proper Formatting With Microsoft Copilot
  • Automated Document Drafting: Letters, Reports, and Proposals
Document Enhancement and Editing
  • Rewriting Documents and Finetuning Tones of Writings with Copilot
  • AI-powered Document Summarization, Rewriting, and Proofreading
  • Extracting Key Insights and Generating Action Items from Long Documents
  • Document Quality Improvement Using AI Prompts
Advanced Word Features with Copilot
  • Tabularize your Word Documents with Microsoft Copilot
  • Product Research and Comparison with Copilot
  • Summarizing Documents, Creating Images and Prompt Gallery of Microsoft Copilot
  • Creating Reusable Templates and Content with AI
Professional Document Workflows
  • Workflow Automation: Generating Templates and Reusable Content
  • AI-driven Personalization of Business Communication Content
  • Collaborative Document Creation and Review Processes
  • Version Control and Change Tracking with AI Assistance
Practical Exercises
  • Drafting Professional Business Letters Using Prompts in Word
  • Summarizing Long Reports with Copilot
  • Improving Poor-quality Documents Using AI Prompts
  • Creating Reusable Prompt Template Libraries

PowerPoint Copilot Pro Fundamentals
  • Microsoft Copilot Pro for AI Powered Presentations
  • Navigating Microsoft Copilot Pro in Power Point
  • Creating Presentations Using Microsoft Copilot Pro in Power Point
Presentation Creation and Design
  • Outlining and Reformatting Presentations and Perform Web Search with Copilot
  • Create Presentations using Existing or New Templates with Copilot
  • Create Presentation From File and Word Documents with Copilot
  • AI-assisted Presentation Creation from Raw Content
Advanced Editing and Enhancement
  • Editing Presentations and Adding New Slides Using With Formatting Copilot
  • Adding AI Generated Images to Your Slides With Microsoft Copilot Pro
  • Designing Slides with Suggested Visuals, Animations, and Layouts
  • Customizing Presentations Based on Audience or Purpose
Presentation Management and Optimization
  • Summarizing and Organizing Long Presentations With Microsoft Copilot
  • Asking Important Questions on Presentations and Copilot's Prompt Gallery
  • Content Quality Enhancement and Consistency Checks
  • Presentation Flow and Narrative Structure Optimization
Practical Exercises
  • Creating Complete Presentations with AI-suggested Slides and Visuals
  • Customizing Presentation Content and Style Based on Audience Needs

Excel Copilot Pro Fundamentals
  • Microsoft Copilot Pro with Excel Usecases With Examples
  • Generating Data Insights Using Microsoft Copilot
  • Creating Formula Columns With Microsoft Copilot Pro
Data Analysis and Processing
  • Asking Complex Data Questions and Creating Pivot Tables Using Microsoft Copilot
  • Applying Data Filters using Microsoft Copilot
  • Advanced Data Filtering along with Data Analysis
  • Conditional Formatting Excel Tables With Microsoft Copilot
  • Sorting Data and Excel Table with Copilot
Data Visualization and Transformation
  • Data Visualizations using Microsoft Copilot Creating Charts & Graphs
  • Data Cleaning and Transformation Using Copilot
  • Data Transformation and Analysing With Microsoft Copilot
  • Creating Interactive Dashboards and Data Stories
Advanced Excel Automation
  • Automating Repetitive Data Tasks with AI Assistance
  • Data Validation and Error Detection Using Copilot
  • Trend Analysis and Forecasting with AI Support
  • Complex Formula Creation and Optimization
Practical Exercises
  • Analyzing Complex Datasets and Generating Reports Using Copilot in Excel
  • Creating Interactive Data Dashboards and Visualization Charts

Outlook Copilot Core Features
  • AI-powered Email Drafting and Smart Replies
  • Email Content Summarization and Key Point Extraction
  • Automatic Email Tone and Style Adjustment
  • Extracting and Organizing Action Items from Emails
  • Email Priority Management and Smart Classification
Meeting Management and Invitations
  • Creating and Sending Smart Meeting Invitations with Copilot
  • Automated Meeting Scheduling and Calendar Conflict Management
  • Creating Meeting Agendas and Preparation Materials
  • Personalizing and Customizing Meeting Invitation Content
  • Setting Smart Reminders and Follow-up Tasks
  • Managing Meeting Responses and Participant Status
Microsoft Teams Copilot Applications
  • Real-time Copilot Assistance Features in Teams Meetings
  • Automatic Generation of Meeting Summaries and Action Items
  • Smart Replies and Content Suggestions in Teams Chat
  • Creating and Managing Teams Channel Content with Copilot
  • Smart Editing and Suggestions for Collaborative Documents
  • Cross-team Information Integration and Knowledge Management
Teams Meeting Optimization and Management
  • Intelligent Pre-meeting Preparation and Material Organization
  • Real-time Note-taking and Key Point Capture During Meetings
  • Post-meeting Automatic Summaries and Task Assignment
  • Multilingual Meeting Support and Translation Features
  • Smart Indexing and Search for Meeting Recordings

Instructor

Dannis Mok

who has rich experience in business web and apps system development and have over 20 years of teaching experience. He has great passion in learning and teaching new technologies and his teaching style is clear to point and can explain complex technologies in simple terms. He has delivered various workshops and classes for different corporate, government departments and local universities and is the principal lecturer for NCC Education and University of Greenwich. Besides BSc degree in IT, he also got a MBA, MSc in IT and MSc in Telecommunication degree.

CompTIA Data Plus
相關專業認證
  • Microsoft MCSE, MCDBA
  • Microsoft Certified System Developer
  • Microsoft Office Specialist Master
  • Cisco CCNA,CCDA,CCNP,CCDP
  • Sun Microsystems – Certified Java Programmer
  • Oracle – Certified Database Professional
  • Linux - LPI Level 1 & 2
  • CompTIA Data+
  • Microsoft Certified: Power BI Data Analyst Associate
  • Python Institute: Certified Associate Python Programmer
相關教學經驗
  • 為積金局 (MPF) IT 員工提供 Android 及 iPhone 視像培訓課程
  • 為香港教育局提供 Android 培訓課程予中學電腦科導師
  • 為香港教育大學 IT 員工提供 Cordova 跨平台流動程式開發課程
  • 為房屋署員工 IT 員工提供 HTML5 跨平台流動程式開發課程
  • 為房屋署員工 IT 員工提供 Android 及 iPhone 平台流動程式開發課程
  • 為香格里拉大酒店IT 員工提供 Android 流動程式開發課程
  • 為勞工處提供 HTML5 遊戲培訓課程及電子商店培訓課程
  • 為中國銀行IT 員工提供 Android 及 iPhone 流動程式開發課程
  • 為香港郵政IT 員工提供 Angular 8 程式開發課程
  • 為 VTC 職業訓練局提供各種各類 IT 培訓課程
  • 為醫管局員工 IT 員工提供跨平台流動程式開發課程

企業客戶

導師曾教授以下客戶 - 辦公室軟件或者相關課程
  • Prince Hotel 香港太子酒店
  • Marco Polo Hong Kong Hotel 馬哥孛羅香港酒店
  • Kerry Warehouse 嘉里貨倉
  • Labor Department 勞工處
  • Baguio Green Group 碧瑤綠色集團
  • 香港耆康老人福利會
  • Education Bureau 教育局
  • Hong Kong Institute of Education 香港教育大學
  • Hong Kong Housing Authority 香港房屋委員會
  • Hong Kong ICAC 香港廉政公署
  • Hang Seng Bank 恒生銀行
  • Civil Aivation Department 民航處
  • Darty Asia
  • UA Finance 亞洲聯合財務有限公司
  • 基督教香港信義會
  • NCSI Hong Kong Ltd
  • 香港善道會
  • 恆生銀行
  • 聯合國兒童基金會
  • City University of Hong Kong 香港城市大學
  • 香港明愛
  • 救世軍
  • City Facilities Management Holdings Ltd
  • HACEO 香港飛機工程
  • JLL 仲量聯行
  • Hong Kong VTC 職業訓練局
  • Hong Kong IVE 香港專業教育學院
  • Adidas Hong Kong
  • Polyplastics
  • Apex Logistics
  • Defond 德豐
  • JAS Worldwide
  • VTech Hong Kong 偉易達香港
  • VTech Hong Kong 偉易達香港
  • YWCA 女青年會
  • 東華三院
  • iRobot Hong Kong
  • Bureau Veritas
  • Boardway 百老滙
  • StarLite Holdings (星光集團)
  • Puma Hong Kong
  • Marriott International 萬豪國際
  • WheeLock會德豐
  • 香港立信德豪會計師事務所 (BDO)
  • Kering Group
  • 中華電力有限公司
  • Wilko Worldwide Limited
  • 華懋集團
  • 機電工程署
  • 無國界醫生
  • Unilever Hong Kong 聯合利華
  • 獅王 (Lion Corporation)
  • 菱電商事株式会社
  • Merck & Co 默克藥廠
  • 九龍木球會
  • 香港航空發動機維修服務有限公司
  • 維他奶國際集團
  • Toyota 豐田汽車
  • adidas Hong Kong
  • 連續五年 (2017,2018,2019,2020,2021) 為VTC 職業訓練局的員工作培訓
  • 連續八年為勞工處YES的會員作”辦公室軟件”培訓
  • 浸會大學
  • 西門子 Siemens
  • Fujitsu Hong Kong
  • Luxasia
  • Miele
  • Pacific Coffee
  • PersolKelly
  • Schmoll Group
  • Johnson & Johnson
  • 周大福集團
  • Tory Burch
  • 南洋商業銀行
  • 新鴻基
  • 迪士尼樂園
  • 一田百貨