About this Event

A good working knowledge of Microsoft Excel and its functions is valuable for professionals. Our

informative workshop will focus on Excel features used in analysing financial data.

This course aims to teach Excel’s powerful features to maximise productivity; we will also discuss how to use OpenAI and Microsoft Excel Co-Pilot for day-to-day Excel work.

Course content

·      Going beyond basic Excel formulas

·      Creating stylish and professional spreadsheets

·      Validating data at entry points

·      Getting to grips with your data for insightful analysis

·      Creating charts for maximum impact

·      Doing predictive analytics in Excel

·      Performing what-if analysis

·      Google Sheets and Google Data Studio

·      Excel and AI

o Exploratory and predictive data analytics using ChatGPT

o Getting ChatGPT to build your Excel Financial Models

o How to use ChatGPT to find errors in your Excel models and fine tune them

o Introduction to AI Assistants

o Introduction to Custom GPTs

Speaker

Harsha Wijesooriya

CTO/Co-Founder

Data Studio Labs LLC

What you can gain:

• Expand your knowledge horizons with new tips and techniques.
• List of online resources to widen your skills
• Using Excel as an advanced analytics tool

Dates and times: 

27 July – 8:30am–12:30pm IST via Zoom

28 July – 8:30am–12:30pm IST via Zoom

Ticket fee

CIMA members/students – LKR 15,000

Nonmembers – LKR 18,000

A certificate will be issued based on attendance