Loading Events

« All Events

  • This event has passed.

Workshop on Advance Excel

February 22 @ 10:00 am - 1:00 pm

IT CONNECT COMMITTEE
Chairperson : Maitri Savla
Vice Chairman : Alok Jajodia
Convenors : Murtaza Ghadiali, Anand Paurana
Advisor : Dinesh Tejwani

Description

MS keeps adding new features in MS Excel. Every new version coming in makes Excel more powerful for Analytics, Data Massaging and helps auditors as an audit tool. The following topics will be covered in the workshop:

  • New Formulas in Excel XLookup, Concat, TextJoin, IFS
  • Hidden Tricks of Flash Fill
  • Unpivot using Power Query
  • Handling Dates in Excel Conversion, Formatting, Grouping, Pivot Slicing
  • Array Formulas (if time permits)

Who should Attend

Every professional who uses Excel and wants to enhance his skills

Fees
Members ₹ 600/- + ₹ 108/- (18% GST) = ₹ 708/-
Non-Members ₹ 700/- + ₹ 126/- (18% GST) = ₹ 826/-
Students ₹ 250/- + ₹ 45/- (18% GST) = ₹ 295/-

 

Day & Date : Saturday, 22nd February, 2020
Time : 10:00 a.m. to 1.00 p.m.
Venue : Babubhai Chinai Hall, 2nd Floor IMC, Churchgate, Mumbai-400 020
Speaker : CA Adarsh Madrecha
Topic : Hands-on Learning on Laptops on Advance Features of Excel

Details

Date:
February 22
Time:
10:00 am - 1:00 pm

Venue

Babubhai Chinai Hall, 2nd Floor IMC, Churchgate, Mumbai-400 020
Mumbai, Maharashtra 400020 India