LaxmiAcademy

https://www.youtube.com/watch?v=iB3x256a8i8

https://www.youtube.com/watch?v=wTsqChrkgn4

https://www.youtube.com/watch?v=v83FvqVNfYQ Tips Less than sign is like a tilted L . Once you identify less than sign then other sign is greater than Inequality signs are like animal mouth. Animal opens the mouth towards bigger number.

https://www.youtube.com/watch?v=vYtpiIUkQjw

https://www.youtube.com/watch?v=sujLcqmyA20

https://www.youtube.com/watch?v=uMUhaWIPXYY To remove hyperlinks from word document select all text using CTRL A and then CTRL SHIFT F9 will remove hyperlinks.

[embedyt] http://www.youtube.com/watch?v=cPn1gGjD4ZM[/embedyt] Max function returns the largest value in a set of values. Syntax MAX(number1, [number2], ...) The MAX function syntax has the following arguments: Number1, number2, ...     Number1 is required, subsequent numbers are optional. Note: If the arguments contain no numbers, MAX returns 0 (zero). Arguments that are error values or text that cannot be translated into numbers cause errors. If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the MAXA  function. MIN functions returns the smallest number in a set of values. Syntax MIN(number1, [number2], ...) The MIN function syntax has the following arguments: Number1, number2, ...     Number1 is required, subsequent numbers are optional. Note: If an argument is an array or reference, only numbers in that array or reference are used. Empty cells, logical values, or text in the array or reference ...

https://www.youtube.com/watch?v=QBaSY8hhThg Depending on your data, you can split the cell content based on a delimiter, such as a space, semicolon, tab, comma, etc or based on a specific column break location within your data. If the delimiters used by you is not an option in the wizard then user other and type the delimiter. Select the range of data that you want to convert, make sure you dont select headings. On the Data tab, in the Data Tools group, click Text to Columns . In Step 1 of the Convert Text to Columns Wizard, click Delimited , and then click Next . In Step 2, select the  delimiter which applies to you. Click Next . In Step 3, click a column in the Data preview box, and then click Text under Column data format .Repeat this step for each column in the Data preview box. If you want to insert the separated content into the columns next to the data you have , click the icon to the right of the Destination box, and then select the cell next to th...

https://www.youtube.com/watch?v=dYkLGYHNn1o The COUNTIFS function applies criteria to cells across multiple ranges and counts the number of times all criteria are met. Syntax COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…) The COUNTIFS function syntax has the following arguments: criteria_range1     Mandatory. The first range in which to evaluate the associated criteria. criteria1     Mandatory. The criteria in the form of a number, expression, cell reference, or text that define which cells will be counted. criteria_range2, criteria2, ...     Optional. Additional ranges and their associated criteria. Up to 127 range/criteria pairs are allowed. Note:  Each additional range must have the same number of rows and columns as the criteria_range1 argument. If the criteria argument is a reference to an empty cell, the COUNTIFS function treats the empty cell as a 0 value. You can use the wildcard characters— the question mark (?) and asterisk (*) — in crit...

https://www.youtube.com/watch?v=Bo2mQV-JsX4

https://www.youtube.com/watch?v=CqAIbKzNp3A