_

Course Introduction

MS Excel is a very powerful and user friendly tool for any organization. This predestines it for use in Engineering, Industrial and technical calculations and creating reports with many benefits. Macros are very useful to automate tasks. The innovative ideas are emerging so fast that it is time for having knowledge on how to enhance our presentation skills, enhance the performance of MIS reports and manage data in worksheets efficiently.

Industrial Training Objectives

The objective of the programme is to impart awareness of the advanced options existing in MS Excel and how to fully realize the usefulness of those advanced options in order to enhance the utility of MS Excel for Reporting Generation.& Data Analycis

Course Outcomes

• Overview & features of Excel 2016
• Data filters: AutoFilter and
• Advanced Cell level validations
• Using data tables for data analysis
• Mastering PivotTables, Pivot Charts
• Working with external databases
• Using data forms for managing tabular data
• Workbook sharing, Tracking changes
• Goal Seek
• Scenario Manager
• Auditing
• Managing add-ins
• Customizing toolbars and menus
• Conditional formatting of cells
• User-defined functions
• Control-flow statements
• Objects, properties and methods
• Creating Automatic Procedures
• Creating and Using Shared Workbooksl
• Working with Worksheet Protection
• Working with Multiple Workbooks in Excel
• Working with Macros in Excel
• Make a Macro do Simple Tasks
• Creating a Simple Macro
• Changing Multiple Properties at Once
• Recording Methods in a Macros
• Data Analytics Tools
• Solver for What-if Analysies
• Power Pivot’s
• Case study

Course Schedule

Dates: 19 – 21  JAN 2022 (6 Hours per day )

After registration participant can access ESCI LMS platform for digital learning

Online session timings will be from 10:00 – 17:00 hrs with 15 Minutes Tea breaks One Hrs Lunch Break.