This quick video shows you how powerful the Ctrl + E combination can be in Excel with some examples.
Ctrl + E is a keyboard shortcut for flash fill that recognizes patterns in adjacent columns and fills the current column. This will not replace the need for all formulas but it can help with common tasks we perform in Excel.