Virtual Programme on Advanced Excel
No Fees For Students.
Students have to pre-register on bosactivities.icai.org
Speaker :- CA Vaibhav Doshi
- Smart shortcuts, formatting formula and technique, graphical presentation:
Conditional formatting, Justify, Painter, Paste values shortcut, Sparkline, Excel Maps, Quick analysis tool, 3D references, People graph, protect/lock, fill - series, insert - screenshot, create Emoji and replace with text.
- Data management features (Validation tools, extraction and conversion tools and data modeling tools):
Pivot table with Pivot slicer features and Excel table, recommended Pivots (A.I), Basic Forecasting, Flash Fill
- Advanced formula:
Concat formula instead of Concatenate - Show with Multiple rows and columns, TextJoin technique, use of IFS Formula instead of IF and nested IF formula
- Manage your own portfolio with live stock Market data:
Real time web data reflection into excel with continue refresh option Viz. NSE/BSE stock price. Analyse stock history with various data analysis graph.
- Microsoft 365 features:
- IDEA: Excel will analyze your data and return interesting visuals about it in a task pane. If you are interested in more specific information, you can enter a question in the query box and Excel will use Artificial Intelligence to answer the same.
- XLookup: Are you still using old technique of Vlookup and Hlookup which has various limitations like it cannot search right to left and if lookup value is repeated then it shows the wrong result? Let us learn Xlookup which is very fast and without any limitations.
- Sharing of workbook and co-authoring (Legacy feature of Excel 365and most useful during lockdown):
- Work together on the same excel sheet with two different users at different locations. Both users can work simultaneously in the same excel sheet (without any server).
Registered Participants will get the login details before 1 hour of the programme.
In the case of Group Registrations kindly mention separate email id's for each member.
Kindly mention your correct email id while doing payment to get login details.
For any technical queries kindly contact 8237166006
Please Note: - CPE Hrs. will be credited strictly on individual viewership.
|Event Date||08-11-2020 10:00 am|
|Event End Date||08-11-2020 1:00 pm|
|Registration Start Date||04-11-2020 2:30 pm|
|Cut off date||08-11-2020 8:00 am|
|Individual Price||Rs. 200/- Plus GST|
|CPE Credit Hrs||3 Hrs.|