Workshop on Microsoft Office:  (Word, Excel, Access & 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 is 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.

Requirements: Microsoft Office 2016 Windows installed and ready to use on your computer.

For whom:

This 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; and
• create macros.

Course outline:

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

Day 2 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

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

Day 3 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

Day 4 13: Overview of Workbooks

• Creating Workbooks
• Saving Workbooks
• Closing Workbooks
• Opening Workbooks
• Selecting Cells, Rows, and Columns
• Using Templates

Module 14: Modifying a Worksheet

• Entering Data
• Editing Data
• Moving and Copying Cells
• Using Paste Special
• Clearing Cells
• Undoing and Redoing Changes

Module 15: 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 16: 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

Day 5 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

Training Methodology

Training is highly practical with hands-on exercises using easy-to-follow step-by-step instructions.