Annual Sports Day

Dear Member,

We are pleased to inform you that the Annual Sports Day is scheduled on 22nd & 23rd December 2012 the details of which are as under.

Annual Sports Day

Cricket, Chess, Badminton & Table Tennis Matches for Members & Students.

Date -              December 22 & 23, 2012

Time -               08.30 a.m. onwards

Contribution - Rs. 100/- per game (students Rs.50/- per game)

Cricket matches will be held on 22nd & 23rd December. 

The number of teams for cricket is restricted & teams enrolling earlier will be given preference. 

Indoor games will be held on 22nd December.

All the interested members & students are requested to enrol their names/teams before 20 December 2012 at branch office.

Thanking you,

Yours faithfully,

CA Satish S Dakare

Secretary

Seminar on MVAT Audit

CA. Umesh Sharma - Faculty

Material
Principal issues in MVAT Audit Click Here
Practical issues in MVAT Audit Click Here

Mahabaleshwar RRC

Material of CA Dilip Phadke 
Issues in VAT Audit - Click here
Notes on Taxation of Builders - Click Here

Workshop on Advanced Excel

Dates: 1, 2, 9, 15 & 16 December 2012                         CPE: 30 hrs

Venue: SIBER, Univeristy Road, Kolhapur                                

Fees (Incl lunch): Rs. 3,000/- (for members)

Workshop 1 ( Saturday,1^st December 2012)

Objective

§  Learn New features of Excel 2010

§  Acquaintance with Excel Interface

§  Basic Functions

Overview of the Basics

·         Introduction with new Excel interface

·         Default settings of Excel

·         Introduction to Ribbon

·         Quick Access Toolbar

·         Contextual Tabs

·         Ribbon Customization

Formula and Functions

·         Text Functions

·         Cell Referencing

·         Logical Functions

Workshop 2 (Sunday, 2^nd December 2012)

Objective

§  Validating data

§  Advanced Functions

Formula and Functions

·         Data Validation

·         Lookup Functions (Vlookup, Hlookup, Index, Match etc.)

·         Sumif, Countif, Sumproduct and Averageif

·         Statistical and Financial Functions

Workshop 3 (Sunday, 9^th December 2012)

Objective

§  Protect Sheets and Workbook

§  Sorting and Filtering data

§  Working with tables

Sharing and Protection

·         Sharing and Protection

·         Introduction to Tables

Sorting and Filtering

·         Single and Multiple level Sorting, Custom Sorting

·         Advance Filters

·         Single and Multiple level Subtotals including grouping

Working with styles

·         Conditional Formatting

Workshop 4 (Saturday 15^th December 2012)

Objective

§  Pivot tables

§  Consolidation

§  Analysis

Pivot tables

·         Pivot Table

·         Power Pivot

Consolidation

·         Consolidation

What if Analysis

·         What if Analysis and Scenario Manager

Workshop 5 (Sunday, 16^th December 2012)

Objective

§  Presenting data visually

§  Automating tasks with macros

Presenting data

·         Charts and Dashboards

§  Column Chart 2D and 3D

§  Bar Charts

§  Stacked Column Charts

§  Line Chart

§  Line and Column Chart (Limitation of primary axis)

§  Pie Chart

§  Limitations of Pie Chart (Doughnut Chart)

§  Pie Chart with developer tools

§  Thermometer Chart

§  Scroll Chart

Macros

·         Macro (Recording, Editing and Basic Formulas)

§  Recording Macro

§  Limitation of recording macro

§  Recording Macro with Relative reference

§  Editing Macro

§  Executing Macro in different ways

§  Introduction to VBA window

§  Creating Basic Functions in VBA

RRC at Mahabaleshwar

RESIDENTIAL REFRESHER CONFERENCE (RRC) 2012
HOSTED BY :- PUNE BRANCH OF WIRC OF ICAI JOINTLY WITH :- NAGPUR, PIMPRI CHINCHWAD, KOLHAPUR BRANCHES & SATARA CHAPTER OF WIRC OF ICAI  ON 2ND, 3RD & 4TH NOVEMBER, 2012
TENTATIVE TABLE PLAN
	CPE: 15 Hrs	Fees: Rs. 4500/-
DAY - 1 (2ND NOV, 12)
REGISTRATION & BREAKFAST
INAUGURAL SESSION			30 MINS
SR. NO.	TOPIC	SPEAKER	TIME DURATION
1ST TECHNICAL SESSION
1	Recent Landmark Judgements	CA. Mandar Vaidya	1.30 HRS.
LUNCH BREAK
2ND TECHNICAL SESSION
2	Service Tax - Negative List & Reverse Charge	CA. Naresh Sheth	2 Hrs.
TEA BREAK
3RD TECHNICAL SESSION
3	How to make practice remunerative - Panel Discussion	CA. Atul Bheda, Group Leader	1.30 HRS.
DAY - 2 (3RD NOV, 12)
BREAKFAST
4TH TECHNICAL SESSION
4	Automation & CA Office	CA. Pankaj Deshpande	1.30 HRS.
5TH TECHNICAL SESSION
5	Company Amendment Bill	CS. Vinayak Khanvalkar, Past President, ICSI	1.30 HRS.
LUNCH BREAK
6TH TECHNICAL SESSION
6	Domestic Tranfer Pricing / Internatioal Transfer Pricing	CA. Mahesh Sarda	1.30 HRS.
7TH TECHNICAL SESSION
7	Mock Tribunal	CA. Neelesh Khandelwal	1.30 HRS.
		CA. C. D. Upasani
		CA. Singh
		CA. C. V. Chitale
DAY - 3 (4TH NOV, 12)
BREAKFAST
8TH TECHNICAL SESSION
8	Scrutiny Asst. & Appeals	CA. Jayant Gokhale	1.30 HRS.
9TH TECHNICAL SESSION
9	Vat Audit	CA. Dilip Phadke	1.30 HRS.
LUNCH BREAK
10TH TECHNICAL SESSION
10	Penalties under Income Tax Act	Eminent Faculty	1.00 HRS.