- This event has passed.
Workshop on Advance Excel
February 22, 2020 @ 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 |