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

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

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

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

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

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

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