PUNE
P826
- ADVANCED EXCEL (NON-LIFE)
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 the 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 Excel: Advanced Pivot Table, Advanced Charts &
Visualizations, Power Map, Advanced Functions, Array Functions,
§
Professional Dashboards Development
§
Data Mining for Predictive Analytics
§
Excel Macros
§
Power Query & Power Pivot Using Excel
§
Excel integration with RDBMS: Oracle / SQL-Server
§
Excel integration with Web: Web-based Excel
§ Hands-on Exercises
Participants’ Profile:
This training-course is open to all Insurance organizations (GI, HI, LI, RI) and other related organizations (like IT, Insure-Tech, etc.) from within India as well as from other countries. Officers / Executives / Managers or higher management from IT – AI – Digital Technologies – Analytics, Marketing, Sales, Services, Claims, Financial Intelligence, Actuarial areas, 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:
Hands-on training by using Advanced Excel, Excel Best Practices, Executive Briefings, Case-Studies and Experiences Sharing.
Duration: 3 days
Dates:
I.
15.04.2024 -
17.04.2024
II. 02.09.2024 - 04.09.2024