Skip to main content

Microsoft Productivity Tools


Department of Information and Communications Technology
Enrollment in this course is by invitation only

Course Overview

This course aims to equip learners with satisfactory knowledge and skills in using additional features of selected Microsoft Productivity Tools that are often overlooked.

What You Will Learn

At the end of this course, you will be able to:

  • demonstrate knowledge in utilizing selected additional features of Microsoft Word, Excel, and PowerPoint in making work easier
  • create documents with the use of additional features of Microsoft Word, Excel, and PowerPoint

Course Content

Week 1: Microsoft Word

10 Videos | 1 Activity

10 Videos

  • Welcome to the course!
  • Tables
  • Pictures, Icons, and Screenshot
  • Shapes and SmartArt
  • Comment and Tracking
  • Accepting and Rejecting
  • Page Number
  • Page Breaks
  • Table of Contents
  • Summary

1 Activity

  • Exit Assessment

Week 2: Microsoft Excel

10 Videos | 1 Activity

10 Videos

  • Sort and Filter
  • Find and Replace
  • Conditional Formatting
  • Table and Pivot Table
  • Basic Charts
  • Sum and Average
  • Count Numbers
  • If-Then
  • Encoded Formulas
  • Summary

1 Activity

  • Exit Assessment

Week 3: Microsoft PowerPoint

8 Videos | 1 Activity

8 Videos

  • Transitions
  • Animations
  • Presenter View
  • Functions Available in Presentation View
  • Rehearse Timings
  • Exporting PowerPoint to Slideshow
  • Record Slideshowmail
  • Key Takeaways

1 Activity

  • Exit Assessment
  1. Course Number

    DICT-DLS003
  2. Classes Start

    TBA
  3. Estimated Effort

    2 hrs./week (6 hours)
  4. Price

    Free