Easy Office
LCI Learning

Articles by CA ANKUSH AGGARWAL

avatarView Full Profile

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