Do you give a certification for MS Office course?

Yes. After completing this Microsoft Office Training, we will provide a certificate to all of our students. Including this, we will help students to gain MOS Certification.

Why should you get MS Office certification in Zuan Education?

Zuan Education is one of the best MS Office training institutes in Chennai. Our training faculties are industry experts, and they are having an experience more than 14 years. So, you will gain real-time working experience in all kinds of the MS Office techniques. We also provide placement assistance for our students.

MS Office for Finance Professionals

Enroll Now

MS Office for Finance Professionals

We offer MS Office training course for finance professionals. Our training allows professionals to manage finance models by applying Microsoft office tools and applications. The financial modeling is the task of making a model representing financial asset and performance of a business. 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

MS Office for Finance 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 Finance Professionals

Contact Office:

FAQ

Related Courses

MS Excel Training

Basic of Computers

Laptop & PC Service

C Program Training

Request a callback