CASE STUDY: Counting instances of Duplicate Invoice Nos. APPLICATION AREAS: Vendor Payment, Account Credits SOLUTION: =COUNTIFS() EXAMPLE: Step 1: Write =COUNTIFS( Step 2: Choose range of list. E.g. A4:A13 Step 3: Press
A company secretarys role in a company is very important. Apart from acting as a link between the board of the organization and the various stakeholders, government and other regulatory authorities, he/she also carry out all the duties like m
TIPS FOR STUDENTS TAKING EXAM: DOs and DONTs: BEFORE EXAM:
We all have a set of friends, family members, acquaintances, familiar places, known institutions, etc around which we have lived our lives till this moment. But are you sure that is good for your personal
Knowledge is power- Abdul Kalam With great power come great responsibility- Ben Parker(Uncle of SpidermanJ, remember that scene in the car?) Right from our CPT days, we have been taught the meaning and importance of Econo
Case Study: Indicate Automatic Status based on whether Actual Production exceeds/equals/trails the Budgeted Production. Sample provided in Picture 1. Application Areas: Budget vs. Actual Comparison, Variance Analysis Techniques req
A MAJOR STEP BY FINANCE MINISTER AFTER BUDGET 2013 * Indian Finance Minister Mr P Chidambaram has taken a big step towards assessee in deafaults as soon as budget came out. * After Budget, revenue department used to send show cause notices to
A bad plan is better than having no plan at all Mikhail Tchigorin Well, Im student of Chartered Accountancy at Mumbai. I recently cleared the CA-IPCC (November 2012). Id like to share with you guys about an impor
Are you ready for IPCC Taxation Exam-May 2013? May 2013 IPCC exams are approaching nearer. In the light of several amendments and changes brought in by the Finance Act, 2012 and paradigm shift in Service tax law based on Negative List (i.e. selectiv
In this failure-hating world, the idea of not being successful can be terrifying. After all, failure brings shame, disgrace and negativity it is to be avoided at all costs. A funny thing about life is that when you really fear something, i
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CAclubindia
