Free EXCEL Tutorial for Beginners

Introduction to Microsoft Excel What is Microsoft Excel? Microsoft Excel is a spreadsheet program used to analyze data and record number and text. In Microsoft Excel we can use many features like calculations, pivot tables, graphs, automation by macros etc. in Excel columns and rows makes a table. Columns are align it right to left with A,B,C names, and  rows are align in Up to Down in numbers. where column and row meet together is called cell. The cell represent the column and the number together. Where you can get Microsoft Excel? There are number of ways in which you can get Microsoft Excel. You can buy it from a cybercafé or computer shop . Microsoft Excel is part of the Microsoft Office. or you can download it from the Microsoft website and have to purchase it before use. In this Microsoft Excel tutorial, we are going to cover the following topics about MS Excel. How to Open Microsoft Excel? Understanding the Ribbon Understanding the worksheet Customization Microsoft Exce...

VLOOKUP Check below example and try to use in excel in real time for better understanding Blue text start with "=" is the formula we used VLOOKUP FORMULA   What Does It Do ? This function scans down the row headings at the side of a table to find a specified item. When the item is found, it then scans across to pick a cell entry. Syntax =VLOOKUP(ItemToFind,RangeToLookIn,ColumnToPickFrom,SortedOrUnsorted) The ItemToFind is a single item specified by the user. The RangeToLookIn is the range of data with the row headings at the left hand side. The ColumnToPickFrom is how far across the table the function should look to pick from. The Sorted/Unsorted is whether the column headings are sorted. TRUE for yes, FALSE for no. Formatting The result is shown as a number. Example 1 This table is used to find a value based on a specified name and month. The =VLOOKUP() is used to scan down to find the name. The problem arises when we need to scan across to find the mon...

    YEAR 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 ? This function extracts the year number from a date. Syntax =YEAR(Date) Formatting The result is shown as a number. "> If You Want free Stuffs or Products check our   For More Offers  SUBSCRIBE US    To Support US  Donate Now

UPPER 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 ? This function converts all characters in a piece of text to upper case. Syntax = UPPER(TextToConvert) 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

   TRIM Check below example and try to use in excel in real time for better understanding Blue text start with "=" is the formula we used TRIM FORMULA What Does It Do ? This function removes unwanted spaces from a piece of text. The spaces before and after the text will be removed completely. Multiple spaces within the text will be trimmed to a single space Syntax =TRIM(TextToTrim) 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

  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).