PUNE
P826
- ADVANCED EXCEL
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. 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.
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
Participants’
Profile:
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.
Approach:
100% Hands-on training.
Duration:
3 days
Dates:
07.07.2025
- 09.07.2025