Certificate Programme on Advanced MS Excel

Methodology – Online Live Demonstrative Training

Course Fees – Rs. 6000 Per Participants (Discount of Rs. 1000 on two enrollments)

Duration of Program – 16 hours (5 Session of 3 hours Each + 1  hour test)

Participant Profile –

This program is must for candidates aspiring to get promoted as Team Lead / Managers / Need to represent analytical reports to Managers. This program is also a must for professionals who handle large spreadsheets and are responsible for reporting and managing MIS.

Eligibility —

Any Graduate must be well versed with basic Excel.

Take Away –

• Course Completion Certificate
• Improve participant’s logic through decision making functions
• Ability to Analyze data
• Creating and Maintain MIS / Reports

Programme Content —

1. Working with Decision based functions
   • Using IF condition with logical functions (AND, OR, NOT)
   • Simple and Nested IF Conditions
2. Data Validations
   • Specifying a valid range of values for a cell
   • Specifying a list of valid values for a cell
   • Specifying custom validations for a cell
   • Creating dynamic Lists using data validation and Named Ranges
3. Working with Reports (Pivot Tables)
   • Creating Pivot Tables
   • Understanding the Pivot Field
   • Inserting a Calculated field
   • Formatting a Pivot Table and Modifying the Field Settings
   • Slicers
4. Graphical representation of data through Pivot Charts
   • Creating dynamic charts using Pivot Charts
   • Applying slicers in Pivot Charts
5. Lookups
   • Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
   • Nested VlookUP
   • VlookUP with Tables, Dynamic Ranges
   • Using VLookUP to consolidate Data from Multiple Sheets
6. Basic Macros & Dashboards
   • Keyboard Macros
   • Assigning Macros to Objects
   • Dashboards with Pivot

Trainer’s Profile –

ARATHI SANJAY PUROHIT comes with Over 22 years of experience into trainings in IT and Management to enhance the performance level of learners. Arathi has experience of more than 100 Hours of training on Excel and Advance Excel in her kitty. She had conducted online and offline programs for Companies like KPMG, Finolex Industries Ltd, Ognibene India Pvt Ltd., and many more Companies and Educational Institutes.

Few of Her Certifications –

• • Certified Internal Auditor from Shree Consultancy in collaboration with C-DAC Pune & KPMG Authorized Faculty Certification from Sikkim Manipal University
  • Linkedin Learning Certification for Excel: Advanced Formulas & Functions.