What are some Microsoft Excel tips for CA students?

Learn the following formulas/functions which you must be mastered and also it will be useful in day to day work:

1.     Vlookup / Hlookup

2.     Pivot Table

3.     Excel Charts

4.     Sum / Count / Average

5.     Sumifs / Countifs / Averageifs

6.     Subtotal

7.     Proper / Max / Min

8.     IF Statements

9.     CONCATENATE

10.  CONDITIONAL FORMATTING

11.  Index + Match

12.  Name Manager

13.  Flash fill

As far as I know, the above formulas are a must and will be helpful in articles as well as after qualifying.

Thank you.

Latest Blogs




Top Reviews

Introduction to Statistics for CA Foundation

Introduction to Statistics for CA Foundation Business Mathematics, Logical Reasoning and Statistics is designed as per latest CA Foundation syllabus for Paper 3 to provide a firm grounding in the principles, techniques and practice. The book adopts self-study approach and has been written in student-friendly manner. With a blend of conceptual learning and problem-solving approach, it offers in-depth understanding of the basic mathematical and statistical tools. #introductiontostatistics


Chapter X of Companies Act 2013

Chapter X of Companies Act 2013 The company shall place the matter relating to such appointment for ratification by members at every annual general meeting. ... Under the Act, the provisions for rotation of auditors in the listed Company & certain other class of Companies, have been provided for. #chapterxofcompaniesact2013


Relevant sections under the Companies Act, 2013 dealing with fraud and false statements

Relevant sections under the Companies Act, 2013 dealing with fraud and false statements The new parent corporate law “The Companies Act 2013” is mostly ... I am limiting my write-up to the provisions to the Act, and I request the readers to refer relevant rules, if any, before ... in the 2013 Act is the Section 447 dealing with “Punishment for fraud”. ... Section 448


What is Corporate Image

What is Corporate Image A corporate identity or corporate image is the manner in which a corporation, firm or business enterprise presents itself to the public. The corporate identity is typically visualized by branding and with the use of trademarks, but it can also include things like product design, advertising, public relations etc #WhatisCorporateImage


What is Energy Audit

What is Energy Audit An energy audit is an inspection survey and an analysis of energy flows for energy conservation in a building. It may include a process or system to reduce the amount of energy input into the system without negatively affecting the output. #whatisenergyaudit