P848 - ADVANCED GOOGLE SHEETS

Background:

‘Google-Sheets’, as an integral part of Google Workspace, is web-based alternative spreadsheet tool to Microsoft Excel.  Increasing number of insurance organizations are migrating from Microsoft Office 365 to Google Workspace. We can use it from anywhere and by using any device including Android mobiles. It is freely bundled along with Google Drive, Docs, and Slides, Google Meet, etc. under the umbrella suite ‘Google Workspace’. ‘Google Sheets’ has similar features as Excel – so learning it is very easy for Excel users. We can gather data automatically from several sources of different formats. Also, we can install add-ons, and create our own add-ons with custom codes through powerful scripting facility. ‘AppSheet’ is another powerful low-code automation platform to boost productivity. Against this background, this hands-on training has been arranged to impart necessary hands-on skills to officers and managers.

 Contents:

Ø  Essentials of Google Workspace components including Google Sheets

Ø  Google Sheets menu options (in detail)

Ø  Google Sheets functions for Data Analysis (including advanced functions)

Ø  Visualizations & Professional Dashboards Development by using Google Sheets

Ø  Integration with other data sources

Ø  Google Sheets Scripting

Ø  AppSheet

   Participants’ Profile:

This hands-on 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 are also welcome, who are interested in learning ‘Advanced Google Sheets’. Basic operational knowledge & skills of spreadsheets are assumed.

 Approach:

Hands-on training by using Google Sheets, related Best Practices, Executive Briefings, Case-Studies and Experiences Sharing.

 Duration:       3 days

 Dates:             28.10.2024  - 30.10.2024