Microsoft office Excel

  MAX function in Excel: formula examples to find and highlight highest value Excel MAX function The MAX function in Excel returns the highest value in a set of data that you specify. How to make a MAX formula in Excel To create a MAX formula in its simplest from, you can type numbers directly in the list of arguments, like this: =MAX(1, 2, 3) In practice, it's quite a rare case when numbers are "hardcoded". For the most part, you will deal with ranges and cells. The fastest way to build a Max formula that finds the highest value in a range is this: In a cell, type  =MAX( Select a range of numbers using the mouse. Type the closing parenthesis. Press the  Enter  key to complete your formula. For example, to work out the largest value in the range A1:A6, the formula would go as follows: =MAX(A1:A6) If your numbers are in a  contiguous  row or column (like in this example), you can get Excel to make a Max formula for you automatically. Here's how: 1- Select th...

 MS Excel: How to use the SUMIF Function (WS) This Excel tutorial explains how to use the Excel SUMIF function with syntax and examples. Description The SUMIF function is a worksheet function that adds all numbers in a range of cells based on one criteria (for example, is equal to 2000). The SUMIF function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the SUMIF function can be entered as part of a formula in a cell of a worksheet. To add numbers in a range based on multiple criteria, try the SUMIFS function. Syntax The syntax for the SUMIF function in Microsoft Excel is: SUMIF( range, criteria, [sum_range] ) Parameters or Arguments range The range of cells that you want to apply the criteria against. criteria The criteria used to determine which cells to add. sum_range Optional. It is the range of cells to sum together. If this parameter is omitted, it uses range as the sum...

What is VLOOKUP?   VLOOKUP stands for ‘Vertical Lookup’. It is a function that makes Excel search for a certain value in a column (the so called ‘table array’), in order to return a value from a different column in the same row. This article will teach you how to use the VLOOKUP function. A VLOOKUP function exists of 4 components:  1. The value you want to look  up.  2. The range in which you want to find the value and the return value,  3. The number of the column within your defined range, that contains the         return value.  4. 0 or False for an exact match with the value your are looking for; 1 or True an approximate match. 

  HLOOKUP in Excel – With Examples HLOOKUP function  in Excel is a sibling of the VLOOKUP function. The  H  in the HLOOKUP stands for “Horizontal” and hence it is often called Horizontal Lookup. HLOOKUP is a very useful function for creating horizontal lookups, but as most of the tables that we deal with are vertical hence this function is not very popular. The task of the HLOOKUP function is to search for a value in the topmost row of a table, and then return a corresponding value in the same column from a row you specify. Definition and Syntax of HLOOKUP Function in Excel Microsoft Excel defines HLOOKUP as a function that “looks for a value in the top row of a table or array of values and returns the value in the same column from a row you specify”. Syntax of Excel HLOOKUP The syntax of the HLOOKUP function in Excel is as follows: =HLOOKUP(lookup_value,table_array,row_index_number,range_lookup) How to Use HLOOKUP in Excel Now, let’s understand how to use this ...

How to find minimum figure. =Min(select the range) then press enter.

  Advanced filtering To filter using search: Searching  for data is a convenient alternative to checking or unchecking data from the list. You can search for data that contains an exact phrase, number, date, or simple fragment. For example, searching for the exact phrase  Saris X-10 Laptop  will display only Saris X-10 laptops. Searching for the word  Saris,  however, will display Saris X-10 laptops and any other Saris equipment, including projectors and digital cameras. 1- From the  Data  tab, click the  Filter  command. 2- Click the  drop-down arrow  in the column you want to filter. In this example, we'll filter the Equipment Detail column to view only a specific brand. 3- Enter the data you want to view in the  Search  box. We'll enter the word  Saris  to find all Saris brand equipment. The search results will appear automatically. 4- Check  the boxes next to the data you want to display. We'll disp...