{"id":78,"date":"2024-04-22T04:52:43","date_gmt":"2024-04-22T04:52:43","guid":{"rendered":"https:\/\/myallcodes.in\/?page_id=78"},"modified":"2024-06-11T16:17:04","modified_gmt":"2024-06-11T16:17:04","slug":"excel-formulas","status":"publish","type":"page","link":"https:\/\/myallcodes.in\/index.php\/excel-formulas\/","title":{"rendered":"Excel Formula’s"},"content":{"rendered":"\n

Excel formula to calculate the Days, Hours, Min and sec between two cells which are having data in date format<\/h2>\n\n\n\n
\n

=INT(B2-A2)&” Days “&HOUR(MOD(B2-A2,1))&” Hour “&MINUTE(MOD(B2-A2,1))&” Minutes”<\/p>\n<\/blockquote>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/h2>\n\n\n\n

Excel formula to sum values in a range that meet specific criteria<\/a><\/h2>\n\n\n\n

In that case we can use the formula \u201cSumif\u201d Let\u2019s take an example to understand it, If I am having salesman names in column \u201cA\u201d and sales value of that salesman in column \u201cB\u201d then i can use this formula to get the total sales of each salesman.<\/p>\n\n\n\n

\n

=SUMIF(A:A,\u201dSalesman Name\u201d,B:B)<\/em><\/p>\n\n\n\n

\"\"<\/figure>\n<\/blockquote>\n\n\n\n

<\/p>\n\n\n\n

# What is Microsoft Excel :<\/h2>\n\n\n\n

Excel is a powerful tool to store our data and get the desired information using its inbuilt formula\u2019s.<\/p>\n\n\n\n

Let\u2019s start the work on Excel as a beginner and will finish it by an advance excel user.<\/p>\n\n\n\n

Best of Luck..<\/p>\n\n\n\n

    \n
  1. First we need to install the Microsoft office from the official Microsoft website \u2013 https:\/\/www.microsoft.com\/en-in\/download\/office.aspx<\/a><\/li>\n\n\n\n
  2. These days Microsoft office is called Microsoft 365 which facilitates us with cloud solution also.<\/li>\n\n\n\n
  3. After sign up we can use the cloud version of Microsoft 365 and can download the offline setup also.<\/li>\n\n\n\n
  4. After installation of Office setup we can use the Excel.<\/li>\n<\/ol>\n\n\n\n