Microsoft Office Essential Skills

overview

We use MS Word, MS Excel and MS PowerPoint on day to day basis. This course 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.

course details

COURSE DURATION	LANGUAGE	CERTIFICATE
30 Hours (2 Hours per Day)	English	DISS Certificate
	*Please notify us if an interpretation is required

course benefits/progression opportunities

Course objectives

At the end of the training program, participants will able to:

Work with documents using Word
Work with data manipulations using Excel
Work with presentations using Power Point

course outline

Module 1: Creating a Microsoft Word Document	Module 2: The Ribbon	Module 3: The Backstage View (The File Menu)
This module explains how to get started creating Microsoft Word documents. Topics Starting a Microsoft Document Creating a Document Saving a Document Importing a File The Status Bar Closing a Document Exercise: Create a Microsoft Word Document	This module explains how to work with the Ribbon in Microsoft Word. Topics The Ribbon Tabs Groups Commands Exercise: Exploring the Ribbon	This module explains how to work with the many features located in the Backstage view. Topics Introduction to the Backstage View Opening a Document Exercise: Open a Document New Documents and Word Templates Exercise: Write a Thank You Letter Using a Template Letter Configuring Documents to Print Exercise: Print a Document Adding Your Name to Microsoft Word Adding Values to Document Properties Working with Autosaved Versions of Documents

Module 4: The Quick Access Toolbar	Module 5: Formatting Microsoft Word Documents	Module 6: Editing Documents
This module explains how to work with the Quick Access Toolbar in Microsoft Word. Topics Adding Common Commands Adding Additional Commands with the Customize Dialog Box Adding Ribbon Commands and Groups Placement Exercise: Customize the Quick Access Toolbar	This module explains how work with formatting in Microsoft Word. Topics Selecting Text Selecting Fonts Exercise: Working with Fonts Working with Lists Exercise: Working with Lists Inserting a Hyperlink in a Document Exercise: Inserting a Hyperlink Using Styles Exercise: Applying and Creating Custom Styles Using Themes Using the Ruler Exercise: Using Tabs Setting Margins Exercise: Setting Margins	This module explains how to edit documents in Microsoft Word. Topics Find Find and Replace Find and Replace Tips Appending Text to a Document Exercise: Using Find and Replace Using the Clipboard

Module 7: Finalizing Microsoft Word Documents	Module 8: Advanced Formatting	Module 9: Working with Tables
This module explains how to use various features to finalize Microsoft Word documents. Topics Adding Page Numbers Exercise: Adding Page Numbers Headers and Footers Exercise: Using Headers and Footers Checking Spelling and Grammar Exercise: Checking Spelling and Grammar	This module explains how to work with formatting features in Microsoft Word. Topics Shading and Borders Exercise: Using Shading and Borders Setting Line and Paragraph Spacing Changing Styles Exercise: Changing Styles Paragraph Marks and Other Formatting Symbols Exercise: Using Formatting Symbols	This module explains how to work with tables. Topics Inserting a Table. Exercise: Insert a Table. Table Styles Exercise: Adding Styles to a Table Formatting a Table Exercise: Formatting a Table

MS Excel Modules:

Module 1: Creating a Microsoft Excel Workbook

Module 2: The Ribbon

Module 3: The Backstage View (The File Menu)

This module explains how to get started creating Microsoft Excel workbooks.
Topics
- Starting Microsoft Excel
- Creating a Workbook
- Saving a Workbook
- The Status Bar
- Adding and Deleting Worksheets

Copying and Moving Worksheets
Changing the Order of Worksheets
Splitting the Worksheet Window
Closing a Workbook

The Ribbon is the display you see at the top of the Microsoft Excel window. It is your primary interface with Excel. It allows you to access most of the commands available to you in Excel. The Ribbon is composed of three parts: Tabs, Groups and Commands. In this lesson, you will learn about all three.
Topics
- Tabs
- Groups
- Commands

This module explains how to work with the Backstage View (The File Menu).
Topics
- Introduction to the Backstage View
- Opening a Workbook
- New Workbooks and Excel Templates
- Printing Worksheets
- Adding Your Name to Microsoft Excel
- Managing Workbook Versions

Module 4: The Quick Access Toolbar	Module 5: Entering Data in Microsoft Excel Worksheets	Module 6: Formatting Microsoft Excel Worksheets
This module explains how to work with the Quick Access Toolbar. Topics Adding Common Commands Adding Additional Commands with the Customize Dialog Box Adding Ribbon Commands or Groups Placement	This module explains how to enter data. Topics Entering Text Expand Data across Columns Adding and Deleting Cells Adding an Outline Adding a Hyperlink Add WordArt to a Worksheet Using AutoComplete Entering Numbers and Dates Using the Fill Handle	This module explains how to format Microsoft Excel Worksheets. Topics Selecting Ranges of Cells Hiding Worksheets Adding Colour to Worksheet Tabs Adding Themes to Workbooks Adding a Watermark The Font Group The Alignment Group The Number Group

Module 7: Using Formulas in Microsoft Excel

Module 8: Working with Rows and Columns

Module 9: Editing Worksheets

This is the math lesson, and whether you love or hate math, by the end of this lesson you will agree that Excel makes math easy. We will start by explaining some of the basic concepts you need to understand regarding how Excel does math and then will get into entering formulas.
Topics
- Math Operators and the Order of Operations
- Entering Formulas
- AutoSum (and Other Common Auto-Formulas)
- Copying Formulas and Functions
- Relative, Absolute, and Mixed Cell References

This module explains how to work with rows and columns.
Topics
- Inserting Rows and Columns
- Deleting Rows and Columns
- Transposing Rows and Columns
- Setting Row Height and Column Width
- Hiding and Unhiding Rows and Columns
- Freezing Panes

This module explains how to edit worksheets.
Topics
- Find

Find and Replace
Using the Clipboard
Managing Comments

Module 10: Finalizing Microsoft Excel Worksheets	Module 11: Working with Lists
This module explains how to finalize Microsoft Excel Worksheets. Topics Setting Margins Setting Page Orientation Setting the Print Area Print Scaling (Fit Sheet on One Page) Printing Headings on Each Page/Repeating Headers and Footers Headers and Footers	This module explains how to work with lists. Topics Converting a List to a Table Removing Duplicates from a List Sorting Data in a List Filtering Data in a List Adding Subtotals to a List Grouping and Ungrouping Data in a List

MS Power Point Modules:

Module 1: Creating a PowerPoint Presentation	Module 2: The Ribbon	Module 3: The Quick Access Toolbar	Module 4: The Backstage View (The File Menu)
This module explains how get started using Microsoft PowerPoint. Topics Starting Microsoft PowerPoint Normal View Creating a Presentation Saving a Document Importing a File The Status Bar Closing a Presentation Exercise: Creating a Microsoft PowerPoint Presentation	This module explains how to work with the Ribbon in Microsoft PowerPoint. Topics The Ribbon Tabs Groups Commands Exercise: Exploring the Ribbon	This module explains how to work with the Quick Access toolbar in Microsoft PowerPoint. Topics Adding Common Commands Adding More Commands with the Customize Dialog Box Adding Ribbon Commands or Groups Placement Exercise: Customize the Quick Access Toolbar	This module explains how to work with the Backstage View in Microsoft PowerPoint. Topics Introduction to the Backstage View Opening a Presentation Exercise: Opening a Presentation New Presentation and Presentation Templates Exercise: Creating an Agenda Using a Template Presentation Properties Adding Your Name to a Microsoft PowerPoint

Module 5: Formatting Microsoft PowerPoint Presentations	Module 6: Working with Images	Module 7: Working with Tables and Charts
This module explains how work with formatting features in Microsoft PowerPoint presentations. Topics Selecting a Slide Layout Adding text Adding Text from a Text File or Word Outline Editing Text Formatting Text Formatting Text as WordArt Creating Bulleted and Numbered Lists Formatting Text Placeholder Adding Slides to a Presentation Arranging Slides Exercise: Formatting Text	This module explains how to work with images in Microsoft PowerPoint. Topics Adding Images to a Slide Inserting a Picture Inserting Clip Art Capturing and Inserting a Snapshot Editing an Image Formatting Images Applying a Style and Cropping an Image Grouping and Ungrouping Images Arranging Images Adding Shapes Exercise: Working with Images and Shapes	This module explains how to work with tables and charts in Microsoft PowerPoint. Topics Inserting a Table Formatting Tables Importing Tables from External Sources Exercise: Working with a Table Inserting a Chart Formatting a Chart Importing Charts from External Sources Exercise: Working with Charts

COURSE TYPE: CLASSROOM

DATE	DAY	QATAR TIME
10-12 Jan 21	Mon-Tue	09:00-15:00
14-16 Feb 21	Mon-Tue	09:00-15:00
14-16 Mar 21	Mon-Tue	09:00-15:00
5-7 Apr 21	Mon-Wed	09:00-15:00
3-5 May 21	Mon-Wed	09:00-15:00
7-9 Jun 21	Mon-Wed	09:00-15:00
5-7 Jul 21	Mon-Wed	09:00-15:00
2-4 Aug 21	Mon-Wed	09:00-15:00
6-8 Sep 21	Mon-Wed	09:00-15:00
4-6 Oct 21	Mon-Wed	09:00-15:00
1-3 Nov 21	Mon-Wed	09:00-15:00
6-8 Dec 21	Mon-Wed	09:00-15:00

TESTIMONIAL

Click edit button to change this text. Lorem ipsum dolor sit amet consectetur adipiscing elit dolor. Click edit button to change this text. Lorem ipsum dolor sit amet consectetur adipiscing elit dolor

Person name

Meet THE INSTRUCTORS

Instructor Name
Profession

Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Instructor Name
Profession

Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Related Courses

Classroom

Microsoft Visio 2019 Basic (Level 1)

6-7 Jan 21

09:00-15:00 (Qatar)

Classroom

ITIL Foundation V4

6-7 Jan 21

09:00-15:00 (Qatar)

Classroom

Graphics Design and Video Editing using Adobe Illustrator & Premiere

7-11 Feb 21

09:00-15:00 (Qatar)

Online Self-study Certifications

COBIT Foundation v5

Self-based Learning
662 USD

Online Self-study Certifications

ITIL Intermediate SO

Self-based Learning
970 USD

Microsoft Office Essential Skills

overview

course details

course benefits/progression opportunities

Course objectives

course outline

TESTIMONIAL

Meet THE INSTRUCTORS

Instructor Name
Profession

Instructor Name
Profession

Related Courses

Microsoft Visio 2019 Basic (Level 1)

ITIL Foundation V4

Graphics Design and Video Editing using Adobe Illustrator & Premiere

COBIT Foundation v5

ITIL Intermediate SO

HSE COURSES

BUSINESS COURSES

QUICK LINKS

CONTACT INFORMATION

Microsoft Office Essential Skills

overview

course details

course benefits/progression opportunities

Course objectives

course outline

TESTIMONIAL

Meet THE INSTRUCTORS

Instructor NameProfession

Instructor NameProfession

Related Courses

Microsoft Visio 2019 Basic (Level 1)

ITIL Foundation V4

Graphics Design and Video Editing using Adobe Illustrator & Premiere

COBIT Foundation v5

ITIL Intermediate SO

HSE COURSES

BUSINESS COURSES

QUICK LINKS

CONTACT INFORMATION

Instructor Name
Profession

Instructor Name
Profession