Certificate in Microsoft 365 (前稱 Microsoft Office)

Module 1 - Getting Started with Microsoft Office (2 Hrs)
1.
Getting Started

Microsoft 365 online basic
2. Word 365 new features
3. Excel 365 new features
4. PowerPoint 365 new features
5. 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. 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