MIS Core, Advanced Excel With Dashboard

Best MIS Advance Excel Training @ Innozant

Innozant offer unparelelled job oriented MIS advance excel training. Using advanced excel analysis report can allow your business to keep everything filed in a neat and orderly fashion to speed things up.Microsoft Excel is an electronic spreadsheet application which is used for organizing, storing, and manipulating and analyzing data.MIS is an integrative field. MIS professionals are the "communication bridge" between business needs and technology.Management Information Systems (MIS) is the study of people, technology, and organizations. During your training, we will familiarize you with how to organize the unformated data,manipulate and analyze data and to make a meaningful report.

Innozant has been providing MIS course since long time and is one of the best computer training institute in Delhi- NCR for MIS advance Excel Training, Innozant offers facility of Computer training at New Ashok Nagar Delhi. Learning MIS Advance Excel is useful for beginners and working professionals who want to learn MIS Data Analysis Reporting, this is a short term job and quality oriented practical training, We focus on skill building approach and try to enhance students skills at par excellence.

Advanced Excel

MIS Core, Adv. Excel With Dashboard Training

Target Audience
Fresher and working professional want to enhance their analytical and reporting skills.We enhance skills of students/ Working professional with MIS advance excel data organizing,storing and analysing skills which have become part of life in today's computerized world.

Course Highlight

Basic Level Training
We offer basic level quality course where student learn and familiar with Basic use of Excel , how to use Ms Excel to perform calculations and financial management work by Certified and experienced trainers.
Advance Level Training
We offer advance level quality course where student can learn how to do advanced data analysis using Advanced Excel & solving analytical problems using Goal seeker, Solver, macros & Lookups etc.Innozant certified course which helps you to get skilled job with reputation in professional life.

Advantage Innozant
-: Training Satisfaction Guaranteed
-: Applied and Conceptual learning Process
-: No Limit on Practice sessions
-: Focus on practical oriented approach
-: Learn Job oriented feature i.e.Vlookup,Index,Match,offset etc
-: Competent Fees
-: Guaranteed delivery of said content
-: Experienced and renowned Trainer
-: Individual attention
-: Career counseling

Course Highlights

Excel is an electronic spreadsheet which is used to organize , calculate and analyse the data.

Training Duration Regular : 90 Hrs With Highly Skilled Corporate Trainers for 3 Months
Training Duration Fast Track : 90 Hrs With Highly Skilled Corporate Trainers for 1.5 Month
Introduction to Excel and Advance Excel
EXCEL INTRODUCTION
• What is Excel
• Excel Interface
• An overview of the screen, navigation and basic spreadsheet concepts
• Shortcut Keys
CUSTOMIZING EXCEL
• Customizing the Toolbar
• Customizing the Ribbon
• How to Edit the Custom List
• Changing Excel’s Default Options
FORMATTING AND PROOFING
• Formatting Cells with Number formats, Font formats, Alignment, Borders, etc
• Freeze Panes
• Conditional formatting
ADVANCED PASTE SPECIAL TECHNIQUES
• Paste Formulas, Formats,
• Operation- Add, Multiplt , Substract ,Divide
• Transpose Tables
FORMULA REFRENCE
• Relative
• Absolute
• Mixed
EXCEL BUILT IN FUNCTIONS
• Logical Functions
• Math Functions
• Text Functions
• Date and Time Functions
• Statistical Functions
• Information Functions
• Database Functions
• Lookup and Reference Functions
• Financial Functions
WORKGROUP COLLABORATIONS
• Protecting a workbook
• Protecting a worksheet
• Locking /Unlocking cells in a worksheet
• Creating a shared workbook
• Tracking changes to a workbook
• Accepting and protecting a workbook
• Merging workbooks
PRINTING WORKBOOKS
• Setting Up Print Area
• Customizing Headers & Footers
• Designing the structure of a template
• Print Titles –Repeat Rows / Columns
FORMULA TOOLS
• Tracing formula precedents
• Tracing cell dependents
• Error checking
SORTING AND FILTERING
• Filtering on Text, Numbers & Colors
• Sorting Options
• Advanced Filters on 15-20 different criteria(s)
USING RANGES
• Ranges in Ms Excel
• Naming Range
WORKING WITH THE WEB AND EXTERNAL DATA
• Inserting a Hyperlink
• Importing Data from an Access Database or Text File
• Importing Data from the web and other sources
• Working with Existing Data Connections
SUMMARIZING DATA
• Adding subtotals to a list
• Nesting subtotals
• Text to column
DATA VALIDATION
• Number, Date and Time Validation
• Text and List Validation
• Custom validations based on formula for a cell
• Dynamic Dropdown List Creation using Data Validation – Dependency List
USING MACROS
• Macro options
• Creating Macros
• Editing and Deleting Macros
• Use Relative References
DATA ANYLYSIS TOOL
• Goal Seek
• Scenario Manager
• Data Tables (PMT Function)
• Solver Tool
PIVOT TABLES
• Introduction to PivotTables (collapsing and expanding fields, sorting data, drilling down) Classic Pivot Table
• How to automatically update PivotTables
• Classic Pivot table
• Text Filters-how text filters are used to filter a PivotTable based on text.
• Grouping and Pivot Charts-How to group data in a PivotTable and create a chart based on a PivotTable
• Value Field Settings and Show Values As-how to summarize data as a Percentage of a Row or Column.
• Creating Calculated Fields and Calculated Items
• Using Slicers, Filters, and Timelines to quickly analyse data
• GETPIVOTDATA Function
• Creating Pivot Tables From Multiple Ranges-how to create PivotTables from data in multiple worksheets and/or workbooks.
• Multiple Pivot Tables -how to create many PivotTables based on a Filter.
• Data Model -Data Model to efficiently link data without using thousands of VLOOKUPS.
• Using Multiple Slicers with Pivot Tables -how slicers can be set to control more than one PivotTable
• Conditional Formatting and PivotTables-how to apply Excel’s great Conditional Formatting capabilities to PivotTables
POWER PIVOT , DATA ANALYSIS AND VISUALIZATION
• Power Pivot
• Data Analysis Using Statistics, Analysis Tool pack
CHARTS AND SLICERS
• Creating a chart with the 2D or 3D
• Create column chart, pie chart
• Various Charts i.e. Bar Charts / Pie Charts / Line Charts
• Create speed – o- meter chart
• Moving a chart one to another sheet
• Formatting category & value Axis data
• Formatting a data series
• Changing a charts source data
• Using SLICERS, Filter data with Slicers
ARRAY FUNCTIONS
• What are the Array Formulas, Use of the Array Formulas?
• Basic Examples of Arrays (Using ctrl+shift+enter).
• Array with if, len and mid functions formulas.
• Array with Lookup functions.
• Advanced Use of formulas with Array.
LOOKUP FUNCTIONS
• Vlookup / HLookup
• Creating Smooth User Interface Using Lookup
• Row , Rows , Column , Columns
• Index and Match
• Nested VLookup
• Reverse Lookup using Choose Function
• Worksheet linking using Indirect
• Vlookup with Helper Column
• 3D Lookups
• Duplicate Vlookup
• Partial AND Duplicate Vlookups
• Dynamic Lists
• Address
• Offset
• Smart Lookup
• Mastering Vlookup – 50+ Examples Rehearsal
EXCEL DASHBOARD
• Planning a Dashboard
• Adding Tables and Charts to Dashboard
• Link with one sheet to another worksheets, One workbooks, multiple workbooks
• Interactive Dashboard with Form Controls
• Form Controls for reports automation