The training will cover all the aspects of Microsoft Excel for core MIS at corporate level.

Topics Covered

Overview of basic Excel skills Basic Short Keys Basic Functions Worksheet Operations Format Cells Cell Operation Freeze Panes Techniques of Paste Special Protect Worksheets & Workbooks Time Saving Utilities Format Painter Text to Columns with fixed and delimited parameters Data Sorting using custom list Summarizing data using Group and Outline Concept of Cell Referencing Relative Referencing Absolute Referencing Mixed Referencing Important Functions in Excel AND OR NOT COUNT COUNTA COUNTBLANK COUNTIF MAX MIN UPPER LOWER PROPER RIGHT LEFT MID POWER SUM SUMIF AVERAGE EXACT CONCATENATE LEN NETWORKDAYS IS FUNCTIONS MATCH INDEX IF VLOOKUP – 1D VLOOKUP – 2D Reverse VLOOKUP HLOOKUP LARGE SMALL SUBTOTAL SUMPRODUCT OFFSET NESTED FUNCTIONS Name Manager Defining Static and Dynamic List using names Use of Names in Advance Reports Conditional Formatting Conditional Formatting using Formulas & cell values Highlighting Duplicates Calculation based Conditional Formatting Data Validation 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 Pivot Table creating Methods Rearranging a Pivot Table Filtering Pivot Table Data Performing Custom Calculation Creating Dynamic Dashboards using pivot charts and Slicer Consolidating Data from external source or multiple files in less than a minute Creating Pivot Tables through Database Connections Array Functions for quick conditional calculations Data Filter Normal Data Filter Advance Filter Calculation based filter Filter using wild cards Summarizing data using Subtotal Data Consolidation Consolidation by categories Consolidation using 3D Formulas Analyzing data with What-If Analysis Determine unknown with Goal Seek Analyze data with Data Table Enable decision making using Solver View results with Scenario Manager Use of Form controls for creating Dynamic Reports and Dashboards

Who should attend

Anyone who wants to be expert in Microsoft Excel

Pre-requisites

Should have basic understanding of Excel

What you need to bring

Notebook Pen

Key Takeaways

Understanding 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. 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. Develop Time saving Utilities.