課程資料
Certificate in Microsoft 365 (前稱 Microsoft Office)
MASTEROFFICE19
 
若想更了解以上資訊,歡迎致電 3106 8211 查詢。
 
課程費用: $1500

 
課程費用無須申請任何政府基金資助。

繳費方法:

一般課程:按月等額收取列明的課程費用。本中心將不早於課程開始的一個月前收取第一期費用。除第一期的費用外,每期的費用會在課程進行期間每月的首個上學日或之後收取。

組合課程:若該課程為組合課程,本中心將按該組合課程分科收費,直至所收學費為該組合課程的等額費用為止。

 
退款安排: 本中心備有完善之退款政策及程序。學生將會於報讀課程前獲發有關之文件,學員亦可按此閱讀。
 
質素保證: 本中心備有完善之免費補堂,免費重讀及彈性上課安排,令學員更有保障。
 
   
理論: 0小時 實習: 18小時 示範: 0小時

合共: 18小時

 


課程內容:
Module 1 - Getting Started with Microsoft Office (2 Hrs)
1.

Getting Started

2.

Microsoft 365 online basic

3. Word 365 new features
4. Excel 365 new features
5. PowerPoint 365 new features
6. Document collaboration and co-authoring
Module 2 - Microsoft OneNote (1 Hrs)
1. OneNote basics
2. Take Note
3. Sync and Share
4. Work with images
5. Stay Organized
Module 3 - Microsoft Word – Core (3 Hrs)
1. Managing Document
Converting a document to pdf
Opening and editing PDF content in Word
Recovering unsaved document
2. Page Layout
Margins
Page Orientation
Paper Size
3. Font Formatting
Formatting text
Copy formatting
4. Paragraph Formatting
Line spacing
Indentation
5. Creating Content
Creating a Quick Parts
Inserting a Quick Parts to a document
Changing the Content of a Quick Parts
Renaming a Quick Parts
Deleting a Quick Parts
6. Controlling Page Appearance
Inserting Page Break
Removing Page Break / Section Break
Inserting Section Break
7. Page Numbering
Inserting page numbering
Delete page numbers
Adding different page numbers or number formats to different sections
8. Creating Header / Footer
Header and Footer
Editing a header or footer
 Removing all headers / footers
9. Newsletter Columns
Creating Newsletter Columns
Module 4 - Microsoft Word – Advanced (3 Hrs)
1. Multi-level Numbering
Inserting Multi-level list
Demoting and Promoting Lines On Your Multilevel List
Create a new multilevel list style to add to the gallery
2. Using Styles
Applying styles
Modifying a style by updating it to match formatting in your document
Modify a style manually in the Modify Style dialog box
Create a new style based on document formatting
Save a custom theme for reuse
3. Creating a Table of Contents
Creating the table of contents
Updating the Table of Contents
Customizing the Table of Contents
Deleting the Table of Contents
4. Footnotes or Endnotes
Inserting Footnotes or Endnotes
Converting Footnotes to Endnotes (or vice versa)
Removing Footnote or Endnote
5. Using Index
Creating an Index Using a Concordance File
Auto marking your Text
Inserting an Index
Updating an index
Removing Index Entries
6. Using Mail Merge
Mail merge using an Excel spreadsheet
How to format specific mail merge fields?
Mail merge: number format
Mail merge: currency format
Mail merge: percentage format
Mail merge: date and time format
7. Tables
Inserting a Table
Designing a Table
Display or hide table gridlines in a document
Prevent a table row from breaking across pages
Force a table to break across pages at a particular rows
Delete columns and rows in a table
Add columns and rows in a table
Merge or split cells
Resizing a table, column, or row
8. Collaborating on Documents
Tracking Changes
Keep Track Changes on
Turn off Track Changes
Changing options for Track Changes
Accepting or rejecting tracked changes
Inserting or deleting a comment
Replying to comments in a document
Marking comments as done
Delete a comment
 Protect a document with a password
 Removing a password from a document
Module 5 - Microsoft Excel – Core (3 Hrs)
1. Basic Workbook Skills
Selecting specific cells or ranges
Selecting Rows, Columns, and Special Ranges
Entering data
Special Pasting
Freezing panes to lock rows and columns
Page Setup
Scaling a worksheet before print
Printing row and column headings
2. Adding Headers / Footers / Page Number
Adding Header Or Footer to a worksheet in Page Layout view
Removing Header And Footers
Removing all Headers Or Footers at once
3. Printing a Worksheet and Workbook
Setting Printing Options
Printing one or several worksheets
4. Formatting Cells
Format numbers as currency
Format a date the way you want
Create a custom date format
Create a custom number format
5. Analysing Trends in data using Sparklines
Inserting a Sparkline
Customizing your Sparklines
6. Applying Conditional Formatting
Highlight Cells Rules
Top / Bottom
Data Bars
Icon Sets
Manage Rules
Clear Rules
7. Data Validation
Adding Data Validation to a cell or range
Display an optional input message
Specify an optional alert or error message when invalid data is entered
8. Creating a Formula by using a Function
About the syntax of functions
Creating a formula by using a function
The difference between absolute, relative and mixed references
9. Maths Functions
Module 6 - Microsoft Excel - Advanced (3 Hrs)
1. Date and Time Functions
2. Text Functions
3. Logical Functions
4. Lookup Functions
5. Statistical Functions
6. Analysing Data using Analyze Data
7. Using PivotTables to Analyse Your Data
Creating a PivotTable
Building out your PivotTable
Refreshing PivotTables
Changing or updating PivotTable data
Changing Report Layout
Changing the number format for a field
Filtering Data using Slicer
Grouping or Ungrouping data in a PivotTable report
8. Password protect worksheet or workbook elements
Protecting an Excel file
Unprotecting an Excel file
Protecting worksheet elements
Locking only specific cells and ranges in a protected worksheet
Module 7 -  Microsoft PowerPoint (3 Hrs)
1. Creating a Basic PowerPoint Presentation
Choosing the right view for the task in PowerPoint
Views for creating your presentation
Views for delivering and viewing a presentation
Creating a PowerPoint Presentation
Adding text to placeholder
Adding New Slide
Saving your presentation file
2. Understanding Slide Layout
What is slide layout?
Applying a layout to a slide
Changing the size of your slides
3. Understanding Theme
Overview of Office themes
Adding colour and design to my slides
4. Get Design Ideas
5. Using Slide Master?
What is a slide master?
Creating or customizing a slide master
Saving your Master to your Theme
6. Working with Shapes
Adding shapes
Inserting Icons
Inserting 3d Models
Change how your 3D models look in Office
Adding a shape fill or effect
Moving a objects forward or backward
Grouping objects
Ungrouping objects
Changing the size of a picture, shape, WordArt, or other object
Rotating a text box, shape, WordArt, or picture
Using the Selection pane to manage objects in documents
7. Working with Graphics
Inserting Pictures
Working with pictures
Changing the brightness, contrast, or sharpness of a picture
Recolouring a picture or clip art
Applying an artistic effect
Removing a picture background
Cropping a picture or place it in a shape
Combining shapes to create a custom shape
Using eyedropper to match colours on your slide
Aligning or arranging an objects
Using Edit Points to change a shape
Resetting Picture
Compressing a picture
8. Using SmartArt
Overview of SmartArt graphics
Creating a SmartArt graphic
About the Text pane
Converting slide text to a SmartArt graphic
Changing the colours of an entire SmartArt graphic
Applying a style to your SmartArt graphic
Creating an Organization Chart
Adding boxes / Deleting boxes in your organisation chart
Changing the layout of your organization chart
9. Slide Transitions and Animation Effect
About transitions
Adding a transition to a slide
Removing a transition
How to set up a Morph transition
Applying an animation effect to text or objects
Animating text or objects
Removing an Animation Effect
10. Using zoom for PowerPoint
Create a summary zoom
Slide zoom
11. Multi-media
Insert video
Inserting Online Video
Previewing a video
Editing and formatting videos
12. Organizing your PowerPoint slides into sections
Adding a section
Renaming / Moving a section
Removing a section
13. Presenting a Slide Show
Rehearse your slide show with Speaker Coach
Using keyboard shortcuts to deliver your presentation
Starting a slide show presentation
14. Printing Presentation Slides
Printing your handouts, notes, or slides
Showing footer information on your slides
Changing the starting slide number

 

 
 
如有任何有關課程之查詢,歡迎致電 3106 8211 與我們的客戶關係主任聯絡。
MASTEROFFICE19WAIT
日期 待定
時間 待定
合共 18小時
上課地點 待定