Microsoft® Excel Advance Training Course

 

Advanced Excel Training Certification is a 2-day program for those who are in managerial positions or leadership positions or who want to unleash the power of MS Excel. During this program, you will learn to perform various complex functions like Pivot Tables, Relative and Fixed Referencing, etc., and introduces you to time-saving techniques.

 

This course is designed for engineers, corporates, and finance professionals who want to explore areas of data analytics. This course helps you to perform data comparison, data presentation methods and many complex tasks. Many tips, tricks and time-saving techniques are familiarised to perform more efficiently

​

​

Advance MS Excel Training 

• Performing complex calculations more efficiently, using various Excel functions.

• Organizing and analyzing large volumes of data.

• Creating MIS reports.

• Designing and using templates.

• Analyzing data using chart

• Consolidating and managing data from multiple workbooks.

• Recording Macro to automate work

• Earn 14 PMI PDUs

​

Course Coverage 

• Overview of the Basics

• Working with Cell Reference

• Working with Formulas & Functions

• Sorting & Filtering data

• Working with Styles & Formatting

• Working with Vlookup & Index and Match

• Working with Range Names

• Data Validation

• Working with Templates

• Working with Reports

• More Functions

• What-If Analysis

• Basic of Macros

 

Attendees Profile 

• CIO, CTO, Vice President, IT Head, Project managers, Senior Managers, Senior Consultant,  Functional Managers, Program managers, PMO / PMO consultants, Project Team Lead, Business Head, Business Analyst, Management Trainee, Graduates, Freshers or anyone who typically support or manage project/ program containing complex activities.

• However, this course can be taken by anyone who wants to learn and Improve MS Excel Skills

​

​

For Training Schedule,

Course Fee / Corporate Rate Details

​

Contact -

PMI Mumbai Chapter Office:    +91 8655092194 / +91 22 46081148

 

Mr. Sunil Karangutkar: admin@pmimumbaichapter.org                  +91 8898707025

​

Mr. Tushar Baraskar:  info@pmimumbaichapter.org                      +91 9167979221

​

​

​

​

​

​

Registration cancellation or rescheduling policy:

Registration can be cancelled or rescheduled for a cancellation fee by sending an email to admin@pmimumbaichapter.org or info@pmimumbaichapter.org  along with details of the payment. Telephonic or oral requests will not be entertained.

​

Cancellation/rescheduling fees:

• For cancellations or reschedule before 7 days from the start of the program – 25% of the registration fee

• For all cancellations or reschedule upto 7 days before or after the start of the program – 50% of the registration fee

• Cancellation or reschedule requests received after 7 days from the start date of the program will not be entertained.

• Requests for partial cancellation or rescheduling will not be entertained.

 

​