Finance and Accounts

Ind AS is made and derived in view with IFRS standards. So here I am providing the complete list of the Ind AS and respective IFRS. IFRS and Ind AS IFRS IND AS Description IAS 1 Ind AS 1 Presentation Of Financial Statement IAS 2 Ind AS 2 Inventory IAS 7 Ind As 7 Statement of cash flows IAS 8 Ind AS 8 Accounting Policies, Changes in Accounting estimates and errors IAS 10 Ind AS 10 Events after the reporting period IAS 12 Ind AS 12 Income Tax IAS 16 Ind AS 16 Property, Plant, and Equipment IAS 19 Ind AS 19 Employee Benefit IAS 20 Ind AS 20 Accounting for Government Grants and Disclosure of Govt. Assistance IAS 21 Ind AS 21 The effect of changes in foreign exchange rates IAS 23 Ind AS 23 Borrowing costs IAS 24 Ind AS 24 Related Party Disclosure

Excel Shortcuts: Here are some excel shortcut I used for my everyday works. 1. Ctrl+PageUp/PageDown : To move through various pages within the excel sheet. 2. Ctrl+(Plus): To Insert new line(row/column) in excel sheet.(select the entire row/column if you want to insert a new row or column) 3. Ctrl+(Minus) : To delete lines(row/column) in excel sheet.(first, select the row/column) 4. Ctrl+(arrows) : To move to the last cell value(left/right/up/down) 5. Shift+(F11) : To add a new sheet/tabs in excel 6. Ctrl+Shift+(L) : To put the filter in the excel sheet (same shortcut press again to remove the filter) 7. Alt+ (Equal to”=”) : To get the total of a column(If the filter is there it will calculate “Subtotal” or else “Sum”) 8. Alt + AEF : To convert Text numbers into number 9. Alt+HOI : To Auto fit the column width in the excel sheet. 10. Alt+ NVT - To create Pivot in the excel ( It will ask for the table range for the Pivot) 11. Alt+ JTID -

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