Excel for the Web: Formatting Data

Expected Duration
Lesson Objectives
Course Number
Expertise Level


Excel for the Web makes it easier to enhance the presentation of your worksheets.

Discover how you can customize your font options, align data, and use colors. If you are working with large amounts of data, it will be useful to know how to resize rows and columns, as well as set borders.

In this course you will also learn how to create table and customize them with the formatting style options to improve the presentation of your data.

Expected Duration (hours)

Lesson Objectives

Excel for the Web: Formatting Data

  • apply data formats to a data range
  • use font format options in a spreadsheet
  • insert, customize, and delete borders
  • apply font and background colors
  • use conditional formatting to highlight data
  • transfer format styles from a worksheet to another
  • insert and delete columns or rows
  • resize columns and rows in a spreadsheet
  • convert a data range into a table and edits its contents
  • change the appearance of a table with the formatting styles
  • Course Number:

    Expertise Level