Virtual Programme on Advanced Excel

No Fees For Students.

Students have to pre-register on bosactivities.icai.org

Speaker :- CA Vaibhav Doshi

Curriculum 

  • 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 Information

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.
We are no longer accepting registration for this event
Press enter to search

THE INSTITUTE OF CHARTERED ACCOUNTANTS OF INDIA
(Setup by an Act of Parliament)

Pune Branch of WIRC of ICAI
‘ICAI Bhawan’, Plot No. 8,
Near Mahavir Electronics,
Parshwanath Nagar, Bibwewadi,
Pune - 411 037, Maharashtra, India.

Working Hours

Monday to Saturday (Except Public Holidays) 10.00 am to 6.00 pm
(Lunch Break 1.00 pm to 1.30 pm)