THE BEST

 XCOPY  with slash XCOPY source [destination] [/A | /M] [/D[:date]] [/P] [/S [/E]] [/V] [/W]                            [/C] [/I] [/-I] [/Q] [/F] [/L] [/G] [/H] [/R] [/T]                            [/U] [/K] [/N] [/O] [/X] [/Y] [/-Y] [/Z] [/B] [/J]                            [/EXCLUDE:file1[+file2][+file3]...] [/COMPRESS]   source       Specifies the file(s) to copy.   destination  Specifies the location and/or name of new files.   /A           Copies only files with the archive attribute set,                doesn't change the attribute.   /M           Copies only files with the archive attribute set,        ...

  The   SUM   function adds values. You can add individual values, cell references or ranges or a mix of all three. For example: =SUM(A2:A10)  Adds the values in cells A2:10. =SUM(A2:A10, C2:C10)  Adds the values in cells A2:10, as well as cells C2:C10. Syntax: SUM(number1,[number2],...) Argument name Description number1     Required The first number you want to add. The number can be like 4, a cell reference like B6, or a cell range like B2:B8. number2-255     Optional This is the second number you want to add. You can specify up to 255 numbers in this way. Best Practices with SUM This section will discuss some best practices for working with the SUM function. Much of this can be applied to working with other functions as well. The =1+2 or =A+B Method – While you can enter =1+2+3 or =A1+B1+C2 and get fully accurate results, these methods are error prone for several reasons: Typos  – Imagine trying to enter more and/or much lar...

  Use VLOOKUP when you need to find things in a table or range by row. Select a cell. Type =VLOOKUP( and then select the value to lookup. Type a comma (,) and select the range or table to look for the value. Type a comma (,) and the number of the column where the lookup value is located. Type ,FALSE) to find an exact match. Press Enter. The formula for the video example is as follows: =VLOOKUP(A7, A2:B5, 2, FALSE). In its simplest form, the VLOOKUP function says: =VLOOKUP(lookup value, range containing the lookup value, the column number in the range containing the return value, optionally specify TRUE for approximate match or FALSE for an exact match).

  Use the  XLOOKUP  function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on. Syntax The XLOOKUP function searches a range or an array, and then returns the item corresponding to the first match it finds. If no match exists, then XLOOKUP can return the closest (approximate) match.  =XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])  Argument Description lookup_value Required* The value to search for *If omitted, XLOOKUP returns blank cells it finds in  lookup_array .    lookup_array Required The array or range to search return_array Required The array or ran...

  If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, click   AutoSum   on the   Home   tab, press   Enter , and you’re done. When you click  AutoSum , Excel automatically enters a formula (that uses the SUM function) to sum the numbers. Here’s an example. To add the January numbers in this Entertainment budget, select cell B7, the cell immediately below the column of numbers. Then click  AutoSum . A formula appears in cell B7, and Excel highlights the cells you’re totaling. Press Enter to display the result (95.94) in cell B7. You can also see the formula in the formula bar at the top of the Excel window. Notes:  To sum a column of numbers, select the cell immediately below the last number in the column. To sum a row of numbers, select the cell immediately to the right. AutoSum  is in two locations:  Home  >  AutoSum , and  Formulas ...