_

Course Introduction

Microsoft Office is a set of computer applications mainly used for business or office administration purposes.            MS Office helps simplify basic office tasks and improve work productivity. Each application is designed to address specific tasks, such as word processing, data management, making presentations and organizing emails.

There are lots of new features added in MS Word 2016 such as ability to create, open, edit and save files in the cloud directly from user’s desktop, a new search tool added for commands available in word, PowerPoint, and Excel. 

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.

Industrial Training Objectives

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

Course Outcomes

• Introduction to MS Office 2016
• Working with MS Word
• Creating a Microsoft Word Document
• The Ribbon
• The Quick Access Toolbar
• Formatting Microsoft Word Documents
• Editing Documents
• Finalizing Microsoft Word Documents
• Microsoft Word New Features
• Working with MS Power Point
• New Features in Power Point 2016
• 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
• Managing add-ins
• Customizing toolbars and menus
• Conditional formatting of cells
• User-defined functions
• 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: 08 – 10 FEB 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. One Hour Lunch Break and 10 Minutes Tea Break