# Articles by CA ANKUSH AGGARWAL

#### Prepare for CA Final May 2015

##### CA ANKUSH AGGARWAL    27 January 2015 at 11:16

Greetings to all CAclubians and guest readers!!! Friends!! I recently qualified my Chartered accountancy. I feel like I should share some tips with all my friends who are appearing for May 2015 exams. I am not telling you here about any study plans o

Posted in Students  66 comments |   48066 Views

#### Excellence in Excel Series - Part IV Macros

##### CA ANKUSH AGGARWAL    17 January 2015 at 12:38

EXCELLENCE IN EXCEL SERIES PART IV-MACROS Hey Friends,I am back with another article on most easy and yet unpopular excel function-macros.Many of us as soons as hear the word Macros ,Only one thing comes into mind-Difficult.But friends

Posted in Info Technology  13 comments |   25173 Views

#### Preface to IFRS

##### CA ANKUSH AGGARWAL    17 January 2015 at 12:38

PREFACE TO INTERNATIONAL FINANCIAL REPORTING STANDARDS PURPOSE OF ISSUING PREFACE Setting out objectives and due process of the IASB Explain the scope, authority and timing of application of IFRS Preface has been amended from time t

Posted in Accounts  3 comments |   20091 Views

#### Excellence in Excel - Part III

##### CA ANKUSH AGGARWAL    10 January 2015 at 11:13

How to use VLOOKUP in ExcelOn many request to write an article on VLOOKUP,I tried my best to fulfill the requests. VLOOKUP is a powerful Excel function that allows you to look for a specified value in one column of data in

Posted in Info Technology  17 comments |   36360 Views

#### Excellence in Excel Series- Part II

##### CA ANKUSH AGGARWAL    06 January 2015 at 10:36

EXCELLENCE IN EXCEL-PART 2-USING SUMIF FUNCIONSUMIF functionIn this function SUMIF, you add the numbers present within a criteria.The SUMIF FunctionThe SUMIF function needs 3 parameters. The range of criteria The crit

Posted in Info Technology  16 comments |   20340 Views

#### Excellence in Excel Series- Part 1 using subtotals

##### CA ANKUSH AGGARWAL    26 December 2014 at 10:56

STEP-1: Sort the list on the field/s for which you want subtotals inserted using multi level sorting Select the whole data including headers using ctrl+A ,click on Data and select Sort. Use Add level option to enable multi level sortin

Posted in Students  4 comments |   26583 Views

#### NFRA-Section 132 of Companies act 2013

##### CA ANKUSH AGGARWAL    15 December 2014 at 10:25

INTRODUCTION: The concept of having a body such as National Financial Reporting Authority is not new as such. The Institute of Chartered Accountants of India already has many of these powers. As per section 211(3C) of Companies act 1956, every balan

Posted in LAW  3 comments |   34995 Views

CCI Articles

ï»¿