What are the prerequisites to learn MS Office?

A person who has the interest to learn MS Office shall join this Microsoft office training course.

Why should I learn Microsoft Office?

MS Office is one of the most commonly used suites of productivity tools in the business world. In fact, it's so important that knowing it is an essential to getting employment at some corporate companies.

MS Office Training for HR Professionals

Enroll Now

MS Office for HR Professionals

Our MS Office training is designed to assist HR Professionals with their day-to-day responsibilities. It includes basic, professional and expert problem-solving solutions. This MS Office training will help you develop your HR skills to become an HR Professional and help enhance your current position. Our course syllabus is based on current industry demands across various disciplines.

Batch Training
Starts from 7,999
Individual Training
Get Price
Online Training
Get Price
Custom Training
Get Price
Enroll Now Demo Class

Key Features

Customized Syllabus

All Payment Mode Option

Live Project Training

Free Demo Class Available

Industry Expert Faculties

Individual Approach for Every Student

Doubt Clear Session

Course duration - 48 hours

Classroom and Online Training

Completed 80+ Batches

Want Help?

We are ready to guide you.

Name

Mobile No

Message

Call us +91 9025 500 600

MS Office Course Syllabus

Microsoft Office Word

Introduction to Word

Getting started with Word
Creating, Opening & Saving documents

Working with text

Text basics & formatting text
Using Find & replace
Indents & Tabs

Layout & printing

Printing layout & printing documents
Breaks & Columns
Headers & Footers

Working with objects

Pictures & text wrapping
Fomatting pictures
Aligning, ordering & grouping
Tables & charts

Collaboration & reviewing

Checking spelling & grammer
Track changes & comments
Inspecting & protecting documents

Create and manage documents

Create a document
Navigate through a document
Format a document
Customise options and views for documents
Print and save documents

Format text, paragraphs and sections

Insert text and paragraphs
Format text and paragraphs
Order and group text and paragraphs

Create tables and lists

Create a table
Modify a table
Create and modify a list

Create and manage references

Create and manage reference markers
Create and manage simple references

Insert and format graphic elements

Insert graphic elements
Format graphic elements
Insert and format SmartArt graphics

Manage document options and settings

Manage documents and templates
Prepare documents for review
Manage document changes

Design advanced documents

Perform advanced editing and formatting
Create styles

Create advanced references

Create and manage indexes
Create and manage references
Manage forms, fields and Mail Merge operations

Create custom Word elements

Create and modify building blocks, macros and controls
Create custom style sets and templates
Prepare a document for internationalisation and accessibility

Microsoft Office Excel

Introduction to Excel

A overview of the screen, navigation and basic spreadsheet concepts
Understanding workbooks, worksheets, rows, columns, cells
Various selection techniques

Entering Data

Entering, Editing and Deleting Text, Numbers, Dates
Using Auto Lists
Moving and Copying data
Using navigation techniques

Managing & Navigating through workbooks

Using Workbook Views
Selecting and Switching Between Worksheets
Understading & working rows, columns and worksheets

Creating & Editing formulea

Concept of Formulae
Creating Formulae, Editing Formulae
Bodmas : Mathematical Order

Formatting & Proofing

Formatting Cells with Number formats, Font formats, Alignment, Borders, etc
Basic conditional formatting
Working with Styles

Create and manage worksheets and workbooks

Create worksheets and workbooks
Navigate in worksheets and workbooks
Format worksheets and workbooks
Customise options and views for worksheets and workbooks
Configure worksheets and workbooks for distribution

Manage data cells and ranges

Insert data in cells and ranges
Format cells and ranges
Summarise and organise data

Create tables

Create and manage tables
Manage table styles and options
Filter and sort a table

Perform operations with formulas and functions

Summarise data by using functions
Perform conditional operations by using functions
Format and modify text by using functions

Create charts and objects

Create charts
Format graphic elements
Insert and format objects

Manage workbook options and settings

Manage workbooks
Manage workbook review

Apply custom data formats, layouts & protection

Apply custom data formats and validation
Apply advanced conditional formatting and filtering
Create and modify custom workbook elements
Different levels of protection
Setting permission & track changes
Prepare a workbook for internationalisation

Create advanced formulas

Apply mathematical functions in formulas
Look up data by using functions
Advanced logical & text functions
Apply advanced date and time functions
Perform data analysis and business intelligence
Troubleshoot formulas using error handling functions
Define named ranges and objects

Create advanced charts and tables

Create advanced charts
Create and manage PivotTables
Create and manage PivotCharts

Excel Dashboard

Bar Charts / Pie Charts / Line Charts
Planning a Dashboard
Adding Tables to Dashboard
Adding Charts to Dashboard
Adding Dynamic Contents to Dashboard

Microsoft Office Powerpoint

Introduction to Powerpoint

Getting started with Powerpoint
Creating & Opening presentations

Working with Slides

Slide basics
Text basics
Applying themes & transitions
Managing & printing slides
Presenting your slideshow

Texts & Objects

Lists
Indents & Line spacing
Inserting & Formatting pictures & shapes
Aligning, ordering and grouping objects
Animating texts & objetcs

Collaboration & reviewing

Checking spelling & grammer
Reviewing presentations
Inspecting & protecting presentations

Create and manage presentations

Create a presentation
Insert and format slides
Modify slides, handouts and notes
Order and group slides
Change presentation options and views
Configure a presentation for print
Configure and present a slide show

Insert and format text, shapes and images

Insert and format text
Insert and format shapes and text boxes
Insert and format images
Order and group objects

Insert tables, charts, SmartArt and media

Insert and format tables
Insert and format charts
Insert and format SmartArt graphics
Insert and manage media

Apply transitions and animations

Apply slide transitions
Insert slide transitions, set transition effect options
Animate slide content
Set timing for transitions and animations

Manage multiple presentations

Merge content from multiple presentations
Finalise presentations

Microsoft Office Outlook

Manage the Outlook environment for productivity

Customise settings
Print and save information
Perform search operations in Outlook

Manage messages

Configure mail settings
Create messages
Format a message
Organise and manage messages

Manage schedules

Create and manage calendars
Create appointments, meetings and events
Organise and manage appointments, meetings and events
Create and manage notes and tasks

Manage contacts and groups

Create and manage contacts
Create and manage contact groups

About MS Office for HR Professionals

We are one of the best MS Office training institutes in Chennai. Our students have consistently indicated high on the job productivity levels. We offer a customized training programme for corporate and professionals needs. You will learn essential skills in Microsoft office programs from our training. We provide instructor-led online and classroom training to help professionals get certified and get ahead.

Microsoft Office has made a commendable contribution to the improvement of HR practices globally. Another advantage of MS Office is that it permits for information to be accessed conveniently. Rather than HR professionals having to produce through files to get information, it is available in seconds using MS Excel. Having all of the data in one place and it permits professionals to analyze data quickly and over different locations because the data is in a centralized location.

HR professionals generally process a large amount paperwork on a daily basis. This paperwork could be anything from a department transfer appeal to an employee's confidential tax form. In addition to processing this paperwork, it must be on file for an extended timeframe. The utilization of MS Office has made it possible for organizations to store and recover files in an electronic format for an individual within the association to access when required. HR departments are in charge of supervising the employee-benefits design, employee recruitment, performance appraisal, and rewarding.

There are millions of HR practitioners worldwide and the function has abundant career opportunities.

MS Office helps HR(Human Resource) managers to:

Evaluate and enhance an organization’s productivity by employee performance-related decisions.
Recognize, develop and nurture top talent into employee training and development.
Know main reasons and patterns of employee turnover.
Maintain applicant database efficiently.
Learn how pay-for-performance, training, and other elements increase employee satisfaction.

MS Office for HR Professionals

Key Features

Want Help?

MS Office Course Syllabus

Microsoft Office Word

Introduction to Word

Working with text

Layout & printing

Working with objects

Collaboration & reviewing

Create and manage documents

Format text, paragraphs and sections

Create tables and lists

Create and manage references

Insert and format graphic elements

Manage document options and settings

Design advanced documents

Create advanced references

Create custom Word elements

Microsoft Office Excel

Introduction to Excel

Entering Data

Managing & Navigating through workbooks

Creating & Editing formulea

Formatting & Proofing

Create and manage worksheets and workbooks

Manage data cells and ranges

Create tables

Perform operations with formulas and functions

Create charts and objects

Manage workbook options and settings

Apply custom data formats, layouts & protection

Create advanced formulas

Create advanced charts and tables

Excel Dashboard

Microsoft Office Powerpoint

Introduction to Powerpoint

Working with Slides

Texts & Objects

Collaboration & reviewing

Create and manage presentations

Insert and format text, shapes and images

Insert tables, charts, SmartArt and media

Apply transitions and animations

Manage multiple presentations

Microsoft Office Outlook

Manage the Outlook environment for productivity

Manage messages

Manage schedules

Manage contacts and groups

About MS Office for HR Professionals

MS Office helps HR(Human Resource) managers to:

Contact Office:

FAQ

Related Courses

MS Excel Training

Basic of Computers

Laptop & PC Service

C Program Training

Request a callback