About the Course
This is an industry based course, will teach the Microsoft Excel which is being used in doing analysis and preparing advance MIS reports in the Industry.
It is a fully practical based training and beneficial for career oriented people.
Topics Covered Overview of Basic Excel skills
Basic Short Keys
Techniques of Paste Special
Protect Worksheets & Workbooks
Time Saving Utilities
Text to Columns with fixed and delimited parameters
Data Sorting using custom list
Summarizing data using Group and Outline
Concept of Cell Referencing
Important Functions in Excel
VLOOKUP – 1D
VLOOKUP – 2D
Defining Static and Dynamic List using names
Use of Names in Advance Reports
Conditional Formatting using Formulas & cell values
Calculation based Conditional Formatting
Different Data validation in Excel
Using Dynamic list in validation
Charts in Excel
Elements of Charts
Major charts used in Excel
Creating Dynamic Charts
Pivot Table creating Methods
Rearranging a Pivot Table
Filtering Pivot Table Data
Performing Custom Calculation
Normal Data Filter
Calculation based filter
Filter using wild cards
Summarizing data using Subtotal
Analyzing data with What-If Analysis
Determine unknown with Goal Seek
Analyze data with Data Table
Who should attendMS Office Specialist, MIS Personals, VBA Programmer, Accounts Personal, Project Managers, Developers, Technical/ Test Leads, Program Managers, Project Managers, Research Workers, Freelancers, Data analysis departments, HR Managers, Students
Pre-requisitesBasic understanding of Microsoft Excel.
What you need to bringNotebook
Key TakeawaysUnderstanding importance of Management Information System at corporate environment.
Perform Data Analysis on key performance indicators to drive performance and operational excellence to exceed the goals.
Proactively monitor Performance Dashboards to determine key areas of focus and to identify root causes and potential corrective Actions.
Develop and provide Trend Data and Analysis on key performance indicators as required.
Track, monitor and report out on all Service Delivery and Quality Improvement Plans.
Develop Automated Dashboard.
Prepare Annual Reports in less than a minute.
Analyze data and enhance Decision Making to generate new business opportunities.
Analyze Trends and increase the accuracy of forecasting.