Western India Regional Council of
The Institute of Chartered Accountants of India

(Set up by an Act of Parliament)

Welcome, Guest

Webinar on Excel Skills For Business

Fees: Members & Students ₹1000                         

Event Details

Event Date 22-06-2020 3:00 pm
Event End Date 27-06-2020 5:00 pm

Topics

Speakers
Date : 22/06/2020

Introduction to Excel and Important Functions - SUMIF, SUMIFS, COUNT, COUNTA, COUNTIF, LARGE, SMALL, CONCATENATE, AND – OR

CA. Giriraj Soni
Date : 23/06/2020
Important Functions in Excel - IF & Nested IF, VLOOKUP, HLOOKUP, Fuzzy LOOKUP, INDEX, MATCH, Formula Auditing

CA. Nagarjun Rao Akula
Date : 25/06/2020
Advanced Filtering, Custom List, Data Validation. Pivot table, charts. - Data Validation, Sorting, Filter, Conditional format, Data visualization, Pivot Table CA. Nagarjun Rao Akula
Date : 26/06/2020 & 27/06/2020
Excel VBA - VBA - Excel Macros, Excel Terms, Excel Objects, User Defined Functions, User Forms, Importing data in Excel from online datasets and live data rendering. Dr. Ajay Pande

 

Coordinator: CA Shweta Jain 9920737198

                       CA. Dharmendra Lunawat 9699544666

 

Note: Once the Registration is confirmed you will receive a Goto webinar link one day before the Program from WIRC to view the Webinar/program. Please note the link should not be shared with anyone. If any queries, email us on wircevents@icai.in

 

Members