MS Office Training Course

Enroll Now

MS Office Training

We ensure that our MS Office training course gives you robust office management tools with the right mixture of usability, power, and flexibility, so you can manage your job more efficiently and productively. This course will cover MS Word, MS Excel, MS PowerPoint, Outlook & Project. Learn core and advanced Microsoft Office products through our MS office training classes and improve your skillset to meet the market demand.

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

Microsoft Office Course Packages

Basic

7,999

20 hours

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

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

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

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

Advanced

13,999

36 hours

Microsoft Office Word

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

Microsoft Office Excel

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

Microsoft Office Powerpoint

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
Animate slide content
Set timing for transitions and animations

Manage multiple presentations

Merge content from multiple presentationsa
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

Master

19,999

48 hours

Microsoft Office Word

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

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

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 Course

Nearly every office or home use Microsoft Office package to perform several routine tasks such as sketching a letter, making a financial statement, generating a slide show, etc. Microsoft Office is considered as an essential skillset for today’s business professional’s. It includes programs that help you solve problems, answer questions, express ideas, organize data and communicate. Sharpen your skillset and learn tips and tricks that you haven't discovered yet on all Microsoft products, including Microsoft Office 2007, 2010, 2013 and the newest in Microsoft Office 2016 training.

MS Office and its applications are the ones which is used by most of the businesses and organizations in this vast world. Admittedly, it requires being appreciated as an incredible invention that was ever made. But, even this sometimes leads to experience at a workplace, if not operated correctly. So, in order to sustain in this technology world, it is extremely needed to gain specialized knowledge in MS Office. There are groups of training solutions feasible which helps to learn directly and cleverly with no strain and pressure.

Zuan Education is one of the best MS Office training institutes in Chennai. Our faculties are IT specialists with more than 14 years of real-time experience in the industry. All training classes are In-Person, Instructor-led, and hands on. Our fully customizable courses are offered both on-site (at the client site) and off-site (at Zuan Training Center). Our focus is our students’ successful transformation into an MOS professional. Upon successful completion of this MS Office course, all students will be awarded with MS Office course completion certificate. This would also enable you to take up MOS certification.

Why is MOS Certification Essential?

The All-in-One Microsoft Office Suite offers flexible and powerful ways to organize, manage, and present information. Globally used in most of the offices, knowledge of Microsoft Office tools are a must for anyone in today's job market.

Microsoft Office training helps improve work productivity & efficiency with user-friendly features that enable easy and secure data sharing. Microsoft Office training provides resources for professional presentation of information that helps to advance in your career.

Whether you are looking to expand your Microsoft Office skills for personal use, get on on a new job, or working towards career progression, Zuan Education has the Microsoft Office training that you are looking for.

What will you learn from this MS Office Course?

You will learn about these techniques from our MS Office certification course.

How to create, save and open documents.
You will learn how to manage page appearance including using columns, indents, footers, borders, and watermarks.
Learn how to insert and edit tables.
You will learn how to personalize your use of Excel using Excel Options.
Learn how to create charts and graphs.
You will learn presentation tips for an effective presentation
Find out how to insert shapes, graphics, and pictures to your presentation.
You will learn time-saving techniques including how to copy slides, and be exporting your presentation

FAQ

What are the prerequisites of learning MS Office?

Anyone who has the interest to learn MS Office shall join this microsoft office training course. The In-Person training venue, domain specific curriculum and other strategic initiatives comprise the core of our training philosophy and connect our students to their successful career.

Why should I learn MS Office?

Microsoft Office is one of the most generally utilized suites of productivity tools in the business world. In fact, it's so necessary that understanding it is an essential to obtaining employment at some companies. Given its prevalence in the corporate world, getting to be Microsoft Office certification is one way you can stand out from the crowd and determine your level of proficiency.

Do you give MS Office course completion certificate?

Yes, we will provide course completion certificate after you complete this Microsoft Office Training. Including this, we will assist you to gain MOS Certification.

Why should you get Microsoft office certification at Zuan?

We are one of the best MS Office training institutes in Chennai. You can rest assured that whatever your requirements are, we can deliver solutions to meet them. Meeting your specific learning needs is our first priority. Our students have consistently indicated high on the job productivity levels.

I need to know more about this MS Office training course. Whom do I communicate?

Have a word with our instructors via a phone call to +91 9025500600, or connect our live chat for immediate support. You may also leave your queries to info@zuaneducation.com

Do you provide MS Office online course?

Yes, we are offering MS Office online course. Depends on the candidate's requirement we will provide online MS office training.

How will the Online MS Office training classes be taken?

In our MS Office online training, the classes will be taken by Skype. So you need to have a computer or laptop, uninterrupted internet connection, Skype ID and Teamviewer software.

Do you provide any materials for MS Office training course?

We provide soft copy of our MS Office training course material which includes the step by step learning process. This course material will be helpful for you.

What is the MS Office certification course duration?

Our MS Office certification course duration is 20 hours. For classroom training will be 2 hours per day which means 10 hours a week. If you want weekend classes, you need to spend 4 hours per day, which is 8 hours a week.

Do you provide classroom MS Office training in Chennai location?

Yes, We are providing classroom training for MS Office course in Chennai. We are located at Kodambakkam which is quickly reachable from any area in Chennai.