National Insurance Academy, Pune|Information Technology
P826 | Advanced Excel for Business Application (Combined)
Academic Year 2026-2027
Duration
3Days
Scheduled Dates
14 Oct 2026 - 16 Oct 2026
Background
Excel is one of the most widely used spreadsheet software tools in the insurance industry across departments. Microsoft has been continuously enhancing the features of Excel. Advanced Pivot Table, Advanced Charting & Visualizations, Advanced Functions, Excel Macros, Power Analytics features like Power Query - Power Pivot - Power Map, etc. in MS Excel are getting increasing popularity in Insurance industry.
Learning Objectives
Innovatively, Excel can be used for Data Mining & Machine Learning also. Excel can be integrated with Power BI, with RDBMS like Oracle, SQL Server & others, Web-sources, also with Microsoft Azure. Against this background, this hands-on training has been arranged.
Key Contents
Advanced Pivot Table
Advanced Charts & Visualizations
Professional Dashboards Development
Advanced Functions
Data Mining for Predictive Analytics
Excel Macros
Power Query & Power Pivot Using Excel
Excel integration with RDBMS SQL
Excel integration with Web: Web-based Excel
Who Should Attend
LIC: BMs/ Sr.BM/CM and Principals of STCs
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 / Managers or higher management from IT, Analytics, Marketing, Sales, Services, Claims, Financial Intelligence, Actuarial areas - AI - Digital Technologies, from LI, GI, HI, Re-Insurance organizations, Regulators, Insurance Information Bureau, Brokers, Insure-Tech, etc. Working employees from any other organization who are interested in learning 'Advanced Excel'. Basic Excel operational knowledge & skills are assumed.
