Pressing 'Ctrl + T' in Excel transforms the selected range of data into a formal Excel table. This not only visually organizes your data into a structured format but also automatically applies features such as filtering, sorting, and the use of structured references for formulas. When you enter a formula in one cell of a column inside a table, Excel can automatically replicate the formula to all other cells in that column, maintaining relative references.