Learn with Manish Shori

  Introduction The MOD function is categorized under Excel Math and Trigonometry functions. The function helps find a remainder after a number (dividend) is divided by another number (divisor). As a financial analyst, the function is useful when we need to process every n th value. For example, if our data comprises several columns of numbers, we can use MOD to sum every n th column. The Excel MOD function returns the remainder of two numbers after division. For example, MOD(10,3) = 1. The result of MOD carries the same sign as the divisor. Purpose Get the remainder from division Return value The remainder Syntax =MOD (number, divisor) Arguments ·    number - The number to be divided. ·   divisor - The number to divide with. Usage notes Use the MOD function to get a reminder after division. For Example, MOD (3,2) returns 1, because 2 goes into 3 once, with a remainder of 1. Examples, Here are a few examples of the MOD function with hardcoded v...

  Introduction The Excel WEEKDAY function takes a date and returns a number between 1-7 representing the day of week. By default WEEKDAY returns 1 for Sunday and 7 for Saturday. You can use the WEEKDAY function inside other formulas to check the day of week and react as needed. Purpose Get the day of the week as a number Return value A number between 0 and 7 Syntax =WEEKDAY (serial_number, [return_type]) Arguments ·       serial_number - The date for which you want to get the day of week. ·     return_type - [optional] A number representing day of week mapping scheme. Default is 1. Usage notes WEEKDAY accepts a date and returns a number between 1-7 representing the day of week for that date. By default WEEKDAY returns 1 for Sunday and 7 for Saturday as shown in the table below: Result Meaning 1 Sunday 2 Monday 3 Tuesday 4 ...

  Introduction TDS is Tax Deducted at Source. TDS is the amount of tax which is deducted by the employer from the taxpayer and is deposited to the Income Tax Department on behalf of him/her. The TDS rates are set on the basis of the age and income of different individuals. TDS or Tax Deducted at Source is a specific amount that is reduced when a certain payment like salary, commission, rent, interest, professional fees etc. is made. The person who makes the payment deducts tax at the source while the person who receives a payment/income has the liability to pay tax. It lowers tax evasion because the tax will be collected at the time of making a payment. Note: TDS is nothing but advance payment of income tax. When the TDS applied When you get your salary, TDS is deducted from your salary. Let’s for simplicity assume that the TDS on your salary is ₹20,000 and you are applying for the refund of the TDS because your income i.e. your salary is under the base limit for income ta...

 Introduction Remove Duplicates in Excel is used for removing the duplicate cells of one or multiple columns. This is very easy to implement. To remove duplicates from any column, first select the one or more columns from where we need to remove duplicate values then from the Data menu tab, select Remove Duplicate under data tools. We will get the window for the same where we can select or unselect the columns from where we want to remove duplicate values. How to remove Duplicate values from the table ·    Open the table in Excel sheet ·     Select the column/columns from where you want to delete the duplicate values ·      From the Excel, select Data menu and then select Remove Duplicates from the Data Tools ·     A new Dialog box named Remove Duplicates will open ·          Here on the top, heading regarding My data has headers has been displayed. If you want to keep first row as a heade...