|
Topic
|
Speaker
|
|
TOOLS TO BE PRACTICED PRACTICALLY WITH TRAINER:
19th July 2022 : 03.00 pm to 05.00 pm
|
|
Pre-Cursor to Excel Knowledge & Usage, Customize Ms Office Ribbon, Customize Workbook, Different extensions for Workbook as per Applicability, Understand Formula vis-à-vis Function, Function Description, Syntax & Optional Arguments,Create Template Book (with Case Study)
|
Prof. Asif Rampurawala
|
| 20th July 2022 : 03.00 pm to 05.00 pm |
| Multiple Sorts, Custom Filter, Subtotal, Templates with Icon Sets, Quick Performance, Flash Fill Tool with Simple & Complex Data, Shortcuts Between Multiple Books, Window Usage with Multiple View Options, Protect Sheet, Protect Workbook, Unlock Cells, Hide Formulas to Protect Sheet (Case Study) |
Ms. Sanjeela Sagar
|
| 21st July 2022 : 03.00 pm to 05.00 pm |
| Goal Seek, Data Table, Scenario Manager, Solver Tool, Consolidation, 3D Formulas (Case Study) |
CA. Jyoti Malkani
|
| 22nd July 2022 : 03.00 pm to 05.00 pm |
| Match, Index (Single & Multiple Area Coverage), Index & Match (Combating Vlookup), XLookup, Indirect, Charts with appropriate Choice (Case Study) |
Dr. Ajay Pande
|
| 23rd July 2022 : 03.00 pm to 05.00 pm |
| Pivot Table, Pivot Charts, Slicers, Sparklines, DashBoard, DrillDown, DrillUp Data, Macros, Customize WorkSheets to Print Options, Customize Report (Case Study) |
CA. Abhay Gadiya
|
WIRC
Western India Regional Council