Loading Events
This event has passed.

Introduction:
Organizations today have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. Data analysis & representation is indispensable to facilitate decision making and strategy development. It’s very challenging to turn a huge amount of data to useful information without the help of Excel.

The Advanced Excel Course is designed for executives who are already familiar with the basics of Microsoft Excel, and who would like to work with more advanced features of Microsoft Excel that help in improving their efficiency of working with worksheets, analyzing data, creating MIS reports, and automating various tasks. In this course, you will use Microsoft Office Excel to streamline and enhance your spreadsheets with templates, charts, graphics, data analysis and formulas. Demonstrations will be based on the MS Office version.

Prerequisites:
Participants should be familiar with basic excel that contain few functions like sum, max, min etc, formatting like borders, fonts, merge, etc, saving, printing techniques. Participants need their own laptop/ PC with MS Office installed, for better understanding and practical experience. The participants may also bring with them live data pertaining to their organization, so that these can be studied during the workshop, as to how it can be worked out with better solutions.

This program is for anyone who is already familiar with the basics of Microsoft Excel, and who would like to work with more advanced features of Microsoft Excel that help in improving their efficiency of working with worksheets, analyzing data, creating MIS reports, and automating various tasks.

Program Objectives:
This Advanced Excel training program will empower the participants to be able to do the following:
Performing complex calculations more efficiently, use various Excel functions.
Organizing and analyzing large volumes of data.
Creating MIS reports.
Designing and using templates.
Consolidating and managing data from multiple workbooks.

Delivery Method:
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities. This Advanced Excel Course will empower the participants to be able to do the following:
• Performing complex calculations more efficiently, using various Excel functions.
• Organizing and analyzing large volumes of data.
• Creating MIS reports.
• Designing and using templates.
• Consolidating and managing data from multiple workbooks.

Course Contents:
• Advanced Formulas and Functions
 Advanced Financial Functions
 Advanced Logical & Error Functions
 Advanced Text Functions
 Advanced Date & Time Functions
 Advanced Lookup & Reference Functions
 Advanced Mathematics and Statistics Functions
 Advanced Information Functions
• What If Analysis
 Scenario Analysis
 Goal Seek
 Data Table
• Data Consolidation
• Working with Duplicates
 Using the Remove Duplicate command
 Array formula to locate duplicate data
• Data Validation
 How to lock values and formulas in your Excel worksheets
 Track down mistakes in your worksheet using the Formula Auditing tools
 How to use the Trust Center settings to manage Excel security
 How to share your Excel workbook and not worry about someone making changes
 that’ll ruin your work
 How to use Data Validation to make sure the data going into any cell meets the
 criteria you’ve specified
• Advanced Custom Formatting
• Advanced Conditional Formatting
• Sparklines, Slicers & Timelines
• Random Numbers
• Debugging formulas & Dependency Tree
• Counting Unique, Generating Unique List
• Working with Duplicates
• Advanced Pivot Tables
 PivotTable calculations
 Creating separate sheets for PivotTables
 Using slicers in PivotTables
 Summarizing pivot data
 Sorting and filtering data
 Conditional formatting in PivotTables
 Creating Pivot Charts
• Advanced Charting
• Macros
• Troubleshooting Excel Problems
• Tips & Tricks

Medium: English/ Hindi/ Marathi

Fees and Registration:
Fees: Rs. 1,500/- + GST 18% per person.
Incentive: Rs. 1,300/- + GST 18% per person for a group of Three or more Members from the same or different Organizations.

Fees include participation, course material (Soft copies) and certificate.

Kindly provide below details for registration to Email: iitdpune@gmail.com; rajiv@iitdworld.com
● Name of the workshop:
● Name of the participants with Email ID & Mo. Number:
● Company Name and address:
● GSTN Number:
⮚ Please reply on E Mail – iitdpune@gmail.com or rajiv@iitdworld.com
⮚ Pre-payment and pre-registration is required
⮚ Participation fee is non-refundable/ non-adjustable against any other programme of IITD, but change in nomination(s) is accepted

The participation fee can be paid by way of NEFT/Cheque drawn in favour of “Indian Institute of Training & Development” payable at Pune or through NEFT.

NEFT Details – Indian Institute of Training & Development
Bank Name – Bank of India
Current Account No: 052320110000336
ISFC Code – BKID0000523
Branch – Kothrud (Gujarat Colony), Paud Road, Pune 411029.
GSTN Number: 27BDNPK3328J1Z9

Certification:
Certificate of Participation would be sent to all the participants through Speed post/ courier.