MS Office Training Course

MS Office for MIS Professionals

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

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.

  • ms office batch training Batch Training
    Starts from 7,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

One to One live Online Taining

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

Ms Office Training Course

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.

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."

Benefits of using MIS dashboards:

  • A visual presentation of performance measures.
  • Ability to identify and correct negative trends.
  • Measure efficiencies / inefficiencies.
  • Ability to generate detailed reports showing new trends.
  • Align strategies and organizational goals.
  • Saves time compared to running multiple reports.
  • Gain total visibility of all systems instantly.
  • Quick identification of data outliers and correlations.
  • 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 : admission@zuaneducation.com
  • Location: New No. 61, 2nd Floor, Arcot Road, Kodambakkam, Chennai

FAQ