Learn with Manish Shori

  Introduction The Excel CHOOSE function returns a value from a list using a given position or index. CHOOSE Function For example, CHOOSE(2,"red","blue","green") returns "blue", because blue is the 2nd value listed after the index number. The values provided to CHOOSE can include references. Purpose Get a value from a list based on position Return value The value at the given position. Syntax =CHOOSE (index_num, value1, [value2], ...) Arguments ·      index_num - The value to choose. A number between 1 and 254 ·     value1 - The first value from which to choose ·     value2 - [optional] The second value from which to choose Usage notes The Excel CHOOSE function returns a value from a list using a given position or index. The values provided to CHOOSE can include references. However, CHOOSE will not retrieve an item from inside range or array constant provided as a value. Choose can handle up to 254 values but INDEX o

  Introduction Deleting a company in Tally is as simple as deleting a voucher but still many people are confused or they do not know how to delete a company in Tally because there is no specific option in Tally to delete a company. So, you can delete a company in Tally but you can’t find the option. You can also say that there is a hidden option. To delete anything you create in Tally, there is one command or option you have to select. That is ALT+D. D for Delete. Whether you create vouchers or you create ledgers or you pass entries, press ALT+D and it will get deleted. The same is the case with the company deletion process. Before you delete a company Deleting a company is as easy as deleting a picture from your phone. But certain important things need to be taken care of before you delete an entire company otherwise you will later regret a lot. Because prevention is better than cure. 1. Don’t delete a company for changing the year There is no need to delete a company for ch

  Summary The Excel MONTH function extracts the month from a given date as number between 1 to 12. You can use the MONTH function to extract a month number from a date into a cell or to feed a month number into another function like the DATE function . Purpose Get month as a number (1-12) from a date Return value A number between 1 and 12. Syntax =MONTH (date) Arguments date - A valid Excel date. Usage notes The MONTH function extracts the month from a given date as number between 1 to 12. For example: =MONTH("23-Aug-2012") à returns 8 =MONTH("11-May-2019") à returns 5 You can use the MONTH function to extract a month number from a date into a cell or to feed a month number into another function like the DATE function. Dates are serial numbers in Excel and begin on January 1, 1900. Dates before 1900 are not supported. To display date values in a human-readable date format, apply the number format of your choice. Date must be a valid Exc

 Introduction Either Business or your personal account you have to carry forward your account to the next year and closed your last year account. You can carry forward your account in a very simple way. In your Balance Sheet you have come to know that before carry forward the account to the next year, I had closed my previous account and now there is no account is showing in the Liabilities side Now, you are ready to carry forward your account to the next year. For this follow these simple steps: 1.    Click on Period button (Right Hand Side of the screen) or just press Alt+F2 from the keyboard to change the year. 2.     This will open the change period window: 3.     Enter the year i.e. a22. 'a' is for April 4.     In the “To” box enter the next year i.e. m23. 'm' for March because the financial year held April 2022 to March 2023. 5.     As soon as you press enter, the year has been changed in the left top side of the screen: 6.     Now have a look at the Balance

  Excel DATEDIF Function Introduction The Excel DATEDIF function returns the difference between two date values in years, months or days. The DATEDIF (Dated + if) function is a "compatibility" function that comes from Lotus 1-2-3. For reasons unknown it is only documented in Excel 2000 but you can use it in your formulas in all Excel versions since that time. Excel won't help you fill out the arguments for DATEDIF like other functions but it will work when configured correctly. Purpose Get days, months or years between two dates. Return value A number representing time between two dates Syntax =DATEDIF (start_date, end_date, unit) “Y” means Year. But if we mention here “M” then it gives the answer. “M” for Month If we want to check the Days between two dates then the result will be “D” means Days. Arguments ·     start_date - Start date in Excel date serial number format. ·     end_date - End date in Excel date serial number format. ·     unit - The