Most Commonly Used Excel Functions

Here, I have mentioned some of the Excel functions which are commonly used in the organizations and in our day to day work.

1.SUM: To get the total of a group of cells.

2. SUM IF: To get the totals with some criteria or condition (Ex- from a given list of products and their sales volume you want the total of one specific product)


3.SUM IFS: To get the totals with more than one criteria. (Ex-In the previous example let add one more criterion, we want to check the sales of a particular product in particular month.)








4. SUM PRODUCT: To get the sum by multiplying two or more sets of arrays.
     














5. IF ERROR: To show the alternate results in case of formula error. Generally clubbed with some other formula to show the alternate results.

6. V lookup: To find the data in the large datasheet by using one unique field. This is the most commonly used excel function. (Ex-Suppose in one sheet we have Material code and quantity and other sheets their cost, here material code is the unique field)















7.Index: To get the value at a given position in a specific range. Index function mostly used to Match function where the match function used to find the location.
8.Index Match: In Index function, we have to give the row number and column number. Using a match we can give the criteria to get the value.



Comments

Post a Comment

Popular posts from this blog

FINANCIAL PLANNING & ANALYSIS Part - 1

Image
Financial Planning and Analysis is carried out to ascertain the financial strength and weakness of an enterprise. The main tools are Ratio Analysis and Cash flow and Funds Flow analysis. Ratio Analysis: Ratio Analysis is the comparison of different numbers from the balance sheet, Income Statement and Cash Flow statement against the figures of previous years, other companies, the industry or even the economy in general for the purpose of financial analysis. Ratio Analysis can be classified into four broad categories Liquidity Ratio: It derives the liquidity or short term solvency means ability of the business to pay its short term liabilities. Leverage Ratio: This is also known as Capital Structure. This may be defined as the ratio which measures the long term stability and structure of the firm. This can be further derived in two parts known as: (I)             Capital Structure Ratios (II)  ...
Read more

IND AS 41 : AGRICULTURE

Image
Accounting treatment for Biological assets are given in the Ind As -41. Previously There are no standards are given for the agricultural sectors in India therefore Ind As 41 is derived for proper treatment of the biological Assets and transactions related to the sectors. First lets understand, what is biological Assets? ·       Living Plant & living Animals are called as biological Assets. Types of biological Assets: Bearer Plants: Bearer produces for more than one year. For eg. All fruits Bearing Plants. It is derived in Ind As 16- PPE as self-constructed Assets Consumable Plants: Directly usable in ply or lumber (Furniture and Fittings). Consumable Plant and consumable Animals are derived in this standard which Ind As 41. Agriculture: Management of biological transformation of biological assets. Transformation in the form of Quality and Quantity. Quality: Change in Nutrients level Quantity: Change in Weight and Structure...
Read more