Formatting Data

Formatting data makes the data easier to see and work with. Discover how you can align data, use colors, and themes, resize rows and columns, and insert tables and borders in Excel to change the presentation of data in this 14-video course. Key concepts covered here include how to apply data formats to a data range; how to use font format options in a spreadsheet; and how to insert, customize, and delete borders. Next, you will learn how to add color to your spreadsheets and to apply font and background colors; how to use conditional formatting tools to highlight and apply the rules to different data; and how to transfer format styles from one worksheet to another. Learn how to insert and delete columns or rows, including multiple columns and rows in a single action; how to resize columns and rows in a spreadsheet; and how to convert a data range into a table and edit its contents. Finally, learn how to change the appearance of a table with formatting tools and table styles.