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.
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