MS Office Training Course

MS Office Training Course

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.

  • ms office batch training Batch Training
    Starts from 6,999
  • ms office individual training Individual Training
    Get Price
  • ms office online training Online Training
    Get Price
  • ms office custom training 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.

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

6,999

18 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

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

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

Ms Office Training 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.

  • MOS course for Finance professionals.
  • MOS course for HR professionals.
  • MOS course for Sales & Marketing professionals.
  • MOS course for Business Management/Operations professionals.
  • MOS course for MIS/PMO professionals.
  • MOS course for IT/ITES professionals.

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
  • Anyone with a willingness to learn.
  • Basic knowledge of using Computers.
  • Freshers
  • Students
  • Working Professionals
  • Business Owners
  • Those who have Passion in developing Technological Skills
  • Well-Structured and Industry-Relevant Course Curriculum
  • Experienced and Dedicated Faculty Members
  • Exposure to Live Projects from Day One
  • Periodic Evaluation and Feedback
  • Placement Assistance on Successful Completion
  • 24 Days with Flexible Timing
  • 2 hours/Day for Weekdays Batch
  • 4 hours/Day for Weekend Batch
  • Live Instructor-led Online Training also available via Skype and Teamviewer
Contact Office:
  • Phone : 044 43 53 4999
  • Mobile : 9025 500 600
  • Email : [email protected]
  • Location: New No. 61, 2nd Floor, Arcot Road, Kodambakkam, Chennai

FAQ