課程資料
Master in Microsoft Office 2019 高級證書課程
MASTEROFFICE19
 
若想更了解以上資訊,歡迎致電 3106 8211 查詢。
 
課程費用: $2980

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

繳費方法:

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

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

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

合共: 18小時

 


課程內容:
Module 1 - Getting Started with Microsoft Office 2019 (2 Hrs)
1. Getting Started
Sign In to Microsoft Office
Office 2019 vs Office 365
2. New User Interface & Features
The Backstage View (The File Menu)
Introduction to the Backstage View
Live Preview
Save Files in Different Formats
File Recovery
Office Web App, Co-Authoring
Simplified Sharing
Touch Features
Insert icons
Translate text
Draw and write with ink
Tell me
Smart Lookup
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. Advanced Formatting
Shading and Borders
Changing Styles
Expand and Collapse
Paragraph Marks and Other Formatting Symbols
Ink Equations
2. Working with Long Documents
Adding a Table of Contents
Updating the Table of Contents
Deleting the Table of Contents
Footnotes and Endnotes
Adding an Index
3. Create a Form
Create Form Template
Add Text Section
Add a Date Selection
Insert Drop-Down List
Add Checkboxes
4. Working with Tables
Inserting a Table
Table Styles
Formatting a Table
5. Working with Images
Inserting Images
Placing and Sizing Images
Wrapping Text Around an Image
Adjusting Images
Live Layout and Alignment Guides
Insert a Screenshot or Screen Clipping
Borders and Effects
Module 4 - Microsoft Word – Advanced (3 Hrs)
1. Page Layout
Orientation and Paper Size
Working with Columns
Page and Section Breaks
2. Finalizing Microsoft Word Documents
Adding Page Numbers
Headers and Footers
Checking Spelling and Grammar
Open and Edit PDFs
New Read Mode
3. Reviewing and Collaborating on Documents
Adding Comments
Tracking Changes
Viewing Changes, Additions, and Comments
Accepting and Rejecting Changes
4. Managing Mailings
Creating Envelopes and Labels
Using Mail Merge
5. Protecting Documents
Making Word Documents Read Only
Password Protect Word Documents
Restrict Formatting and Editing
Module 5 - Microsoft Excel – Core (3 Hrs)
1. Entering Data in Microsoft Excel Worksheets
Entering Text
Using AutoComplete
Entering Numbers and Dates
Using the Fill Handle
Quick Analysis
2. Using Formulas in Microsoft Excel
Math Operators and the Order of Operations
Entering Formulas
AutoSum (and Other Common Auto-Formulas)
Copying Formulas and Functions
Relative and Absolute Cell References
3. Working with Rows and Columns
Inserting Rows and Columns
Deleting Rows and Columns
Setting Row Height and Column Width
Hiding and Un-hiding Rows and Columns
Freezing Panes
4. Data / Time Functions
5. Text Functions
6. Finalizing Microsoft Excel Worksheets
Setting Margins
Setting Page Orientation
Setting the Print Area
Print Scaling (Fit Sheet on One Page)
Headers and Footers
Module 6 - Microsoft Excel - Advanced (3 Hrs)
1. Applying Conditional Formatting
Highlight Cell Rule
Top / Bottom Rule
Data Bar
Color Scale
Icon Sets
2. Using Pivot Tables
Creating Pivot Tables
Preparing Your Data
Inserting a Pivot Table
Inserting Pivot Charts
More Pivot Table Functionality
Automatic Time Grouping
Inserting Slicers
Multi-select Slicer
3. Data Tools
Data Validation
Flash Fill
4. Protecting Worksheets and Workbooks
Password Protecting a Workbook
Password Protecting a Worksheet
Password Protecting Ranges in a Worksheet
Tracking Changes
Accepting or Rejecting Changes
5. Summarize Functions
6. Lookup Functions
7. IF Functions
Module 7 -  Microsoft PowerPoint (3 Hrs)
1. Creating a PowerPoint Presentation
Starting Microsoft PowerPoint
Normal View
Creating a Presentation
Widescreen Presentation
Saving a presentation
The Status Bar
Closing a Presentation
2. Working with Images
Adding Images to a Slide
Inserting a Picture
Inserting Clip Art
Capturing and Inserting a Screenshot
Editing an Image
Formatting Images
Rotating and Resizing an Image
Line-up and Space Objects Equally
Grouping and Ungrouping Images
Arranging Images
Adding Shapes
New Shape Styles
New Eyedropper for Color Matching
Combine Shapes
Compressing Pictures
3. Using SmartArt
Inserting SmartArt Graphics
Modifying SmartArt Graphics
Resizing / Repositioning a SmartArt Object
Resize a SmartArt Shape
Resize a SmartArt Graphic
Reposition a SmartArt Graphic
Inserting Text into a SmartArt Object
Formatting Text in a SmartArt Object
Adding Shapes to a SmartArt Object
Ungrouping SmartArt Objects
4. Multimedia
Inserting Sounds and Video
Inserting a Sound File
Inserting a Video File
Inserting a YouTube Video
Editing Media Clips
Editing an Audio Clip
Editing a Video Clip
Inserting Animated GIFs
Screen Recording
5. Animation and Transition
Apply entrance and exit animation effects
Apply sound effects to animated text and objects
Apply a motion paths to text or an objects
Add, change, or remove transitions between slides
Use the Morph transition
6. Setting up the Slide Show
Setting up a Custom Show
Creating a Hyperlink
Adding an Action Button
Jumping to Another Presentation
Annotating a Presentation
Creating a Presenter-Independent Slide Show
Setting Up a Slide Show to Repeat Automatically
7. Presentation Masters
Working with the Slide Master
Formatting Slide Masters and Layouts
Adding a Watermark to Your Presentation
Adding Slide Numbers Using the Slide Master
Inserting a New Slide Master
Preserving a Slide Master
Modifying the Notes Master
Modifying the Handout Master
Adding a Header and Footer to Notes and Handouts
8. Finalizing Microsoft PowerPoint Presentations
Checking Spelling
Accessing Different Views of a Presentation
Organizing a Presentation in Sections
Adding Speaker Notes
Running a Slide Show
Presenter Mode
Printing a Presentation

 

 
 
如有任何有關課程之查詢,歡迎致電 3106 8211 與我們的客戶關係主任聯絡。
 
MASTEROFFICE1920110015 
日期 1/11/2020~15/11/2020 (SUN)
時間 10:30~17:30 
合共 18 小時
上課地點 長沙灣分校
課程費用 $ 2980