GST Course
CA Final Online Classes
CA Classes

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

Download Files uploaded by Prodip Das





xls File
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: 1237) Income Tax


xls File
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: 3018) Others


xlsx File
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: 11009) Others


xlsx File
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: 946) Others


xlsx File
106 KB

Dynamic Chart in Excel

Learn how to make a simple Dynamic Chart in Excel...

Posted on 13 November 2015  (Downloads: 1785) Others


xlsx File
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: 744) Others


pdf File
315 KB

Delete blank rows in same worksheet using Macro

Delete blank rows using Macro in same worksheet...

Posted on 23 September 2015  (Downloads: 639) Others


xlsx File
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: 544) Others


xlsx File
18 KB

Consolidate Report using OFFSET Function

Generate Consolidate Report within a second using OFFSET function in Excel...

Posted on 02 September 2015  (Downloads: 602) Others


pdf File
325 KB

Pivot Table on Protected Sheet

Customised Pivot Table Report using Macro on Protected Sheet...

Posted on 31 August 2015  (Downloads: 910) Others