WORKSHOP ON MICROSOFT OFFICE (WORD, EXCEL & POWERPOINT)

PROGRAM OVERVIEW:

Microsoft Office is a set of desktop applications that offer flexible and powerful ways to organize, manage, and present information. Universally used in office settings, knowledge of Microsoft Office tools are a must for anyone in today's job market.
This is a fundamental course which covers fonts and formats, creating a table and few other basic functions. Besides that, formulas can be used for sorting a table or formatting. It also helps the people to use the various layouts, do slide formatting, provide special effects or select customized designs of templates for their presentation.
This program is designed to help participants improve their work efficiency and effectively utilizes all the features of Microsoft Office products that enable easy and secure information sharing.

FOR WHOM:

his program on Microsoft Office training is designed for anyone who wants to improve their skills and master Microsoft Office applications.

LEARNING OBJECTIVES:

At the end of the program, participant will be able to:
■ Gain the ability to create and edit of all types of documents, both formal and informal
■ Use Microsoft applications for simple or complex calculations (through the use of formulas) and the generation of graphics associated with these calculations.
■ Learn how to create visual presentations (slides) with the inclusion of text, images, sound or video
■ Understand how to use email, manage online calendars, and contacts
■ Create a template
■ Use complex spreadsheet functions including Goal Seek and PMT
■ Use Lookup Using Match and Index
■ Create macros

COURSE CONTENT:

DAY 1: MICROSOFT WORD
Module 1: Getting Started with Microsoft Word
- Explore the User Interface and the Ribbon
- Quick Access Toolbar
- Creating Documents

Module 2: Editing Documents
- Selecting Text
- Deleting Text
- Moving and Copying Text
- Undoing and Redoing Changes
- Finding and Replacing Text

Module 3: Formatting Documents
- Formatting Text
- Changing the Font and Font Size
- Changing the Font Color and Highlighting Text
- Applying Font Styles and Effects
- Clearing Formatting
- Copying Formatting
- Formatting Paragraphs
- Changing Paragraph Alignment
- Changing Line and Paragraph Spacing
- Changing Paragraph Indentation
- Setting Tab Stops
- Adding Borders and Shading
- Creating Bulleted and Numbered Lists
- Applying Styles
- Formatting Headings

Module 4: Working with Tables
- Inserting Tables
- Navigating Tables
- Selecting Table Parts
- Adding Borders and Shading
- Inserting Rows and Columns
- Resizing Rows and Columns

Module 5: Working with Headers and Footers
- Insert Headers and Footers
- Insert the date or time into a header or footer
- Inserting Page Numbers
- Changing the Page Layout
- Changing the Page Margins
- Changing the Page Orientation
- Changing the Page Size

Module 6: Using the Mail Merge Wizard
- Use the Mail Merge Feature

Module 7: Printing Word Documents, Getting Help and Exiting Word Document
- Printing and Previewing a Work Document
- Getting Help
- Exiting Word
- Microsoft PowerPoint

Day 2: MICROSOFT POWERPOINT

Module 8: Getting Started with Microsoft PowerPoint
- Explore the User Interface and the Ribbon
- Quick Access Toolbar
- Create a New Presentation
- Using Templates
- Saving Presentations
- Slide Basics
- Working with Text
- Add a Text Box

Module 9: Adding Multimedia Elements
- Using Multimedia Elements
- Working with Pictures
- Applying Styles & Effects
- Modifying Hyperlinks
- Working with SmartArt

Module 10: Enhancing Presentations
- Insert Audio from a File
- Insert a Video from a File
- Using Animation
- Applying Transitions

Module 11: Managing and Preparing the Slide Show
- Create Slide Sections
- Presenting a Slide Show
- Presentation Tools and Features
- Presenter View
- Microsoft Excel

Module 12: Getting Started with Microsoft Excel
- Explore the User Interface and the Ribbon
- Overview of Workbooks
- Creating Workbooks
- Saving Workbooks
- Closing Workbooks
- Opening Workbooks
- Selecting Cells, Rows, and Columns
- Using Templates

Module 13: Modifying a Worksheet
- Entering Data
- Editing Data
- Moving and Copying Cells
- Using Paste Special
- Clearing Cells
- Undoing and Redoing Changes

Module 14: Working with Rows and Columns
- Inserting Rows and Columns
- Deleting Rows and Columns
- Changing Row Heights
- Changing Column Widths
- Hiding and Unhiding Rows and Columns

Module 15: Formatting Worksheet
- Changing the Font and Font Size
- Changing the Font Color and Fill Color
- Applying Font Styles
- Adding Cell Borders
- Formatting Numbers
- Positioning Cell Contents
- Copying Cell Formatting
- Applying Cell Styles

Module 17: Performing Calculation
- Using Formulas and Functions
- Using Cell References in Formulas
- Entering Formulas
- Displaying Formulas
- Using Functions in Formulas
- Using the AutoSum Button
- Inserting Functions
- Using Formula AutoComplete

Module 18: Visualizing Data with Charts
- Creating Charts
- Selecting Chart Elements
- Changing the Chart Type

Module 19: Getting Help and Exiting Excel Document
- Getting Help
- Exiting Excel

METHODOLOGY

This course relies on the use of individual and group debriefs. The course also features the use of several case studies and presentations by participants followed by plenary discussions. In addition, videos and exercises are used to demonstrate the skills required for effective supervision.

Available on request

WHAT YOU WILL GET?

■ PowerPoint Slides– All slides necessary to run the course. Please note: Our materials are not ‘Death by PowerPoint’. The major content is in the Trainers Notes and all courses have been designed to be interactive rather than presentational.
■ Case Studies – This is a method which provides descriptive situations which stimulate trainees to make decisions. The purpose of the case method is to make trainees apply what they know, develop new ideas to manage a situation or solve a problem.
■ Activities/Exercises– A detailed explanation of the activities/exercises used to consolidate learning (these are included in the trainer’s notes)
■ Pre-course Preparation – Basic advice on running the training course and also any necessary preparation that is specific to the course.
■ Certificate – A recognition to be awarded as proof of proficiency, having fulfilled all requirements.
■ Support for back to work implementation.

No. of Days:	2
Total Hours:	10