Want to give your text some "style" or special formats to spruce up the appearance of your text in Excel 2007? After you have applied numerous formats, not limited to fancy formats from found on the Home Tab, to Styles group and clicking on the Cell Styles button, you can take that collage of formats applied to your data i.e. text or numbers and save that as a new style! To save your style, select the cell that you've applied numerous styles to including bold, color, font style, size etc. and on Home Tab, Styles group and click the Cells Styles button and click New Cell Style. In the Cell Styles window you can modify your formatted selection and name your style tool.

Purchase the training video and you can see this in action for yourself!