MICROSOFT OFFICE TOOLS

MS WORD

This Introduction to Microsoft Word 2013 training class is designed for students new to working with Microsoft Word in Windows. Students will learn to create, edit, format, and print Microsoft Word documents. This series includes a complete classroom instructional program.  This Word 2013 text is mapped to the Word 2013 certification exam objectives and is designed to re-enforce workforce skills. With this book students learn to create and edit professional-looking documents for a variety of purposes and situations.   It also covers such skills as browsing, sorting and finding information, accessing and sharing documents from anywhere, enhancing visual impact with picture editing tools, text effects, SmartArt® Graphics, and much more.

Module 1: Creating a Microsoft Word Document

Module 2: The Ribbon

Module 3: The Backstage View (The File Menu)

Module 4: The Quick Access Toolbar

Module 5: Formatting Microsoft Word Documents

Module 6: Editing Documents
Module 7: Finalizing Microsoft Word Documents

Module 8: Microsoft Word New Features Since 2013

Module 9: New Features in Word 2016

 

MS WORD INTERMEDIATE

MODULE 1:  Managing Your Documents

MODULE 2:  Using Formatting Tools in Word

MODULE 3:  Creating Headers and Footers

MODULE 4:  Working with Pictures

MODULE 5:  Working with Shapes

MODULE 6:  Performing a Mail Merge in Word

 

MS WORD ADVANCED 

MODULE 1:  Managing and Reviewing Documents

MODULE 2:  Working with Reference Tools

MODULE 3:  Using Time Saving Tools

MODULE 4:  Working with Advanced Graphics and Objects

MODULE 5:  Creating Tables in Word

MODULE 6:  Creating Equations and Charts

MS EXCEL

MODULE 1:  Getting Started with Microsoft Excel

MODULE 2:  The Excel Interface

MODULE 3:  Microsoft Excel Basics

MODULE 4:  Editing your Workbook

MODULE 5:  Printing and Viewing your Workbook

MODULE 6:  Working with Charts in Excel

 

MS EXCEL INTERMEDIATE

MODULE 1:  Advanced File Tasks

MODULE 2:  Working with Functions and Formulas

MODULE 3:  Managing Tables in Microsoft Excel

MODULE 4:  Data Tools in Excel

MODULE 5:  Doing More with Charts in Excel

MODULE 6:  Spark lines

 

MS EXCEL ADVANCED

MODULE 1:  Grouping & Outlining and Subtotals

MODULE 2:  What-If Analysis

MODULE 3:  PivotTables

MODULE 4:  Charting Pivoted Data

MODULE 5:  Advanced Excel Tasks

MODULE 6:  Creating HLOOKUP and VLOOKUP Functions

MODULE 7:  Introduction to Macros in Excel

MS POWER POINT

Microsoft PowerPoint 2013 is a presentation application that enables an individual from any technical level to create a dynamic and professional-looking presentation. This is a hands-on training that will help educators, young professionals, students with the fundamental features of PowerPoint and will teach them how to develop a slide presentation that will engage and inform an audience.

I. Introduction
a. Launch PowerPoint
b. Windows Features
c. Feature Terms and Descriptions
d. Presentation Slides

II. Create Slide Presentation
a. Design Theme
b. Add Text
c. Add New Slide

III. Editing Techniques
a. View Modes
b. Edit Bulleted List
c. Add Clip Art

IV. Slide Master
a. Edit Slide Master

V. Format Slide
a. Replace Font
b. Format Text
c. Format Placeholder
d. Change Bullets
e. Change Theme
f. Modify Theme
g. Add Footer

VI. Transition and Animation
a. Slide Transition
b. Text Animation
c. Custom Filter

VII. Slide Illustrations and Shapes
a. Illustration Features
b. Create Shapes

VIII. Slide Show
a. Launch Slide Show
b. Navigation Slide Show

IX. Print Presentation
a. Print
b. Sample Output

MS OUTLOOK

Email has become one of the most widely used methods of communication, whether for personal or business communications. In most organizations, large or small, email is the preferred form of communicating information amongst employees.

As email grows in popularity and use, most organizations have found the need to implement a corporate mail management system such as Microsoft Office Outlook to handle the messages and meeting invitations sent among employees.
In this course, you will use Outlook to send, receive, and manage email messages, manage your contact information, schedule appointments and meetings, create tasks and notes for yourself, and customize the Outlook interface to suit your working style.

MICROSOFT OUTLOOK LEVEL 1

  1. Getting Started with Outlook 2016
  2. Formatting Messages
  3. Working with Attachments and Illustrations
  4. Customizing Message Options
  5. Organizing Messages
  6. Managing Your Contacts
  7. Working with the Calendar
  8. Working with Tasks and Notes

 

MICROSOFT OUTLOOK LEVEL 2

  1. Modifying Messages and Setting Global Options
  2. Organizing, Searching, and Managing Messages
  3. Managing Your Mailbox
  4. Automating Message Management
  5. Working with Calendar Settings
  6. Managing Contacts and Groups
  7. Managing Activities Using Tasks
  8. Sharing Workspaces with Others
  9. Managing Outlook Data Files

MS PROJECT

This course is designed to familiarize you with the basic features and functions of Microsoft Project Professional 2016 so you can use it effectively and efficiently in a real-world environment.
This course covers the critical knowledge and skills a project manager needs to create a project plan with Project 2016 during the planning phase of a project. In other words, if your supervisor assigns you to lead a project, this course will enable you to draft a project plan with Project 2016 and share it with your supervisor (and others) for review and approval.

MICROSOFT PROJECT LEVEL 1

  1. Getting Started with Microsoft Project
  2. Defining a Project
  3. Creating and Organizing Tasks
  4. Managing Project Plan Resources
  5. Finalizing a Project Plan

  

MICROSOFT PROJECT LEVEL 2

  1. Executing a Project
  2. Monitoring Project Progress
  3. Controlling a Project Plan
  4. Reporting on Progress
  5. Customizing the Application