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