Excel: Exact function
https://www.youtube.com/watch?v=_Fo3nEwX7HQ
Posts
Excel Basics
https://www.youtube.com/watch?v=KzXn0JJTTsI Row is a horizontal stack of cells and labelled by numbers ex row 1, row 2 and so on. Column is a vertical stack of cells and labelled by alphabets Column A, Column B and so on. Shortcut Copy Ctrl C Cut Ctrl X Paste Ctrl V Undo Ctrl Z
Excel trick to jump from worksheet to worksheet
https://www.youtube.com/watch?v=ZzOvUIgq7wk By pressing Ctrl Page up and Page down on your keyboard, you can move from one worksheet to another wokrsheet,
Create Number sequence using Excel
https://www.youtube.com/watch?v=G0VYpbYu4hk Create number sequence in Excel Select the first cell in the range that you want to fill. Type the starting value for the series and next values in the next cell to establish pattern of sequence. Note: For example, if you want the series 2, 4, 6, 8..., type 2 and 4 in the first two cells. Select the cells that contain the first two values. Drag the fill handle across the range that you want to fill. Note: To fill in increasing order, drag down or to the right. To fill in decreasing order, drag up or to the left.
Excel: Find duplicate values
https://www.youtube.com/watch?v=RO53GaLi2pE&feature=youtu.be Find duplicate values in excel using conditional formatting and you can use any color combination you want to identify duplicate values. You can apply conditional formatting to selected cells or to the entire worksheet. Formatting can be cleared by clicking on conditional formatting and clear rules.
Excel convert text to lower case
https://www.youtube.com/watch?v=AltQw4o_qQA&feature=youtu.be lower(text) function converts text to lower case.
Excel: Convert text to upper case
https://www.youtube.com/watch?v=mLcGLdSXEF8 =upper(text) converts text to upper case. All the letters in the word are converted to capital letters.
Excel: Convert text to proper case
https://www.youtube.com/watch?v=6Eipo7oVeqk&feature=share Formula to convert text to proper case =proper(text) Proper case converts first letter into upper case and rest of the letters to lower case for every word.
Excel: Min and Max
[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 ...
Excel: Split Text using text to columns wizard
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...
Excel: CountIFS
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...