Excel Office 365 (Windows): Formatting Data

Expected Duration
Lesson Objectives
Course Number
Expertise Level


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.

Expected Duration (hours)

Lesson Objectives

Excel Office 365 (Windows): Formatting Data

  • Setting your data type
  • Formatting your data
  • Aligning your data
  • Using colors
  • Changing your cell style
  • Using document themes
  • Using formulas to modify your text case
  • Creating a title
  • Formatting a title
  • Creating a table
  • Resizing columns & rows
  • Inserting columns & rows
  • Inserting borders
  • Transferring format styles
  • Course Number:

    Expertise Level