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 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 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 Data Filter Normal Data Filter Advance 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 attend

MS 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-requisites

Basic understanding of Microsoft 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. 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.