What is the course duration of MS Office training?

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

Do you provide MS Office classroom training in Chennai location?

Yes, We are providing MS Office classroom training in Chennai. Our institute is located at Kodambakkam which is quickly accessible from any area in Chennai. So, you can easily reach us.

MS Office for MIS Professionals

MIS (Management Information System) is the eyes of business.

Enroll Now

MS Office Training for MIS Professionals

We offer MS Office training course for MIS professionals. Our course syllabus is based on current industry demands across various disciplines. It covers all the core topics with specialization modules to help you learn from the scratch. You will learn to create MIS reports & dashboards from different Management Information Systems using drag & drop, customize reports with a few clicks. Upon successful completion of this MS Office training, all students will be awarded with MS Office course completion certificate.

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

ADVANCED EXCEL COURSE FOR MIS

Module1: Excel Introduction

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

Module 2: Entering Data

Entering, Editing and Deleting Text, Numbers, Dates
Using Auto Lists
Moving and Copying data
Inserting, Deleting and Hiding Rows & Columns
Inserting, Deleting, Moving and Copying Sheets
Using navigation techniques

Module 3: Customizing Excel

Customizing the Ribbon
Customizing the Quick Access Toolbar
Using and Customizing AutoCorrect
Changing Excel’s Default Options
Creating a Custom AutoFill List
Creating a Custom Number Format
Customizing Excel Review

Module 4: Managing and Navigating Large Workbooks

Using Workbook Views
Selecting and Switching Between Worksheets
Splitting and Freezing a Window
Creating Headers and Footers
Hiding Rows, Columns, Worksheets, and Windows
Working with Multiple Workbook Windows
Creating a Template
Managing Workbooks Review

Module 5: Creating and Editing Formulae

Concept of Formulae
Creating Formulae, Editing Formulae
Bodmas : Mathematical Order
Copying Formulae
Using Functions - Sum, Average, Max, Min, Count, Counta
Applying Absolute (Fixed) Referencing

Module 6: Referencing Techniques

Relative Reference
Absolute Reference
Mixed Reference
Moving Range Reference

Module 7: Formatting and Proofing

Formatting Cells with Number formats, Font formats, Alignment, Borders, etc
Basic conditional formatting
Copying and Clearing Formats
Working with Styles
Spell Check, Find & Replace and AutoCorrect

Module 8: Mathematical Functions

SumIf, SumIfs
CountIf, CountIfs
AverageIf, AverageIfs
SumProduct, Subtotal

Module 9: Lookup Functions

VLookup / HLookup
Match
Dynamic Two Way Lookup
Creating Smooth User Interface Using Lookup
Offset
Index
Dynamic Worksheet linking using Indirect

Module 10: Logical Functions

Nested If (And Conditions, Or Conditions)
Alternative Solutions for Complex IF Conditions to make work simple
And, Or, Not

Module 11: Text Functions

Upper, Lower, Proper
Left, Mid, Right
Trim, Len
Concatenate
Find, Substitute

Module 12: Date and Time Functions

Today, Now
Day, Month, Year
Date, DateDif, DateAdd
EOMonth, Weekday

Module 13: Rounding Functions

Round
RoundUp
RoundDown
MRound

Module 14: Error Handling Functions

isNa
isErr
isError

Module 15: Advanced Paste Special Techniques

Paste Formulas
Paste Formats
Paste Validations
Paste Conditional Formats
Add / Subtract / Multiply / Divide
Merging Data using Skip Blanks
Transpose Tables

Module 16: Sorting a

Sorting on Multiple Fields
Dynamic Sorting of Fields
Bring Back to Ground Zero after Multiple Sorts

Module 17: Filtering

Filtering on Text, Numbers & Date
Filtering on Colors
Copy Paste while filter is on
Advanced Filters
Custom AutoFilter

Module 18: Printing Workbooks

Working with Themes
Setting Up Print Area
Printing Selection
Branding with Backgrounds
Adding Print Titles
Fitting the print on to a specific defined size
Customizing Headers & Footers

Module 19: Import & Export of Information

From Web Page
Exporting to XML
Creating Dynamic Dashboards and Reports Using Data on Other Applications
Using Text To Columns

Module 20: What If Analysis

Goal Seek
Scenario Analysis
Data Tables

Module 21: Data Validation

Number, Date & Time Validation
Text Validation
List Validation
Handling Invalid Inputs
Dynamic Dropdown List Creation using Data Validation

Module 22: Protecting Excel

File Level Protection
Workbook Level Protection
Sheet & Cell Level Protection
Setting Permissions for Specific Tasks
Track changes

Module 23: Consolidation

Consolidating data with identical layouts
Consolidating data with different layouts
Consolidating data with different Sheets

Module 24: Conditional Formatting

Creating Basic Conditional Formats
Managing Conditions Created
Dynamic Formatting using Formulas in Conditional Formatting

Module 25: Pivot Tables

Creating Simple Pivot Tables
Basic and Advanced Value Field Setting
Sorting based on Labels and Values
Filtering based on Labels and Values
Grouping based on numbers and Dates
Drill-Down of Data
GetPivotData Function
Calculated Field & Calculated Items

Module 26: Charts & Pivot Charts

Bar Charts / Pie Charts / Line Charts
Dual Axis Charts
Dynamic Charting
Other Advanced Charting Techniques

Module 27: Excel Dashboard

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

About MS Office Training for MIS Professionals

Zuan Education is one of the reputed MS Office training institutes in Chennai. We offer a customized training programme for individual and corporate needs. Our students have consistently indicated high on the job productivity levels. Our faculties are IT specialists with 14+ years of real-time experience in the industry. We provide instructor-led online and classroom training sessions for deeper understanding.

Microsoft Office evolved from its simple origins into the dominant productivity suite on the planet. Indeed, knowledge of Microsoft usage is one of the basic requirements for most of the job profiles. Be it business analysis, accounting, marketing; you need to have adequate awareness of Microsoft programs.

MS Excel enables you to create MIS reports & dashboards from different Management Information Systems using drag & drop, customize reports with a few clicks. It empowers users to quickly extract and report information that organizations need to manage themselves effectively. MS Excel allows you to quickly generate MIS reports for Management Information Systems at all company levels and departments. It provides operational level managers and high-level managers the insights to improve their business processes and operations. MS Excel MIS delivers a complete overall picture of the company.

In management information system, a dashboard is "an easy to read, often single page, real-time user interface, showing a pictorial representation of the current status (snapshot) and historical trends of an organization or its key performance indicators to enable instantaneous and informed decisions to be made at a glance."