BA_COMC120: MS Office Skills I - Taylor Pro College

BA_COMC120: MS Office Skills I

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

 

This course introduces students to the key techniques for using:

  • Microsoft Office Software applications for Word
  • Microsoft Office Excel
  • Microsoft Office Outlook assists managers in effectively addressing their day-to-day business operations.

What Will You Learn?

  • Recognize when to use each of the Microsoft Office programs.
  • Effectively use Microsoft Office interface and Windows file management tools to manage workflow.
  • Use Microsoft Office programs to create business documents following accepted professional and industry standards.
  • Credit and edit Word, Excel and Outlook documents.
  • Create and perform data calculations using Excel spreadsheets.
  • Manage email and calendaring in Outlook.

Course Content

Module – I

  • 00:00
  • 00:00
  • LO2: Demonstrate proficiency in Navigating and Managing files within Microsoft Office applications
    05:17
  • LO3: Knowledge Check
  • Case Study: Introduction to Microsoft Word
  • 03:23
  • 02:29
  • LO2: Demonstrate how to Save, Close, Open, and switch between Presentation files
    03:28
  • LO3: Identify the Names and functions of the PowerPoint Interface
    07:12
  • LO4: Analyze the Formatting techniques and Presentation styles of PowerPoint
    11:55
  • LO5: Knowledge Check
  • Case Study: Microsoft PowerPoint
  • 04:28
  • 05:12
  • LO2: Understand basic Editing functions, Formatting text, Copying, Moving objects, and Text
    07:45
  • LO3: Explain how to use Paragraph Formatting Features in MS Word effectively
    05:46
  • LO4: Describe the process of inserting Graphics, Pictures, Pages, and Tables
    08:31
  • LO5: Comprehend MS Word’s advanced Formatting techniques and Presentation styles
    07:12
  • LO6: Knowledge Check
  • Case Study: Microsoft Word
  • Topic 4: Microsoft Excel
    04:41
  • LO1: Identify the basic Components and Navigation features of an Excel Spreadsheet
    08:09
  • LO2: Explain the purpose of Functions and Formulas used in Excel
    17:55
  • LO3: Describe how to create a new Workbook Using a Template
    04:57
  • LO4: Distinguish between various Cell Formatting options and their applications
    15:43
  • LO5: Explain the process of Formatting a Worksheet in a Spreadsheet application
    12:21
  • LO6: Discuss the ability to add Charts to a Spreadsheet and analyze data effectively
    12:08
  • LO7: Knowledge Check
  • Case Study: Microsoft Excel
  • Topic 5: Microsoft Access
    03:43
  • LO1: Examine Database concepts and understand the MS Office Access Environment
    05:23
  • LO2: Explain how to Open and Close Databases, as well as how to Open, Close, and Save objects
    03:25
  • LO3: Knowledge Check
  • Case Study: Microsoft Access
  • Topic 6: Microsoft Outlook
    03:27
  • LO1: Describe the Functions and applications of Microsoft Outlook for Effective Email Management
    06:51
  • LO2: Demonstrate how to organize Contacts in Microsoft Outlook
    03:27
  • LO3: Comprehend Tracking and Task management features in Microsoft Outlook
    04:02
  • LO4: Knowledge Check
  • Case Study: Microsoft Outlook
  • Topic 7: Office 365
    03:18
  • LO1: Understand the basic Functions and Services offered by Office 365
    05:15
  • LO2: Describe the Office 365 Interface to access various applications and tools
    03:41
  • LO3: Explain how to Collaborate and Share documents effectively using Office 365 applications
    03:37
  • LO4: Knowledge Check
  • Case Study: Office 365
  • Module Based Quiz

Final Exam

Want to receive push notifications for all major on-site activities?