Date : 04/06/2026 (ONE-day Program) Time : 09.30 am - 4.30 pm

Venue : Productivity House, Kalamassery

---

Introduction

---

This programme is designed for those who are familiar with the basics of Microsoft Excel and would like to work with more advanced features of MS Excel that help in improving their efficiency of working with worksheets, analyzing data, creating MIS reports and automating various tasks. The goal for this session is to equip with valuable skills and insights that will enhance the ability to analyse and present data effectively.

COVERAGE

• The program covers essential industry-focused topics including Lookup Functions (Xlookup, Vlookup, Hlookup, Index and Match) Logical Functions: (if function, if with OR & AND, Nested ifs), Text Functions (Trim, Len(), left(),right(), mid() etc.), Conditional Formatting, Pivot Tables, Pivot Charts, sumif, countif and average if, Data validation, Group by, Subtotal and Advanced Statistical functions (max, min, large, small, median, mode, average, rank, rand etc.). Designed with practical business scenarios and hands-on exercises, this training helps professionals improve reporting, analysis, and decision-making skills.
• Participants should bring laptop with them for better hands on experience.

FACULTY

FEE PER PARTICIPANT

• Members of KSPC - Rs.2,000/-
• Non-members        - Rs.2,200/-
• GST @ 18% Extra

Special discount of 10% will be offered, if 2 or more nominations from the same organization

GENERAL

• Well prepared course material will be supplied
• Lunch & refreshments will be served

Last Date for Nominations : 02-06-2026