Download Files uploaded by Prodip Das
584 KB
Generate for 16 for AY 2016-17
Generate Form 16 (Part A & B) for AY 2016-17 using excel only.No Macro..No Software.. It is very simple and custmoised for 100 employees. Suitable for small organisation....
Posted on 01 August 2016 (Downloads: 1274) Income Tax
1484 KB
Payroll for Small Organisation
This macro based excel file will be useful for small organisation to generate Salary Slip, Salary Report etc.....
Posted on 22 December 2015 (Downloads: 3207) Community & General
698 KB
Fee Collection Report of School in Excel
Maintaining records of Student's Fee collection and tracking the same is a vital work in any school. In case of small size of school often they do not use any software and mainly maintain the records on manually. Therefore to find any information like stu...
Posted on 21 December 2015 (Downloads: 12240) Community & General
22 KB
Trick to Display Worksheet without Macro
An excel file may have different worksheets. Each sheet may have different data, content, object etc.. When there are many worksheets the user can be able to access the worksheets by scrolling and click on the respective sheets. To repeat the same it may ...
Posted on 01 December 2015 (Downloads: 962) Community & General
106 KB
Dynamic Chart in Excel
Learn how to make a simple Dynamic Chart in Excel...
Posted on 13 November 2015 (Downloads: 1795) Community & General
82 KB
Convert numeric value in thousand unit without formula
Without using formula convert numeric value in thousand unit...
Posted on 08 October 2015 (Downloads: 749) Community & General
315 KB
Delete blank rows in same worksheet using Macro
Delete blank rows using Macro in same worksheet...
Posted on 23 September 2015 (Downloads: 646) Community & General
160 KB
How to make Cumulative Sum on certain Criteria?
Suppose you need to track bill wise payment details in excel, which shows Invoice Amt, Cumulative payment outstanding etc.....
Posted on 07 September 2015 (Downloads: 558) Community & General
18 KB
Consolidate Report using OFFSET Function
Generate Consolidate Report within a second using OFFSET function in Excel...
Posted on 02 September 2015 (Downloads: 609) Community & General
325 KB
Pivot Table on Protected Sheet
Customised Pivot Table Report using Macro on Protected Sheet...
Posted on 31 August 2015 (Downloads: 920) Community & General
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
CAclubindia
