Excel 2016: Formatting Data

Expected Duration
Lesson Objectives
Course Number
Expertise Level


Formatting data makes it 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 2016 to change data presentation.

Expected Duration (hours)

Lesson Objectives

Excel 2016: 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