Programme Index
National Insurance Academy, Pune | Information Technology

P871 | Excel for Business Application (Basic) (Non-Life)

Academic Year 2026-2027

Duration
3 Days
Scheduled Dates
15 Jun 2026 - 17 Jun 2026

Background

Excel is one of the most widely used spreadsheet software tools in the insurance industry across departments. It is extensively used for data entry, data management, basic analysis, and reporting.

Microsoft Excel provides a strong foundation for handling structured data efficiently through features such as formulas, functions, charts, and basic data analysis tools.

Learning Objectives

  • A clear understanding of these foundational concepts is essential before progressing to advanced analytics tools like Pivot Tables, Power Query, and Macros.
  • Against this background, this hands-on training has been arranged to build essential Excel skills for effective day-to-day business usage.

Key Contents

  • Essential Functions
  • Introduction to Pivot Tables
  • Data Cleaning, Validation & Preparation
  • Basic Data Analysis
  • Basic Charts & Visualizations
  • Basic Dashboard Concepts
  • Introduction to Macros
  • Power Pivot

Who Should Attend

  • This training-course is open to all Insurance organizations (GI, HI, LI, RI) and other related organizations from within India as well as from other countries.
  • Officers / Executives / Staff from Operations, Marketing, Sales, Services, Claims, Finance, and administrative functions, as well as professionals from IT and Analytics domains who wish to build foundational Excel skills.
  • Working employees from any other organization who are interested in learning 'Basics of Excel'. Basic computer knowledge is assumed. No prior advanced Excel knowledge is required.
  • Approach: 100% Hands-on training.
National Insurance Academy
25, Balewadi, Baner Road, NIA P.O., Pune 411 045 India
+91-20-27204053  |  programoffice@niapune.org.in
Source: