Articles by CA ANKUSH AGGARWAL

Prepare for CA Final May 2015

Posted by CA ANKUSH AGGARWAL 27 January 2015 48317 Views

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

Posted by CA ANKUSH AGGARWAL 17 January 2015 25522 Views

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

Posted by CA ANKUSH AGGARWAL 21 October 2019 21966 Views

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

Posted by CA ANKUSH AGGARWAL 10 January 2015 36690 Views

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

Posted by CA ANKUSH AGGARWAL 06 January 2015 20801 Views

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

Posted by CA ANKUSH AGGARWAL 26 December 2014 26869 Views

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

Posted by CA ANKUSH AGGARWAL 15 December 2014 35786 Views

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