Workshop on Microsoft Office (Word, Excel & PowerPoint)
ENDED
Workshop by
REKRUT CONSULTING
Inquire Now
On-Site
/ Workshop
Details
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:
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
■ Create macros
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:
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
■ Create macros
Outline
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
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...
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
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...
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
Speaker/s
Available on Request
Special Offer
Early Bird: 5% Discount. 5-10 Participants (5% discount). 11 or more participants. (10% discount). This covers Course materials and Certificate of attendance.
Schedules
Nov 17, 2022 - Nov 18, 2022
ENDED
Thu, Fri | 10:00 AM — 03:00 PM |
No. of Days: | 2 |
Total Hours: | 10 |
Reviews
Be the first to write a review about this course.
Write a Review
We are a Top Class Human Capital Development Service provider in Nigeria. Our prime objective is to enable organisations to access tomorrow’s thinking and today’s best practices in people management.
People are the greatest assets of any organisation. Rekrut Consulting is dedicated to designing and delivering Recruitment, Training interventions, Team building, and HR consultancy services to the specific needs of client organisations in order for them to be competitive and contemporary.