Microsoft Excel is a very powerful tool that can be even more powerful and faster by using Excel shortcuts. Using Excel keyboard shortcuts allows you to edit Excel worksheets quickly, faster than just using a mouse.
Learn how to extract last name in Excel in a few simple steps. A formula or text to columns can be used to extract last names in Excel.
The Excel OR function tests whether any arguments are TRUE, and returns TRUE if at least one argument is TRUE. If all arguments are FALSE the OR function will return FALSE.
Learn how to find and remove duplicates in Excel easily. Data may contain duplicate values which may be useful to find and remove.
The Excel AND function tests whether all arguments are TRUE, and returns TRUE if all arguments are TRUE, or FALSE if any arguments are FALSE.
The Excel SUBSTITUTE function replaces existing test with new text in a text string. This function is useful for inserting text and/or correcting misspellings in Excel.
The Excel REPLACE function replaces part of a text string with a different text string.
The Excel FIND function returns a numerical value of the position of a text string within another text string.
The Excel SUMPRODUCT function multiplies an array by another array(s) and sums the results.
The Excel ISERR function determines whether a value is an error and returns TRUE if an error or FALSE if not an error.
The Excel ISERROR function determines whether a value is an error and returns TRUE if an error or FALSE if not an error.