Thursday, 19 Nov, 7:00 PM – 9:00 PM

Friday, 20 Nov, 7:00 PM – 9:00 PM

Saturday, 21 Nov, 7:00 PM – 9:00 PM

Sunday, 22 Nov, 7:00 PM – 9:00 PM

AGENDA / DISCUSSION TOPICS

Day 1 – Various Lookup Functions In Excel Vlookup, Hlookup, Xlookup, Vlookupwith match (Advanced Dynamic Vlookup), Fuzzy Lookup How to prepare financials from tally in clicks. Free Automated tool with 1 month validity will be shared.

Day 2 – Macro (Automation In Excel) How to record macro (without knowledge of coding), How to Edit Macro, How to do debugging, How to create Button to run macro, Dynamic Selection. How to do 2B reconciliation in excel in one click. Free Automated tool with 3 months validity will be shared.

Day 3 – Jugalbandi between Tally & Excel Discover the fresh reports and updates of TallyPrime with power of Excel.

Day 4- Excel 365: Legacy features of Excel – XLOOKUP, IDEA, Dynamic Array Functions, Real time web data reflection into excel with continue refresh option Viz. NSE/BSE stock price, Sharing and Co-authoring of Excel worksheets

PARTICIPANTS

  •   CA. Punit Mehta
  •   CA. Amit Jain
  •   CA. Vaibhav Doshi

Webinar/Workshop organized by: Connect Easy

iSeekh Disclaimer

We list events as per details provided by the organizer. We are NOT responsible or liable in case of any non-availability or deficiency of the service provided, including any paid event/services.