P826-ADVANCED
EXCEL (NON-LIFE)
Excel is one of
the most widely used spreadsheet software in Insurance industry across
departments. Microsoft has been continuously enhancing the features of Excel.
Advanced Pivot Table, Advanced Charting & Visualizations, Advanced
Functions, VBA Macros, Power Analytics features like Power Query - Power Pivot -
Power View - Power Map, etc. in MS Excel are getting increasing popularity among
Data Analysts and 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 hand-on training has been
arranged.
Contents:
Ø
Advanced
Excel: Advanced Pivot Table, Advanced Charts & Visualizations, Power Map,
Advanced Functions, Array Functions,
Ø
VBA Macros
Ø
Power Query,
Power Pivot, Power View Using Excel
Ø
Professional
Dashboards Development
Ø
Data Mining
& Machine Learning by using Excel: Regression Techniques, logistic
regression, k-nearest neighbors, naïve Bayes classification, decision trees,
cross-validation, artificial neural network, k-means clustering, discriminant
analysis, association analysis, text mining
Ø
Excel
integration with RDBMS: Oracle / SQL-Server
Ø
Excel
integration with Web
Ø
Hands-on
Exercises, Project
Participants’ Profile:
This training-course is open to entire General Insurance 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 GI, HI, Re-Insurance
organizations, Regulators, Insurance Information Bureau, Brokers, Insure-Tech,
etc. Working employees from any other organization interested in learning
‘Advanced Excel’. Basic Excel operational knowledge & skills are assumed.
Approach:
Hands-on training by using Excel, Excel Best Practices, Executive
Briefings, Case-Studies and Experiences Sharing.
Duration: 5 days
Dates:
06.02.2023 - 10.02.2023