Microsoft Office

Affiliation: Microsoft
Duration: 1 days

Course Objective :

The objective of a Microsoft Office course is to equip individuals with the knowledge, skills, and practical abilities to effectively use the various applications within the Microsoft Office suite. These applications are widely used for both personal and professional tasks, and a comprehensive course aims to empower learners to navigate, create, and manage documents, spreadsheets, presentations and more.

Target Audience :

Anyone who want to learn professionally with basic fundamentals computer knowledge.

Pre – Requisites :

No Pre-requisites required

Course Outline :

Introduction to Computer

  • Computer Basic, Creating Folder, Paint
  • Directories, input units, Output unit
  • Central Processing Units
  • What is Hardware
  • what is Software
  • Windows short cut keys

MS Word

Document Settings

  • Page Size
  • Page Margins
  • Page Colors
  • Page Borders
  • Watermark

Text Basics

  • Typing the text, Alignment of text
  • Editing Text: Cut, Copy, Paste, Select All, Clear
  • Find & Replace

Text Formatting and saving file

  • New, Open, Close, Save, Save As
  • Formatting Text: Font Size, Font Style
  • Font Color, Use the Bold, Italic, and Underline
  • Change the Text Case
  • Line spacing, Paragraph spacing
  • Shading text and paragraph
  • Working with Tabs and Indents

Working with Objects

  • Shapes, Clipart and Picture, Word Art, Smart Art
  • Columns and Orderings – To Add Columns to a Document
  • Change the Order of Objects
  • Page Number, Date & Time
  • Inserting Text boxes
  • Inserting Word art
  • Inserting symbols
  • Inserting Chart

Header & Footers

  • Inserting custom Header and Footer
  • Inserting objects in the header and footer

Working with bullets and numbered lists

  • Multilevel numbering and Bulleting
  • Creating List
  • Customizing List style

Tables

  • Working with Tables, Table Formatting
  • Table Styles
  • Alignment option
  • Merge and split option

Printing

  • Print Preview
  • Print
  • Mail Merge

MS Excel

Introduction to Excel

  • Introduction to Excel interface
  • Understanding rows and columns
  • Understanding Cell Naming
  • Working with excel workbook and sheets

Formatting excel work book

  • New, Open, Close, Save, Save As
  • Formatting Text: Font Size, Font Style
  • Font Color, Use the Bold, Italic, and Underline
  • Wrap text, Merge and Centre
  • Currency, Accounting and other formats
  • Modifying Columns, Rows & Cells

Perform Calculations with Functions

  • Functions Mathematical Functions
  • Real Time Example Formulas & Problems

Sort and Filter Data

  • Using number filter, Text filter
  • Custom filtering
  • Removing filters from columns
  • Conditional formatting

Create Effective Charts to Present Data Visually

  • Inserting Column, Pie chart etc.
  • Create an effective chart with Chart Tool
  • Design, Format, and Layout options
  • Adding chart title
  • Changing layouts
  • Chart styles
  • Editing chart data range
  • Editing data series
  • Changing chart

MS PowerPoint

Setting Up PowerPoint Environment

  • New, Open, Close, Save, Save As
  • Typing the text, Alignment of text
  • Formatting Text: Font Size, Font Style
  • Font Color, Use the Bold, Italic, and Underline
  • Cut, Copy, Paste, Select All, Clear text
  • Find & Replace
  • Working with Tabs and Indents

Creating slides and applying themes

  • Inserting new slide
  • Changing layout of slides
  • Duplicating slides
  • Copying and pasting slide
  • Applying themes to the slide layout
  • Changing theme color
  • Slide background
  • Formatting slide background
  • Using slide views

Working with bullets and numbering

  • Multilevel numbering and Bulleting
  • Creating List

Working with Objects

  • Shapes, Clipart and Picture, Word Art, SmartArt
  • Change the Order of Objects
  • Inserting slide header and footer
  • Inserting Text boxes
  • Inserting shapes, using quick styles
  • Inserting Word art
  • Inserting symbols
  • Inserting Chart

Hyperlinks and Action Buttons

  • Inserting Hyperlinks and Action Buttons
  • Edit Hyperlinks and Action Button
  • Word Art and Shapes

Working With Video and Sounds

  • Inserting Video From a Computer File
  • Inserting Audio file
  • Audio Video playback and format options
  • Video options, Adjust options
  • Reshaping and bordering Video

Using SmartArt and Tables

 

DOWNLOAD COURSE OUTLINE