You know how powerful Excel’s Fill Down “Control -D” command is? The new version of Office has something that practically reads your mind: Flash Fill.
With Flash Fill Excel sees what you are doing and does the rest of it for you.
For example, say you are changing the formatting of a list of people’s names from spread across two columns (first name, last name) into a single column. When you type the second reformatted name, Excel displays the whole list, reformatted. Just click to accept it.