I call formatting a necessary evil in Excel. It can easily take as long as the analysis itself — but the nice thing is that good formatting makes for better, quicker data analysis.
Keep the Ctrl+1 shortcut handy when formatting your data. It will launch the Format Cells menu from which you can re-format selected cells.
Every keyboard shortcut saves a second or two vs. using the mouse. Think of this time-savings spread over weeks and months and it’s significant! Wonderful!