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 CA. Hitesh Bansal





xlsx File
27 KB

Inserting a Blank Column

inserting a blank column after every column...

Posted on 29 July 2013  (Downloads: 381) Info Technology


xlsx File
14 KB

Max and Minimum use with condition

Max and minimum with one condititon...

Posted on 19 July 2013  (Downloads: 936) Info Technology


xlsx File
12 KB

Inserting a Blank Row

How to insert a blank row ...

Posted on 17 July 2013  (Downloads: 646) Info Technology


xlsx File
51 KB

Advance filter Trick

Advance filter trick by changing formating...

Posted on 02 July 2013  (Downloads: 2437) Info Technology


xlsx File
13 KB

Extract Value below the Cell Vlookup Finds

extract Value below the Cell Vlookup Finds...

Posted on 28 June 2013  (Downloads: 1475) Info Technology


xlsx File
12 KB

Arranging of Data in Excel

Arranging of Data With the help of word...

Posted on 28 June 2013  (Downloads: 2895) Info Technology


xlsx File
14 KB

Use of Nested if condition for CA Final Examination Result

Here i used nested if use condition with "And" & "Or" Word....

Posted on 25 June 2013  (Downloads: 1408) Students


xlsx File
14 KB

Use of sumifs with if condition

Use of Sumifs with If condition and one column merged....

Posted on 17 June 2013  (Downloads: 616) Info Technology


xlsx File
150 KB

Pivot Table Setting

we can use pivot table value in formula as normal cell....

Posted on 11 June 2013  (Downloads: 2397) Info Technology


xlsx File
30 KB

Vlookup used in Two dimensions

Use of Vlook up in two dimensions using Match....

Posted on 08 June 2013  (Downloads: 2292) Info Technology


xlsx File
31 KB

Use of VLookup Function in More than one sheet

USE OF VLOOK UP FUNCTION IN MORE THAN ONE SHEET...

Posted on 06 June 2013  (Downloads: 2499) Info Technology


xlsx File
36 KB

Use of Indirect Function for Consolidation

Consolidation of Data using Vlookup or Index and IF Error, Match & Indirect....

Posted on 03 June 2013  (Downloads: 1187) Info Technology


xlsx File
14 KB

Round function of excel with possible aspect

Complete understanding of Round function of Excel....

Posted on 31 May 2013  (Downloads: 1110) Others