My excel files at one place - very very useful

3436 views 15 replies

 

CA CS Prakash Somani (A helpin's Files

Displaying Files 1 - 10 of 285 in 29 pages 

Unlinking Pivot From Source Data Preserving Formatting

My Best ever file without macro... powerful and most used function simplefied...
 

Category: Others | 844 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
30 KBRetirement cum Admission Partnership Deed

RETIREMENT CUM ADMISSION PARTNERSHIP DEED...



Category: Income Tax | 400 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
40 KBICAI Elections - Information for those who are away from their Addresses 

ICAI ELECTIONS-INFORMATION FOR THOSE WHO ARE AWAY FROM THEIR ADDRESSES...



Category: Others | 98 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
34 KBAbsolutely Fantastic Slideshow - Ever Seen

Absolutely Fantastic Slideshow - Ever Seen these type of Slideshow Before...



Category: Others | 3131 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
1455 KBDelhi High Court Decision on Refund of TDS

Delhi High Court Decision on Refund of TDS...



Category: Income Tax | 453 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
5811 KBLecture how useful in Teaching

LECTURE HOW USEFUL IN TEACHING...



Category: Others | 281 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
14 KBRoot Cause Analysis

Root Cause Analysis.. Identify the origin of a problem...



Category: Others | 185 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
21 KBHow to Manage large Data in Excel

How to Manage large Data in Excel...



Category: Info Technology | 1584 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
258 KBHow to insert Row Automatically in excel - By Formula Macro

How to insert Row Automatically in excel - By Formula or Macro...



Category: Info Technology | 230 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
15 KBCMA Data Format - Very Useful 

CMA DATA FORMAT - VERY USEFUL...



Category: Accounts | 2384 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
299 KB

 
Replies (15)

 

CA CS Prakash Somani (A helpin's Files

Displaying Files 10 - 20 of 285 in 29 pages 

Magic with colors in excel by excel formula - Very useful

Magic with colors in excel by excel formula - Very useful for Excel 2007...
 

Category: Others | 4541 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
54 KBMany Congratulations to CCI for achieving one more milestone

Many Congratulations to CCI for achieving one more milestone...



Category: Students | 1354 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
15 KBRole of CPE Committee of ICAI

Role of CPE Committee of ICAI...



Category: Others | 137 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
32 KBCertificate Course on Enterprise Risk Management

Certificate Course on Enterprise Risk Management...



Category: Students | 220 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
15 KBA Brief on Reverse Mortgage

A Brief on Reverse Mortgage...



Category: Others | 286 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
12 KBImpact of Globalisation on India

Impact of Globalisation on India...



Category: Others | 269 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
14 KBWhat Is An Emerging Market

A Simple understanding on What Is An Emerging Market?...



Category: Others | 224 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
13 KBIncome tax on House Property - Few FAQ For Simple Understand

Income tax on House Property - Few FAQ For Simple Understanding...



Category: Income Tax | 677 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
17 KBBenefits & tax implications of purchasing a house

BENEFITS & TAX IMPLICATIONS OF PURCHASING A HOUSE...



Category: Income Tax | 961 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
14 KBGift from Non Resident Indian (NRI) to Resident Indian

Gift from Non Resident Indian (NRI) to Resident Indian - A Simple & Useful Guide....



Category: Income Tax | 630 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
15 KB

 

 

CA CS Prakash Somani (A helpin's Files

Displaying Files 20 - 30 of 285 in 29 pages 

Concatenate - A Simple yet very useful guide

I am sure you must not have seen simpler then this guide before on concatenate function. Also one more function which is substitute if concatenate....
 

Category: Students | 2257 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
17 KBVedic mantra to achieve Success in Job Interviews

Vedic mantra to achieve Success in Job Interviews. This i feel will boost your confidance too....



Category: Others | 1741 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
17 KBIncome Tax Deadlines is approaching 

Income Tax Deadlines is approching...



Category: Income Tax | 326 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
81 KBVery fine difference between Jan Lokpal & Govt Lokpal

This is why the govt dont want lokpal to be passed......



Category: Others | 458 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
19 KBPenalty - late filing of it return FY 2011-12

PENALTY - LATE FILING OF IT RETURN FY 2011-12 - A Brief Guide...



Category: Income Tax | 1140 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
16 KBCBDT Circuler on Issuance of TDS Certificate in Form 16A

CBDT Circuler on Issuance of TDS Certificate in Form 16ACBDT Circuler on Issuance of TDS Certificate in Form 16A...



Category: Income Tax | 1318 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
98 KBLevy of vat on sale of flat during construction of building

Levy of vat on sale of flat during construction of building...



Category: VAT | 783 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
185 KBValidity of CA Registration CPT, IPCC, Final

Validity of CA Registration CPT, IPCC, Final......



Category: Students | 2205 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
35 KBDatedif Formula in Excel - Very useful

Datedif Formula in Excel - Very useful...



Category: Students | 4485 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
40 KBWhen to go for Bankruptcy?

When to go for Bankruptcy ? An useful guide covers disadvantages for filing for bankruptcy......



Category: Others | 337 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
15 KB

 

 

CA CS Prakash Somani (A helpin's Files

Displaying Files 30 - 40 of 285 in 29 pages 

An Simple & very useful understanding about Growth Rate (GDP)

An Simple & very useful understanding about Growth Rate (GDP)...
 

Category: Income Tax | 730 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
13 KBService tax due dates

Service tax due dates....



Category: Service Tax | 856 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
13 KBProcedure for Registration under Service Tax

Procedure for Registration under Service Tax...



Category: Service Tax | 661 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
16 KBTax on Salary Calculator - FY 2011-2012 (AY 2012-2013)

Tax on Salary Calculator - FY 2011-2012 (AY 2012-2013) - Very useful & userfriendly...



Category: Income Tax | 2103 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
81 KBEnrollment as Member - Complete Guide

Enrolment as Member - Complete Guide...



Category: Others | 541 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
427 KBVery useful writeup on Revised Schedule VI

Revised Schedule VI.pdf by CA shriram Kshrinamurthi...



Category: Income Tax | 3035 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
817 KBStudents General Study Tips

Students General Study Tips.doc...



Category: Students | 1267 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
30 KBUseful Salary related details

Useful Salary Details...



Category: Income Tax | 2458 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
502 KBLatest tax on Salary Calculator - FY 2011-12 (AY 2012-13)

Latest tax on Salary Calculator - FY 2011-12 (AY 2012-13).xls...



Category: Income Tax | 5096 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
80 KBGet Pivot Data in Formula

Get Pivot Data in Formula. very useful function to use formula and pivot together...



Category: Students | 4254 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
36 KB

 
Thanku for sharing Sir.smile.

CA CS Prakash Somani (A helpin's Files

Displaying Files 40 - 50 of 285 in 29 pages 

Revision Tips in Exams

REVISION TIPS IN EXAMS...
 

Category: Exams | 1477 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
13 KBHow to Edit word file in MS Excel

How to Edit word file in MS Excel...



Category: Info Technology | 3162 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
48 KBGeneral Tips for Students

General Tips for Students...



Category: Students | 430 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
29 KBEXAM, STUDIES AND MOTIVATION

EXAM, STUDIES AND MOTIVATION...



Category: Students | 1462 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
32 KBInternational GAAP® 2011 - India edition now available.

International GAAP® 2011 - India edition now available....



Category: Accounts | 790 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
1534 KBBudget Expectations 2011

Budget Expectations 2011...



Category: Others | 83 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
29 KBHow to use track changes in excel

How to use track changes in excel...



Category: Info Technology | 1019 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
49 KBFAQs on training of articled assistant outside India

FAQs on training of articled assistant outside India...



Category: Students | 87 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
45 KBForm for self declaration in lieu of Annual Report for Impar

Form for self declaration in lieu of Annual Report for Imparting Industrial Training outside India...



Category: Career | 40 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
26 KBGoods and Service tax - Diary

Goods and Service tax - Diary...



Category: Income Tax | 912 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
560 KB

 

 

CA CS Prakash Somani (A helpin's Files

Displaying Files 50 - 60 of 285 in 29 pages 

The IT Strategy for GST

The IT Strategy for GST...
 

Category: Service Tax | 125 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
506 KBDEDICATED TO ALL MY FRIENDS WHO WORK IN IT SECTOR!!!

DEDICATED TO ALL MY FRIENDS WHO WORK IN IT SECTOR!!!...



Category: Info Technology | 551 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
33 KBMy Expectation from Budget

MY EXPECTATION FROM BUDGET...



Category: Others | 58 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
27 KBHow to make use of e-sahaayaata 

How to make use of e-sahaayaata ...



Category: Students | 242 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
2802 KBBudget Expectations

Budget Expectations...



Category: Others | 301 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
31 KBExcel - Calculated Field Guide in Pivot table

It shows how to use formula along with pivot table.. very useful function which is not very well known by many. you will like it :) let me know if you want more on excel. p_somani @ yahoo.co.in...



Category: Info Technology | 2504 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
8 KBHow to Enroll for CA - registration process in Brief

How to Enroll for CA - registration process...



Category: Students | 677 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
14 KBBudgeting

BUDGETING...



Category: Accounts | 1004 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
29 KBList of Strengths and Weaknesses

List of Strengths and Weaknesses...



Category: Others | 1238 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
28 KBRevenue_Management

Revenue_Management...



Category: Income Tax | 490 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
207 KB

 

CA CS Prakash Somani (A helpin's Files

Displaying Files 60 - 70 of 285 in 29 pages 

All About Invoice - Scope & Purpose

ALL ABOUT INVOICE - SCOPE & PURPOSE...
 

Category: Accounts | 672 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
24 KBCash Management Process

CASH MANAGEMENT PROCESS...



Category: Others | 739 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
25 KBCash Flow Management

Cash Flow Management...



Category: Others | 934 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
28 KBDeduction for rent paid -Section 80GG

Deduction for rent paid – Section 80GG...



Category: Income Tax | 636 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
29 KBThe Ways Managers can Improve Morale

THE WAYS MANAGERS CAN IMPROVE MORALE...



Category: Career | 637 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
57 KBIferror Formula - How to use

Iferror Formula - How to use...



Category: Info Technology | 992 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
36 KBChecklist-for-Partnership-firm-Registration

Checklist-for-Partnership-firm-Registration...



Category: Corporate Law | 1268 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
35 KBLatest Tax on Salary Calculator - FY 2010-2011 (AY 11-12)

Latest Tax on Salary Calculator - FY 2010-2011 (AY 11-12)...



Category: Income Tax | 3896 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
79 KBDifference - IPCC and PCC

Difference - IPCC and PCC...



Category: Students | 552 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
30 KBSalary related files... very useful for HR

Salary related files... very useful for HR...



Category: Others | 2257 downloads | by CA CS Prakash Somani (A helpin 

click here to download the files
564 KB

 

Thank you Sir for sharing and consolidating and compilying all at one place....Keep sharing.

Thnx vandana ...

thanks.

very much useful files! thanks.

Thnx ajay & Surya...
very nice sir.... thanks for sharing....


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register