Monday, May 9, 2011

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

1 comment:

karthik m k said...

if u put those files on the blog it will be very helpful for us