Guntur Branch of SIRC of ICAI - Advanced Excel for Chartered Accountants

Folks,

On 12th and 13th May 2011, Guntur Branch is organising two day CPE program for Members in ADVANCED EXCEL.

The entire program is coordinated and presented by CA. GOPAL KRISHNA RAJU.

GKR

The invitation of the GUNTUR BRANCH OF SIRC OF ICAI is given below:

GUNTUR BRANCH OF SIRC OF ICAI, GUNTUR


CPE WORK SHOP ON ADVANCED EXCEL

You are cordially invited for two days work shop on Advanced Excel on 12.05.2011and 13.05.2011 of MAY 2011 at our branch premises. The work shop timings start 10 A.M -5 P.M on both days.

Faculty: CA.GOPAL KRISHNA RAJU FCA, AICWA, ACS, PGDOR, PGDFM, DISA

The following are the topics

1. Basics of Spreadsheet- Navigation, Toolbar, Range Names, Formatting, etc.,

2. Financial Functions

3. Data & Time Functions

4. Math Functions

5. Statistical Functions

6. Lookup & Reference Functions

7. Database Functions

8. Text Functions

9. Logical Functions

10. Information Functions

11. Round, Date, logical, Lookup, If, nested If, Count, Subtotal, Array

12. List Management-Sort, Filter ,Advanced Filter, Pivot Table, Import Data, Data Validation

13. Tools-Solver, Goal Seek, Scenario Analysis, protection, sharing

Both days will be dealt with practical illustrations faced by CAs in their day-to-day practice

The subject will be dealt while sitting with the individual computer

Work shop will be held at ITT Lab in our branch premises.

Each work shop is limited to 28 members.

Registration will be done on first com basis.

Delegate Fees: 800/-

Lunch will be served on both days.

CA K.V Brahmum CA A.Leela Krishna Murthy

Branch Chairman Branch Secretary

Advanced Excel for Chartered Accountants - Full day MS Excel workshop handled by GKR - Reflections by participants from Erode Branch of SIRC of ICAI (Date: 22nd April 2011 - Good Friday) : Location: ERODE (Tamilnadu)

@ CA. K. Rajendran:  - This Workshop is very useful to us in day to day office function with Excel. Thank You.

@ CA. R.C.Murukanandam:  - EXCEL WORKSHOP IS EXCELLENT

@ .....................................:  - You handled the workshop in simple, understandable and effective way. This workshop gives me more scope of using excel in my office owrk in effective way.

@ CA. R. Krishna Kumar:  - Workshop of Excel was very useful. Workshop for converting & using text data in Excel may be seperately handled. Thank You for purposeful presentation.

@ CA. M. Sundar Kumar:  - Workshop was Practical.

@ CA. R. Mohanraj (Karur):  - Todays Class was very useful for day to day office work. Please provide some other advanced formulas and calculation for regular office work in the next session.

@...................................:  - Today's seminar is useful to all of us. I am not experienced in Excel. The Class encourage me to learn new things in the System.

@ CA. N. Thangavel:  - The Session was generally interesting. It seems we should have one more day for this topic. Problems like IT Calclation and partners remuneration were really interesting and it would be better it they are included in the backgound material. Thank you for your presentation and background material.

Folks,

Please do post your reflections / suggestions / views.

GKR

Erode Branch of SIRC of ICAI

Folks,

On Saturday, 7th MAY 2011 at ERODE Branch of SIRC of ICAI, I am presenting a Paper on LLP - Taxation Aspects and MDP through LLP along with CS. S. Dhanapal. My co-speaker will deal with Legal aspects of LLP. The link for the program is given below. Kindly participate

News Title : Seminar on LLP


Date From : 2011-05-07

Date To : 2011-05-07

Faculty : CA Gopalakrishna Raju, Sirc Member, Chennai, CS Dhanabal,Chennai

Cpecredit : 3 Hrs

Time : 5.30 pm to 8.45.pm


http://icaierode.org/events.php?start_date=2011-05-07

GKR

CS Final - Advanced Tax Laws and Practice - Latest Amendments, Circulars and Notification - Relevant for JUNE 2011 and DEC 2011 Exams

Folks,

Herewith I have attached PDF format of Direct and Indirect Taxes Latest Amendments - Applicable for JUNE 2011 and DEC 2011 exams.

The Amendment is with respect to Finance Act 2010 relevant for AY 2011-12.

The past trend in the exams indicate that latest amendments, circulars, notifications are most sought after questions. Happy Reading.

Latest Amendments in Direct and Indirect Taxes:
https://sites.google.com/site/gkr8164/Home/LatestAmendments_final_dt2010.pdf?attredirects=0&d=1

Latest Notifications and Circulars in Direct and Indirect Taxes:
https://sites.google.com/site/gkr8164/Home/LatestNotificationsCirculars_final.pdf?attredirects=0&d=1

GKR

CS Final - Advanced Tax Laws and Practice - Rich contents for Exam Review

Folks,

Herewith I have attached rich contents in PDF from ICAI-BOS portal. The contents relevant for CS Final are listed below:

The syllabus consists of 30 marks on Direct Taxation and 20 marks on International Taxation. The following chapters will suffice due coverage on International Taxation:

Double Taxation Relief:
https://sites.google.com/site/gkr8164/Home/18891sm_dtl_finalnew_cp15_DTAA.pdf?attredirects=0&d=1

Transfer Pricing:
https://sites.google.com/site/gkr8164/Home/18892sm_dtl_finalnew_cp16_TransferPricing.pdf?attredirects=0&d=1

Foreign Companies - Taxation Aspects and FEMA Aspects:
https://sites.google.com/site/gkr8164/Home/WRITE_UP_ON_FOREIGN_COMPANIES_IN_INDIA.pdf?attredirects=0&d=1

Advance Ruling:
https://sites.google.com/site/gkr8164/Home/18899sm_dtl_finalnew_cp23_AdvanceRulings.pdf?attredirects=0&d=1

Happy Reading...

Please do post your suggestions / comments to gkr@icai.org or leave it in the comments space below.

GKR