« Continuing Prof. Edu. » Open DEMAT Account in 24 hrs  Seminar on Key Changes / Amendments relevant for filing ITRs of AY 2024-25   Seminar on Audit Trail, Critical issues in sec 43B(h) & PMLA  Seminar on Audit Trail, Critical issues in sec 43B(h) & PMLA  Seminar on Standards on Auditing & Different Dimensions to Practice and Mastering Project Financials  Full day Seminar on financial statement of Non-corporate entities and consolidation of Financial statements  Seminar on Interplay between Income Tax and GST in Real Estate Transactions  Seminar on Audit Trail under Companies Act and Internal Audit and Audit trail A Perspective  Two Days Residential Seminar on GST Demand & Professional Development with Stress Management  Seminar on Year end compliance check for 23-24, wrt Income tax, TDS, GST & PT  Full day Seminar on financial statement of Non-corporate entities and consolidation of Financial statements  Seminar on Bank Branch Audit Q & A Session 3 «  TAXATION ISSUES... Fraud Detection & Forensic Accounting... » WORKSHOP ON POWER OF EXCEL / ACESS AND VB MACRO December, 18th 2009 Events Details Event Topic WORKSHOP ON POWER OF EXCEL / ACESS AND VB MACRO Date 20-12-2009 Event Venue K.V.PATEL HALL CPE Hrs 20 Capacity of Venue 50 BG Material Send No Programme Structure Note: Time should be entered in 24 hrs format Date Description From To Faculty Chairman CPE Hrs Day 1 20-12-2009 ADVANCE FUNCTION OF EXCELL i.e V-LOOKUP, PIVOT TABLE, CONDITIONAL FORMATTING, FORMULA AUDITING TOOLS 16:00 18:00 CA. NARESH BALWANI, AHMEDABAD CA. NITIN PATHAK, I.T.COMM. 02:00:00 20-12-2009 ADVANCE FUNCTION OF EXCELL i.e V-LOOKUP, PIVOT TABLE, CONDITIONAL FORMATTING, FORMULA AUDITING TOOLS 18:15 20:15 CA. NARESH BALWANI, AHMEDABAD CA. NITIN PATHAK, I.T.COMM. 02:00:00   Total CPE Hours: 20 Tea 18:00 To 18:15 (00:15:00)   Day 2 21-12-2009 ADVANCE FUNCTIONS OF EXCEL i.e AUDITING THROUGH IF CONDITIONS, DATA FILTER AND IMPORTANT SHORT CUTS USEFUL FOR DATA ANALYSIS FOR EFFICIENT USE OF EXCEL 16:00 18:00 CA.PATHIK SHAH, AHMEDABAD CA. NITIN PATHAK, I.T.COMM. 02:00:00 21-12-2009 ADVANCE FUNCTIONS OF EXCEL i.e AUDITING THROUGH IF CONDITIONS, DATA FILTER AND IMPORTANT SHORT CUTS USEFUL FOR DATA ANALYSIS FOR EFFICIENT USE OF EXCEL 18:15 20:15 CA.PATHIK SHAH, AHMEDABAD CA. NITIN PATHAK, I.T.COMM. 02:00:00   Total CPE Hours: 20 Tea 18:00 To 18:15 (00:15:00)   Day 3 22-12-2009 VISUAL BASIC AND MACRO AND ITS USE IN DATA ANALYSIS PURPOSE AS WELL AS DAY TO DAY PRACTICE 16:00 18:00 CA. VISHAL LANGALIA, AHMEDABAD CA. NITIN PATHAK, I.T.COMM. 02:00:00 22-12-2009 VISUAL BASIC AND MACRO AND ITS USE IN DATA ANALYSIS PURPOSE AS WELL AS DAY TO DAY PRACTICE 18:15 20:15 CA. VISHAL LANGALIA, AHMEDABAD CA. NITIN PATHAK, I.T.COMM. 02:00:00   Total CPE Hours: 20 Tea 18:00 To 18:15 (00:15:00)   Day 4 23-12-2009 ADVANCE FUNCTIONS OF EXCEL i.e GOAL SEEK, SCENARIO SUBTOTAL, IF AND SUM IF CONDITIONS ETC. 16:00 18:00 CA.NARESH BALWANI, AHMEDABAD CA. NITIN PATHAK, I.T.COMM. 02:00:00 23-12-2009 ADVANCE FUNCTIONS OF EXCEL i.e GOAL SEEK, SCENARIO SUBTOTAL, IF AND SUM IF CONDITIONS ETC. 18:15 20:15 CA.NARESH BALWANI, AHMEDABAD CA. NITIN PATHAK, I.T.COMM. 02:00:00   Total CPE Hours: 20 Tea 18:00 To 18:15 (00:15:00)   Day 5 24-12-2009 BASICS OF MICROSOFT ACCESS AND ITS IMPORTANCE 16:00 18:00 CA. PATHIK SHAH, AHMEDABAD CA. NITIN PATHAK, I.T.COMM. 02:00:00 24-12-2009 BASICS OF MICROSOFT ACCESS AND ITS IMPORTANCE 18:15 20:15 CA. PATHIK SHAH, AHMEDABAD CA. NITIN PATHAK, I.T.COMM. 02:00:00   Total CPE Hours: 20 Tea 18:00 To 18:15 (00:15:00)