Free EXCEL Tutorial for Beginners

  TODAY Check below example and try to use in excel in real time for better understanding Blue text start with "=" is the formula we used   What Does It Do ? Use this to show the current date. Syntax  =TODAY() Formatting The result will normally be displayed using the DD-MMM-YY format.   Example 1 The following example shows how the Today function is used to calculate the number of days since a particular day. Note that the result is actually the number of days before todays date. To calculate  a result which includes the current date an extra 1 will need to be added.   Example 2 The following example shows the number of days from today until the year 2000.

  SUMPRODUCT Check below example and try to use in excel in real time for better understanding Blue text start with "=" is the formula we used SUMPRODUCT FORMULA What Does It Do ? This function uses at least two columns of values. The values in the first column are multiplied with the corresponding value in the second column. The total of all the values is the result of the calculation. Syntax =SUMPRODUCT(Range1, Range, Range3 through to Range30) Formatting No special formatting is needed.   Example The following table was used by a drinks merchant to keep track of stock. The merchant needed to know the total purchase value of the stock, and the potential value of the stock when it is sold, taking into account the markup percentage. The =SUMPRODUCT() function is used to multiply the Cases In Stock with the Case Price to  calculate what the merchant spent in buying the stock. The =SUMPRODUCT() function is used to multiply the Cases In Stock wit...

   SUMIF Check below example and try to use in excel in real time for better understanding Blue text start with "=" is the formula we used SUMIF FORMULA   What Does It Do ? This function adds the value of items which match criteria set by the user. Syntax =SUMIF(RangeOfThingsToBeExamined,CriteriaToBeMatched,RangeOfValuesToTotal) '=SUMIF(C4:C12,"Brakes",E4:E12)           This examines the names of products in C4:C12. It then identifies the entries for Brakes.   It then totals the respective figures in E4:E12  =SUMIF(E4:E12,">=100") This examines the values in E4:E12. If the value is >=100 the value is added to the total. Formatting No special formatting is needed. BACK TO HOME PAGE If You Want free Stuffs or Products check our   For More Offers  SUBSCRIBE US    https://excelknowlegde.blogspot.com To Support US  Donate Now

   SUM Check below example and try to use in excel in real time for better understanding Blue text start with "=" is the formula we used SUM FORMULA   What Does It Do ? This function creates a total from a list of numbers. It can be used either horizontally or vertically. The numbers can be in single cells, ranges are from other functions. Syntax = =SUM(Range1,Range2,Range3... through to Range30). Formatting No special formatting is needed.   Note Many people use the =SUM() function incorrectly. This example shows how the SUM has been combined with plus + symbols. The formula is actually doing more work than needed. It should have been entered as either =C48+C49+C50 or =SUM(C48:C50).

    SUBSTITUTE Check below example and try to use in excel in real time for better understanding Blue text start with "=" is the formula we used SUBSTITUE FORMULA   What Does It Do ? This function replaces a specified piece of text with a different piece of text. It can either replace all occurrences of the text, or a specific instance. The function is case sensitive. Syntax =SUBSTITUTE(OriginalText,TextToRemove,TextToInsert,InstanceToUse) The InstanceToUse is optional, if it is omitted all instances will be substituted. Formatting No special formatting is needed.   NOTE To cope with upper or lower case in the substitution you can use other text functions  such as =UPPER(), =LOWER() or =PROPER() to ensure that the substitution will take place. Table 1 shows how differing text cases alter the result of the substitution. Table 1 TABLE 1 Table 2 shows how the =PROPER() function has been used to take account of the mixed cases. Table 2 TABLE ...

   SMALL Check below example and try to use in excel in real time for better understanding Blue text start with "=" is the formula we used SMALL FORMULA   What Does It Do ? This function examines a list of values and picks the value at a user specified position in the list. Syntax =SMALL(ListOfNumbersToExamine,PositionToPickFrom) Formatting No special formatting is needed.   Example The following table was used to calculate the bottom 3 sales figures between Jan, Feb and Mar. Note Another way to find the Highest and Lowest values would have been to use  the =MAX() and =MIN() functions.

  ROUNDUP Check below example and try to use in excel in real time for better understanding Blue text start with "=" is the formula we used ROUNDUP FORMULA   What Does It Do ? This function rounds a number up to a specified amount of decimal places. If 0 is used the number is rounded up to the nearest whole number. If a negative amount of rounding is used the figures to the left of the decimal point are rounded. Syntax = =ROUNDUPNumberToRound,DecimalPlacesToUse) Formatting No special formatting is needed.